sarfaraz ali khan mir

Bensenville, IL, *****

510-***-**** adgwl4@r.postjobfree.com www.linkedin.com/in/mir-sarfaraz-ali-khan

Summary

Database enthusiast with extensive experience in Database Administration and SQL Development using variety of database systems including SQL Server, DB2 LUW, Oracle and Azure SQL. Self-motivated and result oriented team player with excellent problem-solving skills and zeal to learn new technologies.

Around 6 years of experience in Database Administration and SQL development for very large databases in SQL Server 2017/2016/2014/2012/2008 R2/2005/2000, DB2 LUW 9.7/10.1/ 11 and Azure SQL.

Extensive experience in migrating and upgrading databases to latest versions (upgrade and in-place) and migrating on-premise databases to cloud platforms Microsoft Azure and AWS

Expert in implementing and troubleshooting databases in High Availability environments using HA/ Always ON, Replication, Log shipping, Database mirroring and failover clustering using SQL server and HADR in DB2 LUW.

Expert in writing efficient SQL code following standards and best practices. Creating stored procedures, Views, functions, in-line queries.

Creating and tweaking Indexes (Clustered and Non- Clustered) to improve performance

Expert in developing ETL SSIS Packages for data warehousing systems and designing reports using SSRS, PowerBI.

Proficient in database performance monitoring using DMVs, SQL Profiler, Database Engine Tuning Advisor, Activity Monitor, execution plans, Performance dashboard and Performance Counter.

Expert in Performance Tuning and Query optimization.

Proficient in writing scripts in PowerShell and Bash to monitor and administer databases.

Setting up and configuring third party tools like SolarWinds, Orion and backup tools like NetBackup, Redgate.

Highly adept in performing database engineering tasks and Data Analytics.

Expert in capacity planning, resource allocation (memory, CPUs) and designing backup strategy as per RTO and RPO.

Expert in implementing SQL server security at server, database and object level.

Deploying SQL code to production server via DACPAC, scripts utilizing change management and ITIL best practices.

Installing, configuring and administering SSIS, SSRS and SSAS

Experience in implementing Table Partitioning, Change Data Capture, Dynamic Data Masking, Adaptive Compression (DB2 10.1).

Technical skills:

Databases

MS SQL Server 2017/2016/2014/2012/2008,2005,2000, DB2 LUW, MS Access, Oracle 11g, Microsoft SQL Azure, Mongo DB.

Operating Systems

Windows, Unix, Linux

BI Tools

SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Power BI, Tableau, SQL Server Analysis Server

Languages

JAVA, C#, SQL, HTML, CSS, XML, Power Shell, Bash

Monitoring Tools

SCOM, BMC Portal, Orion, SolarWinds,

SQL server Tools

Management Studio, Enterprise Manager, Index Tuning Wizard, Database Tuning Wizard, Profiler, Query Analyzer, Export & Import, Visual studio.

Experience

P.S.A.V, Schiller Park, IL 2017 – 2020

A $4B company, a global leader in providing event experiences. Acquired by BlackStone Group in June 2018.

Database Admin SQL

Create and modify database objects (stored procedures/ triggers/ views/tables etc) and perform SQL code review.

Support the development and project team with Database modelling and design.

Administration of large databases for complex applications in SQL Servers ranging from 2008 R2 to 2017.

Installing, Configuring, Securing and Monitoring Microsoft SQL Servers. Implementing high-availability solutions (AG, HADR, Log Shipping, Clustering, Replication)

Planning and allocating hardware resources to DB servers and performing regular DR exercises.

Responsible for creating and maintaining ETL process used in enterprise data warehouse system.

Design and Develop SSIS packages that integrate data from various data sources - SQL Server, Oracle, MuleSoft, MS Access and Flat files (CSV, JSON) from third party applications.

Migrating on premise SQL databases to Azure SQL using DMS. Managing backup/recovery, security and scheduled tasks on the Azure SQL instances. Troubleshooting issues relating to network, firewall.

