Support Sql

Gmail:************.*@*****.***

Mobile: 991-***-****

Summary:

•Having 2 years’ experience on MS SQL DATABASE ADMINISTRATOR in production environment and no production environment.

•Experience in handling Database Backup, Restore and,Point in time recovery.

•Expertise in planning and implementing Database Security by creating users, Roles, and assigning permissions.

•Experience on system database and user database files moving one location to another location.

•Experience on Scheduled and maintained routine Jobs, Tasks, Alerts and Maintenance Plans.

•Good Login and User creation, granting and revoking roles and privileges, fixing orphan users.

•Experience in configuring and maintaining Log-Shipping and troubleshooting the issues.

•Experience in configuring and maintaining Mirroring and troubleshooting the issues

•good knowledge on always on availability groups.

•Experience on Database consistency checks using DBCC Utilities.

•Knowledge on replication (snapshot replication, transaction replication, Merege replication) monitoring the replication issues and fixed the issue.

Technical skills:

MS SQL SERVERS: /2008R2/2012/2014/2016

Operating Systems: Windows server 2007/2008/2008R2/2012/2012R2

Work Experience:

●Currently Working as SQL database Administrator with Cognizant from 2018 July – till date.

Academic:

Completed Graduation in B.Tech (ECE) from JNTUK University in the year 2018.

Project: Capital One

Capital One Financial Corporation is an American bank holding company specializing in credit cards, auto loans, banking, and savings accounts, headquartered in McLean, Virginia with operations primarily in the United States. It is on the list of largest banks in the United States and has developed a reputation for being a technology focused bank.The company's three divisions are credit cards, consumer banking and commercial banking

Roles & Responsibilities:

•Daily checking the tickets assign the tickets and resolving then asper priority levels.

•Checking Databases consistency using DBCC commands.

•Taking backups on daily bases and Restoring from backups as per requests.

•Identifying and resolving Deadlocks and Blocking.

•Creating and Scheduling Jobs.

•Checking Jobs are running well or not.

•Creating SQL Logins and Users as per request.

•Monitoring SQL Server Error Log and Event Viewer for issues and errors.

•Checking the Database participating in Log Shipping by manual failover.

•Monitoring SQL Server performance with help counters in Performance monitor.

•Worked on daily tickets/DB growth and failed jobs. CPU, memory/disk utilization.

•Involved in restoring database to Point-In-Time, Page Restore in case of issues.

•Used tools like SQL Server management studio and SQL Server Profiler

•Troubleshooting TEMPDB full and Log file full issues.

•Effectively handling client change requests by proposing and supporting solutions.

•Managing Permissions, and creating appropriate logins, database users, roles

•Preparing daily reports like disk space report, backup.

•Doing all Daily, weekly & monthly checks in-time and raise incident.

•Involved in On-call support outside business hours

•Provided 24x7 DBA production support, work with DBA team for production on call support.

Contact this candidate