OBJECTIVE

• Experienced Senior Oracle Database Administrator, MuleSoft Developer along with experience in Project Management (technical and Agile) and coordination seeking a Leadership position where I can use my excellent management and technical skills to help plan, execute and coordinate IT projects that have a positive impact on the well - being of employees and the financial status of Company, utilize abilities to lead and coach a team, and provide solutions. Worked in various domains like Finance, Healthcare and Telecommunications.

SUMMARY

• Have 15+ years of total experience in Information Technology in Technical, Leader and Managerial role. Worked as Sr. ORACLE DBA, Anypoint MuleSoft Developer, Operations DBA Manager and Process Manager.
• Extensive knowledge on database administration for Oracle 9i, 10g and 11gR1/2, 12c R1, 13c and 19c with experience in very large scale database environment and mission critical large OLTP.
• Hands on experience in Oracle 10g/11g and 12c/19c RAC implementation & administration (Oracle Cluster ware setup and configuration, RAC installation using ASM, Grid Installation) and manage RAC instances using CRSCTL and SRVCTL Utility.
• Expertise in migration of databases from a datacenter to the other using various technologies like DATAPUMP, Traditional export/import, RMAN, TRANSPORTABLE TABLESPACE, replication technologies like GOLDEN GATE.
• Expertise in scheduling jobs, RMAN backups, credential setup, database administration and monitoring, Metrics collection and performance tuning from OEM 10g,11g and 12c and 13c.
• Migration of Oracle database version from 10g R1 to 12c R1, 11g to 12cR2, 12c to 19c.
• Experience in the installation, configuration and maintenance of DATA GUARD (Physical Standby) with DATA GUARD BROKER and knowledge of Logical Standby.
• Extensive experience in Database Backups RMAN (Full/Incremental backups) and in traditional user managed hot/cold backups & Flash-Back Technology. Experience in LOGICAL BACKUPS and Database migration tools with DATA PUMP, Export/Import.
• Good experience in PATCHING AND UPGRADES.
• Designed MIGRATION APPROACH while migration of databases from one data Center to other on various UNIX platforms (Cross-Platform) Sun OS to LINUX and same platforms and from Windows 2003 to Windows 2012 R2.
• Extensive troubleshooting of typical Oracle Golden Gate technical issues: such as differences in the rows count from source to target, column mismatch errors, unique key violation by using GGSCI / log dump/discard file & ggserr.log analysis.
• In depth understanding of Security, Auditing of Oracle databases.
• Experienced in coordination with DEVELOPMENT TEAM in moving the schema (code) changes to Production database in a structured manner.
• Skilled in designing and implementing complete Life cycle of database applications.
• Experience in creating Mule flows/application using Mulesoft Anypoint to integrate between Oracle and Salesforce and external files mapping to Oracle and Salesforce.
• Hands on knowledge of object structures of Salesforce and datatypes and data modeling of salesforce.
• Good experience in leading various projects Confidential Oracle database level, application level and administration level. Help and coach team to achieve the desired vision of project.
• Good experience in leading projects following Traditional Project management approaches and Agile Life cycle using Scrum, XP and Kanban.
• Lead and successfully completed various IT projects in health sector using Hybrid management approach.
• Vast experience in working closely with System Administrators, Middle tier administrators & network administrators, development team on Oracle, Auditing teams and salesforce side during project design, build & implementation phases.
• Excellent Communication skills, co-ordination and communication with system administrators, business data analysts and development team.

TECHNICAL SKILLS

O/S: Solaris 10, UNIX, WIN/ 2000/2003/2008/2012 R2,2016 LINUX, AIX

Languages: SQL, PL/SQL, UNIX SHELL SCRIPTS

RDBMS: Oracle 9.2.0.x, 10.1.0.x., 10.2.0.x, 11.1.0.7, 11.2.0.3, 11.2.0.4, 12.1.0.2, 19c

Tools: /Utilities: RMAN, OEM 10g/11g/12c/13c,18c.19c, SQL*Loader, Traditional Export/Import, Datapump, Dataguard, Oracle Goldengate 11g, Oracle Golden Gate 12c, Windows Task scheduler and batch process, VMware, Commvault

