Asif Hakim Email & Phone Number

Chantilly, Virginia, Us

Project: Maintain SQL Server infrastructure for a Government Agencyo Perform capacity planning for Development, Test, UAT, Staging and Production environments for scalable database growth and performanceo Install, configure and maintained SQL Server 2019o Recently upgraded the entire SQL Server infrastructure from SQL 2012 and 2014 to SQL Server 2019 including Azure and on-premise VM environmentso Track, download and applly Service Pack and Cumulative updates to SQL Serverso Support developers in designing and implementing database structureso Implement and maintain Always On Availability Groups for High Availability optiono Create and manage various maintenance plans to optimize databaseso Enforce security mechanism and periodically generated and reviewed reports that adheres to DISA STIGso Designe and implement backup and recovery plans for Disaster Recovery Solutions using native tools and AVAMAR backup solutiono Diagnose issues using tools such as SQL Profiler, System Monitor, DMV, etco Participate in emergency recovery of databases as well as managed physical structures, space utilization and participate in disaster recovery testingo Responsible for creating, modifying and managing tables, indexes, constraints, views, Stored Procedures, Triggers, etc.o Monitor database systems performance, capacity and availabilityo Work with Splunk developer/admin in creating dashboards and alerts to monitor SQL Serverso Install, configure and administer Power BI & SSRS including report securityo Train other members of the broader team on how to access SQL Server database and better manage SQL Server user accountso Work with vendors and developers as needed to resolve issues

Vienna, Virginia, Us

Project: Reserve Component Management System-Guard (RCMS-G) is a multifaceted electronic system providing automated data processing and information technology support to Chief Army National Guard. Strength Maintenance Management System (SMMS) is a CAC-authenticated management and reporting tool for the Army National Guard (ARNG) force’s readiness and strength at the unclassified level.o Lead a team of 8 DBAs to support Database infrastructure that includes SQL Server 2008R2 and 2014 instances, MainFrame, DataWarehouse, SSIS packages, etc.o Stand up new SQL Server environments on VM platformo Use VMware vSphere to access VMs at core level to modify resource allocationo Install, Configure and Maintain SQL Server 2014 and 2016 o Work with developers performance tuning, user permissions, database maintenance, etc. o Use Visual Studio 2008 and 2013 to troubleshoot failed SSIS packageso Configure SFTP Servers and Clients to facilitate automated file transfers between two internal systems and external entitieso Configure an manage HA and DR solutionso Assisted in recreating the environment after a catastrophic disastero Currently working to a migration plan related to data center moveo Make sure tasks are assigned to team members based on priority and due dateso Get in touch with end users while troubleshooting complicated issueso Coordinate and participate daily meetings with team member and/or managers to discuss work in progress, tackle new reqirement, brainstorm on new ideas to streamline existing processes, etc.o Provide daily reports and briefings to executives on updates related to ongoing disaster recovery and migration plans

Alexandria, Virginia, Us

Reserve Component Management System-Guard (RCMS-G): Electronic system providing automated data processing and information technology support to Chief Army National Guard. Strength Maintenance Management System (SMMS): CAC-authenticated management and reporting tool for the Army National Guard (ARNG) force’s readiness and strength at the unclassified level.o Lead DBA team to support Database infrastructure including SQL Server 2008, 2014 and 2016 instances, MainFrame, DataWarehouse, SSIS & DTS packages, etc.o Stand up new SQL Server environments on virtual platformo Use VMware vSphere to access VMs at core level to modify resource allocationo Install, Configure and Maintain SQL Server 2014 and 2016 o Regularly work on data processing, performance tuning, user permissions, database maintenance, etc. o Monitor and maintain adequate disk space for files and database growtho Periodically restore databases from DR system (IBM Tivoli, NetBackup and native SQL Server backups) to ensure backups are good and restorableo Use Visual Studio 2008, 2013 and 2015 to troubleshoot failed SSIS packageso Configure SFTP Servers and Clients to facilitate automated file transfers between internal systems and external entitieso Configure and manage database mirroring, snapshots. linked servers, etc. for data availability on differet serverso Brought the RDBMS system back fom a catastrophic disastero Single handedly working on migrating entire database system to a new data centero Make sure tasks are assigned to team members based on priority and due dateso Get in touch with end users (as required) while troubleshooting complicated issueso Coordinate and participate daily in meetings with team member and/or managers to discuss work in progress, tackle new reqirement, brainstorm on new ideas to streamline existing processes, etc.o Provide daily reports and briefings to executives on updates related to ongoing disaster recovery, data processing and migration plans

Arlington, Va, Us

