PRINCE ZAHID

+91-600*******

admpqr@r.postjobfree.com

OBJECTIVES:

I would like to put down my quick learning ability to learn new things related to my profession and to implement them in the practical world. I am willing to develop my technical skills in a better way to increase my efficiency and benefit the company in return.

EDUCATION:

SQL DBA SKILLSET

2.5 years of experience in SQL Server Database Administration in Production, Test and Development environments, with MS SQL Server 2017, 2016, 2014, 2012, 2008R2, 2008, 2005, 2000.

Having knowledge and hands-on experiences on upgrading SQL Server Software to new versions and applying service packs and hot fixes.

Sufficient knowledge and experience on SQL server Migration between SQL 2008 to SQL 2012/2014/2016.

Sufficient knowledge of Database Recovery models and developing the successful backup strategies based on recovery models.

Have Knowledge on security and Creating Customized Server Roles in SQL server.

Concerned with backups, security, patches.

Having good experience in daily database maintenance and administrative tasks like Space issues, transaction log file size growth, connectivity issues and regular monitoring of SQL Server error logs and Windows event viewer.

Experience in automation of administrative tasks like creating maintenance plans, creating Jobs, Alerts using SQL Server agent and monitoring and troubleshooting the jobs.

Experience in performing database regular Backups Full/Differential/Transaction Log Backups into Disk and Restoring on requirement.

Responsible to secure the SQL server, user management, assigning permissions and roles.

Creating technical documentations and process archiving and change management.

Experience in installation, configuration, maintenance, and optimization of SQL Server HADR solutions like Log Shipping, Clustering, Mirroring, AlwaysOn Availability Groups and Replication.

Knowledge on Profiler, Performance tools to identify/troubleshoot slow performance factors.

Hands-on experience on Transparent Data Encryption (TDE).

Good Experience on managing Azure SQL database. Performing backup and restore activity to and from the azure storage.

Qualification Board/University %age Year of Passing B. Tech (CSE) Baba Ghulam Shah Badshah University Rajouri J&K 78% 2018 Senior Secondary JKBOSE 84% 2013

Secondary JKBOSE 94% 2011

Creating new Azure SQL database.

Managing users and groups on Azure SQL database.

OTHER TECHNICAL SKILLS:

NETWORKING AND CCNA:

Basics of Networking: ISO/OSI Model.

IP Addressing, Subnetting, Network Topology, Network Protocols

Static Routing and Dynamic Routing Protocols (RIP, EIGRP, OSPF)

Network Address Translation NAT/PAT

Switching, VLAN creation and configuration, ARP

AZURE ADMIN SKILLS:

Creating and managing the Azure AD users and groups and providing access to azure resources using RBAC

Creating and managing subscriptions, Resource groups and resource locks.

Creating and configuring Azure file share and blob storage

Creating, configuring, and managing azure VM

Configuring and Managing Azure VNET, Azure DNS and Azure Firewall

Monitor resources by using Azure Monitor.

Creating and configuring backup and recovery policies.

PROFESSIONAL EXPERIENCE:

Organaization:: Lumen Technologies

Designation:: Database Administrator (System Engineer) Duration:: Dec 2018 – till date

COURSES AND CERTIFICATIONS:

Completed certification on Microsoft SQL Database Infrastructure Administration (70-764)

Passed “ITIL 4 Foundation Certification” Exam

Completed a 2-month training course on “CCNA (Routing and Switching)”

Attended a 4-day workshop on Microsoft Azure concepts organized by Microsoft.

PERSONAL STRENGTHS

Creative Good Communication skills

Quick Learner Maintaining Good level of Professionalism Declaration

I hereby declare that the information furnished above is true to the best of my knowledge and belief. Place: Bangalore

Date: Prince Zahid

Contact this candidate