Aditya Sain CV

Download as docx, pdf, or txt
Download as docx, pdf, or txt
You are on page 1of 3

Deepankar Madan

MS-SQL SERVER DATABASE ADMINISTRATOR


New Delhi, India | +91-7982733418

[email protected] |

Objective

Experienced MS-SQL Server Database Administrator with 10+ years of expertise. Proven mastery in
database design, performance optimization, and security implementation. Skilled in disaster recovery,
Failover Clustering, Mirroring, Log shipping, Always-On replication, Backup Recovery, Migration, Query
Optimization, T-SQL Scripting, Data Base Maintenance Plans, Azure Migration, RDS, User Suspect
Databases and other server managing activities. Up-to-date with latest industry trends. Strong problem-
solving and communication abilities. Worked for both Development and Maintenance software projects

Experience

Accenture | Cloud Tech Support Specialist Nov 2019 – Current

SAIPEM (Italian multinational oilfield services company and one of the largest in the world):
 Administration of 10100+ Databases.
 Managed Always On replication for most critical client application.
 Migration to Azure Farm.
 Upgradation from older version to latest.
 Successfully managed performance issues.
 Worked on SNOW ticketing tool (For Changes, Tasks, Service Request & Incidents)

ENEL (Italian multinational manufacturer and distributor of electricity and gas):


 Administration of 1475 Databases Instance and 336 RDS Instances.
 Managed Always On replication for most critical client application.
 Successfully managed performance issues.
 Worked on AWS (Instance Creation, DB creation, File growth, Instance Management, Login
Management, Space Management etc.)

Ferrero SPA (Italian multinational confectionery company that specializes in producing a wide
range of high-quality chocolates, sweets, and other confectionery products):
 Project Management.
 Training and Development.
 Team Leadership and Management for a team of 10+ DBA's.
 Problem Solving and Incident Management.
 Backup and Recovery.
 Migration to Azure Farm.
 Documentation and Reporting.
 Security and Access Control.
 Upgrades and Patch Management.
 Oversaw all the problems related to SQL Database.
 Database Upgrade (Edition upgrade and version upgrade).
 Troubleshooting user escalations and working on escalations by support team.
 Production support on SQL Server 2008-2022. Managing 1050+ SQL Servers.
Leonardo SPA (Italian multinational company specializing in aerospace, defense, and security
technology solutions):
 Project Management.
 Training and Development.
 Team Leadership and Management.
 Problem Solving and Incident Management.
 Security and Access Control.
 Upgrades and Patch Management.
 Oversaw all the problems related to SQL Database.
 o Troubleshooting user escalations and working on escalations by support team.

HCL Technologies Ltd | Specialist Oct 2018 – Oct 2019


BEKAERT (Bekaert is a global company known for its expertise in advanced steel wire
transformation and coatings):
 Production support on SQL Server 2008/2012/2014/2016/2017
 Managing 150+ SQL Servers
 Manage disaster recovery planning
 Oversaw all the problems related to SQL Database
 Performance monitoring and troubleshooting
 Implementing and maintaining Mirroring, Always-on, Replication & Cluster and maintaining
high availability
 Troubleshooting user escalations and working on escalations by support team
 Did deployment of different Microsoft technologies like SSIS Package
 Work with TCS (Application Team)
 Team Size - 20+ DBA's.

NIIT Technologies Ltd | Production Support Apr 2013 – Oct 2018


Intranet Prahari Project BSF is a customized solution proposed for Border Security Force (BSF),
the country's premier paramilitary force tasked with securing its borders:

 Performance monitoring and troubleshooting


 Implementing and maintaining Mirroring, Log shipping, Always-on, Replication & Cluster and
maintaining high availability
 Troubleshooting user escalations, working on escalations by support team
 Worked on deployment of different Microsoft technologies like .Net, SSAS, SSRS and SQL.
 Administration of 40 Sites spread across the country with consistently 99.99% uptime.
 Managed Mirroring, Log shipping and Always on for Disaster recovery solution.
 Successfully overseen performance issues.

Education

 M.Tech in (Computer Science) from BITS Pilani, 2018 with CGPA – 8.06
 B.Tech in Information Technology from Rajasthan Technical University, Kota, 2012 with
64.32%
 Intermediate in Science from Birla Senior Secondary School, C.B.S.E, 2008 with 60%

Skills & abilities

 Database Installation and Configuration.


 High Availability and Disaster Recovery.
 Data Migration.
 Project Management.
 Training and Development.
 Team Leadership and Management.
 Problem Solving and Incident Management.
 Monitoring and Troubleshooting.
 Collaboration and Support.
 Backup and Recovery.
 Migration to Azure Farm.
 Documentation and Reporting.
 Security and Access Control.
 Upgrades and Patch Management.
 Performance Tuning and Optimization.
 Oversaw all the problems related to SQL Database.
 Database Upgrade (Edition upgrade and version upgrade).
 Troubleshooting user escalations and working on escalations by support team.

Languages

 English - Speak, Read and Write.


 Hindi - Speak, Read and Write.

Additional Information

Extra-Curricular Activities:
 DDNT 2012 (NIIIT-South-ext., Delhi).
 NCC (Unit-2 Raj Naval Unit NCC, Ajmer).
 Convergence 2009 (National Level Tech-Cum-Cultural Fest in DEBATE committee).
 Convergence 2008 (Achieving SECOND PRIZE at this National Level Tech-Cum-Cultural Fest in
SKIT committee).
 Summer camp 2006 (Certificate at school level in GYM & Basketball.
 Uplifting Service Champion 2016 (From UP! Your Service College).

Certifications

 Microsoft® Certified Professional MCP (SQL 2016).


 Microsoft® Certified Solutions Associate: SQL 2016 Database Administration MCSA (SQL 2016).
 AZ-104

Declaration

I hereby declare that the above cited information is true to the best of my knowledge and belief.

Place: Delhi Aditya Sain

You might also like