SUMMARY:

Over 8+ years of professional experience in the Information Technology mainly worked on Banking, Telecommunications, Insurance domains, Restaurants and involved in software development life cycle processes including requirements gathering, analysis and design, development tools and technologies, release and version control.

• 8+ years of experience as Oracle EBS technical consultant.
• Technical lead and principal developer over the last 3 years.
• Developed solution to exchange information between Oracle EBS and external applications.
• Consumed SOAP services from concurrent programs and OAF Pages.
• Developed custom modules to increase.
• Created custom email alerts using HTML and JavaScript.
• Sent emails using XML Bursting, PLSQL and Java.
• Developed inside Oracle EBS utility to compress big files and sent it by email in zip format.
• Completed AIX and OCA First Level .
• Perform Oracle database administration tasks include configuration management, backup/recovery, performance optimization, and space management.
• Effective Communication and interpersonal skills.
• Installation of Oracle on Windows platforms with operating system environments.
• Knowledge of SQL and PL/SQL scripting.
• L3 production support and technical knowledge for Automation of DBA tasks.
• Excel in SQL performance tuning, monitoring and PL/SQL development.
• Manage a comprehensive and ongoing Release management and planning program.
• Trained in Amazon Web Services (AWS).
• Experience in Migration of Oracle Databases from non - RAC to RAC and non-ASM to ASM Instances.
• Experience in Real Application Clusters (RAC) setup with 4 nodes, configuration and cluster interconnection with Automatic Storage Management (ASM).
• Configured and maintained physical standby databases using Oracle Data Guard to perform quick disaster recovery.
• Extensively worked on Import/Export and Data Pump Import/Export tools.
• Expertise in implementing partitioning methodologies (Range partitioning, List partitioning, Hash partitioning, Composite partitioning) on tables and indexes for high performance.
• Experience in conducting Joint Application Development Sessions with end-users, Subject Matter Experts (SMEs) Development and QA teams.
• Monitor database systems and provide technical support for database system issues and application performance enhancement/improvement using both OEM (client), Oracle 10g database control & SQL*Plus, as well as pre-developed UNIX shell scripts.
• Created Physical Standby databases and switch to snapshot standby databases for application testing.
• Applied Critical Patch Updates (CPU) and Patch set updates (PSU) on Oracle databases and interim patches for various bug fixes on database products.

• Oracle Solaris
• V Sphere
• PL/SQL
• UNIX Shell Scripting
• Erwin
• Oracle 12c
• 11gR2
• 10g, RAC
• ASM
• Golden Gate
• Linux
• Windows
• Veritas
• Cluster
• Net Backup
• VNC server
• AIX, OEL 5.8
• OEM12c
• Java
• JavaScript
• Forms
• Shell scripts
• RMAN
• EXPDP/IMPDP
• Partitioning
• Oracle Fail Safe 3.x
• Disaster recovery,
• Rman Backups
• Scripting
• Storage management
• Hp-ux
• Load balancing
• Oracle Dba
• Dba

PROFESSIONAL EXPERIENCE:

Confidential. Chicago, Illinois

Sr. Oracle Developer

Responsibilities:

• Applied Patches to 11g and 12g and used data patch to upgrade 12c databases • Kept team members and management updated on major issues so they have a clear picture of situation.
• Oracle 11gR2/12CR1/12CR2, Red Hat Enterprise Linux 7, HP-UX, Solaris 10, Oracle Enterprise Manager 13.1/13.2, Grid Control, PL/SQL, Shell Scripting, Data Guard, RMAN, Data pump, TCPS listeners, oracle wallets, DBLINK, web logic server, oracle management agents

