Database Administrator

Basic Information

Country:

India

State:

Maharashtra

City:

IND Pune - Business Bay

Date published:

10-Jun-2021

Job ID:

30329

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.
Our SQL Server team’s primary function is to manage the SQL Server RDBMS systems at an outstanding level.  We are tasked with the design, architecture, configuration, maintenance, performance and availability of our production SQL Server RDBMS systems. We work closely with our application, architecture, and windows teams to provide the highest levels of availability, service and customer success. 

About the Job
Manage SQL Server databases
Configure and maintain database servers
Monitor system’s health, performance and capacity
Ensure high levels of performance, availability and security
Analyze, identify and correct issues in real time
Assist developers with query tuning and performance issues
Work alongside developers and other groups in projects
Automate and refine regular and repetitive processes
Support DR activities including database backup & recovery
Monitor incident and request queue
Take part in 24/7 on-call rotations and shift rotations as required
Perform scheduled maintenance and support release deployment activities after hours

Requirements and Qualifications
3 to 5 years of Database Administrator experience with Microsoft SQL Server
Experience with Windows server, including Active Directory
Experience working with physical and virtual database environments
Experience with backups, restores and recovery models
Experience with High Availability (HA) and Disaster Recovery (DR) options for SQL Server
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
Experience working with performance analysis & tuning of database applications or other similar OLTP/OLAP applications
Working knowledge with automation & scripting using PowerShell
Team player with good interpersonal and communication skills
Good time-management skills
Ownership and pride in your performance and its impact on a company’s success

If you know about the following is a plus
Experience working with peer DBAs and global teams located across the globe in different time zones
BMC Helix Products including Remedy ITSM, MyIT, SmartIT, SmartReporting, DWP, BPPM (Patrol), TrueSight Suite, BladeLogic, Control-M, SQLBackTrack
Knowledge of monitoring technologies including agent, agentless, synthetic and real user including BMC Patrol, Redgate
Experience working with AWS (RDS MySQL), AWS S3
Other SQL database technologies including MySQL, Oracle, PostgreSQL
ITIL Practices & Agile methodologies
Experience working with Linux operating system 
It is the policy of BMC Software to afford equal opportunity for employment to all individuals regardless of race, color, sex, 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.