Database Administrator Job Description
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:
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:
Desired experience for database administrator includes:
Database Administrator Examples
Database Administrator Job Description
- 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
- 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
Database Administrator Job Description
- 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
- 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
Database Administrator Job Description
- 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
- 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
Database Administrator Job Description
- 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
- 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
Database Administrator Job Description
- 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
- 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