Senior Data Engineer – Oracle DBA – OCI

Role Overview

• Establish database standards for operations, upgrades, migrations and onboarding new applications and/or clients.
• Diagnose problem areas and develop solutions and/or workarounds by writing clear, concise, well-coordinated technical documentation to maintain standards and procedures.
• Monitor, configure, and maintain database platforms to ensure optimal performance, capacity planning, system health, and availability, proactively responding to alerts and rapidly diagnosing and resolving performance or stability issues.
• Support existing infrastructure, integrate new features, and implement the data architecture of the organization.
• Develop methods to seamlessly integrate products together, including customizing commercial databases to fit specific needs.
• Collaborate with project managers, systems analysts, engineers, application teams, customers, and enterprise partners to align database solutions with technical, operational, and business requirements.
• Perform application database administration (Oracle/Postgres) across all phases of the SDLC, including SQL code review, performance analysis and query tuning, logical and physical data modeling, database application design, and development support.
• Participate in proof-of-concept (POCs) efforts to evaluate and enable new technology solutions.
• Design and implement highly resilient and performing Oracle database platforms, using distributed database technologies.
• Participate in 24X7 on call rotation schedule for various production support, database maintenance, housekeeping and installations.
• Establish Continuous Integration and Continuous Delivery (CI/CD) pipelines to deploy code and services to Amazon Web Services (AWS) using Cloud based data platforms.

Requirements

• 5+ years of experience in Oracle Database technologies
• 3+ years of Cloud experience, AWS is preferred
• 5+ experience in Oracle Database Administration / Performance Engineering / Replication Engineering
• 1+ experience in DB performance for other database platforms
• 5+ years of experience in Distributed replication technologies (Oracle Goldengate, EDB Replication, etc.)
• Experience with cloud databases platforms (AWS/Azure/Oracle OCI certification is helpful)
• Possess domain expertise in Oracle internals, Optimizer, Statistics management, Partition management, Physical implementation and Workload management for highly scalable and resilient database platforms.
• Possess sophisticated skills in Query Performance Tuning and Optimization (PTO), Oracle Enterprise Manager Grid control (OEM 12c), Linux shell scripting, and writing database monitoring jobs in PL/SQL.

Tech Stack

• AWS
• Azure
• Cloud
• Linux
• Oracle
• Postgres
• SDLC
• Shell Scripting
• SQL

Benefits

• Health insurance
• 401(k) matching
• Flexible work hours
• Paid time off
• Professional development opportunities