Database Administrator Job Description
Database administrator
provides 24*7 on-call support (includes holidays) for the Oracle, Microsoft SQL Server and Aurora (MySQL) production databases.
Database Administrator Duties & Responsibilities
To write an effective database administrator job description, begin by listing detailed duties, responsibilities and expectations. We have included database administrator job description templates that you can modify and use.
Sample responsibilities for this position include:
Work in tandem with the security team to ensure all security requirements are delivered protecting company and customer data
Maintain data integrity and security (manage roles and permissions of database users)
Develop and implement backup and recovery strategies using both native SQL and third party technologies
Strong production experience with Microsoft SQL Server 2008 or later
Project based participation
Benchmark new technologies
Creates and manages assigned databases per defined standards and procedures
Processes successful, daily backups guaranteeing recoverability
Performs database refreshes using Export/Import, upgrades and applies patches
Completes activities such as storage management, backup and recovery, and performance tuning
Database Administrator Qualifications
Qualifications for a job description may include education, certification, and experience.
Licensing or Certifications for Database Administrator
List any licenses or certifications required by the position: SQL, ITIL, MCTS, IAT, MCDBA, MCITP, CCNA, MTA, MCSA, MVP
Education for Database Administrator
Typically a job would require a certain level of education.
Employers hiring for the database administrator job most commonly would prefer for their future employee to have a relevant degree such as Bachelor's and Associate Degree in Computer Science, Education, Technical, Engineering, Management, Technology, Business, Computer, Computer Engineering, Computer Information Systems
Skills for Database Administrator
Desired skills for database administrator include:
Replication
SQL
MySQL
Index management
Indexes
Statistics
Oracle
Security
Clustering
PL/SQL
Desired experience for database administrator includes:
Ability to extrapolate information from multiple systems and provide effective troubleshooting for system integration
Scripting to help with administration and write custom queries to measure key information
Ability to multi-task and take initiative without direct supervision
Project management capabilities with the ability to identify and implement process improvements
Results driven focus, with the capacity to see issues through to completion in a timely manner
Database administration, design, implementation, and tuning experience
Database Administrator Examples
1
Database Administrator Job Description
Job Description Example
Our growing company is hiring for a 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 database administrator
- Design and maintain Oracle RAC services supporting studio production applications
- Configure and monitor PostgreSQL replication across multiple environments
- Work directly with developers on query tuning, schema design, and index management
- Proactively monitor databases to ensure high level of performance, availability, and security
- Monitor database performance for proactive actions preventing production issues impacting full customer base
- Work with external technology partners to minimize TCO and maximize performance
- Manage and maintain multiple databases across development, UAT, QA, and production environments
- Manage, monitor and maintain data integration and data flow with firm systems
- Performs research and evaluation of new database features and technology
- Create and maintain replicated databases over the local LAN and WAN
Qualifications for database administrator
- DB tuning for Linux Environment
- Java Application Server Concepts
- Fundamental understanding of database internals and data structures, including defining init.ora parameters for optimum performance and understanding Oracle V$ system tables and defining
- Solid knowledge of SQL and database procedural languages
- Solid knowledge of Unix shell, Perl or other scripting languages
- Experience working with TSM and TDP backup infrastructure
2
Database Administrator Job Description
Job Description Example
Our growing company is hiring for a 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 database administrator
- Experience on Traditional RDBMS (Oracle, MySQL etc)
- Install, set-up, configure, support and design the back-up and recovery of SQL Server and Oracle databases
- Responsible for design, installation, configuration, security and maintenance of highly available enterprise database systems (SQL 2005, 2008, 2012)
- Experience in Oracle Golden Gate is a must
- Work closely with engineers to keep various MySQL databases performant and normalized, and follow best practices relating to keys, indices
- Perform capacity planning for new systems
- Participate in 24x7 on-call rotation to support critical production systems
- Automate routine tasks with scripts and PSQL client
- Experience on Linux and system administration in Linux
- Experience in NoSQL Technologies a huge plus
Qualifications for database administrator
- Solid knowledge of SSIS, Database Mail, Database mirroring and DBCC
- Basic knowledge of Reporting Services and Analysis Services
- Experience working with LiteSpeed database backup tool
- Experience working with TSM backup and Tivoli monitoring tool
- Experience working with Windows Clustering
- Experience working with Reporting Service, Analysis Services, and Management Datawarehouse
3
Database Administrator Job Description
Job Description Example
Our growing company is looking to fill the role of 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 database administrator
- Support of Application databases (MSSQL, DB2, Oracle)
- Refresh data from one environment to another at the request of the application development staff
- Follow and maintain in-house documentation for repeatable processes, including database feature installation, disaster recovery, and common problem resolution
- Utilizing our business process, plans, evaluates and manages the execution of assigned projects
- Administers, maintains, develops and implements policies, procedures and best practices
- Has expert knowledge of commonly used concepts, practices and procedures within job scope
- Identify and review opportunities and implement recommendations for improvement to mitigate risk and optimize technology
- Prepare formal project plans maintaining an awareness and an updated status of projects that fall within span of responsibility
- Provide leadership and mentoring opportunities to staff
- Provide regional Engineering support for mission critical databases that drive our critical applications
Qualifications for database administrator
- SQL Sentry
- Working in a structured IT environment
- PC proficiency, using Microsoft office applications such as excel, word, PowerPoint, Visio
- Create ad-hoc queries based on business needs using SQL
- Create and manage logins and related permissions
- Provide day-to-day operational support of development and test database environments, including database refreshes and execution of SQL Scripts
4
Database Administrator Job Description
Job Description Example
Our innovative and growing company is searching for experienced candidates for the position of database administrator. To join our growing team, please review the list of responsibilities and qualifications.
Responsibilities for database administrator
- Problem escalation to Oracle Development team and third parties as appropriate
- Solve a range of problems within area of expertise and apply known toolkit to new problems
- Maintain the enterprise wide database systems
- Manage system performance processes and communicates issues to Architects
- Manage and test pieces of backup and recovery plans, ensuring that storage, archiving, backup and recovery procedures are functioning correctly
- Assists in the identification of information flows
- Participates in physical database design from specifications
- Supports enterprise database development standards
- Supports the deployment of data access tools and techniques to enable information access by business users
- Performs upgrades of databases
Qualifications for database administrator
- Oracle 11g and/or Microsoft SQL Server 2008 or more recent experience required
- Experience with MSSQL Server AlwaysOn and Oracle Data Guard a plus
- Knowledgeable in all Microsoft Office applications, including Word, Excel, Access, PowerPoint and Visio software applications
- Must have at least 5+ years of experience working in a high volume environment
- Must have a general knowledge of indexes, High Availability(HA) and Disaster Recovery(DR) options for MS SQL Server and DB2
- Certification for a database programs such as Microsoft Certified Database Administrator and DB2 Database Administrator desired
5
Database Administrator Job Description
Job Description Example
Our company is searching for experienced candidates for the position of database administrator. To join our growing team, please review the list of responsibilities and qualifications.
Responsibilities for database administrator
- Support all relational databases, primarily SQL Server, PostgreSQL, and MySQL
- Administers database access and maintain database security
- Handle common database procedures, such as upgrade, backup, recovery, replication, migration, tuning
- Defines database configuration standards related to performance and sizing for both transactional and data warehouse databases
- Works closely with technical teams to ensure delivery and service assurance
- Member of DBA group and report to DB Architect
- Provides database monitoring
- Backup/recovery and performance analysis
- Migration to the SoftLayer.Works with the Release Manager, Engineering, Modeling & technical Integration to control changes made to production databases
- Responsible for the support and maintenance of Infrastructure components within the global organisation
Qualifications for database administrator
- Knowledge of other databases like MySQL, No SQL databases and In-memory databases and MCTIP certification will be an advantage
- Previous database administration experience (1 -2 years) or previous experience in design and implementation (tables, query optimization, triggers, views and stored procedures)
- Knowledge of systems concepts and technologies
- Strong verbal/written communication, documentation, organizational, analytical and troubleshooting skills are a must
- Customer focused and team player attitude
- Experience in Availability Groups, SQL cluster, mirroring, logshipping and replication