VIC MOHAMMED

***** ***** *** ** ****: 301-***-****

Burtonsville, MD 20866 E-mail: adm2ut@r.postjobfree.com

SUMMARY:

SQL Server DBA tasks with 2 years’ experience in an AWS role, including installation and configuration, security management, space management, extraction, transformation and loading (ELT), performance monitoring and tuning, backup and restore, maintaining indexes, design and development of databases.

Experience with Microsoft SQL Server 6.5, 7.0, 2000, 2005, 2008R2, 2012, 2014, 2016 performing data acquisition, analysis and design, DBMS optimization and recovery strategies.

Experience developing scripts to manage and report on space utilization, database consistency, update statistics and security audits.

Experience developing and programming applications using SQL Server as backend database and Visual Basic, ASP, VBScript and MS Access for development of applications.

Managed large databases (50+GB) in an active passive clustered, Log Shipping and Always on Availability group to ensure high availability (HA) and Disaster Recovery (DR) options.

Experience using bulk load procedures including creating and maintaining Data Transformation Services (DTS) packages and SQL Server Integration Services (SSIS) to load, unload, clean, and transform data from multiple environments.

Extensive experience with Transact SQL creating stored procedures, triggers, optimizing code and creating maintenance scripts.

Created multiple logical and physical database designs using rule of normalization,

De-normalization and sound design practices.

Performed network management tasks on Windows NT 4 Server based and Windows 2000 and 2003 Server based networks.

PROFESSIONAL EXPERIENCE

United States Citizenship and Immigration Services (USCIS) / Mantech Corporation, Bethesda, MD

Lead Senior Enterprise DBA 2008 to Present

Providing highly available database and application infrastructure support according to Business Continuity requirements using Mirroring, Always on Availability Group, SQL clustering and Log Shipping.

Work in an Agile environment to design, create and maintain Microsoft SQL Server.

Lead migration effort of SQL Servers 2000 and 2005 to SQL 2008 R2 from Physical to Virtual ranging in size from 500G to 10 Terabyte of data from one Data Center to another.

Responsible for day to day Production and Staging support activities for SQL Servers 2005, 2008R2 and 2012, 2014, 2016, and MySQL Databases.

Responsible for updating database systems by reviewing, planning, testing, installing database security patches, service packs and security hardening.

Recognize areas of process improvement; initiate and implement approved changes, and document policies, processes, and procedures.

Installed and Administered System Center Operations Manager (SCOM) and New Relic to monitor the health and performance of all Server SQL instances.

Responsible for performing root cause analysis for all aspects of database and recommending solutions to minimize future incidents.

Resolved SQL Server vulnerabilities from DB Protect security scan.

Provide subject matter expertise as needed, including estimating levels of effort and troubleshooting.

Installed and configured ArcSight on SQL Servers to audit logs.

MedImmune Inc, Gaitherburg, MD

Senior System Analyst / Senior SQL Server DBA 2006 to 2008

Responsible for Sarbanes-Oxley (SOX) compliance of database backup and recovery.

Created DBA procedures, policies and SOPs for MedImmune to document disaster recovery, maintenance schedules and other database tasks.

Responsible for day-to-day activities, database mirroring, SSIS packages, replication and LiteSpeed log-shipping using SQL Server 2000 and 2005.

Monitor and resolved issues on SQL Server using Microsoft Operation Manager (MOM).

Nextel / Sagex Inc, Herndon, VA

Senior Production Support SQL Server/Oracle DBA (6 months contract) 2005 to 2006

Responsible for production support activities of large-scale terabyte size databases.

Created a number of jobs to import and export data from SQL Server using DTS, allowing COTS applications to interface with other systems.

Manage small projects at customer sites involving multiple consultants.

Provide analysis and design consulting services to clients using specialty products based on business requirements which include application maintenance, development, deployment, and problem resolution.

United States Postal Inspection Services / Northrop Grumman, Arlington, VA

Lead SQL Server DBA 2001 to 2005

Lead SQL Server Database Administrator for development, testing and production database

in 24 x 7 environments.

Responsible for day to day activities for 23 SQL Servers and 79 databases in a cluster environment including security management, storage space management, backups and restores.

Implemented & maintained replication and log-shipping between Dulles and United States Postal Inspection Service (USPIS) Data Center in Rosslyn for High Availability and Disaster recovery.

Assisted and created normalized logical data model for database projects and implement the physical design into SQL Server 2000 production server.

Developed database notebook and documents for standard operating procedures including backup and recovery plans to ensure that mission critical applications can be supported.

Upgrade SQL Servers from SQL 7 to SQL 2000.

Implemented, planned, & stimulated drills for disaster recovery, backups, restoration of database between Dulles and United States Postal Inspection Service (USPIS) Data Center in Rosslyn, VA

Created DTS packages/code SQL stored procedures for electronic transfer & processing of data.

Verizon / Ajilon Consulting Services, Baltimore, MD

SQL Server DBA 2000 to 2001

Maintained SQL Server servers, versions 6.5, 7, and 2000, some in clustered environments including security management, storage space management, backups and restores.

Used NetIQ Recovery Manager (Lumigent Log Explorer) to review transaction logs and rollback unwanted transactions.

Documented SQL Server systems and applications.

Designed and implemented several Active Server Page based web pages using VBScript and JavaScript to access SQL Server data.

Datasource, Inc., Silver Spring, MD

SQL Server DBA / Systems Analyst 1999 to 2000

Assisted in the database design and modeling of an Enterprise system, N-Tier business applications in Windows NT environments using Visual Basic 6.0, Microsoft Transaction Server (MTS), Microsoft SQL-Server 7.0, Component Object Model (COM) and StarTeam.

Responsible for typical DBA duties - logical and physical database design, performance tuning, optimization, added/modified permissions and roles, backup/restore, ensured optimal performance, created/updated database objects, created indexes, regression testing & installation.

Team Lead for data migration using scripts with business rules to loads the DB with data and validation of the data in the existing schema using SQL 7 & 2000.

Team Lead for the extraction, transformation and loading (ETL) of the data into a SQL Server 7 & 2000 relational DB from a flat DB3 DB using the Data Transformation Services (DTS).

System Support Alternatives, Inc., Laurel, MD

Programmer / Systems Analyst 1998 to 1999

Debugged and enhancements of RDBMS applications using VB 5.0, Source Safe, Crystal Reports, Forehelp, InstallShield, and Access 97 in an NT environment.

Represent SSA, Inc. at the field site location in Kansas City during field support, software installation and modification, demos and coordinating with end users during the testing phase of the FARMS application for 2,500 users.

Designed, developed, debugged and modified client-server applications utilizing VB 5.0 with DAO, SQL 6.5, and third-party tools Source Safe, Crystal Reports, Sheridan Data Widgets, Forehelp, Installshied and Cresent tools on a NT platform.

Utilized the Bulk Copy Program (bcp) to import and export data from the SQL Server tables and formatting data using various stored procedures and views.

Responsible for analyzing and transferring data in ASCII file format to various sites using the File Transfer Program (FTP).

PROFESSIONAL TRAINING

Information Technology Infrastructure Library (ITIL) Certificate.

Azure Administration Training in progress.

EDUCATION

Bachelor of Science degree, Aerospace Science with emphasis in Information Systems Management

Metropolitan State College of Denver

STATUS

Active Public Trust Clearance

REFERENCES UPON REQUEST

Contact this candidate