TD BPL - Lending - Engineer Postgres Admin

Job ID: R0328052
Full/Part-Time: Full-time


Regular/Temporary: Regular
Listed: 2024-05-03


Location: Pune

Position Overview

Job Title \xe2\x80\x93 Devops /DBA Location \xe2\x80\x93 Magarpatta Pune Role Description Engineer is responsible for managing or performing work across multiple areas of the bank\'s overall IT Platform/Infrastructure including analysis, development, and administration. It may also involve taking functional oversight of engineering delivery for specific departments. Work includes: \xe2\x80\xa2Planning and developing entire engineering solutions to accomplish business goals \xe2\x80\xa2Building reliability and resiliency into solutions with appropriate testing and reviewing throughout the delivery lifecycle \xe2\x80\xa2Ensuring maintainability and reusability of engineering solutions \xe2\x80\xa2Ensuring solutions are well architected and can be integrated successfully into the end-to-end business process flow \xe2\x80\xa2Reviewing engineering plans and quality to drive re-use and improve engineering capability \xe2\x80\xa2Participating in industry forums to drive adoption of innovative technologies, tools and solutions in the Bank. What we\xe2\x80\x99ll offer you As part of our flexible scheme, here are just some of the benefits that you\xe2\x80\x99ll 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

• Developing and maintaining database schemas, tables, views, and indexes.
• Optimize SQL queries, database structures, and indexing for maximum performance.
• Monitor and analyze database performance metrics.
• Building and setting up database instance in cloud (PostgreSQL )
• Troubleshoot and address database usage problems and malfunctions.
• Build and deploy monthly release artifacts for production and non production.
• Proficiency in Oracle Database administration and development.(Exacc , PostgreSQL)
• Building terraform codes to deploy infrastructure as a code
• Migrating databases from onprem to cloudSQL (DMS service/ORA to PG)
• Ensuring all SDLC and Release processes are followed and take proactive actions as and when necessary

Your skills and experience

• Should have strong experience in databases like Exacc DB, PostgreSQL
• Should aware about setting up infrastructure using terraform code and deployments on Google cloud platform.
• Experience in monitoring database performance and tuning SQL queries and identifying and resolving bottlenecks. Experience with AWR analysis. Experience in identifying performance issues for database.
• Configuration and managing databases such as Oracle, Cloud SQL, and PostgreSQL
• Understanding of cloud networking, security such as software defined networking/firewalls, virtual networks and load balancers.
• Hands on experience with build and deployment automation.

Good to have:

• Working with deployment and troubleshooting of Docker, GKE, OpenShift and Cloud Run
• Hands-on experience in development of large-scale enterprise systems
• Working knowledge of Linux commands and shell/python scripting
• Certification in Google professional Cloud DevOps Engineer
• Building CI/CD pipelines for cloud native PaaS services such as Databases, Application, Compute in Google Cloud Platform

. How we\xe2\x80\x99ll 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.

About us and our teams Please visit our company website for further information: https://www.db.com/company/company.htm Our values define the working environment we strive to create \xe2\x80\x93 diverse, supportive and welcoming of different views. We embrace a culture reflecting a variety of perspectives, insights and backgrounds to drive innovation. We build talented and diverse teams to drive business results and encourage our people to develop to their full potential. Talk to us about flexible work arrangements and other initiatives we offer.
We promote good working relationships and encourage high standards of conduct and work performance. We welcome applications from talented people from all cultures, countries, races, genders, sexual orientations, disabilities, beliefs and generations and are committed to providing a working environment free from harassment, discrimination and retaliation.

Visit Inside Deutsche Bank to discover more about the culture of Deutsche Bank including Diversity, Equity & Inclusion, Leadership, Learning, Future of Work and more besides.