We provide IT Staff Augmentation Services!

Sql Database Administrator/dba Resume

Alexandria, VA

SUMMARY

  • 4 + years of experience in Database Administration, Database Design, and support MS SQL in Production & Development environments.
  • Very Good knowledge of MS SQL Server 2000, 2005, 2008/R2, 2012, 2014 and 2016.
  • Experience in installation, configuration, maintenance, security, backup, troubleshooting, performance turning of MS SQL Server 2005, 2008r2, 2012, 2014 and 2016
  • Experience in Creating Tables, Views, Triggers, Dynamic Stored Procedures, User Defined Functions, and other Transact - SQL (DDL, DML) statements for various applications.
  • Tracked Server Activity, Query Performance, and Disk usage activity statistics via Performance Data Collection.
  • Worked with SSIS & SSRS for various BI requirements.
  • Experience in SQL Server Replication, Backup/Recovery, Disaster recovery and planning.
  • Experience in Database migration using both in place and side by side migration
  • Experience in creation of logins, users and configuring permissions and assigning roles to users.
  • Experience years in configuring and managing Mirroring, Active/Active/Passive, and Always on Availability Groups
  • Experience in creating server, database, users, roles, and privileges in Azure portal
  • Experience in managing and troubleshooting Azure SQL databases through AppDynamics
  • Experience in managing and troubleshooting Azure SQL databases through portal
  • Manage Azure SQL servers, databases, and firewalls using the Azure portal

TECHNICAL SKILLS

Microsoft: Azure, SQL

Database Administration/Management: SQL Server 2016 2014, 2012, 2008(R2)/2005/2000

SQL Tools: Query Analyzer, Profiler, Database Mail, SQL Mail, SQL Agent, DTA, Task Manager

ETL Tools: SSIS, SSRS

Database Reporting and Analysis tool: SSRS (SQL Server Reporting Service)

Operating System: Windows Server 2014/ 2012/ 2008/2003/2000

PROFESSIONAL EXPERIENCE

Confidential, Alexandria, VA

SQL Database Administrator/DBA

Responsibilities:

  • Installed, Configured, and Managed SQL Server 2016, 2014, 2012, 2008/2008R2 and 2005 in development, test, and production environments.
  • Migrated from SQL server 2005 to 2008 and from 2008/R2 to 2012.
  • Scheduled jobs to automate different database related activities including backup, monitoring database health, disk space, backup verification
  • Monitor SQL Server Error Log
  • Implement DBA maintenance tasks for increase the Database performance with the help of Re-indexing, Re-organize index, and Update Statistics.
  • SQL Server jobs scheduling and creating alerts and operators and Trouble shoot the Job failures.
  • Monitor Server Activity, and solving problem as needed
  • Configured and Maintained Replications (Transactional)
  • Configured Log Shipping as Standby database from Production database.
  • Experience in using SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor (DTA).
  • Provided 24x7 on-call supports. Supported systems beyond regular hours/ weekends/ holidays
  • Documented changes made to the servers, including documentation of performance issues.
  • Created SQL server and database on Azure portal
  • Managed Azure SQL databases through Azure portal
  • Managed Azure SQL databases through AppDynamics

Confidential, Alexandria, VA

SQL Database Administrator/DBA

Responsibilities:

  • Installed, Configured, and Managed different versions of SQL server
  • Built and supported production servers on a 24/7 support on-call schedule.
  • Rebuild / Monitored indexes at regular intervals for better performance.
  • Configured and Maintained Replications (snapshot, merge and Transactional)
  • Monitored SQL server performance using SQL Profiler to find performance and dead locks.
  • Worked on SQL Server tools Like Enterprise Manager and SQL Query Analyzer.
  • Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
  • Monitored and modified Performance using execution plans and Index tuning.

Confidential

SQL Database Administrator/DBA

Responsibilities:

  • Installed, Configured and Maintained Database Mirroring using automatic fail-over option in SQL Server 2008 and 2012
  • Supported production and development databases.
  • Solving the request raised by user support.
  • Upgrade MS SQL Server from different versions.
  • Participate in implementation of new releases into production.
  • Designed and implemented Backup plan and disaster recovery strategies
  • Developed Database Backup Scripts and automated this process
  • Diagnosed job errors and implemented solutions or worked with developers and/or Server Administration as necessary to solve break/fix and other issues.
  • Worked with developers to tune the SQL queries using SQL Profiler
  • Solved critical production problems and performed point in time recovery plans.
  • Trouble shooting Problems by using SQL server profiler, DMV’S and Estimated Execution Plan

Hire Now