מציאת משרת הייטק בחברות הטובות ביותר מעולם לא הייתה קלה יותר
BMC Lead Postgres DBA United States, Ohio 961632851
Yesterday
Description and Requirements
CareerArc Code
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
Min salary
Mid point salary
Max salary
משרות נוספות שיכולות לעניין אותך
