Data Analyst Database Administrator
Resume:
Garry Dawkins
Woodbridge VA *****
**************@*****.***
Clearance - Active Secret
●Experienced with all major phases of information technology and database management.
●Expertise with large, complex federal projects, in the roles as Senior Database Administrator/Enterprise Manager/ Data Analyst, SOA Architect, System Integrator and Data Modeler (logical and physical design). Strong working knowledge and experience in managing development triage, processes and documentation and supporting clients in Oracle IAM service engagements
Education:
●Strayer University Bachelor of Arts Information Systems 1996
●Prince George’s Community College Associates in Arts Marketing 1986
Certifications and Licenses:
●CompTIA Security+ January 2024 to January 2027
●IAT
●MCSA
●IAT Level II
●DoD 8570 October 2023 to October 2028
●CISSP
●CEH
●DoD 8570
●CCNA Security
Work Experience:
Senior Database Administrator/Data Analyst
MacaLogic LLC
October - 2023 — August 2024:
Responsibilities:
●Administered and supported multiple Database repositories US Air Force Program & Budget Enterprise System (PBES)
●Support databases in Qlik reporting and ETL Development tools, Staging, Testing and Production.
●Responsible for BI Business Intelligence Imports and exports of structured and unstructured data.
●Oracle EDM data management, data quality, data cleansing and reconciliation
●Maintained Development data models and schemas via software application development tools: C#, ASP .NET, SQL, SQL Plus and Toad.
●Supported database interface storage and user access via AWS S3, Elastic interface repository and Whitlist controls.
●Supported data warehouse application interfaces, application upgrades to primary Production, Backup and recovery of all environments
●Supported the dev, test and pre-prod environments via SQL developer, Hyperion and BI report.
Portfolio Consultant,
Selenium Consulting LLC
May - 2023 – July 2023
Responsibilities:
●Assisted and supported Portfolio Managers during the order generation and compliance approval process.
●Processed and received customer payments and orders via electronic transaction Services.
●Assisted with all trade processing operations and the trading desk.
Lead Data Analyst / DBA
Potawatomi Training, LLC
November 2021 to September 2022
Responsibilities:
●Responsible for a clinical data analysis plan.
●Provides quality assurance for all metrics and statistical reporting via Tableau reporting tools.
●Manage the end to end lifecycle of user identities and access data
●Acted as the Work Asset Management Manager assigning Covid information to various teams and administering the Work Asset Management data within the COVID-19 initiatives for Indian Health Services (IHS) Under Health and Human Services (HHS).
●Processed clinical data, including receipt, entry verification or filing information.
●Responsible for overseeing data systems to ensure it maintains up-to-date, organized information within specific guidelines and procedures.
●Led a team of data professionals to complete tasks, installing, and updating cybersecurity hardware or software and responding to security breaches to retrieve lost data.
●Managed an IAM team: recruiting, training, coaching, team building and day-to-day oversight
●Managed Data masking, Data provisioning, sub setting, profiling, Data mining, TDM, data management Review the designated data reporting requirements and evaluate the integrity of the data being submitted by the sites participating in the IHS COVID reporting efforts.
●Reviewed the designated data reporting requirements and evaluated the integrity of the data being submitted by the sites participating in the IHS COVID reporting efforts. My focus was to ensure the data submitted met the applicable reporting requirements, contained accurate and meaningful data elements, and complied with applicable reporting format specifications.
As HIPAA Compliance administrator, I transferred data via HL7 v2.5 specific messaging standards to an IHS Central Aggregation Server (CAS), where some automated data validation and normalization is performed to prepare and send messages to locations, such as APHL AIMS, CDC, and IHS National Data Warehouse.
DBA and Cloud Data Analyst / Specialist
Disys, Inc.
Client Highmark Health Pittsburgh PA.
March 2020 to August 2021
Responsibilities:
●Set up user access to a new cloud data repository and migrated data from Teradata to new cloud-based data source Yellowbrick Data Warehouse using R Studios, and YBtool utilities.
DBA and Cloud Data Analyst
Cybermedia Technologies, Inc.
January 2019 to May 2020
Responsibilities:
●Provided advanced setup of migration tools and data for the client Customs and Border Patrol CBP Work Asset Management database to Newly developed CRM management system.
●Led migration from Oracle Forms and Reports 10g/11g/12i CRM 12c to Salesforce CRM.
●Oracle Forms and Reports 10g/11g/12i data to Amazon Web Services as DBA and Cloud administrator via DynamoDB and Amazon S3 and S3 Glacier cloud repository.
●Acted as a liaison to CBP application consultant to maintain integrity of existing database objects during reengineering of CBP internal database architecture.
Sr. DBA\Network Consultant
Accel Solutions LLC
May 2016 to July 2018
Responsibilities:
●Aided and advised scientific users on the technical aspects related to software, hardware, and peripheral equipment essential to support research in the USDA ARS Nutrient Data Laboratories (NDL).
●Provided Network administrative assistance with the set-up and maintenance of new user accounts to the USDA ARS Domain and demonstrated familiarity with network software.
●Led the existing legacy USDA ARS database responsible for all aspects utilizing ETL tools, including Oracle Forms and Reports 10g/11g/12i Data Integrator into Oracles Work Asset Management system via Oracle Forms and Reports 10g/11g/12i Goldengate, Informatica, PowerBI, Data stage and RDBM systems like Oracle Forms and Reports 10g/11g/12i and SQL Server. NDL Oracle a 12c application.
●Modified existing Oracle Forms and Reports 10g/11g/12i PeopleSoft CRM 9 and 9.1 forms, Oracle reports, Cisco, WebLogic middleware interfaces to application, Java access and upgrades along with maintaining Oracle Forms and Reports 10g/11g/12i patching, Symantec, Microsoft, Dell server and power management.
●Extensive experience in the administration, installation and configuration Apache 2.0/2.2 Tomcat 5.x, 6.x, Sun One 6.1 Web Server iPlanet, Microsoft IIS Server.
●Installation and configuration of JBoss 4.x and Apache Tomcat 5.x, 6.x application servers
●Maintained the National USDA ARS Nutrient Databank System (NDBS): Fisma and Fedramp Administrator. Including servers, hardware, software, IP addresses and network access, while transitioning to the new database application. ETL Integration of data from Oracle 12c to Azure Data Platform.
●Maintained 508 compliance standard to support the NDBS systems for anomalies that may occur from all software modifications or other sources.
●Maintained the current legacy AIM-NDBS during the transition to the ARS Foods master database system.
●Supported the New Productions ARS Foods application as primary production Administrator and Lead Development Liaison. Configuration and Administration of DevOps tool Jenkins and Artifacts for Development, Testing and Production environments.
●Acted as the liaison to groups that share and import data such as Food and Nutrient Services, National Agriculture Library and Nutrition.gov at both USDA Beltsville MD and Ft. Collins Site.
DBA
CTI Global Solutions
May 2015 to August 2015
Responsibilities:
●Supported the National Endowments for the Arts as a senior database analyst and application database administrator DBA and supported the conversion of legacy Oracle HCM Forms and Reports 10g/11g/12i grant data and information via Grants.Gov system to via Fisma Compliance guidelines. As the technical liaison to National Endowments for the Humanities to the new Grants Management Shared System eGMS my role also required my expertise as the NEA eGMS application administrator
●Worked as liaison to the primary NEH (National Endowment for the Humanities) development team to adhere to the development standards for NEA integration.
Sr. DevOps Engineer
US Coast Guard - Washington, DC
January 2015 to March 2015
Responsibilities:
●Supported the US Coast Guard. I upgraded and data Integration of Oracle Forms and Reports 10g/11g/12i 11i HCM Suite to Oracle 12.1 E-Business Suite in their Dev, Test, and staging environment.
●Used Oracle E-Business/Oracle HCM in an effort to modernize and provide integration for Accounting and Financial for the US Coast Guard, TSA and DNDO at HQ DHS Division.
●Duties included database maintenance, database SQL script development, requirements gathering, documentation, implementation and ETL Integration as well as form development and modification, report modifications and database administration.
Oracle DBA
Purisolve, Inc
September 2013 to July 2014
Responsibilities:
●Supported the Internal Revenue Service TASIS and TAMIS, Maintain Federal Compliance regulations. Oracle database and application as a senior Oracle DBA\Developer.
●Upgraded and patched on the Development, Test and pre-deployment servers and systems support via OEM and command line utilities.
●Supported the testing process by providing insight to the independent testing staff when complex issues arise. Provided software maintenance to Oracle forms and reports of existing services to the present database running on Oracle 11g r2 in preparation for Integration to Oracle 12c.
Sr DBA
CDI Corporation - Washington, DC
August 2012 to January 2013
Responsibilities:
●Migrated and upgraded from Oracle 10g to Oracle 11g r2. Test environment Oracle 12c.
●Duties included database maintenance, database PL SQL development, ASP.NET web development, ASP.NET services development, requirements gathering, documentation, implementation and ETL Integration.
IRS Informatica Lead
Internal Revenue Service
August 2011 to August 2012
August-2011 - August 2012
Responsibilities:
●Worked as a Multi Mass processing Database analyst/engineer/administrator. Maintained Federal Compliance regulations. Gathered for review deliverables produced by other Test Analysts and IRS groups that feed document, artifacts, and other pertinent database infrastructure documentation for integration into new RRP EMC GreenPlum Database.
●Coordinated project testing, including testing involving multiple tests and coordinated the creation of generic data needed for testing for database maintenance, database PL SQL and PostgreSQL database development with access to appropriate personnel to ensure the test environment is ready for ( IRS Informatica Lead). Informatica MDM Power Exchange development, ETL Integration, EMC GreenPlum NET services and Hortonworks tools for development, requirements gathering, documentation, and implementation.
●Developed test plans, schedules, and test cases for result analysts with other RRP Team groups and members. Managed data source feed; developed reports for the IRS Return Review Program Office.
On Contract
Department of Housing and Urban Development, Silver Spring
July 2011 to July 2011
Responsibilities:
●Analyzed the HUD Multifamily Database Applications & Program.
●Modified ASP.NET application forms and coordinated changes with the SQL Server 2008 database.
DBA Consultant
On Contract Department of Army - Washington, DC
October 2009 to May 2011
Responsibilities:
●Maintained daily load of the Physical Disability Agency data load and Integration. Maintained DOD Compliance regulations, backups and recovery strategies.
●Developed ad-hoc reports. Maintained legacy databases and processes while gathering requirements for Integration, testing and upgrades as needed.
●Set up user access to the data repository and migrate data from clipper data source to Oracle and SQL Server for management reporting.
Recovery Manager
On Contract
Department of Justice - Washington, DC
January 2009 to May 2009
Responsibilities:
●Managed, administered, and upgraded multiple Department of Justice Civil Division Office of Litigation Support Oracle 9i and Oracle 10g databases and servers up to 10 terabytes of data (DOJ, Office of Litigation support OLS).
●Maintained Federal Compliance regulations.
●Managed Oracle Content Database, Oracle Fail Safe RAC, ASM Backup Strategies and TOAD for primary databases. Re-configured backup and recovery strategy via Recovery Manager (RMAN) for upgrade. Backup to SharePoint OLS administration. Utilized, managed and monitored hot standby databases using (Data Guard) as well as monitored primary databases.
●Assisted with EMC SAN deployment and coordinated implementation with Dell Engineers, Lockheed, and other Server Engineers.
●Supported Development Team throughout OLS. Integrated existing Oracle Content of OLS legacy systems into database technology using Oracle, SQL Server, and SharePoint of other database technologies. Upgraded and maintained other database daily responsibilities.
●Perform application testing of new DOJ Integration, applications, and interface.
On Contract
Missile Defense Agency - Arlington, VA
October 2007 to August 2008
Responsibilities:
●Managed, administered, and upgraded Missile Defense Agency (MDA) Oracle database 9i and Oracle 10g database technologies.
●Managed backups and recovery strategies using Recovery Manager (RMAN). Modify Cluster expansion through node additions with existing infrastructure elements for secure BEA Plumtree portal access. Cluster-ware monitoring and diagnosis for Integration of existing legacy systems into database technology using either Oracle Portal application server single sign-on technologies. Tested and Integrated 2 terabytes of data into MDA Portal.
●Implemented a hot standby database (Data Guard) for production databases. Testing and implementation of database replication for move to Huntsville, AL.
●Integrated Oracle Content into BEA portal for upgrade and maintenance of other databases using SQL Developer and Toad to interface oracle daily applications as needed.
●Performed application testing of new MDA portal applications and interface.
Contact this candidate