Job Summary
L2 Resource for MSSQL / Oracle / PostgreSQL) rnJob TitlernL2 Database Administrator (MSSQL / Oracle / PostgreSQL)rnExperiencernJob SummaryrnWe are seeking a skilled and motivated L2 Database Administrator having experience in managing, monitoring, and supporting Microsoft SQL Server, Oracle Database, and PostgreSQL environments. The candidate will be responsible for ensuring database availability, performance, security, backup and recovery, troubleshooting, and supporting critical production systems while adhering to organizational SLAs and operational standards.rn________________________________________rnKey ResponsibilitiesrnDatabase Administrationrn• Administer and support MSSQL, Oracle, and PostgreSQL databases in Production, UAT, and Development environments.rn• Perform database installation, configuration, upgrades, and patching activities.rn• Monitor database health, performance, and availability.rn• Perform database capacity planning and growth analysis.rnBackup & Recoveryrn• Configure, monitor, and validate backup strategies.rn• Execute database restore and recovery activities during incidents and DR exercises.rn• Ensure successful completion of backup jobs and compliance with recovery objectives.rnHigh Availability & Disaster Recoveryrn• Monitor and maintain High Availability solutions: rno SQL Server Always on Availability Groupsrno Oracle Data Guardrno PostgreSQL Replicationrn• Support failover, switchover, and disaster recovery testing activities.rnSecurity & Compliancern• Manage database users, roles, and permissions.rn• Implement database security best practices.rn• Support audit, compliance, and vulnerability remediation activities.rnIncident & Change Managementrn• Resolve database-related incidents within SLA timelines.rn• Participate in root cause analysis (RCA) for recurring issues.rn• Execute planned changes, maintenance activities, and deployments.rn• Follow Doer-Checker and Change Management processes.rnMonitoring & Automationrn• Monitor databases using enterprise monitoring tools.rn• Develop and maintain maintenance scripts for routine DBA activities.rn• Support proactive health checks and preventative maintenance.rn________________________________________rnTechnical SkillsrnMicrosoft SQL Serverrn• SQL Server 2019/2022 Administrationrn• SQL Server Agentrn• Backup & Restorern• Always On Availability Groupsrn• Performance Tuningrn• Database Securityrn• SSMSrnOracle Databasern• Oracle 19c Administrationrn• RMAN Backup & Recoveryrn• Oracle Data Guardrn• User & Schema Managementrn• Patching and Maintenancern• Performance MonitoringrnPostgreSQLrn• PostgreSQL 12/13/14/15/16 Administrationrn• Streaming Replicationrn• pgAdminrn• Backup & Recoveryrn• Performance Monitoringrn• Role & Privilege Managementrn________________________________________rnRequired Skillsrn• Strong troubleshooting and analytical skills.rn• Experience working in Production Support environments.rn• Knowledge of ITIL processes (Incident, Change, Problem Management).rn• Ability to work in shifts and support critical production systems.rn• Good verbal and written communication skills.rn• Experience in handling customer-facing activities and escalations.rn________________________________________rnPreferred Skillsrn• Exposure to Cloud Platforms (Azure).rn• Knowledge of Shell Scripting, PowerShellrn• Experience with monitoring tools such as SolarWinds, OEMrn• Knowledge of database migration and upgrade projects.rn________________________________________rnKey Competenciesrn• Database Administrationrn• Performance Optimizationrn• Backup & Recoveryrn• High Availability & Disaster Recoveryrn• Incident Management
Key Responsibilities
2. To maintain the existing project and resolving the issues occurring in the existing project.
3. To work upon the new requests raised by the client and develop those features.
4. Documentation work.