Mark Smith Email & Phone Number

Reston, Va

Alexandria, Va

• Work with ‘agile’ teams to create DB2 tables and perform data load from DATACOM extracts and copybook formats. • Work with ‘agile’ teams to review, test, analyze, and recommend improvements of SQL code for Oracle application schemas.• Work with ‘agile’ teams to process database change requests for Oracle and DB2 environments, review and recommend changes to data models.• Reviewed developer code for client standards compliance.• Work with team members to define database portion of DevOPS plan for CSPD; reviewed all other portions of CSPD DevOPS documentation.• Work with teams to standardize coding and database access conventions.• Provide support as member of CSPD Infrastructure and Architecture & Engineering planning team. • Reviewed and noted deficiencies in existing continuity of operations, particularly the absence of failover contingency or DR site. • Reviewed and noted documentation for existing “ACE” database system related to system access points.• Participate in meetings with CSPD management to plan migration efforts to unify agile team ‘playbooks’ including the “Data Naming Standards and Modeling Guidelines” requirements for CSPD. • Developed spreadsheets to identify agile team interactions with database(s) and servers in their respective environments.• Perform required support and administrative duties on CSPD development database (12.1.0.2).• Participated in webinars of AWS capabilities relevant to potential implementation within CSPD.• Completed AWS Technical Professional online training course and Certification.

Provided production and QA support as Oracle DBA on Windows and HP-UX Unix systems within the Web Infrastructure environment. • Created new database instances, migrating instances from server/platform to new server/platform.• Monitored performance and instance tuning.• Configured RMAN to perform backups, tested random restore and recoveries of database instances.• Provided upgrade and patching support of all database systems, with all production Oracle databases currently at v11.2.0.2.x on both HPUX and Windows servers. • Performed maintenance and upgrades of application schema objects and data.• Installed, configured, and maintained Oracle Enterprise Manager 10.2 with patch revision to level 10.2.0.5.• Installed OEM agents on all database servers allowing active monitoring of all production databases within the Web Infrastructure environment. • Initiated migration of OEM to v12c on HPUX from Windows. • Installed, configured, and managed Oracle Application Express and BI Publisher servers and applications.• Setup scripts to implement CIS benchmarks and DISA/DOD STIG requirements noting those which broke applications and setup scripts to enhance auditing capabilities. • Setup UNIX shell scripts to implement database tasks and enhance existing tasks to provide runtime performance status via email to DBA staff and managers. • Updated and enhanced DB2 extract scripts for data obtained from DOJ DB2 system. • Provided ongoing support for Panorama (AppInternals Xpert) and IT/GURU-ACE (AppTransaction Xpert) tool sets from OpNet/Riverbed. Utilized these tools to identify possible application errors or bottlenecks and provided analysis results to operations management and personnel.• Provided SQLServer database administration support for several implementations of SQLServer 2005 and 2008. Migrated databases from SQLServer 2000 to 2005 or 2008 hosts. Assisted with production application support in new SQL 2012 farm environment.

Fairfax, Va

In-house Systems Consultant/Database Specialist: Provided ongoing Oracle 10g/11g and SQLServer DBA support for internal corporate and client application development and assist in the hardware and software setup, upgrades, and configuration of corporate network infrastructure. Responsible for installation, configuration, and management Oracle databases since v6 on OS/2 to 9i, 10g, and 11g instances on Linux. Configured backups, exports, and migrations of development schemas, setup schema environments duplicating client systems, provided SQL coding and debugging support for developers. Installed and maintained Linux systems using RedHat v7.2 and SuSE Linux Enterprise Server, SLES8 & SLES9. Provided network and systems support, installing physical servers, installing OS environments, patch management, and communications troubleshooting.Drug Enforcement Agency (DEA); 01/2005 – 06/2009: Provided Windows and HP-UX Unix system and network engineering support including hardware and operating system installation and configuration, and management for 50+ servers. Setup Fiber Ethernet connectivity and disk storage systems for four HP rp7400s supporting multiple Oracle database systems with terabyte storage requirements. Administered and maintained a prototype VMWare ESX server environment hosting Windows 2000/2003 servers. As an HPUX Unix administrator, installed the operating system, individual patches, and periodic Quality Packs, configured network interfaces, user maintenance, and implemented system security rules based upon the CIS benchmark set. Utilized Microsoft’s W2K3 server clustering capabilities for application performance enhancement and web site failure prevention. Configured a NAS capable of supporting access via NTFS/Windows shares, NFS shared, and iSCSI LUNs. Migrated web sites from an old Apache 1.3.12 configuration and restructured with Apache 1.3.31 and v2.