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.
...An American multinational mass media and entertainment company is actively looking for a detail-oriented and creative Global Media Technician... ...for a hybrid skillset that encompasses all aspects of the digital supply chain: source content QC, basic editing, transcoding, and...
...Source One is a staffing services company and were currently looking for the following individuals to work as drivers for our client, a major AI technology company developing autonomous vehicles (AVs). Title: Vehicle Operator - Data Collection (Driver) Location:...
...and Sales Associates; train and develop store management in all aspects of the business... ...Planning and coordination of merchandise set ups, visual compliance, promotional signage... ...day, although some out-of-area and overnight travel is expected Qualifications:...
...Destination Group is an award-winning national destination and event management company with offices throughout California, Las Vegas, Florida... ...final program development and fulfillment. Booking and releasing of tentative holds for venues, vendors, and activities for...
...driving innovation with compelling assortments and experiences? If so, there is a great opportunity to join CVS as an Assistant Category Manager of Celebrations and Gifting. In this role, you will partner with your leadership to execute the strategy to drive these...