Data Architect Oracle Dba

Kamal Agnihotri

***** ***** **** *****

Boyds, MD 20841

Phone: 240-***-****

E:Mail: *******@*****.***

SUMMARY: 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, Oracle AS, ASM, Data Guard, RMAN, MySQL, NoSQL, PostgreSQL, 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, Oracle Discoverer, 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. 1989

M. S. Finance, Université Catholique de Louvain, Belgium. 1987

B. B. A. International Business, Schiller International University, Paris, France. 1983

SKILLS PROFILE:

Hardware: IBM-AIX, SUN Solaris, COMPAQ/HP, TOSHIBA, VM-Ware, Pentium PCs

Operating 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 Platform

Languages: SQL, PL/SQL, Unix Shell Script, XML, XACML, Python

RDBMS: Oracle 12c/11g/10g, SQL Server, My SQL, PostgreSQL

PROFESSIONAL EXPERIENCE:

4/2024 Present Optisources Inc McLean, VA Data Scientist Provision and administer Databricks instances on AWS cloud including network connectivity and security. Interact with systems using various programming interfaces (notebooks, SDK, CLI, Cloud Formation..) as well as UI components on Linux. Deploy, test and create Docker containers and images via Docker compose and builds on Windows Subsystem for Linux (WSL) development and Linux virtual machines. Patch, apply DISA compliance STIGs and remediating security vulnerabilities on Linux and Windows. Created Bash shell scripts to manage system jobs and backups. Manage CentOS, Azure, Ubuntu and IBM AIX servers. Manage Docker containers with multiple namespace versions for testing, training and production of Oracle, SQL Server, PostGreSQL and MongoDB databases. Managed NettApp Storage Area Network (SANs). Build and deploy Linux Cloud computing environments via AWS. Maintained clustered Splunk infrastructure, including search head and index cluster, deployment server, deployer, license manager, heavy and universal forwarders, Distributed Management Console (DMC). Performed routine maintenance tasks such as adding or deleting indexes, sizing volumes, adding data inputs, patching the OS and upgrade Spunk and automated routine tasks. Set Up Oracle AS. Created reports using Oracle Discoverer.

5/2023 to 11/2023 Zolon Tech Chantilly, VA Data Scientist/DBA

Data 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. Tracked software development lifecycle using JIRA. Participated in weekly scrum meetings. 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. Set Up Oracle AS. Created reports using Oracle Discoverer. Created development environment using git repository for code management. Used Jenkins to spin off virtual servers for continuous integration and automation of tasks. Collaborated with cross-functional teams to analyze and integrate data from multiple sources. Managed NettApp Storage Area Network (SANs). 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 Manager

Created 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. Set Up Oracle AS. Created reports using Oracle Discoverer. 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 Administrator

For 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. Managed NettApp Storage Area Network (SANs). 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. DBA

For 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. Managed NettApp Storage Area Network (SANs). 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. Set Up Oracle AS. Created reports using Oracle Discoverer.

11/2017 to 5/2018 TUVA Herndon, VA Data Scientist III

For 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 DBA

For CIA, 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. Set Up Oracle AS. Created reports using Oracle Discoverer. 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/Developer

For 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 /SME

For 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 Oracle’s 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.

01/2015 to 06/2015 Onyx Government Services, Fairfax, VA Sr. Data Architect, DBA

For Treasury Department, Financial Crimes Enforcement Network (FinCEN), modified existing database design using ER-WIN to improve financial reporting environment. Set Up Oracle AS. Created reports using Oracle Discoverer. 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 environments

6/2014 to 10/2014 CACI, Arlington, VA Principal Oracle DBA

For 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 Develop and implement strategic data architectures consistent with the Federal Enterprise Architecture artifacts for both public and private entities

5/2012 to 5/2014 Intelligent Decisions, Ashburn, VA Senior Oracle DBA/Team Lead /SME

Department of Justice, Office of Justice Programs, Financial Management System, lead data manager/project leader and DBA managing a team of 5 DBA’s 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. Set Up Oracle AS. Created reports using Oracle Discoverer. Responsible for maintaining 40 databases on 12 Sun Solaris. Expertise in installing, configuring, and maintaining MS SQL Server. 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 Manager

Department of Justice, Office of Justice Programs, Financial Management System, Lead DBA managing a team of 8 DBA’s 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. 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.

CONTINUING EDUCATION:

CompTIA Advanced Security Practitioner (CASP+) Security University Reston, VA 2024

Oracle Cloud Infrastructure 2022 Foundation Associates (1Z0-1085-22) Chantilly, VA 2023

Data Migrator Essential Information Builders Washington, DC 2017

Oracle Certified Associate 11g Oracle Certified Professional Boyds, MD 2014

CompTIA Security+ (SYO-301) Certification Exam Boyds, MD 2012

Oracle Certified Associate 9i Oracle Certified Professional Gaithersburg, MD 2003

Project Management USDA Graduate School Washington, DC 2001

Local Area Network Concepts USDA Graduate School Washington, DC 1999

References: Available upon request.

Contact this candidate