Rahul Kushwaha
Bhopal
Summary
SQL Server DBA with 11 years of experience managing large-scale databases. Expertise includes high availability, performance tuning, query optimization, database migration, server configuration, disaster recovery.
Overview
12
12
years of professional experience
1
1
Certification
Work History
SQL Server Database Administrator
Eclat Infotech Pvt. Ltd.
Remote
10.2022 - Current
- Project: California Psychics (USA).
- Global online platform offering psychic readings via phone, chat, and mobile app.
- Over 25 years of experience in the industry, with a strong customer base in the USA and worldwide.
- Provides personalized guidance on relationships, careers, finances, and life decisions.
- Offers services through a network of professional psychics, available 24/7.
- High-traffic production environment, with real-time session tracking and billing.
- Backend systems include secure handling of customer profiles, session logs, and payment data.
Database Administrator
Madhya Pradesh State Electronics Development Corporation Ltd.
Bhopal
07.2021 - 10.2022
- Project: CCTNS (Crime and Criminal Tracking Network and Systems)
- Managed centralized SQL Server databases for statewide FIR tracking and police investigation data.
- Ensured 24/7 uptime for the CCTNS portal by configuring replication and implementing HA/DR mechanisms.
- Coordinated with police department stakeholders to ensure real-time updates of FIR statuses and multimedia crime data.
Database Administrator
Photon Grafix and Innovation Pvt. Ltd.
Bhopal
06.2018 - 07.2021
- Project: MP Police Dial 100 Emergency Response System.
- Managed and optimized SQL Server databases, handling 50,000–70,000 emergency calls daily across the state.
- Implemented partitioning and archival strategies for call records to ensure system scalability and performance.
- Designed robust monitoring scripts to track data growth and query execution times.
- Supported application teams in analyzing and troubleshooting slow-running queries, and system alerts.
Database Administrator
InteleCorp Software (I) Pvt. Ltd.
Mumbai
07.2016 - 05.2018
- Project: E-commerce, U.S.-based pharmacy sites.
- Supported multiple e-commerce platforms and CRM systems, managing customer, order, and product databases.
- Ensured secure and efficient data movement across production and staging environments.
Technical Support Engineer
Ambit Software Pvt. Ltd.
Mumbai
09.2013 - 07.2016
- Project: CRM and ERP Applications for Finance and Stock Market Clients.
- Provided L2/L3 support for CRM and ERP platforms used by finance and stock market clients.
- Assisted in SQL performance troubleshooting, report generation, and issue resolution.
- Collaborated with the development team to identify and resolve production database issues, ensuring system stability and minimal downtime.
Education
Bachelor of Engineering - Computer Science and Engineering
IES College of Technology
BhopalSkills
- SQL Server versions (2008–2022)
- Performance tuning
- Query optimization
- AlwaysOn availability groups
- Log shipping
- Replication
- Database mirroring
- Disaster recovery planning
- Azure SQL Database
- Table partitioning
- SSIS
- SSRS
Certification
- DP-300: Microsoft Certified Azure Database Administrator Associate
- Microsoft Certified Professional in Database Fundamentals
Core Responsibilities
- Managed SQL Server environments across production, development, and staging with emphasis on availability, performance, and security.
- Led SQL Server upgrades and migrations (2008 to 2019) with minimal downtime and rollback planning.
- Designed and implemented HADR solutions: AlwaysOn, Failover Clustering, Log Shipping, Replication, and Database Mirroring.
- Tuned performance and optimized queries using execution plans, indexing, statistics, and DMVs.
- Automated backups, index maintenance, and archival tasks via SQL Agent and custom procedures.
- Deployed and managed Azure SQL Databases with auditing, and activity logging.
- Managed cloud resources using Azure Portal, RBAC, and managed identities.
- Configured Azure Monitor and Log Analytics for real-time SQL performance monitoring.
- Secured SQL environments through role-based access, authentication modes, and policy-aligned configurations.
- Used SSMS, Query Store, Profiler, and Extended Events for diagnostics and system monitoring.
- Created documentation for operational procedures, troubleshooting, and incident resolution.
- Handled critical incidents and communicated status effectively to stakeholders.
- Supported CI/CD pipelines for SQL deployments using Team Foundation Server (TFS).
Timeline
SQL Server Database Administrator
Eclat Infotech Pvt. Ltd.
10.2022 - Current
Database Administrator
Madhya Pradesh State Electronics Development Corporation Ltd.
07.2021 - 10.2022
Database Administrator
Photon Grafix and Innovation Pvt. Ltd.
06.2018 - 07.2021
Database Administrator
InteleCorp Software (I) Pvt. Ltd.
07.2016 - 05.2018
Technical Support Engineer
Ambit Software Pvt. Ltd.
09.2013 - 07.2016
Bachelor of Engineering - Computer Science and Engineering
IES College of Technology