Sr. SQL DBA Resume

SUMMARY:

SQL Server DBA with 8 years of experience in Database Administration of medium to large databases in SQL Server 2016, 2014, 2012, 2008R2, 2008 & 2005. Seeking a challenging opportunity where I can be a contribution to the SQL Server environment.

TECHNICAL SKILLS:

Installation & implementation of: MS SQL 2005, 2008, 2008R2, 2012, 2014 & 2016, Maintenance & Performance Tuning of the database, Backup/Disaster Recovery strategy implementation

Database Security: Database Migration & Patching

Server Tools: SSMS, SQL Profiler, Performance Monitor, DMV & DMF, Intermediate T - SQL knowledge

HA Solutions: AlwaysOn Avail Groups, Mirroring, Log Shipping, Failover Clustering & Replication

PowerShell & VMware: ServiceNow, Idera & StarWind

EXPERIENCE:

Sr. SQL DBA

Confidential

Responsibilities:

Manage over 720 databases ranging from 350GB to 3TB with SSMS
Setup various measures to manage data including partitioning, transactional & merge Replication, Log Shipping, Mirroring & AlwaysOn
Build & manage ACTIVE-PASSIVE Clustering to handle mission-critical databases
Schedule database backups ensuring schedules meet daily, weekly &/or monthly recovery requirements
Manage technical reviews validating & thoroughly testing changes to the production environment
Use SQL Profiler for troubleshooting, monitoring & optimization of SQL Server
Develop & optimize stored procedures, triggers & views
Work with BI team to define, implement & maintain reporting requirements
Configuring HADR using SQL server 2012
Experience in writing & optimizing T-SQL codes & stored procedures
Utilize PowerShell (Windows & SQL server)
Proactively monitor the database systems to ensure secure services with minimum downtime
Provide on call support on a rotating basis
Improve CPU consumption for critical production database servers by tuning queries
Responsible for admin tasks like re-indexing and backup & recovery
Upgrade SQL Server 2005, 2008 & 2008r2 databases for mission-critical business
Created database objects - tables, stored procedures, views, indexes & constraints
Supported SQL Server database performance, availability & security

Sr. SQL Server DBA

Confidential

Responsibilities:

Installed & configured SQL Server instances in Development & Production environments
Performed backup, restore, maintenance & performance tuning of multiple databases
Upgraded SQL Server 2005, 2008 & 2008r2 databases for mission-critical business
Analyzed and supported multiple databases with SSMS
Worked as a team member with other DBAs to ensure 24x7 support of all corporate databases
Used ServiceNow to troubleshoot & resolve support tickets to meet business SLA
Worked closely with the Applications, BI & Project Management team members to ensure that all systems function together & meet SLA's business goals & objectives
Managed & monitored HA Solutions: AlwaysOn, Failover Clustering & Replication

SQL Database Administrator

Confidential

Responsibilities:

Identified & troubleshooted any CPU or Memory lagging & latency issues
Ensured availability of instance & databases via Clustering, Replication, Mirroring & Log Shipping
Proactively monitored entire instances & databases for any abnormalities
Created database objects - tables, stored procedures, views, indexes & constraints
Performed various patching & data migration tasks for mission critical databases
Installed & configured SQL Server instances in Development & Production environments
Troubleshooted & resolved support tickets to meet business SLA
Implemented VMware to reduce datacenter footprint
Evaluated, defined, recommended & implemented application database requirements in collaboration with IT management & other staff
Provided technical assistance to the projects throughout their development phase by customizing the systems to give desired result
Maintained standards & policies for SQL Server user authentication & database security
Designed, documented & executed maintenance procedures including system upgrades, patch management and system backups
Installed & configure SQL 2012 clustered environment with availability groups
Scripted, scheduled & monitored different type of database jobs & alerts for automation
Responsible for supporting the SQL Server databases with SSMS & ensuring their performance, availability, scalability & security
Worked with developers to perform database testing & supported releases in production
Provided technical support to users including 24x7 on-call responsibilities
Worked closely with subject matter experts from various product & services vendors to design & implement sound disaster recovery & business continuity practices
Created, maintained, backed up, restored & tuned databases for development test & production
Created & deleted accounts in Active Directory
Provided administrative technical support to users for all network application

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship