We provide IT Staff Augmentation Services!

Database Administrator Resume

Huntsville, AL

SUMMARY:

  • Over 27 years of IT experience with latest emphasis on Oracle 11g/12c administration on Linux, Solaris and Windows, and SQL Server 2008R - 2/2012 and 2014 cluster administration on Windows in support of the DoD at Confidential, AL.
  • 8 years of application and database development for the DoD while utilizing SQL Server 2008R-2, 2012 and 2014, Oracle 11g, 12c, PowerShell, SharePoint 2010, ASPX, VB.Net 2008/2010, Business Objects, Visual Basic 6.0, VBScript, ASP.Net, Access 2007/2010, SQL, T-SQL, PL/SQL, ODBC, ADO, DAO, XML, APIs, Crystal Reports, MS Office 2010, PowerPoint, Visio, SQL Diff.
  • Over 20 years as a Software Analyst
  • Over 15 years as a Database Developer
  • Over 20 years of manufacturing experience
  • Over 10 years of ETL/data-migration tool and middle-ware design, development and support
  • Over 8 years in support of Department of Defense operations, CONUS and OCONUS
  • Active Secret Clearance
  • Significant experience in DoD systems and operations to include USMC MFS, Army IA/CND Network Defense Operations, ULLS-A (E) and UAS-I Aviation Maintenance and Supply Software design, development and support, SAMS-E support, Air Force NexGen, SQL Server 2005/2008R-2, 2012, 2014 database administration, design, development and support, Oracle 11g, 12c database administration, design, development and support.
  • SQL Server and Oracle patching, upgrading and STIGging
  • Extensive data-migration automation (ETL tool development) SQL Server, Oracle and other databases
  • Over 6 years management experience as Project-Lead, Development-Team-Lead and IT Department Manager
  • Familiar with CMMI Level III Documentation Standards
  • Significant experience in software design documentation process, i.e. requirements-gathering, requirements specifications, functional specifications, flow-charts, mock-ups, etc.
  • Full Lifecycle Application Development experience (SDLC).
  • CompTIA Security+, DISA HBSS Admin (201), Skillsoft SQL Server 2008R-2, FedVTE Advanced Windows Scripting, Brainbench Visual Basic.Net 2003, MS Access 2000 Programming and MS Access 2000 Fundamentals s
  • Databases include SQL Server, Oracle, Access, DB2, Progress, Paradox, IMS, Image, dBase III+
  • Languages include: VB.Net 2003/20, VB 4/5/6, VBA, VBScript, SQL, PL/SQL, T/SQL, Powershell, ASPX, HTML, XML, PHP, JavaScript, VBScript, DOS, QBASIC, GWBASIC, COBOL, Progress 4GL in C++, Visual Basic, VB.Net, C#.Net, ASP.Net, HTML, XML, COBOL, PASCAL, FORTRAN
  • Report development experience in SSRS, Crystal Reports versions 2, 6 and 9, Oracle, Access and others
  • Designed, developed and deployed a Material Requirements Planning System developed in Paradox 3.5 and PAL.
  • Administration of Windows 2003/XP/2000/NT/98/95/3.1, MS-DOS, IBM AIX, HP/UX, Linux and HP3000 MPE.
  • Windows Network Administration, MS Exchange, Active-Directory, Outlook, Firewall Administration
  • EDI Administrator on GEISCO and Harbinger/Supply Tech for DOS.
  • Application support for MS Office products, Lotus SmartSuite products and Corel WordPerfect.
  • Installation, configuration and support of a document imaging, indexing and filing system.
  • Hardware support, including assembly, trouble-shooting, maintenance and repair of PCs and peripherals.
  • Programming of Intermec Bar code scanners and data collectors for physical inventory of finished goods.
  • Y2K Compliance Programmer/Analyst on HP3000 utilizing COBOL, IMAGE, QUERY, Librarian, MPEX, PowerHouse QUIZ, Suprtool, Transact, Omnidex and DBGeneral.
  • System Manager on an HP LX, MPE supporting a 32-user MRP system (MDSS).
  • Member of team that developed an EDI to Order Entry System interface for an HP3000/MPE manufacturing system.
  • Custom EDI report development
  • Licensed HAM Radio Operator, General Class
  • First Aid/CPR/AED

