10+ Stored Procedures Jobs in Mumbai | Stored Procedures Job openings in Mumbai

Key Responsibilities:

● Analyze and translate legacy MSSQL stored procedures into Snowflake Scripting (SQL) or JavaScript-based stored procedures.

● Rebuild and optimize data pipelines and transformation logic in Snowflake.

● Implement performance-tuning techniques such as query pruning, clustering keys, appropriate warehouse sizing, and materialized views.

● Monitor query performance using the Snowflake Query Profile and resolve bottlenecks.

● Ensure procedures are idempotent, efficient, and scalable for high-volume workloads.

● Collaborate with architects and data teams to ensure accurate and performant data migration.

● Write test cases to validate functional correctness and performance.

● Document changes and follow version control best practices (e.g., Git, CI/CD).

Required Skills:

● 4+ years of SQL development experience, including strong T-SQL proficiency.

● 2+ years of hands-on experience with Snowflake, including stored procedure development.

● Deep knowledge of query optimization and performance tuning in Snowflake.

● Familiarity with Snowflake internals: automatic clustering, micro-partitioning, result caching, and warehouse scaling.

● Solid understanding of ETL/ELT processes, preferably with tools like DBT, Informatica, or Airflow.

● Experience with CI/CD pipelines and Git-based version control

Note : One face-to-face (F2F) round is mandatory, and as per the process, you will need to visit the office for this.

Required Skills and Qualifications :

• Bachelor’s degree in Computer Science, Information Technology, or a related field. 
• Proven experience as a Data Modeler or in a similar role at a asset manager or financial firm. 
• Strong Understanding of various business concepts related to buy side financial firms. Understanding of Private Markets (Private Credit, Private Equity, Real Estate, Alternatives) is required. 
• Strong understanding of database design principles and data modeling techniques (e.g., ER modeling, dimensional modeling). 
• Knowledge of SQL and experience with relational databases (e.g., Oracle, SQL Server, MySQL). 
• Familiarity with NoSQL databases is a plus. 
• Excellent analytical and problem-solving skills. 
• Strong communication skills and the ability to work collaboratively. 

Preferred Qualifications: 

• Experience in data warehousing and business intelligence. 
• Knowledge of data governance practices. 
• Certification in data modeling or related fields.
•  

Key Responsibilities :

• Design and develop conceptual, logical, and physical data models based on business requirements. 
• Collaborate with stakeholders in finance, operations, risk, legal, compliance and front offices to gather and analyze data requirements. 
• Ensure data models adhere to best practices for data integrity, performance, and security. 
• Create and maintain documentation for data models, including data dictionaries and metadata. 
• Conduct data profiling and analysis to identify data quality issues. 
• Conduct detailed meetings and discussions with business to translate broad business functionality requirements into data concepts, data models and data products.

We are looking for an experienced DB2 developer/DBA who has worked in a critical application

with large sized Database. The role requires the candidate to understand the landscape of the

application and the data including its topology across the Online Data store and the Data

Warehousing counter parts. The challenges we strive to solve include scalability/performance

related to dealing with very large data sets and multiple data sources.

The role involves collaborating with global team members and provides a unique opportunity to

network with a diverse group of people.

The candidate who fills this role of a Database developer in our team will be involved in building

and creating solutions from the requirements stage through deployment. A successful candidate

is self-motivated, innovative, thinks outside the box, has excellent communication skills and can

work with clients and stakeholders from both the business and technology with

ease.

Required Skills:

Expertise in writing complex data retrieval queries, stored procs and performance tuning

Experience in migrating large scale database from Sybase to a new tech stack

Expertise in relational DB: Sybase, AZURE SQL Server, DB2 and nosgl databases

Strong knowledge in Linux Shell Scripting

Working knowledge of Python programming

Working knowledge of Informatica

Good knowledge of Autosys or any such scheduling tool

Detail oriented, ability to turn deliverables around quickly with high degree of accuracy Strong

