.
.
P R O F E S S I O N A L S U M M A R Y
Driven and analytical MSSQL Database administrator with 4 plus years of experience. Have worked on versions SQL server versions like 2012/2014/ 2016/ 2017/2019. Experience in handling large databases and performing regular DBA activities like installation of SQL engine, configuration of maintenance plans and OLA jobs, backup and restore operations, HA/DR, import export, database migration, Patching and upgradation of SQL server, database refresh and much more. Good knowledge of incidence, request and change management using service now
(SNOW).
W O R K H I S T O R Y
September 2018 – December 2022
HCL Technologies ltd., Nagpur, India
Senior Analyst - SQL Server Database Administrator (DBA) As a database administrator my job responsibilities are, but not limited to:
- Handling or working with 2012/2014/2016/2017/2019 versions of SQL Server in both non-production and production environment
- Installing SQL server engine and management studio (SSMS)
- Configuring OLA jobs and maintenance plans
- Creating and decommissioning databases
- Creating logins and users
- Assigning server level and database level roles & permissions
- Performing backup and restore operations
- Handling disk space issues due to increase in size of database and log files
- Handling temp database issues
- Handling blocking and deadlock issues
- Database refresh from production to pre-production environment
- Handing database import and export requests
- Handling migration of system and user databases
- Configuring and handling issues related to database mirroring
- Configuring and handling issues related to log-shipping
- Configuring and handling issues related to always on and failover clustering
- Installing patches and cumulative updates
- Working knowledge of Indexes, recovery models, statistics, locks etc.
- Coordinating with other teams like windows (wintel), ansible, monitoring, storage etc. to ensure proper execution of scheduled changes. _15 A m i t G h a i
(SQL Server Database Administrator)
Contact: +1-770-***-****
Email: ad4xoj@r.postjobfree.com
Preferred location: Anywhere in the USA DOB: 5thNov.79
.
.
February 2016 - March 2017
Hexaware technologies ltd. (BPS), NAGPUR, India
Back Ground Verification Executive
As a background verification executive my responsibilities were, but not limited to:
- Performing background verification on perspective employees for client
- Performing background checks on employment history, education and references. January 2008 - January 2016
IT-Computer Hardware and Network support
Nagpur, India
As a computer hardware and network support my work was, but not limited to:
- To assemble PC/desktop computers for customers
- Installing operating system and various applications
- Upgrading OS, RAM and other machine hardware
- Installing and troubleshooting peripheral devices like printers, scanners, webcams etc.
- Installing, configuring and troubleshooting broadband routers
- Configuring home and small networks
- Troubleshooting LAN and WAN related issues
- Troubleshooting no post, no boot, blue screen error other issues related to hardware, OS and applications.
E D U C A T I O N
12/2020
Bachelor of Computer Application (BCA)
Manonmaniam Sundaranar University, Tamil Nadu
12/2003
Diploma in Mechanical Engineering (3 years Diploma) NPN college, Nagpur, Maharashtra
05/1998
Higher Secondary School Diploma (12th standard, science) Nagpur, Maharashtra
A C C O M P L I S H M E N T S
Received award and certificate for exceptional contribution in the team from the top-level leadership at HCL technologies.
T R A I N I N G & C E R T I F I C A T I O N S
- MSSQL Server database administration (DBA) training
- PC engineering (Computer Hardware) training completion certificate
- CompTIA Network Plus (Networking) Novel training completion certification
- Cisco Certified Network Associate (CCNA) training completion certificate
- Microsoft Certified Systems Associate (MCSA) training completion certificate from Microsoft certified training partner.
S K I L L S
- MS SQL Server relational database administration & T-SQL skills
- Desktop/laptop hardware & network configuration and troubleshooting skills
.
.
- Windows OS and applications installation, configuration and troubleshooting Skills.
.