Database Administration

ASIF HAKIM

703-***-**** *********.**@*****.***

Executive Summary

Microsoft Certified SQL Server Database Administrator seeking a position where I can utilize years of experience in Database Development, Administration and Technical Support with analytical and troubleshooting experience in Data Modeling, DR & HA Solutions, Backup, Performance Tuning, Maintenance Plans, Automation, SSRS, SSIS, Security, Stored Procedures, Triggers, Functions, Constraints, Views, SharePoint, Report Builder, etc. for different SQL Server versions on different Operating Systems. I also have some experience working with developers on application coding and Software Testing as well as ETL Testing. An ideal role for me would be where I can exercise my knowledge and experience and have ample opportunity to learn new things.

Qualifications

oInstallation and Configuration (development, testing and production environments):

Successfully install and configure SQL Server

oUpgrade/Service Pack/Patches (development, testing and production environment):

Successfully upgrade and apply service packs, patches and updates to SQL Server

oDatabase Migration (development, testing and production environment):

Experienced in migrating databases from Oracle, MySQL, Access and other SQL Servers to different versions of SQL Servers

Tools Used: SSMA (SQL Server Migration Assistant), ODBC/DB Link, BCP

oDatabase Programming:

Able to write T-SQL, Triggers, Functions and Stored Procedures

Assist Database Developers to optimize SQL queries, Stored Procedures, etc.

Tools Used: Query Analyzer, Toad Data Modeler

oDTS/SSIS:

Importing and exporting data between SQL Server and other sources such as Excel, Flat file, CSV file, Oracle, MySQL, Access, ODBC/OLEDB data sources, etc.

Tools Used: SSIS, DTS, Import/Export Wizard, Informatica, Visual Studio

oDatabase High Availability:

Experienced in creating and maintaining high availability solutions including AlwaysOn Availability, Mirroring, Log Shipping, Replication and Clustering

oBackup/Recovery:

Extensive knowledge in designing and implementing Database Backup and Recovery for DR solutions including knowledge of Point-in-Time Recovery

Tools Used: SSMS, Maintenance Plan, RedGate, CommVault

oData Modeling:

Create ER diagrams using rules of normalization as well as using forward and backward engineering processes

Tools Used: Toad Data Modeler, ERWin, VISIO, SQL Server Data Diagram

oDatabase Monitoring/Performance Tuning:

Experienced in database Monitoring and Performance tuning

Practice of root cause analysis by using Wait Statistics

Tools Used: SQL Server Error Log, Windows Event Logs, SQL Profiler, Activity Monitor, SSMS, Performance Tuning Dashboard, Query Execution Plan, Tuning Advisors, Resource Governor, System Monitor, Perfmon, Counter, etc.

oReport Development:

Able to install, configure and administer SQL Server Reporting Services

Develop, Deploy, Manage Reports and Manage Reports Security

Tools Used: SSRS, BIDS and Report Builder

Professional Experience

Accenture Federal Services, Chantilly, VA May 2017 – Present

Database Administration Associate Manager

Project: As an infrastructure team member, configure and manage database infrastructure on Microsoft Azure IAAS platform to support a US Government project.

oStand up new SQL Server environments on Azure IAAS platform

oInstall, Configure and Maintain SQL Server 2012 and 2016

oWork with developers and other vendors to facilitate database creation, user permissions and database maintenance

oAccess Active Directory (AD) to manage Domain user permissions

oDesign and implement maintenance plans as required

oCreate and manage Agent Jobs to support application processes

oConfigure and maintain AlwaysON Availability Groups for High Availability

oMonitor performance and tune as needed to maintain acceptable performances

oWork with developers to troubleshoot Stored Procedure performances

oConfigure and maintain database backups to Azure cloud storage

oInstall and manage SSIS to support developers to create and deploy ETL packages

oInstall and manage SSRS to facilitate reporting including security

oApply DISA STIG controls on SQL Servers to maintain security compliances

oParticipate in knowledge sharing session to learn development and testing processes

oWhen time permits, help developers with modifying codes using GitHub, java, node.js and angular.js to meet requirements

oAssist Test Team in execution of functional and load tests using VS Test Manager