GUI tools: Quest TOAD, SqlDeveloper, Golden6 Software, Golden PLedit, Anypoint mulesoft, Jira, Microsoft Project

Command Line: SQLPLUS, srvctl, crsctl, GGSCI, DGMGRL, ASMCMD, expdp/impdp, exp/imp, CMD, Soql

PROFESSIONAL EXPERIENCE

Project Manager/ Lead Oracle DBA (Consultant)

Confidential, Hamilton, NJ

Responsibilities:

• Maintaining and administering 100+ Oracle production databases along with their corresponding development and test databases for OLTP on Linux, Windows 2016, Windows 2012 R2.
• Lead the Migration and upgrading project of 30 inhouse Applications data from Oracle database version 10g on Linux to Oracle database version 12c.
• Leading the upgrade project of Oracle databases from 12c to 19c on Linux, this project is currently ongoing.
• Installed and configured 12c/13c Oracle Enterprise Manager (OEM) and Agents on Database server for monitoring and administration purpose, scheduling and automating database jobs.
• Involved in day-to-day database administration and maintenance like refreshing Dev and UAT environments with data from Prod environments for developers to test and work on new requirements, troubleshooting the errors reported on regular basis, adding space to tablespaces, schema changes on request from development team, removing fragmentation from tables with high DML activity, stats gather on regular basis, etc.
• Configured and scheduled jobs from Windows task scheduler using batch jobs and on Linux via cronjobs.
• Installed and Configured Oracle Real Application Cluster (RAC) with ASM and managing RAC instances using CRSCTL and SRVCTL Utility. Installed and Administered Oracle 19c, 12c, 11g ASM
• Created and configured Physical standby databases for Prod environment for High availability after migration, configured physical standby environment for failover and switchover modes.
• Experience in installation, configuration and maintenance of Physical standby databases.
• Involved in performance tuning Confidential the sql queries level and database level reported by development team using AWR reports, ADDM reports, ASH reports, tkprof and trace files.
• Configured/Scheduled RMAN backups using Commvault to take backups over the network on Tapes using CommCell console on Windows environment.
• Involved in patching of CPU, PSU and BP patches to databases every quarter with previous quarter patch on all environments and later on production environment after through testing of each patch.
• Involved in capacity planning of Oracle databases on regular basis.
• Experience in LOGICAL BACKUPS and Database migration tools with DATA PUMP, Export/Import.
• Lead the migration project from Windows 7 to Windows 10 PCs for the whole DMAHS division, which involve regular meeting with networking team, security team, development team for software testing and compatibility and with leads of the applications. Was involved in planning and executing of the project. We followed an Agile approach for initial testing and integration and finalizing the images for different groups and then rolled out the PCs in a traditional way.
• Monthly meeting with Security/Auditing team of DMAHS to be in compliance with all the regulations to be followed by projects, applications, and software and hardware requirements.
• Involved in creating various audit policies on 12c and 19c environment for auditing the database and to be in compliance with security policies related to database, passwords, etc.
• Working as an operations DBA to troubleshoot and resolve day to day application and database issue.
• I am also involved in process management which involves regular interaction and updates on the manual and automated jobs running for data transfer between departments, organizations, data manipulation with entire development and testing team and to be in compliance with regulations and standards maintained by PMO.
• I have also learned MuleSoft in my current job to be an expertise and is involved in creating various Mule flows or applications to integrate between Oracle and salesforce and mapping external data sheets and manipulation of data.
• Have a good knowledge of object structures of Salesforce and datatypes and data modeling of salesforce, can write Soql queries to an intermediate level.
• Managing Lead level project for migration of Access to Oracle. Apart from leading the project I am also involved in backend work in Oracle for data modeling and deployments. Also created Mule application to integrate the Oracle backend with Salesforce front end to accessed by MCOs and DOH teams. Following hybrid project management approach.
• Worked on SBE project on Oracle side in xml mapping to Oracle tables and structure and processing of data and then created Mule flows for integration between Oracle and Salesforce. Involved in regular meeting with development team for Oracle and salesforce. This project was led by chief architect of our team.
• Managing various IT developments projects using Agile mainly scrum and Kanban development.
• Regular coordination with developers’ team, system admins, auditing team to maintain compliance, network admins and end users for various applications we are building.
• Create and maintain comprehensive project artefacts (plans, risks/issues log) on regular basis.
• Measure project performance using appropriate systems, tools and techniques
• Manage ticketing service through Jira for Oracle projects and using Jira for coordination project related activities.

