SQL Server Database Administrator Job Description
SQL server database administrator
provides primary DBA support for application databases, including space monitoring and managing security, backup and recovery, performance tuning, and database refresh processes.
SQL Server Database Administrator Duties & Responsibilities
To write an effective SQL server database administrator job description, begin by listing detailed duties, responsibilities and expectations. We have included SQL server database administrator job description templates that you can modify and use.
Sample responsibilities for this position include:
Working closely with IT to support physical database administration including performance management, security, installations, upgrades, patches, backup, recovery, space management, performance tuning and capacity planning
Ensure that all databases environments are deployed, maintained and managed via proactive monitoring of performance and capacity planning of RDBMS
Maintain backup and recovery process, including disaster recovery performance and tuning of database and application
Managing database backup and recovery
Managing database security, roles, and profiles
Ensure data requirements have been identified, design is fully normalized, and database complies with industry best practices and strict security requirements
Participating in design sessions with application engineers and will work closely with business analysts,who develop the business and software specifications for project objectives
Supporting the critical data and content migration teams will also be a significant part of the job
On-call support to maintain 7x24 coverage of the database environment
Provides business with day-to-day stable, and optimally designed, tested and implemented database environment that allows continued growth of our business partner’s globally
SQL Server Database Administrator Qualifications
Qualifications for a job description may include education, certification, and experience.
Licensing or Certifications for SQL Server Database Administrator
List any licenses or certifications required by the position: SQL, MCITP, MVP, MCTS, MCDBA, MCSA, DBA, MCSE, MS, ITIL
Education for SQL Server Database Administrator
Typically a job would require a certain level of education.
Employers hiring for the SQL server 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, Engineering, Technical, Information Technology, Administration, Business, Design, Management
Skills for SQL Server Database Administrator
Desired skills for SQL server database administrator include:
Security
Backup and recovery
Capacity planning
High Availability options for SQL Server
Configuration
DoD Security Technical Implementation Guides
Statistics
Data loading
Full system development life cycle
Index management
Desired experience for SQL server database administrator includes:
Interface with application development /support teams on production/development issues to ensure that all database related issues are resolved to completion and business partner’s satisfaction
Install, configure, maintain and report on software releases and patch levels across the environment
Database technical advice
Maintaining ongoing, effective communication with Project teams, 1st and 2nd level supporting teams and/or Developers, internal group staff, and other IT partners globally
Creating, validating and maintaining operational processes and documentation, establish training requirements and identifying potential resource requirements
Assisting with BCP/DRP planning and implementation
SQL Server Database Administrator Examples
1
SQL Server Database Administrator Job Description
Job Description Example
Our innovative and growing company is searching for experienced candidates for the position of SQL server 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 server database administrator
- Designing, developing, implementing, and providing operation support of database security
- Building and implementing database backup and recovery strategies
- Managing database growth, data purging/archiving
- Database monitoring, tuning, and troubleshooting
- Support Development Teams by implementing database objects in TEST/STG/PROD and through on call rotation
- Defining and implementing physical database layout
- Problem prevention, detection, and correction
- Design and maintenance of SSIS packages
- On call rotation, available for 24/7 support if contacted
- Implement database cluster
Qualifications for SQL server database administrator
- To provide support of database and transaction management technology and it’s deployment and usage standards
- To lead application development and support teams in optimal use of database and transaction management technology through creation and communication of standards and walkthrough of critical application components
- At least 2 years of experience in Database Support as a DBA
- At least 2 years of experience interfacing and collaborating with users, developers and teammates
- 5 years of experience in Database Support
- Microsoft Certified Professional, DBA - MS SQL Certification
2
SQL Server Database Administrator Job Description
Job Description Example
Our company is growing rapidly and is hiring for a SQL server 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 server database administrator
- Optimizes database access and allocates/re-allocates database resources for optimum configuration, database performance and cost
- Develops, implements and tests database backup and recovery policies and procedures
- Deployment of SSIS packages
- Write Unix shell scripts to automate DBA tasks
- Perform Production On call support on rotational basis
- Monitor database performance to ensure integrity of data and provide tuning of the database for optimal performance
- Identify need for hardware / software upgrades or replacements
- Administrative control of all databases, to include backup/recovery maintenance using integrated maintenance functions and secondary backup software
- Administrative control of all code on development and production, to include backup/recovery using integrated maintenance functions and secondary backup software
- Conduct Quality Assurance of content to ensure website NIPR requirements
Qualifications for SQL server database administrator
- Deep understanding of SQL Server monitoring technologies, such as Idera
- MSFT Clustering, HA, DR, Mirroring and other resiliency technologies
- Experience with SQL Server 2005, 2008, and 2012
- Undergraduate degree and 4+ years, or Graduate degree and 2+ years of experience in administering SQLServer Database Systems in a production environment
- Knowledge of SSIS, SSMS, and SSRS
- Knowledge of Oracle, DB2 Mainframe, DB2 LUW, or Teradata DBMS
3
SQL Server Database Administrator Job Description
Job Description Example
Our company is hiring for a SQL server 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 server database administrator
- Identify and implement creative solutions to improve contract and Portal offerings
- Analyze contract requirements to determine feasibility of automation within time and cost constraints
- Adhere to policies, achieved quality targets and delivery of schedule milestones
- Interact with headquarters and field personnel on significant technical matters, often requiring coordinate activity across organizational lines and provided advice, guidance and team leadership
- Consult hardware/system administrators to evaluate interface between hardware and software, and operational and performance requirements of overall Portal
- Day-to-day management of all SQL database servers
- Assisting Developers with code review, troubleshooting, tuning and deployments
- Administering and documenting database backup and maintenance policies and procedures
- Backup of all production and test databases
- Testing database backups and database disaster recovery procedures
Qualifications for SQL server database administrator
- Knowledge of Erwin and Data Modeling
- Ability to implement automation to reduce manual administrative tasks through use of jobs, power shell, scripts or other techniques
- OCA/MTA preferred
- Bachelors degree in CS, MIS, IT, CIS with database emphasis or equivalent experience
- 5 plus years as Oracle DBA experience
- MS SQL DBA - Proficient in SQLServer Management studio, in IDERA, SCOM, DMP, Window clustering, Log shipping and SRDF, mirroring, PerfMon, and SQL Profiler
4
SQL Server Database Administrator Job Description
Job Description Example
Our innovative and growing company is hiring for a SQL server 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 server database administrator
- Understand how to leverage Microsoft AD security in a Database
- Maintain necessary level of SQL server security
- Optimizing system performance and storage utilization
- Writing queries, scripts and stored procedures, new product installations
- Take proactive measures to monitor, trend, and tune SQL databases, such as running maintenance jobs (backups, DBCCs, apply indexes/re-indexing, ), to meet or exceed baseline stability and performance SLAs on large databases (1 TB+) and large volumes of databases (100+)
- Implements and continuously improves the database infrastructure environment
- Stays current with the DB technology
- Monitor backup jobs on all enterprise databases and perform routine disaster recovery scenarios
- Support the database management system [DBMS] and all related software
- Respond to and resolve any issues that may occur on production database systems
Qualifications for SQL server database administrator
- Bachelor's or Master's (or equivalent) degree in Computer Science, Information Systems or other related discipline is required
- 5+ years of DBA experience, expertise in database structure design and database administration, proficient in complex query analysis and tuning, database builds, migrations and upgrades, system and database troubleshooting
- Experienced in alternate open source technology is a plus
- Experienced in database partitioning and STATS methodologies, prioritization, interpersonal and resource management skills, and delivering technical documentation
- Able to work with minimum supervision, able to contribute to team work
- Bachelors degree in Computer Science or related field or completion of a technical training program in software development programming language plus eight years business experience
5
SQL Server Database Administrator Job Description
Job Description Example
Our growing company is hiring for a SQL server database administrator. To join our growing team, please review the list of responsibilities and qualifications.
Responsibilities for SQL server database administrator
- Recommend processes to maintain database security
- Establish and maintain sound backup and recovery policies and procedures using SQL Server maintenance plans
- Database Security and Audit Compliance
- Perform database security audits
- Ensure database code meets company standards
- Use DMVs to better understand database performance
- Conduct monthly database maintenance tasks
- Write scripts to automate repetitive tasks
- Be available on-call to resolve any issues that may occur after business hours
- Deploy database changes during release cycles
Qualifications for SQL server database administrator
- 5+ years of experience supporting and administering secure systems
- Minimum 7+ years’ experience managing an IT team, and/or IT projects
- Minimum 5+ years’ experience SQL Server Database Administration in Mid and Large scale enterprise environments
- Experience defining team communication protocols and procedures
- Experience defining and enforcing IT processes and procedures
- Extensive knowledge of the T-SQL