Sr: SQL DBA

Mubashera Shafiq

Senior SQL Server Database Administrator

SUMMARY:

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

Part of CSS teams in Microsoft developing long-term client relationships and acting as a trusted advisor.

Oracle HCM Cloud Specialist (SAAS)with PL/SQL expertise.

Experienced in production support especially with business-critical issues (SQL Server On Windows).

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 for ORACLE Cloud.

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

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

Expertise in installation configuration and customization of SQL Server 2005-2014 and Oracle (7, 9i and 11g XE).

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

Experienced in writing SQL queries,triggers, and stored procedures.

Knowledge of Agile and Waterfall development methodologies.

Technical Skills:

Relational DBMS

Microsoft SQL Server 2017/2016/2014/2012/2008R2/2008,

Oracle 7/8i/10g/11, MySql 5.7/5.8

Operating systems

Windows Server 2012/2008R2/2008/2003, RHEL 7, CentOS 7

Programming

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

Cloud

Oracle HCM Cloud, Azure

Tools

PSSDIAG, SQL Profiler, Perfmon, Virtual Box, Ansible, Tableau

Certifications:

Microsoft Certified IT Professional (MCID :6635392)

Oracle Certified Specialist (Cloud HCM)

Education:

B.E Computer Science - 2001, Gulbarga University, Karnataka, India.

Professional Experience:

Amerisource Bergen Specialty Group Mar18 – Till Date

Senior SQL Server Database Administrator Dallas, TX

Monitor and support SQL servers.

Installation & configuration of SQL Server on Cluster / stand-alone Tools and Technologies.

Day to day database administration activities for all the applications under SI-DBA Team to make sure the availability of databases to the application users by understanding the client requirements closely.

Check Server configurations, SAN storage configurations, RAID levels.

Configure Reporting Services (includes Report DB migrations), SSIS Packages, IIS, and AD level policies.

Configure SSIS, SSRS, IIS, Active directory level policies etc.

Configuration of Replication, Mirroring for performance and data availability.

Configure SQL Server Memory, sp_config options, drives for data, log, backup.

Migration of Databases, and other SQL objects to new servers.

Performing SQL Server Patching, SQL Server Upgrades.

Coordinating with Wintel team for procuring & decommissioning hardware.

Monitoring the Production Database Server's Health and Performance Tuning accordingly.

Implementing strategies for managing security roles, privileges, and authentication.

Working on the production fixes as per the ticket raised for the reports which are in production Tools and Technology.

Tools and Technology: SQL Server 2017, 2016, 2012.

Xduce Corporation (IEEE Organization) April 17 – Feb 18

Oracle Fusion with PL/SQL Scripting Edison, NJ

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

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 using PL/SQL.

Complex calculations and computations incorporated in all compensation reports.

Computed data sets for prior years were 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.

Tools and Technology:Oracle HCM Cloud, Oracle BI Publisher

Srinagar Technology Consultants Private Limited May 14–Mar16

Database Consultant (Remote Work) 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.

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.

Tools and Technology: Windows 2008/2012,Linux,SQL Server 2008/2012,Python,Linux

Microsoft SQL Server Production Support Engineer Mar 08 – May 12 and May 12 – Jan 14

Microsoft R&D India Pvt Ltd Bangalore, India

(EMEA Support) and (US Support-PST)

Subject Matter Expert: Installation/Configuration, SQL Database Replication.

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

Able to dive deep into the market and understand the dynamics of the workload they are supporting.

Provide leadership both within the customer team and on their behalf back to Microsoft and the account teams.

Can increases client technology adoption and investment by presenting solutions that support short and long-term business strategies.

Build a business case that rationalizes the cost of technology using value realization, thereby impacting bottom-line result

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

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.

Tools and Technology:SQL server 2012/2008 R2/2005, MS Office communicator, Share point server, Windows 2008/2012.Windows Azure.

J&K Bank Jul 02 – Apr07

Database Manager Kashmir, India

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.

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

Bill Quick Inc (BQE)(LA California)(http://www.bqe.com) Jul 01 -Jul 02

Software Developer (Offsite) Srinagar, Kashmir

Design and development of application interfacelinked libraries.

Database design and normalization.

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

Software testing.

Tools and Technology:Windows,VisualStudio 6, VBNet,VC++

ACADEMIC ASSIGNMENTS –

CONNECTIVITY USING SOCKETS(LINUX AND WINDOWS with C)

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.

Contact this candidate