SUMMARY:

• Database migrations, ETL development with PL/SQL, data analytics & SQL tuning, and full cycle application development using Oracle APEX.
• Database configuration/maintenance, backup/recovery, redundancy, replication, disaster recovery, security, & performance tuning.
• AWS VPC configuration, Relational Database Service (RDS), Redshift, Database Migration Service, S3, EC2, Lambda with Python, CloudWatch/SNS, Identity Access Management (IAM), & CloudFormation.
• Configuration & management of SAP BusinessObjects. Universe, Webi report & Dashboard design and configuration.

SKILLS:

Database: Oracle 12c, Oracle RAC 11.1.0.7, MS SQL Server, Amazon Aurora, PostgreSQL, DynamoDB, and MySQL.

Cloud Services: AWS - Relational Database Service (RDS), Database Migration Service, VPC configuration, S3, Elastic Compute (EC2), CloudWatch, SNS, Redshift, QuickSight, CloudFormation, and Lambda.

Applications: SAP Business Intelligence Platform 4.2, Jupyter Notebook, Oracle Enterprise Manager 13c, Confidential 4.2, Apache Tomcat, Oracle Weblogic. Microsoft SharePoint

OS: Windows Server and Linux.

Programming: PL/SQL, Python, bash & DOS scripting, C++, Javascript, JSON, PHP, ASP

PROFESSIONAL EXPERIENCE:

Database Engineer

Confidential, Reston, VA

Responsibilities:

• Architected and implemented a financial BI reporting system based on Oracle databases and SAP BusinessObjects, tailored to BIA’s Financial Systems Division’s reporting requirements. Integrated data sources from various legacy systems as well as the current DOI’s main accounting system.
• Implemented extract, transform, and load (ETL) operations using PL/SQL programming along with O/S scripting to create a self - maintaining ETL environment. Extensive usage of Oracle Data Pump and SQL Loader for ad hoc data loading and migrations.
• Led several data integration projects to provide reporting capabilities between various systems, including DOI’s HR system, accounting system, and LDAP server. Coordinated between business entities and provided project planning.
• Planned, installed/configured, and maintain SAP Business Intelligence Platform (BusinessObjects)
• Work closely with report developers on designing universes, Webi reports and dashboards. Provide SQL tuning using explain plans and troubleshoot long running queries. Oversee change management, and perform promotions for production report deployments.
• Integrated the SAP BI Platform with Microsoft Active Directory, configuring single sign-on authentication using Kerberos and Vintela.
• Provide data connectivity and integration support for BI reporting between systems such as IBM Maximo and Crystal reports.
• Performed tuning for BI Platform services via manual configuration of Adaptive Processing Servers, Adaptive Job Servers and configuring Apache Tomcat web server.
• Maintain the entire BI environment including backup/recovery, licensing, and upgrade/patching.
• Work with Change Management team to create and execute implementation plans for new and existing database projects.
• Maintain reporting databases running on Oracle 12c, including backup/recovery, performance tuning, upgrade/patching, and STIG implementation.
• 2 years of hands on experience working in a team of AWS engineers in migrating reporting systems based on Oracle databases to Amazon’s Relational Database Service (RDS for Oracle/PostgreSQL/Aurora) and configuring business intelligence reporting tools such as AWS QuickSight.
• Designed and configured VPCs, subnets, Bastion hosts, security groups, and NACL. Used CloudFormation to deploy AWS infrastructure.
• Monitor and tune databases using Amazon RDS Performance Insights. Extensive usage of CloudWatch and SNS to monitor overall health of the cloud environment.
• Manage AMIs, snapshots, volumes and upgrade/downgrade AWS resources such as CPU, memory and EBS.
• Maintained more than 70 production/test database instances and application servers on Oracle 12c and 11g RAC including the following:
• Configured and maintained a two-node 11.1.0.7 RAC on ASM using NetApp storage on Red Hat Enterprise Linux 5 environment.
• Worked closely with Linux and NetApp administrators to configure Linux O/S and NetApp storage device for Oracle Clusterware and ASM.
• Maintain the RAC environment and monitor performance using OEM 11g Grid Control.
• Designed and planned database backup and recovery. Implemented backups using RMAN and OS scripting, and perform recoveries using RMAN, and Data Pump.
• Oversaw and supported an Oracle Portal system that consists of Oracle Universal Content Manager, Identity Management, WebLogic, Secure Enterprise Search, Web Center, and RAC databases.
• Made recommendations on the performance and security of Oracle Databases.
• Worked closely with Change Management for software release lifecycles and deploy applications into production environment.
• Migrated terabyte sized Oracle geospatial databases across O/S platforms.
• Performed upgrades and patching.
• Configured and managed Oracle Enterprise Manager 10g/11g/12c Grid/Cloud Control.
• Monitor and perform day to day database administration for over 70 targets including production and test databases.
• Create AWR baselines and periodically run ADDM/ASH for performance monitoring and tuning.
• Configure and manage incremental backups as well as image copies.
• Setup and configured MS SQL Server to work with COTS products. Perform backup and restore of SQL Server databases.
• Provided database administration for BIA wide financial reporting systems, based on Oracle databases and .NET framework. Performed SQL tuning, release deployments, data migrations and maintenance.

