VISHAL SRIVASTAVA
SQL DATABASE ADMINISTRATOR
Summary
Lead Database Administrator on projects utilizing Microsoft SQL Server 2005|2008|2012|2014|2016 |2019 |2022 on Windows. Created, maintained, and managed databases on multiple servers in a fast paced 24 x 7 x 365 environment.
Overview
14
14
years of professional experience
7
7
Certifications
2
2
Languages
Work History
Sr. SQL Database Administrator
Rackspace India Pvt. Ltd.
01.2017 - Current
- Responsible for the database administration and service delivery to our valued customers
- Responsible for the high availability and on-going maintenance and support of SQL Databases
- Performing SQL Server installations, configurations, administration, patching, security, backup, restore, monitoring and capacity management
- Configuring, Administering SQL Server High Availability, Mirroring, Replications and Disaster Recovery strategies
- Handling server/memory configurations and database optimizations for better performance
- Troubleshooting and fine-tuning queries for their performance and concurrency
- 24 x7 Production Database support.
Sr. Principal Consultant
Tricore Solutions India Pvt. Ltd.
04.2012 - 01.2017
- Installing and Configuration of the Microsoft SQL Instance as per the best practices
- Upgrades and patching of Microsoft SQL Server environment with the latest Microsoft SQL Server releases
- Responsible for the implementation and testing of backup and recovery procedures
- Implemented configuration changes and release of schema and data changes
- Implementation of Failover and availability mechanisms Always On, DB Mirroring, Log shipping and Replication
- Optimization of databases, Health Checks & Performance monitoring/tuning
- Worked on SQL DB migration projects
- Performed troubleshooting and problem solving of database related incidents and problems
- Ensured availability and optimized performance of multiple databases and proactively monitored databases to ensure secure services with minimum downtime.
Sr. Software Engineer
Steria India
04.2007 - 03.2012
- Client: Barclaycard UK
- Proactively monitoring the health of all live servers
- Preparing the daily check reports
- Resolving the day-to-day database related issues
- Resolving the day-to-day incidents within their SLA's
- Raising changes to implement changes for prod databases
- Handling user's requests & queries
- Incident & Change management
- Report generation as per user's requirement
- Preparing monthly reports
- Assisting manager in his day-to-day activities.
Software Engineer
Birlasoft India
01.2005 - 03.2007
- Client: GE Commercial Finance US
- Ensuring DB backups
- Reporting on Job's failures and acting on advises
- Resolving user queries.
Education
Bachelor of Engineering - Electronics Engineering
Nagpur University
Intermediate - undefined
D.A.V Public School, Sahibabad
High School - undefined
D.A.V Public School, Sahibabad
Skills
Backup and recovery
Database Maintenance
Database monitoring
Performance Tuning
Data Migration
Capacity Planning
Disaster Recovery
Database Security
SQL Server Reporting Services
Query Optimization
Log Shipping
Database Management
Database Administration
Problem-solving aptitude
Teamwork and Collaboration
Active Listening
Interpersonal Communication
Adaptability and Flexibility
Organizational Skills
Written Communication
Certification
DP-300 Azure Database Administrator
Awards
- Pat on the back (Steria)
- Best Project Team (Birlasoft)
Timeline
Sr. SQL Database Administrator
Rackspace India Pvt. Ltd.
01.2017 - Current
Sr. Principal Consultant
Tricore Solutions India Pvt. Ltd.
04.2012 - 01.2017
Sr. Software Engineer
Steria India
04.2007 - 03.2012
Software Engineer
Birlasoft India
01.2005 - 03.2007
Bachelor of Engineering - Electronics Engineering
Nagpur University
Intermediate - undefined
D.A.V Public School, Sahibabad
High School - undefined
D.A.V Public School, Sahibabad