sql server database administrator Resume Examples

sql server database administrator
Build My Resume

Andrew Smith

287 Custer Street, Hopewell, PA 00000
[email protected]
(000) 000-0000

Professional Summary

 Dedicated and hardworking database administrator with 5 years of experience working in the field. Committed to ensuring complete database organization and security. Excel at database modification and improvement. Exceptional analytical, problem-solving, and communication skills. Excellent attention to detail and experience with numerous types of database software. Ability to work well on a team and individually. 

Employment history

SQL Server Database Administrator, Ruecker, Stark and Okuneva. South Almedatown, Missouri
May. 2019 – Present
  • Plan the database side of a server migration, taking our systems from SQL 2008R2 and 2012 to SQL 2016 and 2016
  • Document and communicate database schemas, using accepted notations.
  • Plan and install upgrades of database management system software to enhance database performance.
  • Provide technical support to junior staff or clients.
  • Set up database clusters, backup, or recovery processes.
  • Monitor and report systems resource consumption trends to assure production systems meet availability requirements and hardware enhancements are scheduled appropriately.
  • Test changes to database applications or systems.
  • Develop, Maintain, and migrated legacy SSIS packages. 
SQL Server Database Administrator, Purdy, Zemlak and Cronin. Tillmanmouth, Florida
Dec. 2017 – Jan. 2018
  • Demonstrate database technical functionality, such as performance, security and reliability.
  • Collaborate with system architects, software architects, design analysts, and others to understand business or industry requirements.
  • Create and enforce database development standards.
  • Develop and document database architectures.
  • Develop and maintain archived procedures, procedural codes, or queries for applications.
  • Develop and maintain archived SSIS packages. 
Jr. DevOps Engineer, Harris, Romaguera and Kihn. East Jacinto, Montana
Jan. 2016 – Feb. 2016
  • Run proprietary publishing process (web application, SQL queries, scripts) to move eLearning courses from development to production. 
  • Ensure web assets (csv, html, xml, images, media files) are installed in the appropriate repositories and meta data is loaded into databases. 
  • Run queries and scripts to QA check business rules and validate the entire process has run successfully and/or to correct any anomalies in the process. 
Business Analysis Intern, Ankunding Group. Porschechester, Washington
Oct. 2015 – Nov. 2015
  •  Provide routine technical assistance to departmental staff for development, project planning, testing, report writing, queries, analysis, and troubleshooting. 
  • Gathering department requirements, coordinate timelines, develop scripts, test scripts, create end-user front end and train users. 

Education

Southern South Carolina College, Port Herman, West Virginia
Associate of Arts, Database Management and Design, Oct. 2016
Southern McDermott, Lilliantown, South Carolina
Associate of Arts, Health Infomatics and Integrated Technology, Jan. 2015

Skills

SSRS
SSIS
T-SQL
Database Aministration
Build My Resume

Andrew Smith

287 Custer Street, Hopewell, PA 00000
[email protected]
(000) 000-0000

Professional Summary

 
·       4+ years of experience in Database Administration and supporting for very large and complex databases in SQL Server 2016,2012, SQL Server 2008 R2, 2008 and 2005. 
·       Worked extensively on Clustering and server consolidation. Troubleshooting production issues and raising high availability. 
·       Installing, configuring and maintenance of SQL Server as per the client requirement. 
·       Troubleshoot performance problems, fine-tuning of databases and index Analysis. 

·       Worked on SQL Server 2012 migration from SQL Server 2008 / 2005. 

·       Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities. 

