Lead Postgres DBA

You may occasionally be required to travel for business.

This role can be based remotely in the United States.

"At BMC trust is not just a word - it's a way of life!"

We are an award-winning, equal opportunity, culturally diverse, fun place to be. Giving back to the community drives us to be better every single day. Our work environment allows you to balance your priorities, because we know you will bring your best every day. We will champion your wins and shout them from the rooftops. Your peers will inspire, drive, support you, and make you laugh out loud!

We help our customers free up time and space to become an Autonomous Digital Enterprise that conquers the opportunities ahead - and are relentless in the pursuit of innovation!

The DSOM product line includes BMC’s industry-leading Digital Services and Operation Management products. Our team is a global and versatile group of professionals, and we LOVE to hear our employees’ innovative ideas. So, if Innovation is close to your heart – this is the place for you!

In this role, you will combine Infrastructure and Applicative DBA tasks (50%-50%) and work within an awesome R&D team. You will be the Tech Lead of the team, responsible for mentoring, onboarding, providing technical advice, researching new technologies and handling more complex tasks. This is a fantastic opportunity to influence technical decision-making and lead DB-related projects. You will use relational DBs such as Oracle, Postgre

SQL, and MSSQL, and collaborate with various internal interfaces as well as B2B enterprise customers.

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 Postgre
  
  SQL database systems ensuring availability and consistent performance, supporting product development teams.
• Build high-scale data pipelines and data infrastructure for migrating SQLServer and Oracle DB to Postgre
  
  SQL 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 Postgre
  
  SQL.
• Develop Dev Ops policies and procedures as it relates to Postgre
  
  SQL.
• Manage Postgre
  
  SQL 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, track issues, and document changes.
• Assist 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.

• Strong experience with Postgre
  
  SQL, it should have been your primary database over the last few years.
• Deep understanding of systems performance in Postgre
  
  SQL, and advanced knowledge of Postgres internals.
• Experience with system performance counters and metrics relevant to the operation of high-concurrency Postgre
  
  SQL implementations.
• Very strong experience with query optimisation.
• Strong experience with Oracle SQL throughout your career.
• Experience…