Gaming, audiophile, sketching and photography
ALOK MISHRA
Sr. SQL Developer
Gurugram
Summary
- SQL Developer with a decade of experience in designing and maintaining robust data pipelines for enterprise-scale applications.
- Proficient in optimizing complex SQL queries to improve performance and reduce resource consumption, resulting in significant cost savings for the organization.
- Led the migration of multiple standalone applications into a centralized platform, resolving database incompatibilities and data inconsistencies while ensuring seamless integration and improved system efficiency.
- Built automated workflows for Power BI and Tableau dashboards, enabling data-driven decision-making for business stakeholders.
- Resolved complex data inconsistencies and collaborated with global teams to deliver scalable, high-performance solutions.
- Extensive experience in database development, administration, performance tuning, and migration of enterprise-scale systems.
Overview
12
12
years of professional experience
2
2
Certifications
Work History
Senior Database Developer
Accenture
03.2020 - Current
- Developed multiple automated data pipelines that fed into Power BI and Tableau dashboards, enabling business stakeholders to effectively compare performance and feature adoption across the application.
- Achieved monthly savings by optimizing long-running queries, eliminating need for lower environment servers during non-business hours.
- Led the migration of multiple standalone applications into a centralized platform, resolving heterogeneous database incompatibilities and complex data inconsistencies, while collaborating with global, cross-functional stakeholders to ensure seamless integration and improved system efficiency.
- Designed and implemented automated database maintenance solutions (statistics updates and index rebuilds) using Azure runtime, enhancing query optimization, reducing performance bottlenecks, and ensuring consistent database efficiency at scale.
- Implemented consistent coding practices, data modeling, and troubleshooting of deadlocks, while ensuring backup and recovery of the production database.
- Optimized query performance for an enterprise-scale application with 500+ users, tuning complex SQL workloads to enhance execution times and system responsiveness.
Associate
Cognizant
09.2014 - 05.2016
- Collaborated with cross-functional teams to design and implement efficient database schemas, enhancing overall application performance and reliability.
- Proactively identified and resolved performance bottlenecks and database risks, improving system stability and scalability.
- Optimized complex SQL queries and indexing strategies using execution plans and SQL Profiler, significantly enhancing database performance.
- Refactored existing database code to improve performance, maintainability, and scalability across enterprise applications.
- Designed and implemented data management processes, including import/export workflows, and backup and recovery procedures, ensuring data integrity and availability across systems.
- Partnered with infrastructure teams on database migrations, replication, backups, and data validation to support reliable and scalable system operations.
Education
B.Tech - Computer Science
Uttar Pradesh Technical University (UPTU)
Greater Noida, India01-2012
Skills
SQL
Certification
Microsoft AZ-900 : Azure Fundamentals
Interests
Timeline
Senior Database Developer
Accenture
03.2020 - Current
Associate
Cognizant
09.2014 - 05.2016
B.Tech - Computer Science
Uttar Pradesh Technical University (UPTU)