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.
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:
- Extensive experience with PostgreSQL, MSSql
- Experience of data warehousing
- Experience of performing load testing
- Experience of working in past paced high availability environments
- Experience of deploying large PostgreSQL, MSSQl implementations and apply data security
- Experience of cloud platforms - AWS, Azure
- Recovery and Replication
- Overall system health
- Developing Triggers/Stored Procedures
- Query optimization
- Developing SQL reports and business logic of UNIFY
- Staging, testing and development of database
- Documentation of schema
- Schema Management, updates, and rollbacks
Responsibilities:
- 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.
- Perform other duties as assigned.
Qualifications:
- BSc in Computer Science, Engineering, or relevant field
- 5-8 Years of relevant experience
- It would be grateful if PostgreSQL certification database certification
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:
- Extensive experience with PostgreSQL, MSSql
- Experience of data warehousing
- Experience of performing load testing
- Experience of working in past paced high availability environments
- Experience of deploying large PostgreSQL, MSSQl implementations and apply data security
- Experience of cloud platforms - AWS, Azure
- Recovery and Replication
- Overall system health
- Developing Triggers/Stored Procedures
- Query optimization
- Developing SQL reports and business logic of UNIFY
- Staging, testing and development of database
- Documentation of schema
- Schema Management, updates, and rollbacks
Responsibilities:
- 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.
- Perform other duties as assigned.
Qualifications:
- BSc in Computer Science, Engineering, or relevant field
- 5-8 Years of relevant experience
- It would be grateful if PostgreSQL certification database certification
For further information, send your CV to Dan Rodrigues or give us a call.
Senior PostgreSQL Developer - PL/PGSQL
Role: Senior PostgreSQL Developer
Salary: £45k - £60k
Location: Birmingham - office based
CX Squared are the exclusive talent partner to a brand new fin-tech product engineering team, who are setting up a new office in the heart of Birmingham.
This fintech company are going to be going from 1 - 16 in the next 6 months and we are starting by hiring a team of DevOps, Java Devs, Senior QAs, PostgreSQL and Scrum Master and Project Managers.
About the Role
- Expert Level SQL, PL/PGSQL, including stored procedures, functions, triggers, and views.
- Ability to efficiently write database code without compromising data quality, privacy or security.
- Knowledge of database design principles, query optimization, index management, integrity checks, statistics and isolation levels
- Excellent verbal, written, and interpersonal communication skills
- Ability to evaluate alternative solutions and/or workarounds.
- Partners with PostgreSQL Administrators to optimize implementation of system design in order to optimize performance and effectiveness while realizing the optimum technical issues.
- Evaluates application database queries performance and optimize the code and database configuration as appropriate.
- Partners with PostgreSQL administrator for the implementation of secured PostgreSQL database platform in compliance with STIG.
- Provide technical leadership to other DBAs.
- Design process for database change management issues related to environment migration. * Other duties as assigned.
Essential Skills Needed
- 6+ years of professional experience as a Postgres code development
- In depth knowledge of the PostgreSQL architecture and application data lifecycle management.
- Experience in working closely with the application teams to resolve any performance related issues.
- Measure database performance and troubleshoot complex database issues, I/O bottlenecks and SQL Tuning.
- Proven experience in working in a mission critical environment in a multi-terabyte database platform.
- Experience with automation using Python, Ansible, etc.
- In-depth knowledge of IT industry database technologies and processes and business applications integrated with database technologies.
- Ability to develop efficient data models. * Ability to write optimized SQL queries and PL/PGSQL code.
- Experience in triggers and constraints.
- Strong experience in SQL and Database performance tuning.
- Experience in developing and managing table and index partitioning.
- Strong experience in writing complex JOINS and Sub Queries
- Extensive experience in using extensions and all available functions.
- Knowledge in Agile Scrum Framework.
Preferred:
Give Dan Rodrigues a call to find out more, or send in your CV for a confidential chat.
Please note: this role will require you to be in the office, due to the nature of the culture and brand new product, we need that team collaboration for the first 3-6 months. After this, the model will change.
Role: Senior PostgreSQL Developer
Salary: £45k - £60k
Location: Birmingham - office based
CX Squared are the exclusive talent partner to a brand new fin-tech product engineering team, who are setting up a new office in the heart of Birmingham.
This fintech company are going to be going from 1 - 16 in the next 6 months and we are starting by hiring a team of DevOps, Java Devs, Senior QAs, PostgreSQL and Scrum Master and Project Managers.
About the Role
- Expert Level SQL, PL/PGSQL, including stored procedures, functions, triggers, and views.
- Ability to efficiently write database code without compromising data quality, privacy or security.
- Knowledge of database design principles, query optimization, index management, integrity checks, statistics and isolation levels
- Excellent verbal, written, and interpersonal communication skills
- Ability to evaluate alternative solutions and/or workarounds.
- Partners with PostgreSQL Administrators to optimize implementation of system design in order to optimize performance and effectiveness while realizing the optimum technical issues.
- Evaluates application database queries performance and optimize the code and database configuration as appropriate.
- Partners with PostgreSQL administrator for the implementation of secured PostgreSQL database platform in compliance with STIG.
- Provide technical leadership to other DBAs.
- Design process for database change management issues related to environment migration. * Other duties as assigned.
Essential Skills Needed
- 6+ years of professional experience as a Postgres code development
- In depth knowledge of the PostgreSQL architecture and application data lifecycle management.
- Experience in working closely with the application teams to resolve any performance related issues.
- Measure database performance and troubleshoot complex database issues, I/O bottlenecks and SQL Tuning.
- Proven experience in working in a mission critical environment in a multi-terabyte database platform.
- Experience with automation using Python, Ansible, etc.
- In-depth knowledge of IT industry database technologies and processes and business applications integrated with database technologies.
- Ability to develop efficient data models. * Ability to write optimized SQL queries and PL/PGSQL code.
- Experience in triggers and constraints.
- Strong experience in SQL and Database performance tuning.
- Experience in developing and managing table and index partitioning.
- Strong experience in writing complex JOINS and Sub Queries
- Extensive experience in using extensions and all available functions.
- Knowledge in Agile Scrum Framework.
Preferred:
Give Dan Rodrigues a call to find out more, or send in your CV for a confidential chat.
Please note: this role will require you to be in the office, due to the nature of the culture and brand new product, we need that team collaboration for the first 3-6 months. After this, the model will change.
