Resume

Name : R.Durga ashok

Email : admcmy@r.postjobfree.com

Mobile : +91-966*******

Location : Noida, India.

Summary: Around 2 years of experience as Microsoft SQL Server Database Administrator.

A strong work ethic combined with a commitment to excellence in all projects undertaken. A team player, working effectively with management, developers and users. A broad range of experience in all aspects of Database Administration.

Professional Experience:

• Around 2 years of professional experience in MS SQL Server Administration.

• Providing 24/7 On-Call support for critical Production Servers and Databases

• Administrated 800+ databases on 120 SQL Servers in production, development, and test environments

• Installing, configuring, administrating, securing and maintaining SQL Server 2008,R2,2012,2014,2016 and 2017 instances and databases

• Applying Patches by Service pack installation and hot fix application strategies

• Upgrade/Migration of MS SQL Server from lower to higher versions using any suitable approach (in place or side by side).

• User and database security management, creating groups, users, roles, granting permissions, policies.

• Refresh the database between the Environments.

• Monitor databases for errors and perform problem determination when necessary.

• Creating and monitoring jobs for automating daily tasks like backups, checking integrity of databases, updating statistics.

• Maintain database changes from Development, QA to Production.

• Resolve database performance issues, database capacity issues, and etc...

• Implementing and administering database replication.

• Experience on creating linked servers

• Hands on Experience on Database High Availability solutions like Log-Shipping, Database Mirroring, Replication, Always on and Clustring

• Working with developers for designing scripts for the maintenance activities of the Database.

• Perform other SQL Server DBA responsibilities as needed

• Participation of team meeting on a Bi-weekly basic for a discussion on the ongoing process and upcoming.

• Experience on installation and configuration of Lite speed tool

• Hands on experience on Clustering.

• Work experience on T-SQL.

Work Experience Details:

Working as MS-SQL DBA for “Tata consultancy service”, Hyderabad from aug 2019 - Till date.

Education Summary:

B-Com (Computers) from North East Frontier Technical University.

Skill Set:

OS

Windows Family

Database

SQL Server 2008, 2008,2012,2014,2016 & 2017.

RDP

Citrix Desktop and VPN Client

Ticketing Tools

Service NOW, ITSM

Tools

SQL Litespeed,,SCOM.

Current Project:

Project Name : Shared Telecom Infrastructure

Brief Overview:

Indus Towers Limited, a joint venture of Vodafone, Airtel-Bharti, and Idea, has been incorporated with an objective to provide “Shared Telecom Infrastructure” to telecom operators across the world on a nondiscriminatory basis. It’s commitment towards continuous innovation will enable optimization of future tower rollout and enhance operational efficiencies and result in substantial cost savings for its customers. Indus Towers shall significantly contribute in propelling wireless communication sector towards achievement of Government’s tele-density goals and broader rural coverage. Indus Towers management has chosen ‘Green’ as its corporate color as an embodiment of its commitment to deliver its services in an environmental friendly manner.

Roles and Responsibilities:

• Installation and administration of SQL servers and Patch management.

• Performed Operational Acceptance tasks on newly created SQL instances with help of Scripts as Ops DBA

• Implement DBA maintenance tasks for increase the Database performance with the help of Re-indexing, Re-organize index, and Update Statistics.

• Implemented procedure documents in place to ensure smooth day to day administration of databases.

• Implemented Log-Shipping as high availability solution

• Monitoring and responding on various database alerts

• Following ITIL process to handle requests and incidents

• User management and database security imposition by creation and granting of roles and privileges.

• Performed database Refresh

• Create Logins and Granting privileges as per requirement

• SQL Server jobs scheduling and creating alerts and operators and Troubleshoot the Job failures.

• Creating User Logins with appropriate roles, dropping and granting the privileges to users and groups.

• Administering SQL Server security, automatic e-mail notification, backup strategy and automation.

• Applying the services packs and hotfixes in servers.

Personal Profile:

Name: Durga ashok Ramisetti

(R.Durga Ashok)

Contact this candidate