DBA INFRA, AVP

The candidate in this role will architect, design, develop application code, implement technical solutions and configure applications in different environments in response to business problems. To meet the requirements of the business, the candidate will actively participate in architecture design, application development lifecycle, investigate issues (bugs/performance), propose solutions, promote re-usability of existing components and contribute to the creation of frameworks. The candidate will assist junior members of the team and guide them as applicable. Knowledge and prior experience of working on Trade finance domain will be an advantage.

Your key responsibilities

• Demonstrably solid software engineering skills.
• As part of a high-performing development team, design and deliver highly functional, robust, and scalable code.
• Review of long running queries and optimize it for production issues.
• Have hands-on knowledge on stored procedures, functions, packages, Objects etc
• Have performed database migrations with previous experiences.
• Review of AWR reports and suggest good execution plans of queries when needed.
• Leverage design patterns, test driven development (TDD) and behavior driven development (BDD) to build software that is reliable and easy to support in production.
• Experience of working in a team development environment as well as globally distributed project team
• Leads development of source code, including descriptions, for all software components in accordance with the detailed software requirements and design
• Experience in data modeling, database architecture and solution design
• Experience in understanding enterprise data models and documenting data attribute mapping & interface control requirements
• Actively participate and contribute in Agile ceremonies including Daily Stand up's, Sprint Planning, Sprint review, Sprint retrospective meetings
• Strong communication, negotiation, networking and influencing skills are essential because collaboration with end-users, technology and operational functions are critical to the relevance of the product.
• Verifies the developed source code/queries via reviews (4-eyes principle) and resolve review findings and recommend solutions
• Integrates software components following the groups integration strategy.
• Verifies integrated software components by unit and integrated software testing according to the software test plan. Software test findings must be resolved.
• Ensures all code changes are tracked and recorded through the groups change management process as Change Items (CIs) and that development is scheduled and approved.
• Provides Release Deployments on non-Production Management controlled environments.
• Perform refresh of lower environment data from production with all masking
• Captures Build and Deployment notes, develops Software Product Deployment & Operating Instructions
• Manages maintenance of applications and performs technical change requests scheduled according to Release Management processes.
• Measures and analyses code for quality
• Collaborates with Functional Analysts and QA to complete work, as required.
• Reviews and mentors other developers in developing solutions which perform to expected results and handle negative test case scenarios.
• Provides timely Level 3 support and resolves incidents and provide fixes for problem tickets.
• Actively contribute to Global Incident Management as Level 3, share root cause analysis and manage timely closure of problem tasks.
• Perform monitoring activities for database for production.
• Contributes to root cause/problem analysis and solution brainstorming.
• Collaborates with Functional Analysts and QA to complete work, as required.
• Create required documentation for the project.
• Recommend changes to improve established java application processes and its performance
• Shall be ready to learn new Java technologies as per the project requirements

Your skills and experience

• Hands-on experience on Oracle 19C, PL/SQL, PostgreSQL & SQL queries with very good debugging skills
• Good practical experience of database modelling and design
• Hands-on Experience in design, architecture, source code management, continuous build, continuous integration technologies, TDD, performance improvement and profiling tools
• Good to have knowledge with CI/CD using Jenkins is a plus.
• Experience with CyberArk profiling, and Google Cloud Platform is a plus
• OS: Linux, Windows
• Database: Oracle 19(preferred), PostgreSQL
• Platform Tools : Fabric, DAP
• Languages and Frameworks: Mybatis, Hibernate
• Tools: GIT, SQL Developer, PUTTY, Eclipse/IntelliJ, Maven, Ant, Linux/Unix shell scripting, JMS/MQ ,
• Other (Plus/Advantage):
  • ER/Studio, ERwin
  • Knowledge of Design Patterns

Key Attributes:

• Ability to architect/design solution for a given requirement
• Ability to provide technical leadership to the team

• Ability to write high quality code
• Ability to solve business or production problems
• Strong analytical skills
• Strong interpersonal, written and verbal communication skills, particularly in a multi-cultural environment
• Excellent team player
• Keeps pace with technical innovation

Experience and Education:

• Bachelors Degree from an accredited college or university with a concentration in Computer Science or equivalent
• 10+ years of relevant work experience
• Investment Banking experience will be advantage.

How we'll support you

• Training and development to help you excel in your career.
• Coaching and support from experts in your team
• A culture of continuous learning to aid progression.
• A range of flexible benefits that you can tailor to suit your needs.