Job
Description
We are an escalations team in Operations that primarily works on databases, performance, infrastructure, scalability & innovate solutions 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 To be successful in this role you have: 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. 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
