AugmntX

AugmntX is the world’s largest network of pre-vetted talent.

Contact Info

305, IRIS Corporate Centre,
Hiranandani Meadows, 400610.
hello@augmntx.com
+919820045154

Follow Us

Home / Developers / AXO5817
profile image
A A AXO5817 Active
SQL Server DBA in Pune
Experienced MSSQL Database Administration.  Installing and configuring the MSSQL Server 2012 and 2016.  Creating and administering the MSSQL Server Databases like data and log file placements and managing the growth parameters and database options.  Resolving the Disk space issues and finding the root cause and permanent fixes.  Expertise in Database backup, Recovery, Restoration.  Restoring the Databases from Production to test environment and vice versa.  Experience in User Management activities like adding the user and managing the permissions and fixing the orphan users.  Experience in usage of DBCC commands and DMVs for troubleshooting.  Trouble shooting and maintenance of SQL Server Always on Availability Groups.  Experience in creating SQL Server Logins, Assigning Roles to the users and Authentication Modes as part of Security Policies for various categories of users.  Monitoring SQL server performance using profiler to find performance.  Experience in Managing and monitoring jobs, Error Logs, Server space, Health of Database & Servers.  Able to communicate with peers/customers, team and become proficient at root cause analysis while communicating and resolving customer technical problems.  Working as part of a Core DBA team and providing 24x7 support when required.  Strong troubleshooting and problem-solving skills and strong ability to prioritize multiple tasks. Knowledge of Configuring Backups/Restoration from Azure Blob Storage. s of Experience in MSSQL Database Administration.
Industries : Transportation, Finance
Share
Hire A A
Download PDF
Availability
Full-time
Total experience
3 years
Technical skills
MS SQL Server
3 Years
Windows Server
3 Years
T SQL
3 Years
SQL
3 Years
SSMS
3 Years
Profiler
3 Years
Query Analyzer
3 Years
Redgate SQL Monitoring
3 Years
Azure Boards
3 Years
SQL Server 2012, 2016, 2017, 2019
Projects
Wheelking Canada
November-2021 to Present
Description
Installed and configured SQL Server 2016/2019 on Windows Server, ensuring optimal performance and reliability of the database environment. Implemented and administered robust backup/restore and disaster recovery plans for production servers, ensuring data integrity and availability. Conducted regular health checks on the databases, monitoring critical factors such as lock escalation, deadlocks, and resource utilization. Utilized advanced troubleshooting techniques to identify and resolve incidents proactively.
Roles and Responsibilities
Installation of SQL 2016/2019 on Windows Server. Implemented and administered backup/restore, disaster recovery plans for production servers. Performed regular database health checks. Monitored lock escalation, deadlocks, resources utilization, and captured long-running SQL queries. Worked as part of a team providing 24x7 support. Configured database mail profiles and created SQL Server traces for performance monitoring. Resolved incidents proactively and performed health checks of production servers. Monitored SQL jobs on Production and Pre-Production environments. Experienced in SQL installation, up-gradation, applying patches, file movement of Secondary Server databases in HA and DR. Successfully conducted various DR switchover and switchback on Always On. Created Linked Servers between SQL Servers and other Heterogeneous environments. Experience in creating automated backups, indexing, and update stats through SQLAgent Jobs and Maintenance plans. Monitored the status of Maintenance jobs scheduled to run daily and on weekends. Created Indexes and performed Maintenance, checking the fragmentation percentage.
Technologies: SQL Server 2012, 2016, 2017, 2019
Industry: Transportation
RBL Bank
December-2020 to September-2021
Description
Led initiatives to enhance SQL Server performance through the creation and utilization of SQL Server traces using the SQL Server Profiler. Monitored SQL jobs meticulously on both Production and Pre-Production environments to ensure seamless execution. Spearheaded the management of file movement for Secondary Server databases, actively contributing to High Availability (HA) and Disaster Recovery (DR) strategies.
Roles and Responsibilities
Created SQL Server traces using the SQL Server Profiler to monitor and optimize performance.Monitored SQL jobs on both Production and Pre-Production environments.Managed file movement of Secondary Server databases involved in High Availability (HA) and Disaster Recovery (DR).
Technologies: SQL Server 2012, 2016, 2017, 2019
Industry: Finance
Work history
SQL Server DBA • Nov 2020 to Present
Description: Currently working as SQL Server DBA with CodeElan Technologies from Nov 2020 to till date.
Soft skills
Teamwork
Problem-solving
Time management
Education
Bachelors degree in BCA
SPPU
2018 to 2021
Language
English - Advanced