SQL Database Administrator Resume Sample
Work Experience
- SQL Server Software Installs, Upgrades in version 2008r2, 2012 & 2014
- Performance tuning of the Database both at the application level (SQL) as well as instance
- Experience in building and modifying stored procedures, functions, creating tables and views with Strong T-SQL skills
- Experience in Development using SQL Server Integration Services (SSIS)
- Performance Tuning: Reviews monitoring tools and query execution plans to maintain or increase query efficiency. Also performs root cause analysis on query performance issues
- Database Development: Works with application developers to deliver data through the design of stored procedures, functions and views
- Develops database architecture and standards
- Configures and upgrades database software
- Maintains the overall enterprise database architecture including number of instances and how each is used
- Designs and implements databases in conjunction with the application development and Enterprise Data Analyst teams
- Provides consultation and trouble shooting for the development team
- Implements and maintains database security
- Provides 7X24 database support for production databases
- Operationally Reports to :Department Head – ITCC
- Internally: Teams: DBA, Security, Network, Storage, Systems and SES Team
- Externally: Software Vendors like Microsoft
- B.E in Computer Science, IT or ECE from reputed university and 6 – 8 years’ experience in IT Consulting
- Strong technical skills in SQL Server Database Administration
- Strong technical skills in Windows Operating System Administration
- Experience in co-ordination with various teams
- Experience in onsite/offshore co-ordination
- Service oriented mind
- Team Spirit and ability to take flexible timing
Education
Professional Skills
- Strong interpersonal skills and ability to communicate effectively with technical staff as well as non-technical users both verbally and in writing
- Excellent time keeping, prioritisation, and organisational skills
- Excellent written and verbal communication skills required with the ability to communicate effectively to a diverse group of IT professionals
- Strong communication, critical thinking and problem-solving skills
- Strong attention to detail problem solving and troubleshooting skills
- Demonstrates solid skills in shell scripting
- Strong troubleshooting skills with an attention to detail and ability to follow process
How to write SQL Database Administrator Resume
SQL Database Administrator role is responsible for sql, database, troubleshooting, t-sql, administration, server, advanced, microsoft, scripting, technical.
To write great resume for sql database administrator job, your resume must include:
- Your contact information
- Work experience
- Education
- Skill listing
Contact Information For SQL Database Administrator Resume
The section contact information is important in your sql database administrator resume. The recruiter has to be able to contact you ASAP if they like to offer you the job. This is why you need to provide your:
- First and last name
- Telephone number
Work Experience in Your SQL Database Administrator Resume
The section work experience is an essential part of your sql database administrator resume. It’s the one thing the recruiter really cares about and pays the most attention to.
This section, however, is not just a list of your previous sql database administrator responsibilities. It's meant to present you as a wholesome candidate by showcasing your relevant accomplishments and should be tailored specifically to the particular sql database administrator position you're applying to.
The work experience section should be the detailed summary of your latest 3 or 4 positions.
Representative SQL Database Administrator resume experience can include:
- Excellent communication skills and ability to build a good rapport with colleagues
- Good team working skills and capable of working alone
- Strong analytic skills, strategic vision, and logical approach to problem solving
- Strong planning, organizational and documentation skills
- Possess excellent written and verbal communication skills, demonstrating the ability to present material to senior DOD and non- DOD officials
- Excellent communication skills and the ability to work both independently and collaboratively with systems teams are required
Education on a SQL Database Administrator Resume
Make sure to make education a priority on your sql database administrator resume. If you’ve been working for a few years and have a few solid positions to show, put your education after your sql database administrator experience. For example, if you have a Ph.D in Neuroscience and a Master's in the same sphere, just list your Ph.D. Besides the doctorate, Master’s degrees go next, followed by Bachelor’s and finally, Associate’s degree.
Additional details to include:
- School you graduated from
- Major/ minor
- Year of graduation
- Location of school
These are the four additional pieces of information you should mention when listing your education on your resume.
Professional Skills in SQL Database Administrator Resume
When listing skills on your sql database administrator resume, remember always to be honest about your level of ability. Include the Skills section after experience.
Present the most important skills in your resume, there's a list of typical sql database administrator skills:
- Experience with strong experience in handling large scale SQL Server consolidation and migration
- Strong skills with TSQL and experience in a large enterprise
- Strong Programming and Shell scripting skills (Perl)
- Excellent interpersonal, planning, documentation, organization, and problem solving skills
- Good business analysis skills and a detailed understanding of one or more subject areas of the bank
- Work in a team environment, presenting a professional image with good verbal and written communication skills
List of Typical Experience For a SQL Database Administrator Resume
Experience For Senior SQL Database Administrator Resume
- Strong interpersonal, collaborative and creative problem-solving skills
- Excellent organizational/project management and analytical skills
- Strong organization skills to manage multiple timelines and complete projects quickly within the constraints of timelines and budgets
- Expert skills in inserting and updating SQL statements in T-SQL
- Expert skills in SQL queries, table joins, where causes, grouping, temp tables in T-SQL
Experience For Microsoft SQL Database Administrator Resume
- Expert skills in creating tables, views, complex stored procedures, scalar and table user defined functions in T-SQL
- Strong experience in monitoring and tuning MS SQL Server databases for optimum performance and assistance in capacity planning of database servers
- Think Logically: Top-notch logical skills that includes ability to make sense of complex systems and understand how things work and problems arise
- Strong operational support experience (5+ years) of MS SQL Server in an enterprise environment
- Additional Skills/Familiarity with
- Strong Hands-on SQL administration, reporting and integration related experience
- Demonstrated in-depth knowledge of database internals and data structures. Hands-on experience with database optimization and tuning
- (optional) SQL Azure (or other Azure DB related skills)
- Proven ability to collaborate, learn from and educate other experienced DB2 DBAs
Experience For Junior SQL Database Administrator Resume
- Proven experience in the ability to carry out L4 and above activities
- Microsoft SQL database administration and/or development skillset
- Thorough database design and analysis skills
- Working experience with database support for ASP.NET applications in a hosted environment
- Experience in providing HA solutions like mirroring, Log shipping, replication, clustering & Alwayson
- Experience performing SQL server installations, upgrades, and installing patches
Experience For Windows Server & SQL Database Administrator Resume
- Experience performing database server backups, planning backup strategy and schedule
- Experience of Microsoft operating systems, server hardware and networking
- Experience working with ticketing systems (Remedy, Support Works etc.)
- Solid level understanding of SQL Server administration and troubleshooting
- Solid understanding of data access configuration, including SQL Server to SQL Server, and SQL Server to Oracle
- Solid understanding of Windows Server 2008 and 2012 clustering
Experience For Oracle / SQL Database Administrator Resume
- Solid understanding of network tracing utilities
- Strong troubleshooting and performance tuning ability
- Database Administration experience MS SQL Server (including performance tuning and optimization, backups, restores and recovery)
- Experience supporting a managed DBA services offering
- Experience installing and configuring SQL independently
- Strong working knowledge of database software and operating systems
Experience For Development SQL Database Administrator Resume
- Knowledge of Server/PC operating systems including Windows 2008 R2 and 2012R2; VMWare experience
- Experience in optimizing performance through indexing and query optimization
- Sound experience in setting up different HA and DR solution using SQL Server
- (optional) Experience installing/configuring SSRS/SSAS solutions
- Strong understanding of Microsoft SQL, SQL Replication, Clustering, Windows concepts
- Previous experience with Performance Tuning and Optimization, Back-ups and Restores, SSIS, Indexes, Capacity planning, and Data Security
- Familiar with basic Azure IaaS and PaaS capabilities, and experience with designing and building MS SQL databases within Azure
Experience For SQL Database Administrator Senior Resume
- Experience with SQL Business Intelligence utilizing SQL Server Analysis Services and SQL Server Reporting Services
- Experience with Online Analytical Processing (OLAP) and Online Transaction Processing (OLTP)
- Strong working knowledge of monitoring tools such as Redgate; SQL Sentry etc
- Experience with database monitoring and troubleshooting
- Experience writing and maintaining with SSIS packages
- Experience working as a Microsoft SQL DBA leveraging versions 2008r2 or later
- Experience with database technologies, enterprise database operations, and migrations, including acting as a primary DBA
- Extensive experience writing T-SQL, stored procedures, and functions, and query tuning on high-transaction
- Possess at least 4 years’ experience designing and implementing SQL databases,
Experience For SQL Database Administrator / Developer Resume
- Familiar with basic Azure or cloud IaaS capabilities, and some experience designing and building MS SQL databases within Azure or AWS
- Solid understanding of database performance tuning strategies
- Excellent knowledge in SSIS, SSRS and Data Warehousing using the Kimble methodology
- Knowledge of Server/PC operating systems including Windows 2008 R2, iSeries; VMWare experience
- Experience Data Manipulation and troubleshooting Database Environments applications stop working
- Experience using Microsoft SQL server 2000/2005/2008 and High Availability Clustering
Experience For EHM SQL Database Administrator Resume
- Experience designing and deploying automated alerts when errors occur or performance moves below tolerable thresholds
- Experience in Database Mirroring, log shipping and DR procedures
- Experience installing/administering clustered MSSQL 2012 instances
- Experience configuring and administrating MSSQL technologies outside the relational engine (SSIS, SSRS, SSAS)
- Has good understanding of product or of supporting database technology
- Experience in preparing RCA
Experience For Lead SQL Database Administrator Resume
- Experience in any ticketing tools
- SQL Server Capacity Planning, Consolidation & Virtualization
- Experience managing Oracle Real Application Clusters and SQL Server Clusters
- Experience leading database team
- Experience designing index and statistics strategies
- Experience in troubleshooting database performance related issues
List of Typical Skills For a SQL Database Administrator Resume
Skills For Senior SQL Database Administrator Resume
- Strong T-SQL skills required and other scripting language skills (VBScript, PowerShell, etc.) desired
- Strong project management requirements gathering and analytical skills
- Demonstrates fluency in RMAN skills
- Strong experience of project management principles to plan, schedule, execute, and prioritize
- Team player with strong intercommunication skills and the ability to provide clear documentation of production processes as necessary
- Have effective communication skills both verbally and written
- Advanced troubleshooting skills utilizing Profiler and the Extended Events system
- Good Windows operating system experience is needed along with PowerShell scripting
Skills For Microsoft SQL Database Administrator Resume
- Proven experience with SQL performance tuning, including indexes, statistics, and query optimization
- Work experience with a proven track record of working as a Microsoft SQL DBA leveraging versions 2008r2 or later
- Olid experience with T-SQL, database admin, including server maintenance, security monitoring
- Demonstrated experience solving performance tuning challenges within a data analytics environment: ETL load times, SQL query times, etc
- T-SQL scripting skills are vital
Skills For Junior SQL Database Administrator Resume
- Sr DBA with architectural and engineering skills--
- Expert skills in T/SQL scripting and stored procedures
- T-SQL scripting and development skills
- Strong business sense and focus on delivering excellent customer IT service
- Strong experience with modeling large applications/Systems on MySQL/PostgresSQL technologies
- Database performance triage and proactive measures for effectively running database systems
- Expert level T-SQL Development and Tuning skills
- Strong experience in Microsoft SSRS; SSIS and ability to ensure efficient SQL is used – thereby ensuring performance is optimised
- Excellent documentation and project planning experience
Skills For Windows Server & SQL Database Administrator Resume
- Able to work effectively with client personnel in various organizational positions, IT managers and staff
- Able to communicate effectively with others outside the department
- Experience in SQL Server Database Administration Experience with SQL Server 2014/2012/2008
- Experience in T-SQL development. Experience with SSIS packages, SSRS and SSAS
- Operate under deadlines, set priorities, and handle heavy workloads
- Two (2) to three (3) years of solid experience in Database administration (SQL Server)
Skills For Oracle / SQL Database Administrator Resume
- Two (2) to three (3) years of solid experience in Data Warehouse
- Strong technology experience in MS-SQL database administration
- Microsoft SQL DBA and/or development skillsets
- Extensive experience of database management and administration experience with SQL Server 2008R2-2016 preferably in a production environment
- Proven 8 years of experience in implementation of DB related scripts/jobs
- Working technical experience with designing, building, installing, configuring and supporting Microsoft SQL Server 2008 R2 Reporting Services
- Engaging with various Application and Operate teams to ensure that accounts are correctly assigned to the appropriate Lines of Business
- Proven ability in designing, building, testing, implementing and supporting MS SQL 20XX Infrastructur solutions
- Solid understanding of MS SQL Server locking, indexing and error handling and performance tuning
Skills For Development SQL Database Administrator Resume
- Specific experience in documenting, establishing, and performing database performance monitoring and tuning
- Solid understanding of SQL Server replication and high availability solutions, including SQL Server failover clustering, log shipping, and database mirroring
- MS SQL Server 2008/2012 experience with Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools
- Specific experience in documenting, establishing, and performing database security - authentication, auditing, and encryption
- Experience in Performance Tuning and Optimization (PTO), using both native and Idera monitoring and troubleshooting tools
- Experience in designing, building, supporting and troubleshooting Oracle databases in an Enterprise environment
- Experience with SQL Server doing installs, tuning, backup and clustering (always on replication)
- Experience configuring the monitoring of SQL Server databases utilizing Spotlight, Foglight, and/or Solarwinds highly advantages
Skills For SQL Database Administrator Senior Resume
- Experience in Database management including updating statistics and rebuilding indexes
- Experience in all phases of project life cycle, starting from business requirement gathering and analysis to testing and deployment
- Experience with database migration, performance tuning, and optimization, and setting up and managing database connections
- Experience of delivering improvement through debugging code and optimising queries
- Specific experience in documenting, establishing, and performing database backup and recovery
- Experience with automating DBA tasks, database tuning and capacity planning
- Experience in securing a SQL environment to include applying and documenting DISA’s Security Technical Implementation Guides (STIGs)
Skills For SQL Database Administrator / Developer Resume
- Hands-on experience with SQL Server implementations including design, security, testing, troubleshooting, maintenance, optimization and support
- Experience of analysing Profiler traces and the output of SQL Server logs during troubleshooting
- Strong understanding of replicated storage, database mirroring, clustering, and technologies like SQL 2012 Always On
- Hands-on experience architecting, administering, and tuning data analytics solutions in Snowflake
- Experience developing, deploying, and refining system architectures and solutions within SQL Server
- A deep understanding of performance tuning methodologies and experience optimizing DB level objects
Skills For EHM SQL Database Administrator Resume
- Database maintenance including providing access, creating batch processes, device allocation and validation checks
- Knowledge and understanding of how to use Oracle Support Site Metalink and has had experience in creating service requests
- Experience with managing and maintaining SharePoint platforms is desired
- Strong knowledge of SQL AlwaysOn and Availability Groups features, Clustering, Database mirroring, Replication
- Experience with supporting .Net development teams and working with other O&M teams
Skills For Lead SQL Database Administrator Resume
- Experience of working with large-scale public-facing websites
- Practical experience with SQL Server clustering installation and trouble shooting
- Experience managing and tuning large, multi-terabyte SQL Server databases in a SAAS environment
- Experience with proactively identifying issues and driving them to resolution
- Experience with Windows Server operating systems or Linux/UNIX operating systems is required
- Familiarity with any of the following languages: Python, PowerShell - Experience using Microsoft products (e.g. Outlook, Word, Excel, SharePoint, etc.)
- Experience setting up and maintaining Disaster Recovery and Mirrored database instances
List of Typical Responsibilities For a SQL Database Administrator Resume
Responsibilities For Senior SQL Database Administrator Resume
- Strong SQL skills (2012 - 2016)
- Effectively work independently to identify issues and come up with options, then work with teams to implement
- Team collaboration and leadership skills
- Experience in upgrading SQL Server software to new versions and applying service packs and hotfixes
- Solid understanding of SQL Server 2008, 2012, 2014, and 2016
- Solid understanding of SQL Server index management
Responsibilities For Microsoft SQL Database Administrator Resume
- Solid understanding of Active Directory with respect to SQL Server security
- Solid understanding of Windows Server 2008 and 2012
- Solid understanding of remote server management
- On-call troubleshooting experience with at least one production SQL Server for a year
- Practice the ability to balance client requests and business needs/goals in prioritizing the team's work, and staff developmental opportunities
- The ability to manage a number of projects, and be able to adjust quickly to changing priorities in a dynamic environment
- Experience with SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS)
- Experience as a database administrator working on SQL Server 2012 and higher versions
- Good understanding of AWS cloud technologies such as RDS, EC2, S3 Storage, EBS Volumes and CloudWatch
Responsibilities For Junior SQL Database Administrator Resume
- Solid understanding of networks, storage, tiered application environments and security
- History of being a good team player who is flexible, shares knowledge, helps others, and collaborates well within and outside the team
- Experience with the following: Microsoft SQL Server; Microsoft Windows Server 2008/2012/2016; SQL Server Database Administration 2008 R2/2012/2016
- Experience in managing the SSIS, SSRS services in the production cluster & non cluster environment
- Extensive know-how of .Net Architecture and experience in implementing advanced concepts like Clusters
- Good understanding of various patch level compatibility with database releases
Responsibilities For Windows Server & SQL Database Administrator Resume
- Good scripting knowledge to implement DB related scripts/jobs
- Additional experience including
- IT Operations with strong understanding of database structures, theories, principles, and best practices
- Microsoft SQL Server administration experience, preferably in a hosting and/or corporate 24x7, highly available, environment
- Solid understanding of best practices for SQL Server administration
- Experience supporting web-based hosted applications
- Extensive experience in leading projects such as server migrations, version upgrades, and shared development environment refreshes
- Experience supporting a transactional replication environment
- Experience in T-SQL and PowerShell programming
Responsibilities For Oracle / SQL Database Administrator Resume
- Experience working in an Oracle and/or SQL Server environment with latest or recent versions of database software
- Experience working in a UNIX (Sun Solaris) and/or Windows Server environment
- Solid understanding of database backup and recovery strategies
- Excellent knowledge in developing SSAS cubes in SQL Server
- Proven Knowledge of MDX, powershell, tracing of stored procedures
- Experience with the various components in the Microsoft SQL Server Stack (db engine, integration services, reporting services, etc.)
- QL Server Database Administration Experience with 2+ years supporting SQL Server 2008 and 20012
Responsibilities For Development SQL Database Administrator Resume
- Experience using T-SQL in an operational database admin capacity
- Hands on experience with PowerShell or other similar automation scripting language
- Experience with SSIS and other ETL types of processing
- Experience managing high volume, high concurrency environments and multi-TB OLTP databases
- Experience with Idera SQL Monitoring Tools
Responsibilities For SQL Database Administrator Senior Resume
- IT operation with strong understanding of database structures, theories, principles, and practices
- Experience migrating from 2005/2008 environment to 2012
- Experience with dimensional and relational modeling
- Experience in supporting world class data centers
- Experience maintaining large number of database instances (1000+ databases in store & corporate environments)
- Experience with high availability solutions such as but not limited to Always On Availability Groups and Database Mirroring
- Proven exposure with SQL DB2, Data Stages and CDC,Shell Scripting
- Experience with Failover clustering and SAN replication
- Experience inMicrosoft SQL Server performance tuning
Responsibilities For SQL Database Administrator / Developer Resume
- Experience in Microsoft SQL Server clustering
- Experience working in a SQL database environment
- Advanced experience in SQL design, planning, development, and performance tools
- Strong knowledge of SQL Server tools (Profiler, DTA, SSMS, SAC, SSCM, PerfMon, DMVs,) including third party product tools
- Strong knowledge of Microsoft operating systems, security delegation, SPNs, and storage components
Responsibilities For EHM SQL Database Administrator Resume
- Experience with BI, reporting, and analytical tools (Power BI, Tableau)
- Experience working in an Agile SDLC environment, JIRA software
- Experience with managing SQL database in Microsoft Azure (SQL Azure, Managed SQL Server instances)
- Solid, recent knowledge of Microsoft SQL Server (SQL Server 2012 and 2016) and the Standard and Enterprise Edition feature sets including
- Experience working with FTP
- Experience with Cloud technologies – Azure by moving data in-house to cloud
- Experience with Linux BASH or Shell scripting
- Experience with Microsoft SQL Server Integration Services (SSIS), Reporting Services (SSRS) and Analysis Services
Responsibilities For Lead SQL Database Administrator Resume
- Or more) of professional experience working as part of a defined group of technical individuals
- Experience collaborating with developers on database design within the framework of project work
- Experience with SQL Server Reporting Services, Analysis Services, Integration Services
- Experience with Powershell scripting, specifically for SQL Server administration
- Strong understanding of Database Controls and access
- Good working knowledge of al supported Windows versions
- Experience working with Team Foundation Server (TFS) in a fast paced, waterfall environment is highly desired
- Proven ability to diagnose & improve long-running queries