Job Summary
Transformation - Database L2
Key Responsibilities
Key Responsibilities: Database Administration: Install, configure, upgrade, and maintain relational databases (SQL Server, Oracle, PostgreSQL, MySQL) across physical, virtual, and cloud environments. Backup & Recovery: Execute routine database backups, test restore procedures and ensure compliance with strict RPO/RTO data recovery policies. Performance Tuning: Monitor database health, optimize slow-running queries, manage indexes, and resolve blocking/deadlocking issues. L2 Incident Management: Act as the primary technical resolver for escalated database alerts, connection failures, and capacity issues within ServiceNow. Access & Security: Manage user access, roles, and privileges, ensuring databases are hardened against unauthorized access and comply with security audits. Transformation Support: Assist senior architects in executing database migrations (e.g., on-premises SQL to Azure SQL Managed Instance or GCP Cloud SQL). Patching & Upgrades: Schedule and apply routine security patches and cumulative updates to database engines with minimal business disruption.
Skill Requirements
ust have Skills: Technical: 4+ years of dedicated experience in Database Administration in a large-scale enterprise environment. Strong hands-on experience managing Microsoft SQL Server (2014-2022) and/or Oracle databases. Proficiency in writing, analyzing, and tuning complex T-SQL or PL/SQL queries. Solid understanding of database high-availability (HA) concepts, such as SQL Server AlwaysOn Availability Groups, Log Shipping, or Oracle Data Guard. Familiarity with cloud-based database services (IaaS VMs and PaaS offerings like Azure SQL or Cloud SQL). Experience managing database storage, filegroups, table spaces, and capacity forecasting. Non-Technical ITSM Operations: Proven experience adhering to strict Incident, Change, and Problem Management workflows using ITSM tools like ServiceNow. SLA Compliance: Strong track record of meeting strict resolution targets and minimizing database downtime during critical business hours. Documentation: Ability to follow and update standard operating procedures (SOPs), runbooks, and build-guides for database deployments. Cross-Functional Collaboration: Ability to work closely with Wintel, Linux, and Storage teams to troubleshoot underlying OS or disk latency issues.
Other Requirements