Oracle DBA/Developer (VP)

The Applications Development Technology Lead Analyst is a senior level position responsible for providing Application Database support to the entire reference data applications for database & application enhancements.The overall objective of this role is to lead application database administration, architect resilient database solutions and performance tuning efforts.

Responsibilities:

• Able to make changes to the existing Data Model (Logical & Physical),

Implement Changes, build deployment packages using CI/CD pipelines

such as Client Project 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.

• Should be able to help in finding current performance bottlenecks and

provide solutions to improve performance

• 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.

• Extensive experience with Database compression and purging

techniques.

• Experience with enabling encryption data in transit and at rest.

• Experience with MSSQL, mongoDB and postgres will be an added

advantage.

• Partner with multiple management teams to ensure appropriate integration

of functions to meet goals as well as identify and define necessary system

enhancements to deploy new products and process improvements

• Resolve variety of high impact problems/projects through in-depth

evaluation of complex business processes, system processes, and

industry standards

• Provide expertise in area and advanced knowledge of applications

programming and ensure application design adheres to the overall

architecture blueprint

• Utilize advanced knowledge of system flow and develop standards for

coding, testing, debugging, and implementation

• Develop comprehensive knowledge of how areas of business, such as

architecture and infrastructure, integrate to accomplish business goals

• Provide in-depth analysis with interpretive thinking to define issues and

develop innovative solutions

• Serve as advisor or coach to mid-level app DBAs and developers,

allocating work as necessary

• Appropriately assess risk when business decisions are made,

demonstrating particular consideration for the firm's reputation and

safeguarding Banking, its clients and assets, by driving compliance with

applicable laws, rules and regulations, adhering to Policy, applying sound

ethical judgment regarding personal behavior, conduct and business

practices, and escalating, managing and reporting control issues with

transparency.

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

Education:

• Bachelor's degree/University degree or equivalent experience

• Master's degree preferred

This job description provides a high-level review of the types of work performed.

Other job-related duties may be assigned as required.

• Additional Job Description

Essential :

Oracle 19c/23ai, RHEL7/8, GoldenGate 19c/23c, MySQL, PostgreSQL, Sybase, MS SQL Server, AWS, UDeploy, Client Project, TPAM, CyberArk, Autosys, Python Scripting, Ansible, Shell scripting, PL/SQL, T-SQL, mongoDB, ServiceNow.

Leadership skills, Great communication, Team player, Ownership & Accountability.