Sql Server Administrator
Resume:
Harishankar
DATABASE Administrator
****************@*****.***
No 6 Balaji Nagar, Srinivasa Flats 2nd Floor, Kodungaiyur, Chennai-600118
I have over 6 years of experience in providing database administrator support. My responsibilities include enhance database performance, perform restores, implement recovery procedures, handle performance tuning and conduct regular system backups, perform application level support and access security level for users and logins. Ensure technical and functional designs meet business requirements.
Technical Proficiency
Server : Windows 2008,2012,2016
SQL Server : SQL Server 2005/2008/2012/2014/2016
Tools : Visual Studio 2010/2012, SQL Server Management Studio, MS Office
Able to work independently with minimal dependency
Job Title & Responsibilities
Database Administrator
Chembian Technologies P. Ltd Mar 2018 – Till Date
Have experience in installing and configuring the SQL server
Handled SQL servers with versions of 2005, 2008, 2012,2014 and 2016
Handled Azure 2016 version environment
Configured and supported Always On in Azure 2016 version environment
Configured and supported Replication in 2008 and 2016 versions
Create new database for the customer and database objects such as tables, views, stored procedures, Triggers etc.
Participate in discussions involving the application creation and understand the requirements and provide the back-end functionality for the applications.
Provide DBA support and technical expertise for multiple applications in development, test, QA and production - SQL Server 2005, 2008, 2012, 2014 and 2016 environments
Have experience in writing complicated queries involving sub queries and co-related queries
Have experience and knowledge in query tuning
Have experience in processing large volumes of data
Performed day to day DBA activities such as monitoring SQL Server health, job status, addressing user requirements.
Took responsibility of maintaining the SQL Server instances to ensure software is properly installed, security patches were applied and upgrades were done
Approved and ran scripts for Quality Assurance and Production releases
Diagnosed job errors and implemented solutions or worked with developers and/or Server Administration as necessary to solve break/fix and other issues
Provided database access by adding their logins, creating roles, granting privileges, unlocked accounts, reset passwords.
Scheduled full, differential, and transactional log backups for user created databases in production environments.
Responsible for setting up security, and providing user access to SQL Server instances and objects.
Configured, and supported Log Shipping and Database Mirroring strategies to support our client
Software Analyst
STATS Systems India P. Ltd Jan 2012 – Mar 2018
Have experience in installing and configuring the SQL server
Handled SQL servers with versions of 2005, 2008, 2012 and 2014
Create new database for the customer and database objects such as tables, views, stored procedures, Triggers etc.
Participate in discussions involving the application creation and understand the requirements and provide the back-end functionality for the applications.
Interacting with clients of development teams, identifying & explaining the bugs, updating them in Jira and keep tracking the status
Provide DBA support and technical expertise for multiple applications in development, test, QA and production - SQL Server 2005, 2008, 2012 and 2014 environments
Managed SQL Server -based Applications
Have experience in writing complicated queries involving sub queries and co-related queries
Have experience and knowledge in query tuning
Have experience in processing large volumes of data
Performed day to day DBA activities such as monitoring SQL Server health, job status, addressing user requirements.
Took responsibility of maintaining the SQL Server instances to ensure software is properly installed, security patches were applied and upgrades were done
Approved and ran scripts for Quality Assurance and Production releases
Diagnosed job errors and implemented solutions or worked with developers and/or Server Administration as necessary to solve break/fix and other issues
Provided database access by adding their logins, creating roles, granting privileges, unlocked accounts, reset passwords.
Scheduled full, differential, and transactional log backups for user created databases in production environments.
Responsible for setting up security, and providing user access to SQL Server instances and objects.
Configured, and supported Log Shipping and Database Mirroring strategies to support our client
Education & Qualifications
Course: Bachelor of Engineering, Information Technology
Institution: Sri Venkateswara College Of Engineering, Anna University
Year of Passing: 2010
Course: SQL Database Administrator
Institution: Hope Tutors
References
On Request Basis
Date of Birth
17/02/1989
Contact this candidate