Worked on development of visualization reports and dashboards in Power BI and Tableau that utilize the company’s EDW databases.

Collaborate with other team members and business owners to provide SQL solutions for reporting and ad-hoc data extracts to business users.

Worked on Performance Tuning and Query Optimization. Analyse SQL query plans using SQL sentry, SSMS and optimizing complex SQL queries by ensuring best practices in SQL operations like joins, temporary tables usage, grouping/sorting etc.

Identify slow performing SQLs and fixing them by tweaking indexes, datatypes, bad statistics etc.

Work on increasing system efficiency. Changing server and database configurations to better handle system workload.

Worked on Table Partitioning and data archiving mechanism for OLTP and business warehouse systems as per company policy.

Develop solutions for data security to comply with GDPR policies – Dynamic Data masking of sensitive columns.

Tune in-line SQL queries and Stored Procedures, Create/Modify Indexes Clustered and Non-C indexes as required.

Optimizing complex SQL reports to avoid Parameter sniffing by analysing SQL joins and datatype usage.

Create automated backup-recovery mechanism and other jobs to monitor resources, security and performance.

Automated the deployment process for production environments to make use of DACPAC via Jenkins

Inspiration Corporation, Chicago, IL Summer 2016

A non-profit organization that helps homeless people find housing, training and placements.

Intern DBA

Worked as an Intern for migrating Database from SQL Server 2012 servers to MS Access servers. Automated the process of migration using batch scripts to help Non-IT team to refresh Database when required.

Computer Sciences Corporation India Pvt Ltd, Hyderabad, India 2013 – 2015

An American multinational corporation that provides IT services. Now DXC Technology.

Database Administrator

Worked in a team spread across UK and India to support Microsoft SQL Server, IBM DB2 LUW and database servers for various clients including Arcelor Mittal, Noble BioCare, Royal Mail Group, Virgin Atlantic Airways, MetLife Inc, AIA Insurance.

Implemented Adaptive Compression on OLAP servers for Noble BioCare in DB2 LUW 10.1 and Microsoft SQL servers resulting in 80% storage savings and improved query responses.

Administrative activities included setting up environments, scheduled maintenance activities, planned disaster recovery exercise, installation, configuration, upgradation of Database Servers, OS, Security patches.

Worked on Index Rebuild and Index Reorganization based on fragmentation.

Supported activities across multiple environments that includes database refresh, troubleshooting app issues, monitoring daily jobs, providing support to dependent teams (development, business, and end-customer) and deployments.

Experience with configuring and monitoring backup-restore strategies, Archive logging and serving security requests.

Worked on planning and Implementation of maintenance activities and Data migrations based on requirement.

Developed and Tested ETL jobs to support Data Movement as per requirement.

Developed automated monitoring using PowerShell script tasks to check the health and hygiene of database servers.

Experience in using third party tools like NetBackup, Redgate, Commvault for backup and recovery.

Configuring SQL Server Agent jobs, Alerts, Maintenance plans and mail.

Worked on configuring database backups (Full, Transactional, Differential) by creating maintenance plans.

Maintaining Database security as per SOX compliance. Grant/Revoke object level access, fixing Orphan users.

Worked with DBCC commands to check and fix data corruptions.

Resolved problems related to performance like high CPU, Blocking, CPU Utilization and Deadlocks.

Education

Master of Science, Computer Science & Engineering, LOYOLA UNIVERSITY CHICAGO, Chicago, IL

Bachelor of Engineering, Information Technology, OSMANIA UNIVERSITY, Hyderabad, India

CERTIFICATION and ACTIVITIES

IBM Certified Database Associate DB2 10.1

Participated in various workshops and conferences for performance tuning of database by IDUG.

Responsible for training SQL Server Administration, DB2 LUW to the new joiners at CSC India.

Contact this candidate