We provide IT Staff Augmentation Services!

Senior Sql Dba Administrator Resume

2.00/5 (Submit Your Rating)



  • A Microsoft certified SQL server (DBA) with 8+ years IT experience: designing, coding, testing, and supporting next - generation database solutions in SQL Server environment.
  • Possess strong communication and problem-solving skills developed through a variety of projects. Offers proven ability in team work and proactive system support.
  • Experience in Installing, configuring, administration and Maintenance of mission critical client databases in SQL server 2008, 2008R2, 2012, 2014, 2016, 2017 and 2019 versions.
  • Good experience in configuring teh SQL Server in AWS Relational Database Management system and in EC2.
  • Extensive Experience in Upgrading SQL Server (In place Up and Side by side Upgrade) based on application compatibility and fixing teh orphan users.
  • Experienced in implementing SQL Server security and Object permissions like creation of users, granting permissions and assigning roles to users.
  • Deployment, administration and operational support of production, development and test environments utilizing proper change management and other ITIL best practices using ticketing tools.
  • Good experience in implementing and troubleshooting High Availability of database servers using Replication, Log Shipping, Database Mirroring, failover clustering and Always ON AG.
  • Strong experience on understanding and creating teh server level and database level roles as per business requirement.
  • Experience in Configuring and Scheduling SQL Server agent Jobs, Alerts, operators, Maintenance plans, Database Mail Configuration, facets and Transparent Data Encryption.
  • Extensive experience with Monitoring, Performance Tuning and analyzing DB performance issues.
  • Strong experience on designing and implementing teh backup and disaster recovery strategies as per RPO and RTO values.
  • Experience in configuring and maintaining full backup, Transactional log backup, Differential backup and creating teh maintenance plans for index rebuild, index reorganize based on fragmentation.
  • Strong experience on identifying and troubleshooting database health, integrity checks and fixing them.
  • Experience in Microsoft Reporting Service (SSRS) with Report authoring, Report management, Report delivery and Report security.
  • Created reports, sub reports, charts, Tablix, Matrix, Hyperlink reports.
  • Created jobs, alerts to run SSAS, SSRS packages periodically.
  • Created teh automated processes for teh activities such as database backup processes and SSAS, SSRS Packages run sequentially using SQL Server Agent job


  • Windows R2
  • SQL Server
  • T-SQL
  • AWS-EC2
  • IDERA SQL diagnostic Manager
  • SQL safe 6.0
  • Red-gate SQL Compare 10
  • Data Compare 10
  • DataEdo
  • SSDT
  • Azure
  • SSIS
  • SSRS
  • SSMS
  • DTA
  • JIRA
  • RAID
  • LiteSpeed
  • Azure managed instance
  • Salesforce
  • API


Confidential, Virginia

Senior SQL DBA Administrator


  • Installing, configuring, administering and securing production and non-production servers (clustered and non-clustered).
  • Upgrading SQL server 2012 to SQL Server 2016 and 2017.
  • Experience in implementing windows cluster across multiple availability zones and Implemented SQL Server 2016 Always On availability group in AWS.
  • Experience in setting up database transactional replication for reporting servers, Using Backup and restore methods.
  • Expert in Database refresh from prod to lower environment as per teh business requirements and automated quarterly/monthly database refresh.
  • Managed and Involved in SQL performance Tuning, identifying locking and blocking issues using Native and Third-party tools to enhance and boost performance of SQL Dbs.
  • Managed and Implemented Ola Hallengren's Industries best SQL server maintenance plan and created schedule for all environments.
  • ManagedSQL server Logins, Database users & rolesand involved in Daily User Maintenance.
  • Created Database Maintenance jobsto perform full & transaction log Backups and scheduled them with teh SQL Server agent job scheduler.
  • Monitor database growth activities & Troubleshoot Transaction Log Issue.
  • Created and configured mirroring for Disaster Recovery.
  • Providing weekly status information on all projects to Project Manager.
  • Wrote and debugged Stored Procedures and (DDL /DML) Triggers, Functions as per client requirements.
  • Logical and Physical design of database for projects on basis of user requirements using ERWIN
  • Reporting on a weekly basis to teh project manager.
  • Extensively worked on troubleshooting and fine-tuning of databases for optimal performance.
  • Worked withPerformance Tuning/Query tuning,execution plans, trace flags and SQL Profiler
  • Installation ofService packsto all environments.
  • Used log shipping for synchronization of databases.
  • Designed and developed ETL process using SSISto load data from various sources like MS Access and SQL Server 2014, Oracle database
  • Expert in Data Extraction, Transformation and Loading (ETL) using SQL Server Integration Services (SSIS)
  • Experience in migrating SQL Server 2012 and 2014 to SQL Server 2016 with AlwaysOn Availability
  • Good understanding in database and data warehousing concepts (OLTP & OLAP).
  • Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases
  • Worked on BCP for data uploading module and created SSIS packages for data transfer & transform across locations and multiple data sources as per requirement.
  • Created new tables, stored procedures and triggers using T-SQL.
  • Refactored and Fine-tuned teh queries and Stored procedures in T-SQL.
  • Performing DB backups, DB refresh, DB restores, clean-up, statistics update
  • Installed and configured MS SQL Servers in Virtual Environments using VMWARE.
  • Analyze teh Execution plans and recommend/implement a better execution plan.
  • Experience in Monitoring and Tuning system resources associated with teh database performance, hit ratios, me/O, lock, and latch contention.
  • Experience supporting AWS DB in production and Development environment