Application Developer

Confidential

Responsibilities:

• Designed and implemented a database application used for collecting/tracking/reporting proposals information for the BIA Office of Indian Self Determination. Provide data integration with DOI’s accounting system (FBMS) to meet reporting requirements for high level BIA managers.
• Provided a total solution including single sign-on authentication, role based authorization, user administration interface, and reporting against proposals data using SAP BI Platform.
• Configure and maintain Confidential, Oracle Web server, and database.
• Provided production support for Microsoft SharePoint including the following:
• Created and configured web applications, and site collections.
• Performed content deployment across development, test and production and setup jobs to sync up data between the three environments.
• Designed and implemented the backup and recovery plan for SharePoint.
• Assisted the migration between SharePoint versions.
• As an Application Administrator, performed the following:
• Configured and performed disaster recovery for each BIA application.
• Provide technical guidance and assistance in problem resolution for BIA’s custom Application Express (APEX) applications and COTS products.
• Configure and maintain various COTS products such as HP Quality Center, EMC Application Xtender, and Adobe Flash Media server.
• Configure and manage Oracle HTTP and Microsoft IIS web servers including configuration of SSL.
• Configured Media Wiki and Ideation servers in production environment.
• Supported the configuration of Microsoft Project server, including configuring Project Web Access sites, and managing user groups and privileges.

Senior Consultant

Confidential, Rockville, MD

Responsibilities:

• Performed system consolidation of OAM’s contract management system by migrating several database systems into one Oracle database. Performed system integration of a PowerBuilder application and Oracle Forms application with Oracle 10g database and Novell Netware file system.
• Provided production database support for the EPA Office of Acquisition Management (OAM)’s Integrated Contracts Management System (ICMS), and Small Purchases Electronic Data Interchange (SPEDI). Maintain 10 production databases ranging from Oracle 8i to 10g.
• Designed and implemented the strategy for setting up and managing applications users on OAM’s Windows 2003 Terminal Services Server.
• Installed and maintained a development environment running on SUSE Linux Enterprise Server 9 with Oracle 10gR2. Installed and configured Oracle 10g Designer Repository for the EPA OAM.
• Configured Oracle Application Server (10.1.2) with Oracle HTMLDB applications.
• Provided production database support on Oracle 9i databases
• As the Oracle Development Team Lead, planned and was responsible for the Oracle development configuration management (CM) process for bringing OPP to CMMI level 2. Created the Oracle Development Standards and Best Practices document for the Oracle Team. Led all PL/SQL development.
• Performed OPP’s software releases with PL/SQL coding and application deployment into test and production database.
• Configured and maintained Test and Development databases.
• Created reporting schemas and repositories for Business Objects on Oracle 9i and configured Business Objects on Windows 2003 Server and Oracle 9i.
• Installed and configured Serena Tracker/Version Manager on Windows 2003 Server using an Oracle 9i SCM instance.
• Performed migration of the EPA OPP’s database from Oracle 8i to 9i, while cleaning up database objects and reorganizing metadata tables for user roles and privileges. Implemented Oracle Virtual Private Database (VPD) technology in the database for fine grain security access.
• Configured Oracle 10g Application Server for the OPP’s Web Query tool and Reports Server.
• Installed HP Tru64 operating system on DEC Alpha server.
• As the lead PL/SQL and HTML developer, converted one of the EPA’s web services to be compliant to the Section 508 Accessibility laws. Led the requirement analysis and defined the scope of the project.

Confidential, Gaithersburg, MD

Oracle Developer

Responsibilities:

• Participated in an Oracle 7 to 9i migration project upgrading old versions of Oracle Forms.
• Developed an application that manages and tracks activities across the contract and timesheet, using Oracle 10g HTMLDB and PL/SQL. Used Oracle Designer for ERD.

Database Developer

Confidential, Melbourne, Florida

Responsibilities:

• Implemented a web-based NRL Personnel Database using Oracle Designer, Oracle Web Toolkit (HTP/OWA pkgs), and PL/SQL.
• Designed the logical/physical model for a web-based Actions/Tasking Database for the employees of NRL. Used Oracle WebDB and HTML/JavaScript to develop forms and reports, and PL/SQL. Programmed Java stored procedures and Javamail API to implement an automatic e-mail notification system.
• Migrated retiree data from a VMS legacy system into Oracle8i and provided custom SQL reports in aid of a statistical research of NRL retirees. Assisted in statistical analysis.
• Managed financial data migration from a flat-file VMS legacy system into Oracle 8i using SQL Loader and transformed data for Oracle RDBMS.
• Worked with government-set budgets, managed the purchasing of servers, software licenses, and other equipment.

Analyst

Confidential, Reston, VA

Responsibilities:

• Participated in a systems integration project of Alpha-Linux supercomputing clusters.
• Assisted the setup and configuration of a Linux cluster, which was built on Compaq Alpha workstations. Researched hardware components and made recommendations.
• Maintained the hardware and software aspects of the cluster by running patches, installing drivers, and troubleshooting hardware components.
• Ran benchmark codes written in Fortran 77 on the Linux cluster
• Designed a website as a marketing effort for one of the major business areas of Confidential .