SQL Server DBA Job Description
SQL server DBA
provides server administration with a variety of database products that include Oracle, SQL Server, and SYBASE.
SQL Server DBA Duties & Responsibilities
To write an effective SQL server DBA job description, begin by listing detailed duties, responsibilities and expectations. We have included SQL server DBA job description templates that you can modify and use.
Sample responsibilities for this position include:
Set up and optimize high-availability and clustering solutions
Manage vendor datasets (pricing, security, fund performance, economic)
Performance tuning for SQL Server stored procedures, functions, views, SSIS packages and SSRS reports
Participate in enterprise wide security audits
Ensure SQL data assets are available for use by applications
Assists in the design of data models and physical databases, data dictionaries and schemas
Installs, upgrades and tests database software
Monitors database environment
Monitors database growth and activities
Manage development, QA/UAT and production environments
SQL Server DBA Qualifications
Qualifications for a job description may include education, certification, and experience.
Licensing or Certifications for SQL Server DBA
List any licenses or certifications required by the position: MCITP, MVP, MCTS, SQL, MCSE, MCDBA, MCSA, ITIL, MS, MTA
Education for SQL Server DBA
Typically a job would require a certain level of education.
Employers hiring for the SQL server DBA job most commonly would prefer for their future employee to have a relevant degree such as Bachelor's and University Degree in Computer Science, Education, Information Systems, Engineering, Technical, Information Technology, Administration, Business, Business/Administration, Management
Skills for SQL Server DBA
Desired skills for SQL server DBA include:
High Availability options for SQL Server
Index management
Indexes
T-SQL
Statistics
SSIS
Windows Server administration & an idea about proper disk configurations
Integrity checks
Security
Clustering
Desired experience for SQL server DBA includes:
Bachelor's degree in an IT field related to database administration
A minimum of five years of full-time SQL Server Database Administration and/or Engineering experience
Knowledge and understanding of MSSQL High Availability and Disaster Recovery options and where those technologies would apply to fill a requirement
The ability to troubleshoot and resolve database performance problems using native monitoring tools
Experience with Windows Server 2003 and 2008R2 and the proper disk configuration and layout to support large, scalable SQL Server environments
Basic knowledge of Reporting Services and scale-out SSRS farm configurations
SQL Server DBA Examples
1
SQL Server DBA Job Description
Job Description Example
Our company is growing rapidly and is looking to fill the role of SQL server DBA. To join our growing team, please review the list of responsibilities and qualifications.
Responsibilities for SQL server DBA
- HA technologies such as clustering and standby databases
- Monitor database health - availability, reliability, performance, capacity planning, server clustering, replication, re-indexing
- Work with Developers/Users to resolve data conflicts and inappropriate data usage
- Understanding of Microsoft Windows Server Technologies
- Design solutions, perform POCs and help Level 2 and Level 3 DBAs in development and implementation of solutions
- Install, configure and deploy MS SQL Server
- Migrating databases
- Establish and maintain database user accounts
- Creates updated solution (diagrams, code, test plans, ) in support of incident and problem management
- Set and administer standards for overall organization's SQL Server relational database structure / architecture
Qualifications for SQL server DBA
- Extensive knowledge of High Availability and Disaster Recovery options for SQL Server
- Familiar with components of SQL Server and troubleshooting of SQL Server issues
- Experience with Microsoft SQL Server 2012 Enterprise on Windows Server 2008 is required
- MS Windows Server 2008 Enterprise is required
- MS SQL Server certification 70-432 is a plus
- Bachelor’s Degree or Master’s degree in a technical field such as Computer Science, Information
2
SQL Server DBA Job Description
Job Description Example
Our company is growing rapidly and is searching for experienced candidates for the position of SQL server DBA. Thank you in advance for taking a look at the list of responsibilities and qualifications. We look forward to reviewing your resume.
Responsibilities for SQL server DBA
- Maintain, tune, monitor and administer both development and production SQL Server application databases and application-tier technology components
- Designs, tests and installs database management systems for use with business applications
- Monitor, resolve and implement incidents, service requests, changes and problem tickets requested by the applications teams providing hands on DBA support
- Ensure that proper root cause analysis is completed on all Database Problem tickets and that solutions are implemented across the enterprise of servers
- Constructs database specifications, provides fault isolation and resolution, tunes database applications for optimum performance, and implements disaster recovery and contingency plans as required by the business
- Responsible for the control, integrity, and accessibility of the database file structure of databases with multiple concurrent users
- Research database technologies, determine business requirements, propose changes, and develop migration and implementation plans, may execute projects based on these activities
- Ensure plans for database technologies integrate effectively with other aspects of the technical infrastructure
- Enterprise Oracle RDBMs Deployments and PLSQL
- Enterprise Technologies such partitioning, log mining, replication and messaging
Qualifications for SQL server DBA
- A bachelor's degree in an IT field
- 2 years of recent SQL Server DBA experience which includes SQL Server 2012
- Must be able to demonstrate strong technical skills in the use of the components of SQL Server and troubleshooting of SQL Server issues
- Have the ability to work well with all types of customers
- Thorough understanding of Windows OS Powershell scripting and Active Directory integrations with SQL Server
- Minimum 5 years of work experience as a Database Administrator
3
SQL Server DBA Job Description
Job Description Example
Our growing company is hiring for a SQL server DBA. If you are looking for an exciting place to work, please take a look at the list of qualifications below.
Responsibilities for SQL server DBA
- Automated deployment and monitoring of database systems
- Requirement translation
- Responsible for technical delivery of assigned projects
- Technical mentoring of junior DBA's
- Proactively monitor capacity of environments to predict future storage, memory, or processor shortfalls
- Provide initial diagnosis/troubleshooting to resolve incidents
- Independent worker capable of supporting, troubleshooting, and resolving production database issues
- Database reporting using third party tools and/or Microsoft BI
- Working with VMWare virtual environment
- Collaborate with R&D teams to design data structures and processes
Qualifications for SQL server DBA
- A bachelor's degree in an IT field or related
- Knowledge of enterprise storage platforms such as EMC, NetApp
- 10+ years’ experience in MS SQL Server production support
- Excellent SQL Server database administration skills in production support, project delivery or engineering capacity
- Highly self-motivated individual who has the ability to work independently in a team environment
- Knowledge of .Net Framework and application development with C#, ASP, VB
4
SQL Server DBA Job Description
Job Description Example
Our growing company is hiring for a SQL server DBA. We appreciate you taking the time to review the list of qualifications and to apply for the position. If you don’t fill all of the qualifications, you may still be considered depending on your level of experience.
Responsibilities for SQL server DBA
- Minimum of 12 months of experience with Microsoft SQL Server Integration Services (SSIS)
- Apply the data retention policy
- Cleanup useless data and structures to keep a clean environment
- Increase the automation level of recurrent tasks and health checks
- Ensure knowledge sharing
- Trouble-shoot poor performing stored procedures, tune database & query performance
- Create & review databases and coordinate changes during deployment
- Develop solutions to problems of unusual complexity which require a high degree of ingenuity, creativity, and innovativeness
- Conduct system maintenance verifying all instances are up, applications services are on-line, database backup successfully and archived to tape
- Verify concurrent managers are operational and there are enough resources for acceptable performance
Qualifications for SQL server DBA
- Involvement with the MSSQL Server Community
- Typically requires a Bachelor’s degree in Computer Science, Information Systems or related discipline and nine or more years progressive experience in database administration
- Exposure to Quest Foglight, is preferred
- Participate in planning, design, implementation, and testing of new and changing database configurations
- Provide DBMS and database knowledge to developers, business analysts, testers, and others as needed
- Develop queries, stored procedures, triggers, and scripts as needed
5
SQL Server DBA Job Description
Job Description Example
Our company is searching for experienced candidates for the position of SQL server DBA. We appreciate you taking the time to review the list of qualifications and to apply for the position. If you don’t fill all of the qualifications, you may still be considered depending on your level of experience.
Responsibilities for SQL server DBA
- Design and implement processes and standards for database systems recovery and back-up checks user performance and data security
- Investigate and resolve technical database issues
- Own, resolve, and track all database incidents and requests across production, UAT, and development environments
- Work closely with other IT resources
- Understand NCE-Active IT baseline capabilities
- Supporting the Certification and Accreditation process - running SRR
- Ensure the accessibility and integrity of the systems and data used in the services offered to our clients
- To verify the existence, the good functioning and the continuous improvement of the processes required for the support, the maintenance and the evolution of the systems
- Evaluate and identify changes to infrastructure following the introduction of new systems, services or process changes
- Complete extract queries for internal and external clients from different databases
Qualifications for SQL server DBA
- 3 years of experience supporting design and architecture of database schemas with an emphasis on data analysis and modeling required
- Proficiency in performing database administrative tasks
- Microsoft Certification in SQL related competencies is a plus
- Expert-level understanding of SQL server maintenance procedures
- Ability to work in a team environment with experienced professionals
- Background in corporate job schedulers