Environment: Windows R2, SQL Server, AWS-RDS, AWS-EC2, IDERA SQL diagnostic Manager, SQL safe 6.0, Red-gate SQL Compare 10 and Data Compare 10, Visio 2010, DataEdo, ERWIN.

Confidential, New Jersey

SQL Server Database Administrator


  • Installed and Configured various editions and versions of SQL Server in standalone, and clustered nodes
  • Installed, and Configured SQL Server Fail-Over Cluster for SQL Server 2012, 2016 & 2017.
  • Applied service packs, hotfixes and cumulative updates
  • Upgraded SQL Server 2005, 2008 and 2008 R2 Database into SQL Server 2017 and 2019
  • Created and maintained logins, Users, Roles and managed security of teh database.
  • Implemented Disaster recovery plan by performing routine backups and restore
  • Taking Full, Differential and Transactional log backups and setting automated jobs.
  • Migrated data using Import/Export, bulk, backup-restore, DTS, SSIS, Detach/Attach
  • Performed data Extracting, Transforming and Loading (ETL) from different data sources.
  • Rebuilding /reorganize indexes to reduce fragmentation and enhance SQL server performance
  • Created triggers, views and stored procedures,
  • Implemented database Maintenance plans, scheduled automated SQL Server jobs, Created Alerts, Operators, Notifications and configured database Mail.
  • Hands on experience monitoring and performance tuning using Tuning Advisor, SQL server Profiler, Activity monitor, Windows performance monitor, DBCC, DMVs, Stored procedures
  • Working with Resource Governor to control and allocate CPU and memory resources depending on teh priority of applications.
  • Configured and Managed Database High Availability: Replication, Database Mirroring, Log Shipping, Failover Clustering and Always On availability group.
  • Scheduled reports using SSRS to generate daily, weekly, monthly, quarterly reports
  • Worked in a team with integrated Developers, CAB (Change Approval Board) and Disaster Recovery Planning team.
  • Experience in contacting Microsoft and other vendors for product and technical support.
  • Providing resolution to assigned tickets (JIRA, Team Track and Service Desk) as per their severity and meet teh deadline before SLA is due.
  • Experience in Agile projects with a solid foundation in Software Development Lifecycle (SDLC).

Environment: Windows R2, SQL Server, IDERA SQL diagnostic Manager, Red-gate SQL Compare 10 and Data Compare 10, Visio 2010, SSDT.

Confidential, Bentonville, Arkansas



  • Installed and configured SQL server 2008/R2, 2012 and 2014.
  • Installed and configured window server 2008 and 2012R2
  • Created and updated databases, tables, stored procedures, triggers, functions, and views.
  • Configured, administered, and troubleshoot multiple databases in production and staging environments in clustered and standalone environments.
  • Prepared documentation for disaster recovery plan.
  • Involved in installing failover clustering on multiple nodes.
  • Implemented database mirroring and log shipping
  • Planned backup strategies, scheduled backups, and performed restore operations.
  • Managed security of SQL server databases by creating logins, creating database users, creating roles, assigning proper permissions, creating server and database audits.
  • Worked on creating, reorganizing, and rebuilding indexes.
  • Worked on database space management, performance monitoring, and alert management.
  • Planned teh location of files and increased teh size and number of files.
  • Performed tasks of query optimization, troubleshooting client/server connectivity issues, and performance tuning.
  • Monitored and troubleshoot database and server performance at system-wide scale and effectively identify network, databases, Memory, CPU, Disk Space, and me/O related bottlenecks.
  • Transferred data between several servers using BCP and DTS.
  • Generated reports extensively using SSRS.
  • Providing resolution to assigned tickets (JIRA, Team Track and Service Desk) as per their severity and meet teh deadline before SLA is due.

Environment: Windows R2, SQL Server R2, SQL Server 2012 SSMS, Profiler, Extended Events, Perfmon, RAID

We'd love your feedback!