oGather information on industry best practices, test and implement

oAchieved certification as an ICAgile Certified Professional (ICP)

Mediware Information Systems, Reston, VA Dec 2013 – May 2017

DBA

Project: Harmony: Support Database infrastructure in a SAAS environment for long term health care solutions for our aging population related to Health and Human Services (HHS) and serving Federal/State/County/Local Agencies, Managed Care Organizations, Service Providers, Care Givers and Consumers.

oPerformed capacity planning for scalable database growth and performance

oInstalled, Configured and Maintained SQL Server 2005, 2008, 2008R2, 2012 and 2014

oMigrated databases to SQL Server using Backup/Restore and Detach/Attach

oMonitored and maintained 1000+ databases on 40+ SQL Severs located at three different data centers in clustered and standalone server environment

oWritten SQL Scripts to create Triggers, Functions and Stored Procedures

oWorked closely with Database Architect in Designing and Developing databases

oAssisted SQL Developers in Query Optimization

oModified and Maintained PowerShell scripts to move data faster and efficiently

oMaintained security by creating and monitoring user logins and groups with appropriate roles and assigning respective server or object level permissions

oEncrypted databases by enabling TDE to be compliant where needed

oWas responsible for all Database Backup and Disaster Recovery procedures

oImplemented and maintained ETL operations using SSIS and through SQL Agent jobs using T-SQL and stored procedures

oConfigured and maintained Database Mail

oCreated, maintained and monitored new/existing automation jobs

oCreated Maintenance Plans such as Rebuild Indexes, Update Stats, DBCC commands, etc. to keep databases optimized, consistent and maintain data integrity

oMonitored SQL Server using IDERA SQL Diagnostic Manager, Error log, Windows event logs, SQL Profiler, Perfmon, etc.

oMaintained Online Indexing and Database Consistency Checks using DBCC commands

oGenerated and execute queries against SQLdm Repository (IDERA) to resolve Lock, Block, Dead Locks, long running queries and slow running server

oAssisted in troubleshooting and resolving Report Builder issues including but not limited to user permissions and query modifications for reports

oCollected SQL Server health related matrix and generated reports to be discussed in monthly meetings with CTO and IT managers

oUsed third party tools such as RedGate SQL Backup Pro for backup/restore and IDERA SQL Diagnostic Manager for monitoring

oCo-ordinated with Off-Shore team regarding issues, responsibilities and daily operations

oMade sure RDBMS is compliant with FIPS 140-2 and HIPPA regulations

oGot trained in Microsoft Power BI and worked on some POC (Proof of Concept)

oPrioritized and distributed tasks based on workload and importance while managing multiple projects simultaneously and meet strict deadlines

oProvided technical assistance or trained technical staff and other database users on database access and database integration based on requirements and policies

Fannie Mae, Herndon, VA July 2012 – Feb 2013

Database Administrator

Project: CLM (Credit Loss Management) System.

oInstalled, Configured and Maintained SQL Server 2005, 2008 and 2008R2

oUpgraded SQL Server 2000 and 2005 to SQL Server 2008 and 2008R2

oMigrated Oracle 10g databases to SQL Server 2008R2 using SSMA for Oracle

oWrote T-SQL Programming to create Triggers, Functions and Stored Procedures

oAssisted Database Developers in Query Optimization

oImported and Exported data between SQL Server and other different sources

oUsed PowerShell to move data faster and efficiently

oMaintained security by creating and monitoring user logins and groups with appropriate roles and assigning respective server or object level permissions

oInvolved in Data modeling and database design using rules of database Normalization

oUsed Database Backup and Recovery procedures including point-in-time recovery

oConfigured and maintained database Replication, Log Shipping and Mirroring

oImplemented and maintained database using DTS and SSIS for ETL operations which exported data from different sources and import data into different destinations

oImplemented and maintained SQL Mail and Database Mail

oUsed ODBC/OLEDB drivers to run distributed queries between Linked/Remote servers

oScheduled and monitored new/existing automation jobs on production environment

oCreated Maintenance Plans to keep databases optimized and consistent

oMonitored SQL Server using Error log, Windows event logs, SQL Profiler, Perfmon, etc.

