SUMMARY

• Around 8+ years of IT Experience as a Oracle PL SQL Developer PostgreSQL Golden Gate for System Analysis, Designing, Testing Development & Support of Oracle 11g and 12g in Production, Staging, Development environments
• Testing Development & Support of Oracle 10g,11g and 12g in Production, Staging, Development environments Strong experience in Oracle, Perl and Linux, Unix shell Scripting
• Excellent database knowledge on RDBMS like Oracle, SQL, PL/SQL ETL development (SSIS,SSRS)
• Strong experience in SQL and PL/SQL object types, Oracle parallel queries, materialized views, bulk collects and collections
• Experience in Oracle SQL Developer, SQL Server in Microsoft ETL development (SSIS,SSRS)
• Create a WebSphere MQ message includes XML message data, use the XML Parser transformation to read the data and parse the data into one or more targets. The XML Parser transformation speeds processing by parsing data in the pipeline through the transformation rather than in the target at the end of file
• Experienced with PostgreSQL & PostgreSQL Architecture, Installation & Configuration Schema handling
• Experience in Oracle database 18.0.18.2.3 4.1 4.0 , 5.2, 4.1, 4.2.5.1, 10.2.11.2.3 for development web application, work - flow applications, web services and interactive reports.
• Create Eclipse IDE for Java EE developers, because that contains the database development plugin which doesn't come along with Eclipse IDE for Java developers. You can download the latest version of Eclipse IDE for Java EE developers here.
• Have worked in Oracle 10gR2 and 11gR1,11gR2,12gR1(11.2.0.1,11.2.0.2),12c worked
• Worked on Database user roles and Security related permission. User creation, object Backup & Restore. Architect level Server security
• Creating and Managing PostgreSQL Databases PostgreSQL Index Management
• PostgreSQL Partitioning and System Catalogs Backup, Recovery and PITR
• Monitoring disk usage PGAdmin Transferring Data Moving Transaction Logs
• Implemented Indexes in indexing module to index the entire incoming document (physical or electronic) using Oracle PL SQL Developer POSTGRESQL.
• Creating back end modules for order processing using Unix shell scripts
• Developed Oracle PL/SQL packages and procedures for extracting or loading of files for internal and external sources Apache Tomcat
• Experience in Star Schema modeling and Snowflake Dimensional Modeling (Data Marts, Facts and Dimensions ) ETL development SSIS,SSRS
• Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.
• Experienced in Agile development process for diverse requirements
• Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, and Analytical functions, Materialized Views, Query Re-Write and Transportable table spaces
• Well experience in Perl programming using JavaScript and HTML
• Experience working with huge volumes of data, analyzing record sets for Data Quality, Data Validation and Metrics using Oracle SQL and PL/SQL
• Experience in Business Intelligence tools like - Tableau, Business Objects and Tibco Spotfire
• Extensively involved in Oracle SQL, PL/SQL tuning and Data warehouse applications using
• Experience Data warehouse Concepts and ETL tools like Informatica
• Experience in job defining, scheduling and monitoring tool Autosys.
• Good experience with creating Unix shell scripts to automate validation process, saving of log files, and other tasks
• Experience in Data Migration and Data modeling tools like MS Visio, Toad, Erwin, Star Shema
• Experience in operational 24x7 support, best practice trouble shooting, monitoring, capacity planning and maintenance

TECHNICAL SKILLS

Languages: DBI/DBD, HTML, SQL, PL/SQL Data Modeling, OLTP, OLAP

Operating Systems: Windows, Sun Solaris, Linux, HP UNIX

Databases: Oracle, Oracle 10gR2 and 11gR1, 11gR2, 12gR1 (11.2.0.1, 11.2.0.2), 12c Sybase, MS Access, MySQL, MS SQL Server, POSTGRESQL

Web Servers: Weblogic, Apache Tomcat

Tools: Toad, Jira, SQL Developer, SQL * Loader, SQL*Plus

PROFESSIONAL EXPERIENCE

Confidential, Irving, TX

Oracle PL SQL Developer PostgreSQL

Responsibilities:

