David Singleton Email & Phone Number

Remote

Remote

Kansas City, Missouri, United States

Created and completed ETL data migration processes to the cloud. Completed migration of all requisite data to the cloud, ahead of schedule. Successful performance tuning of VLDB (20TB) databases. Exceeded all requirementsCurrently managing heterogenous environment with SQL Server and Oracle.Created ETL between SQL Server and Oracle and upload between SQL Server, Oracle and S3.Used SQL, PLSQL, TSQL, PERL, BASH, BAT to create processing environment for ingesting, in-line transformations, uploading to cloud. Direct automated loads from SQL Server to Oracle

• Cloud champion, moving applications into FEDRAMP certified environments.• Interface between business, development, management, vendors and data centers to design multi-terabyte high performance environments.• Develop, plan and execute strategic migrations. Consolidation, and re-hardware of existing environments. • Logical and physical performance improvements. Resulted in drastic increase in performance, reduction in memory and resources, and customer satisfaction.• Coordinate and participate in security A&A activities. Enforcement of Federal security guidelines. Data custodian supporting SSO during multiple A&A activities and boundary adjustments for core systems.• Mentoring influence and teaching and socializing best database practices. • Capacity planning, and future systems design, for both cloud and hardware implementations.• Execute architectural enhancements based on needs of the business and architectural goals.• Completed Basic (Level I) Contracting Officer's Representative 9/29/2015. Future plan to complete COR certification.

Fort Collins, Co

Technical Lead Oracle DBA and Architect• Consolidated Multiple enterprise databases, and over 20 applications into PaaS type RAC and standalone environments, improving performance, and cutting resource utilization in half (16 machines to 6 machines and 3 PaaS VMs). All delivered on time without additional downtime.• Developed and executed migration plan for 6 production RAC Oracle databases from local data center to USDA NITC Enterprise Data Center Database as a Service (cloud)• High level planning with senior leadership in order to comply with current Federal directives concerning cloud, data center consolidations, disaster recovery, and security compliance.• Developed PLSQL procedures and functions, utilizing Oracle Virtual Private Database functionality, Row Level Security, and Fine Grained Auditing in order to comply with NIST standards.• Implemented access based controls, using session information, IP address information for DB level ACLs, and program based access.• Performance tuning of DB objects, SQL, PLSQL in OLTP, DSS and Data Warehouse environments.• Implemented Windows to Linux database cloning, using RMAN • Implementing non-heterogeneous Data Guard between Linux and Windows.• Multiple successful production RMAN recoveries. • Merging, and redesigning DB systems, based on capacity planning and load studies.• Mentoring 2 DBAs, in order to provide continuity of support.• Organizational Subject Matter Expert for Oracle RAC, Data Guard, RMAN, HA, DR.

10/2005 - 12/2012 D-SAS, LLC; Oracle DBA Contractor/ Technical LeadNational Information Technology Center (NITC) • Desgined and deployed Oracle RAC solutions for national "critical infrastructure" customers.• SME for RAC, Dataguard, HA environments.• Built and deployed turnkey “Oracle Platform as a Service(PaaS)” • Provided technical direction and support to critical government emergency systems • Implemented Oracle STREAMS for data replication and Data Guard for disaster recovery• Supported rollout of data warehouses using downstream change data capture to staging database, Oracle Warehouse Builder (OWB) run by Oracle Workflow for Load-Transform-Load. Data sources included real-time weather, aviation, and GIS data. Cognos provided dimensional cubes for query flexibility in reports• 24x7 DBA support for mission critical government enterprise DBs, including OLTP/OLAP RAC, Data Warehouses, and Spatial (ARC)GIS databases, and an additional 12 production DBs, and Oracle GRID• Conducted recovery of data on very large clustered databases for customers.

Master Of Education, Human Resources And Adult Education

Master'S Degree, Human Resources And Adult Education