Core Responsibilities
- Maintain Oracle databases across Cloud (OCI) and on-premises environments to meet organizational data storage and retrieval needs.
- Monitor and optimize database performance, including query tuning , indexing , and configuration adjustments .
- Perform regular maintenance tasks such as backups , patching , and version upgrades to ensure data consistency and system integrity.
- Implement performance monitoring and alerting solutions to proactively address performance issues.
- Troubleshoot and resolve database-related incidents and problems in collaboration with application teams.
- Support schema setup, load balancing, failover, and connection management for application teams.
- Proactively tune systems for performance and stability, ensuring SLAs are met for large-scale databases.
- Perform root-cause analysis and troubleshooting as a Linux Systems Admin/Engineer .
- Manage installations and configurations of Oracle RAC, Data Guard, and GoldenGate.
- Install and manage Oracle databases in OCI and Autonomous Transaction Processing (ATP) environments.
- Implement and manage cloud networking tasks such as IPsec VPN , FastConnect , and interconnectivity between cloud and on-premises systems.
- Apply best practices in cloud security , including identity and access management, encryption, and compliance.
- Develop and maintain backup and disaster recovery strategies to ensure data availability and business continuity.
- Integrate and manage Microsoft Active Directory (AD) security within database environments.
- Maintain appropriate levels of SQL Server security and access controls.
- Monitor, trend, and tune SQL databases, including running maintenance jobs (backups, DBCCs, indexing/re-indexing).
- Ensure SQL Server patching, installation, and backup processes are functioning as expected.
Essential Qualifications Experience
- Bachelor s degree in Computer Science, Information Technology, or a related discipline.
- Minimum 5 years of experience managing Oracle Database solutions in production environments.
- Expert-level knowledge of Oracle architecture, administration, and performance tuning.
- Strong understanding of networking, storage systems, and ASM disk groups .
- Hands-on experience with Oracle RAC, Data Guard, GoldenGate, and OCI deployments.
- Experience with SQL tuning , trace file analysis , listener logs , and alert logs .
- Proficiency in data extraction, transformation, masking, subsetting, and loading.
- Experience with SQL Server maintenance, performance tuning, and security.
- Ability to estimate work effort and manage multiple tasks in parallel.
Desirable Skills
- Oracle Certified Professional (OCP) or equivalent certification.
- Experience with Oracle Fusion applications.
- Experience working in Agile development environments.
- Exposure to finance or healthcare-related systems.
Key Competencies
- Flexible and open-minded, with a willingness to work with legacy and modern systems.
- Passionate about applying technology to solve business problems.
- Proactive, enthusiastic, and solution-oriented.
- Proven ability to deliver results in fast-paced, evolving environments.
- Creative thinker and effective collaborator.
- Comfortable navigating conflict and ambiguity.
- Team player with excellent written and verbal communication skills.
