Postgres SQL and MySQL DBA

Diverse Lynx; Stamford; On-site; GBP 45,000 - 65,000; Full time

Job summary

A leading technology firm in the United Kingdom is seeking a Postgres SQL and MySQL DBA. This role involves designing and implementing database schemas, optimizing SQL queries, managing user permissions, and ensuring high availability and disaster recovery for database systems. Ideal candidates will have strong skills in database performance tuning, security practices, and AWS monitoring tools.

Qualifications

• Experience in designing and implementing database schemas.
• Proficiency in optimizing SQL queries and stored procedures.
• Knowledge of performance tuning techniques for databases.
• Familiarity with security best practices for databases.

Responsibilities

• Design and implement database schemas for optimal performance.
• Manage user accounts and roles in PostgreSQL and MySQL.
• Configure multi-AZ deployments for high availability.
• Develop disaster recovery plans for database instances.

Skills

Database schema design

SQL optimization

Performance tuning

Capacity planning

Security best practices

High availability configuration

Disaster recovery planning

AWS monitoring tools

Troubleshooting database issues

Job description

Postgres SQL and MySQL DBA

Database Management / Optimization

• Design and implement database schemas, ensuring data integrity and optimal performance.
• Optimize SQL queries and stored procedures for application efficiency.
• Perform proactive and reactive performance tuning, including query analysis, indexing strategies, and parameter group configuration.
• Manage database capacity planning and storage scaling.
• Implement and manage data archiving and retention policies.

Security / Access Control

• Manage user accounts, roles, and permissions within PostgreSQL and MySQL RDS instances and other databases.
• Implement and enforce security best practices, including encryption in transit and at rest.
• Monitor and audit database access and activity for security compliance.

High Availability

Disaster Recovery

• Configure and manage multi-AZ deployments for high availability.
• Implement and test backup and recovery strategies using RDS automated backups and manual snapshots.
• Develop and maintain disaster recovery plans for database instances.

Monitoring / Troubleshooting

• Utilize AWS monitoring tools (CloudWatch, Performance Insights, Enhanced Monitoring) to analyze database performance and identify bottlenecks.
• Troubleshoot and resolve database-related issues, including performance degradation, connectivity problems, and data corruption.
• Set up and manage alerts for critical database events.

Diverse Lynx LLC is an Equal Employment Opportunity employer. All qualified applicants will receive due consideration for employment without any discrimination. All applicants will be evaluated solely on the basis of their ability, competence and their proven capability to perform the functions outlined in the corresponding role. We promote and support a diverse workforce across all levels in the company.