We provide IT Staff Augmentation Services!

Sql Database Administrator Resume

5.00/5 (Submit Your Rating)

Mclean, VA

TECHNICAL SKILLS

Database: SQL Server 2008, 2012, 2014, 2016

SQL Tools: SQL Server Management Studio, Enterprise Manager, Query Analyzer, SQL Profiler, Database Tuning Advisor, SQLCMD, Reporting Services Report Manager, Reporting Services Configuration SQL Configuration manager

Reporting/ETL Tools: SSRS, SSIS

Programming Language: Transact - SQL, ASP.net, HTML, C#, C++, CMD, PowerShell

Operating Systems: MS Windows Server 2008, 2012, Windows XP, Windows 7

Monitoring Tools: System Monitor, Counter, SQL Diagnostic Manager by IDERA, Windows Event Logs, Activity Monitor

Other Tools: SSMA (SQL Server Migration Assistant) and ODBC/DB Link, Red-Gate, SharePoint 2010/2013, VISIO, VMware

Methodologies: Agile Scru

PROFESSIONAL EXPERIENCE

Confidential, McLean, VA

SQL Database Administrator

Responsibilities:

  • Install and configure different versions of SQL Server in Development, Test, Stage and Production environments.
  • Upgrade earlier versions SQL Server 2008, SQL Server 2012 and SQL Server 2016.
  • Work with business analyst to deploy databases and manage database availability.
  • Rebuild servers when master database was corrupted.
  • Develop and apply Disaster Recovery strategies.
  • Configure and manage SQL Server Always-On High Availability Groups with multiple secondary nodes.
  • Experience on public cloud infrastructures and migration of on-premises SQL server databases into the cloud (Azure).
  • Work with developers to tune-up performance of SQL and T-SQL queries.
  • Performance tuning & optimization of servers in Production and Test environments.
  • Create and manage database security, data encryption and apply object level security.
  • Develop Database Maintenance Plan for different business requirements.
  • Used DBCC and Alter statements for different database administration tasks such as checking database consistency, reorganizing and rebuilding indexes, updating statistics.
  • Used DMV (Dynamic Management View) for different database administration tasks such as backup history, indexes fragmentation levels, statistics and status of different jobs.
  • Export & import database objects from/to Oracle, MySQL, Access Database, flat files (text, excel, and CSV files) and MS SQL Server.
  • Experience in using SSIS/DTS, BCP to import & export data from flat files, excel, MS Access, and other OLEDB databases to MS SQL Server databases.
  • Working experience with SAN and RAID.
  • Providing customer support, dealing with non-technical and upper level management.
  • Experience in providing end-user support on a day-to-day basis.
  • Provide 24x7 supports for critical production systems.

Confidential, Bethesda, MD

SQL Database Administrator

Responsibilities:

  • Installed, Configured, and Managed SQL Server 2008 R 2/ 2012/2016.
  • Performed regular database maintenance tasks such as rebuilding indexes, update statistics, database integrity check, storage management, monitoring performances.
  • Applied Hot Fixes, Patches, Cumulative Updates, Service Pack, Service Pack), Upgrades.
  • Managed Backup and Recovery systems based on RTO and RPO, use Native SQL server Backup/Recovery Tools, Red Gate SQL Backup Pro.
  • Refreshed database from production and attach the database from data file when needed.
  • Created and manage database security, data encryption and apply object level security.
  • Implemented SQL Server Always-On High Availability Groups with multiple secondary nodes.
  • Applied patches and CUs on Always-On Availability group replicas in production and non-production environment.
  • Worked on public cloud infrastructures and migration of on-premises SQL server databases into the cloud (Azure).
  • Designed high availability architecture for database availability.
  • Maintained performance tuning and optimization of servers in Production and Test environments.
  • Used Activity monitor, Wait stats, Stored Procedures, DMV, DMF, SQL Profiler, Extended Events, Error log, Windows Performance Monitor to find out health and performance problems for the servers.
  • Wrote automating database maintenance processes and monitoring using T-SQL scripts.
  • Worked on query optimization and tuning using Database Engine Tuning advisor, Activity Monitor and analyzing Execution Plan.
  • Performed research into database performance issue and come up with solutions to address those concerns.
  • Enjoyed working in a team environment and independently as well.

Confidential, Tampa, FL

SQL Database Administrator

Responsibilities:

  • Installed, configured, and managed SQL Server 2008/2012/ 2014/2016 in Development, Test, and Production environments.
  • Ensuring system availability, data integrity; monitor/troubleshoot backup and recoveries, performance, disk space, and network connectivity.
  • Coordination with the team, providing technical assistance, support to system operations staff and end-customer client organizations.
  • Handled common database functions, such as upgrade, backup, recovery, and migration.
  • Resolved, troubleshoot database issues, and performed upgrades, conversions and deployments.
  • Proactively monitored the production database(s) and optimize stored procedures for better performance. Resolved locking conflicts and resource utilization.
  • Written automating database maintenance processes and monitoring using TSQL scripts.
  • Provided project database consulting including query analysis, and database implementation.
  • Refined and automated regular processes, track issues, document changes.
  • Assisted developers with complex query tuning and schema refinement.
  • Implemented SQL Server ALWAYSON High Availability groups with two secondary nodes.
  • Performed scheduled maintenance and support release deployment activities after hours.
  • Configured and Maintained; Log shipping, Mirroring, Replication as part of a high availability solution.
  • Exported & imported database objects from/to Oracle, Access Database, flat files (text, excel, and CSV files) and MS SQL Server.
  • Installed, configured, and Managed SQL Server Reporting Services (SSRS).
  • Generated Report using SSRS (SQL Server Reporting Services).
  • Responsible for creating, modifying and managing tables, Index (Cluster/Non-Cluster).
  • Monitored Server Activity, Error Log, space usage, and solving problem as needed.
  • Managed and resolved trouble tickets (Remedy) for database-related issues submitted.
  • Designed database backup and restore plan, recovered database from back up in disasters, implement point in time recovery solutions.
  • Created database capacity planning, Maintenance planning, SQL Agent Jobs scheduling and troubleshooting.
  • Written SQL queries, Triggers, Functions, creating Tables, Views and Indexes.
  • Audited and generated monthly management reports using third party tool.
  • Created the database, tables, table spaces, data objects, setting privileges, indexes, user login and password (Security).
  • Provided 24x7 supports for critical production environment.

We'd love your feedback!