Nana Aboagye Asare

Phone 202-***-**** • Email ac7dq1@r.postjobfree.com

Objective:

To obtain a SQL Server DBA position where I can use my problem-solving skills to help leverage company investment

Clearance: Active Secret.

Professional Summary

Over 9 years total IT experience in Oracle, SQL Server, other RDBMS, and Windows Systems Administration, Design & Development, Systems Architecture and Infrastructure.

Installed, upgraded, and administered SQL Servers 2014/2008 R2/2005/2000 in virtual and physical servers in development, Test, and Production environment.

Expert in configuring cluster environments: SQL Server 2008 R2/2008/2005 Active/Active and Active/Passive cluster on Windows Server platforms. (Windows 2012, Win2k8R2, Win2k3).

Experienced in performance Monitoring and Tuning, Query Optimization via T-SQL, DMVs, System Monitor (Perfmon), DBCC Utilities, Database Tuning Advisor/Index Tuning Wizard, and SQL Profiler.

Strong knowledge of oracle data-dictionary, configuration of Oracle Enterprise Manager (Oracle Grid Control) tools for monitoring, performance enhancement and debugging

Implement ASM cluster on Oracle RAC11g (Active/Active & Active/Passive) on Multi Node Cluster.

Experience with database backup, restore, and disaster recovery procedures

Experience in Active Data guard (11g and 12c) setup and configuration.

Analyzed and documented the root causes of performance issues in development, test, and production environments.

Developed and documented database migration strategies, ETL using SQL SSIS/DTS, Import/Export and BCP utilities

Supports RDBMS databases in a High Availability environment.

Strong understanding and use of RMAN for backup and disaster recovery

Results-driven DBA with skills in team building and problem-solving with an established reputation for effectively working with diverse groups of people and adaptability to changing environments and new software version releases.

Experience as On-Call 24x7 production DBA support, system administrator; handle business service requests using Helpdesk Request Management.

Experience in full life cycle projects from analysis phase to production support.

Education

University of Maryland University College, College Park, MD

MS Information Technology- in Information Assurance 2010

George Mason University, Fairfax, VA 2004

B.S., Information Technology: Systems and Network Security

Training and Certification

oMicrosoft SharePoint Server 2010 Microsoft Corporation.

oSQL Server 2008 R2/2012 Microsoft Corporation

oSQL Server 2014 Learning Tree

oMicrosoft Certified IT Professional –Database Administration (MCITP – SQL Server 2008 R2)

oMicrosoft Certified IT Professional –Database Administration (MCITP – SQL Server 2014)

oOracle 11g/2c: New Features for Administrators ORACLE UNIVERSITY

oOracle Database 11g: Administration Workshop I & II ORACLE UNIVERSITY

oOracle Fusion Middleware (WebLogic, BI, OBIEE, Apache) ORACLE UNIVERSITY

oOracle E-Business Suites R12 ORACLE UNIVERSITY

oOracle 11g: RAC and Grid Infrastructure Administration R2 ORACLE UNIVERSITY

oOracle Real Application Cluster Administrator Certified Expert – 11g

oCompTIA – Security +

oRHCSS - Red Hat Certified Security Specialist - /training/etc

oOracle Certified Professional (OCP)-11g

oOracle Certified Associate (OCA)

oOracle Real Application Cluster Administrator Certified Expert – 10g

Technical Skills

Windows Server 2008R2 \2012, SharePoint 2010, PostgreSQL, Oracle Database Administration, Linux Admin, Amazon Web Services (AWS), TOAD, Active Directory and MySQL administration. Chef, Puppet, Python, AWS, Azure, MongoDB, SSRS, SSIS, SSMS.

Professional Experience

Digital Management Inc Remote 9/ 2016 to Present

Customer: Defense Manpower Data Center and Human Resource Information (DMDC/DHRA/FAFA)

Snr. Database Administrator

Plan, install, build, manage, support, configure and test Database server infrastructure components and connectivity.

Deploy new SQL Server environments in Production, QA and UAT environments.

Maintain server security in compliance with Department of Defense (DoD) and supporting vendor requirements.

Installed and configured 4 node SQL Server 2014 Ent cluster between 2 data centers with Always-On Availability Groups configured for replication between data centers.

Manages multiple nodes of Clustered and Stand-alone SQL server 2014/2012/2008 R2

Monitor and troubleshoot backups, scheduled jobs, and monitor systems and processes for performance related issues.

Provides support in planned DR solution testing between multiple Data Centers

Interface directly with end users and other IT groups to ensure complete resolution of server issues reported through the Help Desk tracking system.

Perform vulnerability and remediation for all SQL Server database server hosted across multiple data centers.

Participates in meetings impacting databases physical architectural design.

Apply Microsoft Security Patches.

Utilized Microsoft SQL Server Integration Services (SSIS) platform (ETL) for extraction of data, transformation of data, and loading the data into destination/ data warehousing.

