PROFESSIONAL SUMMARY:

Long time IT professional with a multi - disciplinary history of success;,, and broad Information Technology experience necessary to excel in new challenges and responsibilities. experience and successes are in Database Development, Administration, and ETL s in networking hardware, Cloud/AWS (Pentagon “Mil-Cloud”) web development (CBP NOC Dashboard), programming team lead (CBP Python Data Visualization Prototype) management experience including US Federal management and regulatory documentation.

TECHNICAL SKILLS:

• MS SQL Server 2000/2005/2008 r2/2012/2014
• Oracle R12 Discoverer
• SAP Business Objects XI
• C, C++, Java, SQL, Python, Javascript
• Proficient at an advanced level in MS Office, (Word, Excel, PowerPoint, Access, Outlook).
• Web Author/Design using HTML, Macromedia Dreamweaver

WORK EXPERIENCE:

SQL Server Database Administrator

Confidential

Responsibilities:

• SQL Database Administrator in an SQL Server clustered Enterprise Data Center
• Monitor and support a federal data center comprised of 3 enclaves, multiple SQL Server clusters in an always on environment
• Perform routine backup and restore functions and ad-hoc backup and restores to support the enterprise environment customers.
• Plan and implement SQL Server version upgrades
• Plan and implement SQL Server migrations
• Microsoft SQL Server 2012/2014 exam 70-461 boot-camp
• Microsoft SQL Server 2012/2014 exam 70-462 boot-camp
• Responsible for ETL, maintenance, operations, and optimization of:
• SQL Server 2014 DB
• MongoDB database
• PostgreSQL database
• Linux Administrator for secure virtual environment (MilCloud)
• 9 Linux servers
• AWS structure for migration of existing financial applications
• Apache
• Tomcat on DoD
• MongoDB database
• Windows System Administrator for multiple Windows servers both in production and test environments

Confidential

SQL Server Database Developer

Responsibilities:

• Tableau Administrator, Tableau database reporting application, Administer user list, logins, roles and access

Confidential,

DBA and Application Developer

Responsibilities:

• Lead on a $500 Million dollar, multi-year Java development project leading a team comprised of a Professor at Confidential and his research team to automate and maintain the Nuclear Radiation Sensor network nationwide
• Lead on a Remote Satellite-Modem project to support the Nuclear Radiation Sensors. Researched, designed, obtained proprietary access to Confidential satellite networks and commercial grade DOD/DISA certified satellite modems and successfully transmitted proprietary formatted sensor data via satellite to military ground station for secure transmittal via secure government network to analysis office
• Lead - Application Designer on a Python big-data visualization development project in support of the Nuclear Radiation Sensor project.
• DBA team member on data mining and data warehouse design project for a 100 TB dataset of sensor data
• Instrumental on re-writing critical SQL queries to optimize run-time and lessen impact on database services and other user organizations
• Database designer using Enterprise Architect, Tableau, and other tools to design, diagram, and document progress of front-end applications and configure the database backend
• Database analyst and report writer for proprietary Customs and Border Protection (CBP) very large database
• Analyze and suggest updates/ modifications to enhance and optimize the db and/or result sets
• Research and prepare documentation and staffing recommendations for staffing-up Data Analysis Center for Threat Evaluation and Reduction (DAC-TER) (CBP) utilizing Department of Homeland Security guidelines and procedures
• Prepare presentation and for new data warehouse functions and data marts additions to CBP database
• Daily ETL operations using Oracle R12, Oracle Discoverer, and SAP Business Objects to access military personnel database (MILPDS), and federal civilian personnel database (DCPDS)
• Working closely with Air Force personnel gathering requirements for complex ad hoc SQL queries to produce reports to specifications on request.
• Test, monitor and optimize database queries and tables
• Produce technical design documentation from requirements: Working closely with Air Force personnel gathering requirements for ongoing improvements to proprietary client-server application
• Liaison with Air Force Board Secretariat and Senior Leader Personnel Operations Administration
• Documented and Certified the Promotion Board results for all SR personnel listed above for Congressional review

Web Content Developer

Confidential

Responsibilities:

• Develop, upgrade and maintain secure web portal and supporting database for a U.S. Customs and Border Patrol, using AJAX, Java, JavaScript, SQL, MySQL, and SQL Server
• Maintain and update existing Secure Web Portal/Network Operations Center dashboard using Java, JavaScript and SQL
• Produce technical design documentation from requirements: Working from user requirements, upgrade and develop content for web portal
• Perform maintenance, updates, and user logins and roles on sql server databases that support web portal functions
• SQL Server DBA: Administer user list, logins, roles and access to secure web portal

Project Management Information Systems Manager

Confidential, Chantilly, VA

Responsibilities:

• Responsible for the update and maintenance of the Project Management Information System
• Perform Daily ETL procedures from multiple sources for Confidential
• Design SQL queries and reports to support the project control office
• Designed and implemented MS Access databases
• Evaluate and recommend IT services and equipment

Information Systems Analyst

Confidential, Manassas, VA

Responsibilities:

• Administrative and database support to IDP Lab, Production and Test unit
• Assist in inventories, audits, data input
• Database administrator: operation and maintenance of 5 SQL based proprietary databases
• Design and implementation of MS Access databases in support of Sonar Lab operations
• Rack Server Technician: service and upgrade of rack servers for deployment to U.S. Nuclear Sub Fleet