SUMMARY

• 11+ years of experience in the field of Database Technology with experience in designing, developing, implementing different Databases technologies.
• Enabling Load Balancing in a Multi - Tier Architecture
• Import/Export and Expdp/ Impdp utilities.
• Monitor nightly Database backup Jobs and necessary actions for failed backup jobs including script corrections, disk space monitoring and Database availability.
• Setup procedure for Database statistics gathering - Frequency, Best Time of the day to execute stats gathering jobs, correct level of gathering statistics.
• In-depth understanding on oracle utilities SQL Trace, Explain Plan, TKPROF, Statspack, AWR, Analyzer and DBMS STATS in Performance Tuning.
• Creating roles, profiles, privileges and assigning roles to users.
• Extensively worked on monitoring and optimizing the database by performance tuning.
• Hands on experience with various tools like SQL*Loader, TOAD, Oracle SQL/PLSQL Developer and Oracle Enterprise Manager (OEM).
• Worked extensively in migrating on-prem oracle dbs to AWS.
• Extensive experience in Installations, configuration, Cloning, Security, Patching, Upgrades.
• Performance tuning of the database (Memory Allocation Tuning, I/O Tuning, and Tuning Contentions) using TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ADDM.
• Database Upgradation, Migrations using traditional way (DBUA, Manual and export/import) as well as non-traditional way (Transportable tablespaces).
• Migrated databases from Non-ASM file system to ASM file system using RMAN.
• Upgrading and Migration of Oracle database to higher version and other platforms using manual method and traditional Export/Import, datapump & Transportable Tablespace (TTS).
• Experience in coding SQL, PL/SQL package, function, stored procedure, triggers, and materialized view for Oracle database.
• Worked on AWS DMS for Migrating Oracle databases.
• Implementation of Enterprise wide Database Monitoring enabling Oracle 11g Enterprise Manager Grid Control. One stop solution for monitoring every single Oracle Database within the global enterprise.
• Database Backup and Recovery using Vertica and RMAN including duplicating/cloning Databases across with point-in-time recovery option.
• Responsible for establishing Security Baseline in the entire enterprise on OCI
• Responsible for building a POC Ravello migration on-prem VM to OCI
• Installed Oracle Golden Gate 11g, Implemented uni-directional and bi-directional replication.
• Strong experience in RMAN, fail-over/fail-back/switch-over of standby databases
• Experienced in Installation and Configuration of Oracle Primary and Standby (Dataguard) Database and Switchover/Switchback of Database in 10GR2 /11GR2 RAC, 12c RAC
• Provided support to the DBA Team for the architectural design, build, deployment, implementation of Oracle Golden Gate on RAC and Data Guard
• Experience in multi-node and RAC environments including configuration of PCP.
• Experience with various database Backup and Recovery methods like PITR, TSPITR, Export/Import and Flashback Technologies.
• Work with DBA Team in the integration of DBV 11gr2/12c with EBS and OFM
• Setup and install Oracle EBS 12c Integrated SOA Gateway (ISG0 for 12.2
• Highly Experience in Tuning database in RAC / Non-RAC environment for better Performance.
• Expertise in Configuring RMAN with Catalog /No-catalog and worked on Point-In-Time Recovery and flashback.
• Plugging the tablespace between different platforms using Cross platform transportable tablespace Utility.
• Collecting performance statistics using Statspack/AWR (Automatic Workload Repository) and ADDM (Automatic Database Diagnostic Monitor).
• Support database provisioning and maintenance to accomplish task objectives.
• Used TKPROF utility and Explain Plan for tuning SQL queries.
• Experience in regular DBA activities such as Upgrades, Patches, TAR support, Cloning, Backups and Recovery Manager, Performance Tuning, Capacity Planning, and documentation.

PROFESSIONAL EXPERIENCE

Confidential

Database Engineer

Responsibilities:

• Migrated on-prem oracle, mysqldbs to AWS cloud -EC2, RDS, AWS Redshift,
• Configured New relic tool for monitoring AWS and On-Prem dbs.
• Monitoring of tablespaces, memory structures, rollback segments, logs, and alerts.
• Effective leadership skills are crucial, as Application Architects tend to lead project development teams in areas of application software design, development, testing, and implementation.
• Strong verbal and written communication as well as interpersonal skills
• Installed/Configured PostgreSQL Version 9.6, 10 and 11 and monitored and managed them using PgAdmin and PSQL.
• Migrated and reorganized large volumes of data. Created and maintained batch pipelines using PL/SQL. Analyzed cost, performance, and storage analysis of data intensive workloads.
• Created multiple ETL pipelines using Python, PostgreSQL, DBMS, SQL, PL/SQL, MySQL, AWS Such as RDS, EC2, S3, EBS, SQS, Java, JDBC SQL and PL/SQL for trickle data load into REST APIs.
• Used PySpark (Hive SQL interface) to convert existing Exadata PL/SQL pipelines to data lake/Spark.
• Performed ad-hoc data analysis and data validation.
• Performed backup using pg Backrest, pg dump and pg Basebackup.
• Created and managed database objects such as users, roles, indexes, views, sequences and permissions.
• Migrated oracle databases to AWS RDS PostgreSQL using SCT Data Migration Service (DMS) Tool. Migrated Informix to postgres azure (paas)
• Migrated from oracle to PostgreSQL on-premise using mtk.
• Route 53 (DNS), Cognito Authentication, Amplify console, GitHub configuration, API Gateway, Microservices, DynamoDB.
• Ability to build Docker containers and docker compose environments
• Migrated 12c oracle databases to AWS.
• Facilitate joint planning activities with stakeholders to develop a combined project schedule
• Develop and manage the project plan including the schedule of activities and deliverables/artifacts.
• Strong experience in analyzing, architecting, designing, installing, configuring, administrating, operating, monitoring, following the standards maintenance of databases.
• Ability to work in a team and individually in a complex project environment,
• Oracle 12c with good experience in PDB/CDB Understanding of the Core Architecture
• Comfortable working with AWS CLI and knowledge of JSON and/or PowerShell scripting,
• Experience deploying dedicated infrastructure vs shared as well as identifying best instance type based on project requirements.
• Good understanding of Azure Policy Management, Azure Monitor, Azure Backup and Recovery Services.
• Proven understanding of micro-services-oriented architecture and extensible REST APIs
• Experience designing, developing, and deploying Websites and/or Web applications, including configuration, installation, maintenance, and site-specific Web development languages and relational databases.
• Experience using Web development and graphic tools, as well as, Web Server and database administration,
• Design, architect, develop, scale, and improve data platform and its services,
• Build, support and improve the continuous integration / delivery pipelines for the services and jobs,
• Diagnose and debug issues in development, staging and production environments.
• Collaborate with product/program managers, software developers and analysts in an open, creative environment.Platform Automation experience with Terraform, Ansible, ARM.
• Implement AWS Auto Scaling for monitoring Ec2 instances
• Implement high level Security Groups to control an inbound and outbound traffic
• Infrastructure services such as but not limited to EC2, Route53, S3, Workspace, CloudWatch, CloudTrail, Automation deployment, RDS, AWS Redshift, Lambda, IAM & Governance, Organizations, EBS Storage & Snapshots replication, Tagging, VPCs, Security Groups, Load Balancers, VPN Gateway, Data and Server migrations, Cloud Endure, and AWS CLI.

Confidential, ASHBURN, VA

Database Engineer

Responsibilities:

• Supporting critical and non-critical environment with Seven different applications,
• Configuring and scheduling of Oracle database backup using Vertica and RMAN.
• Migrated on-prem oracle, mysql dbs to AWS cloud -EC2, RDS
• Configured Newrelic tool for monitoring AWS and On-Prem dbs.
• Monitoring of tablespaces, memory structures, rollback segments, logs, and alerts.
• Monitor and fully analyze performance issues in production Oracle databases by using OEM, ASH/AWR/ADDM, EXPLAINPLAN and TKPROF tools.
• Built OA Framework pages (using Jdeveloper 10g, for EBS R12.1.x, R12.2.x).
• Install, configure, test, monitor, upgrade, and tune new and existing PostgreSQL/EnterpriseDB databases.
• Created ETL design data reconciliation strategy, data archival strategy and design mapping sheets.
• Implemented ETL framework according to PostgreSQL, DBMS, SQL, PL/SQL, MySQL, AWS Such as RDS, EC2, S3, EBS, SQS, Java, JDBC specification with emphasis to data loss detection.
• Automated majority of business data processes using common framework reducing execution time 2x.
• Created multiple Oracle database objects: tables, views, triggers, sequences, materialized views, functions, procedures, and packages.
• Written new and optimized existing SQL queries and PL/SQL code.
• Created new, modified existing, and tuned and PostgreSQL, DBMS, SQL, PL/SQL, MySQL, AWS Such as RDS, EC2, S3, EBS, SQS, Java, JDBC optimized complex Python, SQL and PL/SQL code.
• Migrated core reporting functionality from Oracle to Redshift. Created multiple ETL jobs to support it.
• Installing and Configuring PostgreSQL from source or packages on Linux machines.
• Experience designing database structures, indexes, views, partitioning.
• Implementing backup and recovery (Logical and Online).
• Setup and maintenance of postgres clusters utilizing streaming replication
• Performing schema management, database sizing, maintaining privileges.
• Extensive experience with Warm Standby (PostgreSQL 9.x and earlier), and Hot Standby (PostgreSQL 9.x and greater).
• Performance monitoring and optimization
• Installing and configuring Object level replication like Slony etc.
• Installing and configuring connection-pooling tools like Pgbouncer and pgpool etc.
• Installing and monitoring PostgreSQL database using the standard monitoring tools like Nagios/zabbix etc.
• Implemented Oracle Multitenant EBS SCM features like Inventory Organizations, Parameters.
• Partitioning Tables, Rebuilding of Indexes, Securefiles, DBLINKS, Materialized Views, Store Procedures, Triggers, and constraints.
• Used SQL TRACE, TKPROF, EXPLAIN PLAN utilities for optimizing and tuning SQL queries.
• Setting up of Oracle and Application user accounts and passwords, monitoring application securitySetup, ConfiguredOracleData Guard using physical standby database.
• Implemented Dataguard / Standby (with FAL), performed switchover/failover.
• PatchedOracledatabases using OPatch utility.
• Responsible to improve the performance by Using the Hints, Indexes, Explain Plan,
• Performance tuning of SQL statements using STATSPACK, TKPROF, Explain Plan and SQL TraceSetup and documentedGolden Gate replication on 10g, 11g and 12c for support team.
• Worked with RAC implementation team. Added nodes.
• Table space management including, adding/resize data files, allocated quotas to user and managed disk space.
• Experience in coding SQL, PL/SQL package, function, stored procedure, triggers, and materialized view for Oracle database.
• Migrated 12c oracle databases to AWS.
• Creating user with assigning profile and privileges, revoking them as well as required.
• Performing database migration from Sun Solaris to Linux, and from Linux to Oracle Cloud Infrastructure (OCI) using traditional data pump, Golden gate for zero downtime.
• Migration oracle database on-prem linux86 64 platform to Oracle Cloud Infrastructure (OCI).
• Migrate databases from on-prem to OCI Database using Export/Import.
• Create your encrypted application table spaces.
• Migrated EC2 instances across different AWS regions
• Install, monitor, and maintain PostgreSQL & MySQL software, implement monitoring and alerting, implement backup and recovery processes, provide system and SQL performance tuning, and assist in business process integration with various data sources.
• Work with the DBA Team in reconfiguration of DBV 11gr2 and 12c on Exadata+RAC+Data Guard on RAC+Data Guard.
• Setup and install Oracle EBS 12c Integrated SOA Gateway (ISG) for 12.2
• Migrate oracle databases from on-prem to PostgreSQL platform onAWS RDS.
• Disabling indexes during migration for zero downtime. Modifying and converting database objects from source database to the target PostgreSQL.
• Provide database and systems administration support for software deployment operations, data migration and conversion, and other critical production operations support activities as required
• Troubleshooting, Load Balancing, Clustering, Deploying Applications, Performance Tuning and Maintenance. Work with vendors and developers for application related issues.
• Installed the application on AWS EC2 instances and configured the storage on S3 buckets.
• Implemented and maintained the monitoring and alerting of production and corporate servers such as EC2 and storage such as S3 buckets using AWS Cloud Watch.
• Configured an AWS Virtual Private Cloud (VPC) and Database Subnet Group for isolation of resources within the Confidential RDS Aurora DB cluster.
• Working with the App server DBA and Oracle DBA to resolve application problems.
• Performing Migrations of the code between test QA and production environments.

Confidential, Matawan, NJ

Database Engineer

Responsibilities:

• Worked in an environment comprising 200 databases with the largest databases each of size 5 TB.
• Performed periodic refreshing/cloning of production databases to development & testing databases using RMAN Duplicate database.
• Extensively worked on complete & incomplete recoveries of the databases including Point intime recovery (PITR) and Tablespace point in time recovery (TSPITR) using RMAN utility.
• Involved in performing upgradation from Oracle10g to Oracle 11.2.0.3 RAC database.
• Applied PSU Patches (10.2.0.3, 10.2.0.4) as a part of maintenance activity.
• As a Oracle EBS Technical Consultant, contributed in design and development of AP/IBY/SLA/GL/PO Interfaces.
• Worked with business users, collected and documented reqs, brds, frds, tsds.
• Designed and implemented IOB OATS report for 5 random order families using Python and PL/SQL.
• Designed and implemented solutions to submit, review, and correct oats FORE files and oats ROE events.
• Implemented application for review of historical data submissions, PostgreSQL, DBMS, SQL, PL/SQL, MySQL, AWS Such as RDS, EC2, S3, EBS, SQS, Java, JDBC corrections, and order/executions.
• Created Contlol-M schedules for one time and recurring execution of OATS workflows.
• Created multiple Python and PL/SQL APIs for reporting dashboards
• Participated in modeling sessions, technical design reviews, functional spec reviews, code reviews.
• Created new, modified existing, and tuned and optimized complex Python, SQL and PL/SQL code parsing and loading vendor XML files.
• Provided L3 production support of Depot.
• Extensively used Data pump, conventional export/import utilities for loading data to & from databases, logical backups, and migration of databases.
• Installing and configuring Nagios check postgresql.pl plugins for Monitoring PostgreSQL instances effectively.
• Configuring log analyzation tools like pgfouine and pgbadger etc.
• Removing the Index bloat concurrently to improve the performance.
• Query optimization and troubleshooting of PostgreSQL/EnterpriseDB
• Database migrations of non-EBS Oracle Multitenant into OCI.
• OCI security permissions, backup and disaster recovery.
• Fixed various database performance issues using Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM) and Active Session History (ASH).
• Extensive experience working on HVR as a real-time database replication software. Ability to create table and load using HVR software and configure HVR for integration.
• Setting up the HVR Channel in Linux setup as well as Confidential AWS server. Setting HVR configuration for Change Data Capture (CDC). Reporting and monitoring in moving high volumes of data between databases. Experience with data replication, ETL/ELT tools, API technologies and analytics using HVR or Talend.
• Performing Migrations of the code between test QA and production environments.
• Developing the standards and tuning metrics and alert thresholds.
• Creating standardized alerts for telephone/pager devices for exceptional performance thresholds
• Experience supporting Risk Management Framework (RMF) activities to include documentation and resolving database related POA&M findings.
• Provide database and systems administration support for software deployment operations, data migration and conversion, and other critical production operations support activities as required.
• Manage Oracle/MySQL databases (Primary) and Vertica/Druid (Secondary) through multiple product lifecycle environments, from development to mission-critical production systems in both on-prem and AWS environments.
• Prior experience demonstrated thorough knowledge and progressively responsible experience in implementation and maintenance of large-scale OLTP, OLAP, and data warehouse systems in mission-critical environments including, but not limited to, Oracle or MySQL.
• Confidential Web Services - Create/manage/optimize - EC2/RDS instances, Cloudwatch, S3 buckets, Jenkins jobs, SNS, Route 53.
• Assist in planning and performing database upgrades and migrations Experience with AWS technical essentials such as RDS, EC2, S3, security, and networking.

