DBA Job Description
DBA
provides assistance, where necessary, to developers in building stored procedures, views, and other objects in SQL Server.
DBA Duties & Responsibilities
To write an effective DBA job description, begin by listing detailed duties, responsibilities and expectations. We have included DBA job description templates that you can modify and use.
Sample responsibilities for this position include:
Create, maintain and monitor our database environment that is highly available and high performing
Plan, drive and implement capacity planning and best practices
Participate in planning, maintenance and implementation of all aspects of database disaster recovery
Set database performance and approve all database schema and procedure changes
Rapidly diagnose and fix problems
Have on-call responsibility (including weekends)
Provide first-class database support and administration
Execute change requests
Administer database access and maintain database security
Gate-keep' new databases destined for the production environment
DBA Qualifications
Qualifications for a job description may include education, certification, and experience.
Licensing or Certifications for DBA
List any licenses or certifications required by the position: DBA, OCP, II, ITIL, IAT, SQL, MVP, MCITP, MCTS, MS
Education for DBA
Typically a job would require a certain level of education.
Employers hiring for the DBA 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, Engineering, Technical, Information Technology, Information Systems, Business, Computer Engineering, Administration, Software Engineering
Skills for DBA
Desired skills for DBA include:
SQL
High Availability options for SQL Server
Partitioning
ASM
Oracle OEM
Datapump
Materialized views
Index management
Development cycle of a rapidly paced dev env
Replication
Desired experience for DBA includes:
At least 10 years of DBA experience
Shipped and supported at least 2 mobile/social titles
Scalability techniques for multiple database platforms
Deep knowledge of persistence models for multiple database platforms
Deep knowledge of database engines strengths and weaknesses
Strong knowledge of Database consumers, along with their strengths and weaknesses
DBA Examples
1
DBA Job Description
Job Description Example
Our company is growing rapidly and is looking to fill the role of 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 DBA
- Identify opportunities to optimize application data models for performance, manageability, scalability and availability
- Implement, capture and monitoring of key database metrics such as CPU and storage utilization, system resources, and immediately respond to incidents
- Work with application teams in delivering optimal database solutions throughout the life cycle
- Experience in upgrading database from one version to another
- Keep up to date on industry trends, research and evaluate new database features and technology
- Must take a lead role and act as a go-to person when it comes to database related technology
- Implement backup/restore policies for databases
- Evaluate and execute non-application initiated queries
- Investigate and resolve all database crashes, failures, and unexpected behavior
- Installation and support of DB2 software and patches
Qualifications for DBA
- Template data versioning solutions
- Solid understanding of HA and disaster recovery configurations
- Experience with MySQL, Linux system
- Experience with designing the HA, DR database solutions
- Experience with operating large size databases
- Experience with building and operating highly available and DR database infrastructure solutions
2
DBA Job Description
Job Description Example
Our growing company is looking to fill the role of DBA. If you are looking for an exciting place to work, please take a look at the list of qualifications below.
Responsibilities for DBA
- Implement the changes in the production environment
- In case of any escalation, assign the criticality to the tickets and allocate the tickets to the administrator
- Provide technical guidance to the administrator in resolving the issue by conducting root cause analysis
- Define capacity planning, Gather requirements from the client in terms of new application
- Provide recommendation ( in terms of version , clustering and system configuration) to the client on the basis of the requirement analysis
- Post architecture finalization, recommend prerequisites and share it with the customer
- Post testing, transfer the new patches in the production environment
- Database/ tool Administration Currently running application administration
- Analyze the current application, identify the client pain points
- Based on the analysis, provide inputs to the lead administrator on the recommendation to resolve it
Qualifications for DBA
- Setup and monitor backups
- Well versed in network troubleshooting – LAN, WAN, Subnetting, basic routing
- Good knowledge of further Oracle database options like RAC, Data Guard, GRID Control
- Hands on exp in Sybase ASE 15.7
- You must be able to demonstrate good attention to detail with good judgement in a logical and structured approach to work
- Excellent interpersonal skills, ability to work effectively and cooperatively with all levels of management, staff and contractors
3
DBA Job Description
Job Description Example
Our growing company is looking for a 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 DBA
- Responsible for coding and testing efficient data access queries using a variety of languages such as SQL and javascript
- Provide support to the data model team in performance enhancement
- Review the data models and provide the sign off on the same
- Database/ tool Administration Archiving of the existing system
- Create decommissioned plan to schedule, check, monitor and troubleshoot system batch jobs
- Provide technical guidance to the team to create/ cancel/ reschedule/ terminate the jobs as per requests or predefined procedures
- Provide technical guidance to the team to monitor batch inputs and interfaces
- Provide technical guidance to the administrator to manage clustering and high availability configurations if required
- Review the deployment plans for change requests (CRs) created by the administrator
- Diagnose and resolve the issues as applicable
Qualifications for DBA
- Hands on experience in database administration
- Strong Linux skills, preferably with RedHat/CentOS
- Hands-on experience in NoSQL administration
- Experience in bash/Perl or ruby is a must
- Understanding of one high-level object oriented programming language C++,Java
- Working knowledge of Splunk, Nagios is a must
4
DBA Job Description
Job Description Example
Our innovative and growing company is hiring for a 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 DBA
- Seek out opportunities and provide inputs to the client for standardization in systems and processes
- Identify workloads and forecast workload evolution, if required
- Predict the future performance and define system availability
- In collaboration with the lead administrator, analyze and resolve performance bottlenecks
- Support application team in resolution of application performance problems
- Review the HLD/ LLD design documents created by the architect to ensure high maintainability, if required
- Provide inputs/ define solution and share it with the lead administrator to seek review inputs on the same
- Create knowledge articles on the workaround solutions
- Build internal capability on system management
- Conduct assessments on existing employees as required by the practice
Qualifications for DBA
- Experience in working with Oracle Exadata will be a plus
- Log calls in Call Tracking system, track, escalate, and close tickets as appropriate
- Proficiency with UNIX and the shell environment
- Experience supporting multiple medium scale databases (250G or more)
- Knowledge on Cassandra
- 3+ years of experience with Vertica Administration and expertise in VSQL
5
DBA Job Description
Job Description Example
Our company is growing rapidly and is looking to fill the role of DBA. 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 DBA
- Configuration, maintenance, and monitoring of SQL Server AlwaysOn setups
- Configuration, maintenance, and monitoring of Oracle RAC & traditional SQL Clusters
- Diagnose and troubleshoot Oracle, SQL Server and related technology issues
- Work collaboratively with teams on database design and data modelling with a focus on improving SQL efficiency and for fast application performance
- Maintenance of the current system
- Designing & developing DB solutions for new capabilities according to demand
- Performance tuning & optimizations on existing systems
- Responsiveness to alerts from production database
- Performing code reviews and participating in design reviews inside the team / relevant project
- Work with development teams to design and build and maintain effective, usable database environment to support the creation and maintenance of applications
Qualifications for DBA
- Good working knowledge of Vertica database architecture (column orientation, compression, projections, segmentations, partitions, high availability and security)
- Hands-on experience with database optimization and tuning
- Experience with ETL and Data Warehouse systems
- Strong familiarity with a scripting language
- 8 years of Database Administration production experience, including a minimum of 2 years as a DBA on MySQL
- Extensive experience on UNIX and/or Linux