L2 EB & BSS Infra – Database Admin Oracle & MS SQL

JOB PURPOSE
• Provide expert L2 database administration for Oracle and Microsoft SQL Server databases supporting Billing and broader BSS application workloads.
• Ensure database availability, performance, integrity, and security in line with SLA commitments within the enterprise BSS managed services environment.

DUTIES AND RESPONSIBILITIES
• Administer Oracle Database (19c and above) and Microsoft SQL Server (2017/2019) instances hosting BSS and Billing application schemas.
• Perform database health monitoring, alert management, and proactive maintenance.
• Troubleshoot and resolve L2 database incidents: performance degradation, lock contention, space issues, ORA- errors, SQL deadlocks.
• Manage Oracle RAC (Real Application Clusters) and Data Guard configurations for HA and DR.
• Administer MS SQL Server Always On Availability Groups and Failover Cluster Instances.
• Perform database tuning: query optimization, index management, statistics refresh, and execution plan analysis.
• Manage database backups: RMAN for Oracle, native SQL Server backup, and integration with enterprise backup tools.
• Perform and validate database restore operations per RTO/RPO requirements.
• Manage Oracle ASM, tablespace growth, and capacity planning for database storage.
• Apply Oracle Critical Patch Updates (CPU) and SQL Server service packs per Change Management.
• Administer database user accounts, roles, privileges, and auditing.
• Coordinate with BSS application teams for schema changes, data migrations, and performance tuning.
• Maintain database documentation, configuration records, and CMDB accuracy.
• Support DR testing and database failover/switchover exercises.
• Respond to L1 NOC escalations for database-related alerts.

SKILLS & EXPERIENCE
• 8–12 years of experience in Oracle and/or MS SQL Server DBA roles.
• Oracle Certified Professional (OCP) preferred.
• Microsoft Certified DBA or equivalent SQL Server certification preferred.
• Expert knowledge of Oracle 19c: RAC, Data Guard, RMAN, ASM, partitioning, and performance tuning.
• Strong knowledge of MS SQL Server: Always On AG, SSIS, SSRS, SQL Agent, and T-SQL.
• Experience with Billing/BSCS database schemas (Oracle) is highly desirable.
• Proficiency in PL/SQL and T-SQL scripting.
• Experience with database performance tools: AWR, ADDM, ASH (Oracle), Query Store (SQL Server).
• Knowledge of database security: TDE, auditing, privilege management.
• ITIL awareness – incident and change management.
• English skills – oral and written.

TECHNICAL SKILLS – SYSTEM & PLATFORM COVERAGE
• Billing (EB) – Primary database – EB/BSCS Oracle database administration: RAC, Data Guard, ASM, RMAN backup, schema management, rating engine data, BCH/BGH tables, and CDR/UDR storage
• Order Management (EOC) – EOC Oracle/SQL database instances – schema administration, performance tuning, and index management for order processing data
• Product Catalog (ECM) – ECM database – product catalog data model, pricing tables, and catalog version management database support
• Mediation (EM) – EM mediation database – CDR processing queue tables, archive policies, and mediation DB health monitoring
• CRM (MS Dynamics/MSD) – MS SQL Server database for Microsoft Dynamics CRM – Always On AG, SQL Agent, SSRS, and CRM schema administration
• DMS (MS SharePoint) – MS SQL Server backend for SharePoint – content database management, AG configuration, and SharePoint SQL maintenance
• Power BI/Vertica/Talend – Reporting/BI – Vertica analytics database administration – columnar store management, workload routing, and ETL data pipeline database support
• Commvault Backup/Restore – RMAN-to-Commvault Oracle backup integration; SQL Server Commvault VSS agent configuration and database restore validation
• Monitoring (ENM, MITO ELK) – Database performance metrics (AWR, wait events, query store) exported to MITO ELK for dashboarding and alerting
• ITSM (MITO) – Change management for database patching, schema changes, data migrations, and emergency database operations
• IAM/PAM/security tools – Database privileged account management; Oracle TDE and SQL Server TDE encryption; database audit trail and access governance

EDUCATION
• University degree in Computer Science, Information Technology, or equivalent. OCP certification preferred.