Sandeep Gupta
Bethlehem,KY
Summary
- Diversified experience in Team Management, pivotal role in transition of a project to stable phase, documentation, one-on-one interaction with client
- A hardworking leader and team player with well-defined communication, problem-solving, multitasking, and technical skills
- Aptitude and Enthusiasm to learn new technologies
Strong Presentation, Solution demonstration and Customer facing skills - Articulate, educated with an international culture. Capable and enthusiastic for new challenges
- Continuous Learner and smart worker.
Overview
18
18
years of professional experience
1
1
Certification
Work History
SQL SERVER DBA
ENERGIA
10.2022 - Current
- Provide technical leadership
- Mentor junior staff on database technical details
- Provide technical assistance to developers
- Assist in developing strategic technical/architectural plans for SQL database and web applications infrastructure
- Participate in on-call support rotation and provide non-standard work hour support
- Provides database support to business users
- Restores functionality to database processes that have failed, documents resolutions, and creates and maintains troubleshooting documentation
- Provide technical support to databases, including system management, backup/recovery, account management, configuration management, and trouble calls
- Estimate effort to complete software development activities and provide input that adds value to management of software development projects
- Work with application development staff to develop database architectures, coding standards, and quality assurance policies and procedures
- Work with development team to resolve bug-fixes and assist in relevant testing through various environments
- Assist with Windows Server configuration and management as it relates to MS SQL Server installation and performance
- Perform and manage daily database maintenance, monitoring and performance tuning tasks/jobs
- Monitor SQL server and database performance and proactively address potential performance issues
- Provide solutions for database issues including capacity, redundancy, replication, and performance.
MANAGER – MS. SQL Server Services
ENERGIA
05.2020 - 10.2021
- Maintaining staff by shortlisting, recruiting & training employees
- Accomplishing goals by communicating job expectations, planning & monitoring results, along with coaching & counseling employees
- Setting up a realistic goal, milestones and working towards achieving them
- Increased billing efficiency by forecasting billing targets & capacity planning to improve team efficiency
- Achieving & maintaining SLAs by providing dashboards & reports to employees
- Strong technical abilities to help team in problem solving
- Supporting Enterprise & midsize Customers along with highly skilled DBAs
- Roughly managing 100+ customers
- Addressing escalations & providing detailed RCA to customers
- Setting, measuring & achieving operational goals
- Providing coverage to cross teams
- Setting up/driving best practice standards and processes across the team
- Writing-up reports & presentations
- Maintaining clean, professional & safe working environment
- Willing to work & available 24
- 7
- Extensive understanding of SQL Server architecture.
LEAD Technical Specialist - SQL SERVER DBA
ENERGIA
01.2016 - 05.2020
- Client meetings – Attending technical meetings for all the supporting customers
- Familiarity with assigned customers – Very much familiar with all the assigned accounts and good in making any tactical decision on client work
- Complex Service Requests – Having good knowledge on all the supporting environments and ability to prioritize and execute complex service requests
- Escalation Point – Working as a single point of contact for all the supporting customers
- Incident Management - Analyzing all the incident occurrence and high bar report
- Problem Management - Reviewing all the repeated incidents, looks for trends and takes permanent corrective action
- Work with respective teams to identify the root cause for any unplanned outage
- Change Management – Following the change management process defined by the customers and make sure the team aware of it
- Automation – Identifying all the repetitive task and automatizing it
- Documenting the customer DBA process – Coaching, training, documenting and educating the Customer DBA process to Junior and Mid-level DBAs
- Owner of all the runbook for the supporting customers
- Technical Quality Check – Doing regular 'Technical Quality Check' on the assigned incidents by using audit tool
- PIR and Corrective Action – Completing the post incident review on the required incidents and take corrective action in coordination with Primary DBA
- Weekly / Monthly Achievements Summary – Consolidating the weekly/monthly achievements data for all the supporting customers and presenting it to the respective customer leadership
- Monthly Achievements Summary – Sending the monthly achievements data to Practice Team Manager & Leads for Global Operations Meeting
- Conflict Management – Resolving all the conflicts and issues among the team members
- Roster Management - Preparing shift roster for all the Sr
- DBAs
- Review & follow-up on ticket / call audit compliance summary data - Reviewing and following up on data sent by audit team and take necessary actions to meet the compliance requirements
- Offshore Operations Meeting - Depending on requirements, attend offshore Operations Meeting
- Annual Performance Appraisal Review - Conducting 1:1 performance review discussion with DBA team
- Customer Satisfaction review – Getting the customer feedback on a regular interval and make sure DBA performance are up to the mark
- Capacity Management - Working on the capacity management for the Sr
- DBAs and keep a check on the mapping with the onshore leads
- Documentation Maintenance - Ensuring that customer documents related to connectivity, inventory and database transition are properly maintained.
Technical Specialist - SQL SERVER DBA
ENERGIA
01.2013 - 01.2016
- Handling multiple client requests, prioritizing, and communicating
- Installation of SQL server 2000/2005/2008/2012/2014/2016/2017 and 2019 with various editions in different environment
- Conducting health check of databases on schedule to check page and index fragmentation
- Creating, suggesting and maintenance of indexes
- Implementing & Monitoring the Log Shipping, Mirroring and Availability Group for DR server
- Setting up the backup strategy & its maintenance as per the client requirement
- Worked on backup utility Litespeed, Redgate and SkyNet
- Implementing and configuring replication
- Good understanding of SQL server clustering environment
- Performance Tuning
- Taking care of problems faced by users related to slow execution of queries.
- Analyzing the problem first & then taking required measures to resolve the same
- Using performance monitor to monitor Resource utilization
- Database maintenance activities using DBCC and DMVs and Extended Events
- Database and SQL tuning to improve performance of loads.
Tier 2 Shift Lead - SQL SERVER DBA
ENERGIA
01.2011 - 01.2013
- Responsible for owning, tracking, and resolving database related incidents and complex requests, fulfilling requests, and resolving incidents within SLAs, reviewing service-related reports on daily basis to ensure service-related issues are identified and resolved and review previous incidents, looks for trends and take permanent corrective action
- Reviewing tasks and request and assigning to DBA Team to get it done in time.
Tier 2 - SQL SERVER DBA
ENERGIA
06.2006 - 01.2011
- Installation, Configuration & Maintenance of MS SQL Server 2012/2008/2008R2/2005/2000 Versions and Upgrading Service Packs/hot fixes
- Experience in Database backup and disaster recovery procedure
- Experience in Log Shipping and database Mirroring, data partitioning, Always On
- Experience in Replication – Snapshot, Merge and transactional
- Maintained Database authentication modes, creation of users, assigning roles to users and managing user permissions, resolving Blocks and deadlocks
- Optimizing and Automating SQL Server Administration.
Education
PGDEB-DLP - Business Administration And Management
Welingkar Institute of Management Development & Research
Mumbai01.2015
Bachelor of Commerce - Accounting And Finance
Mumbai University
Mumbai01.2005
Skills
- 2016
- 2017
- 2019
- 2022
Certification
- Microsoft Certified: Azure AI Engineer Associate
- Microsoft Certified: Azure Database Administrator Associate
- SAA-C02, AWS Certified Solutions Architect Associate
- Microsoft Certified Solutions Associate: SQL Server 2012/2014
- 70-463, Implementing a Datawarehouse with Microsoft SQL Server 2012/2014
- 70-462, Administering Microsoft SQL Server 2012/2014
- 70-461, Querying Microsoft SQL Server 2012/2014
Languages
English
Full Professional
Hindi
Full Professional
Timeline
SQL SERVER DBA
ENERGIA
10.2022 - Current
MANAGER – MS. SQL Server Services
ENERGIA
05.2020 - 10.2021
LEAD Technical Specialist - SQL SERVER DBA
ENERGIA
01.2016 - 05.2020
Technical Specialist - SQL SERVER DBA
ENERGIA
01.2013 - 01.2016
Tier 2 Shift Lead - SQL SERVER DBA
ENERGIA
01.2011 - 01.2013
Tier 2 - SQL SERVER DBA
ENERGIA
06.2006 - 01.2011
PGDEB-DLP - Business Administration And Management
Welingkar Institute of Management Development & Research
Bachelor of Commerce - Accounting And Finance
Mumbai University
Similar Profiles
Lukas GazdikLukas Gazdik
Junior Trading Analyst at Energia GroupJunior Trading Analyst at Energia Group
Roland MuggliRoland Muggli
Africa Upstream & Geoscience Director at Galp EnergiaAfrica Upstream & Geoscience Director at Galp Energia
Geni Mirford Raff YakoroGeni Mirford Raff Yakoro
Câbleur atelier at Energia (Langlois)Câbleur atelier at Energia (Langlois)