Livi Email: ad1nub@r.postjobfree.com PH: 678-***-****

Summary

Dedicated to Problem Solving, Trusted & Proactive SQL Server DBA with expertise in crisis management, performance tuning, and high availability (HA) to increase reliability, maximize productivity and ensure system efficiencies. Adept at all stages of project lifecycle, from business requirements and technical definitions to testing, documentation, production support, training and completion. Reliable and Result Oriented

Skills set

•Over 10 years of experience supporting SQL server database 24x7 production environments.

•Installation and configuration of SQL Server 2008, 2008R2, 2012, 2014, 2016 and 2017

•Experience with implementation of disaster recovery (DR) and strategic planning and testing.

•Implemention of high availability (HA) solutions like AlwaysON, Clustering, Mirroring, Log Shipping.

•Experience with periodic database upgrades; applying patches and hotfixes

•Experienced in database security using TDE, Always Encripted, Dynamic data masking

•Experience monitoring and diagnosing databases for performance issues and tuning for optimazition.

•High level of self motivation and the ability to work well under pressure.

•Excellent written and verbal communication skills.

•Strong analytical and problem solving skills.

•Enthusiasm to learn new things.

•OPERATING SYSTEMS: Windows NT, Windows 7, 8 and 10. UNIX - Sun Solaris, Linux and AIX.

•DATABASES (RDBMS): 2008, 2008R2, 2012, 2014, 2016, 2017and 2019.

•LANGUAGES: SQL, T SQL, PL/SQL.

•TOOLS: Profiler, Extended Events, PerfMon, Idera, SCOM, SQL Sentry, SSIS, SSRS, SS Management Studio, HP Service Manager, Service Now, Rubrik, DBboost, Powershell, Remedy, Iserve, Jira, Qualys, Nessus, kenna

PROFESSIONAL EXPERIENCE

PGE Electric Company San Ramon, Califonia – Feb. 2020 to Present

SR. SQL Server DBA

RESPONSIBILITIES:

•Provide 24/7 production database support with on call shift rotation schedule, with coordination with other IT teams.

•Installed and configured SQL Server 2008R2, 2012, 2014, 2016,2017 and 2019 in clustered and non-clustered environments

•Optimized Ad hoc SQL queries and Stored procedures for performance improvement.

•Assisted in resolving application connection timeouts and other system level issues

•Used extended events, profiler and third-party tools to trace system bottlenecks and user related issues

•Performed data masking on databases on the DELPHIX target servers prior to provisioning the databases for database refresh in both the Azure and OnPrem online environments to data integrity.

•Performed data masking on QA\UAT\TEST databases while provisioning the databases

•Experienced in Transparent Data Encryption to encrypt data at rest.

•Perform Physical database refresh to lower environments to meet the customers needs

•Engaged in projects requirements analysis while working with various teams and management

•Using Automation skills, I created a monitoring mechanism to collect and report critical system errors for rapid response and resolution.

•Performed AWS cloud monitoring on using the DataDog, CloudWatch and Performance Insight

•Created databases on AWS RDS and ECS instances

•Performed backup/snapshots and restores in AWS EC2 instances

•Migrated databases from On-prem to the AWS RDS/EC2 Instances using DataSync / CLOUDENDURE.

•Installed and configure kenna/Nessus virtual scanner appliances an access via cloud

•Managed kenna/Nessus vulnerability scanning and identified vulnerabiliites; detected deprecated software on a windows 10 servers and remediated the vulnerabilities, verified the software was not vulnerable any longer.

•Executed kenna/Nessus vulnerability management life cycle in virtual environment in different stages like Prioritiziing, Assessment, reporting, Discovery and remediation.

•Analyzed database performance trends, adjusted system resources and established baselines using Foglight (Quest Software) tool, SolarWinds and App Dynamics

•Monitored database errors and other inconsistencies by running DBCC commands on weekly basis.

•Used SQL Server Dynamic Management objects/ views (DMV) to retrieve database and server health status; essential for proactive monitoring and prevention of system outages.

•Automated database maintenance tasks using PowerShell scripts

•Performed Index analysis to modify or add indexes to improve performance

•Enhanced data integrity and security by enforcing change management rules, utilization of AD Groups, and applying least privilege rules to database users and Application users.

•Followed documented process to decommission sql server and windows OS servers.

•Implemented AlwaysOn Availability Groups, a high availability solution for Tier1 systems with up to 4 replicas across subnets.

•Performed database migrations while working with Lan Analysts and application team to ensure all services are offline and back online and running fine accordingly.

•Migrated databases to higher versions of servers while maintaining database compartibility level.

•Implemented database security in all SQL server databases using privileges, roles and profiles while maintaining proper logins and ensuring there are no orphan users.

•Performed periodic database upgrades; applying patches/service packs/hotfixes

•Implemented transactional replication topology with 6 subscriptions and distributor for reporting purposes.

•Configured SQL Server mirroring and SQL server failover clustering solutions for manufacturing sites.

•Refreshed Dev, QA and Test environments from PROD using Backup and Restore mechanism

•Implemented transactional replication to transfer critical proprietary critical data from the data center to the manufacturing sites.