Environment: Oracle 10gR1,10g R2, 12c R1,13c, 19c, OEM 10g/13c, VMware, Windows R2,2016 Windows 7 and 10, AIX, Linux Redhat 7.5, Anypoint MuleSoft 3 and 4, Salesforce classic and lightning

Senior Oracle DBA (Consultant)

Confidential, Middletown, NJ

Responsibilities:

• Maintained Oracle production databases along with their corresponding development and test databases for OLTP on 24x7 (ONCALL, OFF HOURS and BUSINESS HOURS).
• Maintained and created database of up to 10 terabyte size with multiple schemas of up to 3 Terabyte size.
• Installed, Configured & Designed and deployed Oracle 11g databases on Sun OS/Linux servers in Production/UAT/ Development environments.
• Supported several application and support teams with numerous on-going projects.
• Redefined pre-defined partitioned tables to automate interval partition creations in all the environments.
• Performed database software installs, configurations, patches, and upgrades.
• Applied the latest PSU patches to the oracle database versions every 3 months.
• Upgraded and tested DEV/UAT/PROD environment databases from version 11.1.0.7 to 11.2.0.3.
• Upgraded and tested DEV/UAT/PROD environment databases from version 11.2.0.3 to 11.2.0.4.
• Worked on Initial steps on migration project for iplan project from Sun solaris to Linux servers.
• Worked on capacity planning for new database creation on Linux environment according to the requirement provided by application team and coordinated with the needs with System Admin teams for configuring the servers according to the requirement.
• Managed all aspects of physical database administration including schema management (DDL), security setup and enforcement, ID creation, installations, upgrades, patching, troubleshooting and instance tuning in development, UAT and production environments.
• Identified the root cause and resolved various ORA errors occurring in all database environments after upgrades including performance related issues (i.e. database & SQL tuning) for various reports and SQL queries running for the project iPlan in Dev/UAT/PROD environments using OEM 12c /TOAD /EXPLAIN PLAN /AWR /ADDM.
• Supported DBA utilities, reorgs, index builds, etc. and DBA tools.
• Expertised on SQL Plan Management (SPM), baselines and DB profiles.
• Monitored database performance, diagnosed performance problems, and tuned the database. Investigated, gathered diagnostic data, and reported to Oracle Support Services any critical database errors.
• Configured and supported Oracle 11g databases in Dataguard mode including failover and switchover modes in production environment.
• Proven ability in UNIX shell scripting.
• Coordinated the implementation of technical controls to support and enforce defined security policies.
• Extensively used expdp/impdp, for logical backups and refreshing of Databases. Refreshes were followed quarterly for every forecast model, trobleshooted and tuned the whole process to take lesser time everytime.
• Involved in taking physical full and incremental (differential/cumulative) backups and recovery through RMAN utility for 3 TB size databases .
• Worked and coordinated with Backup management team (EBRT) to resolve backup issues.
• Involved in setting up of RMAN backup jobs for production databases (net backup)
• Managed regularly scheduled backups using Oracle’s RMAN and occasionally a database recovery.
• Used vi and CRON utilities in day to day DBA activities.
• Worked on creation of ACLs (Access control list) in 11g environment.
• Monitored unix servers using various administrative utilities like sar/vmstat/netstat/iostat.
• Ran segment advisor to gather status of fragmented and tables with chained and migrated rows on regular monthly basis.
• Used online procedures for defragmenting schema objects using redefinition, Shrink fragmented tables and online rebuild fragmented indexes in all databases environments.
• Installed Oracle Golden Gate 11g on Prod environment and configured bidirectional movement of data from source to target database for replicating one of the schemas for testing purpose.
• Migrated database for various applications from Unix to Linux environment from database version from 10.2.0.4 to 11.2.0.4.

Environment: Oracle 10g/11gR1/11gR2, on Solaris 10/LINUX, OEM12c

Oracle DBA (Consultant)