Perform threat modeling, static application security testing, code reviews, and secure design reviews for high risk applications

Participates in Scrum teams in support of Agile projects; end-to-end support for build, deployment, and operational activities.

SRA International Inc. Remote February 2009 to 09/2016

Customer: U.S Dept. of Health and Human Services/National Cancer Institute

Senior Database Administrator

Provides Oracle and SQL Server database design, architectural and infrastructure solutions to National Cancer Institute Center for Bioinformatics (NIH/NCI-CBIIT)

Lead in architecture, design and maintenance of data center infrastructure and customer environments.

Implemented efficient Disaster Recovery Strategies and High availability include Always On Availability Groups, Replication (Snapshot, Transactional and merge).

Installing and configuring MS SQL Server 2005\2008R2 fail-over Cluster and its applicable Service Packs.

Setup, configure, administer and maintained SQL Server databases (Prod, Stage, Test and Dev Environment) for various groups such as Developers, QA and DA users and ensured database availability in a 24X7 environment.

Implement and manage MS SQL Cluster (Active/Passive & Active/Active), Multi Node Cluster up to 8 Node

Upgrade SQL Server database environment from SQL Server 2000 -> 2005-> 2008->2012>2014

Deployed SSIS projects. Schemas and configured Report Server to generate reports through SSRS.

Scheduling and managing SQL Server database backup jobs.

Extract, Transform and Load millions of clinical data into ETL database using SSIS.

Monitoring Oracle and SQL Server jobs performance and impact on normal operations.

Conducted root cause and analysis for database incidents and problems.

Developing and implementing DBA maintenance plan

Participated in meetings impacting databases physical architectural design.

Assist web Application developers with database related issues

Installed and Configured Oracle 10g/11g and 12c software on Linux.

Maintain Relational Database infrastructure, software, upgrades, and patches.

Monitor and provide response for all database systems.

Use RMAN duplicate command to clone/refresh development database from production.

Upgraded several databases from Oracle 10.2.0.5 to 11gR2 to 12c

UNISYS CORP, Reston VA February 2008 – January 2009

Customer: TSA (U.S Dept. of Homeland Security)

Database Administrator

Responsibilities:

Provided database design, technical and infrastructure solutions to Transportation Security Administration (TSA-ITIP).

Implemented ASM cluster on Oracle RAC 10g (Active/Active & Active/Passive) on 4 node cluster.

Maintains Oracle Application Server 10g with Oracle E-Business Suite Release 11i.

Hardening Oracle environments per TSA database Security auditing recommendations.

Use AD utilities including adpatch, adding, autoconfig, etc for maintaining Oracle 11i Apps.

Apply CPU Patches to Oracle E-Business Suite Databases and Applications.

Responsible for working with application developers, systems administrators and management to ensure that any new product usage or release upgrade takes place with minimal impact on test and production environments.

Support and managed databases in High Availability environments.

Migration of several databases (size 500GB -7.2TB) and Applications to new servers using RMAN.

Evaluates new releases of Oracle and its tools, and third party products to ensure that the site is running the products that are most appropriate.

J2EE application support and support

Define Database Backup, Recovery and Disaster Recovery procedures using RMAN, flashback.

MICROSTRATEGY, Mclean, VA February 2006 to January 2008

DBA/Systems Engineer

Responsibilities:

Responsibilities were to perform daily, weekly, and monthly checks of all databases.

Ensure that daily backup using the export utility and monitoring the CRON jobs to ensure backups are good for restore and recovery.

Provided first level support for helpdesk work tickets and manage all calls logged regarding the databases.

Installed and Upgraded Oracle 9.2.x to 10G (10.2.0.2) on new LINUX Red Hat Servers.

Setup and maintain Oracle 11g Data Guard (Logical and Physical standby) between two data Centers as part of disaster-Recovery solutions.

Assisted Sr. DBAs to develop capacity and performance metrics as well as maintain, analyze, and report on a scheduled periodic basis to management on development progress.

Created Oracle instances with appropriate initialization parameters.

Primary on call support duties for a week every month, which include monitoring mission-critical servers.

Deploy software and security patches using Windows Update Server

Configured and support MS SQL Server 2000/2005 databases in a clustered environment.

Hardware/Software:

SQL Server 2000/2005/2008/2012,2014/2016, ORACLE 12c/11g/10g/9i, SQL*PLUS, SQL*Loader, Developer 2000/6i, SQL, PL/SQL, UNIX, Linux, TOAD, ERWIN, DBArtisan, Data Guard, Oracle Grid Control, PLSQL, OEM, Windows 2012/2008R2/ 2003/ XP/NT, Unix Shell scripting, XML, HTML, Java, VB Script, and MS office.

Tools : OEM Cloud Control 12C, OEM Grid Control 11g and 10g, IDM, OAM, SSO/OID, SOA.

Cloud Technology: AWS and Microsoft Azure

Contact this candidate