Staff Database Administrator

Basic Information

Country:

India

State:

Maharashtra

City:

IND Pune - Business Bay

Date published:

11-Jan-2021

Job ID:

28462

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
DBA focused on day to day production operational tasks, database administration and automation of database services & solutions
Primarily working with Microsoft SQL Server and PostgreSQL database administration
Secondarily working with Casandra, MongoDB and MySQL
Support OLTP and OLAP applications
Provide proactive tuning and capacity optimization of databases supporting BMC Helix products & services
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 Database Administrator experience with Microsoft SQL Server and PostgreSQL 
Experience working with physical, virtual, AWS (RDS & Aurora) and AZURE (MI & Hyperscale) database environments
Experience working with database technology high-availability solutions (SQL Server Logshipping/Mirroring/AlwaysON/Clustering, PostgreSQL Replication/Clustering)
Experience working with database scripting using T-SQL, PostgreSQL, Cassandra, MongoDB, MySQL
Experience working with operating systems using Windows and Linux
Experience working with performance analysis & tuning of database applications or other similar OLTP/OLAP applications
Working knowledge with Cassandra, MongoDB and MySQL 
Working knowledge with automation & scripting using Ansible, Terraform, Python, Bash/Shell, PowerShell
Working knowledge with SQL and NOSQL solutions in the market
Adept at working with product teams on database best practices
Good understanding of Compliance & Governance, Change Control, Security and Security practices
Experience working with peer DBAs and global teams located across the globe in different time zones
Calm under pressure with demanding, dynamic, fast paced agile Saas Operations and with shifting priorities

If you know about the following is a plus
BMC Helix Products including Remedy ITSM, MyIT, SmartIT, SmartReporting, DWP, BPPM (Patrol), TrueSight Suite, BladeLogic, End User Experience Manager (Coradiant), Control-M
Knowledge of monitoring technologies including agent, agentless, synthetic and real user including BMC Patrol, Solarwinds DPA, Microsoft SCOM, Prometheus with Kibana/Grafana
Knowledge of HDS (Hitachi), AWS EBS/S3 storage technologies
Other SQL database technologies including Oracle
ITIL Practices & Agile methodologies
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. BMC never asks for payment from individuals seeking employment with the company.

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