WORK HISTORY:

Database Administrator

Confidential, Huntsville, AL

Responsibilities:

  • Database administration and support, patching, upgrading, database backup management and support, automation of database status monitoring, backup status monitoring and alerts, space monitoring and management, job and task scheduling, automation of password management for Linux, Solaris and Windows accounts, database patch installation and STIGging of Oracle 11g, 12c on Linux, Solaris and Windows and SQL Server 2008R-2-2014 on Windows 2008R2, 2012R2 for AESIP and ERP enclaves.
  • Shell scripting, DOS batch and Windows command file development, T-SQL and PL/SQL script development, crontab and Windows task management
  • SQL Server 2014 Cluster administration, application of database and instance STIGs with development of procedures and scheduled jobs as solutions for open findings. No issues were raised during a recent security audit of the 2014 cluster.
  • Security+, Secret Clearance, CAC and SA tokens as required for access to Government Systems

Implementation Conversion Engineer; Oracle SQL, PL/SQL

Confidential, Heathrow, FL

Responsibilities:

  • Parse, cleanse and migrate data extracted from hospital systems into system for monitoring 340b eligibility, automation of 340b inventory control and auditing Deficit Reduction Act compliance(Medicaid), and pharmacy claims processing.
  • Tools utilized include: Oracle, SQL and PL/SQL, PostgreSQL, Ruby and Linux Shell scripting

MFS Developer/Technical Analyst

Confidential, Pensacola, FL

Responsibilities:

  • Gather and document requirements, design, develop, deploy and support Memorandum Fiscal Services (MFS), a financial document management and reporting system used by the USMC
  • Tools utilized include: VB.Net 2010, SQL Server 2008R-2, Visio 2010, PowerPoint 2010, MS Access 2010, T-SQL

SharePoint Developer

Confidential, Huntsville, AL

Responsibilities:

  • Gather and document requirements, design and develop SharePoint site for consolidated management and reporting of Programmatic data.
  • Design and develop dashboard for quick access to key performance indicators for quickly ascertaining the health and status of Programs at the Confidential .
  • Process requires Identification and mining of data from several disparate systems
  • Extraction, transformation and loading of data from various disparate sources into normalized and relational SharePoint lists
  • Source databases included: SQL Server 2008R-2, Oracle 11g and IBM DB2
  • Secret Clearance and CAC as required for access to Government Systems

Database Administrator

Confidential, Herndon, VA

Responsibilities:

  • Oversight of database design, implementation and data-migration processes from Air Force legacy systems to NexGen, ACES, GeoBase and EESOH-MIS systems
  • Management of MOA/LOA agreements between systems management personnel for definition of responsibilities and limitations associated with interfaces between disparate systems.
  • Design and development of MS Access and Excel applications in support of contract management personnel
  • Security+, Secret Clearance and CAC as required for access to Government Systems

Network Defense Engineer

Confidential, Fairfax, VA

Responsibilities:

  • Supporting IA/CND operations for all of Afghanistan
  • Maintain, enhance and support the Heuristic Observable Traffic Passing Across Networks System (HOTPAN), an application for identifying and reporting cross-domain violations across the entire CJOA for investigation of potential security breaches and/or spillages of classified information
  • Provide SQL Server database development, administration and support for McAfee HBSS and HOTPAN, as well as MS Access and Excel support for the IA staff.
  • Develop Powershell, VBScript and T-SQL scripts, stored-procedures and functions for iimporting, storing, analyzing and reporting various network activity logs and registry data retrieved on a daily basis across all government networks in use in Afghanistan.
  • Managed ongoing ETL processes for daily migration of data from various source systems into SQL database
  • Analyze, improve and/or automate processes wherever possible
  • Gather requirements, produce design documents, develop, deploy and support databases and software as needed
  • Modify and improve Web-based application for presenting network activity logs to authorized investigators.
  • Security+, Secret Clearance and CAC as required for access to Government Systems