Confidential, NY

Responsibilities:

• Installed, Configured & Designed Oracle 10g/11g databases on Solaris10/Aix5.x/Linux servers in Production/UAT/ Development environments globally.
• Supported 150+ development/UAT and production databases for OLTP on 24x7 of upto 9 Terabyte size with multiple schemas of upto 2 tearbytes.
• Planned & Designed Database Capacity requirement for various financial applications.
• Deployed & implemented various application schemas for multiple projects successfully in development/UAT/Prod Environments.
• Troubleshooted Oracle 10g/11g Production and development databases from user end to Database end.
• Implemented Security features like Roles & privileges in data warehousing as well as transactional databases as per Database security guidelines
• Successfully implemented 11g Golden gate on 3 major databases.
• Performed Database and Application Tuning using OEM/TOAD/Shell scripts/ TKPROF/EXPLAIN PLAN/AWR/ADDM
• Implemented Database releases in UAT/PROD environments as per Change control process
• Installed two node 11gR2 RAC software and configured databases.
• Extensively used srvctl, crsctl commands in RAC databases.
• Applied CPU and PSU patches to RAC and non-RAC databases.
• Worked in monitoring of databases for fragmentation, capacity planning, checking on errors in alert.log files for ORA-600 & ORA-7445 and resolved through SR’s.
• Extensively coordinated with storage/ SA teams for multiple projects in Smith Barney/Private Banking/Legal & compliance.
• Extensively worked on Performance tuning of SQL queries and databases in Dev/UAT/PROD environments.
• Used expdp/impdp (Datapump), for logical backups and refreshing of Databases.
• Involved in taking physical full and incremental backups and recovery through RMAN utility.
• Coordinated with Backup group for database backups using BCV and later used for COB test as well as for recoveries.
• Coordinated with Storage group for configuration of SAN to Databases on Solaris servers.
• Implemented and supported Partitioned tables in all the environments.
• Implemented Oracle security patches every six months.
• Followed Change control procedures for problem resolution and implemented DB releases in UAT/PROD databases.
• Extensively used shell scripts for backups with Compression techniques.
• Performed Database recoveries whenever required using RMAN.
• Implemented Grid control & ASM in Oracle 11g databases.
• Involved with installation and maintenance of ORACLE 11gR2 RAC.
• Implemented various Oracle 10g/11g features in development & Production databases.
• Automated Database shutdown & Startup and backups using Korn shell scripting
• Configured &Supported Oracle 10g/11g dataguard and Physical Standby database in production environment.
• Supported half yearly DR testing using snapshot databases.
• Monitored & Managed Oracle 10g/11g databases using OEM/TOAD/GRID control & shell scripts.
• Monitored UNIX servers using various administrative utilities like sar/vmstat/netstat/iostat.
• Configured & tested Oracle 10g/11g databases in Dataguard mode including failover and switchover modes.
• Involved in setting up of backup jobs for FS and databases using Autosys scheduler
• Designed and implemented DB security procedures for different users as per Application requirements.
• Performed Cloning of databases as per request from the development team.
• Reorganized fragmented tables in production databases whenever required.
• Implemented DDL & DML as per the database releases in Production & development Environment
• Planned, Designed & migrated Oracle 10.2.0.3 to 11.2.0.3

Environment: Oracle 10g/11g, on Solaris 10/AIX 6.1/LINUX, Goldengate 11g, RAC 11g, OEM10g/11g

Oracle DBA (Consultant)

Confidential, Middletown, NJ

Responsibilities:

