| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
email: EMAIL AVAILABLEPHONE NUMBER AVAILABLESUMMARYTechnically 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 CLEARANCESTop Secret with CI Polygraph ClearanceTRAINING AND CERTIFICATIONSCompTia Security+ITIL Foundation v3 CertifiedOracle Database Administrator Certified ProfessionalOracle Application Server Administrator Certified ProfessionalOracle PL/SQL Developer Certified AssociatePROFESSIONAL EXPERIENCEJasint Inc. 10/2023 presentDefense Information Systems Agency: Oracle DBAProvided 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 environmentWorked on database checklists for IAVA.Quadrint Inc. 03/2023 10/2023National Geospatial Agency: Oracle DBAProvided 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/2023General Dynamic Information Technology 10/2021 01/2022Information Gateway Inc. 12/2019 09/2021Defense Security Cooperation Agency: Oracle DBAProvided 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/2019Transportation Security Administration Screening Gateway System: Oracle DBAProvided 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/2017Blood Donor Management System: Oracle DBAProvided 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 DBAProvided 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 DBAPlanned, 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/2007Medicare Part D: DeveloperSupported 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 CMSs 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/2005Centers for Medicare/Medicaid Services (CMS), Healthcare IntegratedGeneral Ledger Accounting Systems (HIGLAS): DeveloperProvided 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/2004U.S Navy, Military Sealift Command (MSC), U.S Army,Military Traffic Management Command (MTMC) and FinancialManagement Information Systems (FMIS): Programmer / User SupportMaintained 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 teams conversion effort.Monitored and fixed manifest transmission and system back-up jobs in production.Migrated MSCs manifests to the Navy Marine Corps Intranets network. Monitored and fixed a Unix script that executes daily manifest upload job from MSC FTP Server to the mainframe system.U.S NavyMilitary Sealift Command (MSC) Cargo Project: DeveloperDeveloped 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 clients site.Completed a Technical Systems Design and a Transition documents of the AS-IS system and the TO-BE system.U.S NavyMilitary Sealift Command (MSC), Historical Financial Data: DeveloperInterviewed 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 HFDs roles, users, tablespaces and grant Oracle privileges to HFDs usersRestored 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 dictionaryDesigned, constructed and unit tested new HFD Discoverer reports from the four major sub-systemsDeployed the new system and conducted user acceptance test at the clients siteTRW (Formerly BDM International, Inc.), Bethesda, Maryland 1/1998 7/1998Marriott Hotel, FY 2000 (Y2K) Compliance: Programmer/AnalystMaintained, 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 Marriotts new applications, internal and vendors responses and phone support for survey inquiries.U.S Department of Energy (DOE) 6/1997 1/1998Technical Support Services: MS Access DeveloperDesigned data structure and developed logical data model for the Office of Science and Technology.Developed, maintained and supported the OST database to warehouse DOEs data.Distributed the database to DOEs 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 BDMs employees.Corporate Information Services 1/1997 6/1997Programmer/AnalystResponsible 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/1996Systems Department: ProgrammerMaintained 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 SKILLSOperating Systems: Windows 2003/2008, Solaris 10Languages: C, COBOL, PL/SQL, SQL, Unix Korn ShellDatabase: Oracle 9i, Oracle 10g, Oracle 11gSoftware: Quest TOAD 7.6, Erwin 7, Oracle SQL*Loader, Oracle SQL*PLUS, Oracle Enterprise Manager, Oracle Discoverer Admin/Desktop 4i/9iAWARDSPSI Excellence Award, 2011PSI Excellence Award, 2010IBM Corporation Excellence Award, 2004BDM International Inc. Excellence Award, 1998 |
