27+ Stored Procedures Jobs in India

.Net Core Developer

Experience 2+ Yrs in .Net Core/C# Responsibilities Responsible for designing and developing REST APIs using .Net Core Framework and C#. Create high-performance REST APIs for financial applications. Qualifications B.Tech/BE or MCA – May be relaxed in the case of experienced candidates.

Experience At least 2+ Years of experience as .Net Core Developer Proficient in .Net Core and C# Excellent knowledge in developing REST APIs and Entity Framework Knowledge and experience in writing SQL, SPs, and Triggers Sound knowledge in MVC frameworks and databases. Good project management skills. Good communications skills A good team player

Salary 2 -8 LPA

Must have Expert level (5-7 years of development and maintenance experience) in MS SQL Server

·       Excellent skills in writing Stored Procedures, functions, triggers, queries, scripts, etc.

·       Excellent in troubleshooting, performance tuning, debugging, and query optimization

·       Excellent in indexing, finding and resolving potential for database deadlocks

·       Strong in database migrations and upgrades. 

·       Has experience with analytics and reporting.

·       3+ years of experience with SSIS, SSRS.

·       Has experience with Access DB.

·       Have a MS SQL Server certification OR are willing to obtain in a short time frame.

1.      Core Responsibilities

·        Leading solutions for data engineering

·        Maintain the integrity of both the design and the data that is held within the architecture

·        Champion and educate people in the development and use of data engineering best practises

·        Support the Head of Data Engineering and lead by example

·        Contribute to the development of database management services and associated processes relating to the delivery of data solutions

·        Provide requirements analysis, documentation, development, delivery and maintenance of data platforms.

·        Develop database requirements in a structured and logical manner ensuring delivery is aligned with business prioritisation and best practise

·        Design and deliver performance enhancements, application migration processes and version upgrades across a pipeline of BI environments.

·        Provide support for the scoping and delivery of BI capability to internal users.

·        Identify risks and issues and escalate to Line / Project manager. 

·        Work with clients, existing asset owners & their service providers and non BI development staff to clarify and deliver work stream objectives in timescales that deliver to the overall project expectations.

·        Develop and maintain documentation in support of all BI processes.

·        Proactively identify cost-justifiable improvements to data manipulation processes.

·        Research and promote relevant BI tools and processes that contribute to increased efficiency and capability in support of corporate objectives.

·        Promote a culture that embraces change, continuous improvement and a ‘can do’ attitude.

·        Demonstrate enthusiasm and self-motivation at all times.

·        Establish effective working relationships with other internal teams to drive improved efficiency and effective processes.

·        Be a champion for high quality data and use of strategic data repositories, associated relational model, and Data Warehouse for optimising the delivery of accurate, consistent and reliable business intelligence

·        Ensure that you fully understand and comply with the organisation’s Risk Management Policies as they relate to your area of responsibility and demonstrate in your day to day work that you put customers at the heart of everything you do.

·        Ensure that you fully understand and comply with the organisation’s Data Governance Policies as they relate to your area of responsibility and demonstrate in your day to day work that you treat data as an important corporate asset which must be protected and managed.

·        Maintain the company’s compliance standards and ensure timely completion of all mandatory on-line training modules and attestations.

2.      Experience Requirements

·        5 years Data Engineering / ETL development experience is essential

·        5 years data design experience in an MI / BI / Analytics environment (Kimball, lake house, data lake) is essential

·        5 years experience of working in a structured Change Management project lifecycle is essential

·        Experience of working in a financial services environment is desirable

·        Experience of dealing with senior management within a large organisation is desirable

·        5 years experience of developing in conjunction with large complex projects and programmes is desirable

·        Experience mentoring other members of the team on best practise and internal standards is essential

·        Experience with cloud data platforms desirable (Microsoft Azure) is desirable

3.      Knowledge Requirements

·        A strong knowledge of business intelligence solutions and an ability to translate this into data solutions for the broader business is essential

·        Strong demonstrable knowledge of data warehouse methodologies

·        Robust understanding of high level business processes is essential

·        Understanding of data migration, including reconciliation, data cleanse and cutover is desirable

Skill for BI Backend developer -

-SQL development (Snowflake preferred but any other version of SQL would work)

- ETL

- Stored Procedures

- Creating jobs and work flows in SQL

- some business knowledge

Responsibilities

