Database Administrator

We are seeking a new Database Administrator (DBA) that possesses expertise in PostgreSQL as well as MySQL. Most of the workload is Cloud hosted on AWS, Azure or Google Cloud, however, there will be on-premises instances that require DBA support as well. We can accept a contract DBA that works entirely remote if necessary. Candidates with experience on AWS database technologies like AWS RDS, AWS Aurora PostgreSQL, and AWS Aurora MySQL will gain preference. Candidates with experience is MongoDB, MariaDB (as well as other open source databases used in Cloud environments) will also gain preference, though this is not a requirement. Compensation will vary based on the candidates experience.

• Candidate will have extensive experience in database administration, performance tuning, and ensuring the availability and security of PostgreSQL and MySQL databases.
• Candidate will be experienced in providing support for high-availability environments, as well as database environments that do not require high-availability.
• Candidate will be expected to take a technical lead role within the team for PostgreSQL and MySQL database technologies.
• Candidate will possess a thorough understanding of System Development Life-Cycle (SDLC) industry practices.
• Candidate will demonstrate experience supporting application developers and business users in application development.
• Candidate will work on a team of 12 DBAs that currently support; Microsoft SQL Server, Oracle, DB2 and IMS databases.

• Key responsibilities include;
• Database Administration;
• Install, configure, administer, and maintain database systems, ensuring high availability and disaster recovery.
• Perform routine database maintenance tasks, including backups, database restoration, and database migration.
• Ensure data security, privacy, and compliance by implementing proper access controls and security patches.
• Troubleshoot and resolve database issues in a timely manner.
• Performance Tuning and Optimization;
• Optimize queries and database performance through indexing, query optimization, and other performance-enhancing methods.
• Monitor database performance and recommend improvements.
• Identify bottlenecks, optimize SQL queries, and design database structures for high performance.
• Database Design & Implementation;
• Collaborate with developers to design, implement, and maintain the schema of databases.
• Assist with the creation of stored procedures, triggers, and other database objects.
• Work with other teams to scale databases effectively to meet performance and storage requirements.
• Disaster Recovery & High Availability;
• Design and implement backup, replication, and failover solutions to ensure business continuity.
• Perform disaster recovery tests and ensure the database systems are always available in the event of system failures.
• Upgrades & Patching:
• Plan and execute database upgrades and patches with minimal downtime.
• Keep up to date with the latest features, tools, and techniques.
• Documentation;
• Maintain comprehensive and up-to-date documentation for all database systems, processes, and policies.
• Create operational and technical reports to communicate database status and performance.