Manager - Product and Core Platforms

A Position Overview

Position Title

Manager - SQL Developer MSSQL, PostgreSQL, Oracle

Department

IT - Product and Core Platforms

Level/ Band

Manager

Role Summary : The Developer will be responsible for designing, developing, and maintaining applications. The ideal candidate should have a deep understanding of application architecture principles and best practices, with experience in cloud-based technologies for migration and integration, query optimization, maintenance of Databases.

B Organizational Relationships

Reports to

SM

Supervises

AVP

C Job Dimensions

Geographic Area Covered

PAN India

Stakeholders Internal

TDA-BSG and all other TATA AIA internal departments

External

Partners

D Key Result Areas

Implement and Optimize Operational data

Maintain Master Data Management

Prepare and Organize for Big Data

Integral Part of BI initiatives

Design and implement database in accordance to end users information needs and views

Define and implement database schemas and normalization

Develop, implement, and optimize stored procedures and functions using T-SQL

Review and interpret ongoing business report requirements

Develop procedures and scripts for data migration

Provide data management support to users

Ensure performance, security, and availability of databases

Prepare documentations and specifications for database design, coding, and testing

Handle common database procedures such as upgrade, backup, recovery, migration, etc.

Profile server resource usage, and optimize and tweak as necessary

Collaborate with other team members and stakeholders

Analyse existing SQL queries for performance improvements

Perform tests and evaluations regularly to ensure data security, privacy, and integrity

Resolve database-related issues and provide solutions in a timely manner

Stay updated with recent technological advancements and industry trends in database development

Complex query understanding

Follows all required company policies and practices relating to the System Development Life Cycle.

Technical Tools:

Databases - MS SQL Server, Teradata BI Tools, SSIS, SSRS, Etl.

Good to have - PostgreSQL

E Competencies ( Please copy paste from Competency Dictionary)

Competency For

Proficiency Scale

Proficiency Scale Description

Eg

Business Acumen and Strategic Orientation

Ability to align with the organizations vision with a fair understanding of the insurance industry, regulations, financial markets and the agency business model in order to deliver profitable and sustainable business growth.

3

Has an in-depth understanding of the market of operations and proposes changes if required as per market dynamics.
Understands how and to what extent business complexities impacts ones own area of work.
Is able to identify trends and analyze performance of self and various branches in ones geography.
Has expert knowledge of BA model, BA compensation and Agent commission and progression and uses it to deliver superior performance.
Is able to device plans to recruit, develop and sustain distributors on a long term basis with organization.
Strives towards achieving proportionate business contribution from all the branches of assigned territory.

G Skills Required

Technical

Min 10 years experience in MS SQL Server, Teradata BI Tools, SSIS, SSRS, ETl.

Good to have - PostgreSQL

Knowledge of JSON and PostgreSQL support for JSON.

PostGIS proficiency and grasp of core geospatial concepts.

Ability to efficiently write database code without compromising data quality, privacy or security.

Knowledge of database design principles, query optimization, index management, integrity checks, statistics and isolation levels

Able to handle multiple tasks in a fast paced environment

Excellent verbal, written, and interpersonal communication skills.

Ability to evaluate alternative solutions and/or workarounds

Behavioral

Essential

Desired

Interpersonal skills

Communication skills

Creative thinking skills

Supervising/Leadership skills

Teamwork Skills

Influencing skills

Relationship Building skills

Decision making skills

H Incumbent Characteristics

Essential

Desired

Qualification

Bachelor or equivalent degree in computer Science, Information systems, Engineering

Experience

Min 10 years of experience