oMaintained Indexes and Database Consistency Checks using DBCC commands

oUsed SQL Profiler and Windows Performance Monitor tool to resolve Dead Locks, long running queries and slow running server issues

Census Bureau, Suitland, MD Nov 2009 – Jun 2012

Database Administrator

Project: 2010 Census Program Management and 2012 Economic Census.

oInstalled, configured, managed and applied Service Packs to SQL Server 2005 and 2008

oSuccessfully migrated databases from older to newer versions

oContributed designing and implementing database structures

oManaged different High Availability options (mirroring, log shipping, replication)

oCreated and managed various maintenance plans to optimize databases

oEnforced security mechanism and periodically generated reports and reviewed them

oDiagnosed problems using tools such as SQL Profiler and other native tools

oDesigned and implemented backup and recovery plans for Disaster Recovery Solutions

oParticipated in emergency recovery of databases as well as managed physical structures, space utilization and participated in disaster recovery testing

oWas responsible for creating, modifying and managing tables, indexes, constraints, views, Stored Procedures, Triggers, etc.

oInstalled, configured and administered SSRS including report security

oManaged ETL processes using Informatica and SQL Server native tools such as SSIS and Visual Studio

oMapped data based on different Schema designs and moved data to Data Warehouse for data analysis

oWorked with vendors and developers as needed to resolve issues

Bank of America, Wilmington, DE Aug 2007 – Oct 2009

Database Administrator

Project: BOADirect and BOA iCash.

oInvolved in installation, configuration and administration of SQL Server 2000 and 2005 including virtual environment that used VMware

oDesigned stored procedures and triggers to establish and enforce security, performance and optimization and to audit SQL Servers

oDesigned, tested and implemented migration plans from SQL Server 2000 to 2005

oExtensively involved in designing and implementing Backups and Recovery plans

oCollected SQL Server performance statistics that for monitoring and performance tuning

oApplied data partitioning to improve database performance

oCreated databases, tables, data objects, indexes, user logins, passwords and set privileges

oWrote SQL queries, Stored Procedures, Triggers and Functions

oImported and exported data using Import and Export Wizard

oMoved SQL Server objects from development to QA and QA to production instances

oImplemented data models, database designs, data access

oMaintained database integrity of all vendor and in house databases

oProactively monitored and optimized production databases for better performance

oResolved locking conflicts and resource utilization

oAdministered, maintained, developed and recommended policies and procedures for ensuring the security and integrity of the company’s databases and systems

oManaged and resolved trouble tickets and troubleshot database related issues and performed upgrades, conversions and deployments of databases

Education, Certifications, Training and Clearance

Education: BS in Finance (May 2007): George Mason University, Fairfax, Virginia

Certification: MCTS: Microsoft Certified Technology Specialist

MCITP: Microsoft Certified IT Professional

ICP: ICAgile Certified Professional

Training: Microsoft Power BI

Infrastructure and Architecture Bootcamp for Azure Gov

Clearance: Public Trust (Clearable for higher clearances)

Skills and Environment

Databases: SQL Server 2016/2012/2008R2/2008/2005, MS Access, Oracle 10g, MySQL

SQL Tools: Transact-SQL, Query Analyzer, Query Execution Plan

ETL Tools: SSIS, DTS, Visual Studio, Informatica

Reporting: SSRS (SQL Server Reporting Services/Server), SharePoint

Reporting: SSRS (SQL Server Reporting Services/Server), SharePoint

Warehousing: SSAS (SQL Server Analysis Services), Informatica

Data Modeling: Toad Data Modeler, ERWin, VISIO

Testing Tools: VS With Test Manager, Quality Center, DOORs, ClearQuest, ClearCase, QTP, LoadRunner, etc.

Environment: Transact-SQL, SQL, ASP, ASP.net, VB Script, JavaScript, HTML, etc.

Operating System: Windows Server 2008/2008 R2/2012/2016, Windows 7/10, VMware

Other Tools: TFS, Active Directory, SharePoint, RedGate, IDERA, GitHub, Node.js

Storage: SAN, RAID, SSD

Web/App Servers: IIS 5.0, 6.0, 6.5, 7.0, 7.5

Contact this candidate