Patel Priyanka

Mail: adhdu0@r.postjobfree.com

Contact: +91-988*******

SQL DATABASE ADMINISTRATOR

OBJECTIVE:

To work in a responsible position applying my knowledge and skills as a Microsoft SQL Server DBA and accomplish projects involving Database Management with extensive use of my skill set in SQL Server technology.

PROFILE SUMMARY:

Having 3+ years of experience as a SQL Server Database Administrator in 24*7 Production Environment.

Proficient in TSQL Scripting.

Strong analysis and process understanding skills and ability to logically analyze and resolve the complex issues.

Ability to interact, communicate and work with all teams of the enterprise.

Expertise in Installation, Upgrades, Patches, Configuration and Administration for SQL Server in a Clustered and Non-Clustered Environment of MS SQL Server2008R2, 2012, 2014.

Expertise in Database Backup, Restore and Recovery procedures

Monitoring SQL Server job logs to ensure the backup operations, batch commands, or other scripts and processes have completed successfully.

Scheduling Database tasks like Jobs, Alerts, Emails, and Notifications.

Expertise in Security Management, Performance Tuning and Disaster recovery.

Successfully Implemented Point in time recovery in real time on SQL server 2008R2.

Good experience in resolving Query Blocking and Dead Lock Issues by using SQL commands and stored procedures.

Experience in implementation of High Availability and Disaster Recovery solutions (HA-DR), including Replication, Database Mirroring, Log Shipping, Always On and Clustering.

Experience in Development of automated daily, weekly and monthly system maintenance tasks such as database Full/Differential/Transactional log backups.

Administered, maintained, developed and implemented policies and procedures for ensuring the security and integrity using the constraints and Triggers.

Expertise in troubleshooting the Database issues and administering large and complex databases.

Performing Query Tuning, Data Integrity and updating Statistics using DMVs and DMFs, SQL Profiler Tool, DTA (Database Tuning Advisor), system traces and Activity monitor to Fine tune the SQL server performance.

Resolving the technical issues with Internal Technical Staff like DB Developers and external vendors.

Experience in solving Database issues with Index fragmentation, DBCC checks (Health Checks), Optimization of Query, Data Integrity, Index tuning, Update Statistics.

Experience in T-SQL Developer skills including stored procedures, Indexed views, User Defined Functions (UDF), Triggers, and Distributed Queries (in Linked Servers).

Installing applications on Client provided servers (3rd party servers) and making sure the system and the environment is ready for the migration.

A good team player and can work independently with a positive and Always-ready-to-learn attitude.

Excellent oral communication skills and documentation skills.

TECHNICAL SKILLS:

SQL Server tools

SQL Profiler, Import/Export wizard

Databases

SQL SERVER 2008R2/2012/2014

Programming Languages

T-SQL,Python

Operating Systems

Windows server 2008/2008R2/2012, Windows 7/8/10

Office Tools

MS Office 2007/2013/2016, MS Outlook

Ticketing Tools

Service Now

EDUCATIONAL QUALIFICATIONS:

M. Tech in Embedded system from Jawaharlal Nehru Technological University –Hyderabad (2015 – 2017).

B. Tech in Electronics & Communication Engineering from Jawaharlal Nehru Technological University –Hyderabad ( 2011 – 2015).

PROFESSIONAL EXPERIENCE:

Currently working as SQL DBA for Texcel infotech,Hyderabad from May 2017 to till Now

Worked as AR Analyst for Oakridge IT Limited, Hyderabad from Oct 2015 till Nov 2016.

PROJECTS SUMMARY:

Project

Previous Project:

1. Project : Health care portal

Client : Glenn Eagles Medical Centre, Malaysia

Role : SQL DBA

Duration : Sep2018 to till now

Description:

The health care portal is a system of maintaining and monitoring the health status of the patient visiting health centres. The health workers can enter the details of the patient refered by the doctor in the add screen. They can also do operation like modification, deletion and search of a patient’s health profile.

Roles & Responsibilities:

Team providing 24/7 production support to the clients

Monitoring the Scheduled jobs

Ensuring high availability of the database.

Monitoring the Disk spaces on all the servers.

Checking the general Health of the servers for identifying Bottlenecks

Planning, Database performance tuning for optimal results.

Developed Backup strategies for Database Recovery.

Performing Database maintenance activities like Backups, Restoring, Re indexing etc.

Ensured back-up procedures executed without failure

Creating Maintenance plans and jobs for automation of the repetitive task

As a part of the DBA implementation and administration of Database.

Monitoring Transactional Replication

Monitoring database Mirroring

Troubleshoot long running Queries and Stored Procedures

Environment: Windows 2008 Server Enterprise Edition, MS SQL Server 2008, MS Outlook, SQL Server Business Intelligence Development Studio.

2. Project : Administration Assistance System

Client : Aquire inc, USA

Role : SQL DBA

Duration : July 2017 to August 2018

Description:

This project is developed for Aquire Inc, based in the U.S, who provide services to the customer categories like business, residential, students etc in different areas like, body care, hair styling, services for pet animals, vehicle grooming etc. Among others. This company has branches all over the country. The main aim of this system is to synchronize, keep track of team members of all the branches and monitoring the status of each customer who visits the Shoppe daily, weekly, monthly and monitoring revenue of the company. This has modules like vendor, Admin sys Rep, Admin and sub modules in the above modules. Admin acts as a HUB, who handles the main activates for the business development.

Roles & Responsibilities:

Installing, Configuring and Administering SQL server 2008

Database performance tuning for optimal results.

Developed Backup strategies for Database Recovery.

Performing Database maintenance activities like Backups, Restoring, and Re-indexing etc.

Ensured back-up procedures executed without failure

Creating Maintenance plans and jobs for automation of the repetitive task

As a part of the DBA team providing 24/7 production support to the clients

Monitoring the Scheduled jobs

Ensuring high availability of the database exploiting the concepts of Log shipping etc.

Monitoring the Disk spaces on all the servers.

Checking the general Health of the servers for identifying Bottlenecks

Analyzing, Identifying and Resolving performance issues of the server

Planning, implementation and administration of Log Shipping with MS SQL Server 2008.

Maintained and developed Fail-Over databases using Database Mirroring

Environment: Windows 2008 Server Enterprise Edition, MS SQL Server 2008, MS Outlook, BIDS

HOBBIES:

Cooking

Gardening

PERSONNEL DETAILS:

Name : Patel Priyanka

Father Name : Sathyanarayana

Date of Birth : 29-05-1994

Address : Door No: 1-125/1, Seethampeta village, pinapaka Mandal,

Bhadradri (DT), Telagana – 507117.

Place:

Date: (Priyanka.P)

Contact this candidate