Key Facts

Remote From:

Full time

English

Hard Skills

Query Optimization SQL (Programming Language) Microsoft SQL Server Data Engine (MSDE) High Availability Design Data Normalization Indexing Transactional Replication Stored Procedure Database Upgrades Data Partitioning +17 more

Other Skills

•
Plan Execution
•
Collaboration
•
Communication
•
Leadership
•
Mentorship
•
Problem Solving

Roles & Responsibilities

8+ years of experience in MS SQL Server development and administration.
Strong expertise in T-SQL, query optimization, and performance tuning.
Experience with database partitioning, indexing, and execution plan analysis.
Hands-on experience with ETL processes using SSIS, and experience with SSRS and Power BI.

Requirements:

Develop, optimize, and maintain stored procedures, functions, triggers, and views in Microsoft SQL Server.
Design normalized and denormalized data models for application performance.
Implement high availability solutions (Always On, Clustering, Replication, Mirroring) and manage database migrations, upgrades, and security enhancements.
Ensure data integrity, backups, disaster recovery, collaborate with development teams, and mentor junior SQL developers.

PradeepIT Consulting Services Pvt Ltd

About PradeepIT Consulting Services Pvt Ltd

Join PradeepIT: Innovating Information Technology and Solutions We pride ourselves on delivering exceptional results in the digital era of Information and Technology. With a track record of successful projects across offshore, nearshore, and onshore locations, we've built a clientele spanning 3 continents and 100+ companies. Our 380+ successful projects reflect our commitment to excellence. At PradeepIT, we prioritize the satisfaction of our resources, followed closely by meeting the needs of our clients and partner companies. Our service offerings include Outsourcing, Managed Services, Recruitment Process Outsourcing, Customer Relationship Management, Web Designing & Development, Content Development, and E-commerce Management. We specialize in SAP S/4 HANA, SAP Customer Data Cloud (Gigya), SAP CPQ (Calliduscloud), SAP Customer Experience, Mobility, Android, iOS & Hybrid development for native application developments. Our core value of "Join As Employee With Us And Grow Up As Entrepreneur" drives our mission. We proudly introduce our venture companies: 1. HG Infotech Pvt Ltd 2. Beli Brother Consulting Pvt Ltd 3. Involvemind 4. Stackglobe 5. Prastuti Consulting 6. Khahara Consulting 7. Thinkhigh And many more to come in the near future. We invite you to be part of our clients' success stories by adopting the latest technology and continually improving processes. If you'd like to learn more about us or have specific questions, visit www.pradeepit.com, call us at 08047363377, or email info@in.pradeepit.com. Let's work together on your next project!

Founded: 2018

Company size: 51 - 200

Website LinkedIn See all jobs →

Job description

Job Title: MSSQL Lead

Experience: 8+ Years

Location: Remote

Job Summary:

We are looking for an experienced MSSQL Lead to develop and maintain SQL Server databases for mission-critical applications. This role requires deep expertise in T-SQL, query optimization, indexing strategies, and high availability.

Key Responsibilities:

Develop, optimize, and maintain stored procedures, functions, triggers, and views in Microsoft SQL Server.
Design normalized and denormalized data models for application performance.
Optimize queries using indexing, execution plans, and partitioning.
Implement high availability solutions (Always On, Clustering, Replication, Mirroring).
Manage database migrations, upgrades, and security enhancements.
Ensure data integrity, backup, and disaster recovery processes.
Work closely with development teams to integrate databases efficiently.
Mentor junior SQL developers and provide best practice guidelines.
Required Skills & Qualifications:
8+ years of experience in MS SQL Server development and administration.
Strong expertise in T-SQL, query optimization, and performance tuning.
Experience with database partitioning, indexing, and execution plan analysis.
Hands-on knowledge of ETL processes using SSIS.
Experience in SQL Server Reporting Services (SSRS) and Power BI.
Familiarity with cloud-based SQL solutions (Azure SQL, AWS RDS) is a plus.
Strong problem-solving skills and the ability to handle large-scale databases.

Note: The candidate must have a minimum of 1+ years of MSSQL Lead experience.

Ready to apply?

APPLY

Share ·