Suresh M
Chennai
Summary
An experienced SQL Server DBA with detail oriented, analytical and troubleshooting having 1.5 years of experience in the industry as a Microsoft SQL Server Database Administrator.
Created and managed databases across Development and Production instances using SQL Server Management studio.
Responsible for maintaining, monitoring and troubleshooting SQL Server performance issues.
Ensuring the integrity and security of data for internal users and customers.
In-depth understanding of security and backup procedures to ensure database integrity.
Hardworking and passionate job seeker with strong organizational skills eager to secure entry-level MSSQL DBA Administrator position. Ready to help team achieve company goals.
Overview
2
2
years of professional experience
Work History
MSSQL Database Administrator
Suresh M
2022.06 - Current
- Over 1.5 years of experience as a MSSQL Database Administrator.
- Monitor server activity, Error log, Space issues for Tlog and disk alert and solving problem as needed.
- Hands on experience with installation and configuration of SQL Server 2019/2017/2016/2014/2012.
- Good hands-on experience with database backup, recovery and maintenance of SQL Server databases.
- Created new databases as per user need and table scripts.
- Maintained User databases and System Databases.
- Created user logins and add users to respective databases for their access need.
- Maintained regular backups, restore databases and transaction logs as needed.
- Responsibilities included the maintenance, scheduling and maintenance of SQL jobs.
- Database maintenance tasks (rebuilding and reorganizing indexes,updating statistics and running DBCC).
- Performed tuning of Stored procedures, SQL Queries and user Defined Functions.
- Setting up and monitoring high availability solution such as Replication, Mirroring, Log Shipping and Failover Clustering and Always-On high availability groups.
- Good hands-on experience with backup and recovery methods (Full, Differential and Transaction log) using management studio.
- Performed database health checks using SQL Profiler, performance monitor and DBCC commands.
- Automation of SQL DB Backups
- Administered, supported, and monitored databases by proactively resolving databases issues and maintaining servers.
- Monitored database system details within the database, including stored procedures and execution time,
Education
Bachelor of Engineering - Mechanical Engineering
Jaigopal Garodia National Higher Secondary School
Chennai11.2020
Skills
- RDBMS: MSSQL Server 2019,2018, 2016, 2014, 2012
- Database Tools: SQL Server Management Studio, Database Engine Tuning Advisor, SQL Profiler, Replication, SSIS, SSRS and SSAS.
- Programming Languages: SQL, T-SQL.
- Operating System: Windows Server 2012, 2008 R2.
- Ticketing Tools: ServiceNow, Autosys.
- Utility Tools: MS Excel, MS Word.
Strong motivational and leadership skills
Leadership is about collaboration and inspiring others to do their best work.
Qualities that allow leaders to encourage and inspire team members to boost productivity and improve work quality.
Motivating people requires a strategy to ensure they achieve desired outcomes.
Timeline
MSSQL Database Administrator
Suresh M
2022.06 - Current
Bachelor of Engineering - Mechanical Engineering
Jaigopal Garodia National Higher Secondary School
Similar Profiles
Sushmitha Krishnan M N MSushmitha Krishnan M N M
Junior Advocate at ADV. SureshJunior Advocate at ADV. Suresh
Chavi JainChavi Jain
Assistant General Manager at Suresh Chand Jain and sonsAssistant General Manager at Suresh Chand Jain and sons
Jaysinh BhatiJaysinh Bhati
Maintenance Engineer at Suresh Oil Field Pvt LtdMaintenance Engineer at Suresh Oil Field Pvt Ltd