Sql Server Database Administrator

Johnson Oyemosu

Houston Texas

832-***-****) • ********@*****.***

EXPERIENCED SENIOR MSSQL SERVER DATABASE ADMINISTRATOR MS SQL Server Database Administrator • Mitigated Risk • Process Automation • Created Disaster Recovery Plans Reduced Downtimes • Data Encryption Migrated Servers • Database Management • Cloud Computing • Troubleshooting Ideated Resolutions • Delivered Technical Support • Reconfigured File Locations • Transferred Data Created Optimized Clusters • Database Admin Performance Tuning • Facilitated Automations • Led Database Replication • Tuned Queries • Stored Procedures • Design & Maintenance • Data Migrations & Upgrades Provisioned Databases • Enabled High Availability • Solved Space Issues • Setting Up EC2 and RDS/AWS. Oracle Golden Gate. Amazon CloudWatch and Prometheus. WORK EXPERIENCE

Sonsaffairs Auto Services, TX. USA 2019 - present Sr. SQL Server DBA Administrator

● Provided 24/7 production support and maintenance for SQL Server 2016/ 2014/2012/2008.

● Installed and configured SQL Server 2016 on new servers and worked on data migration from Oracle 11g to MS SQL 2014 server instances.

● Supported and troubleshot very large databases (VLDB) with 500 GB to 3 TB and worked on Active-Active and Active-Passive 2 node Clustering and 3-node clustering.

● Migrated SQL Server databases from 2008 R2 to 2012/2014, 2016 to 2017 and 2019.

● Implemented Always-On HA and worked with 2014 new concepts like Delayed Durability, Partition-Table Parallelism, Data Compression, Table and Index Partitioning, and more.

● Facilitated migrations of Databases from SQL Server 2000/2005 to SQL Server 2008R2/2012 in Production and test Environments and installed and performed maintenance of SQL Servers.

● Utilized good understanding & knowledge of cloud computing architecture, technical design, and implementations including Infrastructure as a Service (IaaS) Platform as a Service (PaaS), etc. DMP

● Deployed Azure IaaS virtual machines and Cloud services into secure VNets and subnets.

● Ensured high availability for IaaS VMs and PaaS role instances for access from other services in the VNet with Azure Internal Load Balancer.

● Performed query tuning and other performance tuning practices to resolve issues and ensure that databases were working at their maximum capacity.

● Created and modified Stored Procedures and Functions to generate reports for data migration using TSQL and worked on Snapshot and Transactional Replication.

● Installed, configured, and maintained MS SQL Failover clustering and configured SQL Server Always-On High Availability to provide server high availability solutions.

● Configured TempDB on SQL Server instances by adding TempDB data files proportional to the number of processor cores and setup file growth parameters.

● Reconfigured the default locations of the data files, log files, and error log files onto the SAN environment for all the servers and developed complex/tune mappings for better performance.

● Utilized tools like SQL Server Agent, SSCM, SMO, Database Tuning Advisor, SQL Server dashboard, SQL Profiler, and Activity Monitor for event monitoring and performance monitoring.

● Implemented data availability solutions like online Restore, Online index Operation, and more.

● Migrate MySQL Database to MSSQL using Microsoft SQL Server migration Assistant.

● Migrated and managed production database from on-prem (MS SQL) to cloud (Azure).

● Excellent experience with Github, Jira, Confluence and Jenkins.

● Migrate SQL Server Database to Amazon RDS using AWS DMS. Also setting up EC2 and RDS Instances

● Support SSIS/SSAS/SSRS implementations.

● Maintain FCC compliance and GITC controls within SQL environments.

● Support several highly active custom application and software development groups in a controlled Dev/Test/Prod/DR. TradeGo integrated services Havertown, PA 2017 - 2019 Sr. SQL Server DBA Administrator

● Directed 24/7 production support, maintenance, and administration of MS SQL Server 2012/2014/2016/ Azure SQL and supported 18 large production Percona servers.

● Supervised all aspects of database administration for SQL Server databases including problem-solving, configuration, and implementation efforts for large and/or complex projects.

● Oversaw maintenance/troubleshooting of applications on Microsoft Cloud infrastructure Azure.

● Created cloud-based ETL and data integration service that allows data-driven workflows and created optimized clusters for Hadoop using HDInsight.

● Migrated and administered production database from on-prem (MS SQL) to cloud (Azure).

● Augmented operations by performing backups, restoring databases, leveraging experience in Point-in- Time Recovery based on company SLA, and running DBCC Check DB statements.

● Maintained all access and security control on both on-prem and cloud environments and worked with Microsoft Azure cloud for multiple clients and customers of General Blue Corporation.

● Deployed Azure IaaS virtual machines and Cloud services into secure VNets and subnets.

● Designed and built cloud service models including Infrastructure-as-a-Service, Platform-as-a-Service, and Software-as-a-Service.

● Restored database backups from cloud to on-prem for a solid recovery reliability and designed VNets and subscriptions to conform to Azure Network Limits.

● Established Azure Virtual Appliances (VMs) to meet security requirements as software-based appliance functions (firewall, WAN optimization and intrusion detections).

● Automated all passwords reset processes using PowerShell scripting.

● Experience with Linux/Unix shell scripting and Oracle Golden Gate (setup and maintenance)

● Data Modeling: ER/Studio: Creating logical and physical data models to graphically represent databases. Greenland Inc services, TX 2015 - 2017

Sr. SQL Server DBA Administrator

● Upgraded the Database from SQL Server 2000 and 2005 to SQL 2008R2 and handled Microsoft Windows Server Administration Windows 2003/2008 /2012.

● Provided Microsoft Windows Desktop Administration /Support/Configuration Windows 95/XP/7 and handled AD Support/Administration for Windows 2003.

● Monitored and updated Backup and Recovery strategy to recover data using business RPO and RTO SLA requirements & executed scripted change requests in accordance with procedures.

● Diagnosed software/hardware problems, responding quickly, clearly, and resourcefully.

● Installed Microsoft Windows Servers as well as Windows Desktop OS.

● Delivered overall configuration and change control management for database components.

● Escalated database issues to appropriate approvers (if applicable).

● Conducted research and collaborated with vendors if necessary for additional patches.

● Improved security via applying SQL Service packs on all environments, supporting Windows monthly security patching activity, and working on monthly refresh tasks and activities.

● Prepared broken mobile devices for repair as well as issued temporary devices for users. EDUCATION

Community college Houston TX 2017

Associate of applied science, computer system networking cybersecurity. University of Ibadan, Ibadan, Nigeria 2011

Bachelor of Science, Information Technology

TECHNOLOGIES & CERTIFICATIONS

Technologies: MSSQL, (OEM), Service Now, Red Gate, Solar Winds DPA, DBUA/Metalink, Query Store, Extended Event, PostgreSQL, Windows OS, MySQL Workbench, PowerShell, Toad, TDE, Power Bi, Percona XtraDB Backup, Azure/AWS, SQL Server Profiler, MDS, SSIS, SSAS, SSRS, Azure Data Factory, Azure HDInsight, T-SQL (DDL, DML), BCP, SSMA.

Certifications: Microsoft Certified: Azure Fundamental DP-900; Microsoft Certified: Azure Database Administrator Associates DP-300; MCSA: SQL 2016 Database Administration; MCSE: Data Management and Analytics; MS SQL Server Database Administration

Projects: Migrating 500+ Database from OnPrem to Azure Cloud using PowerShell and DMA; Patched SQL Serves Ranging from 2008 to 2019; Upgraded SQL Servers from Lower Versions (2008, 2012, 2014) To Higher Versions (2017, 2019)

Contact this candidate