Contractor Lead Resume
Aberdeen, MD
SUMMARY:
Senior and experienced systems, security and database engineer with an incredibly large and wide hands on experience set.
TECHNICAL SKILLS:
Development Languages: PL/SQL, Transact - SQL (Microsoft and Sybase), Java, Visual Basic (3.0), Paradox ObjectPal, Progress
Databases: Oracle 7 thru 12g, Sybase 10, SQL Server (2000-2014), MySQL, MS Access All Versions, Paradox All Versions, ObjectPal, PostgresSQL, Derby, Progress v 5,7,8
Products / Tools / Frameworks: NetExpert, NetCool, Tivoli Framework Products, Tivoli Storage Manager (AIX/Oracle), Quest Toad for Oracle/ SQL Server/MySQL, Erwin, SQL Navigator, Oracle Discover, Oracle SQL Developer, Novell 2.x-4.x, CygwinMicrosoft System Update Services/ Windows System Update Services, BMC Remedy, Cisco CiscoWorksVeritas HA for Solaris, Symantec/Veritas Netbackup, InfoVista, Citrix, VMware 4.x 5.x,Vsphere 4.x 5.x, Apache Hadoop (Cloudera and Hortonworks)
Hardware: Linux, IBM xSeries, xSeries Intel (x86, x64), Sun (Enterprise, E Class, V Class Ultra, DEC Alpha, HP (V, KD 9000 Classes), HP G5-G9 Intel/86 Servers, AMD and Intel (i3/i5/i7/Xeon) based servers, Dell R Series Enterprise Servers
Software: AIX 4-5.3, Solaris 2.6 - 11, HP-UX 9, 10-11.X, SCO Unix/Xenix, Linux, BSD, Suse Linux, Red Hat Linux, CentosOracle Enterprise Linux (OEL/ULN), Microsoft/IBM (DOS 1.0 - Windows Server 2012/ Windows 8)
WORK EXPERIENCE:
Contractor Lead
Confidential, Aberdeen, MD
Responsibilities:
- Primary architect and engineer for migration of ESXi 3.5 and 4.0 servers to a VCenter 5.5/VSphere 5.5 environment supporting over 100 Red Hat, Windows 2008R2 and Oracle Linux servers. Provided primary support for migration to Windows 2012 from Windows 2008 for .Net, SQL Server 2012, SharePoint 2012 and other Windows based applications.
- Oracle Database and Fusion Middleware SME: Installed and supported Oracle 11GR2 Fusion Middleware environment consisting of WebLogic, Oracle Access Manager, Oracle Identity Manager, Oracle Webgates and Oracle Forms and Reports for critical reporting applications for US Army Installation Management Command (IMCOM).
- Trained in McAfee Confidential (now Confidential ) modules mandated by Army policy: primary engineer for policies implemented on all systems in this environment.
- Trained in Confidential (Nessus Security Center) for compliance scanning and mitigation. Reviewed IAVM announcements and utilized SCAP tools and manual configuration to achieve Confidential compliance for systems.
IT and Business Consultant
Confidential, Halethorpe, MD
Responsibilities:
- While in next career path job search, I have and expanded side contract work with private clients, enhanced my Confidential to continue his and preserve his hands on IT skills (VMware Workstation/Esx5.1 environment) with fully functional virtual servers which include a Hortonworks Hadoop three node cluster, an Oracle 11G RAC configuration, numerous Windows 2008/2012 test environments and multiple configuration profiles.
- This environment is particularly engineered to allow for fast deployment of Oracle Enterprise Linux 64 bit and Centos base operating systems, Oracle product based configurations and the ability to fast track new products for hands on installation, documentation and incremental upgrade/patches to maintain hands on productivity.
- I document my internal environment in the same fashion as I would in a larger enterprise environment.
- I have deployed, as specific consulting projects have come up, this infrastructure to model projected systems and database architectures, especially when said clients did not have or allow sanctioned access to their nonproduction environments.
Senior Systems and Data Admin
Confidential, Herndon, VA
Responsibilities:
- Installed and maintained a 5 node Cloudera Hadoop Cluster for the evaluation of Big Data technology.
- Supported the upgrade of Microsoft SharePoint and Microsoft Active Directory technologies.
- Utilized Derby, MySQL and Oracle databases with Cloudera and Hortonworks Hadoop technologies
Senior Database and Systems Subject Matter Expert
Confidential, Washington, DC
Responsibilities:
- Provided evaluation and reverse - engineering support for PL/SQL based procedures, functions, triggers, and sequences in COTS/Oracle based applications (Onbase/WebTA).
- Migrated from one Windows 2008 server with 10GR2 database to three Windows 2008 servers, creating and data migration of an Oracle 11GR2 Windows 2008 server, utilizing tablespace based Transparent Data Encryption to protect sensitive personal information contained in the database.
- Assessed Epassport application issues that arose during migration from SQL Server to Oracle.
- Provided database administration and initial Epassport gap assessment, including implementation of coldbackup strategies, Recovery Manager (RMAN) configuration and utilization of hot backups in conjunction with a cold backup schedule.
- Provided SQL Server data and database support for proprietary accounting application
- Provided full life cycle support for hardware and software requirements for all Oracle based COTS and proprietary applications within GPO: This included assessments of virtual (VMware) versus physical server deployments, utilization of NAS (Network Appliance) based storage versus local storage, and assessment of the possible utilization of the Oracle Database Appliance (ODA) for additional availability, performance and server consolidation goals.
- Provided systems and database architecture support for the migration and upgrade of the Probe Scanner application deployed throughout GPO locations. Upgraded this application from Windows NT and Oracle 8i to Windows 2003 and Oracle 10GR2.
- Developed scripts and tools to allow the movement of backup files to Network Attached Storage (NAS) storage to prevent local file systems from causing outages. This reduced regular disk drive space issues that had been causing the databases to shut down and application to lose data.
- Developed Netbackup/RMAN based scripts that scheduled backups for all production environments. This facilitated required offsite storage of data, and offsite data/database recovery capabilities, reducing resources and downtime required to provide regular backups. After implementation, overall availability increased to greater than 95%.
- Installed Oracle Grid Control 10g and 11g in all environments to monitor database and server-based issues and alert IT and database management staff managers of serious issues regarding application and database availability. This reduced off-hour incident response time from over 8 hours to 2 hours.
- Created a manual recovery strategy for a key ePassport database failure due to a disk space, reducing recovery downtime from 36 hours to 10 hours, with no loss of application data inserted into the backend database. This reduced revenue loss to 1/3 of the predicted recovery time for the database.
- Provided CM team support for WebTA (COTS/Oracle based application) utilizing Oracle Rational ClearCase/ClearQuest products for change and software configuration management.
- Provided systems administration/ OS configuration support for the creation of VMware templates for RedHat version 5 for Oracle database deployment (using Oracle-validated package), Windows 2008 for Oracle Database deployment.
- Provided disaster recovery and data recovery for an internal Intrusion Detection System (IDS) based on
Senior Database SME and Security Incident Response Engineer
Confidential
Responsibilities:
- Supported the USFS Oracle Databases that supported the 10 Regional Office based Tivoli Inventory servers (Oracle 8i on IBM AIX Servers).
- Acted as the Co-architect/Team Lead for the upgrade from Oracle 8i to Oracle 9i for all ten regional and onedata store database supporting the Tivoli Inventory product
- Assisted in the installation and testing of Tivoli Storage Manager, for the proper Recovery Manager (RMAN)backups of these critical databases off of all regional servers
- Utilized a basic waterfall SDLC process for the testing, documentation and deployment of all configuration changes in databases, reporting systems, and application software that were used
- The environment and technologies in use included: Oracle 8i, Oracle 9i, SQL, Tivoli, Cold Fusion, IBM AIXServers
Data Migration Consultant
Confidential
Responsibilities:
- Provided data quality and data reporting support for the data migration from mainframe legacy systems toan ARIBA application based system (PASS - Procurement Automated Support System). This project followed a rapid prototype methodology.
- Produced reports in COGNOS and Oracle SQL*Plus for data migration validation for integrity
- Created and modified tickets regarding migration tasks and application development activities that were verified or modified based on data validity reporting.
- The environment and technologies in use included: Oracle, ARIBA, COGNOS, MS Access, Excel, WindowsXP, Windows 2000 Server
Senior Peregrine Developer/Administrator
Confidential
Responsibilities:
- Planned and deployed a database migration from the Peregrine proprietary default database to Oracle 9icentral hosted by the agencies Oracle Database Management Group
- Acted as primary application administrator for all three environments for Peregrine ServiceCenter
- Improved availability of production environment
- Schema maintenance and development for the Call Center Consolidation Project.
- The environment and technologies in use included: Oracle 9i, Peregrine, ServiceCenter 5.04.0
Oracle DBA/Developer/Infrastructure Support Engineer
Confidential
Responsibilities:
- Provided data maintenance and data migration support in a planned upgrade from a Cold Fusion/Oracle based platform to SQL Server and .Net application. This project followed a waterfall methodology.
- Provided application and data management of the original core system and creating an interim system to parallel the production system
- Provided data management support while the original system was kept in production
- Maintained a high service level for systems and services provisioning for the NMCI while application andengineering issues were being resolved with the .Net/SQL Server contractor
- Supported Confidential staff DBAs for production exports and backups for production Oracle database
- The environment and technologies in use included: Oracle 8.1.7, PL/SQL, SQL Server, Business Objects,ERWIN, Linux servers, SQL*Navigator, SQL*Net, SQL, Sun Solaris Servers, Toad for Oracle, Windows 2000 servers
Confidential
Senior Database Administrator/Help Desk Systems Administrator
Responsibilities:
- Supported US Senate Sergeant at Arms IT services Support Contract.
- Supported all Help Desk systems
- Migrated and upgraded the ServiceCenter 4.0 to 5.0, which including database migration between instances of Oracle 8.1.7 and intense testing for data migration and workflow continuity.
- Managed the iterative training and enhancement of a thirty person help desk/support team that provided 24/7support to all Senate IT systems.
- The environment and technologies in use included: Stored Procedures and other Oracle utilities (Oracle 8.1.7on VERITAS HA Cluster), Crystal Reports 8.5, Quest, SQL*Navigator, SQL*PLUS, Sun Solaris 2.8, Windows
Senior DBA/Change Management Consultant
Confidential
Responsibilities:
- Facilitated upgrade of the baseline Oracle database version from 8.1.6 to 8.1.7
- Verified Oracle Databases were insufficiently patched and not being backed up successfully using Veritas Netbackup. This resulted in the reconfiguration and scripting of scheduled backups of the database to provide recovery capabilities.
- Created a standby database instance with automated and manual processes for resynchronization of production data, to provide for a disaster recovery capability
- Created a manual change/configuration management process to validate the source for Oracle based objects
- Enhanced, documented, and managed the change/configuration management process
- The environment and technologies in use included: Oracle 9i, Oracle database version from 8.1.6 to 8.1.7,
Senior Oracle Migration Consultant
Confidential
Responsibilities:
- The environment and technologies in use included: Oracle 7.x, 8.x, 9.x. Compaq Tru64 Unix/Alpha Servers,
Confidential
Senior Technical Lead and DBA/Data Architect
Responsibilities:
- Led the engineering of a Security Operations Center for a major service provider
- Evaluated Network Attached Storage/SAN solutions for additional backend storage solutions from EMC, Network Appliance, and other vendors
- Utilized PL/SQL, SQL*Plus, and Enterprise Manager to implement a proprietary event correlation tool withdata in Oracle 8.1.7 and monitor transaction posting progress in the production database
- The environments and technologies used included: Oracle 8i, BSD UNIX, Checkpoint, Nerve Center, NetCool ISS, Provider-1, Solaris, RMAN Sun 4500 Database Cluster on a SUN A5200 array with Veritas HA Cluster for Oracle, Veritas File Manager, Veritas HA Cluster, Veritas Netbackup
Systems Integrator/ Technical Lead /Support Team Leader
Confidential
Responsibilities:
- Served as the Technical Lead/Support Team Leader for output management in a large enterprise with substantially high service level agreements (99%).
- Evaluated all available commercial print management products for HP-UX based systems
- Deployed and installed the modified OSM product into test/development environments and then deployed into production.
- The environments and technologies used included: HP V-Class/E-Class/D-Class Enterprise Servers, Oracle Forms, and SQL*Plus, HP ServiceGuard (for automated failover for the Print Management Cluster), C Shell Scripting, and Oracle 8.1.x Server.
Senior Database Administrator/Site Manager
Confidential
Responsibilities:
- Provided incident management/ticketing (Remedy) and application (NetExpert) support.
- Managed five field DBAs and two database developers deployed at multiple worldwide sites
- Provided level 3 technical support for operational issues improving data integrity and reliability at each site.
- Developed SQL and shell scripts for the rapid movement of development schemas to production.
- The environments and technologies used included: Oracle 7.x, HP-UX servers, HP OpenView, NetExpert
Oracle Database Administrator
Confidential
Responsibilities:
- Utilized MS Access, PL/SQL stored procedures and ERWIN to efficiently monitor change managementbetween the five environments.
- The environments and technologies used included: Oracle 7.x, PL/SQL AIX/RS6000, ERWIN, MS Access
Quality Assurance Manager/Help Desk Manager
Confidential
Responsibilities:
- Provided development and Help Desk support to worldwide users of the Defense Data Repository System which tracked all non-classified IT upgrade or development projects.
- Managed four systems engineers in handling and tracking of customer service calls, that included product testing and field support, dispatch of field service technicians to support break/fix of contract supported hardware and software.
- Assisted with the UNIX (HP-UX 9.x and Confidential ), Oracle (7.3) and application support (worldwide) as well as system releases, problem reporting and feedback between the client and the development team.
- Tested major release and patch versions of software, both Oracle-based, Web/XWindow Based and PCAT based versions of the application, including code level (Visual Basic and C) debugging and feedback. • The environments and technologies used included: Oracle 7.3.x, C++, HP-UX 9.x, Lotus Notes, MS Access, Visual Basic 3.0, Windows for Workgroups
Help Desk Engineer/Manager
Confidential
Responsibilities:
- Provided logistical and support desk support for the Confidential PC Lan contract.
- Product evaluation lab manager.
- Developed a customer service tracking application in Lotus Approach and Oracle 7 to provide central customer and ticket tracking across mainframe based contract/service call applications.
- The technologies used included: Oracle 7.x Novell, Digital Unix, Lotus Approach, MS Access, Novell 2,3.