• Design and implement Azure BI infrastructure, ensure overall quality of delivered solution 
• Develop analytical & reporting tools, promote and drive adoption of developed BI solutions 
• Actively participate in BI community 
• Establish and enforce technical standards and documentation 
• Participate in daily scrums  
• Record progress daily in assigned Devops items 

Ideal Candidates should have

• 5 + years of experience in a similar senior business intelligence development position 
• To be successful in the role you will require a high level of expertise across all facets of the Microsoft BI stack and prior experience in designing and developing well-performing data warehouse solutions 
• Demonstrated experience using development tools such as Azure SQL database, Azure Data Factory, Azure Data Lake, Azure Synapse, and Azure DevOps. 
• Experience with development methodologies including Agile, DevOps, and CICD patterns 
• Strong oral and written communication skills in English 
• Ability and willingness to learn quickly and continuously 
• Bachelor's Degree in computer science 

Job Profile

Purpose of Role: To support and maintain the existing and future applications managed by ABD (Agile Business Development) Team.

Main Responsibilities:

• To work on existing and future applications as required
• Work with ABD India Application Support and Business Support team to address production issues and/or to do development work
• Work with US ABD team to coordinate the on-going support and monthly release of C-Hub (Customer-Hub) application and other ABD Applications
• Report status to management on project progress
• Identify and escalate related issues and risks
• Coordinate with others in Development and Business Support team to implement new features of SQL Server/ MS Web based technologies 
• Assess current modules and offer performance improvements techniques  
• Make sure Database Design Standards/coding standards established by ABD are followed
• Constant communication with ABD leadership team in US.
• Problem Solving ability with “Can-do” attitude
• IT experience in Banking industry is preferred

Candidate Profile:

• Minimum 10 years of experience at least 3-5 years of experience in Corporate & Investment Banking area and Bachelor's degree in Engineering, Accounting, Finance, or equivalent
• Expertise with MS SQL Server development including SSIS and SSRS, Proficient in development of Stored procedure, Views, Functions etc in MS SQL Server
• Experienced with DBA kind tasks such as replication, linked server, query analyzer, DBCC commands, data transfer from one DB server to other DB Server etc
• Experienced in MS Excel VBA and macro scripting
• Knowledge of data Encryption in database

MANDATORY TECHNICAL SKILLS

SSRS, PowerBI, SQL Server 2008/2012, TSQL, Stored Procedures, Views, UDF’s, Triggers, Charts

EXPERIENCE

• 7+ years professional experience in database development using SQL Server 2008/2012(T-SQL, SSRS)

• Strong analytical and critical thinking skills, with the ability to analyze business requirements to determine

• processing flow, user requirements and inter-dependencies of multiple information systems.

• Experience with SDLC required

• Excellent verbal and written communication skills.

• Strong in performance tuning especially tuning complex queries, procedures and indexing strategies

Company Profile

Prescinto is a VC funded SaaS company in the renewable energy space enabling digital transformation for customers across the globe.

Prescinto provides solutions to improve power generation for Renewable energy power plants by identifying areas of underperformance and lost generation opportunities through patent pending methodologies; systematically addressing these through an automated workflow system to improve power generation for our customers.

 This is achieved by leveraging the IoT and Analytics platform built to collect high frequency data from distributed renewable energy assets and the comprehensive data lake.

 Roles & Responsibilities

 You are responsible for understanding the product architecture and Design laid out by the Architect and Develop product features in alignment with the architecture.

Product is built on Microsoft stack with Angular 11, .NET and data residing in MS SQL Server and InfluxDB, mobile application built on Flutter and data lake deployed on Azure environment. It extensively uses multi-threading for parallel processing, stored procedures for data access and leverages time-series database for storing high frequency equipment data.

In this role, you should be able to work independently as well as work with vendor and junior members to collaboratively build the features and take them to production. You need to be both a big picture thinker and in-depth problem solver, your knowledge and skills are both broad and deep.

Do you take pride in building customer centric functionalities with an eye on performance? Are you remembered for the quality of your code? This position is for you.

Desired Skills & Experience

