MS Database Administration on Premise and Azure Cloud:• Database Administration: Hands on experience in development and review of others TSQL Queries, Stored Procedures, Functions, or statements: Assist in Trouble Shooting any errors found, review syntax per version 200-2017 utilized: Perform Troubleshooting TSQL queries to determine what might be performance issues: Assist Developers in writing TSQL queries for Applications. Good working knowledge of 2019.• Database Administration: Hands on experience in Database Administration: installing, configuring, managing, upgrading, and migrating, monitoring utilizing 3rd Party Monitoring tools or native SQL Tools, and troubleshooting MS SQL Server 2000-2017. Good working knowledge of 2019.• Database Administration: Hands on experience and knowledge in SSRS installing, configuring, managing, migrating SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS) with good knowledge on good knowledge on SQL Server Analysis Services (SSAS) and other Third-Party Reporting tools• Database Administration: Provide updates, maintenance, performance tuning and optimization utilizing native and third-party tools: backups, verification of backups utilizing native and/or third-party tools: troubleshooting utilizing performance monitoring tools, native SQL commands, DMV, and experience, modeling, update current database schemas if necessary, improving data integrity, and improving security: Created Database Administrator Documentation

Providing 7x 24 System Administrator and Database Administrator with following responsibilities: REMOTE Administration during CV19• Perform Database Administration, Architecture and SQL Developer functions on current MS SQL, MySQL, PostgreSQL, AWS Database instances in all environments: As needed Architect new databases, and instances work with Development team for large projects, and architect new database solutions for Tableau {Including Cloud}, SSRS, and SSIS: Utilize SSIS automation skills in development of packages, etc. for all environments: Create and work with Parent company to create automation between Samsung Parent SAP system and Internal customized ERP infrastructure and Application utilizing Win Automation: Provide updates, maintenance, tuning, backups, verification of backups, troubleshooting, modeling, update current database schemas if necessary improving data integrity, and improving security: Create Database Administrator Documentation.• Database Migration: Migrate MySQL database to MS SQL Database: Migrating current MS SQL Database server from one instance to three instances for security purposes: Utilizing MS SQL Server Security Best Practices; Checking Data Integrity, Migrating SSRS Data and Reports, Migrating SSIS and Packages ensuring a tighter security and better auditing capabilities available. . • Performance Management: Databases MySQL and MS SQL utilizing MonYog, and IDERA: Optimizing databases via third party tools or SQL.• AWS Management- Work with developers and users of AWS Cloud and manage accounts and billing: Help develop new Architect plans and ideas for utilization of the AWS Cloud. SEE or ask for RESUME for complete details

• Key point of contact for Operations & Development in resolving critical business issues with reference to Securities Lending (SL) associated Applications, various Batch jobs, and Business continuity planning (BCP) activities, Iview Alerts, Incident Management. • Wrote Sybase and MS SQL Scripts in creating tools to determine root cause, and quickly determine root cause of reported problems.• Wrote Linux scripts in creating tools to determine root cause, filter through logs, and determine root cause of reported problems.

• Implemented upgrades to DELL/EMC2 VMax, VMax3, Symmetric, plus other product lines associated to storage arrays remotely globally working in Windows and Linux environments.• Executed, Validated and Verified Storage configurations, health checks, product solutions, and upgrades solutions to ensure systems fully operational.• Utilized Windows and Linux Skill set to confirm DELL/EMC Storage Array Healthy after upgrade.• Upgraded, Modified, and Verified detailed oriented step by step instructions for Upgrade solutions.

• Utilized SCCM Sys Admin skills to Maintain and Monitoring and patching of all DSHS agency systems for which our Infrastructure team was assigned utilizing SCOM2012/SCCM.• Implemented Windows Sys Administration services in support of SCCM Patching of all DSHS Server systems(750+). • Accurately tracked Windows Servers to ensure at proper approved MS Patch Levels in conformance with policy and procedures.• Technical Support on Database issues and/or Windows Administration issues on Servers reported problems on Virtual VM environments or Physical servers• Wrote MS Windows Power Shell Script and TSQL Script to automate extraction of information from Active Directory and other sources to automate update to CMDB Database used in conjunction with larger Database FEAF being utilized by DSHS. • Create CR via Ticketing process per ITIL procedures Document and close per processes.• Utilized Business Analyst and Project Management-Lead expertise when working with Development team to transition legacy software Database over to new External On Line Application, and Internal third party Applications• DBA Consultation on new project work with Badge security system (EBAS) for DSHS WA State wide utilizing Third party Software, Windows 2012 Operating System, and Microsoft SQL 2012, and database skill set..

