Dba Infra, Avp

**DBA INFRA, AVP**:
**Job ID**:R0336731

**Full/Part-Time**:Full-time

**Regular/Temporary**:Regular

**Listed**:2025-01-13

**Location**:Pune

**Position Overview**:
**Job Title**:

- **DBA INFRA,**AVP**

**Location
- Pune, India**

**Role Description**

**What we’ll offer you**

As part of our flexible scheme, here are just some of the benefits that you’ll enjoy
- Best in class leave policy
- Gender neutral parental leaves
- 100% reimbursement under childcare assistance benefit (gender neutral)
- Sponsorship for Industry relevant certifications and education
- Employee Assistance Program for you and your family members
- Comprehensive Hospitalization Insurance for you and your dependents
- Accident and Term life Insurance
- Complementary Health screening for 35 yrs. and above

**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
- Measures and analyses code for quality
- Collaborates with Functional Analysts and QA to complete work, as required.
- Reviews and mentor’s 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.
- 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 interperso