Senior Database Administrator (PostgreSQL and DevOps)

Basic Information

Country:

India

State:

Maharashtra

City:

IND Pune - Business Bay

Date published:

19-Mar-2021

Job ID:

29612

Travel Amount:

None

Description and Requirements

From core to cloud to edge, BMC delivers the software and services that enable over 10,000 global customers, including 84% of the Forbes Global 100, to thrive in their ongoing evolution to an Autonomous Digital Enterprise.
BMC Software is looking for a passionate and highly experienced PostgreSQL Sr/Lead Engineer to help build the next-gen data migration and Automation platform on the cloud and assist on-Prem to AWS migrations from SQL Server and Oracle DB to PostgreSQL with the following skillset:

You will work very closely with:
BMC Helix Cloud Operations & DevOps Team
BMC R&D Teams
BMC Support Teams – Customer Support, Database, Networking, Security and Server.

PRIMARY ROLES AND RESPONSIBILITY: 
  • You are 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.
  • You will be building high-scale data pipelines and data infrastructure for migrating SQL Server and Oracle DB to PostgreSQL on AWS RDB.
  • you will be contributing in 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.
  • 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
  • You will manage PostgreSQL databases through multiple product lifecycle environments, from development to mission-critical production systems dealing with upgrades.
  • Independently analyzes, solves, and corrects issues in real-time, providing problem resolution end-to-end.
  • You will assists developers with complex query tuning and schema refinement.
  • Provides on-call support, as part of team rotation, for critical production systems.
  • Performs pre-scheduled maintenance and support release deployment activities after hours.
  • Shares 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.

QUALIFICATIONS:
  • BS/B. Tech Degree in Computer Science, Engineering, Math or Physics. 
  • Minimum work experience of 7+ years in building enterprise-class products and platforms 
  • Strong knowledge in SQL and experience with at least one standard Database systems like PostgreSQL, MySQL or Oracle.
  • Proven working knowledge in one scripting language like Bash, Perl, PHP, Javascript 
  • Solid foundation in computer science fundamentals, including data structures, algorithms, database theory, and operating systems. 
  • Proven experience in building applications using Java. 
  • Working knowledge in IOS development, Andriod development, IOS Swift, and in developing/deploying webservices. 
  • Good understanding and working knowledge in UNIX operating systems – Preferably Linux. 
  • Demonstrable analytical and problem solving skills. 
  • Strong communication, presentation, and interpersonal skills. 
  • Exposure to Agile (Scrum)

It is the policy of BMC Software to afford equal opportunity for employment to all individuals regardless of race, color, age, national origin, physical or mental disability, history of disability, ancestry, citizenship status, political affiliation, religion, gender, transgender, gender identity, gender expression, marital status, status as a parent, sexual orientation, protected veteran status, genetic information or other factors prohibited by law, and to prohibit harassment or retaliation based on any of these factors. 

If you need a reasonable accommodation for any part of the application and hiring process, visit the accommodation request page.