The DBA team ensures the reliability and integrity of data, including the availability and consistency of data throughout the organization. DBAs work with business analysts, system architects, software developers, and quality assurance resources to provide consistent data across all applications in support of business objectives.
Major Duties and Responsibilities
Data Integrity :
- Ensure recoverability of data through the design, implementation, and practice of defined database disaster recovery strategies
- Ensure availability of data through the design, implementation, and practice of database high availability strategies
- Establish and maintain the quality of data throughout the organization to support business goals
Monitoring and Maintenance :
- Monitor database performance to identify database configuration, hardware, and SQL query tuning opportunities
- Monitor database resource usage and recommend hardware/software changes as needed
- Monitor database utilities to ensure maintenance policies are being achieved
Documentation and Standards :
- Provide documentation for database design and modification
- Document established DBA-driven processes, work flows, and tasks
- Adhere to all applicable team and department standards governing workplace performance
Qualifications
Desired Qualifications
- Strong knowledge of DB2, PostgreSQL, and/or SQL Server relational database management systems and concepts
- Scripting experience with sh, ksh, bash, awk, sed, Python, and/or Perl
- Familiarity with Ansible and Infrastructure as Code concepts