• Maintained, scheduled, tracked changes, DBA support for 1.5 Terabyte Statewide child welfare information case management system as well as projects associated to Various Databases in Production, and Non Production environments (Dev, ST, UAT, Pre-Prod).• Day to Day Administration Production OLTP database including User Access, Specific special request permissions, backups, restores, and execution of ad hoc developer queries for each environment (Dev, ST, UAT, Pre-Prod, Prod)• Backup Data Warehouse Administration Production database including Production Replications, replication scripts, user access, specific permissions, and ETL Package implementations, and new releases: Monitored replication process utilizing Replication monitor process utilizing Snapshot and transactional replication methods.• Implemented MS Best Practice Security guidelines and DOD Security Guidelines. • TSQL Code review Peer to Peer for Development Team programmers: Reviewed and approved basic to semi-advanced T-SQL scripts prepared by development team for database changes for major releases(DLL, DML), Emergency HOT fixes, and data fixes during development phases (AGILE), using SVN Tortoise change control software.• Migrated MS SQL Server and databases from Physical to New Virtual environments (Dev, ST, UAT, Pre-Prod, Prod).• 24/7 Database support, and Customer Service support

• Maintained, scheduled, tracked database changes, DBA support, as well as projectsassociated to various third party Databases in Production, and Non Production environments• Day to Day Administration Internal and External Production databases including User Access, Specific special request permissions, backups, restores, and execution of ad hoc developer queries for each environment.• Delivered consultation, analysis, and implemented database migration from Physical to Virtual environment project including database security standard using MS best practice standards: LINUX and UNIX Operating System• Analyzed the databases daily, evaluating connections, intrusions, and bottlenecks utilizing SOLAR WINDS and COMPUWARE product application and network monitoring tools.• Utilized COMPUWARE Automated Testing Tool Test Partner to Test 22+ On Line Applications for Functionality.• Go To Expert Application Testing utilizing Compuware "Test Partner" Daily Application Testing/Monitoring of Production on 22 applications : Created MS VB Code to automate testing, managed daily statistical reports based on test results, and intervals of testing each application which is displayed on DAILY MONITORING screen in view of all of IT department:• Utilized SQL knowledge and expertise to create requested adhoc reports produced by COMPUWARE and/or SOLAR WINDS monitoring tools(MySQL Database).• Managed primary System Administration support for Unix Servers including the installation of patches, managing users, disk space oversight, and software support.• Administrated the Windows System for desktop systems used for application testing overseeing the installation of Windows System for desktop configurations and installation of software

SYSTEM ADMINISTRATION: Primary System Administration support for MS Windows Servers, Exchange Servers, DNS Server, Proxy Server including the installation of service packs, antivirus software, managing users, device drivers, disk drive installation, and space oversight, Active Directory management, VERITAS backup and recovery third party software, network configuration changes for firewall, and MS Windows Shell script software support. Administrated the Windows System for desktop systems used for application, and on-site training courses utilizing knowledge of Windows Operating System Active Directories, and security with reference to Department of Defense standards. TECHNICAL EXPERTISE: Delivered Project Management, consultation, analysis, and solutions for Windows Operating System and Network upgrade in mixed Windows environment while migrating up to MS Windows Server 2003 Operating Systems including hardware changes, IT security changes using Department of Defense standards: Managed all Windows Servers and Windows Desktop migrations, loading server software, loading desktop software, configuration changes: As Web Master created dynamic software solutions for Applications, and MS Access Databases utilized using XML,HTML, PHP, ASP, PERL, CFM, Java, Java Script ,VB Script, VBA programming expertise. ORAL AND WRITTEN COMMUNICATIONS: Go To Project Manager of MS Windows Migration to 2003 Servers, and Windows Desktop upgrade including Project Documentation of 'big picture' diagram, feasibility studies, Scope of Project, and Migration Documented in accordance with DOD standards, and reporting to other Departments answering all Project, Testing, Implementation, setup permissions, commands, and upgrades in addition to providing analysis for new systems, and/or Application changes during migration Project