Job Description:
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.
Company: Joe & the Juice is a fast-growing freshly made juice, coffee, and sandwich concept. JOE was founded in Copenhagen in 2002 and has grown to +370 stores across 17 countries with more than 4,000 employees worldwide. The brand offers a healthy, convenient, and ambient...
...include: # Coordinate requests for medical records, including court subpoenas and requests from Federal, State and local regulatory and legal entities. Follow up on all requests and ensure timely response on all requests for medical records. # Process requests for patient...
...our clients unique we match them with the talent they need to continue to grow. We are currently searching for an Administrative Assistant for our client located in Libertyville, IL. Our client aspires to be focus-oriented, customer driven, positioned as the top tier mid...
Transfer Pricing Analyst Location Houston, TX (Westchase area) : NOV, Inc. Transfer Pricing Analyst The Transfer Pricing Analyst will report to the Transfer Pricing Manager in NOV's Corporate Tax Department. The Transfer Pricing Analyst will assist in developing...
...Join Our Team as a Quality Engineer/Manager - with a focus in Electrical Engineering Are you a dedicated professional with a passion for quality management in manufacturing? We're seeking a Quality Engineer/Manager to oversee and enhance our product and process quality...