We at
Innovecture
are hiring for a
SQL Server Expert/Database Lead
to expand our team, this will be in
Gurgaon or Noida
. You will work across various Innovecture and client teams and apply your technical expertise to some of the most complex and challenging technology problems.About
Innovecture:
Founded in 2007 under the leadership of CEO Shreyas Kamat, Innovecture LLC, began as a U.S.-based Information Technology and Management Consulting Company focusing on technology consulting and services. With international development centers located in Salt Lake City, USA, and Pune, India, Innovecture leverages its Global Agile Delivery Model to effectively deliver client projects within budget scope and project deadline. The primary focus of Innovecture is to provide a unique wealth of expertise and experience to the IT and Management Consulting realm by utilizing various technologies across multiple industry domains. Innovecture uses best-in-class design processes and top-quality talent to ensure the highest quality deliverables. With innovation embedded in its consulting and services approach, Innovecture will continue to deliver outstanding results for its Fortune 500 clients and employees.
Key Responsibilities:
- Lead implementation, configuration, performance tuning, and maintenance of Microsoft SQL Server databases (must-have).
- Provide hands-on support for schema design, stored procedures, indexes, execution-plan analysis, and query optimization.
- Administer database security, user roles, backups, and disaster recovery for on-prem and cloud deployments.
- Troubleshoot and resolve database performance and availability issues; implement scalability improvements.
- Support MongoDB implementations and operationalization where applicable (good-to-have).
- Collaborate with analytics and reporting teams to integrate with Power BI, Qlik, Crystal Reports, and other BI tools.
- Coordinate with engineering teams on ETL/data integration processes and pipelines (good-to-have).
- Contribute to data architecture discussions and implementation plans; drive best practices for data modeling and governance (good-to-have).
- Document database designs, ER diagrams, runbooks, and operational procedures.
- Mentor and guide junior DBAs/engineers and provide technical leadership on database initiatives.
Key Skills & Experience:
- Must-have: Extensive, hands-on experience with Microsoft SQL Server — writing and optimizing stored procedures, triggers, complex queries, index strategy, and execution-plan tuning.
- Good-to-have: Experience with MongoDB (NoSQL operations, schema design, and performance considerations).
- Good-to-have: Familiarity with ETL tools/processes and data pipeline orchestration.
- Good-to-have: Exposure to Databricks and data lake integration.
- Strong understanding of database design principles, ACID properties, and high-performance schema design.
- Experience managing database security, backups, availability, and DR strategies.
- Familiarity with cloud database services and concepts (AWS-related experience is a plus).
- Excellent troubleshooting, documentation, and communication skills; demonstrated ability to lead technical teams.
Qualifications:
- 10–15 years of professional experience in database administration, database development, or data engineering with demonstrated leadership responsibilities.
- Proven track record of administering and optimizing Microsoft SQL Server in production environments (required).
- Experience with MongoDB, ETL processes, Databricks, or data architecture as desirable additions.
- Strong verbal and written communication skills; ability to collaborate effectively across teams.
