You will be responsible for implementation, configuration, maintenance, and performance of system health for high-concurrency PostgreSQL database systems ensuring the availability and consistent performance, supporting product development teams. Build high-scale...
Description:Description and Requirements
Here is how, through this exciting role, YOU will contribute to BMC's and your own success:
- You will be responsible for implementation, configuration, maintenance, and performance of system health for high-concurrency PostgreSQL database systems ensuring the availability and consistent performance, supporting product development teams.
- Build high-scale data pipelines and data infrastructure for migrating SQLServer and Oracle DB to PostgreSQL on AWS RDB.
- Resolve database performance and scalability issues and implement Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools.
- Design and implement scalable database schemas and configurations, File system layout, Physical partitioning, Sharding and Replication, incremental backups, Restores, and recovery models.
- Implement High Availability (HA) and Disaster Recovery (DR) options for PostgreSQL.
- Develop DevOps policies and procedures as it relates to PostgreSQL.
- Manage PostgreSQL databases through multiple product lifecycle environments, from development to mission-critical production systems dealing with upgrades.
- Independently analyse, solve, and correct issues in real-time, providing problem resolution end-to-end.
- Refine and automate regular processes, tracks issues, and documents changes.
- Assists developers with complex query tuning and schema refinement.
- Provide on-call support, as part of team rotation, for critical production systems.
- Perform pre-scheduled maintenance and support release deployment activities after hours.
- Share domain and technical expertise, providing technical mentorship and cross-training to other peers and team members.
- Design and implement a complex system to combine and merge data from multiple database servers into a target database.
- Create complex queries to produce materialized views collating data from multiple servers based on which server is deemed authoritative for each record.
- Tune performance of source and target servers to ensure performance is maintained even after replication/merge engine is added.
To ensure you’re set up for success, you will bring the following skillset & experience:- Strong experience with PostgreSQL, it should have been your primary database over the last few years.
- Deep understanding of systems performance in PostgreSQL, and advanced knowledge of Postgres internals
- Experience with system performance counters and metrics relevant to the operation of high-concurrency PostgreSQL implementations.
- Very strong experience with query optimisation
- Strong experience with Oracle SQL throughout your career.
- Experience implementing high availability systems by setting up either streaming replication or logical replication and decoding.
- Expertise implementing Foreign Data Wrappers to sync data across multiple PostgreSQL servers and Advanced query tuning for large data sets.
- Knowledge on how to optimize queries/schemas.
- Knowledge on backup, High Availability solutions and strategies
- Ability to troubleshoot methodically, identify and applying fixes for known errors, and when necessary, capacity to think outside of the box to resolve complex issues.
Nice to have Experience:
- Specific experience in complex large data architectures using AWS Aurora PostgreSQL and AWS data lake (S3 and Glue) with IAM roles and KMS key encryption.
- Understand automation concepts to speed up the work using Ansible.
- Opensource contributions to PostgreSQL