Key Responsibilities:
Database Administration & Maintenance
- Install, configure, and upgradeOracle Databasesoftware and related tools.
- Perform regulardatabase maintenancetasks including patching, tuning, backup, and recovery.
- Monitor and optimizedatabase performance, identifying bottlenecks and applying tuning methods (SQL tuning, index adjustments, optimizer improvements).
- Managetablespaces, schemas, partitions, datafiles, and user permissions.
- Implement and maintainbackup and recovery strategiesusing RMAN or other tools.
- Ensurehigh availabilitythrough Oracle RAC, Data Guard, or other clustering/replication technologies.
Security & Compliance
- Apply databasesecurity policies, including encryption, auditing, and access control.
- Ensure compliance with company, industry, and regulatory standards for data protection and privacy.
- Conduct regulardatabase auditsand vulnerability assessments.
Performance Monitoring & Troubleshooting
- Monitor database health using Oracle Enterprise Manager or equivalent tools.
- Diagnose and resolveperformance issues, system errors, and database failures.
- Optimize SQL queries and application database interactions to improve efficiency.
Data Management & Support
- Support development teams withdatabase design, query tuning, stored procedures, and data modeling.
- Managedata migrations, imports/exports, and refreshesbetween environments.
- Provide24/7 on-call supportfor critical production issues when needed.
Documentation & Collaboration
- Maintain detailed documentation of database configurations, standard operating procedures (SOPs), and recovery plans.
- Collaborate with system administrators, developers, and application teams to ensure seamless integration and system reliability.
- Participate in capacity planning and scalability initiatives to support future growth.
Qualifications & Skills:
Required:
- Bachelor's degree in Computer Science, Information Technology, or a related field.
- Proven experience as an Oracle DBA(Oracle 11g/12c/19c or higher).
- Strong knowledge of:
- Oracle Database Architecture
- RMAN backup and recovery
- SQL and PL/SQL
- Oracle RAC, Data Guard, ASM
- Database security and encryption
- Performance tuning and optimization
- Experience with Linux/Unix environments.
- Strong analytical, troubleshooting, and problem-solving skills.
- Ability to work in fast-paced, mission-critical environments.
Preferred:
- Oracle certifications (OCA, OCP, OCM).
- Experience withcloud databases(Oracle Cloud, AWS RDS, Azure DB).
- Knowledge of scripting languages (bash, shell, Python).
- Experience with Oracle GoldenGate or other replication tools.
- Familiarity with DevOps pipelines or CI/CD environments.