• Experienced with PostgreSQL & PostgreSQL Architecture, Installation & Configuration Schema handling.
• Worked on Database user roles and Security related permission. User creation, object Backup & Restore. Architect level Server security
• Experience in Oracle SQL Developer, SQL Server in Microsoft ETL development (SSIS,SSRS) TABLEAU
• Also some Experience on PostgreSQLwith Confidential impacting production performance.
• Good communication with excellent analytical skills, willingness to learn and improve and ability to work within a team and independently.
• Creating and Managing PostgreSQL Databases PostgreSQL Index Management
• PostgreSQL Partitioning and System Catalogs Backup, Recovery and PITR
• Monitoring disk usage PGAdmin Transferring Data Moving Transaction Logs
• Implemented Indexes in indexing module to index the entire incoming document (physical or electronic) using Oracle PL SQL Developer POSTGRESQL DataGuard
• Creating back end modules for order processing using Unix shell scripts
• Developed Oracle PL/SQL packages and procedures for extracting or loading of files for internal and external sources
• Create Eclipse IDE for Java EE developers, because that contains the database development plugin which doesn't come along with Eclipse IDE for Java developers. You can download the latest version of Eclipse IDE for Java EE developers here
• Designed system tools in PERL and shell script to automate and monitor application in administrator module Utilized SQL Server DBA ETL development (SSIS,SSRS)*Plus as the main interface with Oracle
• Implemented PL/SQL bubble sort algorithm in sorting module to sort the content and send it to the archive database system Update and maintain web server in Unix environment Used JavaScript API in HTML to work on the system in offline mode also
• Monitored the performance tuning in Oracle PL/SQL application, ETL Developed PL/SQL routines to extract data from other database and load it into the Oracle database Used DBI/DBD for Oracle connection from PERL in Data Extraction and Loading module
• Developed Unix KSH scripts allowed users to perform database tasks Created SQL*Loader scripts to load data from external system to Oracle
• Responsible for primary database creation writing indexing and triggers on Oracle database
• Used java to support and download of electronic files to load files into the archive, retrieve files from achieve and spread the document across the archive structure Created RDBMS and Achieve using SQL, PL/SQL shell Scripting.
• Extensive hands on experience in Oracle database 10g, 11g and 12g, proficient in maintaining and
• Managing large scale SQL SSIS, SSRS database environment and mission critical large OLTP and OLAP systems.
• Eliminated months of production server issues by systematically troubleshooting and resolving the problem with no further downtime. Enhanced the performance of the company’s Oracle environment by providing advanced performance tuning using tools like AWR, ADDM, EXPLAIN PLAN, ASH, SQL TUNING ADVISOR, TKPROF, SQL TRACE OEM grid control 12c and command line.
• Extensive experience maintaining, enrolling users, system security, controlled and monitored user access to the database, operating 24/7, with 40-50 concurrent users at any given time worked on ASM redundancy,
• Managing ASM disk failures & replace failed ASM disk with a new disk Monitored resource utilization from both database and O/S level making suggestions for upgrades for software and hardware (memory, CPU, disk) which resulted in higher overall system performance.
• Products include Oracle Enterprise Manager, SQL, PL/SQL, Recovery Manager, Oracle Data Pump, and Oracle Partitioning.
• Analyzed all database updates to ensure integrity of ETL database design, performance, optimization, and security. Have worked in Oracle 10gR2 and 11gR1, 11gR2 (11.2.0.1, 11.2.0.2),12c and worked interchangeably across multiple O/S platforms (AIX, HP/UX, Sun Solaris 8,9,10, Linux Redhat 5,9 and Windows 2000+ servers supporting 100s of schemas to prevent and/or fix 1000s of production problems Have upgraded oracle databases from 10g to Oracle 11g and Oracle 11g to Oracle 12c using DBUA and scripts on Linux red had 5.9 server Performed on-call duties 24x7 consistently over
• Experienced in all the phases of Software Development Life Cycle (SDLC) Most recently supported Oracle 11g RAC database projects, mission-critical HA using ASM disk groups, RMAN backup and recovery alongside primary and physical standby disaster recovery configurations on Linux Red Hat platforms. Solid Experience utilizing Oracle EM Dbconsole and Oracle Enterprise
• Experienced in Installation of high availability RAC environment (2, 3 and 4 node clusters) and upgraded standalone databases to 11g RAC environment.
• Proficient in setting up Standby Database using OEM grid control and RMAN utility tool, activating and Re-building Standby Databases both Physical and Logical supported by DATAGUARD, configure datagaurd broker for switchover and failover Ample knowledge on working with AWS services such as IAM, S3, EC2, RDS
• Implemented Goldengate integrated capture and coordinated replicat (available from OGG 12c) to improve the performance of data replication to targets Managed Oracle GoldenGate installation, configuration, troubleshooting ABEND, and performance issues.
• Having hands on experience in Hot/Cold Backup, Recovery and Cloning of databases using RMAN with VERITAS Net Backup.
• Proficient in Logical backups/database migration using DATAPUMP, load data using SQL*LOADER
• Expertise in maintaining Database Security using security compliance auditing, and expertise in loading data from flat files using external tables, SQL*LOADER Refreshing Dev and Test instances with data from Production on a regular basis using TTS,DATAPUMP and cloning,
• Perform database Security using auditing and TDE
• Good experience of creating PL/SQL packages, Stored Procedures, Functions, Triggers and Views to retrieve, manipulate and migrate complex data sets in Oracle Databases.
• Experienced in using Oracle's Transportable Tablespace (TTS) feature allows users to move a user Tablespace across Oracle databases.
• Experience in applying security patches to the databases, Data Migration using datapumpand export/import. Management of Objects, Schemas, Partitioning the tables and Indexes databases across the globe responded to trouble calls from multiple production database sites throughout US Monitoring and administration of databases using OEM 12c Cloud control 12.1.0.4
• Using Oracle Data Pump utility making fasted SQL reports / imports using Network link on large databases Support application performance issues using 12c Cloud control / AWR / ASH / ADDM / Traces. Install, upgrade Oracle Enterprise Manager (OEM) 12c. Manage Oracle Real Application Cluster (RAC) for Oracle 11g R2; apply Oracle Security Patches to adhere to the security policy.
• Loaded spatial data into database using SQL Loader and creating spatial Indexes.
• Optimized the queries, tuning of SQL statement using tools like Explain plan, Auto trace of, SQL tuning advisor, DBMS PROFILER, made performance improvements to the database by building Partitioned tables, Index Organized Tables, Materialized Views and Bitmap Indexes Create and Configure new 12C pluggable databases (PDB's) using DBCA.
• Worked on Database Upgrade from 11.2.0.3 to 12.1.0.1 using DBUA.
• Migrated Non-Container databases to 12c Pluggable databases.
• Upgraded 11g databases to12c stand alone and container database Utilize Oracle Universal Installer (OUI) support Set up oracle Gold Gate integrated capture for automatic dependency awareness of dynamic load balancing with the aid of parallelism
• Up gradation of Grid Infrastructure and Oracle Database from 11.2.0.2to11.2.0.4on3-nodeRAC environment Migration of database from one server to another server with zero downtime using Oracle Golden Gate.
• Implemented Data guard, creating physical stand by databases in11g RAC environment for production database. Install, configure and support uni-directional and bi-directional Oracle-to-Oracle replicated environments utilizing Golden Gate.
• Used Golden gate for configuring on line change sync harmonization between the source and target database using Data pump.
• Increased performance of Goldengate by using range parameter and multiple threat replicate processes.
• Successfully configured and installed Oracle Golden Gate for Schema/Table replication. Configured
• DDL Replication in Golden Gate to enable DDL Synchronization.
• Trouble shoots GoldenGate erroneous Skipping Transactions using LOGDUMP utility. Configured Integrated Extract& Integrated Replicates substitute to conventional Classic mode to increase the performance. Used Convch Utility in Golden gate to repair the corrupted Checkpoint Table.
• Performed regular system Upgrades and applied latest patch sets to all Oracle Enter priseserve, piloted all changes in a controlled environment prior to deployment.
• Recommendations for SQL statement tuning for SQL statements that are identify ideas

Environment: Oracle PL/SQL, SSIS,SSRS Linux 6 & Red Hat Linux 5.0, Oracle 10g,12c and 11g, GoldenGate, Oracle EnterpriseCloudcontrol12c,RMAN,11gRAC,ActiveDataGuard,ASM,TKPROF,Explainplan,AWR, ADDM, remedy, SQL* Plus, PL/SQL, SQL*Loader

Confidential

Oracle PL SQL Developer

Responsibilities:

• Performed daily activities, including database backup and recovery, testing, and performance monitoring and tuning, refreshes, Rebuilding of Indexes, if bulk load of data is inserted, Perform database health check.
• Queried databases using SQL and PL/SQL and server scripts to verify data integrity Completed 2-month temporary duty assignment providing 24*7 on-call support for production databases, responded to trouble calls from multiple production database sites throughout US
• Enhanced the performance of the company’s Oracle environment by providing advanced performance tuning using tools like AWR,ADDM,EXPLAIN PLAN,ASH,SQL TUNING ADVISOR,TKPROF,SQL TRACE automated via OEM grid control 12c and both command line Implemented Oracle ASM 12c software installation and configuration (Grid Infrastructure) and partitioning Disks in Linux.
• Supported up to 100 databases and applications, including development, test, and production servers, loading initial, upgrades, and software patches Products include Oracle Enterprise Manager, SQL, PL/SQL, Recovery Manager, Oracle Data Pump, and Oracle Partitioning.
• Analyzed all database updates to insure integrity of database design, performance, optimization, and security.
• Eliminated months of production server performance issues by systematically troubleshooting and resolving the problem with no further downtime Extensive experience maintaining, enrolling users, system security, controlled and monitored user access to the database, operating 24/7, with 40-50 concurrent users at any given time Developed, tested and maintained a Disaster Recovery plan proving beneficial using DataGuard Broker in 11gR2 environment between multiple data centers
• Successfully designed and developed a backup/recovery strategy and procedures for several Oracle database instances, such as RMAN incremental level 0, incremental level 1, incremental updated, incremental differential, incremental cumulative following company SLA, PTO and RTO.
• Most recently supported Oracle 11g RAC database projects, mission-critical HA using ASM disk groups, RMAN backup and recovery alongside primary and physical standby disaster recovery configurations on Linux Red Hat platforms.
• Solid Experience utilizing Oracle EM Db console and Oracle Enterprise Manager Grid Control Managed and set up database security, access control, using standard, fine grain auditing and TDE Modified scripts to provide reports as to health of databases and provided reorganization information Migration of database from one server to another server with zero downtime using Oracle Golden Gate.
• Setup and maintain documentation, create database objects Efficiently performed installation, setup and creation of four node cluster RAC with Oracle 11.2.0.3 database using GRID infrastructure with ASM file systems Implemented Data guard, creating physical standby databases in 11g RAC environment for production database.
• Resolve Performance issues by tuning RAC, tuning applications, shared pool, I/O distribution, rollback segments, buffer cache, redo mechanisms, tune all Oracle instance components including SQL and PL/SQL Installed, Configured and Administered Oracle Golden gate to replicate table data between databases Patch database for security and bug fixes using Opatch utility for applying patch set Upgrade (PSU).
• Troubleshoot archive log Gaps between the primary and standby database using RMAN incremental backup and manually by copying the logs across without down time.
• Completed a 2-month temporary duty assignment providing 7x24 on-call support for production databases across the globe; responded to trouble calls from multiple production database sites throughout US Monitoring and administration of databases using OEM 12c Cloud control 12.1.0.4
• Using Oracle DataPump utility making faster exports/imports using Network link on large databases Support application performance issues using 12c Cloud control / AWR / ASH / ADDM / Traces. Install, upgrade Oracle Enterprise Manager (OEM) 12c. Manage Oracle Real Application Cluster (RAC) for Oracle 11g R2; apply Oracle Security Patches to adhere to the security policy.
• Loaded spatial data into database using SQL Loader and creating spatial Indexes
• Optimized the queries, tuning of SQL statements using tools like Explain plan, Auto trace, Tkprof, Sql tuning advisor, DBMS PROFILER, made performance improvements to the database by building Partitioned tables, Index Organized Tables, Materialized Views and Bitmap Indexes Create and Configure new 12C pluggable databases (PDB's) using DBCA.
• Worked on Database Upgrade from 11.2.0.3 to 12.1.0.1 using DBUA
• Migrated Non-Container databases to 12c Pluggable databases
• Upgraded 11g databases to 12c standalone and container database Utilize Oracle Universal Installer (OUI) support set up oracle goldengate integrated capture for automatic dependency awareness of dynamic load balancing with the aid of parallelism
• Upgradation of Grid Infrastructure and Oracle Database from 11.2.0.2 to 11.2.0.4 on 3-node RAC environment Migration of database from one server to another server with zero downtime using Oracle Golden Gate
• Implemented Data guard, creating physical standby databases in 11gRAC environment for production database Install, configure and support uni-directional and bi-directional Oracle-to-Oracle replicated environments utilizing GoldenGate.
• Used Goldengate for configuring online change synchronization between the source and target database using Datapump
• Increased performance of Goldengate by using range parameter and multiple threat replicat processes. the transactions
• Performed regular system Upgrades and applied latest patch sets to all Oracle Enterprise servers, piloted all changes in a controlled environment prior to deployment.
• Periodic validation of oversized indexes and index rebuild when required.
• Recommendations for SQL statement tuning for SQL statements that are identified as impacting production performance
• Good communication with excellent analytical skills, willingness to learn and improve and ability to work within a team and independently.

Environment: Oracle Linux 6 & Red Hat Linux 5.0, Oracle 10g,12c and 11g, GoldenGate, Oracle Enterprise Cloud control 12c, RMAN,11g RAC, Active DataGuard, ASM, TKPROF, Explain plan, AWR, ADDM, remedy, SQL* Plus, PL/SQL, SQL* Loader.

Confidential

Oracle PL SQL GOLDEN GATE SPECIALIST

Responsibilities:

• 24x7 Production database administration, support and monitoring to ensure a proactive problem.
• Successfully configured and installed Oracle GoldenGate for Schema/Table replication. Configured
• DDL Replication in GoldenGate to enable DDL Synchronization.
• Troubleshoot GoldenGate erroneous Skipping Transactions using LOGDUMP utility Configured Integrated Extract & Integrated Replicat as a substitute to conventional Classic mode to increase the performance. Used Convch Utility in Goldengate to repair the corrupted Checkpoint Table
• Improved performance of replicate by using Batch SQL Parameter & Max Transops parameter to split
• ProvidedinstancelevelperformancemonitoringandtuningforEventWaits,Sessions,Physicaland
• Logical I/O and MemoryUsage.
• Used transportable table spaces (TTS) to move the data on a different platform and much faster than performing either an export/import or unload/load of the samedata.
• Assist in the Implementation of 10g Data Guard and Bi-directional streamsimplementation.
• Use Oracle Enterprise Manager (OEM) on daily basis tool serves the performance of the production databases and set trigger foralert.
• PerformancetuningofQueriesbymaintainingAggregates, Compression, partition, indexinganduse of Hints, Stored outlines, Statistics for thesame.
• Created Users, Groups, Roles, Profiles and assigned user store groups and granted privilege gees and permissions to appropriate groups.
• ImplementedandfolloweddatasecuritystandardsandSecurityUserManagement, Privileges, Roles, Auditing, Profiling, Authentication and Riskmanagement.
• Use different backup types and striate gees like hot, cold, and import/exports based on the business requirements.
• Applying security patches both Server side and Client side and Performedtesting.
• Trouble shooting of various database performances by proper diagnosis at all levels like SQL, PL/SQL,databasedesign,databasetables,indexes,Instance,memory,operatingsystemandjava calls.
• Worked with production DBA team in perfect coordination with seniors and teammembers.
• Performed database cloning to setup test and developmentdatabases.
• Responsible for optimizing the queries and applicationtuning.
• Performed SQL tuning and assist developers with codingPL/SQL.
• Provided support to Application Database Administrators in designing the database

Environment: Oracle database 10g (10.1.0.5 to 10.2.0.4), Redhat4, HP-UNIX 10.0, RAC, TOAD, TTS, Erwin 7.2, J2EE, ASM, Oracle Enterprise Manager, Network setup and Management, ASM, RMAN, SQL*Plus, PL/SQL, SQL*Loader, Oracle Reports etc