Technologies Used: RHEL 7, Oracle Solaris, Aix 5.3, Windows Server, MS SQL Server 2008R2/2012/2014 VERITAS, Oracle (12c,11g,10g,9i), RAC, Data Guard, ASM, OEM 10g/11g/12c, TOAD, RMAN, BMC Control-M, SAN, VMware V Sphere, PL/SQL, UNIX Shell Scripting, Erwin, Subversion, Service Manager. Oracle Applications R12.1.3, CEMLI's related to AP module, SQL, PLSQL, Shell scripts. Oracle 12c, 11gR2, 10g, RAC, ASM, Golden Gate, Dataguard, Oracle Enterprise Manager Grid Control (OEM), RDBMS, Explain plan, Stats pack, Red hat Linux, Windows, PL/SQL, TOAD, SQL Tuning Advisor, SQL Performance Analyzer, Shell Scripting.

Confidential, Roseland, NY

Sr. Oracle DBA

Responsibilities:

• Administer over 300 databases across development, QA, UAT and PROD environments via use of command line and Oracle tools Oracle Enterprise Manager Cloud 12c.
• Manage large complex Oracle RAC clusters with 50+ applications.
• Installed Oracle 11g RAC and Upgrading Oracle 10g RAC databases.
• Upgraded databases from 11g to 12c.
• Set up Active Data guard Configurations for oracle database 11.2.0.3 for thirty databases whose size varies from 5 TB to 20 TB on a 6 node RAC.
• Designed Golden Gate configuration for databases & implemented filters with rules to meet the business usage which will reduce load on the production databases for better performance with replication on multiple sites.
• Migrated and upgraded Oracle 11gR2 Databases from Sun Solaris 10 to Red hat Linux 5 using Golden gate.
• Designed and maintain Database security using Oracle Roles and privileges.
• Monitored and troubleshoot issues for GG process lags or a bended process and fixed issues.
• Applied patch to Golden gate.
• Written shell scripts to automate jobs
• Creating Indexes, rebuilding indexes, analyzing indexes to improve the performance of query.
• Monitored the various database activities by developing shell scripts and using various tools.
• Worked closely with Developers
• Upgraded Databases from Oracle 10g to 11g
• Worked on Flash Recovery Area
• Performed DR switchover / failover practices using Data Broker.
• Patched Oracle databases using Opatch utility.
• Generated triggers for data integrity, created views to resolve complex queries.
• Used RMAN duplicated database to clone.
• Used export import and Data pump to refresh schemas.
• Identifying the poorly performing queries using Explain Plan, TKPROF, and assisting the developers in optimizing and tuning the SQL and PL/SQL code using SQL trace.
• Worked on Materialize views
• Provided 24/7 on-call support.
• Translated logical models to physical Data models for database designs.
• Monitored Table spaces and Data files utilization using OEM.
• Administered the data integrity of all databases by controlling and coordinating all changes and updates to the databases.
• 24X7 production DBA support for mission critical databases (300+) up to 12tb in size on various operating systems like LINUX, SOLARIS, and AIX.
• Implement Oracle Golden Gate (OGG) between Oracle RAC databases as High Availability solution and tune the performance of OGG in high data volume environments.
• Upgrade databases from 11g to 12c.
• Scheduled meetings with application team for database migration review to gather legacy information such as type of application, database options, current oracle configuration, capacity and oracle outstanding tasks.
• Migrated 80+ production databases across data centers using data pump, log shipping and transportable databases.
• Installed and configured multi-tenant databases using oracle 12.1.0.2 and upgraded 11.2.0.4 to 12c
• Successfully upgraded databases to version 12.1.0.4 and applied latest PSU patches.
• Performed rolling grid infrastructure upgrade from 11.2.0.4 to 12.1.0.2.
• Applying Quarterly patches and Version change patch bundles.
• Setup of golden gate replication for to provide maximum flexibility and availability for busin, Maven and GIT.
• Used TDD approach to develop the application and Implemented the unit tests using Python Unit test framework.
• Wrote unit test scripts for controllers, filters and services using Karma, Jasmine and Mocha.
• Worked with DevOps, Jenkins in a Docker container with EC2 slaves in Amazon AWS cloud configuration.
• Used Jenkins and pipelines to builds out to the Docker registry and then deployed to Kubernetes.
• Created Java based scripts for Selenium RC with JUnit/TestNG as automation frame work.
• Worked with Agile Software Development environment using SCRUM and Kanban.
• Worked on API Gateway in AWS (EC2, Lambda, EBS, RDS, and Dynamo) with AWS CloudFormation.
• Worked on CI/CD pipeline and created sandbox, UAT and Production Environments in Google Cloud Platform.
• Manage the code changes in the project by using TFS tool and used GRADLE to build the web application.
• Worked with UI development under Linux OS (Debian, Ubuntu, and RedHat Linux) and Mac OS.
• Used Zoom, HipChat, and Slack for project tracking and team communication.
• Ran SQL/CQL stress workloads to test storage on Docker swarm using Cassandra and MySQL.

