Database Administration Lead Analyst

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.