SME - Oracle Administration,PostgreSQL,MYSQL, MS SQL

Job Summary

Database Administration Administer and maintain Oracle, PostgreSQL, MySQL, and Microsoft SQL Server databases. Install, configure, upgrade, and patch database servers. Manage database instances, schemas, tablespaces, and storage allocation. Ensure database availability, performance, and reliability. 2. Backup, Recovery & Restoration Configure and monitor database backups. Perform backup validation and recovery testing. Execute point-in-time recovery (PITR) and disaster recovery procedures. Support database restore requests and data recovery activities. 3. Database Performance Management Monitor database health and performance. Troubleshoot slow-running queries and blocking sessions. Optimize indexes, execution plans, and database configurations. Perform capacity planning and storage optimization. 4. High Availability & Disaster Recovery Manage: Oracle Data Guard SQL Always On Availability Groups (AOAG) PostgreSQL Replication MySQL Replication Database Clustering Solutions Conduct DR drills and failover testing. Ensure RPO and RTO compliance. 5. Incident & Problem Management Act as L3 escalation point for database-related incidents. Troubleshoot: Database outages Replication failures Backup failures Performance degradation Connectivity issues Perform Root Cause Analysis (RCA) for recurring issues. 6. Security & Compliance Manage database security policies. Implement role-based access control (RBAC). Monitor privileged access and audit logs. Ensure compliance with organizational security standards. 7. Change & Release Management Plan and implement: Database upgrades Security patching Schema modifications Database migrations Participate in CAB reviews. Execute maintenance activities during approved windows. 8. Migration & Upgrade Activities Perform database migrations between versions and platforms. Support cloud migration initiatives. Execute database consolidation and modernization projects. Validate application connectivity post-migration. 9. Automation & Scripting Develop scripts for: Database monitoring Backup validation Health checks Reporting Automation of routine DBA tasks Use PowerShell, Shell Script, SQL Scripts, or Python. 10. Documentation & Knowledge Management Maintain: Runbooks SOPs HLD/LLD documents Recovery procedures Provide technical mentoring to L1/L2 teams. Conduct knowledge transfer sessions. Technical Skills Required Oracle Oracle Database Administration RMAN Oracle RAC Oracle Data Guard ASM OEM Cloud Control Microsoft SQL Server SQL Server 2016/2019/2022 Always On Availability Groups SSMS SQL Performance Tuning SQL Backup & Restore PostgreSQL Replication Streaming Replication PITR pgAdmin PostgreSQL Performance Tuning MySQL MySQL Replication MySQL Cluster Backup & Recovery Performance Optimization Common Skills Linux & Windows Administration Storage Concepts Backup Solutions (PPDM/Veeam/NetBackup) PowerShell/Shell Scripting ITIL Incident, Problem & Change Management Preferred Certifications Oracle Certified Professional (OCP) Microsoft SQL Server Certifications PostgreSQL Professional Certification MySQL Database Administrator Certification ITIL Foundation Key KPIs Database Availability ≥ 99.9% Backup Success Rate ≥ 98% Restore Success Rate = 100% Incident Resolution Within SLA Successful Completion of Patch & Upgrade Activities Database Performance Compliance Zero Critical Data Loss Events

Key Responsibilities

