SARANYA NAGHARAJAN **********.********@*****.***
CARRER objective
Looking for a reputed organization with global acclaim and challenging environment wherein I can be a part of proactive progress which offers ample opportunities to enhance my skill set and equip myself to take up new responsibilities and challenges.
HIGHLIGHTS
Having 2 years of experience in the field of Database Administration.
Protecting the databases by taking different kinds of Backups such as Full, Differential
and Transactional log backups.
Created more than 500 Database for various customers.
Managing customers MS SQL Databases on CLOUD & responsible for backup and Restoration, analyze and resolve performance problems.
Experience in using Performance Monitor, SQL Profiler and optimizing the queries, tracing long running queries and deadlocks.
Monitor the status of Maintenance jobs – schedule to run daily and on weekends (tasks like rebuilding indexes, Shrink Database, and Database complete backup).
Followed Incident Tracking tool like JIRA for support with the priority and the process.
TECHNICAL SKILLS
Databases SQL SERVER 2008 R2 and 2012, 2014
Languages C, C++, J2EE.
Knowledge in SDLC and STLC.
Ticketing Tool JIRA
PROJECT DETAILS
Project #1
Client TAFE and TMTL Tractors
Role SQL DBA
Duration Nov 2016 to till date
Team Size 8
Environment SQL Server 2012,2014, Windows 2008 R2/2012
Roles and Responsibilities:
Resolving Tickets which include creating and maintaining databases, monitoring Disk Space
Ensure and maintain sound backup and recovery policies and procedures.
Backup and restoring the databases from production to test environment.
Resolving blocking processes related issues.
Executing the scripts in production environment.
Monitoring of server performance.
Trouble shooting blocking, space issues.
Once created the database Backups, monitor those backups are being performed regularly. (SQL Server Agent)
Project #2
Duration October 2015 to Jan 2016
Client NSA Australia, Dunes Oman
Position DBA
SQL Version MS SQL Server 2008 R2,2012,2014
Roles and Responsibilities:
Resolving Tickets which include creating and maintaining databases, monitoring Disk Space, database integrity, identifying missing Indexes, handling blocking.
Maintained & Monitored Alert/Schedule to make smooth replication process.
Ensure and maintain sound backup and recovery policies and procedures.
Backup and restoring the databases from production to test environment.
Troubleshoot various problems that arise in a day-to-day work and fix the issues. (Monitoring SQL Server Error Logs .Design database Backup and Restoration Strategy. (Database Backups and SQL Server Agent)
EDUCATION
Bachelor of Engineering in Electronics and Communication at Kalasalingam University, Srivilliputhur in 2014 .
PERSONAL INFORMATION
Date of birth 04.12.1992
Marital status Single
Address 3rd cross street vijayanagar velachery, Chennai.
DECLARATION
I hereby declare that the above-mentioned information is correct up to my knowledge and I bear the responsibility for the correctness of the above-mentioned particulars.
SaranyaNagharajan.