Confidential - Marlboro, MA

Database Engineer /Lead

Responsibilities:

• Performed Installation and configuration of Oracle 10g, 11g, and 12c database on HP-UX platform.
• Worked with different middleware & IDM teams to resolve their issues from the database side.
• Experience in Replication of Data bases using Oracle Streams and Logical Standby.
• Implemented and managed optimum physical database design (tablespaces, datafiles, extents, redo logs, archive logs) and assessed database capacity by monitoring online storage, growth, and file system space, in adherence to the Optimal Flex Architecture.
• Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical IO and Memory Usage.
• Maintained multitenant databases on OCI.
• Configured open ports on OCI for GDS.
• Monitoring Day-Day Backups, Log's and recovering them as per the requirement. Utilized LOG MINER Technology and applied Application Database Transactions on other Databases.
• Developed Shell scripts, SQL & PL/SQL scripts for monitoring GoldenGate processes and their stats running on 60+ servers from one single database repository providing table level granularity with end-to-end replication map and thus maintain history of all GoldenGate processes for later analysis.
• Performed Oracle Schema level and Table level data migrations using Datapump EXPDP/IMPDP.
• Configuring and scheduling of Oracle database backup using RMAN.
• Monitoring of tablespaces, memory structures, rollback segments, logs, and alerts.
• Monitor and fully analyze performance issues in production Oracle databases by using OEM, ASH/AWR/ADDM, EXPLAINPLAN and TKPROF tools.
• Used SQL TRACE, TKPROF, EXPLAIN PLAN utilities for optimizing and tuning SQL queries.
• Setting up ofOracleand Application user accounts and passwords, monitoring application securitySetup, ConfiguredOracleData Guard using physical standby database.
• Implemented Dataguard / Standby (with FAL), performed switchover/failover.
• Worked with RAC implementation team. Added nodes.
• Tablespace management including, adding/resize data files, allocated quotas to user and managed disk space.
• Helpwriting database triggers, packages, procedures, functions, utilities for application development.
• Implemented backup strategies using hot/cold, exp/imp used on the business req.
• Cloning databases using scripts as well as RMAN and performed Tablespace point in time recovery (TSPITR) using RMAN.
• Maintained the data integrity and security using integrity constraints and database triggers.
• Provided 24X7 supports for all the production and development databases.
• Successfully performed migrations from Oracle 10g/11g to 11gR2 RAC (Real Application) Database.
• Designed and implemented different backup strategies like Cold, Hot, MAN with Flash Recovery Area and Logical Backups EXPDP/IMPDP.
• Handled Chained Rows and Row migrationand solved the database performance issues.
• Experienced with ASM, adding, deleting disks to the disk group.
• Used Explain Plan, Oracle hints and creation of new indexes to improve the performance of SQL statements. Involved in SQL Query tuning and provided tuning recommendations to Application jobs, time/CPU consuming queries.
• Implemented Logical and Physical Standby Databases for RAC cluster on Sun Solaris platform using Data Guard feature of Oracle 11g R2.
• Successfully performed data replication using Materialized views and Oracle Streams in Oracle 11gR2.
• Cloned/Migrated databases using RMAN and traditional Data Pump export/import utilities in Oracle 11gR2.
• Implementeddisaster recovery system, using RMANand custom written shell scripts.Create and maintainOracleData Guard configuration.

