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.
...LaSalle Network has aggressive growth plans for 2025 and beyond, and we want you to grow with us. Come join us as an Entry-Level Recruiter ! What's in it for you? With a training program recognized as one of the best in the nation, our team will take the time...
Position Location: Hybrid Primary: Birmingham AL Secondary: Other tech hubs (Pittsburgh, Strongsville, Phoenix, Dallas) Technical Skills: 6+ years Salesforce Sales Console LWC - Lightening Web Components- expertise Salesforce Object Query Language...
...Beacon Hill Legal is seeking an Legal Administrative Clerk for a contract to hire opportunity with a notable law firm based in Richmond, VA. This is an exciting entry-level opportunity to gain experience into the legal field!~ The role includes a variety of legal support...
...Position Summary Our company is hiring for an Early Childhood Lead Teacher to join our team. As an Early Childhood Lead Teacher the... ...Educare model If having a child with an I.E.P. (Individual Education Plan) or I.F.S.P. (Individual Family Service Plan) seek...
...Job Description We are looking for a high-energy, passionate, health and fitness focused individual to join our team of coaches at Caledonia Fit Body Boot Camp. We are Currently Hiring Group Fitness Coach/Group Personal Trainer Part-Time (10-30 hours/week)...