We provide IT Staff Augmentation Services!

Sql Server Database Administrator Resume

Atlanta, GA

SUMMARY:

  • Successful Database Administrator with 7 years of experience in database development and production environments. Areas of expertise include database maintenance and database security. My experience includes SQL Server 2012, 2014 and 2016, SSIS, as well as clustering, mirroring, and high availability solutions; including AlwaysON Availability Groups, in OLTP environments. I am proficient in database backup, recovery, performance tuning, maintenance tasks, security, and consolidation. Proactively established backup and recovery processes; and protocols to protect and retain valuable company data.

TECHNICAL SKILLS:

RDBMS: MS SQL SERVER 2012/2014/2016

Operating Systems: Windows 20 Server

Data Migration: BCP, Import/Export Wizard, Bulk Load

Language: T - SQL

Third Party Tools: SQL Sentry and Idera SQL Dm

PROFESSIONAL EXPERIENCE:

SQL Server Database Administrator

Confidential - Atlanta, GA

  • Created, administered & maintained SQL Server Databases (Production, Development, Test and Staging Environment) for various groups such as Developer, QA and Users.
  • Upgraded databases from SQL Server 2012 to SQL Server 2014 and 2016.
  • Installed and configured multiple SQL Server instances in production environment.
  • Monitored the database systems to ensure secure services with minimum downtime.
  • Performed, database upgrades & applied software patches to the databases as per application/client requirements.
  • Rebuilt and reorganized the table indexes at regular intervals for better performance.
  • Engaged in Disaster Recovery (DR) strategic planning and implementation in SQL Server.
  • Created jobs, alerts, and SQL Mail Agents.
  • Experienced in Setting up High Availability (HA) solutions like Log shipping, Database Mirroring and Clustering as a part of Disaster Recovery (DR).
  • Scheduled full and transactional log backups for the user created and system databases in the production environment using the database maintenance plan wizard.
  • Assigned proper user access and security via permissions to the various database objects such as tables, views, and stored procedures.
  • Implemented MS SQL Cluster (Active/Passive & Active/Active), Multi Node Cluster for high availability.
  • Rewrote and Tuned long-running SQL queries to reduce execution time, ease database load and improve scalability.
  • Checked Database Consistency/health by using DBCC Commands & DMVs at regular intervals.
  • Tested and Implemented procedures to detect poor database performance, collecting required information, and root cause analysis.
  • Analyzed slow queries and tune the same to optimize application and system performance

SQL Server Database Administrator

Confidential - Atlanta, GA

  • Created, administered & maintained SQL Server Databases (Production, Development, Test and Staging Environment) for various groups such as Developer, QA and Users.
  • Installed and configured multiple SQL Server instances in production environment.
  • Monitored the database systems to ensure secure services with minimum downtime.
  • Performed, database upgrades & applied software patches to the databases as per application/client requirements.
  • Scheduled full and transactional log backups for the user created and system databases in the production environment using the database maintenance plan wizard.
  • Assigned proper user access and security via permissions to the various database objects such as tables, views, and stored procedures.
  • Tested and Implemented procedures to detect poor database performance, collecting required information, and root cause analysis.
  • Analyzed slow queries and tune the same to optimize application and system performance

Hire Now