Database Administration Administer and maintain Oracle, PostgreSQL, MySQL, and Microsoft SQL Server databases. Install, configure, upgrade, and patch database servers. Manage database instances, schemas, tablespaces, and storage allocation. Ensure database availability, performance, and reliability. 2. Backup, Recovery & Restoration Configure and monitor database backups. Perform backup validation and recovery testing. Execute point-in-time recovery (PITR) and disaster recovery procedures. Support database restore requests and data recovery activities. 3. Database Performance Management Monitor database health and performance. Troubleshoot slow-running queries and blocking sessions. Optimize indexes, execution plans, and database configurations. Perform capacity planning and storage optimization. 4. High Availability & Disaster Recovery Manage: Oracle Data Guard SQL Always On Availability Groups (AOAG) PostgreSQL Replication MySQL Replication Database Clustering Solutions Conduct DR drills and failover testing. Ensure RPO and RTO compliance. 5. Incident & Problem Management Act as L3 escalation point for database-related incidents. Troubleshoot: Database outages Replication failures Backup failures Performance degradation Connectivity issues Perform Root Cause Analysis (RCA) for recurring issues. 6. Security & Compliance Manage database security policies. Implement role-based access control (RBAC). Monitor privileged access and audit logs. Ensure compliance with organizational security standards. 7. Change & Release Management Plan and implement: Database upgrades Security patching Schema modifications Database migrations Participate in CAB reviews. Execute maintenance activities during approved windows. 8. Migration & Upgrade Activities Perform database migrations between versions and platforms. Support cloud migration initiatives. Execute database consolidation and modernization projects. Validate application connectivity post-migration. 9. Automation & Scripting Develop scripts for: Database monitoring Backup validation Health checks Reporting Automation of routine DBA tasks Use PowerShell, Shell Script, SQL Scripts, or Python. 10. Documentation & Knowledge Management Maintain: Runbooks SOPs HLD/LLD documents Recovery procedures Provide technical mentoring to L1/L2 teams. Conduct knowledge transfer sessions. Technical Skills Required Oracle Oracle Database Administration RMAN Oracle RAC Oracle Data Guard ASM OEM Cloud Control Microsoft SQL Server SQL Server 2016/2019/2022 Always On Availability Groups SSMS SQL Performance Tuning SQL Backup & Restore PostgreSQL Replication Streaming Replication PITR pgAdmin PostgreSQL Performance Tuning MySQL MySQL Replication MySQL Cluster Backup & Recovery Performance Optimization Common Skills Linux & Windows Administration Storage Concepts Backup Solutions (PPDM/Veeam/NetBackup) PowerShell/Shell Scripting ITIL Incident, Problem & Change Management Preferred Certifications Oracle Certified Professional (OCP) Microsoft SQL Server Certifications PostgreSQL Professional Certification MySQL Database Administrator Certification ITIL Foundation Key KPIs Database Availability ≥ 99.9% Backup Success Rate ≥ 98% Restore Success Rate = 100% Incident Resolution Within SLA Successful Completion of Patch & Upgrade Activities Database Performance Compliance Zero Critical Data Loss Events

Skill Requirements

Database Administration Administer and maintain Oracle, PostgreSQL, MySQL, and Microsoft SQL Server databases. Install, configure, upgrade, and patch database servers. Manage database instances, schemas, tablespaces, and storage allocation. Ensure database availability, performance, and reliability. 2. Backup, Recovery & Restoration Configure and monitor database backups. Perform backup validation and recovery testing. Execute point-in-time recovery (PITR) and disaster recovery procedures. Support database restore requests and data recovery activities. 3. Database Performance Management Monitor database health and performance. Troubleshoot slow-running queries and blocking sessions. Optimize indexes, execution plans, and database configurations. Perform capacity planning and storage optimization. 4. High Availability & Disaster Recovery Manage: Oracle Data Guard SQL Always On Availability Groups (AOAG) PostgreSQL Replication MySQL Replication Database Clustering Solutions Conduct DR drills and failover testing. Ensure RPO and RTO compliance. 5. Incident & Problem Management Act as L3 escalation point for database-related incidents. Troubleshoot: Database outages Replication failures Backup failures Performance degradation Connectivity issues Perform Root Cause Analysis (RCA) for recurring issues. 6. Security & Compliance Manage database security policies. Implement role-based access control (RBAC). Monitor privileged access and audit logs. Ensure compliance with organizational security standards. 7. Change & Release Management Plan and implement: Database upgrades Security patching Schema modifications Database migrations Participate in CAB reviews. Execute maintenance activities during approved windows. 8. Migration & Upgrade Activities Perform database migrations between versions and platforms. Support cloud migration initiatives. Execute database consolidation and modernization projects. Validate application connectivity post-migration. 9. Automation & Scripting Develop scripts for: Database monitoring Backup validation Health checks Reporting Automation of routine DBA tasks Use PowerShell, Shell Script, SQL Scripts, or Python. 10. Documentation & Knowledge Management Maintain: Runbooks SOPs HLD/LLD documents Recovery procedures Provide technical mentoring to L1/L2 teams. Conduct knowledge transfer sessions. Technical Skills Required Oracle Oracle Database Administration RMAN Oracle RAC Oracle Data Guard ASM OEM Cloud Control Microsoft SQL Server SQL Server 2016/2019/2022 Always On Availability Groups SSMS SQL Performance Tuning SQL Backup & Restore PostgreSQL Replication Streaming Replication PITR pgAdmin PostgreSQL Performance Tuning MySQL MySQL Replication MySQL Cluster Backup & Recovery Performance Optimization Common Skills Linux & Windows Administration Storage Concepts Backup Solutions (PPDM/Veeam/NetBackup) PowerShell/Shell Scripting ITIL Incident, Problem & Change Management Preferred Certifications Oracle Certified Professional (OCP) Microsoft SQL Server Certifications PostgreSQL Professional Certification MySQL Database Administrator Certification ITIL Foundation Key KPIs Database Availability ≥ 99.9% Backup Success Rate ≥ 98% Restore Success Rate = 100% Incident Resolution Within SLA Successful Completion of Patch & Upgrade Activities Database Performance Compliance Zero Critical Data Loss Events

