Role Purpose:

• The purpose of the role is to support process delivery by ensuring daily performance of the Production Specialists, resolve technical escalations and develop technical capability within the Production Specialists.

Job Description:

• This role is responsible for developing, enhancing, and supporting high‑performance Oracle PL/SQL–based data solutions while contributing to ongoing data modernization initiatives leveraging the Snowflake cloud data platform.

The ideal candidate will have strong database engineering fundamentals, hands‑on experience with Oracle PL/SQL, and working knowledge of Snowflake in support of analytical, reporting, and regulatory data workloads.

Key Responsibilities

• Design, develop, and maintain complex Oracle PL/SQL code including packages, procedures, functions, triggers, and views

• Support transactional (OLTP) and analytical (OLAP) data workloads with a focus on performance, reliability, and scalability

• Develop and optimize Snowflake SQL objects including tables, views, and schemas

• Support data transformation, validation, reconciliation, and audit controls

• Perform SQL and PL/SQL performance tuning, root‑cause analysis, and production issue resolution

• Partner with application teams, data engineers, and business stakeholders to deliver data solutions aligned with enterprise standards

• Participate in Agile ceremonies, sprint planning, and release execution

• Ensure compliance with SDLC, change management, data governance, and security standards

• Contribute to technical documentation, data models, and operational runbooks

Skills:

• • Bachelor’s degree in Computer Science, Engineering, or equivalent professional experience

• Strong hands‑on experience with Oracle SQL and PL/SQL in enterprise environments

• Proven experience developing and supporting complex PL/SQL‑based data solutions

• Experience working with Snowflake as a cloud data warehouse

• Solid understanding of relational data modeling and database design principles

• Experience supporting production data platforms and resolving performance issues

• Strong analytical, troubleshooting, and communication skills

• Experience with data warehousing concepts (dimensional modeling, star/snowflake schemas)

• Exposure to cloud platforms (AWS preferred)

• Experience with ETL, data pipelines, or data integration tools

• Familiarity with Unix/Linux environments and job scheduling tools

• Experience in financial services or regulated environments

• Knowledge of CI/CD practices and Agile delivery models

Key Competencies͏:

• • Database & Data Engineering Excellence

• Performance Optimization & Problem Solving

• Data Quality & Integrity

• Collaboration & Stakeholder Partnership

• Operational Readiness & Production Support

͏

Deliver

		No
		Performance Parameter
		Measure

		1
		Process
		No. of cases resolved per day, compliance to process and quality standards, meeting process level SLAs, Pulse score, Customer feedback, NSAT/ ESAT

		2
		Team Management
		Productivity, efficiency, absenteeism

		3
		Capability development
		Triages completed, Technical Test performance