Job Description:

Responsibilities:

• Able to make changes to the existing Data Model (Logical & Physical), Implement Changes, build deployment packages using CI/CD pipelines such as LightSpeed and promote them to higher environments (UAT, Production and Cob) following SDLC using Release on Demand.
• Excellent understanding on Database concepts including Procedures, Triggers, Packages, Database Constraints, Indexes, Table statistics using Oracle 19c and 23ai.
• Experience in designing, architecting and implement resilient database solutions.
• Review AWR, ADDM, ASH and other performance reports and provide performance enhancement solutions.
• Working knowledge of Linux Redhat, File System, Cluster Management(RAC) and Oracle ASM & ACFS.
• System analysis and design skill with knowledge of data flow diagrams, data dictionary techniques, case tools, Entity relation Modeling, design Technique etc
• Database Design Skill including normalization theory, STAR Schema Design and Data Modeling tool with proven experience of Process, Data flow and forward/reverse engineering of logical/physical RDBMS layout
• Change Control Management Skills using Source Control System
• Experience of working in a team that delivers a high availability service.
• Ensure weekend activities complete successfully through assignment, coordination, oversight and validation.
• Experience with Oracle Golden Gate 12c/19c/23ai implementation and support.
• Experience with building Database warehouse Solution.

Qualifications:

• 12+ years of relevant experience in Application DBA.
• Extensive experience in Application DBA, performance Tuning and GoldenGate implementation.
• Experience in managing and implementing successful projects
• Subject Matter Expert (SME) in at least one area of Applications Development
• Ability to adjust priorities quickly as circumstances dictate
• Demonstrated leadership and project management skills
• Consistently demonstrates clear and concise written and verbal communication