SUMMARY

• I has hands - on 9 plus years of experience in IT industry for Oracle DBA (19c/12c/11g10g/9i), wif experience in production environments under UNIX, Windows NT platforms.
• Hands-on experience wif real-world Production environments, System Design, Data Migration, Performance Tuning, Data Replication, Data warehouse & Reporting and Database Modeling & Development.
• Extensive noledge on database administration for Oracle 9i, 10g.11g 12c and 19c, wif experience in very large-scale database environment and mission critical large OLTP and OLAP systems.
• Involved wif installation and maintenance of oracle 12cRAC and standby database for High Availability and Disaster Recovery purpose.
• Experience in managing Oracle databases running on UNIX/Linux, Sun Solaris, HP-UX & AIX and RHEL.
• Hands on experience in Oracle 12c RAC implementation & administration (Oracle Cluster ware setup and configuration, RAC installation using ASM, Grid Installation).
• Experience as On-Call 24x7 production DBA support
• Extensive noledge and experience on managing very large Data Warehouse databases.
• Extensive experience in configuring and implementing ASM and proficiency in using ASMCMD and ASMLIB.
• Experience in Flash-Back Technology.
• Experience in Database Refresh and patch management and in Database cloning wif RMAN and manual methods.
• Worked on Oracle, SQL, PostgreSQL, MySQL and AWS for the cloud.
• Identity and Access Management(IAM) (Oauth, SAML)
• Design of Continuous Delivery pipelines and the tools used to deliver solutions such GIT, AWS Code Commit, Code Deploy, Code Pipeline, Code Build, Docker, etc.
• Upgrades from 10g to 11g and 11g to 12c and 19c.
• Experience in configuring and performing Backups/Recovery using RMAN, Data pump, Flashback Technologies and Zero Data Loss Recovery Appliance (ZDLRA)
• Performed data restore, Tablespace/Database restore as well as moving tablespace sets from one oracle Database to another using Transportable Table Space (TTS)
• Good experience in database cloning and database refresh activities using RMAN and Data pump.
• Very good in performance tuning databases systems. Usage of performance views and usage of performance utilities (AWR, ASH, ADDM..etc).
• Experience in Installing and Configuring OEM 12c & OEM 13c cloud control wif email alerts.
• Highly experienced in RAC doing Migration of Oracle Databases from Non-RAC to RAC and Non-ASM to ASM Instances.
• Oracle Security implementation for EBS 12.2 and 12c, 11g databases.
• Installation and configuration of Oracle Audit Vault.
• Implementation of High Availability solutions wif Oracle 11g, 12c and 19c RAC, Dataguard and Golden Gate 11g&12c.
• 3+ years of experience in Goldengate Installation, Configuration, Upgrading Goldengate from 11g to 12c and 19c and Administration. Very good noledge in Goldengate products like GoldengateVeridata and Goldengate monitor. Also Implement and Support of Oracle Golden Gate replication in Prod and Non-Prod.
• Expertise in configuring of Physical standby database for high availability.
• Great noledge in Installation, configuration, maintenance, and administration of Oracle E-Business Suite 11i & R12, Identity & Access Management (OAM11g, OID11g) and Oracle Databases 10g, 11g, 12c and 19c RAC and Dataguard. Expertise in Implementing Single Sign on for Oracle E-Business suite R12 using Oracle Access Manager (OAM) wif OID 11g.
• Proficient in database administrative activities in ASM, RAC and Dataguard.

TECHNICAL SKILLS

ERP: Oracle E-Business Suite 11.5.10.2, 12.0.6, 12.1.1, 12.1.3, 12.2.2, 12.2.4 and 12.2.5

Oracle Databases: Oracle 10g (10.2.0.5), 11g (11.2.0.2, 11.2.0.3 and 11.2.0.4) and 12c (12.1.0.2, 12.2.0.1)

Operating Systems: HP-UX, Redhat Enterprise Linux, Oracle Enterprise Linux and Windows 2008 and 2012 R2, Exadata X5-8, Microsoft Azure Cloud