analytical skills, ability to interpret business requirements and produce functional and technical

design documents

Good time management skills - ability to prioritize and multi-task, handling multiple efforts at

once

Strong desire to understand and learn domain.

Desired Skills:

Experience in Sybase, AZURE SQL Server, DB2

Experience in migrating relational database to modern tech stack

Experience in a financial services/banking industry

Job Role : Associate Manager (Database Development)

Key Responsibilities:

• Optimizing performances of many stored procedures, SQL queries to deliver big amounts of data under a few seconds.
• Designing and developing numerous complex queries, views, functions, and stored procedures
• to work seamlessly with the Application/Development team’s data needs.
• Responsible for providing solutions to all data related needs to support existing and new
• applications.
• Creating scalable structures to cater to large user bases and manage high workloads
• Responsible in every step from the beginning stages of the projects from requirement gathering to implementation and maintenance.
• Developing custom stored procedures and packages to support new enhancement needs.
• Working with multiple teams to design, develop and deliver early warning systems.
• Reviewing query performance and optimizing code
• Writing queries used for front-end applications
• Designing and coding database tables to store the application data
• Data modelling to visualize database structure
• Working with application developers to create optimized queries
• Maintaining database performance by troubleshooting problems.
• Accomplishing platform upgrades and improvements by supervising system programming.
• Securing database by developing policies, procedures, and controls.
• Designing and managing deep statistical systems.

Desired Skills and Experience  :

• 7+ years of experience in database development
• Minimum 4+ years of experience in PostgreSQL is a must
• Experience and in-depth knowledge in PL/SQL
• Ability to come up with multiple possible ways of solving a problem and deciding on the most optimal approach for implementation that suits the work case the most
• Have knowledge of Database Administration and have the ability and experience of using the CLI tools for administration
• Experience in Big Data technologies is an added advantage
• Secondary platforms: MS SQL 2005/2008, Oracle, MySQL
• Ability to take ownership of tasks and flexibility to work individually or in team
• Ability to communicate with teams and clients across time zones and global regions
• Good communication and self-motivated
• Should have the ability to work under pressure
• Knowledge of NoSQL and Cloud Architecture will be an advantage

Office Location: Goregaon Mumbai

Position description: 2+ years of experience in database development.

Primary Responsibilities:

• Understand requirements from front end applications developers
• Write advanced queries, stored procedures, cursors, functions & triggers
• Conduct code reviews
• Work with high-traffic application servers

Required Skills:

Mandatory: Passionate about sports, Problem solving, Team player, Target & Result oriented.

Functional: MSSQL Development - TSQL, Stored Procedures, & Triggers, Advance Queries, Optimization, Indexes, Joins, Database Design, JIRA.

Office Location: Goregaon Mumbai

Position description:

4+ years of experience in database development.

Primary Responsibilities:

• Understand requirements from front end applications developers
• Write advanced queries, stored procedures, cursors, functions & triggers
• Conduct code reviews
• Work with high-traffic application servers
• Complete understanding of various DB like Postgresql, Mongo DB, MySQL 
• Ability to identify root cause and mitigate issues
• Ability to lead a team of DB developers

Required Skills:

Mandatory: Passionate about sports, Problem solving, Team player, Target & Result oriented, Strong communication skills

Functional: Oracle SQL, PostgreSQL Development - TSQL, Advance Queries, Query Optimization, Stored Procedures, Triggers & Cursors, Database Design, Indexes, Joins, ETL tools like SSAS, SSIS, High Data Volume Processing, DB Backup/Recovery.

1) Core PHP: Yes/No(Mandatory)

2) JavaScript and JQuery: Yes/No(Mandatory)

3) Ajax: Yes/No

4) Curl: Yes/No

Github will be an added advantage

MYSQL: 

Stored Procedures: Yes/No

Indexes: Added advantage

Triggers: Added advantage