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.