Database Utilities: OEM 12c& OEM 13cCloud Control, Exp/Imp, Data Pump, DBCA. DBUA, OUI, RMAN, Goldengate Monitor, DGMGRL, GGSCI

Tools: Putty, Toad, SQL Developer, SQL*Plus, SQL*Loader,WinScp, Atom, GitHub,Jenkins,Puppet,Docker,Ansible, Ansible Tower

Domains: Finance, eCommerce, Travel and Logistics, Retailand Manufacturing

PROFESSIONAL EXPERIENCE

Confidential, Monroe, Louisiana

Senior DBA

Responsibilities:

• Experienced working on different database versions like Oracle 9i,10g, 11g and 12c, 18c &19c databases.
• Provided production support for the 24x7 Oracle database availability.
• Multitenant: Mange Tablespace in a container database (CDB) and pluggable database (PDB) in oracle Database 18c.
• Manage User and privileges for container database (CDB) and pluggable Databases.
• Checking Databases Backup and Restore validity periodically, and Data refreshes from Production to Non-Production environment, Creation Duplicate Databases using RMAN Backups.
• Created database links to retrieve data from multiple servers.
• Working on Exadata X2, X3 and X6 machines which included Half Rack and Full Rack.
• Upgraded 19c and 18c grid infrastructure from 12c database version.
• Migrated 12c databases from 11g database by using Transportable Tablespace on cross Platform. provide guidance and develop Disaster Recovery strategies for the Exadata Database machine.
• Provide and implement performance tuning recommendations of all components in Exadata database machine.
• Installation, Configuration, Upgrade, patching of Oracle RDBMS and applications Work on different versions of Databases wif OEM Grid control to maintain the database effectively.
• Worked extensively on 10G, 12C and 13C OEM and configured DB alerts for DBA.
• Worked wif database export &import, import scripts to backup database structures and automation procedures.
• Participate in the design, development, testing, implementation, and maintenance of database structures
• Upgraded 10.2.0.4 Two Node RAC ASM Database to 11g R2 Two Node RAC ASM.
• Managed data warehouse projects improvement and growths.
• Monitor databases for resource utilization, providing trend analysis and forecasting of resource requirements.
• Performance tuning for optimized results using tools like EXPLAIN PLAN, SQL*Trace, AWR and ADDM reports.
• Monitored CPU usage, I/O contention, memory paging and identified the resource and performance bottleneck.
• Tuning which involved I/O, Memory, CPU utilization, SQL Tuning, SGA Tuning, Shared Pool Tuning, Buffers and Disk I/O tuning.
• Implemented and maintained Oracle 10g/11g Data Guard/standby databases for fail-over purposes.
• Implementing and maintaining database security (create and maintain users, roles and assign privileges).
• Extensively used Materialized views and DB links for remote instances to retrieve data from other databases.
• Used Oracle defined packages DBMS JOB, DBMS SCHEDULER for job scheduling.
• Created database objects and managed the permission access on the objects wif necessary security.
• Develop shell, PL/SQL, and SQL scripts to implement automation of ongoing administration and maintenance tasks.
• Reorganizing the database objects by archiving the data, moving the tables wifin the table space, and rebuilding the indexes.
• Involved inmonitoring the lock/block processes, releasing locksin case of resource blockage, and gathering statistics.
• Review alert logs and dump files to check for any problems related to the database.
• Developed Procedures for efficient error handling process by capturing errors into user managed tables.
• Refreshed non-production environment wif production using data pump.
• Checking Databases Backup and Restore validity periodically, and Data refreshes from Production to Non-Production environment, Creation Duplicate Databases using RMAN Backups.
• Database Cloning/Exp/Imp to setup identical databases in the production and development environments.
• Performance tuning for optimized results using tools like EXPLAIN PLAN, SQL*Trace, AWR and ADDM reports.
• Review alert logs and dump files to check for any problems related to the database.
• Develop shell, PL/SQL and SQL scripts to implement automation of ongoing administration and maintenance tasks.