Technologies Used: Visual Basic 5.0, OEM 11g/12c, TOAD, PL/SQL, Shell Scripting, ASM, SQL server 2012, Service Now, Exadata, Golden Gate, Dataguard, Oracle Enterprise Manager Grid Control(OEM), RDBMS, Explain plan, Statspack, Sun Solaris, Redhat Linux, Windows, SQL*LOADER, PL/SQL, TOAD, SQL Tuning Advisor, SQL Performance Analyzer, PostgreSQL database, Mongo database, SQL server 2008, Shell Scripting. cc, SUN SOLARIS, IBM AIX, OEL 5.8, OEM12c, RAC, Golden Gate, Oracle Exadata, Oracle Fail Safe 3.x, RMAN, EXPDP/IMPDP, Partitioning

Confidential, Beaverton, OR

Oracle DBA

Responsibilities:

• Written UNIX Shell scripts for monitoring the processes, sessions, transactions on Production RAC database after migration.
• Written UNIX shell scripts for partition splitting.
• Strong skill in PL/SQL procedures, packages, triggers and replication.
• Work with development and operations staff in resolving problems quickly and efficiently.
• Experienced in migrating databases to higher releases including incremental migrations
• Migrated database from 9i to 10g and 11g supporting various incremental releases
• Planned version control of production source code using Clear case.
• Writing SQL scripts, stored procedures, functions and transactions analysis for performance tuning
• Security User Management, Privileges, Role, Auditing, Profiling, Authentication
• Made performance improvements to the database by building Partitioned tables, Index organized Tables, Materialized Views and Bitmap Indexes

Technologies Used:, Linux, Windows, Veritas Cluster, Net Backup, VNC server, NETAPP Manager, TOAD, OEM 11g grid control, Datapump, Exp/Imp, Metalink, Teradata V15, V14.10, SQL Programming, UNIX Shell scripts, BTEQ, Fastload, Multiload, SQL assistant, Teradata Manager

Confidential, Sterling, VA

Oracle Applications Developer

Responsibilities:

• Configuration, Administration and tuning of Oracle 10g and 9i RAC.
• Used cross platform transportable table space (TTS) to transport table spaces across platforms.
• Data Refresh in Test and Integration Databases using Transportable Table spaces.
• Performed Setup Recovery Manager (RMAN) and Flash Recovery in RAC Environment.
• Troubleshooting all Oracle Apps Issues like Forms, Apache and CM.
• Run ADADMIN to compile APPS schema, regenerate forms, reports, generate Jar files.
• Supporting the databases for different applications like nontax, fog light.
• Written Shell scripts to move the Tables from one instance to another instance using Import/Export.
• On-call support for Oracle ERP Applications and databases.

Technologies Used: V15, V14.10, SQL Programming, UNIX Shell scripts, BTEQ, Fast load, CEMLI's related to AP, AR, INV, EAM,QA, CE modules, XML Publisher, SQL, PLSQL, Java, JavaScript, Forms, Shell scripts.