SQL Server DBA Resume Sample

These are some examples of job descriptions we have handpicked from real SQL Server DBA resumes for your reference.

SQL Server DBA

  • Evaluate the peak and no peak usage pattern of the application; effectively distribute database administration activities, such as full database backup and database defragmentation during no peak hours.
  • Monitored database quality including database consistency check with DBCC, Defrag, and Index tuning and monitored error logs.
  • SQL Query Performance Tuning, system Performance Analysis, analyzing the Query ExecutionPlans, Used SQL Profiler for optimizing the store procedure.

SQL Server DBA

  • Scheduling and implementing patching activities i.e. Service packs and Cumulative upgrades as per baseline standards at Wellsfargo.
  • Contributed to implementation of HA/DR solutions for database servers of SQL 2012/2014/2016, including Failover Clusters, mirroring and Always On Availability Groups.
  • Performance tuning of long running queries and stored procedures, using SQL Profiler, server side traces, Database Tuning Advisor, and query execution plans.
  • Daily production DBA tasks, including monitoring SQL Server logs, SQL Agent job execution, and transaction log file sizes, backup/restore and performance tuning.

SQL Server DBA

  • Managed Microsoft ActiveActive and ActivePassive Clustered SQL Server 2000, 2005 and 2008/R2 environments.
  • Performed DBCC utilities and fixed data corruption in User databases.
  • Developed, deployed and monitored SSIS Packages tool of SQL Server to populate data from various data sources, created packages for different data loading operations for application including upgrading DTS to SSIS.
  • Migrated SQL Server 2000 to SQL Server 2008/2008R2 and SQL Server 2005 to SQL Server 2008/2008R2 which include installing of SQL Server.

SQL Server DBA

  • Created, administered & maintained SQL Server Databases on Production, Test and Staging for various groups and ensured the availability of the database Servers.
  • Monitored data activities like database status, logs, space utilization, locks and long transactions.
  • Worked with developers to optimize the code if required to minimize the duration and look if the indexes are used appropriately.
  • Involved in resolving deadlock and blocking issues for concurrent users.
  • Provided appropriate access to users and their respective needed application schema owners.

SQL Server DBA

  • Worked extensively on monitoring the database and resolving all the production issues in response to the alerts.
  • Monitored the regular backup of the production databases and resolved the backup failures ensuring a perfect database backup strategy for the organization.
  • Worked in setting up and troubleshooting log shipping ensuring no latency.
  • Designed and Implemented database maintenance plans for various database activities.
  • Responsible for ensuring accuracy of data and that processes are followed, loading data into table, etc.

SQL Server DBA

  • Configuring Replication from Production to Reporting server and adding articles as and when new tables are created.
  • Configured Log Shipping as a Disaster Recovery Planning for Critical databases.
  • Working with application development and support teams to resolve service requests and incidents within agreed upon SLAs.
  • Reviewing and fixing issues with database backups, maintenance, monitoring and performance and other common faults.
  • Ensure that new database code meets company standards for readability, reliability, and performance.

SQL Server DBA

  • Reconfigure the default locations of the data files; log files and error log files onto the SAN environment for all the servers.
  • Provide flexibility and performance to simplify the creation and maintenance of partitioned tables in SQL Server 2005.
  • Applied hot patches on MSCS (Microsoft Clusters) and Fixed few bugs in Microsoft Cluster and SQL Virtual Servers.

SQL Server DBA

  • Worked with system administration team to have Windows 2012 R2 VM servers created with standard configuration of specified number of CPUs and amount of Memory for Development, QA, Pre-Production and Production environments.
  • Validated cluster configuration and created clusters with multiple nodes of three different datacenters in the domains available.
  • Installed and Configured SQL Server 2014 and 2016 successfully on Windows 2012 R2 servers.
  • Enabled and created AlwaysOn Availability Groups, AlwaysOn Availability with Transactional Replication and Distributed Always On Availability Groups on the SQL Server instances to host databases for eCommerce, Corporate and Data Warehouse applications.

SQL Server DBA

  • Implemented data models, database structure design, backup and recovery processes.
  • Configured Change Data Capture in SQL Server 2008 to maintain the history of the changes in the tables.
  • Involved in installation of SQL Server 2012 and 2008 R2 on Consolidated and Standalone environments and maintains development and production databases (e.g., SQL Server databases).

SQL Server DBA

  • Installing and configuring SQL Server2014/SQL Server 2012 with backup jobs, database mail and configuration options.
  • Configure, patch, test, monitor, and support multiple heterogeneous database instances, maintaining the databases at current release and maintenance levels.
  • Configured and setup snapshot replication from production to Development and stage environments.

SQL Server DBA

  • Executed Data migrations from one database structure to another Using SSIS Review and Migrated Stored Procedure.
  • Responsible for maintaining High availability serverslike Clustering and transactional Replication.
  • Implemented Point in time Backup and Recovery Plans of all databases and maintained documentation.
  • Good experience in the Maintaining Production Servers, Monitoring Performance issues, Trouble Shooting and Solving Production Issues.

SQL Server DBA

  • Upgraded SQL server 2008 to SQL Server 2012 in Microsoft Windows Server 2012 R2 Enterprise Edition.
  • Installed, Configured, and Managed SQL Server 2012, and 2008 in development, test and production environment.
  • Installed, Configured, and Managed SQL Server 2012 in development and test environment.

Leave a Comment

Your email address will not be published. Required fields are marked *

Read previous post:
Spanish Teacher Resume Sample

In schools across the world, learning a second language is becoming more and more of a valuable skill thanks to...

Close