Dba Administrator

Syed Haider Abbas

*************@*****.***

Mobile No:+91-893*******

PAN No: BOEPA2929D

CAREER OBJECTIVE:

Seeking a challenging and rewarding career in Database as MSSQL DBA and Cloud Services professional where I can contribute my knowledge and skills for growth and development of the organization and to be able to implement solutions that meet the customer requirements using my variety of software development skills and technical expertise

.

PROFILE SUMMARY

6+ years of IT experience in SQL Database Administration,, Cloud Services Administration, System Analysis & Support of MS SQL Servers in Production, QA, Development environments and Cluster Server Environments.

Provide 24X7 Production support for the database and application issues.

Experience of working on high priority incident ticket with high critical deadline.

Having experience in Project Management Activities such as (SLA Management, Resource Management, Change Request Management, Problem Incident Management).

An effective communicator with excellent interpersonal, analytical and client servicing abilities.

Working closely with clients to understand business requirements and delivery technical solutions.

Excellent team player with abilities to work under tight deadlines.

Roles & Responsibilities:

Perform the elevated rights on SQL Server instances on monthly basis for monitoring the application users with high privileges.

Providing MS SQL Server DBA support on day-to-day database related activities and

Installation, Migration, Upgradation and Sql Server Patching on Clustered & Non Clustered Environment.

Working on ticketing system Service Now for all incident and change requests.

Troubleshooting and remediation for job failures.

Supporting Database space issues of DB files and acts accordingly.

Backup and Recovery.

Disk backup management.

Performance monitoring and troubleshooting.

Handling Security tickets to add/modify/revoke access permissions.

Having good experience providing on-call support.

Implementation of Database maintenance plan which covers Database Integrity Checks, Update Database Statistics and Re-indexing

Providing Support to HA environment.

Involved in daily activities and supporting L1 team members.

Prepared Disk Space and Database Growth Report of Monthly basis

Having rich experience in Installation, Configuration, up gradation and Migration of SQL server.

Ability to work independently in a fast-phased deadline oriented environment.

Good in collaboration skills across technical and non-technical teams with a track record of building strong p professional relationships.

Good in customer focus and ability to communicate complex technical concepts and issues to a non-technical customer community in a concise, clear manner often tailored to the audience.

Backups and Restore in SQL server Taking Backup of database and Restoring to different servers through backup.

Maintaining Users & corresponding Logins on user databases in SQL Server.

Attaching and Detaching files: worked on attaching and detaching files on servers.

Installed SQL Server: Installed different versions and editions of SQL Server with different types of collation, installed multiple Instances on the same servers.

Always On configuration using different Subnet.

Job scheduling & trouble shooting: Scheduled different types of Job for databases like Backup and Restore. Handled applications level Jobs.

Managing Files and file Groups: Handled data files and log files in the File groups and creating New File group. Handling space utilization of the files and increased space.

Disk Space Issues: Handled Disk Space issues of the Different drives of the SQL Server. Shrinking Log files, Deleting archived Backups, handling TempDB Issues.

Ensuring security to the database servers by performing Encryption through TDS using Key Vault in Cloud.

Taking Backups and performing Databases restore in Cloud Environment.

Involved in deploying and configuring various EC2 and RDS machines for Cloud Customers.

Microsoft Azure SQL Services: Handling Cloud Database Issues.

Configured high availability in multi-subnet and multi AZ environment in AWS.

Working Experience on IaaS, PaaS Instances in AWS Cloud Environment.

Working Experience on IaaS, PaaS Instances in Azure Cloud Environment.

Configuration and Management of Azure SQL Database.

Current Role/New Role:

I have been aligned in HCL Cloud Database Practice Team since April 2020 where my roles are as follows :

Migration of SQL Server from on premise to Cloud Platform . Performed migration of databases from On Premises to Azure Cloud Platform (VM machine & Azure SQL Database)

Configuring and migrating High Availability techniques on Cloud Platform.

Involve in Transition Process of new project/Customer .

Skills

Primary Skill category

MS- SQL DBA

Linguistic Skills

English, Hindi

Operating Systems

Windows Server 2003/2008/2008R2/2012

Databases

SQL Server 2005/2008/2008R2/2012/2016

Certification

Amazon AWS Certified Solution Architect Exam ;Microsoft SQL Server 2008 Implementation & Implementation(432) and Windows Server 2008 Active Directory,Configuration(640)

Tools & Utilities

SQL Profiler, Service Now (Service Request manager),Spotlight,Spectrum,Foglight,Vistara,

Employment Summary

Organization

Designation

Duration

HCL Technologies Ltd.(ISD)

Senior Analyst (SQL DBA L2)

Oct/2014-Till Now

Project Profile

Project Name

Elastic _Operations (Shared Services )

Client

Handling Multiple Client as working for Shared Services namely Honda Motor Europe,MTaas, GAIC, Saint Gobain DU Telecom,UTI Logistics

DE(USA),Adecco,Wolters Kluwer, LGIM, Arcelor Mittal, Manchester United,HCL Cloud COE Team

Role

Database Administrator

Organization

HCL Technologies, Noida SEZ-126

Duration

(Jan-2015) – Till now

Skills

Database : SQL Server 2005/2008/2008R2/2012,2014,2016

O/s: Windows Server 2003/2008/2008R2/2012

Educational Qualification

Degree

University

Year of Passing

B.Tech

Integral University,Lucknow

2013

Personal Details

Father’s Name

Mr. Syed Ghazanfar Abbas

Mothers Name

Mrs. Nigar Fatma

Email Id

syedhaiderdba @gmail.com

Address

F117-West Jawahar Park,Laxmi Nagar,New Delhi .

Contact Numbers

+91 -893-***-****

Aadhaar No:824*********

Syed Haider Abbas

DOB: 15-03-1990

Contact this candidate