Senior DBA cum PLSQL Developer
Senior hybrid role (8-10 yrs) owning Oracle database environments end-to-end — installation, patching, RAC/Data Guard/ASM high availability, RMAN backup & recovery, tuning with AWR/ASH/ADDM, security and L2/L3 production support — while also designing and optimizing complex SQL/PL/SQL solutions (packages, ETL, migrations) and leading AWS/Azure cloud migration initiatives.
- Compensation
- ₹1M–₹1.5M / yr
- Location
- Kochi
- Work setup
- Hybrid
- Seniority
- Senior
- Employment
- Full time
- Experience
- 8+ years
- Category
- Not specified
- Posted
Skills
Must have
- 8-10 years of hands-on Oracle DBA and PL/SQL experience
- Administer Oracle 12c/19c/21c across Production, UAT, Development and DR environments
- Manage Oracle RAC, ASM and Data Guard for high availability and disaster recovery
- Design and validate RMAN backup/recovery strategies including point-in-time recovery
- Performance tuning using OEM, AWR, ASH and ADDM reports
- SQL tuning, query optimization, indexing and execution plan analysis
- Develop complex SQL/PL/SQL packages, procedures, functions and triggers
- Data modeling, schema design, ETL processes and data migration
- Shell and PL/SQL automation scripting for DBA operations
- Database security standards, user access controls, auditing and vulnerability remediation
- L2/L3 production support, incident management and RCA
- Experience with AWS RDS and Azure Oracle workloads / cloud migration
- Linux/Unix platforms
- Tools: SQL Developer, TOAD, Jira, ServiceNow
Nice to have
- Maintain documentation, SOPs and governance standards
Full description
Job Summary:
We are seeking an experienced Senior Oracle Database Administrator (DBA) and PLSQL Developer with 8-10 years of hands-on experience managing Oracle database environments end-to-end. The candidate will be responsible for the installation, configuration, administration, monitoring, performance optimization, security, backup & recovery, high availability, disaster recovery, database upgrades, and production support of Oracle databases across development, testing, and production environments and Design, develop, and optimize complex SQL/PLSQL database solutions, including data modeling, ETL, migration, and application integration, while collaborating with development teams to enhance scalability, maintainability, code quality, and database standards.
Oracle Database Administration
- Manage end-to-end Oracle database operations including installation, configuration, patching, upgrades, and maintenance.
- Administer Oracle 12c/19c/21c databases across Production, UAT, Development, and DR environments.
- Execute database cloning, refresh, migration, and deployment activities ensuring high availability and reliability.
Database Development & Engineering
- Design, develop, and optimise complex SQL, PL/SQL packages, procedures, functions, triggers, and database-driven application components.
- Support data modelling, schema design, ETL processes, data migration activities, and application database integration.
- Collaborate with development teams to improve scalability, maintainability, code quality, and database development standards.
High Availability, Backup & Recovery
- Manage Oracle RAC, ASM, and Data Guard environments to ensure business continuity and disaster recovery readiness.
- Design, implement, and validate RMAN backup and recovery strategies, including point-in-time recovery.
- Develop, test, and maintain failover, switchover, and disaster recovery procedures to meet availability SLAs.
Performance Tuning & Database Optimization
- Monitor database health and proactively identify performance bottlenecks using OEM, AWR, ASH, and ADDM reports.
- Perform SQL tuning, query optimization, indexing improvements, and execution plan analysis.
- Optimize database storage, memory, and configuration parameters to maximize system performance and scalability.
Security, Automation & Monitoring
- Implement database security standards, user access controls, auditing, and vulnerability remediation activities.
- Develop Shell, PL/SQL, and automation scripts to streamline routine DBA operations and maintenance tasks.
- Establish monitoring, alerting, capacity planning, and forecasting processes to ensure proactive database management