Khizerzai Uzair Nazeer Khan

+965-****-**** (KWT) / +91-880******* (IND)

adkxc5@r.postjobfree.com

PROFESSIONAL SUMMARY

An experienced Microsoft SQL Server Database Administrator with Over 5+ years of experience in IT industry with extensive experience in MS SQL Server installation, configuration, migration, upgrading, applying service pack, performance tuning, query optimization, client/server connectivity, backup/recovery, database maintenance plans and database consistency check. Comprehensive knowledge and experience in installation and configuration of High Availability (HA) and Disaster Recovery (DR) solutions such as SQL Server log shipping, replication, database mirroring, Always On, and clustering. Aspiring to be a part of reputed organization that provides steady career growth along with job satisfaction and new challenges.

Hands On Experience in administration of Cloudera Distribution Hadoop cluster with implementation, configuring services, securing and testing the Cluster.

TECHNICAL PROFICIENCY

Database:

Administration and Management of Microsoft Sql Server (2008, 2012, 2014 & 2016)

Complete understanding of security and back up procedures

Monitoring the Failover cluster connectivity and performance.

Experience to work under critical and time bound activities.

Backup and recovery tasks

Working Experience with Vmware Vsphere 6.5 (Virtualization)

Knowledge in Active directory

Maintain Backups & Perform Recovery on daily basis on EMC AVAMAR

Working knowledge on Linux (RHEL/CENTOS)

Server hardware planning & implementation, troubleshooting and maintenance

Theoretical knowledge of Oracle Database Administration (11g/12c)

Hadoop Administration:

Cluster maintenance as well as creation and removal of nodes using Cloudera Manager

Hadoop cluster Implementation and administration.

Performance tuning of Hadoop clusters and Hadoop MapReduce routines.

Monitor Hadoop cluster connectivity and security

HDFS support and maintenance.

Solr Index creation, maintenance and tuning

EXPERIENCES

Softech Technology Solutions, Kuwait(On-Site) --- Database Administrator

January 2018 – Present

Installed and configured SqlServer(2014 & 2016)

Configured Backup jobs according to the requirements

Create Database, tables, views, indexes and stored procedures

Responsible for monitoring and troubleshooting AlwaysOn high availability option and backup & recovery

Implemented Transparent Data Encryption (TDE) on multiple Databases according to client requirements

Index Management: Rebuild, Reorganize, delete unused indexes and create missing indexes.

Verify and run Scripts for Application update and Patches

Experience in installation, configuration different versions of SQL Servers.

Responsible for upgrading SQL Server databases from 2008 R2 version to 2016 version

Monitor, optimize and request data storage allocation for databases.

Automated loading incremental tables from linked server database into local database.

Responsible for securing SQL Servers and granting permissions to users.

Setup Jobs, maintenance plans for backups, rebuilding indexes, check server health, alert, notifications.

Provide support during weekends and off-hours for windows prod and non-prod patching and ensure database availability and failover Cluster availability.

24/7 on-call to ensure database operations and availability.

Identify and resolve deadlock, block, and locking using extended events, and DMVs

Configure linked server between SQL Server and MySql.

Worked closely with systems team to apply SSL certificates.

Grant appropriate levels of permissions and privileges for database and Application users.

Worked closely with systems team to Plan and lead applying new builds (service pack, cumulative update, hot fixes) in prod and non-prod SQL Servers.

Documented application point of contact for each database.

Import flat and CSV files data to SQL Server database.

Monitor Server Activity, Error Log, space usage and solving problem as needed.

Performed daily DBA duties such as monitoring SQL Server health, job status, and addressing user requirements.

Perform database deployments, database refresh and execute scripts, granting and revoking permissions in prod and non-prod.

Resolve database access and performance issues and manage data files and log files, and troubleshoot performance bottlenecks with extended events, resource/performance monitor, task manager, activity monitor, server report, and DBCC commands and DMVs.

Recommend and improve database security policies that are consistent with security guidelines and best practices

Softech Technology Solutions, Kuwait(On-Site) --- Jr. Database Administrator

November 2016– December 2018

Served as a database administrator responsible for managed high availability and disaster recovery solutions, including backup & recovery, replication, log shipping and AlwaysOn.

Monitored and managed database growth, data files and log files, and troubleshoot performance bottlenecks with SQL Server Profiler, Extended Events, DBCC commands and DMV. Resolved database access and performance issues.

Scheduled and monitored daily and monthly batch jobs using CA workload automation, SQL Server Agent Jobs and Maintenance Plan. Check for failed jobs, investigate root causes, resolve and document error logs.

Identified and Optimized poorly written queries and code by using SQL execution plan and running process for TSQL code in order to improved performance and minimize cost.

Created maintenance plan for consistency checks, maintaining indexes and statistics. Used DMVs to find missing, unused and duplicate indexes and created appropriate indexes to optimize slow running queries.

Granted appropriate levels of permissions and privileges.

Provide DBA support and technical expertise for multiple applications in Test and production - SQL Server 2012, 2014, and 2016 environments.

Render services to client for 24/7 on Call Support for Production Databases

Improved performance, reliability, security and scalability by improving internal processes and make recommendations on new storage hardware.

Performed database maintenance, tuning, archiving, backups, replication, recovery, software upgrades and optimization for SQL Server database.

Designed and implemented incremental and full backup policies and procedures.

Installation, Configuration and Deployment of SQL Databases.

Monitor and optimize system performance using SQL Profiler and Database Engine Tuning Advisor.

Grant Users access and authorizations, Create Users for Application Logins and Administration.

Administrating application users like creating, assigning roles and responsibilities.

Scheduling Backups and Restore and Maintenance plans using SSMS Tool.

Responsible for implementation and ongoing administration of Hadoop infrastructure.

Hadoop File system management and monitoring.

designing, capacity arrangement, cluster set up, performance fine-tuning, monitoring, structure planning, scaling and administration of Cloudera Distribution of Hadoop

Conquest technology Solutions Inc, Hyderabad, India. --- Desktop Support Engineer

August 2014– July 2016

Installation, Upgrades, Patches, Configuration and Administration for SQL Server.

Validate Database Backups and T-Log Backups.

Ensure successful running of Database tasks Jobs, and check Errors and Alerts.

Experience in controlling the User Privileges, Create and Delete Users according to client requirements on Domain Controller.

Managing Service Accounts for Sql Server Service Accounts and Check for application Errors and Warnings to ensure successful running of Sql Server Instances.

EDUCATION

SCET (Jawaharlal Nehru technology University),

Hyderabad, India —

Bachelor of Technology in Computer Science & Information Technology.

SKILLS

Database: SQL Server 2008,2012, 2016, MySQL (8.0)

Operating Systems: Windows 2008 and 2012 Server, Windows 7 and 8, VMWare, LINUX, UNIX

Monitoring, BI and Other Tools/Software: Windows Event Logs, Activity Monitor, Cloudera Hadoop Manager, Apache Solr, EMC AVAMAR(Backup Solution), Sql Profiler, ODBC/DB Link, Integration Service (SSIS), Vmware VSPHERE 6.5, Microsoft Active Directory, Microsoft Excel, Access and Powerpoint

CERTIFICATIONS

CCA131 – Cloudera Hadoop Admin

TRAINING

MySQL

SSMS

CDH (Cloudera Distributed Hadoop)

SSIS & SSRS

Log Shipping, Mirroring, Replication, Clustering, and AlwaysOn

SQL Server Query Tuning & T-SQL

Oracle Database 11g & 12c

Unix and Linux

Centos 5 & 7

Contact this candidate