Project: As an infrastructure team member, configure and manage database infrastructure on Microsoft Azure IAAS platform to support a US Government project. o Stand up new SQL Server environments on Azure IAAS platformo Install, Configure and Maintain SQL Server 2012 and 2016 o Work with developers and other vendors to facilitate database creation, user permissions and database maintenance o Access Active Directory (AD) to manage Domain user permissionso Design and implement maintenance plans as requiredo Create and manage Agent Jobs to support application processeso Configure and maintain AlwaysON Availability Groups for High Availabilityo Monitor performance and tune as needed to maintain acceptable performanceso Work with developers to troubleshoot Stored Procedure performanceso Configure and maintain database backups to Azure cloud storageo Install and manage SSIS to support developers to create and deploy ETL packageso Install and manage SSRS to facilitate reporting including securityo Apply DISA STIG controls on SQL Servers to maintain security complianceso Participate in knowledge sharing session to learn development and testing processeso When time permits, help developers with modifying codes using GitHub, java, node.js and angular.js to meet requirementso Assist Test Team in execution of functional and load tests using VS Test Managero Gather information on industry best practices, test and implement o Achieved certification as an ICAgile Certified Professional (ICP)

Overland Park, Ks, Us

Supported Database infrastructure in a SAAS environment for long term health care solutions for our aging population related to Health and Human Services (HHS).o Installed, Configured and Maintained SQL Server 2005, 2008, 2008R2, 2012 and 2014o Migrated databases to SQL Server using Backup/Restore and Detach/Attacho Monitored and maintained 1000+ databases on 40+ SQL Severs located at three different data centers in clustered and standalone server environmento Writen SQL Scripts to create Triggers, Functions and Stored Procedureso Worked closely with Database Architect in Designing and Developing databaseso Assisted SQL Developers in Query Optimizationo Modifed and Maintained PowerShell scripts to move data faster and efficientlyo Maintained security by creating and monitoring user logins and groups with appropriate roles and assigning respective server or object level permissionso Encrypted databases by enabling TDE to be compliant where needed o Was responsible for all Database Backup and Disaster Recovery procedureso Implemented and maintained ETL operations using SSIS and through SQL Agent jobs using T-SQL and stored procedures o Configured and maintained Database Mailo Created, maintained and monitored new/existing automation jobs o Created Maintenance Plans such as Rebuild Indexes, Update Stats, DBCC commands, etc. to keep databases optimized, consistent and maintain data integrityo Monitored SQL Server using IDERA SQL Diagnostic Manager, Error log, Windows event logs, SQL Profiler, Perfmon, etc. o Maintained Online Indexing and Database Consistency Checks using DBCC commandso Generated and execute queries against SQLdm Repository (IDERA) to resolve Lock, Block, Dead Locks, long running queries and slow running servero Managed Off-Shore team regarding issues, responsibilities and daily operations

Washington, District Of Columbia, Us

Project (Contract): CLM (Credit Loss Management) System.o Installed, Configured and Maintained SQL Server 2005, 2008 and 2008R2 o Upgraded SQL Server 2000 and 2005 to SQL Server 2008 and 2008R2 o Migrated Oracle 10g databases to SQL Server 2008R2 using SSMA for Oracle o Wrote T-SQL Scripts to create Triggers, Functions and Stored Procedures o Assisted Database Developers in Query Optimization o Imported and Exported data between SQL Server and other different sources o Used PowerShell to move data faster and efficiently o Maintained security by creating and monitoring user logins and groups with appropriate roles and assigning respective server or object level permissions o Involved in Data modeling and database design using rules of database Normalization o Used Database Backup and Disaster Recovery procedures including point-in-time recovery o Configured and maintained database Replication, Log Shipping and Mirroring o Implement and maintain database using DTS and SSIS for ETL operations which export data from multiple sources and import data into multiple destinations o Implemented and maintained SQL Mail and Database Mail o Used ODBC/OLEDB drivers to run distributed queries between Linked/Remote servers o Scheduled and monitored new/existing automation jobs on production environment o Created Maintenance Plans to keep databases optimized and consistent o Monitored SQL Server using Error log, Windows event logs, SQL Profiler, Perfmon, etc. o Maintained Online Indexing and Database Consistency Checks using DBCC commands o Used SQL Profiler and Windows Performance Monitor tool to resolve Dead Locks, long running queries and slow running server o Worked independently on multiple projects simultaneously and meet strict deadlines

Washington, Dc, Us

Project (Contract): 2010 Census Program Management and 2012 Economic Census.o Performed capacity planning for Development, QA, Staging and Production environments for scalable database growth and performanceo Installed, configured and maintained SQL Server 2005 and 2008o Successfully migrated SQL Server 2000 databases to SQL Server 2005o Applied Service Pack on SQL Server 2000 and 2005o Supported developers in designing and implementing database structureso Implemented and maintained mirroring and log shipping for High Availability optiono Created and managed various maintenance plans to optimize databaseso Enforced security mechanism and periodically generated and reviewed reportso Designed and implemented backup and recovery plans for Disaster Recovery Solutionso Diagnosed problems using tools such as SQL Profiler and System Monitoro Participated in emergency recovery of databases as well as managed physical structures, space utilization and participated in disaster recovery testingo Was responsible for creating, modifying and managing tables, indexes, constraints, views, Stored Procedures, Triggers, etc.o Monitored database systems performance, capacity and availabilityo Installed, configured and administered SSRS including report securityo Trained members of the Network Access team to handle SQL Server account managemento Worked with vendors and developers as needed to resolve issues