• 8+ years of Product development experience of which at least 2 years should comprise of working independently with minimal supervision and guidance
• Experience with at least one full cycle development of product features from requirements to Production deployment to Post production support is critical
• Excellent Programming Skills using C#, WPF, MVVM, Winforms, .NET Framework, Windows Communication Foundation (WCF), ASP.net web api, SQL Server, Store Procedure, Triggers
• Solid Understanding of Multi-Threading and Parallel Programming
• Excellent understanding of Windows Operating System Internals (Process, Threads, Memory Management).
• Clear understanding of OOP and OOAD
• Excellent application debugging skills using Visual Studio Debugger
• Strong knowledge in design patterns, data structures and algorithms
• Experienced in developing Windows desktop applications
• Ability to work independently and be self-driven
• Should have knowledge on code repositories like SVN, GitHub etc and Agile tools like JIRA
• Should have excellent communication skills, excellent analytical and problem-solving skills
• Have working experience in Test-driven Development and Test Automation experience in third party control like DevExpress, Telerik WPF controls
• Experience building a SaaS product preferable
• Startup experience preferable

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

We are looking for a Senior Microsoft SQL Developer to design, develop, test, plan, implement and maintain conceptual and logical database models.

For this role, you should know how to analyze system requirements and implement migration methods for existing data. Hands-on experience with SQL Server 2012 and above is also required. Ideally, you are familiar with database design, reviewing code, writing stored procedures, creating and modifying SQL agent jobs, making structural changes to tables and views.

Ultimately, you will develop database solutions to ensure project information is stored effectively and securely.

We’re a fast-growing company with clients in the United States, UK, and Australia. You will join a team of talented developers, quality engineers, product managers whose mission is to impact above 100 million people across the world with technological services by the year 2030.

Working as Senior Microsoft SQL Developer at Navtech, you will:

1. Design conceptual and logical data models and flowcharts.
2. Improve system performance by conducting tests, troubleshooting, and integrating new elements.
3. Design and Build database systems of high availability and quality depending on each end user’s specialized role.
4. Help write and optimize in-application SQL statements.
5. Handle common database procedures such as upgrade, backup, recovery, migration, etc.
6. Ensure performance, security, and availability of databases.
7. Use high-speed transaction recovery techniques and backup data.
8. Provide proactive and reactive data management support and training to users.
9. Determine, enforce and document database policies, procedures, and standards.
10. Perform tests and evaluations regularly to ensure data security, privacy, and integrity.
11. Monitor database performance, implement changes, and apply new patches and versions when required.

1. 5+ years of experience in SQL Server Development with at least 1 year of Lead experience.
2. Advanced experience in database monitoring, troubleshooting, performance tuning, and high availability strategies for SQL Server 2016, SQL Server in Cloud (AWS RDS preferred).
3. Advanced skills in resolving database locking conflicts/blocking and resource utilization.
4. Ability to work with other developers and engineers to analyze database performance and identify problems in areas such as execution plans, index coverage, and SQL server statistics.
5. A thorough understanding of Performance Monitoring, Tuning, and Optimization, using native and third-party monitoring and troubleshooting tools.
6. Advanced knowledge of SQL Server Disaster Recovery (DR) options, Always On availability groups, and experience administering Windows Server, including Active Directory, Failover clustering, database partitioning, security, and encryption (a plus).
7. Experience supporting SSIS, SSRS, replication, database mirroring (a plus).
8. PowerShell scripting experience with the ability to write automated scripts and strong knowledge of system tables and DMV’s is required. (a plus).
9. Administering Microsoft SQL Server databases in a high transaction, 24x7 database environment (a plus).
10. Experience in Postgres, No-SQL databases (a plus).
11. MCSA SQL Server 2012/2016 , MCSE or MCDBA (a plus).
12. Should have excellent logical, analytical, and communication skills with client interaction experience.

Benefits

• Working with industry giants while following your passion for technology.
• Competitive pay package with additional bonus and benefits.
• Performance review and Appraisal Twice a year.
• Family Health Insurance cover for self and family.
• Work with US, UK, and Europe-based industry-renowned clients for exponential technical growth.
• Work with a culturally diverse team from different geographies

Job brief 

We are looking for a qualified Database developer to design stable and reliable databases, according to our company’s needs. You will be responsible for developing, testing, improving and maintaining new and existing databases to help users retrieve data effectively.

As part of our IT team, you will work closely with developers to ensure system consistency. You will also collaborate with administrators and clients to provide technical support and identify new requirements. Communication and organization skills are keys for this position, along with a problem-solution attitude.

Ultimately, you should be able to ensure our database systems run effectively and securely on a daily basis.

Responsibilities

• Design stable, reliable and effective databases
• Optimize and maintain legacy systems
• Modify databases according to requests and perform tests
• Solve database usage issues and malfunctions
• Liaise with developers to improve applications and establish best practices
• Gather user requirements and identify new features
• Develop technical and training manuals
• Provide data management support to users
• Ensure all database programs meet company and performance requirements
• Research and suggest new database products, services and protocols