Environment: ORACLE, SQL*Plus, PL/SQL, Oracle 9i/10g/11g/12c,18c &19c Golden Gate, Red Hat Linux, SQL developer, UNIX, Sun Solaris, Oracle Enterprise Manager, Data guard, ASM, RMAN, Toad, SQL*LOADER,10g,12c and 13c OEM, Exadata.

Confidential, Boston, Massachusetts

Oracle DBA

Responsibilities:

• Responsible for Oracle and Sybase Production, Development, test databases on Sun Solaris
• Support and Maintain of Oracle Databases 10g, 11g, 12c and 19c
• Handled huge databases ranging from 500GB to 10TB.
• Web Logic Server administration, monitoring and troubleshooting using Admin console.
• Enabled auditing using FGA policies setup TDE in database level, tablespace level and table level. Highly experienced in resolving issues related to Transparent Data Encryption.
• Installed and configured Oracle Enterprise Manager 13c Cloud control.
• Applied PSU/CPU patches on middleware, database and OEM. Upgraded databases from 9i to 10g and from 10g to 11.2.0.4 to 12.1 to 12.2
• Resolved end to end Golden Gate issues in production. Implemented Golden gate to Replicate data and keeping databases in sync until the time of cutover.
• Performed database maintenance activities such as rebuilding indexes, gathering statistics
• Helped in Tuning and optimizing SQL Query, SGA, Disk I/O using Oracle Enterprise Manager and by monitoring the stats pack report generated from snapshots taken at the peak business hours
• Creating and installing application schema objects in databases as per user requirements.
• Database cloning and Database refresh activities using RMAN and Data pump. Has implemented two type of standby databases supported by Data Guard, logical standby and physical standby databases in 12c on two node RAC. Resolved Dataguard issues like huge gap between primary and standby and switchover, failover.
• Responsible for User management, Database Security, Auditing, performance issues in database level

Environment: ORACLE, SQL*Plus, PL/SQL, Oracle 11g/10g, Golden Gate, Red Hat Linux 5, UNIX, Oracle Enterprise Manager, Data guard, ASM, RMAN, Toad.

Confidential, Tempe, Arizona

Oracle Database Administrator

Responsibilities:

• Responsible for Oracle and Sybase Production, Development, test databases on Sun Solaris
• Support and Maintain of Oracle Databases 10g, 11g, 12c and 19c
• Handled huge databases ranging from 500GB to 10TB.
• Web Logic Server administration, monitoring and troubleshooting using Admin console.
• Enabled auditing using FGA policies setup TDE in database level, tablespace level and table level. Highly experienced in resolving issues related to Transparent Data Encryption.
• Installed and configured Oracle Enterprise Manager 13c Cloud control.
• Applied PSU/CPU patches on middleware, database and OEM. Upgraded databases from 9i to 10g and from 10g to 11.2.0.4 to 12.1 to 12.2
• Resolved end to end Golden Gate issues in production. Implemented Golden gate to Replicate data and keeping databases in sync until the time of cutover.
• Performed database maintenance activities such as rebuilding indexes, gathering statistics
• Helped in Tuning and optimizing SQL Query, SGA, Disk I/O using Oracle Enterprise Manager and by monitoring the stats pack report generated from snapshots taken at the peak business hours
• Creating and installing application schema objects in databases as per user requirements.
• Database cloning and Database refresh activities using RMAN and Data pump. Has implemented two type of standby databases supported by Data Guard, logical standby and physical standby databases in 12c on two node RAC. Resolved Dataguard issues like huge gap between primary and standby and switchover, failover.
• Responsible for User management, Database Security, Auditing, performance issues in database level

Environment: s: Oracle 9i/10g, Sybase 12.5, Sun Solaris, OEM, EM, Data Gaurd, RMAN,SQL*PLUS,TOAD,STATPACK