Database Administrator
LTI
Total years of experience :4 years, 10 Months
Team Size : 06.
Roles & Responsibilities:
•Performed SQL Server installations and their service packs and client installations as per required.
•Creation of users & assigning roles to the users at various levels and mapping logins the database and granting appropriate permissions.
• Performed SQL Server installations and their service packs and client installations as per required.
• Analysis of the existing setups and specifications of the project.
• DBA activities like analysis of Space Availability, Backups and Scheduled Jobs, Alerts.
• Good experience on SQL Database Security related Issues.
• Experience in handling Blockings & Deadlocks.
• Experience on On-boarding, Decommission of Sql servers.
• Involved in trouble shooting cases where the Log file full and TEMPDB full.
• Good Experience on Backup and Restore.
• Good Experience on Database Refresh activities.
• Experience on SCOM monitoring tool.
• Good Experience in Upgrading and Migration from SQL Server 2005 to SQL Server 2008, 2012.
• Having experience on HP tolls called APATE, SQL QA.
• Experience on RTPA.
• Troubleshooting on database user connectivity issues.
• Experience in implementing always on Role changes.
• Good experience on Always on configuration.
• Experience on always adding the databases and Removal of database.
• Resolve Blocking, Long Running Queries.
• Checking the log file size and free space in the data disks.
• Experience in configuring, managing & troubleshooting of SQL server.
• Exposed to Performance Tuning of SQL Server Databases.
• Good experience on high availability technology like log shipping and mirroring.
• Successfully planned and implementing different types of Replication models.
• Experience on clustering environment.
• Having experience on24*7 support as per the client business requirement.