Requirements

• Proven work experience as a Database developer (5+ Years)
• In-depth understanding of data management (e.g. permissions, recovery, security and monitoring)
• Knowledge of software development and user interface web applications
• Advanced proficiency and hands on experience with T-SQL, Stored Procedures, Cursors, Triggers, Schedulers etc.
• Familiarity working with MS SQL Server, MySQL, .Net Framework, java
• Excellent analytical and organization skills
• An ability to understand front-end users’ requirements and a problem-solving attitude
• Ability to craft detailed technical manuals.
• Excellent verbal and written communication skills
• BE/MCA/MSc Degree in Computer Science or relevant field.

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.

Must Have:

1. Strong proficiency with .Net Core API development
2. Experience with caching approaches for API
3. Hands on with SQL Server and its variation among popular databases
4. Well versed with stored procedures, query plans, altering the indexes, and troubleshooting the performance holdups
5. Skilled at performance optimization of .NET APIs
6. Experience & Knowledge on Open API specification & swagger documentation
7. Experience in building Cloud Native Applications
8. Experience in Microservices architecture
9. Has worked on the deployment of applications using Docker
10. Has Knowledge of Kubernetes
11. Has Experience with Cache systems like Redis.

Nice to Have:

1. Familiar with .NET design patterns
2. Performance tuning of SQL Stored Procedures

Note: We looking for immediate joiners. We expect the offered candidate should join within 15 days. Buyout reimbursement is available for 30 to 60 days notice period applicants who can ready join within 15 days.

What essential skills you need

• 4 -6 years’ experience in MySQL database development. You know your way around problems,logic & code but you occasionally need help with how to do things. That’s cool with us. We usestack overflow too.
• Expertise in database design & development (preferably on MySQL).
• Expertise in writing complex SQL queries, stored procedures, and functions, triggers.
• Expertise in performance tuning, query optimization, using performance monitor, SQL Profiler andother related monitoring and troubleshooting tools.
• BE/B.Tech ( or equivalent education), good written & communication Skills.

1. Strong proficiency with .Net Core API development
2. Experience with caching approaches for API
3. Hands on with SQL Server and its variation among popular databases
4. Well versed with stored procedures, query plans, altering the indexes, and troubleshooting the performance holdups
5. Skilled at performance optimization of .NET APIs
6. Experience & Knowledge on Open API specification & swagger documentation

1. Familiar with .NET design patterns
2. Performance tuning of SQL Stored Procedures

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

Mandatory Requirement/ Preference:

- 4 years of experience for delivering enterprise solutions or products using full SDLC 

- 4 years of work experience with enterprise solutions for Microsoft platform (SQL Server, stored procedures, WCF, C#.net, Entity Framework) 

- Extensive knowledge and experience with creating and maintaining stored procedure in MS SQL Server.

- Working with WEB API added advantage

You will get while working with us

• Opportunity to work on highly distributed systems with micro-services architecture and big-data volumes
• Solve challenging real-world problems by leveraging OOP & functional programming concepts
• Opportunity to incubate an open source project
• Get to work with cutting edge technologies to name a few Kafka, Elasticsearch, Postgres, Scala
• Developing scalable, sustainable and reliable enterprise systems
• Hands-on experience of working with TDD and BDD
• Develop environment using practices such as Continuous Integration, Continuous Delivery
• Learning opportunity on how to turn complex business requirements into a working product

Roles & Responsibilities

• Requirement understanding & analysis by interacting with client
• Carry out architectural and design discussions with fellow team members and come up with right approach
• Understand system domain, user’s perspective of system and use-cases
• Understand patterns in existing code and effectively leverage and improvise it 
• Develop backend involving Java8 based functional programming and REST services
• Ensure best practices of code reviews, automated testing and CI
• Research new tools & technologies required for the projects
• Mentor fellow team members and bring their level up

Must have

• Strong hold on written/verbal communication
• Strong core Java fundamentals
• Strong Analytical & problem solving skills
• Proactive and inherent nature of working with ownership
• Passion of writing clean code
• Experience in designing relational data model from business requirements

Good to have

• Knowledge of functional programming (Scala or Java 8 lambda)
• Knowledge of NOSQL
• Working knowledge of linux & networking
• Performance optimisation - Optimise/refactor queries, code, stored procedures to take performance next level