PostgreSql Database Administrator
Basic Information
Country:
India
State:
Maharashtra
City:
IND Pune - Business Bay
Date published:
18-Feb-2021
Job ID:
29084
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.
About the SaaS Operations Team
The BMC SaaS Operations team is a critical group in the design, architecture, configuration, maintenance and availability of our SaaS Services product portfolio. We work closely with our product teams, architecture and customers to provide the highest levels of availability, service and customer success. Being nice is a requirement and you will be working in a high-speed and collaborative team.
About the Job
• As a DBA you are focused on day to day production operational tasks, database administration and automation of database services & solutions
• You will primarily be working with PostgreSQL database administration
• Secondarily working Microsoft SQL Server
• You shall provide proactive tuning and capacity optimization of databases supporting BMC Helix products & services
• You will drive automation and compliance efforts of database solutions & associated technologies
• Work with peer DBAs and other peer teams as a subject matter expert on specified database solutions & associated technologies
• Support BCP & DR activities of database technologies including database backups/recovery
• Work with product teams and make recommendations on SQL & NOSQL engineering
• Take part in 24/7 on-call rotations and shift rotations as required
Experience
• 5 to 7 years of overall Database Administrator experience
Primary RDMS – Postgres with 3+yrs of experience in Postgres support work
• Backup and restore (pg_dump, physical backup tools)
• SQL Query tuning and development
• Familiarity with postgres plpgsql
• Database performance tuning
• Replication and failover
• User and object permission management
• Postgres versions 9.6, 10, 11+
• Linux command-line operating system experience (Centos/RHEL 7/8 preferred)
• Linux software install and configuration
• Scripting and task automation (Bash, Python, Git)
• Networking as related to database (Linux iptables, DNS, load balancers)
Preferred
• Experience with container technologies (Docker, Kubernetes)
• Experience with cloud platforms (AWS, Azure), including cloud DB technologies (RDS, Aurora)
• Experience with Patroni high availability
Secondary RDMS – Microsoft SQL Server 1+ yrs of experience in MS SQL support work
• General Administration support work that should include the following working knowledge level:
- Backup and Restores expertise
- Ad Hoc Query turning experience
- Database performance tuning experience
- AlwaysOn (AON) technology familiarity
- Logshipping and mirroring experience and expertise
- MS SQL Security understanding and familiarity
- Should be familiar with SQL Version 2012, 2016, 2017, and beyond
- Windows server level operating system familiarity and experience
- Networking familiarity and experience as related to RDMS work
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, 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.