Sr. Prin. Dba Resume Profile
Career Summary:
- Over 9 years Database Administration of up t 200 SQL Server and Oracle databases including over 31 years database design, data modeling and analysis, data extraction, transformation and loading, database software, server, and application installation, configuration and maintenance, data warehouse development and administration, database replication and database applications development. Over 31 years of experience designing, developing, and administering a variety of military and commercial software and network systems. Extensive experience in all aspects of the software development life cycle process in the intelligence, defense, utilities, health care, finance, education, and other industries.
- Has acquired excellent communication, task management and organizational skills with attention to detail. Is self-motivated. Able to break down complex problems inside limited maintenance windows and critical level production issues. Works collaboratively within a close-knit team or independently. Can present products and ideas in a professional manner. Has strong customer facing experience.
Clearance:
TS/SCI Clearance with SSBI, Counter Intelligence Polygraph SI/TK/HCS/G/B/NATO - Secret
Technical Experience:
Databases:
- More than 9 years database administration mainly with SQL Server 2000 2012 but some Oracle 9i -11g
- Over 31 years database-oriented development, management and other database/IT related duties
- Database systems administered or data access tools with SQL Server 6.5 2012 64-bit, Oracle 7.3.3 11g, Visual FoxPro 2.0 9.0, dBase II V, DB2, Access 2.0 2010, Excel 2.0 2010, Crystal Reports, Informatica PowerClient Designer and Server Manager 4.6.1, DAO, RDO, ADO 2.0 2.8 and ADO.NET 2002 2010, Visio 97
- 2010 for modeling and reengineering, XML
Systems:
- 9 years system administration of 50 Windows 2000 2012 R2 servers, classified rooms and DMZ
- Administration of NetApp FAS3140 Network Attached Storage NAS /Storage Area Network SAN device
- Development and management of VMWare ESXi 4.0 virtual servers/workstations
- Windows and database account and rights management
- Hardware and software on-site and remote installation, troubleshooting, repair and maintenance
Management:
- Supervised dynamic staff including internal and external contractors for over 6 years
- Building small teams from SEI CMM level 0 to level 2 by successfully designing and implementing software engineering processes consisting of the Extreme Unified Process XUP which is based on Extreme Programming XP , Rational Unified Process RUP and Microsoft Solutions Framework
- Managed team configuration, quality assurance, testing and office automation
GIS:
- More than 8 years supporting ESRI ArcGIS intelligence, defense, state and infrastructure systems
- SDE administration of ArcSDE 8.0 10.1 64-bit on SQL Server 2000 2008 R2 and Oracle 9i 11g
- Map production and interactive map application display using ESRI ArcView/ArcMap 3.2a 10, ArcInfo 7 10, ArcCatalog 8.0 10, ArcObjects 8.0 9.3
- Implement and troubleshoot ArcGIS Server 8.0 10 ArcIMS server, map services and Image Services
Languages:
- Developing with SQL for more than 8 years
- Over 10 years developing with Visual Basic VB for DOS to .NET 2008, VBScript and VBA
- Writing SQL Server Transact-SQL stored procedures, scripts and functions for over 12 years
- 3 years of querying data with ORACLE PL/SQL
Work History:
Sr. Prin. DBA/Database Engineer, Confidential
- Install, administer and troubleshoot SQL Server 2005 - 2012 64-bit and associated servers at the National Geospatial-Intelligence Agency on the Intelligence Community Cloud Engineering Team
- Perform windows updates on all SQL Server related Windows 2008 2008 R2 servers
- Install Database mirroring and Always On Availability Group clusters
- Develop T-SQL scripts and SQL objects and Powershell scripts for improving system management
Geospatial DBA/Enterprise Administrator, Confidential
- Administer SQL Server 2005/2008 R2 64-bit and occasionally troubleshoot development Oracle 11g ArcSDE spatial databases for the National Geospatial Intelligence Agency Global Geospatial Intelligence GGI and Central Intelligence Agency Maps II 2010 programs carto/imagery data on Windows 2008 R2 64-bit database servers
- Provide IT support for production and development file and geospatial database servers, NetApp FAS3140 Storage System, IBM TS3500 Tape Storage System for Geospatial Intelligence Operations including network share creation and security, and administer SAN aggregate, volume, LUN and CIFS shares
- Assist SAIC In-Service Engineering Biometrics Automated Toolset-Army BAT team to receive a rare 3 year Approval to Operate ATO accreditation of their SQL Server 2008 database by working through the DISA STIG action items to lock down server and database security
- Provide cost-benefit analysis and recommendations to purchase IT hardware/software products
- Manage vendor relationships with regards to purchasing, warranties, maintenance and licensing
- Determine IT project priorities and internal site infrastructure architecture such as network domain migration
- Manage application licenses and license servers and virtualized all license management servers to VMWare vSphere ESXi 4.0 virtual servers for multiple sites access
- Mentor the SAIC USDA Farm Service Agency DBA on relational data modeling and reengineering the data model
- Member of the proposal writing team for the SAIC USDA Harvester Data Warehousing program
- Oversee SCIF workstations, server, and network infrastructure and provide SCIF desktop support
- Increased spatial databases performance by migrating them from 32-bit editions of Windows 2003, SQL Server 2005 and ESRI ArcSDE 9.3.1 sp1 to 64-bit editions of 2008 R2 and ArcSDE 10 utilizing Direct Attach Storage
- Provide support for ArcGIS Desktop 9.3.1 to ArcGIS Desktop 10 migration, ArcSDE 9.3.1 to ArcGIS Server ArcSDE 10 implementation, research replacing of ArcSDE for serving imagery with ArcGIS Server 10 Image Services
- Administer on the servers residing in the DMZ including upgrade of a Sharepoint server from 3.0 to 2010
Regional GEOFidelis Database Administrator, Confidential
- Contracted at Confidential Marine Corps Base Camp Lejeune to the East Coast Regional GeoFidelis IT department and Marine Corp Installations East Network Operations Center
- Provided systems administration through installation, configuration, monitoring, troubleshooting, migration and support of Windows 2000 and 2003 32 and 64 bit servers, SQL Server 2000-2005 32 and 64 bit , SharePoint and web-based application installations in virtualized environments
- Provided daily maintenance and support to customer systems of 200 SQL Server databases in all lifecycle environments using standards-based methodologies for internal staff, customers and vendors
- Monitored change by using Configuration Management techniques
Europe Dep. Configuration Manager, Confidential
- Provided configuration management and automated in-house processes and SharePoint document management for the Program Manager Joint-Automatic Identification Technology PM J-AIT In Transit Visibility Internet ITV-I application, which provides visibility of U.S. and NATO military in-transit shipments, server team
- Developed change management workflows such as an Outage Incident System
- Maintained functional baseline documents of all server environments including software version control
- Administered the local Information Assurance Vulnerability Management IAVM database
- Provided QA for the WebMap and Track Admin web applications
Sr. Software Engineer, Confidential
Developed a Data Extraction service to transfer and manipulate data from an Oracle 8i Manufacturing ERP database to an Agile Oracle database at Sanmina-SCI with VB.NET 2003 and 6.0 and RapidSQL
Sr. Programmer, Confidential
Co-enhanced an Optical Network Pricing System on a contract for Nortel
Sr. Software Engineer, Confidential
Replicated proprietary Confidential Army asset management databases at Cobro Westar for PM J-AIT
Sr. Software Engineer, Confidential
Developed a Telecommunications Quality Assurance Metrics Reporting Service at Adtran
Sr. Software Engineer, Confidential
- Contracted to the Alabama Department of Transportation GIS Department
- Database/systems administration of SQL Server 2000 and Oracle 9i - 10g ArcSDE 8.3 9.0 instances of an Executive Management System and data warehouse residing on Windows 2003 servers
- Extracted, transformed and loaded relational and spatial Oracle, SQL Server, DB2 and other source data
Software Engineer External 4, Confidential
Led the PSDSS application team for the US Army's PEO-EIS PM J-AIT finding part failure on deployment and when to move along the supply chain in real time of systems on missions Administered SQL Server 2000, VB 6.0 and ArcView 3.3 server service
Software Consultant, Confidential
Convert proprietary COM data access component/package classes
Software Consultant, Confidential
Transformed Data Mappings Clarify Call Center CRM databases at Lucent/Avaya
Project Manager, Confidential
Maintain the background check system and FTP post process application
Computer Consultant Coordinator, Confidential
Co-developed and coordinated team at Geonix for the map property folios GIS application of Northern Ireland
Computer Consultant, InConfidential
Tooled an Import/Export and data conversion module of a medical management system at InfoMC
Delivery Technical Lead, Confidential
Coordinated the delivery of wireless dispatching system and supervised dynamic applications teams
Manager of Software Development, Confidential
Managed a dynamic development and technical support teams of a managed care system
Computer Consultant, Confidential
Contracted to the Alltel Mortgage Processing development team also report writing in with SQLpassthrough tiered queries at BAE
Manager of Software Development, Confidential
Supervised and architected the lifecycle of a GIS, Document Imaging, Cable-locating Systems
GIS Consultant, Confidential
Edit phosphate mine mapping documents for IMC Agrico
Graduate Research Assistant, Confidential
Developed a network, edited water surface infrastructure and demographic change
GIS Intern, Confidential
Edited the Mississippi state database map