·       Rebuilding / Monitoring the indexes at regular intervals for better performance. 
·       Worked on upgrading (In place, Side-by-side) Sql server from one version to another. 
·       Worked with customers on Application rollouts and server migrations. 
·       Perform SQL Server service pack and Windows Service pack upgrades. 
·       Performed day to day DBA activities such as monitoring SQL Server health, job status, addressing user requirements. 
·       Safeguarding data by instilling backup, managing user access and securing databases. 
·       Took responsibility of maintaining the SQL Server instances to ensure software is properly installed, security patches were applied, and upgrades were done. 
·       Scheduled full, differential, and transactional log backups for user created databases in production environments. 
·       Involved in troubleshooting various database server issues to free up log space, update statistics, configure number of locks, create databases and match their data, log patterns with contingency. Performed many database upgrades using import/export. 
·       Expertise in Database Administration on Production Servers with server configuration, maintenance with outstanding troubleshooting capabilities. 
·       Outstanding knowledge in tuning the query and expertise in Performance Tuning. 
·       Well versed in handling performance issues (Blocks, deadlock, indexes, CPU utilization, Memory utilization) for Windows and SQL Servers. 
·       Experience in Managing, Monitoring, Security and Troubleshooting SQL Server. 
·       Experience in Database Backup, Recovery, Restoration and Disaster recovery plans involved in DR test. 
·       Expertise in creating Maintenance plans, Jobs, Alerts using DB-Mail and applying Service packs for SQL Server. 
·       Experience in Upgrading and Migrating databases from SQL Server 2005, 2008, 2008 R2 and 2012 
·       Expertise in Applying Service packs and hot-fixes on SQL Server which involved in HA. 
·       Configuring and Maintaining and troubleshooting the Database Log Shipping. 
·       Extensively troubleshooting and Implementing the Database Mirroring including modes (High Performance, High Safety and High Safety with witness) 
·       Handling connectivity issues, providing access as per the requirement. 
·       Experience in setup and administration of SQL Server Cluster on 2012. 
·       Creation of Logins and Role and Permission Granting. 
·       Extensively troubleshooting and implementing the Cluster environment. 
·       Configuring and Maintaining and troubleshooting the Always on. 
·       Experience in SQL server Replication (Snapshot and Transaction Replication) 
·       Rebuilding / monitoring the indexes at regular intervals for better performance. 
·       Experience in using SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor (DTA). 
·       Experience in using DMV and dynamic management functions for finding out long running queries. 
·       Processing the client request on 24x7 Database supports, which comes in the form of ticket. 
·       Experience in handling ONCALL. 

Employment history

SQL Server Database Administrator, Runolfsdottir-Miller. Ebertstad, Louisiana
May. 2019 – Present
 
·       Database Administrator, Database Programming. 
·       Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users. 

·       Rebuilding the indexes at regular intervals for better performance 

·       Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented. 

·       Monitoring Log shipping related jobs such as Backup, Copy, and Restore Jobs. 
·       Involved in trouble shooting and fine-tuning of databases for its performance and concurrency. 

·       Monitored and modified Performance using execution plans and Index tuning. 

·       Rebuilding the indexes at regular intervals for better performance. 

·       Deploying new code base release to UAT and Production Environments. 

·       Perform SQL Server service pack and Windows Service pack upgrades. 

·       Working with customers on Application rollouts and server migrations. 

·       Extensively worked on Enterprise Manager for managing the database. 

·       Troubleshoot performance problems and fine-tuning of databases. 

·       Involved in Index Analysis and Performance Tuning. 

·       Recovering the databases from backup in disasters. 

·       To analyze long running slow queries and tune the same to optimize application and system performance. 

·       Monitoring Log shipping related jobs such as Backup, Copy, and Restore Jobs. 

SQL Database Administator, Wolf-Greenfelder. Port Marin, Wisconsin
Nov. 2015 – Jul. 2016
 
•            Installation and configuring of MS SQL Server and Applying service packs & cumulative updates. 

•            Monitoring and managing large databases which are in production environment. 

•            Experience in handling process related in Banking Environment 

•            Scheduling backups using SQL Server Maintenance plans. 

•            Creating and administrating database and data files. 

•            Experience in handling database refresh activities on databases 

•            Adding the required User Logins, Groups and Users. 

•            Granting and Revoking Permission to/from the Users. 

•            Backup and restore of the SQL server databases. 

