Database Administrator
Alpharetta, GA, US • Posted 10 hours ago • Updated 10 hours ago

Clarkstech
Dice Job Match Score™
🫥 Flibbertigibetting...
Job Details
Skills
- oracle
- AWS
Summary
POSITION INFORMATION
Job Title: Database Administrator
Status: Open
Job Type: Fulltime
Work Type: Onsite
C2C Allowed: No
Contract Duration: 1 year
JOB DESCRIPTION
We are looking for a highly skilled and experienced Senior oracle DBA with deep expertise in Oracle GoldenGate replication, zero-downtime migration to Amazon RDS, and Patching mission critical databases. This role requires deep expertise in Oracle database administration , high-availability solutions, performance tuning, and real-time data replication using GoldenGate in both Classic and Microservices architectures in complex production environment .
Key responsibilities
Manage and administer Oracle databases(11g, 12c, 19c and later) in large-scale, mission-critical environments.
Design, configure, deploy, monitor, and maintain replication using Oracle dataguard and Goldengate solutions.
Design, implement and manage GoldenGate bidirectional(active-active) replication for high availability and data consistency.
Troubleshoot and resolve GoldenGate replication issues including lag, data consistency and performance bottlenecks.
Lead oracle to Amazon RDS migration projects with zero downtime using GoldenGate or Aws DMS, ensuing no data loss.
Perform performance turning of oracle databases and queries
Plan and execute database patching, upgrades, and migrations
Implement and support high availability and disaster recovery configurations
Implement and maintain monitoring for replication lag, performance metrics, and fault tolerance(using OEM or custom scripts).
Automate routine database task using scripting languages
Work with developers and application teams to optimize SQL and PL/SQL code.
Create and maintain documentation for architecture, configuration, and operational procedures.
Participate in 24*7 on-call support rotations as needed.
Must have skills
7-8 years of hands-on exercises in GoldenGate classic architecture and Microservices architecture
In-depth kowldege of conflict detection and resolution
Expertise in DDL replication, heartbeat table monitoring and loop detection in active-active replication
Proficiency in tuning Extract, pump, and Replicat for high-volume workloads.
Familiarity with could-native rds features : Multi-AZ failover, backups, monitoring and parameter groups.
Proven delivery of zero-downtime migrations to AWS RDS using GoldenGate, Data Guard, or AWS DMS.
Other skills
Deep SQL and PL/SQL tuning skills.
Knowledge of Oracle RAC, ASM, Data Guard, RMAN and Flashback
Familiar with Devops workflows and CI/CD pipelines for database deployments.
Nice to have
Experience with hybrid environments integrating oracle with kafka, PostgreSQL or NoSQL systems.
Hands-on experience with Oracle 19c or 23c, including JSON,In-Memory and AutoML features.
LOCATIONS
1. Alpharetta, GA
REQUIRED SKILLS
1. Oracle
2. AWS
3. PostgreSQL
WORK AUTHORIZATION ACCEPTED
1.
2. Permanent Resident
3. EAD
INTERVIEW ROUNDS
1. Client Interview
2. Vendor Interview
- Dice Id: 91165214
- Position Id: 8862210
- Posted 10 hours ago
Company Info
About Clarkstech
At ClarksTech, we are a renowned global IT consulting firm committed to collaborating with business and societal leaders in overcoming their most critical challenges and seizing their greatest opportunities. Our achievements are rooted in fostering deep collaboration and cultivating a global community of diverse individuals who are dedicated.
We have highly skilled engineers with excellent technical knowledge and experience in using the latest software standards. We have built a large pool of knowledge that we apply to deliver solutions that meet client’s needs, expectations and budget.
Similar Jobs
It looks like there aren't any Similar Jobs for this job yet.
Search all similar jobs