AWSAzureCassandraCloudLinuxMS SQL ServerOraclePostgresSDLCShell ScriptingSQLShellSnowflakeAmazon Web ServicesSQL ServerCI/CD
About this role
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.
Support existing infrastructure, integrate new features, and implement the data architecture of the organization.
Collaborate with project managers, systems analysts, engineers, application teams, customers, and enterprise partners.
Perform application database administration (Oracle/Postgres) across all phases of the SDLC, including SQL code review, performance analysis and query tuning.
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).
Requirements
5+ years of experience in Oracle Database technologies
3+ years of Cloud experience, AWS is preferred
5+ years of experience in Oracle Database Administration / Performance Engineering / Replication Engineering
1+ experience in DB performance for other database platforms (Postgres, CockroachDB, Snowflake, Cassandra, MS SQL Server, etc.)
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
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.
A good understanding of Oracle RAC related performance challenges
Ability to develop and drive database performance standards, standard methodologies and initiatives.