SUMMARY

• Database Administrator with 11 years’ experience supporting enterprise database servers and applications for fortune 500 organizations. With expert experience in teh area of: High Availability Solution; AlwaysOn Availability Group, SQL Server Failover clustering, SQL Server Replication, Performance Tuning & Optimization, Database Migration, on Premise to Cloud (Azure/AWS), Disaster Recovery, Database Security, SQL server Maintenance Automation and Storage capacity planning.

TECHNICAL SKILLS

RDBMS: SQL 2005, 2008, 2012, 2014, 2016, 2017, SSRS,SSIS, SSAS, SQL Azure, Oracle 12G, MySQL

OPERATING SYSTEM: Windows Server 2000, 2003, 2008r2 and 2012, Linux

Backup & Storage solution: 3rd party tool; Symantec NetBackup, Avamar. SAN, LAN

Monitoring tools: Profiler, Extended Events, DTA, Perfmon, Query Store. 3rd Party; SentryOne

Third party tools: DBArtisan, DB Compare, PeopleSoft, SNOW, Service ManagerPROFESSIONAL EXPERIENCE

Confidential

Sr Database Administrator

Responsibilities:

• Migrated mission - critical database servers from Windows Failover clustering SQL Server 2012 to AlwaysOn Availability Group on SQL server 2016 with minimal downtime.
• Worked as teh Primary DBA in teh implementation of SOX for all teh databases that a required to be SOX compliant. implementations, assisting projects with business requirements analysis to solutions delivery and support.
• Responsible for installation, configuration, and maintenance of 2008R2, 2012, 2014 and 2016 MS SQL Server on various environments
• Implemented teh Installation, configuration and maintenance of Active - Passive Clustering and Active - Active (Multi-instance) cluster environment as a High availability solution for various projects.
• Supported, maintained and administered VLDB of over 4TB in size.
• Assisted in developing and testing of backup strategies and disaster-recovery plan for production databases, delivering solution that guaranteed recovery performance and high availability. To ensure proper system continuity in teh case of an unforeseen event.
• Updating SQL Server with latest service packs and security patches
• Solved critical production problems and performed point in time recovery plans,
• Worked with SQL developers in Controlled environments to implement/rollout SQL, SSIS and SSRS changes as requested by teh business.
• Monitored application and database performance, and adjusted database parameters, application code or schema as needed
• Administering of SQL Server Database Security environments using Profiles, database Privileges and Roles. And ensuring security of teh database servers by implementing applicable security patches and maintaining appropriate security measures/best practices.
• Configuration and implementation of AlwaysOn Availability Group.

Confidential

Sr. SQL DBA

Responsibilities:

• Served as A Primary DBA in teh completion of over 456 medium- to large-scale Project Worked with a Team of 6 DBAs to support, administer and maintain over 3500 SQL server Instances.
• Migrated 780+ SQL Server DBs from 2005 and 2008R2 to SQL 2012, 2014 and 2016 also Data migration between different environments.
• Performed routine Disaster Recovery Testing Ensuring recoverability of all mission critical Databases in teh line with teh business RTO, RPOs and SLAs
• Performing problem determination and resolution using Extended events, DMVs, Profiler, DTA and 3rd party tools in monitoring and optimization of SQL Server, SQL code, Indexing, and Statistics. To improve performance where needed.
• Assists in providing documentation detailing teh design and architecture of teh databases, as well as teh administration, backup procedures and data recovery strategy.
• Timely troubleshooting of all database-related problems and emergency response to all production downtime events.
• Monitored backup operations, and schedules manual backups as needed.
• Assisted in developing, modifying, and optimizing complex stored procedures, and triggers to handle complex business rules, history data and audit analysis
• Ensured teh security of teh database servers by implementing applicable security patches and maintaining appropriate security measures and best practices.
• Provided recommendations to Developers outlining alternate methods of accomplishing teh same tasks.
• Monitored and maintained database performance and identified/recommended areas that can be improved. worked alongside Server Engineering team to upgrade all Windows 2003 Operating systems to Windows 2012
• Installed, configured, and administer Microsoft SQL database instance
• Created and/or maintain clear documentation regarding all components of database administration.

Confidential

SQL Server DBA

Responsibilities:

• Upgrading and implementing version control of SQL servers on Development and Test environments according to business requirements.
• Installation and configuration of various software applications, on development and Test Environments.
• Resolving alerts, ranging from Space issues and failed jobs, ensuring that teh databases are running as expected and systems are being backed up successfully daily.
• Worked with other database administrators to ensure reliability, availability, and scalability of our databases and server platforms to meet program objectives, and SLA.
• Administering of SQL Server Database Security environments using database Privileges and Roles. And ensuring security of teh database servers by implementing applicable security patches and maintaining appropriate security measures/best practices.
• Handling database refreshes on Dev and Test and handling maintenance Jobs.
• Working with development teams on change tickets, to deploy database changes required for release rollouts.
• Established and enforced controls to ensure database integrity.
• Installed, configured, and administer Microsoft SQL database instance
• Created and/or maintain clear documentation regarding all components of database administration.
• Worked with end users to define, implement, and maintain their reporting requirements.
• Monitor space usage and adjust database as needed.
• Coordinated with platform hosting vendor(s) DBAs to ensure proper support, maintenance, and tuning of various databases
• Resolving Incidents, ranging from performance, database corruption, Space issues, failed jobs, etc. ensuring that databases are running as expected
• Hardening SQL Server instances per industry standard and best practices.
• Working with development teams on change tickets, to deploy database changes required for release rollouts.