Senior Oracle Database Administrator (Oracle, Multi-Cloud) - Remote

ENTERPRISE APPLICATIONS CONSULTING

Senior Oracle Database Administrator (Oracle, Multi-Cloud) - Remote

Atlanta, GA
Full Time
Paid
  • Responsibilities

    Job Summary

    As a Senior Database Administrator specializing in Oracle Database Management within multi-cloud environments (AWS and Azure), you will play a critical role in deploying, managing, and optimizing Oracle databases across complex infrastructures.

    Key Responsibilities

    Technical Expertise & Advisory

    • Administer and optimize Oracle databases in multi-cloud environments, ensuring seamless integration with AWS and Azure services.

    • Provide expert guidance on Oracle database architecture, storage, partitioning, sharding, and high-availability configurations (RAC and Data Guard).

    • Oversee Day 2 operations, including advanced performance tuning, proactive monitoring, database patching, backup and recovery strategies, and security hardening.

    • Lead troubleshooting efforts for complex database issues, ensuring root cause analysis and timely resolution.

    • Stay updated on emerging database technologies, cloud-native tools, and Oracle advancements to recommend modern solutions to clients.

    Day 2 Operations Management

    • Manage the lifecycle of Oracle databases, including installations, upgrades, and patch management, ensuring zero or minimal downtime.

    • Implement and maintain high availability (HA) and disaster recovery (DR) setups, such as Oracle Data Guard and GoldenGate replication, across cloud platforms.

    • Design and implement robust monitoring solutions using tools like Oracle Enterprise Manager (OEM), CloudWatch, or custom scripts for multi-cloud environments.

    • Perform capacity planning, resource allocation, and optimization to maintain database scalability and cost efficiency.

    • Ensure compliance with security standards, enforcing database encryption, auditing, and user privilege management.

    Database Migration Management

    • Lead large-scale database migration projects, including on-prem to cloud and inter-cloud migrations, ensuring minimal disruption to operations.

    • Develop detailed migration plans, leveraging tools like RMAN, Oracle Data Pump, Data Guard, and GoldenGate for secure and efficient transitions.

    • Manage dependencies, network configurations, and post-migration performance validation to deliver smooth migrations.

    Automation and Scripting

    • Create and maintain automation scripts for database provisioning, patching, and routine maintenance using Bash, Python, or Ansible.

    • Implement Infrastructure as Code (IaC) solutions using Terraform or CloudFormation to streamline deployment of database resources in cloud environments.

    • Optimize operational workflows by integrating automated alerts, health checks, and backup strategies.

    Support & Escalation Management

    • Take ownership of complex technical escalations, managing issues through to resolution in collaboration with engineering and support teams.

    • Establish and maintain SLAs for database uptime, performance, and recovery, ensuring client satisfaction.

    • Train and mentor junior DBAs, enabling skill development and ensuring adherence to best practices.

    Client Relationship Management

    • Act as a trusted advisor and technical expert for assigned clients, fostering relationships built on credibility and proficiency.

    • Conduct periodic reviews to understand client goals, database infrastructure, operational challenges, and cloud architecture needs.

    • Represent client requirements internally to engineering and product teams, ensuring alignment with technical priorities.

    Qualifications

    Education & Experience

    • Bachelor’s degree in Computer Science, Information Technology, or a related field (or equivalent work experience).

    • 14+ years of hands-on experience in Oracle Database Administration, including high availability, replication, and performance tuning in enterprise-scale environments.

    • Proven experience with multi-cloud environments (AWS and Azure), including database deployment, migration, and management.

    Technical Skills

    • Extensive experience with Oracle Database architecture, RAC, ASM, partitioning, and sharding.

    • Expertise in database migration tools and methodologies, including RMAN, Data Pump, Oracle Data Guard, and GoldenGate.

    • Proficiency in AWS and Azure database services, including RDS, EC2-based database hosting, and Azure SQL Managed Instances.

    • Strong command of Linux environments and shell scripting (Bash, Python, Ansible) for database automation and maintenance.

    • Knowledge of Infrastructure as Code (IaC) tools such as Terraform or CloudFormation for database resource provisioning.

    • Experience with monitoring tools like OEM, CloudWatch, or Prometheus for proactive database health and performance management.

    Soft Skills

    • Strong analytical and problem-solving skills, with a methodical approach to troubleshooting.

    • Excellent communication and documentation skills, capable of conveying technical concepts to diverse audiences.

    • Proactive, self-motivated, and adept at managing multiple priorities in dynamic environments.

    Certifications

    • Oracle certifications (e.g., Oracle Certified Professional, Oracle Database Administrator Certified Expert) are highly desirable.

    • Cloud certifications (e.g., AWS Certified Database - Specialty, Azure Database Administrator) are a plus.

    This is a remote position.