•            Migration of the databases from one server to another server. 

•            Managing Transaction log files and disk space availability for the databases. 

•            Troubleshooting the SQL Server Jobs and database issues. 

Education

Southern Braun Academy, Huelshire, Idaho
Bachelor of Science, Electronics and Communication Engineering, Dec. 2014

Skills

Linux
Skillful
Windows
Expert
SQL SERVER
Expert
Use This sql server database administrator Resume Template

Not in love with this template? Browse our full library of resume templates

boy

Build your resume in 15 minutes

Use professional field-tested resume templates that follow the exact resume rules employers look for.
Build My Resume

Related Resumes & Cover Letters

More Job Descriptions for :

1

sql server database administrator

  • Ascertaining an organization’s information management requirements and designing a database to fulfill them.
  •  Installing new databases, maintaining existing databases, and transferring data between databases as and when needed.
  • Designing and implementing processes and solutions for data distribution and data archiving.
  • Developing and implementing backup and recovery plans to avoid the possibility of data loss in case of a crash.
  •  Securing the data by giving access only to those who are authorized as well as restricting and preventing access to others.
  •  Monitoring disk space, storage capacity, and server performance constantly to prevent bottlenecks.
  • Identifying, analyzing, and fixing database problems when needed.
2

senior sql server database administrator

  • Responsible for the health and stability of global Microsoft SQL Server and related technological platform.
  • Setup and Management of mission critical databases in SQL Server Fail over Clustering, Mirroring, Log-Shipping, Always On Cluster.
  • Administration of Install, Upgrade, Migration, Service Pack and CU up-gradation of SQL Server 2005, 2008, 2008 R2 and SQL Server 2012.
  • Performance tuning of SQL Server using Index tuning, Profiler, Perfmon, Database Tuning Advisor and DMVs.
  • Evaluation of SQL Server environment by providing standards for installation, Configuration,Storage, CPU, Memory, I/O, accounts and Security to follow Microsoft Best practices and standard.
  • Documentation and troubleshooting , Even and Incident Management and DBA support.
  • Assessment of Database designs and Health checkups for Optimization and performance enhancements.
3

sql server database administrator

  • Plan the database side of a server migration, taking our systems from SQL 2008R2 and 2012 to SQL 2016 and 2016
  • Develop, Maintain, and migrated legacy SSIS packages. 
  •  Strong knowledge of Microsoft SQL Server 2008 R2 / 2012 / 2014 /2017at administrative and dev levels 
  • (Installation, index and table maintenance, backups ,SQL language, Stored Procedures, etc. etc.)
4

sql server database administrator

  • Help write and optimize in-application SQL statements
  • Ensure performance, security, and availability of databases
  • Prepare documentations and specifications
  • Handle common database procedures such as upgrade, backup, recovery, migration, etc.
  • Profile server resource usage, and optimize and tweak as necessary
  • Collaborate with other team members and stakeholders.
  • Analyze existing SQL queries for performance improvements
5

sql server database administrator

  • Strong knowledge and experience as data base technical support.
  • Executing periodic DR drills as per the guidelines setup by RBI for Disaster recovery planning and procedures.
  • Responsible for handling various audits conducted in the bank such as SOX, Statutory and Internal Audit.
  • Data provisioning and follow up meetings with Auditors for Closure of open Audit points.
  • Assessment, Setup, Monitoring and troubleshooting of Processes for routine database Maintenance and house keeping activities and continuously reviewing them.
  • Review meetings with the vendors, outsourced staff to target the problem areas for better operational efficiency.
  • Attended meetings and special sessions of Leadership and Executive Leadership Teams and contributed to major administrative initiatives, policies and decisions.

Other Great Resumes & Cover Letters from this Industry:

Suggested Reading:

Related Articles

Resume Design Tips and Tricks

Resume Design Tips and Tricks

Creating a resume that stands out from the rest doesn’t have to be rocket science. With just a few tips and tricks, you can make your professional resume a shining...

Read more