Confidential, Ann Arbor, MI

Oracle Database Administrator

Responsibilities:

• DBA supporting three major projects from Development to Production via Tech-Test environments, involving daily configuration, administration all running on IBM AIX 5.2 & 5.3. Database sizes range from 4GB to 2TB (in ODS & EDW environments).
• Proven experience in troubleshooting issues related to Oracle RAC (Node Evictions, Node Reboots).
• Experienced with all facets of Oracle DBA day-to-day activities like production, database monitoring, Backup & Recovery using RMAN, Cloning, Troubleshooting production issues, and Physical Database Design.
• Extensive Experience in working with the Tools like OEM, AWR, ASH, ADDM Expdp/Impdp, SQL Tuning Advisor, SQL Plan Baselines.
• Good Experience in applying patches like Critical Patch Updates (CPU), Patch Set Updates (PSU), and One-Off Patches, Interim patches, DST, Patch sets as per the Oracle recommendations.
• Installed & configured Oracle Management Server (OMS) & Oracle Grid Control.
• Designing (Physical & Logical) and Implementation, database user creation and database access both at role & table levels, as well as final Project Performance Assessment/Evaluation.
• Create database Objects, Tablespaces, Schemas as needed.
• Schema migrations from Development to Production via Tech Test environments.
• Database refresh from Production to Tech Test as needed.
• Backup Oracle DBA for two major projects involving periodic administration, troubleshooting & tuning of 10g Oracle databases (10g & 11g single instances running on both IBM AIX 5.3, SunOS 5.8 & HP-UX B.11.11.
• Create oracle databases on configured servers using both the DBCA & Database creation scripts.
• Planned and implemented high availability solutions such as Real Application Cluster (RAC) in Oracle 11gR2 Grid and 10g on ASM and OCSF2 file systems.
• Highly experienced in Oracle 11g, 10gAutomatic Storage Management (ASM) required tofulfil the storage needs.
• Installed, configured, and maintained Physical, Logical, Active standby databases supported by Data guard on Oracle 11g, 10gRAC servers for the purpose of disaster recovery procedures.
• Designed daily, weeklyBackup and Recovery proceduresfor production, non- production databases usingRMANbackups taking periodic Complete, cumulative, and differential Incremental Backups.
• Data Refresh/Cloningfrom Production environment to setup QA/ DEV usingRMAN Duplicate.
• Intensively used latest 10g/11gAutomatic Workload Repository (AWR) & Automatic Database Diagnostic Monitoring (ADDM) reports for the health check of the databasesand used thenotificationtool to send the alerts inOEM Grid Control.
• Scheduled UNIX scripts in crontab jobs to automate daily taskslike backups, monitoring the alert logs, and backup logs to send notification emails.
• Migrated data to a new ASM Diskgroupto improve the IO performance of the database.
• Export/Import, Datapump, Transportable tablespacesto migrate databases from one database to another.
• OracleDatabase monitoring, troubleshoot, resolve the issues, monitoring alert log, trace files.
• Recovery of Database(Recovering fromMedia Failure, Recovering the tables dropped accidentally, recovering data files, recovering fromBlock Corruption) from previous RMAN backups.
• Performedcapacity planning, space monitoringliketablespace growth, ASM disk space.
• Resolvecritical issuesby raising SRwithOracleSupportandRoot Cause Analysis (RCA).
• Application of Oracle software patches when/where necessary.