Database Administrator Information Technology
Resume:
Joe H. Tran
email: ad7szi@r.postjobfree.com
SUMMARY
Technically skilled, industry Certified Database Administrator with over 25 years of experience, and in-depth knowledge of Information Technology (IT). Solid experience in planning, installing, configuring, and administering multiple facets of Enterprise platforms, operating systems and Oracle databases. Exceptional ability to adapt to new environments and deliver high quality products and services on schedule and under budget.
SECURITY CLEARANCES
Top Secret with CI Polygraph Clearance
TRAINING AND CERTIFICATIONS
CompTia Security+
ITIL Foundation v3 Certified
Oracle Database Administrator Certified Professional
Oracle Application Server Administrator Certified Professional
Oracle PL/SQL Developer Certified Associate
PROFESSIONAL EXPERIENCE
Jasint Inc. 10/2023 – present
Defense Information Systems Agency: Oracle DBA
Provided 24/7 database support in both NIPR/SIPR environment.
Worked with Unix Admin during OS patch.
Set up back-up jobs and performed daily database health checks.
Support applications and performed daily application checks in both NIPR/SIPR environment
Worked on database checklists for IAVA.
Quadrint Inc. 03/2023 – 10/2023
National Geospatial Agency: Oracle DBA
Provided 24/7 database support in both on-prem and AWS environment.
Applied Oracle quarterly and Linux patches on-prem and AWS environment.
Monitored resources and long running queries in production databases.
Worked and resolved databases’ vulnerabilities.
American Systems Inc. 02/2021 – 03/2023
General Dynamic Information Technology 10/2021 – 01/2022
Information Gateway Inc. 12/2019 – 09/2021
Defense Security Cooperation Agency: Oracle DBA
Provided 24/7 database support in both on-prem and AWS environment.
Performed DSAMS build and data refresh in AWS environment.
Applied Oracle quarterly patches in production/non-production in on-prem and AWS environment.
Worked on Jira cards for updating data in lower and production environment.
Migrated DSAMS database on-prem to AWS environment.
Applied Oracle quarterly patches in production and non-production environment in both on-prem and aws environment.
ManTech International, Annapolis Junction, Maryland 3/2017 – 12/2019
Transportation Security Administration Screening Gateway System: Oracle DBA
Provided 24/7 database support and performed daily database health checks.
Responsible for database incremental and full back-ups in production and non-production environment.
Applied Oracle quarterly patches in production and non-production environment.
Ran database back-ups and scripts for monthly application releases.
Worked with development team to resolve database-related issues and fixes.
Planned System International (PSI), Arlington, Virginia 2/2007 – 2/2017
Blood Donor Management System: Oracle DBA
Provided onsite engineering support for the National Enterprise Blood Management Service, Donor. Supported the Military Health System (MHS)/Military Treatment Facility (MTF) facilities.
Provided IT Help Desk support. Utilize Remedy to document open tickets, track progress, and update ticket with the resolution. Familiar with other ticketing systems such as Fogs Buz.
Performed Information Assurance (IA) scans and remediation using security tools, Retina, SCAP, Windows Gold Disk, and Database SRR.
Monitored and maintain patch management systems and report on patch status.
Managed the daily operation, issues and escalations. Provided 24/7 database support and daily system checks.
Managed, built, configured and troubleshoot mobile servers for the MHS/MTF facilities, using collaboration and remote support tools (WebEx, DCO).
Third Party Outpatient Collection System (TPOCS): Oracle DBA
Provided engineering support to the Military Health System (MHS)/Military Treatment Facility (MTF) facilities.
Managed Oracle database administration for the Third Party Outpatient Collection System. Enhanced database performance, perform restores, implement recovery procedures, handled performance tuning and conduct regular system backups.
Performed Information Assurance (IA) scans and remediation using security tools and scripts for the Protected Health Information Management Tool (PHIMT) database.
Installed, setup and configured Oracle databases, application server and Oracle ILearning for Centralized Credentials Quality Assurance Systems (CCQAS) project.
Planned, documented, tested and performed Database Upgrade from Oracle 11g Release 1 to Oracle 11g Release 2 for TPOCS.
Planned, installed, tested and documented the Oracle 11g Database upgrade for TPOCS. Performed Oracle 11g database upgrade for 60 plus TPOCS databases at Gunter Air Force base.
Configured, installed and deployed TPOCS database and application at Honduras Soto Cano Air Base.
Applied Oracle Quarterly Critical Patch Updates (CPU) to all development, test and production server.
Provided 24/7 database support and daily system checks for 120 plus military sites. Managed all issues and escalations.
Set up TPOCS database and updated rates for UBO conference.
Communicated with the Blade Operation Center (BOC) and remote sites for TPOCS database upgrade for National Provider Identification (NPI).
Supported the BOC in migrating the TPOCS databases to the Blade servers.
Developed SQL scripts to update annual rates.
Developed and installed Oracle 10g Application Server TPOCS portal.
Developed menus, forms, reports and website links in Oracle 10g Application Server Portal.
Coordinated security scan sessions with IA/Security team from PMO/DISA. Oracle 10g Database and Oracle 11g Database security scanned and developed SQL scripts to resolve the findings.
Installed and configured Oracle databases.
Neurocognitive Assessment Tool (NCAT): Oracle DBA
Planned, documented and performed NCAT database upgrade from Oracle 10g to Oracle 11g. Worked with the testing team to test the NCAT application on Oracle 11g.
Provided 24/7 database support.
Worked with the Gartner group for NCAT database server operating system upgrade recommendation. Documented the OS upgrade analysis and submitted to the government.
Updated all database-related documentations with NCAT entity relationship diagrams (ERD).
Partitioned database tables for better performance.
Installed and setup NCAT database in non-production instances.
Computer Sciences Corporation, Hanover, Maryland 11/2005 – 2/2007
Medicare Part D: Developer
Supported all production operation activities, with focus on integration and development of new and existing products and services.
Gathered the requirement from the business user and prepared the program specification and design document for the development of the MMC20/20 application.
Worked with the Call Center to verify and validate Medical Part D members’ addresses. Developed SQL script to update the members’ addresses in MMC20/20 Application.
Developed and maintained SQL script to update State/County Codes in MMC20/20 application.
Loaded members’ survey data into the Oracle database using SQL Loader.
Designed and developed a comprehensive Oracle PL/SQL package to extract members’ survey data based on CMS’s requirements and formats.
Designed and developed a comprehensive Oracle PL/SQL package to extract member information from different regions for the purpose of sending members the Evidence of Coverage letters.
Designed a daily Medicare Part D data extraction, validation and propagation process.
Developed Unix Shell scripts and cron jobs to automate the daily monitoring and reporting process, which included sending Appeals files to the Pega Development team and senior leadership.
Installed and configured CuteFTP to pull enrollment data files from multiple ftp servers.
Ensured best practice application to maintain security and integrity of data.
Pre-edited enrollment data by running an Oracle stored procedure. Loaded enrollment data into MMC20/20 application. Fixed incorrect enrollment data that error out during the pre-editing process and loading.
Created the Daily Part D Enrollment Received Summary report and sent to senior management.
Worked with stakeholders, and production teams across units to identify business needs and solution options.
IBM Corporation, Linthicum, Maryland 11/2004 – 11/2005
Centers for Medicare/Medicaid Services (CMS), Healthcare Integrated
General Ledger Accounting Systems (HIGLAS): Developer
Provided engineering support for the Centers for Medicare/Medicaid Services and Healthcare Integrated General Ledger Accounting Systems project.
Developed Daily Batch Processing Oracle stored procedure, SQL and AutoSys scripts for automating reports that capture daily successful production job runs for multiple workloads.
Developed Process Exceptions SQL and AutoSys scripts for automating reports that capture daily production job runs with exceptions for multiple workloads.
Modified AutoSys Sequencer Oracle stored procedure/SQL/Unix shell scripts to improve performance. Developed AutoSys Sequencer technical combined design, unit developer test plan, alpha test plan. Tested AutoSys Sequencer Oracle stored procedure/SQL/Unix shell scripts. Created builds to promote AutoSys Sequencer Oracle stored procedure/SQL/Unix shell scripts to Alpha, Beta and Production instances.
Developed Inbound Interface Move Files Unix AutoSys/Shell scripts to move inbound interface files to archive directories after the files are processed. Developed Inbound Interface Move Files unit developer test plan and alpha test plan.
Supported and maintained AutoSys Job Scheduler in development, alpha, beta and production instances.
Resolved Problem Management Record (PMR) and ManageNow tickets.
PricewaterhouseCoopers LLP / IBM, Fairfax, VA 7/1998 – 11/2004
U.S Navy, Military Sealift Command (MSC), U.S Army,
Military Traffic Management Command (MTMC) and Financial
Management Information Systems (FMIS): Programmer / User Support
Maintained and supported the FMIS system for both MSC and MTMC. Ensured all production applications ran successfully and resolved user execution errors and data communications problems/issues. Transferred billing data to Marines Corps, Navy, Army and Security Assistance Accounting Center as well as resolved FTP data and password issues.
Extracted Unit Level Billing data files, reports and source programs, and analyzed them for the team’s conversion effort.
Monitored and fixed manifest transmission and system back-up jobs in production.
Migrated MSC’s manifests to the Navy Marine Corps Intranet’s network. Monitored and fixed a Unix script that executes daily manifest upload job from MSC FTP Server to the mainframe system.
U.S Navy
Military Sealift Command (MSC) Cargo Project: Developer
Developed procedures/functions in PL/SQL to validate daily manifests that MSC received from Military Traffic Management Command (MTMC).
Developed Unix shell script to access MSC FTP Server, copy new manifests, move valid and invalid manifests and error log files into Unix directories for archive, and archive new manifests in MSC FTP Server. Calls an Oracle package to process new manifests.
Generated test data, tested the Cargo system with test data and actual manifest data. Developed deployment scripts and implemented the Cargo system at the client’s site.
Completed a Technical Systems Design and a Transition documents of the AS-IS system and the TO-BE system.
U.S Navy
Military Sealift Command (MSC), Historical Financial Data: Developer
Interviewed and communicated with users for new system requirements. Completed system requirements analysis (SRA) and technical system design (TSD) documents.
Designed the data mapping schemes, layouts and record relationships of the new Oracle database and developed Historical Financial Data (HFD)’s entity relationship diagram (ERD).
Developed SQL scripts to create HFD’s roles, users, tablespaces and grant Oracle privileges to HFD’s users
Restored 10 years of historical financial data, extracted record layouts and retrieved all legacy reports for conversion purposes from the mainframe. Loaded data into Oracle database. Performed data cleansing and standardizing the data dictionary
Designed, constructed and unit tested new HFD Discoverer reports from the four major sub-systems
Deployed the new system and conducted user acceptance test at the client’s site
TRW (Formerly BDM International, Inc.), Bethesda, Maryland 1/1998 – 7/1998
Marriott Hotel, FY 2000 (Y2K) Compliance: Programmer/Analyst
Maintained, supported and provided data queries, reports and data analysis using MS Access for the Y2K project.
Formatted, distributed and updated internal and vendors’ surveys to gather software compliance status.
Researched software compliance issues on the internet and from software vendors.
Developed procedures to track Marriott’s new applications, internal and vendors’ responses and phone support for survey inquiries.
U.S Department of Energy (DOE) 6/1997 – 1/1998
Technical Support Services: MS Access Developer
Designed data structure and developed logical data model for the Office of Science and Technology.
Developed, maintained and supported the OST database to warehouse DOE’s data.
Distributed the database to DOE’s employees and its contractors.
Migrated high-level and high visibility data from Excel spreadsheets to the OST database. Implemented and managed security levels for the database.
Provided technical training on OST database to BDM’s employees.
Corporate Information Services 1/1997 – 6/1997
Programmer/Analyst
Responsible for analysis, design, development, testing, maintenance, and implementation of various IT applications including: payroll, time and attendance, human resources, and operational reporting systems.
Loaded employee data into employee database. Managed and manipulated data to facilitate the distribution of time-sheets and paychecks.
Wrote Job Control Language (JCL) to run Mainframe Focus and COBOL programs to extract building lease data from PC-based application.
Created a roll-out package for BDM remote users for a time and attendance program.
First National Bank of Maryland 6/1996 – 10/1996
Systems Department: Programmer
Maintained COBOL system consisting of Order Entry, Invoicing, AR, AP, GL and Inventory.
Wrote a COBOL program to process transaction files, validated records, and updated customer master files; generated unposted transactions and daily transactions reports, and modified partitioned data sets.
TECHNICAL SKILLS
Operating Systems: Windows 2003/2008, Solaris 10
Languages: C, COBOL, PL/SQL, SQL, Unix Korn Shell
Database: Oracle 9i, Oracle 10g, Oracle 11g
Software: Quest TOAD 7.6, Erwin 7, Oracle SQL*Loader, Oracle SQL*PLUS, Oracle Enterprise Manager, Oracle Discoverer Admin/Desktop 4i/9i
AWARDS
PSI Excellence Award, 2011
PSI Excellence Award, 2010
IBM Corporation Excellence Award, 2004
BDM International Inc. Excellence Award, 1998
Contact this candidate