Senior System Analyst/Aviation Analyst

Confidential, Huntsville, AL

Responsibilities:

  • Developed complex MS Access 2007 application in support of AMCOM's Contractor Oversight Team (COT) based at Bagram Air Field, Afghanistan for use during inspection, auditing, findings consolidation and reporting processes
  • Supported US Army Aviation Maintenance and Supply Systems, ULLS-A(E), SAMS-E
  • Developed SQL scripts for manipulation, correction and reporting of Government data in SQL Server databases at Reset Sites
  • Analyzed, simplified, improved and/or automated processes wherever possible
  • VB.Net 2005 SQL Server 2005 GAANT charting application design/development for charting Reset unit performance versus schedule
  • Gathered requirements, produced design documents, developed, deployed and supported databases and software as needed
  • Designed and developed Web-based application and back-end database for managing ROM costs to reside on Redstone WebDesk. Tools utilized included ASP.Net (VB), JavaScript, SQL Server 2005, T-SQL stored-procedures
  • Built and deployed data-warehouse and server for use in analyses of maintenance data across 160+ unit and Reset databases
  • Developed ETL scripts for extraction, cleansing and loading of data from numerous Maintenance Unit databases into data-warehouse
  • Installed and supported Oracle 11g database utilized by one of the STAMIS systems
  • Required to adhere to strict government guidelines with regard to CMMI Level III standards for documentation and testing
  • Secret Clearance and CAC as required for access to Government Systems

Contract Programmer Analyst

Confidential, Huntsville, AL

Responsibilities:

  • Software Developer: VB.Net 2003/2005/2008 , Visual Studio.Net, VB 6.0, Visual Studio 6, SQL Server 2000/2005, SQL, T-SQL, OSQL, SQLCMD, ADO, DAO, ODBC, VBScript, Business Objects, Visio, SQL Diff
  • Requirements-gathering, software design documentation including requirement and functional specs, Visio process-flow-charting, proposed screen-shots and class-definitions, database schemas.
  • Development and support of a system designed and developed for use by ARMY Aviation Maintenance Units.
  • Primary area of responsibility is support for the existing Supply System, an ASP.NET (VB) application, while being involved in the design and development of the next version of the application
  • Responsible for designing and developing a scripted solution for migration of users from SQL Server 2000 and MSDE to SQL Server 2005 and SQLExpress, respectively.
  • Required to adhere to strict government guidelines with regard to CMMI Level III standards for documentation and testing, as well as strict company software design standards, which were enforced through code reviews by peers

Systems Analyst/Programmer

Confidential, Florence, AL

Responsibilities:

  • Systems Administrator/Network Administrator/Web Master: MS Exchange, Active Directory, Windows 2K3 Servers, Fortinet Firewall, Endian Firewall, VNC, Outlook Web Access.
  • Software Developer: VB.Net, Visual Studio.Net, XML, VB 6.0, Visual Studio 6 MS Access 2000/XP, VBA, SQL Server 2000, SQL, PL/SQL, ADO, DAO, ODBC, API, COM, Excel, Data Migration
  • Development and support of a custom loan monitoring system for tracking insurance coverage on properties listed as collateral on bank loans for verification of adequate coverage on real and personal properties with regard to flood zones, wind zones and other locations. Issue notices to customers and force-place insurance coverage as required. Maintained interfaces between TAG systems, banks and insurance providers. Worked closely with bank personnel to ensure the accuracy of the process.
  • Application developed in MS Access 2003 utilizing a SQL Server 2000 backend database.

Senior Software Analyst

Confidential, Huntsville, AL

Responsibilities:

  • Management of a team of developers responsible for design and development of data pre-processors, platform interface automation and ETL/data-migration tools.
  • VB.Net, Visual Studio.Net, XML, VB 6.0, Visual Studio 6, MS Access 2000/XP, VBA, Oracle 9i, Progress, DB2, IBM/IMS, SQL Server 2000, Unix/Linux, NT/2000/XP, SQL, PL/SQL, ADO, DAO, ODBC, API, COM, XML, Excel, Agile CM Engineering Change Management Software

Hire Now