• Supported production, UAT and development databases for OLTP on 24x7 (ONCALL, OFF HOURS and BUSINESS HOURS).
• Installed, configured & designed Oracle 9i/10g/11g databases for multiple applications (mission critical revenue impacting) on Sun solaris, Linux platforms in Dev/UAT/Production environments in RAC & Non-RAC environments as well as in DR modes.
• Planned & Designed Database Capacity requirement for various telecom applications.
• Migrated databases from Oracle UAT and development environment from 10.2.0.5 to Oracle 11.1.0.7
• Planned, Designed & migrated Oracle Production databases from 9.2.0.8 to 10.2.0.5
• Supported and maintained 10g RAC databases.
• Developed solutions for backup and recovery, cloning, patching, high availability, monitoring, upgrades and migrations.
• Extensively used OEM 10g grid for management and monitoring of Oracle database systems.
• Performed Database tuning & capacity planning and monitored database events, troubleshooted & resolved errors.
• Extensively worked on performance of Oracle database systems both on application & database level using Oracle tools like AWR, ADDM, ASH reports and using various data dictionary and dynamics views available.
• Implemented Oracle Disaster recovery strategy as well as participated in DR testing for multiple applications.
• Implemented database releases in Production/UAT environments for multiple applications as per change control process.
• Extensively identified faults in oracle database end to end and coordinated with concerned team to resolve faults.
• Implemented data models, database & application designs and table maintenance as per change control process.
• Deployed code migration in QA/UAT/Prod/DR environments using change control process.
• Decoded any errors in coding of SQL & PL/SQL for multiple projects.
• Supported yearly DR testing using snapshot databases
• Implemented database backups using RMAN(full and incremental) and configured with tape as well as disk.
• Extensively used Oracle data pump for Database refreshes and migration of Data from one platform to another as well as from one database version to another.
• Audited production/Dev/QA databases as well as compliance reporting.
• Assisted developers in end to end solutions in Oracle 9i, 10g databases for multiple applications.
• Performed database and application tuning.
• Implemented jobs using job scheduling tools such as Autosys and Oracle built in scheduler.
• Created SR in Oracle for complex issues and resolved with Oracle customer support team.
• Automated repetitive jobs using scheduler option using Autosys, crontab, Oracle scheduler options.
• Resolved alerts initiated by automated monitoring processes (backups, log files, etc.).
• Provided outage resolution support and perform Root Cause analysis to resolve recurring database issues
• Coordinated with various groups Application Developers/System Admins/Business Analyst team for implementation of Project and support of Databases on 24x7
• Involved in Planning, project implementation, designing, installation, configuration, testing & troubleshooting, backups maintenance, enhancement, performance tuning & security management and implementation of process steps of Oracle 9i/10g/11g databases.
• Worked independently and in team environment and delivered projects on time.

Environment: Oracle 9i, 10g, 11g, Sun solaris, Linux

Oracle DBA

Confidential

Responsibilities:

• Installed, Configured & Designed oracle 9.2.0.6/10.2.0.3 on Solaris 2.x/Aix 4.x/RHEL 4.x servers and Windows 2003 servers.
• Supported Production, UAT, Dev oracle 9.2.0.6 and 10.2.0.3 databases for Billing, impact applications on 24/7 basis for OLTP environments in Data guard.
• Implemented, supported and troubleshooted Oracle 8i/9i/10g dataguard & Broker in production environment for Failover sites as well as performed DR test.
• Maintained RMAN database backups (Disk & NetBackup tape) and restored as per special request.
• Migrated deve environment database from oracle 9i to 10g and implemented oracle 10g new features.
• Used AWR/ADDM/ASH/explain plan/Grid control and performed application and database tuning.
• Performed on call support for every 6 weeks on rotation basis.
• Used Traditional exp/imp for migration of databases as well as for restoration of production data into Dev/UAT environments.
• Pro-actively provided Database support to application developers as well as customers for troubleshooting as well as improving performance of the applications.
• Involved with team in implementing multiple DB releases as per change control process for multiple applications.
• Automated Database backups/Data pump export scripts using UNIX shell scripts.
• Supported Database security procedures for global trading databases.
• Designed, architected & Managed Logical structures like Tables, indexes, clusters,
• Extensively used raw devices and UNIX filesystems for storing billing data.
• Performed capacity planning for multiple production/QA/development databases.
• Designed logical & physical data modeling and created high quality databases.
• Troubleshooted Oracle 9i/10g Production and development databases from user end to Database end.
• Monitored & resolved alerts from multiple production databases for various issues.
• Interacted & resolved issues with help of oracle customer support for TAR’s raised in metalink.
• Involved with the team in Planning, Designing & migrating Oracle database from version 9.2.0.8 to 10.2.0.3.

Environment: Oracle 8i/9i/10g, Solaris 2.x/AIX 4.x/RHEL, Windows 2003