Database Administrators (DBAs) are responsible for the proper functioning of a database. To do this, they monitor data to ensure security and accuracy, oversee upgrades, interpret data, and develop new software. DBA duties revolve around the analysis of data to provide information that can be used for decision making. The top skills for this position are problem-solving, data analysis, database administration, process automation, and customer relationship management. A bachelor’s degree is needed for this job.
The Best SQL Server DBA Resume Samples
These are some examples of accomplishments 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.
- Delivered dependable, accurate, and timely information to our database users through normal operations, database maintenance, and emergency responses.
- Researched functions and implemented recommendations from the SQL Server DBA team.
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, transaction log file sizes, backup/restore, and performance tuning.
- Collaborated with database administrators on the design of databases and related reporting functions.
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 SQL Server.
- Conducted research into SQL Server production systems to ensure that all hardware and software requirements were met.
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 the accuracy of data and that processes are followed, loading data into a 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 the 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 a few bugs in Microsoft Cluster and SQL Virtual Servers.
- Eliminated duplicative information, improved database security with hardware components and software patches, troubleshot hardware issues not related to activity, and researched new database features for future enhancements.
- Keep the daily progress of the project and make status reports.
SQL Server DBA
- Worked with the system administration team to have Windows 2012 R2 VM servers created with the standard configuration of a 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.
- Ensure that high standards of software development QA are met; successfully execute all testing plans and procedures to maintain software quality.
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).
- Support, strengthen, and expand the existing development team’s ability to track critical information in a timely manner.
- Plan, design, code, and test SQL Server databases in a large-scale corporate application programming environment.
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 set up snapshot replication from production to Development and stage environments.
- Act as “go-to guy” for server problems; troubleshoot issues related to network communications and provide solution recommendations for resolution.
- Introduced and trained new programmers on the use of Microsoft SQL Server.
SQL Server DBA
- Executed Data migrations from one database structure to another Using SSIS Review and Migrated Stored Procedures.
- Responsible for maintaining High availability servers like Clustering and transactional Replication.
- Implemented Point in time Backup and Recovery Plans of all databases and maintained documentation.
- Good experience in Maintaining Production Servers, Monitoring Performance issues, Trouble Shooting, and Solving Production Issues.
- Trained DBAs to work on SQL Server forums, server dumps, and the intricacies of SQL Server coders.
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 the development and test environment.
- Trained DBA’s to file service requests for any concerns about database files, data missing in backups, or operating system errors.
- Helped train new DBAs on how to interpret T-SQL commands passed from event handlers as well as commit changes to database files.
Wrap Up
Resumes are a crucial aspect of any job search. In order to make a good first impression, it is important that your resume be formatted and written professionally.
Hope these samples gave you an idea of what your resume should look like and some tips on how to make sure that your resume stands out from the rest.
Contents