Sign in

SQL Server DBA

Cary, NC
January 08, 2020

Contact this candidate


Mubashera Shafiq

Cary NC



Software Professional with 10+ years experience in Database Management Systems.

Experienced in production support especially with business critical issues.

Experienced in design and development of application software using C,C++,Python.

Expertise in creation and design of reports using SQL and shell scripting.

Oracle HCM Cloud Specialist

Expertise in installation configuration and customization of SQL Server 2005-2014 and Oracle(7-9i)

Experienced in troubleshooting issues related to performance,space management,authentication and authorization and database integrity.

Experienced in writing SQL queries,triggers and stored procedures.

Profound understanding of Software Development Life Cycle and Virtualization.

Expertise in installing,configuring and updating Linux Servers

Experience in creation of virtual machines on linux and windows server.

Experience with Logical Volume Manager. Configuring and monitoring Disk mirroring, striping using LVM on Linux Environment.

Technical Skills:

Relational DBMS

Microsoft SQL Server 2008/2008R2/2012/2014, Microsoft Access, Oracle,MySql

Server operating systems

Windows Server 2003/2008/2008R2/2012, Linux, UNIX

Programming Languages

C, C++, VC++, Python, Windows API,Shell Programming,COBOLLLLLLLLLLLLlll


Oracle HCM Cloud,Azure


PSSDIAG, SQL Profiler, Perfmon,Virtual Box,Ansible


Microsoft Certified IT Professional (MCID :6635392)

Oracle Certified Specialist (Cloud HCM)

Professional Experience

Xduce Corporation

Database Analyst/SQL Support(Saas)

New Jersey USA

April 2017-Sep 2019

Data Conversion,Implementation of Core HR Modules and creation of customized reports.

Develop BI (Business Intelligence)/OTBI (Oracle Transactional Business Intelligence) Reports in Core HR, Payroll and Compensation modules.

Developed BIP report for TOP 30 TCC ranked employees with multiple data sets.

Complex calculations and computations incorporated in all compensation reports.

Computed datasets for prior years was retrieved using a complex feature of BIP and compared against current year.

Creating report using HCM Extracts

Data conversion to establish new company on Oracle HCM Cloud using HDL.

Developed data reconciliation BIP reports for migrated data.

Design, develop and maintain various types of BI (Business Intelligence) Templates like e-text template, XSL (XML Style Sheet) Template and RTF Templates to produce various fixed length report layouts, Excel Reports and PDF Reports.

Team participation for WF compensation planning.

Design new Area of Responsibilities as per requirements.

Designed complete migration process of data for the new acquisition via HDLs

Environment:Oracle HCM Cloud, Oracle BI Publisher

Consultant(Remote Work)

Srinagar Technology Consultants Private Limited

May 2014–Mar’2016(Bangalore India)

Design,development and implementation of SQL server 2008/2012 database for the Windows 2012 server.

Automation of operations tasks related to system provisioning, administration, and maintenance using shell and python scripting.

Device configuration backup using python.

Code testing using python scripts.

Using Bash shell scripts for function testing.

Creating different virtual machines on Linux server for testing .

Installing updating and configuring packages on Linux using YUM,APT,RPM.

Environment: Windows 2008/2012,Linux,SQL Server 2008/2012,Python,Linux

Microsoft SQL Server Production Support Engineer

Microsoft R&D India Pvt Ltd

Bangalore India.

Mar 2008 – May 2012 (EMEA Support) /May 2012-Jan 2014 (US Support-PST)

Experience in providing 24X7 support for production severs in industries like communication, banking.

Installed and configured different versions of SQL Server (SQL Server 2005, SQL Server 2008R2, SQL Server 2012) in non-prod and prod environments.

Monitored, fine-tuned and resolved performance issues in test, development and production servers.

Configured and applied SQL Server Service Packs and Hot Fixes to all Production and non-prod database servers.

Created maintenance plans for consistency checks and maintained indexes and statistics.

Planned, designed and implemented two and three node clusters and configured MS SQL on clusters.

Worked on daily activities like jobs monitoring, space alerts, troubleshooting, backup verification and jobs scheduling.

Planned, implemented and managed HADR solutions like log shipping, mirroring, clustering, Replication and Always on.

Configuration and maintenance of linked servers.

Experience in creating views, stored procedures and other database objects using T-SQL.

Worked with SQL server Profiler, and generated traces to optimize the performance of the database.

Have extensive experience in using several third-party tools to monitor and optimize the performance of prod and Non-prod servers.

Performed index maintenance based on the fragmentation level of various tables.

Resolved locking and blocking and deadlock issues.

Planned and modified permission issues in the production servers and provide only the minimum required permission to the users on production database systems.

Assisted other teams (Windows) in pointing out bottlenecks, and recommended solutions.

Profound understanding of Software Development Life Cycle.

Creation of Virtual servers using Windows Hyper V

Implemented and maintained policies, procedures and standards to ensure security and integrity non-prod and production data.

Experience in upgrading and migration from MS SQL Server 2005 to MS SQL Server 2008R2, MS SQL Server 2008R2 to MS SQL Server 2012

Environment: SQL server 2012/2008 R2/2005, MS Office communicator, Share point server, Windows 2008/2012.Windows azure

Subject Matter Expert :Installation/Configuration,SQL Database Replication

Database Manager

J&K Bank Kashmir India

Jul 2002-April 2007

Installing,configuring and updating Unix Server Operating system.

Managing users and groups and assigning file access privileges, ACLs, changing ownership of users and groups using chown, chgrp commands, modifying the file permissions using chmod, SUID, SGID, and Sticky bit commands according to the requirement.

Customization of Banking software involving changing the custom parameters.

Creation and configuration of the Oracle database(7,8 and higher).

Tuning the system semaphore and shared memory segments for better throughput.

Troubleshooting issues like space management,database tuning, database corruption,database recovery.

Data migration and post migration support

Design and development of shell scripts for reporting.

Providing adequate training to the banking staff .

Environment:Unix,Solaris,Oracle 7,8i and above,Shell scripting,Windows

Software Developer (Offsite)

Srinagar Kashmir.

Bill Quick Inc (BQE)(LA California)(

Jul 2001-Jul 2002


Design and development of application interface,linked libraries.

Database design and normalization.

Development of software MySpy, AgentPro using VC++ and MFC

Software testing.

Environment:Windows,VisualStudio 6,VB.Net,VC++



Socket programming in C to transfer files,execute remote procedure calls between linux and windows

File transfer involved transfer of files from one system to another (i.e a send message on one end resulted in file being transferred to another end. Both single and multiple files could be transferred.

Remote procedure call was to accomplish a task by calling a function on remote machine. Use of functions called server stubs and client stubs were made.

The code was written in C


B.E Computer Science Gulbarga University Karnataka 2001

Contact this candidate