PostgreSQL Database Administrator
PostgreSQL Database Administrator:
The Role:
We are searching for an experienced DBA to join a leading company on a permanent basis. As the DBA you will have experience in PostgreSQL, MSSql, MySQL, you will be responsible for developing reviewing, tuning, testing, and reporting across a new reporting suite based on the company's PostgreSQL data warehouse / database. As the PostgreSQL administrator, you will also establish telemetry dashboards whilst also creating and implementing any recommendations.
Who are we looking for:
- Responsible for the monitoring and uptime of all production databases
- Estimate PostgreSQL database capacities; develop methods for monitoring database capacity and usage
- Lead efforts to develop and improve procedures for automated monitoring and proactive intervention, reducing any need downtime.
- Develop Stored Procedures and Database Triggers in support of application development.
- Participate in application development projects and be responsible for the database architecture and design.
- Participate in the creation of development, staging, and production database instances, and the migration from one environment to another.
- Responsible for developer SQL code review to ensure queries are optimized and tuned to perform efficiently prior to production release.
- Responsible for regular backups and recovery of databases.
- Responsible for regular maintenance on databases (e.g., Vacuum, Reindexing, Archiving).
- Responsible for pro-active remediation of database operational problems.
- Responsible for Query tuning and preventative maintenance.
- Participate in a 24×7 support rotation.
You will ideally have:
- Extensive experience with PostgreSQL, MSSql
- Experience of data warehousing
- Experience of performing load testing
- Experience of working in past paced high availability environments
We are building this team from scratch where you will initially work remotely, before moving to a more hybrid working environment with the offices in the heart of Birmingham City Centre.
For further information, send your CV to Dan Rodrigues or give us a call.
PostgreSQL Database Administrator:
The Role:
We are searching for an experienced DBA to join a leading company on a permanent basis. As the DBA you will have experience in PostgreSQL, MSSql, MySQL, you will be responsible for developing reviewing, tuning, testing, and reporting across a new reporting suite based on the company's PostgreSQL data warehouse / database. As the PostgreSQL administrator, you will also establish telemetry dashboards whilst also creating and implementing any recommendations.
Who are we looking for:
- Responsible for the monitoring and uptime of all production databases
- Estimate PostgreSQL database capacities; develop methods for monitoring database capacity and usage
- Lead efforts to develop and improve procedures for automated monitoring and proactive intervention, reducing any need downtime.
- Develop Stored Procedures and Database Triggers in support of application development.
- Participate in application development projects and be responsible for the database architecture and design.
- Participate in the creation of development, staging, and production database instances, and the migration from one environment to another.
- Responsible for developer SQL code review to ensure queries are optimized and tuned to perform efficiently prior to production release.
- Responsible for regular backups and recovery of databases.
- Responsible for regular maintenance on databases (e.g., Vacuum, Reindexing, Archiving).
- Responsible for pro-active remediation of database operational problems.
- Responsible for Query tuning and preventative maintenance.
- Participate in a 24×7 support rotation.
You will ideally have:
- Extensive experience with PostgreSQL, MSSql
- Experience of data warehousing
- Experience of performing load testing
- Experience of working in past paced high availability environments
We are building this team from scratch where you will initially work remotely, before moving to a more hybrid working environment with the offices in the heart of Birmingham City Centre.
For further information, send your CV to Dan Rodrigues or give us a call.
