TATata AIA Life Insurance
Assistant Manager - Customer and Distribution Services
Mumbai ₹3-8 LPA Posted 5 May 2025
FULL TIME
Pl Sql
Database Development
Postgis
Sql
Json
+1 more
Job Description
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 like Azure and mobile development frameworks.
Geographic Area Covered
- PAN India
Stakeholders
Internal
- TDA-BSG and all other TATA AIA internal departments
External
- Partners
Key Result Areas
- Help write and optimize in-application SQL statements
- Ensure performance, security, and availability of databases
- Prepare documentation and specifications
- 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
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 analyse 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 devise 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.
Skills Required
Technical
- 3+ years working as a database developer working with Oracle/SQL and PostgreSQL
- Expert Level SQL, PL/pgSQL, including stored procedures, functions, triggers, and views.
- 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
Qualification
- Bachelor or equivalent degree in computer Science, Information systems, Engineering
Experience
- Min 3+ years of experience
