Senior SQL DBA Resume

SUMMARY

SQL Server DBA with 9~ years of experience including process automation and hands - on experience in coding SQL, Perl, and PowerShell.
Previously at Best Buy and Target, I have led and managed a team in an onshore/offshore model that supported SQL database infrastructure which required to understand business processes, gather requirements, identify potential usability issues, manage scope, and ensure that an appropriate level of support quality was always maintained.
I have comprehensive knowledge and experience in every aspect of Designing, Automating, installing, upgrading and patching SQL database software, backup and recovery strategies, data archiving, managing security and users, SQL file system management, task scheduling, performance monitoring and tuning, retrieving data, cloud deployment, and the Windows operating system.
SQL Server Database Administration, 8+ years in large enterprise environments
Design, Install, configure and patch SQL Server 2000/2005/2008/2012/2014/2016/2017/2019.
Experience in configuring and managing cloud solutions like Azure SQL PaaS and IaaS.
Understanding business processes, gathering requirements, identifying potential usability issues, managing scope, and ensuring that an appropriate level of support quality always maintained.
Managed a team of 15 people with onshore and offshore model and supported 24/7 Production databases and responsible for round - the-clock database operations.
Upgraded SQL server and databases with size up to 28 TB from SQL 2005, SQL 2008 to SQL 2016 or higher version.
Migration of small databases from Oracle and MYSQL to SQL Server.
Experience in Azure DevOps build pipeline, Octopus deployment tool.
Designed and implemented SQL databases for data warehouse applications.
Extensive expertise in designing and configuring High availability and Disaster recovery features like Always On, Mirroring and clustering.
Designed and Configured multi node availability group with high availability, disaster recovery with read replica.
Maintaining the systems and helping application team to resolve the complex performance issues raised by customers efficiently and effectively on time.
Design security architecture for SQL server based upon the policies and needs.
Provide solutions for capacity management of servers and optimize database performance.
Designed and implemented backup and recovery strategy for SQL servers based on the application requirements.
Design new scripts and upgrade existing scripts to perform health check for stability, integrity, security etc.
Configured monitoring for SQL server databases to proactively identify issue.
Excellent communication, interpersonal and strong analytical skills, Documentation and problem-solving skills with customer service-oriented attitude. A very good team player dedicated in any work environment.

TECHNICAL SKILLS

Microsoft Windows 2019/2016/2012/2008 R2/2003
T-SQL, Perl, PowerShell
SQL 2019,2017,2016, 2014, 2012, 2008R2, 2008, 2005, 2000
Visual Studio, Visual studio code, Azure DevOps, Octopus, Git, Thycotic, Tidal
Microsoft service enterprise, Service now, Cherwell, BMC remedy, Optim, Perfmon, Rally, Solarwinds DPA, SSIS, SSRS.

PROFESSIONAL EXPERIENCE

Confidential

Senior SQL DBA

Responsibilities:

Migrated SQL 2008/2012 databases to 2016/2017.
Performed configuration changes in different applications to use the new version of databases.
Worked on database development, Peer review as per business need.
Worked on Azure DevOps build pipeline, creating repository, PR build, CI build and releases.
Automated deployments with Octopus tool in different environments.
Used version control in Azure repository while maintaining the databases.
Created Octopus step template to auto update the SQL account credentials by using Thycotic API.
Automated database mirroring and Always-ON setup for databases using PowerShell.
Assisted developers to migrate SSAS database from 2008 to 2016.
Performed configuration changes on SSRS while migrating SQL databases.
Provided assistances as a DBA for all production deployment.
Worked with vendors to make sure application is working as expected after the migration.

Confidential

Senior SQL DBA

Responsibilities:

Provide SQL server architecture design and solution as per the business requirement. Created deliverables such as Entity Relation Models, Database Structure and Server Configuration specifications.
Migrating SQL Database from one datacentre to another datacentre.
Able to proactively monitor the database environment and to make changes to data structures if needed.
Worked as agile DBA to perform 30+ application migration.
Able to predict growth based on application and data usage patterns and to implement the necessary database changes to accommodate the growth.
Expertise on designing SQL server strategy for new application including the software version, type of hardware and compatibility test with application including load testing.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship