Dipak Rai
Delhi,DL
Summary
Primary Role: Microsoft SQL Server Administrators 8+ years of experience in Database Administration and support of SQL Server 2019\2017\2016\2014 \ 2012 R2. Experience in Database Administration on Production Servers with server configuration and maintenance with troubleshooting capabilities. Hands on Experience in installing, configuring, managing, monitoring and troubleshooting SQL Server SQL Server 2012, SQL Server 2014\2016\2017\2019. Database Migration and Upgradation Administering SQL Server High Availability and Disaster Recovery strategies. Proficiency and extensive experience in SQL Server Replication, Backup/Recovery, Disaster recovery and planning Having hands on experience in HA/DR process Log Shipping, Database Mirroring Clustering. Having hands on experience and troubleshoot Always On. Having hands on experience on configuration of always on. Knowledge of SSIS, SSRS, SSAS. Experience and knowledge of Azure SQL Database. Experience in Import, Export, Backup, Database Monitoring tools and Application support. Created Linked Servers between SQL Servers Strong understanding of ITIL v3 processes (Incident Management, Change Management, Problem Management, Configuration Management etc.) Have impeccable communication and interpersonal skills and an exceptional team player. Actively coordinated with the end user community.
Overview
9
9
years of professional experience
Work History
Database Administrator
Indusfly Technologies
Noida, UP
09.2023 - 01.2024
- Project: Product: LTIMINDTREE Role: MSSQL DBA Duration: Sep 2023 – Till date
- Maintained complex T-SQL queries, views and stored procedures in multi-database environment with little supervision.
- Managed workload independently but collaborated with colleagues to complete larger scale tasks in distributed team environment.
- Supported projects enabling delivery efficiencies and technical resolution.
- Successfully recovered vital data from damaged databases using specialized recovery techniques; minimized impact on business continuity plans by rapidly restoring lost information.
- Evaluated emerging technologies related to SQL Server administration; recommended strategic improvements benefiting both IT infrastructure and business objectives.
Assistance Manager
Havells India Ltd.
Noida, UP
04.2022 - 08.2023
- Project: Product: Havells India Role: MSSQL DBA Duration: April 2022 – Aug 2023
- Accomplished multiple tasks within established timeframes.
- Enhanced customer satisfaction by resolving disputes promptly, maintaining open lines of communication, and ensuring high-quality service delivery.
- Maintained professional, organized, and safe environment for employees and patrons.
- Communicated clearly with employees, suppliers and stakeholders to keep everyone on same page and working toward established business goals.
- Developed and maintained relationships with customers and suppliers through account development.
- Built high-performing teams through effective recruitment, onboarding, and talent development initiatives.
- Streamlined backup and recovery processes, enhancing overall system stability and availability.
- Built databases and table structures for web applications.
- Modified databases to meet needs and goals determined during planning process.
- Created and updated database designs and data models.
MSSQL Database Administrator
Silver Touch Technologies Ltd.
New Delhi, India
08.2020 - 05.2021
- Project: Product: NIC (PNAY, Narega, Awaasplush,) Role: MSSQL DBA Duration: Aug 2020 – May 2021 and Nov 2021 to April 2022.
- Streamlined backup and recovery processes, enhancing overall system stability and availability.
- Implemented comprehensive data retention policies that met regulatory requirements while minimizing storage costs.
- Coordinated with project management on database development timelines.
- Utilized RDBMS tools and utilities to monitor, tune and optimize system performance.
- Installed and configured middleware in Linux and Windows environments.
- Implemented security measures to protect vital business data.
Database Administrator
Sify Technologies
Noida, UP
11.2017 - 07.2020
- Project: Product: NICSI National informatics center (Gov
- Of India) Role: MSSQL DBA Duration: Nov 2017 – July 2020
- Ensured high availability of databases, utilizing clustering techniques and load balancing solutions.
- Migrated legacy databases to more modern platforms, streamlining processes and improving overall efficiency across the organization.
- Provided 24/7 support for critical database systems, quickly resolving any incidents that arose to minimize disruption to business operations.
- Streamlined application performance by creating efficient SQL queries and stored procedures for complex data retrieval tasks.
- Optimized database performance by conducting regular maintenance and implementing indexing strategies.
- Created and updated database designs and data models.
Engineer
CMS Computer India ltd
Delhi, India
06.2017 - 11.2017
- Project: Product: NICSI National informatics center (Gov
- Of India) Role: SQL Server DBA Duration: October 2017 - November 2018
- Performed preventative maintenance to keep tools and equipment functional.
- Wrote, reviewed and edited technical document in accordance with template requirements.
- configured HA/DR Solution
- Migration of Database .
Engineer
HCL Technologies
Noida, India
01.2016 - 05.2017
- Project: Client: NICSI National informatics center (Gov
- Of India) Role: SQL Server DBA Duration: Jan-2016 to May -2017
- Incorporated extensive familiarity with [Type] system for data management and backup and recovery accountability.
- Developed custom scripts for automating routine tasks such as backups, index maintenance, and performance tuning, reducing manual efforts while increasing reliability.
- Implemented robust monitoring tools to proactively identify potential bottlenecks and address issues before impacting end users.
- Successfully recovered vital data from damaged databases using specialized recovery techniques; minimized impact on business continuity plans by rapidly restoring lost information.
- Facilitated smooth system upgrades through diligent testing procedures; ensured minimal disruption to internal teams during rollout phases.
- Trained junior DBAs on best practices in SQL Server administration, fostering a collaborative environment where team members could continually grow their skills.
Engineer
AFORESERV Pvt ltd.
Noida, India
02.2015 - 01.2016
- Project: Client: NICSI National informatics center (Gov of India) Role: SQL Server Production Support Duration: Feb-2015 to Jan -2016
- Achieved successful project outcomes by maintaining accurate documentation and meeting strict deadlines.
- Improved team productivity by providing technical guidance and mentoring junior engineers.
- Reduced project completion time with efficient resource allocation and effective communication strategies.
- Trained and mentored competent and flexible workforce to meet project needs and promote positive work environment.
- Optimized engineering processes by implementing innovative solutions and streamlining workflow.
- Provided input to team lead regarding areas for process and procedural improvement.
- Resolved critical issues during system integration phases, ensuring seamless transitions between design iterations.
Education
MCA - Computer Science
Uttar Pradesh technical university (UPTU).
01.2014
BCA - Computer Science
Sikkim Manipal University
01.2011
Skills
- RDBMS: SQL SERVER 2012, 2014, 2016, 2017, 2019
- Windows server 2008R2, 2012R2, 2016, 2017, 2019
- CA Spectrum Monitoring tools Profiler
- Monitoring Tools: Net vault (Backup), SQL Diagnostic Manager, CA Spectrum
- Backup and recovery
- Data Migration/ Upgradation
- Configure And troubleshoot Log shipping , Clustering , Always On Mirroring
- Database Design
- Database Security
- Capacity Planning
- SQl Installation
- Disaster Recovery
- Database Maintenance
- Performance Tuning
- SQL Server Reporting Services
- Index Management
- Data audits
- Data Security
- Database Management
- Database Administration
Roles And Responsibilities
- Providing 24/7 support for critical production databases of NIC and their clients.
- Installation, Configuration and Administration of SQL Server 2012/2014/2016/2019.
- Migrating databases from SQL server /2012 r2 / 2014/2016\2017\2019 in Prod and test
- Installing SQL Server instances and applying service packs.
- Creating user defined databases, file groups and placing files in appropriate locations.
- Creating Logins, Users, Assigning Roles and Permissions as per the request.
- Experience in troubleshooting issues in Always On.
- Worked on troubleshooting in the mirroring and AG issues.
- Beginner experience in log-shipping, mirroring configuration and troubleshooting them in case of any errors
- Experience in creating Jobs and maintenance plans.
- Creating change requests and getting the necessary approvals for implementing change Requests.
- Working on Standard Database Maintenance tasks, Backups and Recovery Plans.
- Database Refreshes from Production to Stage and Development environments as per the requirement.
- Performing SQL server daily health check and preparing a report based on it.
- Monitoring Disk Space of all the Servers and freeing up space as per SQL Server i.e. Older Backups, Unused Files etc.
- Scheduled and maintain routine Jobs, Alerts and Maintenance Plans.
- Managing backups on a daily basis and recovery (as per request).
- Ensuring the high availability of the Databases to the end users.
- Working as part of a team and provide 24x7 technical database support.
- Administration of SQL server by creating user Logins with appropriate roles, granting and denying login privileges, monitor the user accounts, creation of groups, granting database and application roles to users and groups.
- Involved in creating tables, indexes and views.
- Periodic checking of databases with DBCC command for maintaining data consistency and integrity and rebuilt indexes.
- Carrying out Installations and upgrading of SQL server Database engine and client tools through all the versions and administrating the same
- Reviewing SQL Server and SQL Server Agent Error Logs.
- Knowledge on Administrating replication, log shipping, clustering, always on, and other high availability methodologies.
- Applying SQL Server patches and Service Packs during the maintenance window.
- Raising Change requests for any production change to be made and other defined requests for their respective purpose.
- Creating Weekly and Monthly analysis reports for the Database Growth and Performance statistics
- Monitoring of the server Through the CA-spectrum Tool.
- Monitoring of server backup Through Net Vault Tool
- Distribution of Knowledge with in Team considering any new issue and document it for future usage if it surfaces back
Timeline
Database Administrator
Indusfly Technologies
09.2023 - 01.2024
Assistance Manager
Havells India Ltd.
04.2022 - 08.2023
MSSQL Database Administrator
Silver Touch Technologies Ltd.
08.2020 - 05.2021
Database Administrator
Sify Technologies
11.2017 - 07.2020
Engineer
CMS Computer India ltd
06.2017 - 11.2017
Engineer
HCL Technologies
01.2016 - 05.2017
Engineer
AFORESERV Pvt ltd.
02.2015 - 01.2016
MCA - Computer Science
Uttar Pradesh technical university (UPTU).
BCA - Computer Science
Sikkim Manipal University