Other Requirements

Database Administration Administer and maintain Oracle, PostgreSQL, MySQL, and Microsoft SQL Server databases. Install, configure, upgrade, and patch database servers. Manage database instances, schemas, tablespaces, and storage allocation. Ensure database availability, performance, and reliability. 2. Backup, Recovery & Restoration Configure and monitor database backups. Perform backup validation and recovery testing. Execute point-in-time recovery (PITR) and disaster recovery procedures. Support database restore requests and data recovery activities. 3. Database Performance Management Monitor database health and performance. Troubleshoot slow-running queries and blocking sessions. Optimize indexes, execution plans, and database configurations. Perform capacity planning and storage optimization. 4. High Availability & Disaster Recovery Manage: Oracle Data Guard SQL Always On Availability Groups (AOAG) PostgreSQL Replication MySQL Replication Database Clustering Solutions Conduct DR drills and failover testing. Ensure RPO and RTO compliance. 5. Incident & Problem Management Act as L3 escalation point for database-related incidents. Troubleshoot: Database outages Replication failures Backup failures Performance degradation Connectivity issues Perform Root Cause Analysis (RCA) for recurring issues. 6. Security & Compliance Manage database security policies. Implement role-based access control (RBAC). Monitor privileged access and audit logs. Ensure compliance with organizational security standards. 7. Change & Release Management Plan and implement: Database upgrades Security patching Schema modifications Database migrations Participate in CAB reviews. Execute maintenance activities during approved windows. 8. Migration & Upgrade Activities Perform database migrations between versions and platforms. Support cloud migration initiatives. Execute database consolidation and modernization projects. Validate application connectivity post-migration. 9. Automation & Scripting Develop scripts for: Database monitoring Backup validation Health checks Reporting Automation of routine DBA tasks Use PowerShell, Shell Script, SQL Scripts, or Python. 10. Documentation & Knowledge Management Maintain: Runbooks SOPs HLD/LLD documents Recovery procedures Provide technical mentoring to L1/L2 teams. Conduct knowledge transfer sessions. Technical Skills Required Oracle Oracle Database Administration RMAN Oracle RAC Oracle Data Guard ASM OEM Cloud Control Microsoft SQL Server SQL Server 2016/2019/2022 Always On Availability Groups SSMS SQL Performance Tuning SQL Backup & Restore PostgreSQL Replication Streaming Replication PITR pgAdmin PostgreSQL Performance Tuning MySQL MySQL Replication MySQL Cluster Backup & Recovery Performance Optimization Common Skills Linux & Windows Administration Storage Concepts Backup Solutions (PPDM/Veeam/NetBackup) PowerShell/Shell Scripting ITIL Incident, Problem & Change Management Preferred Certifications Oracle Certified Professional (OCP) Microsoft SQL Server Certifications PostgreSQL Professional Certification MySQL Database Administrator Certification ITIL Foundation Key KPIs Database Availability ≥ 99.9% Backup Success Rate ≥ 98% Restore Success Rate = 100% Incident Resolution Within SLA Successful Completion of Patch & Upgrade Activities Database Performance Compliance Zero Critical Data Loss Events