•Participated in Quarterly Disaster recovery tests to ensure recoverability and to ensure we meet RTO and RPO in incase of a real disaster.

•Database and system performance troubleshooting using Performance Monitor, DMVs, DBCC commands, Native SQL tools and Query execution Plan.

•Support OS patching, perform DB patching, production incidents and their RCA’s

•Resolve all assigned OPS requests on Jira ticketing system.

One Main Financial INC. Evansville, Indiana - March 2017 to January 2020

SR. SQL Server DBA

RESPONSIBILITIES:

•Deployed dynamic automation with flexibility of migrating any number of databases from AWS account to another

•Deployed dynamic automation of backing up number of databases before a major application upgrade and capable of restoring to a point in time on AWS cloud

•Implemented HA (MULTI-AZ) for Amazon RDS

•Experienced in creating database instances and databases on AWS

•Engaged in databases performance monitoring in AWS

•Provide 24x7 oncall support in SQL Server 2008, 2008R2, 2012, 2014, 2016, 2017 and 2019 production environments.

•Installed, configured and upgraded SQL Server softwares and related products.

•Performed capacity planning for all SQL Server databases that ensures stability and reliability.

•Implemented reliable TDP, TSM and DDboost backup and recovery policies and procedures in accordance with client’s SLA.

•Provided a Zero down time production database environment to clients by implementing and configuring ALWAYSON High Availabilty solution with primary and multiple secondary replicas with associated availability groups (AG) across multiple cluster nodes using Sql Server 2016.

•Performed database migrations while working with Lan Analysts and application team to ensure all services are offline and back online and running fine accordingly.

•Migrated databases to higher versions of servers while maintaining database compartibility level.

•Implemented database security policy in all SQL server databases using privileges, roles and profiles while maintaining proper logins and ensuring there are no orphan users.

•Used Transparent Data encryption to encrypt data

•Implemented the extraction, transforming and loading (ETL) strategy by creating packages by using SSIS to extract data Oracle, DB2, SQL Server, Excel files, other databases and flat files sources

•Performed periodic database upgrades; applying patches/service packs/hotfixes

•Implemented SCOM monitoring and diagnosing database for performance problems and resolutions using IDERA.

•Implemented archiving on Very Large database tables to improve performance using T-SQL queries

•Configured and implemented partitioning of Very Large database (VLDB) tables for performance

•Implemented SQL Server high availability solutions like failover clustering, Mirroring, and replication.

•Supported SQL Server production environment in a 24x7 oncall rotation to provide off hours support.

•Worked with developers team to test and tune SQL queries and T-SQL coding.

•Worked with LAN and application teams to deploy approved change control tasks in production.

•Composed a standard operation manual and valid procedures for the DBA team

•Organised DBAs weekly team meetings to keep focus on goals and on time service delivery.

•Coordinate DBAs tasks and schedules to ensure high performance and excellent coverage in our service delivery.

GENERAL MOTORS (GM) Atlanta, Georgia - March 2013 – March 2017

SQL Server DBA

RESPONSIBILITIES:

•Provide 24x7 oncall support in SQL Server 2005. 2008, 2008R2, 2012, 2014 and 2016 production environments.

•Implemented and supported high availability solutions like clustering, log shipping and mirroring.

•Maintained stable environment by automating various maintenance tasks like backups, index reorg, index rebuild, daily health checks in all production databases

•Met and exceeded SLA to provide a Zero down time production database to clients. I accomplished this by implementing and configuring ALWAYSON high availability solution with primary secondary replicas with associated availability groups (AG) across multiple cluster nodes using Sql Server

•Delivered a disaster recovering strategy that saved the company from data loss in our service deliverables to the clients and as such prevented any penalties and fines from clients.

•Using SCOM, I successfully implemented backup and recovery strategies and practices that ensure that company maintain successful database backups daily that meet the recovery requirements as SLA stipulate

•In critical situation helped to restore corrupted databases to a point in time with zero data loss.

•Deployed effective changes to our environments by engaging in the practice of obtaining change control approvals prior to database maintenance.

X- CELLENTSOFT SOLUTIONS INC Woodbridge, Virginia - January 2010 – February 2013

SQL Server DBA

RESPONSIBILITIES:

•Provide 24x7 oncall support in SQL Server 2005. 2008, 2008R2, and 2012 production environments

•Worked and maintained production and development databases in heavy transactional SQL Server 2005, 2008R2, 2012 and 2014 environments.

•Configured various HA solutions like failover clustering for windows and databases, Mirroring and replication.

•Database production support including installations, configurations, upgrades, capacity planning, performance tuning, backup and recovery in managing SQL Server clusters

ELECTRONICS DATA SYSTEMS (EDS) Auburn Hills, Michigan March, 2006 – January, 2010

System Engineer

•

RESPONSIBILITIES:

•Proven ability to implement and support server and network strategies with problem solving skills

•Effective administration and troubleshooting skills for all Microsoft OS and Windows server products

•Configuration, implementation and support of the Active Directory

EDUCATION:

Business Administration / With Minor in IT (University of Ibadan, Nigeria).

CERTIFICATIONS:

Microsoft Certified Technology Specialist (MCTS)

Microsoft Certified IT Professional (MCITP)

Contact this candidate