Note: The job is a remote job and is open to candidates in USA. Tekgence Inc is seeking a Senior Oracle Database Administrator to manage and optimize Oracle database environments. The role involves responsibilities such as installation, configuration, maintenance, performance tuning, and automation of Oracle databases, as well as ensuring high availability and security.
Responsibilities
- Install, configure, and maintain Oracle Grid Infrastructure, RAC, ASM, and Clusterware environments
- Design and support highly available Oracle database architectures utilizing RAC and Data Guard technologies
- Perform database provisioning, patching, cloning, upgrades, and lifecycle management
- Design, implement, and maintain Oracle Data Guard configurations
- Perform advanced Oracle performance tuning at database, SQL, RAC, ASM, and operating system levels
- Optimize SQL execution plans, partitioning strategies, and workload management
- Troubleshoot RAC interconnect, cluster, locking, and contention issues
- Manage schema upgrades and cross-environment data synchronization activities
- Perform data conversions and database re-platforming initiatives
- Engineer secure data transfer mechanisms utilizing Transportable Tablespaces (TTS), Data Pump (EXPDP/IMPDP), and advanced migration methodologies
- Design and manage data conversion, transformation, and database engineering solutions
- Install, configure, and administer Oracle GoldenGate 26AI Microservices architecture
- Develop GoldenGate Extracts, Replicats, Distribution Services, and Performance Metrics
- Troubleshoot replication lag, data inconsistency, and integration issues
- Implement encryption technologies including TDE, SSL certificates, and encrypted data transport mechanisms
- Implement and maintain advanced partitioning strategies including range, interval, reference, and composite partitioning
- Design Information Lifecycle Management (ILM) solutions
- Design and maintain storage optimization, archival, and data retention policies
- Support advanced Oracle object administration and schema engineering
- Develop and maintain advanced Shell, SQL, and PL/SQL scripts
- Implement Infrastructure as Code (IaC) and automation solutions using Ansible
- Automate database deployment, monitoring, patching, and maintenance activities
- Support UC4 workload automation where applicable
Skills
- Bachelor's degree in Computer Science, Information Technology, Engineering, or a related discipline
- 10+ years of Oracle Database Administration experience in large enterprise environments
- Extensive hands-on experience with Oracle 19c administration, including RAC, ASM, Grid Infrastructure, Data Guard, GoldenGate 26AI, RMAN, and OEM
- Experience administering Oracle environments on AIX and Linux platforms
- Demonstrated experience with High Availability and Disaster Recovery architectures
- Experience with Ansible automation and Infrastructure as Code
- Strong expertise in database performance tuning, SQL and PL/SQL development, Shell scripting, and large-scale database migrations
- Oracle Certified Professional (OCP) or Oracle Certified Master (OCM)
- Experience with Oracle GoldenGate 26AI Microservices
- Knowledge of Database Migration Services (DMS)
- Experience with UC4 workload automation solutions
Company Overview
Company H1B Sponsorship