We're excited to share news about a new job opportunity at a fintech company that operates with remote teams spanning the globe.
In the role of a PostgreSQL Database Administrator, your responsibilities will involve the management and maintenance of the client's database infrastructure, ensuring seamless performance and availability. Your expertise in database administration, optimisation, and troubleshooting will be instrumental in enhancing the overall efficiency and stability of the system.
This position presents an excellent opportunity for a seasoned engineer with a passion for data, mathematics, software architecture, system architecture, and programming.
Your responsibilities will include providing support for the existing Postgres database environment, as well as strategising, planning, and executing the migration of the database environment to AWS (utilising RDS, Aurora, Redshift, and potentially additional services).
- Understand operational requirements, including hardware considerations, and oversee the architecture, configuration, integration, and maintenance of mission-critical Production PostgreSQL databases.
- Take responsibility for all aspects of backup, recovery, and point-in-time recovery (PITR) replication.
- Utilise experience with community-supported tools such as Pgbadger, Slony, PGadmin, Pgpool, and Pgbouncer.
- Manage clusters and execute upgrades/migrations for various PostgreSQL database versions.
- Carry out database administration and fine-tune databases for optimal performance.
- Develop scripts for database automation and maintenance tasks.
- Provide technical guidance for the integration, testing, design, development, and planning of new production systems/databases.
- Contribute actively to the improvement and establishment of DBA policies, procedures, and standards.
Requirements
- 4+ years of robust experience as a DBA/PostgreSQL DBA
- 2+ years of experience working with cloud/virtualization technologies
- Proficiency in monitoring, managing, and maintaining mission-critical 24/7 production databases, including installation and configuration, implementation of high-availability solutions, setup of monitoring tools, establishment of database security, and resource optimisation
- Hands-on experience in SQL query tuning
- Proficient in at least one scripting language (Python/shell/PowerShell)
- Strong communication skills
- Willingness to actively contribute and demonstrate a service-oriented leadership approach, along with a history of respect for colleagues
- Excellent command of the English language
- Highly competitive with a strong work ethic
- Flexibility to work in shifts and on weekends to support 24/7 operations
Our client believes that everyone has ideas to contribute to their objective of continuous improvement. Hence, you are expected to take ownership, bring ideas to the table, and inspire others in the team to do the same.
- Demonstrate a strong commitment to achieving high-quality results in all your projects.
- Exhibit confidence in navigating challenging conversations and situations, collaborating with every department within the company to deliver the best product for users.
- Possess a deep passion for the craft, a love of technology, and a self-starting attitude.
- Provide support to the core team and actively participate in a 24x7 on-call rotation to assist fellow engineers in resolving production-related issues.
This is a full-time, remote contractor position, and we are seeking candidates located in Europe. The ability to work flexible hours is essential for this remote team.