SQL Database Administrator Job Description
SQL database administrator
provides administrative support for high availability/disaster recovery aspects, understand Database failover/Switchover technologies for both Oracle & MS SQL Server.
SQL Database Administrator Duties & Responsibilities
To write an effective SQL database administrator job description, begin by listing detailed duties, responsibilities and expectations. We have included SQL database administrator job description templates that you can modify and use.
Sample responsibilities for this position include:
Manage and maintain clustered SAN environment
Provide administration of database systems including installation, upgrades, configuration, consolidation, monitoring, tuning, and maintenance
Maintain detailed documentation of the SQL Server environment
Implement database backup, disaster recovery and high-availability solutions
Maintain reporting and data integration processes using SSRS and SSIS
Develop custom database objects (T-SQL scripts, stored procedures, tables, views, functions
Install, upgrade, configure, and tune SQL Server 2008R2 analytic environments
Analyze relational and storage engine issues and provide appropriate solution
Implement monitoring solutions for analytical environment
Manage database backup and recovery processes
SQL Database Administrator Qualifications
Qualifications for a job description may include education, certification, and experience.
Licensing or Certifications for SQL Database Administrator
List any licenses or certifications required by the position: SQL, MCITP, IAT, MCDBA, II, MVP, MCTS, DBA, MCSE, MS
Education for SQL Database Administrator
Typically a job would require a certain level of education.
Employers hiring for the SQL database administrator job most commonly would prefer for their future employee to have a relevant degree such as Bachelor's and Master's Degree in Computer Science, Education, Information Systems, Information Technology, Technical, Engineering, Administration, Business, Design, Performance
Skills for SQL Database Administrator
Desired skills for SQL database administrator include:
Replication
Clustering
High Availability options for SQL Server
Indexes
Backups
Index management
DBCC commands
Recovery models
Restores
High Availability options for MSSQL Server
Desired experience for SQL database administrator includes:
Strong skills designing, developing and maintaining stored procedures, views, tables, T-SQL scripts, creating associated documentation
Perform data conversion and Server Migrations
High level of OLTP an OLAP/DSS database administration expertise
Bachelors degree in Computer Science or related field or completion of a technical training program in software development programming language and ten years business experience
High school diploma or GED and fifteen years experience will also qualify
Bachelor degree or current student in System Engineering, Computer Science
SQL Database Administrator Examples
1
SQL Database Administrator Job Description
Job Description Example
Our company is hiring for a SQL database administrator. Please review the list of responsibilities and qualifications. While this is our ideal list, we will consider candidates that do not necessarily have all of the qualifications, but have sufficient experience and talent.
Responsibilities for SQL database administrator
- Ensure databases backups are both scheduled and verified successful
- Develop logical/physical data models incorporating changes when appropriate
- Participates with Government and contractor technical staff to determine file organization, indexing methods, and security procedures for specific user applications.DJAM
- Maintain documentation of work maintenance of existing Standards and Procedures
- Documentation of work, maintenance of existing standards and procedures
- Manages and maintains data definitions for complex production, non-production databases
- Monitors database servers for resource utilization
- Performs backup and recovery and configures database parameters
- Responsible for database design, implementation, security and privileges
- Proactively monitor and maintain SQL Server production and test databases
Qualifications for SQL database administrator
- Proficient with MS SQL Server 2008 / 2012 administration including design, installation, configuration, implementation, and backup and recovery of enterprise environments
- Proficient with SQL Server Integration Service (SSIS), SQL Server Analysis Service (SSAS), and SQL Server Reporting Service (SSRS)
- 3 years experience as a database administrator doing code migration, database change management and data management through various stages of the development life cycle
- 3 years experience using Oracle or SQL Server
- RDBMS certification
- Experience in OS administration
2
SQL Database Administrator Job Description
Job Description Example
Our innovative and growing company is looking to fill the role of SQL database administrator. 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 database administrator
- General knowledge of Windows
- Capable of reading and writing technical documentation
- Capable of dealing with unclearities
- Monitors utilization for capacity planning
- Builds scripts automating the daily operations of database management
- Managing, monitoring and maintaining company databases
- Making requested changes, updates and modifications to database structure and data
- Maintaining database backup and recovery infrastructure
- Identifies database requirements by interviewing customers
- Maintains database performance by calculating optimum values for database parameters
Qualifications for SQL database administrator
- Support experience should include installation, setup and configuration, and troubleshooting with emphasis on data structures and file systems
- Expert level relational database management system (RDBMS) fundamentals and design principles, experience tuning databases and applications using such tools as original equipment manufacturer (OEM), Quest, or other tuning tools
- Microsoft SQL Administration Certified (ie
- Gives database related proposals to the customer
- Gets in contact to the database support team if database bug/issue found
- Level 5 Extensive and comprehensive experience
3
SQL Database Administrator Job Description
Job Description Example
Our innovative and growing company is looking to fill the role of SQL database administrator. 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 database administrator
- Monitor SQL Server
- Owning, tracking and resolving database related incidents and requests, fulfilling requests and resolving incidents within SLAs
- Participate in development, testing, and maintenance of application enhancements
- Monitor test results, and make appropriate recommendations
- Assist in overall system application documentation
- Responsible for continuing maintenance on assigned production systems
- Collaborate with other IT departments to ensure successful deployment and support of applications
- Follow departmental standards and guideline
- Research and recommend optimal database design criteria
- Create, develop, review and support the physical model and logical model
Qualifications for SQL database administrator
- Performs independently in routine situations
- Level 2 Very limited experience
- Limited ability to perform
- Level 1 No experience
- Limited knowledge
- No knowledge
4
SQL Database Administrator Job Description
Job Description Example
Our growing company is hiring for a SQL database administrator. 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 database administrator
- Manage weekly database restores to lower environments
- Perform regular database maintenance tasks such as rebuilding indexes, upgrades and storage management
- Diagnose and correct database failure conditions, escalating problems as appropriate
- Ensure optimal application performance via proper database maintenance and tuning
- Implementation of database change requests and new releases as required
- Execute data model and database code reviews, provide constructive feedback and follow-up
- Work within a team environment to ensure all database servers are backed up in a way that meets the business’s Recovery Point Objectives (RPO)
- Responsible for the planning, design, development, maintenance, and organization of all databases
- Administer databases for the data warehouse and various software packages
- Ensures data reliability/integrity so that the data warehouse and all database applications show accurate information
Qualifications for SQL database administrator
- Experienced in Microsoft SQL Server administration, preferably SQL Server 2008 R2
- Experienced in the use of Microsoft SQL Server Transact-SQL
- Applied Best Security Policies, access control and policy based management aligned with SOX including setting up SQL server in DMZ environment
- Updated codes for web (IIS) application
- Automated routine tasks through PowerShell scripts, SQL jobs and Task Scheduler
- Knowledge of other database technologies (Oracle, Sybase, DB2...)
5
SQL Database Administrator Job Description
Job Description Example
Our company is looking for a SQL database administrator. To join our growing team, please review the list of responsibilities and qualifications.
Responsibilities for SQL database administrator
- Experience using Extract, Transform, Load (ETL) tools and technologies for structured / unstructured content
- Experience evaluating existing ETL procedures and methods and making recommendations
- Data access control based on security and privacy settings
- Backup and recovery set-up and monitoring
- Promoting changes using standard procedures
- Leads a team which provides support 24/7 to global users
- Daily operational responsibilities include controlling and monitoring user access to the database
- Advise developers on the most efficient database designs (tables, datatypes, stored procedures, functions)
- Assume ownership of databases related problems
- Create, develop, and review the physical model created from the logical model, ensuring that the detailed physical design of data structures and databases complies with standards, guidelines and procedures recommended for all aspects of data modeling, database design, and maintenance
Qualifications for SQL database administrator
- SQL Server and Database Certifications are preferred
- Microsoft Great Plains Experience is preferred
- Practical Knowledge of High Availability (HA) and Disaster Recovery (DR) options for MS SQL Server versions 2005/2008/2012/2014
- Experience in Installation of SQL Server would be an advantage
- T-SQL (creating queries, scripts, tables, views)
- Analytical mindset with the ability to articulate thoughts clearly, be able to understand issues and devise specific database solutions