Senior Database Engineer

Summary

Join ServiceNow's Operations team as a Database Administrator or Database Operations Engineer, focusing on PostgreSQL and MySQL. Diagnose and resolve complex database performance issues, optimize queries, and proactively monitor workloads. You will perform database migrations, provide on-call support, and lead individual projects. Collaborate with cross-functional teams to resolve bugs and prevent escalations. Deep dive into performance bottlenecks using engineering tools and ensure MTTR stays within SLA.

Requirements

• 5+ years of hands-on experience as a Database Administrator or Database Operations Engineer, with a strong focus on PostgreSQL and MySQL in production or business critical environments
• Expertise in database architecture, indexing, query tuning, performance optimization, high-availability solutions and regular DB administration activities such as schema, tablespace and backup/recovery management
• 3+ years of experience providing support on a SaaS, PaaS, or Cloud Infrastructure product/solution
• Proven experience with concurrency, multithreading, and distributed system architectures
• Hands-on experience with database monitoring tools and setting up effective alerts
• Experience in data mining tool such as Splunk, Grafana or ELK stack tool
• Unix skills: including development, navigation, file manipulation, permissions, searching/finding files and text contents, and administrative actions
• Develop and implement automation scripts (e.g., Python, Bash) for routine operational tasks, deployments, and health checks

Responsibilities

• Diagnose and resolve complex database performance issues across PostgreSQL and MySQL and provide RCAs
• Perform query optimization, indexing, and database configuration adjustments to ensure optimal response times and resource utilization
• Proactively monitor and analyze database workloads, identify bottlenecks, and recommend improvements to developers and other teams
• Perform MariaDB/MySQL to Postgres migrations
• Provide on-call support during weekends on rotational basis
• You'll get an opportunity of leading individual projects, including driving project outcomes & delivering technical solutions for complex business needs
• Work with cross functional teams, pursue to the resolution of bugs identified
• Proactive monitoring of customer infrastructure to avoid any P1/P2 escalations
• Ensure that MTTR (Mean Time To Resolve) of any issues stays within SLA
• Deep dive on Database and ServiceNow Platform performance bottlenecks by utilizing performance engineering tools

Preferred Qualifications

• Strong experience with application/database performance engineering tools (pgbench, sysbech, mysqlslap, jmeter, flamegraph) is highly preferred
• Experience with ServiceNow platform, scripting, tuning, troubleshooting is highly preferred
• Formal experience on a DevOps, support or Operational team is desired
• Experience in supporting large scale web-based distributed application running on JVM/Apache/Tomcat is preferred