The Database Administrator supports several Oracle, PostgreSQL, MySQL, and MariaDB database management system (DBMS) products for a variety of applications developed by the software development team. The DBA develops and implements policies and procedures that ensure the integrity, security, and high availability of the DBMS. This includes implementation of database installation procedures, disaster recovery steps, performance analysis and tuning, index maintenance, patching/IAVA mitigations, and monitoring of data. The DBA works with the Database Engineer (DBE) to implement PL/SQL and SQL performance tuning, architecture changes, and development prototypes. In addition, the DBA works with the DBE and software team to evaluate and recommend new DBMS tools, strategies, and technologies that will enable the team to meet business requirements.
Required Qualifications/Experience:
- Ten (10) years’ experience as a DBA in programs and contracts of similar scope, type, and complexity is required.
- Bachelor’s degree in a technical discipline from an accredited college or university is required. Four (4) years of additional DBA experience may be substituted for a bachelor’s degree.
- Oracle, PostgreSQL, MySQL, and/or MariaDB database administration in production environments.
- High availability configuration using Oracle Dataguard, PostgreSQL, MySQL replication, and/or MariaDB Galera clusters.
- Database system patching to include Oracle quarterly patching and IAVA mitigations.
- Oracle Enterprise Manager Cloud Control administration.
- PL/SQL programming, SQL query analysis, search optimization.
- Familiarity with Linux tooling such as iotop, vmstat, nmap, openssl, grep, ping, find, df, ssh, dnf.
- Familiarity with Oracle SQL Developer, Oracle DataModeler, pgadmin, PHPMyAdmin, and MySQL Workbench is a plus.
- Familiarity with Amazon RDS is a plus.
- Familiarity with NoSQL such as MongoDB and/or Amazon DocumentDB is a plus.