Sr. SQL Server DBA

Basic Information

Country

United States

State

NA

City

Remote

Date Published

09-Aug-2021

Job ID

31026

Travel Amount

None

Description and Requirements

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 & support 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

  • Expert knowledge & experience with Microsoft SQL Server 
  • Any experience with PostgreSQL is a plus
  • 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
  • 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, Prometheus with Kibana/Grafana
  • Knowledge of HDS (Hitachi), AWS EBS/S3 storage technologies
  • Other SQL database technologies including Oracle
  • ITIL Practices & Agile methodologies

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.
It is the policy of BMC Software to afford equal opportunity for employment to all individuals regardless of race, color, creed, sex, age, sexual orientation, national origin, disability, ancestry, citizenship status, political affiliation, religion, gender, transgender, gender identity, gender expression, marital status, status as a parent, disabled veteran or status as a protected veteran, 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.