| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
Street Address Dairy Farm DriveBoyds, MD Street Address
Phone: PHONE NUMBER AVAILABLEE:Mail: EMAIL AVAILABLESUMMARY: 20 + years experience designing, architecting, developing and implementing solutions using Oracle Technologies. Oracle Certified Professional Developer, DBA and Architect with in-depth knowledge of SQL, PL/SQL, Oracle RAC, ASM, Data Guard, RMAN, MySQL, NoSQL, PostgreSQL, Hadoop, MongoDB, Oracle Data Warehouse, Oracle Advanced Security, Oracle 9i 10g, 11i, 12c, 19c, 21c, Unix, SUN Solaris, Citrix, Windows, IBM AIX5. Expert in using, Oracle Golden Gate, OEM, RMAN, ETL, SQL Loader, TOAD, BI, Crystal Reports, MS SQL Server, ER-WIN, Business Objects, Data Migrator, Unix Shell Scripting. Developer having experience in Full Life-Cycle Software Development using Amazon Web Services and Agile methodology. Subject Matter Expert in developing and implementing systems security policy, guidelines, and procedures. Experience working with very large databases and troubleshooting. CompTIA Advanced Security Practitioner (CASP+) certification.Lead Oracle DBA/SME, providing database performance, architecture, data modeling, administration, business intelligence, and management consulting in support of projects. Pay attention to details. Excellent oral and written communication. Write and present training seminars to project managers and development staff to accelerate new technology integration. Provide technical support to customers and other team members including trouble shooting of problems on a daily basis. Examine current business functions and suggest strategies for technology development that streamline operations and automate data processes on site or remotely. Create Proof of Concept presentations and suggest integration solutions. Excellent analytical and problem solving skills. Ability to work on several projects concurrently and stay focused on the goals to be achieved for each project. Experience in managing projects using MS. Project. Oracle Cloud Infrastructure 2022 Foundation Associates (1Z0-1085-22)SECURITY CLEARANCE: Active Top Secret/SCI with Full Scope Polygraph.EDUCATION:M. B. A. Business Administration, Cornell University, Ithaca, New York. 1989M. S. Finance, Universit Catholique de Louvain, Belgium. 1987B. B. A. International Business, Schiller International University, Paris, France. 1983SKILLS PROFILE:Hardware: IBM-AIX, SUN Solaris, COMPAQ/HP, TOSHIBA, VM-Ware, Pentium PCsOperating Systems: Windows NT/XP/Vista/7, HP9000, Redhat Linux.Software Tools: Oracle Developer, Oracle Designer, Oracle Enterprise Manager, Oracle Data Guard, Oracle RAC, Oracle GolenGate, MS SQL Server, Oracle APEX, RMAN, ER-Win, ETL, Business Objects, Oracle Data-Mart, BI, Toad, Embarcadero DB Power Studio, MS Office, MS Project, MS Visio, Share Point, OEM Cloud Control, Syncfusion, Big Data PlatformLanguages: SQL, PL/SQL, Unix Shell Script, XML, XACML, PythonRDBMS: Oracle 12c/11g/10g, SQL Server, My SQL, PostgreSQLPROFESSIONAL EXPERIENCE:5/2023 to 11/2023 Zolon Tech Chantilly, VA Data Scientist/DBAData Scientist and DBA at National GeoSpatial Agency (NGA) working on implementing Oracle 19c on new services and upgrading existing services from Oracle 11g to Oracle 19c. Create detailed ETL procedures for Request Task Profile (RTP) and Rules and Policy Engine (RPE) within the Operational Environment to navigate schemas, import using conversion tools, UI/UX improvements and initial integration with Mission Manager Services (MMS) and Rules and Policy Engine (RPE). Created dashboard using Tableau. Responsible for drafting intelligence products and assessments. Performed quantitative and qualitative analysis and methodology development. Assessed complex information and worked with application developers, analytical teams and end users. Designed and implemented a Data Model for a new CRM (Customer Relationship Manager) system. Collaborated with cross-functional teams to analyze and integrate data from multiple sources. Developed and implemented data quality assurance process, including automated data validation. Created scripts using SQL and TOAD to automate creation of tables, tablespaces, indexes, stored procedures, packages, triggers, views, materialized views and ETL processes to load data. Install, configure and troubleshoot Maintained Oracle Instances on Oracle Cloud. Expert in creating and modifying SQL and PL/SQL packages, procedures, triggers, views and Materialized Views. Created and managed a MongoDB (NoSQL) database to track an inventory application.6/2022 to 05/2023 Oracle Corporation Reston, VA Data Scientist\Consulting Technical ManagerCreated automated procedure to auto start Oracle 19c database upon reboot of the host server. The host server is running Oracle Linux. Created Ansible Playbook to deploy database auto start script to several servers simultaneously. Debugged and tested the running of startup scripts on host servers. Upgraded from Oracle 11g to 19c. Set up Oracle Virtual Box 7. Installed Oracle Linux 8 on Oracle Virtual Box. Installed, configured and maintained PostgreSQL environment on RedHat Linux. Designed and developed data models and normalization process. Created scripts to automate creation of tables, tablespaces, indexes, stored procedures, packages, triggers, views, materialized views and ETL processes to load data. Install, configure and troubleshoot Maintained Oracle Instances on Oracle Cloud. Created Oracle GoldenGate 12c replication across heterogeneous database servers and ensure data synchronization. Proficient in using AWS native services like Lambda, Step Function, S3, and EC2. Conducted interviews with data source owners and end users to create source-to-target mappings, data dictionaries, data definitions, and metadata. This included cataloging existing data sources and those planned for future enhancements and inclusion.06/2020 to 5/2022 BAE Systems Rockville, MD Data Scientist\Sr. Database AdministratorFor FBI responsible for maintenance, administration and performance of Oracle, and MySql databases in production, training and development environments. Ensured that Oracle Database Vault and Data Guard were working as expected and that the logs were crossing over in real time. Updated CAPS database from Oracle 11g to 19c. Participated in daily SCRUM meetings. Prepared detailed step-by-step process for applying Oracle Quarterly patches. Applied patches to Oracle and SQL Server. Set up PostgreSQL 11 environment. Created tables, tablespaces, as requested by developers. Created MongoDB environment. Set up AWS DMS and migrated Oracle Database to AWS Cloud. Provision, manage, migrate and support AWS on EC2 and RDS cloud for backups, software patching, automatic failure detection, and recovery. Provided analysis using Business Objects and BI. Migrated, updated and transformed data using ETL. Design and build enterprise data analytics strategy and governance standards. Offer insights to the team responsible for designing and developing a solution that empowers skilled users to conduct research using artificial intelligence (AI) and machine learning (ML) capabilities.06/2018 to 05/2020 General Dynamics-IT Herndon, VA Data Scientist\Sr. DBAFor National Center For Medical Intelligence (NCMI) supported Global Medical Intelligence Knowledge Enterprise (GMIKE) 3.0.0 utilizing PostGreSQL 9.6 on CentOS 6.9. This system does assessment on disease risk, chemical, radiation and physical hazards as well as medical infrastructure. Set up test GMIKE database on Windows 10 platform for trouble shooting and supporting the development process. Created ETL Process to ingest data. Provided analysis using Business Objects and BI. Created reports using Crystal reports Participated in Scrum meeting and supported the project using Agile methodology with government Project Lead and Project Managers.11/2017 to 5/2018 TUVA Herndon, VA Data Scientist IIIFor Federal Bureau Of Investigation (FBI), for Counter Terrorism Advanced Projects Unit (CTAPU) designed programs to extract information from social media sites of possible terror suspects. Create data models in SQL Server and Oracle, and import data from Access, Excel or unstructured data. Setup PostGreSQL9 environment. Created users and supported development in PostGreSQL. Wrote queries to extract information from databases. Implemented daily data inputs into Stats Tracker program and generated reports. Provided analysis using Business Objects and BI. Created reports using Crystal reports Using Python, extracted information from subpoenaed phone records of suspected individuals.06/2017 to 10/2017 Booz Allen Hamilton Washington, DC Sr. Oracle DBAFor Federal Bureau Of Investigation (FBI), Insider Threat project, setup Oracle ASM and Oracle Database in Red Hat Linux. Monitor Oracle 12c and Oracle 11g Databases in production, development and test environments. Set up Oracle Dataguard. Switched over Primary to Standby and then Standby to Primary. Apply security patches. Write Shell scripts to run oracle programs and procedures after hours. Created ETL scripts to populate target tables. Use Oracle 13C OEM Cloud Control to monitor databases. Install agents on new databases to be monitored. Use TOAD to monitor databases. Work with Oracle Support to get answers to specific questions. Provide tier three support to users.09/2016 to 05/2017 David Hale Associates, Washington, DC Senior Oracle DBA/DeveloperFor Federal Bureau Of Investigation (FBI), Financial Reporting Section, Oracle DBA and developer maintaining Oracle 11g and Oracle 12C databases. Responsible for creating and maintaining hundreds of Materialized Views in development, training and test environments. Modified and created PL/SQL packages, procedures, functions, triggers to accommodate new functionality for improved financial reporting. Developed PL/SQL packages to manage backend CRUD operations consistent with application functionality. Modify code to accommodate new requirements. Troubleshoot performance issues. Use Data Migrator to create new schemas, and dimensions. Translated business processes, information exchanges, and policies into working XML and XACML data solutions.07/2015 to 08/2016 SOTERA, Herndon, VA Senior Oracle DBA/Developer /SMEFor Federal Bureau of Investigation (FBI), Innocence Lost project monitoring exploited children, created 2 Node Oracle 11204 RAC on Sun Solaris 10 in a virtualized environment. Managing 4 Node Oracle RAC, Grant Management System (GMS) production database. . Installed 2 Oracle Dataguard Instances on Oracle 11202 on RedHat Linux. Modified administrative package to assist with security, user management and encryption requirements using Oracles dbms_crypto package. Maintained 3 environments, applied Oracle Security patches, upgraded existing databases to current versions. Assisted application developers. Provided analysis using Business Objects and BI. Created reports using Crystal reports Using Er-Win and Visio redesigned sections of Oracle database to allow additional capability for NBIMS database. Responsible for databases stay up to par in terms of Oracle versions, CPU and PSU patches in production, development and training environments. Monitoring oracle databases using OEM, TOAD. Created Logical and Physical data models for data warehouse repository. Set up MySQL Test Environment on Windows 2012. Upgraded from Oracle 11201 to Oracle 11203. Apply quarterly Oracle security patches. Worked with Oracle Support and opened Services Requests (SR) for problem resolution. Set up MongoDB, in test environment and demonstrated the capabilities and advantages it offers over the traditional database. Provide technical support to customers and other team members including trouble shooting of problems on a daily basis. Installed, configured and tested Oracle APEX 4 on personal computer. Setup database using PostgreSQL. Worked with Syncfusion big data platform for Hadoop. Guide strategy development and feasibility assessments affecting complex data systems and architectures Aligned data modeling methodologies, standards, and guidelines using XML-based schema to mission business processes and services. Migrated, updated and transformed data using ETL01/2015 to 06/2015 Onyx Government Services, Fairfax, VA Sr. Data Architect, DBAFor Treasury Department, Financial Crimes Enforcement Network (FinCEN), modified existing database design using ER-WIN to improve financial reporting environment. Created dataflow diagrams and complex stored procedures, Triggers, packages, functions, sequences to ensure capture and display of relevant information. Participate in technical discussions as SME with senior staff. Propose technical solutions and action plan to achieve desired objective. Help in preparing technical plan to be presented to Government. Team player, with excellent communication skills. Created a subset Data Model from existing Data Model for a specific need using ER-WIN. Normalized database to the third Normal Form. Presented database design to stakeholders and incorporated improvements. Imported data using IBM Websphere. Created PL/SQL procedures to extract relevant info from the database. Improved database response time. Designed, coded, tested and created Members application using Oracle Apex 5 for a non-profit organization. Derive data models consistent with functions, objects and/or classes for development and test environments6/2014 to 10/2014 CACI, Arlington, VA Principal Oracle DBAFor Secret Service, Inventory Management System, principal database administrator and Oracle Application Server administrator maintaining 5 environments and over 20 databases on Redhat Linux. Cloning databases and Oracle E-Business suite (APPLTOP) from Production to Development, Training and Test environments. Apply patches to databases and Application server. Support Sunflower and Prism applications. Administer Prism on Windows 2003 and 2008 environments. Apply Prism patches. Monitor and administer databases and application servers using OEM. Backup, restore and recover databases using RMAN. On my personal computer created Parking Space Oracle Apex application. Formulated SQL queries, functions, procedures as per customization requirement for APEX. Develop and implement strategic data architectures consistent with the Federal Enterprise Architecture artifacts for both public and private entities5/2012 to 5/2014 Intelligent Decisions, Ashburn, VA Senior Oracle DBA/Team Lead /SMEDepartment of Justice, Office of Justice Programs, Financial Management System, lead data manager/project leader and DBA managing a team of 5 DBAs and several support staff. Responsible for managing all aspects of production database administration including but not limited to monitoring and performance tuning, back-up and recovery, security management, setting up alerts via OEM and cron jobs. Responsible for maintaining 40 databases on 12 Sun Solaris. Maintain MS. Outlook, Help Desk Ticket Management System (HEAT) and CITRIX management on 5 Microsoft SQL Servers. Monitoring SQL server databases using Embarcadero. Expertise in installing, configuring, and maintaining MS SQL Server. Designing, deploying, tuning, and maintaining database systems. Supporting application development. Trouble shooting and Responsible for ensuring payments are processed in and out of the Grants Management System (GMS). Responsible for all production databases in a 24/7 environment.4/2006 to 4/2012 ASCI, Boyds, MD Senior Oracle DBA/Team Lead /SME/Project ManagerDepartment of Justice, Office of Justice Programs, Financial Management System, Lead DBA managing a team of 8 DBAs and several support staff. Installed 5 Oracle Dataguard Instances on Oracle 10204 and 11202 for DOJ on IBM-AIX platform. Work with application developers to ensure data integrity on Primary and Logical Standby Databases. Performance monitoring and Tuning of all databases using Oracle Grid Control, TOAD and AWR Reports. Redesigned the Database using ER-WIN. Created roles, privileges, functions to control access for the Momentum (CGI) application. Created Workgroup mode and Enterprise mode environments for Business objects. Created and modified Reviewed final software installation and system plans for additional security risks not identified during proposal stages and recommended work process changes and general design and programming techniques to alleviate potential security problems. Installed two node Oracle RAC. Migrated, updated and transformed data using ETL Maintain the Apply Security Patches (CPU Patches) and Upgrade patches to Oracle Databases and Application Servers. Upgraded Oracle Database from 9.2.0.8 to 10.2.0.3 10 to 11202 Upgraded Oracle Application Server from 9.2.0.3 to 10.1.2.0 to 11.2.1 Set up a 2 Node Oracle RAC.2/2005 to 3/2006 Avanco International McLean, VA Project ManagerUS Armys Personnel Database, Keyview Systems Manager, responsible for maintaining US Armys Personnel Database for creating reports. Roles and responsibilities include; plan, direct, and co-ordinate a cross-functional team activities to manage and implement project and interrelated programs from contract/proposal initiation to final operational stage using MS Project. Leading a Data Warehouse project to redesign an existing antiquated system. Monitored SyBase Database. Designed a system that creates and sends out reports without human intervention and help save thousands of man hours. Supervise 7 developers and 3 DBAs. Provide technical support to customers and other team members including trouble shooting of problems on a daily basis. Worked with Oracle Support and opened Services Requests (SR) for problem resolution.9/2004 to 1/2005 TEK Systems/BearingPoint Washington, DC Oracle DBA/Senior ConsultantFor Marine Core (DOD), Oracle DBA responsible for 7 Servers and 3 environments, namely Production, Development and Testing. Managed Oracle 9i migrating to Oracle 10g. Technical expert in using OEM, RMAN and TOAD to perform migration, backup and restoration of databases. Provided analysis using Business Objects and BI. Created reports using Crystal reports Created Data Model using ER-WIN. Loading and transporting data using SQL Loader. Support application developers. Ability to work effectively with all levels of management. Worked with Oracle Support and opened Services Requests (SR) for problem resolution. Established appropriate metrics for measuring key program criteria. Managed setting up of Oracle Data Guard Environment.6/2004 to 7/2004 Binary Consulting/SRA International Fairfax, VA Oracle DBA/Senior ConsultantLead DBA/Developer responsible for monitoring production, development and testing Oracle Databases on 15 servers. Performing backup and recovery using RMAN. Monitored DB2 Database. Create instances and migrate data on new instances. Migrating, upgrading and cloning databases. Used MS Project to support and monitor several application developers for the National Guard (DOD) . Ability to work effectively with all levels of management. Facilitated the creation of communication plans, ensuring that appropriate information is exchanged among key stakeholders. Identified and recommended contingency measures.CONTINUING EDUCATION:CompTIA Advanced Security Practitioner (CASP+) Security University Reston, VA 2024Oracle Cloud Infrastructure 2022 Foundation Associates (1Z0-1085-22) Chantilly, VA 2023Data Migrator Essential Information Builders Washington, DC 2017Oracle Certified Associate 11g Oracle Certified Professional Boyds, MD 2014CompTIA Security+ (SYO-301) Certification Exam Boyds, MD 2012Oracle Certified Associate 9i Oracle Certified Professional Gaithersburg, MD 2003Project Management USDA Graduate School Washington, DC 2001Local Area Network Concepts USDA Graduate School Washington, DC 1999References: Available upon request. |
