M H NADEEM KHAN
Al Qasimiya, Sharjah, UAE
https://ae.linkedin.com/pub/nadeem-khan-‫ندیم-خان‬/bb/824/57a
Phone: +971-565389...
Diagnose and tune system performance using Performance Monitor, SQL Profiler and other related
monitoring and troubleshoot...
Scripting involves database operations such as online/offline databases, backup/restore,
create/migrate logins, linked ser...
Disaster Recovery planning, setup and documentation.
Configuring and Managing database mirroring, replication and fail ove...
SQL Subject Matter Expert - act as consultant to developers for SQL programming.
Oversees design, database structure and q...
Personal Information
Name : Nadeem Khan M H
Date of Birth : 06th
Feb, 1991
Father's Name: Mr. Hameed Khan M H
Mother's Nam...
Personal Information
Name : Nadeem Khan M H
Date of Birth : 06th
Feb, 1991
Father's Name: Mr. Hameed Khan M H
Mother's Nam...
of 7

Nadeem_DBA

Published on: Mar 3, 2016
Source: www.slideshare.net


Transcripts - Nadeem_DBA

  • 1. M H NADEEM KHAN Al Qasimiya, Sharjah, UAE https://ae.linkedin.com/pub/nadeem-khan-‫ندیم-خان‬/bb/824/57a Phone: +971-565389859 Email: Nadeem.KhanMH@gmail.com Objective To obtain a challenging position in the area of MS SQL Server Database Administration for managing critical databases and achieve company’s requirement. To constantly upgrade my knowledge and skills and make a difference in whatever I do. Profile Summary • 3.5+ years of extensive experience that includes System Analysis, Programming, Installations & Configurations, Design, Development and Administration of MS SQL Servers 2005/2008/2008 R2/2012/2014. • Technical Expertise in Database Administration of SQL Server (2005/2008/2008 R2/2012/2014) as Architectural (Development) and Operational DBA. • Plan and deploy Standalone, Clustered, Dedicated and Shared Instances (Database Engine). • MS SQL Server Database Migrations from lower to higher versions (In-Place and Side-by-Side). • Optimize disk allocation, CPU usage, Memory, I/O throughput, and other resource contention. • Experience implementing 6-Node Failover Cluster (Geo-Clustering) along with other high availability features such as Log shipping, Replication and Database Mirroring. • Ensuring proper Disaster Recovery solution is in place for all production databases. • Respond more efficiently to failure scenarios by troubleshooting and resolving dB integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues etc. • Backups, Restores, Recovery Models, Database Security, Database Integrity, Database Testing, Database Shrink Operations and DBCC commands. Resume of Nadeem Khan Page 1 of 6
  • 2. Diagnose and tune system performance using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools. • Implement robust security by creating Service-Accounts & Logins with Authentication, Authorization, fine-grained auditing, and fine-grained access control. Skills and Strengths Databases – SQL Server 2000/2005/2008/2008 R2/2012/2014, Oracle 9i/10g/11g Installations, Configurations, Upgradations and Management of SQL Server and Oracle Databases along with required Service Packs & Patches. Database Migrations to other Instances of same or different SQL versions using several ways – Database-Mirroring, Log-Shipping, Backup Restore and Copy Database Wizard. High-Availability and Disaster Recovery (“HADR” together) using “AlwaysON Availability Groups” (AOAGs), Failover Clustering, Mirroring (Sync & Async), Replication (Transaction, Snapshot & Merge) and Log Shipping. Database Administration best practices that includes Backup (Full, Differential & Transactional Log), Recovery (Full, Bulk-logged & Simple), Restore, monitoring and performance tuning. Operating Systems – Windows 2000/2003/2008/2012 R2 Servers, Red Hat Linux 9.0 Install, Upgrade, Maintain and customize all Windows Server & desktop operating systems along with other system software. Creation, Configuration and Management of Windows-Failover-Clustering and Windows Server Failover Clustering (WFSC). Working Knowledge and experience with System Center Configuration Manager (SCCM). Strong understanding of TCP/IP, DNS and Microsoft Technologies such as Group Policy Management, Computer & Disk Management, Users Management etc. Microsoft BI Services – SSRS, SSIS, SSAS, MDS Installation of SSRS and Configuration of the same using Report Services Configuration Manager. Experience implementing HADR and Scalability for SSRS along with report development. Installation of SSIS, Creating of SSISDB Catalog and Deploy SSIS Projects. Comprehensive Knowledge on SSAS and MDS. Programming Languages – TSQL, PL/SQL, UNIX Scripting Well Versed in writing, optimizing and troubleshooting SQL Code and queries, in TSQL and PL/SQL. Resume of Nadeem Khan Page 2 of 6
  • 3. Scripting involves database operations such as online/offline databases, backup/restore, create/migrate logins, linked servers and all such database operations. Create stored procedures, Functions, Views, Triggers, Indexes and Constraints Good knowledge of Linux and UNIX basic commands including shell scripting using VI editor. SQL Server Tools – SSMS, SSCM, SQL Server Profiler, DTA, Failover Cluster Manager, RSCM Oracle Tools – Oracle Enterprise Manager (OEM) Other Tools – Server Manager, SCCM, Putty, Performance Monitor, EMC Networker, BMC Remedy, TOAD, SQL Developer, Qlikview, Tableau, Citrix, VMware. Work History Jun 2015 - Present: SQL Consultant at HP (Hewlett-Packard) Account: Du (Emirates Integrated Telecommunications Company) Project: Du Khazna Responsible for all functions associated with the installation, configuration, migration, design, implementation and maintenance of SQL server databases. Manage all technical aspects of the databases, ad-hoc operational data and reporting requests. Responsible for managing multiple 6-Node SQL & Windows Clusters and HADR for SSRS. SQL Server migrations from SQL Server 2005/2008 to 2008 R2/2012/2014 between non-clustered and clustered environments. Configuring and Managing Database Mirroring, Replication, Log Shipping and Failover Cluster (Stretch Clusters) between servers. Load Balancing SQL Server Instances between High-Availability Nodes. SQL Server 2012/2014 Active/Active Cluster Setup with AlwaysON configuration Setup High Availability as part of Disaster Recovery Strategy for the databases. Design Database Backup and Restoration Strategy. Troubleshooting and resolving all database related issues within fixed SLA time. From time to time recover the databases to a specific point of time, as per the requests. Proactive Monitoring (CPU, Disk I/O, Memory), Performance tuning and Query Optimization. Documenting MS SQL Server database design, implementation and configuration. Oct 2014 - Mar 2015: SQL DBA at Net7 Technology Solutions. Account: Sanofi Aventis & Sanofi Pasteur Project: Integrated Commercial Database (ICW) - Production Support Installing, Configuring and Hardening of all versions of MSSQL Servers (2005/2008/2012) as per the organization standard and data protection act. SQL Server 2012 Active/Active Cluster Setup with AlwaysON configuration SQL Server migrations from SQL Server 2000/2005 to 2008/2012 (In-Place and Side-by-Side). Resume of Nadeem Khan Page 3 of 6
  • 4. Disaster Recovery planning, setup and documentation. Configuring and Managing database mirroring, replication and fail over cluster between servers Managing time critical databases with very less downtime and failing over to DR site in case of disasters also performing DR drills. Performance tuning and optimizing by setting up appropriate indexes and regular data maintenance. Creating database design and development standards. Documenting MS SQL Server database design, implementation and configuration. Supporting internal and external clients. Well verse with ITIL standards incident, change and problem management. On call production support 24X7 experience. Deploying new production systems and decommissioning old servers. Developing scripts for Production data archival automated and capacity management reports and schedule to run as jobs. Aug 2012 - Oct 2014: Programmer Analyst at Cognizant Technology Solutions. Account: Blue Cross Blue Shield (BCBS) of Minnesota. Project: EDIM Claims Repository 24X7 production support environment. Responsible for installations and configures, maintains, supports and troubleshoots databases installations, both in the development and testing environments. Managing High availability server environment (Replication, log shipping and SQL server clustering). Setting up DR Servers for Mirroring, Log Shipping, SRDF and Coordinating DR tests. Managing migrations of SQL 2005/2000 servers to SQL 2008/2008 R2 servers. Responsible for maintaining SQL Servers on virtualized environment (VM Ware). Securing and auditing SQL Server through industry standard SQL hardening procedures and reviewing audit logs periodically. Database design document, installation and document to change SQL configuration settings. Planning, sizing and managing SQL server for specific business requirement as per the needs. Planning and implementing backup and restore as per agreed SLAs through native SQL server jobs and conducting recovery tests in testing environment. Troubleshooting performance problems by query optimization, index tuning, re indexing, re compiling, and by upgrading the server hardware CPU and physical memory. Designing and Implementing Maintenance Plans for optimal performance. Experience in handling very large databases up to 1.5 TB on SQL Server 2012 server. Account: Royal Bank of Canada (RBC) Project: Financial Enterprise Data Repository (FEDR) Solving client request in terms of tickets Deploying change control requests and ensure adherence to change control processes. Database mirroring setup, log shipping and replication setup and troubleshooting. Performing query and system tuning to ensure code and use of SQL server is organized and efficient. Resume of Nadeem Khan Page 4 of 6
  • 5. SQL Subject Matter Expert - act as consultant to developers for SQL programming. Oversees design, database structure and query construction to promote DR, integrity and performance of applications. Cluster troubleshooting and failover, Disaster recovery. Create and maintain documentation of SQL configuration and inventory, awareness of SQL configuration change and impacts. Establishing and implementing back up and restoration process for SQL service. Approve and complete database object promotion and maintain promotion log. Performing ad hoc import/exports and maintain schedule for routine import/exports. Constant interaction with Database Server Support Groups on Database backups, recovery, Replications, Memory Issues, Security, Patch updates, Maximum number of users, connectivity. Designing, Implementing & Monitoring SQL Maintenance Plans for optimal performance. Maintenance of transaction logs and Error logs. Dec 2011 – Apr 2012: Database Developer (Contract-Basis) at Luminosoft Technology Solutions.  Designed, Implemented and administered the ‘Intrusion Response System for Relational Databases- an Application for Database Security’. The Major contributions include  Database Software Installation and Configuration  Database Creation, administration and maintenance  TCP/IP Network and Router Configuration.  Operating System Configuration.  User accounts creation and management.  Encryption of database files using Advanced Encryption Standard (AES) during Storage.  Decryption of database files during retrieval.  Creating alert to all DBAs on suspicious activities. Training/Workshops 2012 Attended workshop and trained on MS SQL Database Administration at CTS. 2012 Underwent training at Cognizant Technology Solutions on MS SQL 2005/2008/2008R2/2012, SQL Scripting, High Availability and Disaster Recovery. 2011 Underwent in-plant training at HCL Technologies Pvt. Ltd, Chennai and observed study on Database Administration, Networking and System Administration. Education 2012 Bachelor of Technology - Sri Venkateswara College of Engineering, Chennai, India Major: Information Technology CGPA: 7.2 2008 12th Standard Matric. - MLM Mamallan Matric. Hr. Sec School, Kanchipuram, India Percentage of Marks: 94.2% 2006 10th Standard Matric. - Khatri Matric. High School, Kanchipuram, India. Percentage of Marks: 83.4% Resume of Nadeem Khan Page 5 of 6
  • 6. Personal Information Name : Nadeem Khan M H Date of Birth : 06th Feb, 1991 Father's Name: Mr. Hameed Khan M H Mother's Name: Mrs. Rihana Khan Nationality : INDIAN Passport No : L1019232 (Issued Place: Chennai; Validity: 29/04/2013 to 28/04/2023) Declaration I do hereby declare that the particulars of information and facts stated herein above are true, correct and complete to the best of my knowledge and belief. Resume of Nadeem Khan Page 6 of 6
  • 7. Personal Information Name : Nadeem Khan M H Date of Birth : 06th Feb, 1991 Father's Name: Mr. Hameed Khan M H Mother's Name: Mrs. Rihana Khan Nationality : INDIAN Passport No : L1019232 (Issued Place: Chennai; Validity: 29/04/2013 to 28/04/2023) Declaration I do hereby declare that the particulars of information and facts stated herein above are true, correct and complete to the best of my knowledge and belief. Resume of Nadeem Khan Page 6 of 6

Related Documents