OBJECTIVE

• To obtain a challenging software consultant position with an opportunity to work as an Oracle DBA/Data warehouse Architect utilizing my ORACLE, ORACLE APPLICATIONS, UNIX, C, C++, JAVA, SQL, and PL/SQL skills.

SUMMARY

• 17 years experience as an Oracle DBA, 17 years experience as a physical and logical Oracle
• DBA. Strong skills of Oracle products, Oracle databases and management tools.
• Administered the databases of 80 TB size through the complete cycle of projects.
• Strong expertise in performance tuning, backup recovery, Architecture, Capacity Planning and troubleshooting.
• Ability to work effectively in a team environment and provide logical and efficient solutions.
• Strong sense of ownership and commitment to technical excellence.
• Strong communication, Presentation and Customer Management Skills.
• Installation, maintenance, cloning, Patching and upgrade of Oracle databases 12c and 11g.
• Installation, upgrade, Patching and management of Oracle databases on Unix and Windows Platforms.
• Logical and Physical design of Oracle databases using Erwin.
• Expert level knowledge and working experience of AWS and Oracle cloud products and services
• Proven hands - on cloud migration solution design/delivery experience.
• Ability to effectively address data security concepts in public cloud as it relates to customer needs including an in depth understanding of Federated Security / Single Sign On, and AWS IAM
• Strong skills of Oracle RAC, Streams, Data Guard, Physical Standby and Flashback Technology.
• Strong skills of Performance tuning and optimization of Oracle databases and applications.
• Strong skills of virtualization Oracle VM, VMware, Hypervisor etc, storage, networking, processor architectures and distributed computing.
• Design and Implementation of backup and recovery, disaster Planning and failover plans.
• Design and Implementation of data warehouse including Dimensional Modeling.
• Strong Knowledge of other databases MySQL, SqlServer, MongoDB, Postgres etc
• Strong skills of Data modeling, Data warehouse, Data Mining, Informatica and ETL tools.
• Design, Implementation and Administration of distributed databases and Oracle Streams.
• Capacity Planning, Architecture Recommendations and Project Management.
• Creation of table spaces, datafiles, roles, redo logs, rollback segments, stored procedures and Triggers
• Strong skills in SQL* Loader, Import/Export Server Manager, SQL* PLUS, PL/SQL, Developer 11g, Unix Shell scripts, awk, ‘C’ programming.
• Strong skills of Unix, Network, Tuxedo, Weblogic, Apache, Oracle 10gAS and iPlanet administration.
• On call technical support for 24x7 mission critical production databases
• Used n-tier architecture design extensively.
• Mentoring Junior team member.

TECHNICAL SKILLS

Databases: Oracle12 c, Oracle 11g, Oracle 10g, DB2, SQL Server 2008, SQL Server 2015, Sybase, Informix and MS-Access

Tools: SQL* Loader, Import/Export, Data Pump, ERWIN 3.5, Grid, Informatica, Oracle Enterprise Manager, Sybase Central, Sun Cluster, Rman, Discoverer 10g, Hyperion, PeopleSoft, Oracle ERP, OBIEE, Golden Gate

Platform: Sun Solaris E25k, HP - PA8700, IBM p690, Windows 2008 Servers

Operating Systems: HP-UX 11i, Linux, AIX 5L, Solaris 9 to 10, Windows 2003, and Windows 2008

Languages: 'C', C++, 'SQL', SQL*PLUS,'PL/SQL', Shell Scripting, Perl, Java, CGI, XML, SQR

PROFESSIONAL EXPERIENCE

Lead Oracle Architect/DBA

Confidentia, Dallas, Texas

Responsibilities:

• Implemented latest Oracle technologies like Data Guard, Streams, RAC, ASM, Streams and Oracle Grid. As an Oracle DBA the following tasks were done
• Implementation of Oracle 12c RAC on 6 nodes using EMC and ASM
• Strong Skills of Oracle Container database(CDB) and Pluggable database(PDB) features.
• Used Oracle 12 C Flex ASM and Hub and Leaf Nodes for Oracle 12c RAC .
• Installation and configuration of Oracle databases on Sun Solaris and Linux.
• Used Real Applications Testing (RAT) for the Major changes to Prod.
• Expert level knowledge and working experience of AWS and Oracle cloud products and services.
• Proven hands-on cloud migration solution design/delivery experience.
• Ability to effectively address data security concepts in public cloud as it relates to customer needs including an in depth understanding of Federated Security / Single Sign On, and AWS IAM
• Upgrade of Oracle databases from 11g to 12c on RAC and ASM.
• Upgrade Oracle OEM 11g to 12c and patching using OEM 12c.
• Strong skills of Oracle 12c ASM and OEM 12c Grid Infrastructure.
• Installation, configuration and Administration of Oracle DataGuard 12c.
• Installation, Configuration and Administration of Oracle Golden Gate.
• Design, implementation, administration, optimization and maintenance of Oracle Golden Gate 12 C
• Troubleshooting complex Golden Gate production issues including latency optimization Golden Gate configuration and optimization on RAC environment
• Set up of Golden Gate 12c unidirectional and bi-directional mappings and Conflict Resolutions.
• Golden Gate 12c patching and upgrades from 11g to 12c.
• Handling of large volume transaction loads in various replication scenarios and fast resolution of issues
• Strong Knowledge of other databases MySQL, SqlServer, MongoDB, Postgres etc.
• Administration, Configuration and Tuning of Informatica and Informatica Mappings.
• Tuning of Oracle databases using AWR, ADDM, SQL trace and tkprof.
• Support to developer for development tasks.
• Configuration, Patching and Administration of Oracle Exadata 12c.
• Migrate databases from X3 Exadata to X5 Exadata.
• Tuning of databases and Query after Migrations to Exadata X5-8 full Rack.
• Support and Administration of databases on Oracle Exadata and ZFS appliances
• Automation of ZFS cloned Oracle databases.
• Automation of ZFS backups and restores for the Enterprise Oracle databases.
• Tune the OLTP and Datawarehouse databases on RAC using AWR and ADDM.
• Apply database patches using opatch and follow the change control.
• Implementation of High availability using Dataguard and RAC 12c on Solaris Platform.
• Installation of Oracle Applications server, Weblogic server and configure High Availability.
• Refresh of database environments from RAC to non RAC and support to 40 developers.
• Worked for Various Tar Resolutions and worked with Oracle support using Metalink and OWC.
• Complete Life cycle implementation of Oracle Projects in 12 sites.
• Support mission Critical Production database 24x7
• Design and Implementation of Backup Recovery using Rman and netbackup.
• Implemented Disaster Recovery sites using Oracle Physical standby database and data guard

Lead Oracle Architect/DBA

Confidential, Texas

Responsibilities:

• Implementation of Oracle 12c RAC on 4 nodes using Exadata.
• Installation and configuration of Oracle databases 12c on Sun Solaris, AIX and Linux.
• Strong Skills of Oracle Container database (CDB) and Pluggable database (PDB) features.
• Upgrade of Oracle databases from 11g to 12c on RAC and ASM.
• Expert level knowledge and working experience of AWS and Oracle cloud products and services.
• Proven hands-on cloud migration solution design/delivery experience.
• Ability to effectively address data security concepts in public cloud as it relates to customer needs including an in depth understanding of Federated Security / Single Sign On, and AWS IAM
• Upgrade Oracle OEM 11g to 12c and Oracle patching using OEM 12c.
• Used Real Applications Testing (RAT) for the Major changes to Prod.
• Installation, configuration and Administration of Oracle DataGuard
• Strong skills of Oracle 12c ASM and OEM 12c Grid Infrastructure.
• Installation, Configuration and Administration of Oracle Golden Gate.
• Design, implementation, administration, optimization and maintenance of Oracle Golden Gate 12 C
• Troubleshooting complex Golden Gate production issues including latency optimization Golden Gate configuration and optimization on RAC environment
• Set up of Golden Gate 12c unidirectional and bi-directional mappings and Conflict Resolutions.
• Golden Gate 12c patching and upgrades from 11g to 12c.
• Handling of large volume transaction loads in various replication scenarios and fast resolution of issues
• Strong skills of shell scripting and Perl for various automation tasks.
• Strong Knowledge of other databases MySQL, SqlServer, MongoDB, Postgres etc.
• Administration, Configuration and Tuning of Informatica and Informatica Mappings.
• Tuning of Oracle databases using AWR, ADDM, SQL trace and tkprof.
• Strong skills of virtualization Oracle VM, VMware, Hypervisor etc., storage, networking, processor architectures and distributed computing.
• Support to developer for development tasks and troubleshoot issues.
• Configuration and Administration of Oracle Exadata 11g.
• Tune the OLTP and Datawarehouse databases on RAC using AWR and ADDM.
• Apply database patches using opatch and follow the change control.
• Implementation of High availability using Dataguard and RAC 12c on Solaris Platform.
• Implementation of Oracle Maximum availability Architecture (MAA) for five 9 SLAS.
• Installation of Oracle Applications server 10gAS and configure High Availability.
• Refresh of database environments from RAC to non RAC and support to 40 developers.
• Worked for Various Tar Resolutions and worked with Oracle support using Metalink and OWC.
• Complete Life cycle implementation of Oracle Projects in 40 sites.
• Support mission Critical Production database 24x7
• Design and Implementation of Backup Recovery using Rman and netbackup.
• Implemented Disaster Recovery sites using Oracle Physical standby database and data guard

Lead Oracle Architect/DBA

Confidential, Texas

Responsibilities:

• Implementation of Oracle 11g RAC on 4 nodes using EMC and ASM
• Installation and configuration of Oracle databases on Sun Solaris and Linux.
• Upgrade of Oracle databases from 10g to 11g on RAC and ASM.
• Strong skills of Oracle 11g ASM and Grid Infrastructure.
• Installation, Configuration and Administration of Oracle Golden Gate.
• Administration, Configuration and Tuning of Informatica and Informatica Mappings.
• Tuning of Oracle databases using AWR, ADDM, SQL trace and tkprof.
• Support to developer for development tasks.
• Tune the OLTP and Datawarehouse databases on RAC using AWR and ADDM.
• Apply database patches using opatch and follow the change control.

Lead Oracle Architect/DBA

Confidential, Texas

Responsibilities:

• Implementation of Oracle 11g RAC on 6 nodes using EMC and ASM
• Installation and configuration of Oracle databases on Sun Solaris and Linux.
• Upgrade of Oracle databases from 10g to 11g on RAC and ASM.
• Strong skills of Oracle 11g ASM and Grid Infrastructure.
• Installation, Configuration and Administration of Oracle Golden Gate.
• Configuration and Administration of Oracle Exadata 11g.
• Administration, Configuration and Tuning of Informatica and Informatica Mappings.
• Tuning of Oracle databases using AWR, ADDM, SQL trace and tkprof.
• Support to developer for development tasks.
• Installation, configuration and Administration of Oracle DataGuard
• Tune the OLTP and Datawarehouse databases on RAC using AWR and ADDM.
• Apply database patches using opatch and follow the change control.
• Used Real Applications Testing (RAT) for the Major changes to Prod.
• Implementation of High availability using Load Balancer and RAC 10g on Solaris Platform.
• Installation of Oracle Applications server 10gAS and configure High Availability.
• Refresh of database environments from RAC to non RAC and support to 40 developers.
• Worked for Various Tar Resolutions and worked with Oracle support using Metalink and OWC.
• Complete Life cycle implementation of Oracle Projects in 40 sites.
• Support mission Critical Production database 24x7
• Design and Implementation of Backup Recovery using Rman and netbackup.
• Implemented Disaster Recovery sites using Oracle Physical standby database and data guard.

Lead Oracle Architect/DBA

Confidential, Knoxville TN

Responsibilities:

• Implementation of Oracle 10g RAC on 3 nodes with Physical Standby database and Data Guard.
• Installation and configuration of Oracle databases.
• Upgrade of Oracle databases from 10g to 11g on RAC and ASM.
• Upgrade of Oracle databases from 9i to 10.2.0.2
• Strong skills of Oracle 11g ASM and Grid Infrastructure.
• Administration, Configuration and Tuning of Informatica and Informatica Mappings.
• Tuning of Oracle databases using AWR, ADDM, SQL trace and tkprof.
• Implemented SOX compliance and set up of security and Auditing on Oracle databases.
• Support to developer for development and upgrade tasks.
• Upgrade of Solaris 9 to Solaris 10 with Oracle database 11.
• Install and Configure Mercury Load Runner and carry out the stress test.
• Help the Customer in the Migrations etc using ITG and OM.
• Apply database patches using opatch and follow the change control.
• Implementation of High availability using Load Balancer and RAC 10g on Solaris Platform.
• Installation of Oracle Applications server 10gAS and configure High Availability.
• Refresh of database environments from RAC to non RAC and support to 40 developers.
• Worked for Various Tar Resolutions and worked with Oracle support using Metalink and OWC.
• Complete Life cycle implementation of Oracle Projects in 200 sites.
• Support mission Critical Production database 24x7
• Design and Implementation of Backup Recovery using Rman and netbackup.
• Implemented Business Continuity using Oracle Physical standby database.

Lead Oracle DBA/Architect

Confidential, Chicago

Responsibilities:

• Upgrade of Discoverer 4i to 10g and on Sun Solaris 10 Platform.
• Supported the Cognos Planning and Cognos report.
• Supported the development and functional team for various tars and database issues.
• Administration, Configuration and Tuning of Informatica and Informatica Mappings.
• Support to developer for Informatica Development.
• Upgrade of Solaris 9 to Solaris 10 with Oracle 10g.
• Tuning of Oracle RAC, SQL and Oracle database and application servers.
• Implemented Sox compliance and Set up of Auditing in Oracle database 10g.
• Install and Configure Mercury ITG, Object Migrator, Load Runner.
• Help the Customer in the Migrations etc. using ITG and OM.
• Design and Implementation of Backup Recovery and DR Strategy.
• Install Oracle database 10g with RAC on 4 Tier nodes on sun Solaris and ASM.
• Implementation of High availability using Load Balancer and RAC 10g on Solaris Platform.
• Installation of Oracle Applications server 10gAS and configure High Availability.
• Implemented Oracle Data Guard, Streams, Physical Standby database.
• Cloning of database environments from RAC to non RAC and support to 25 developers.
• Worked for Various Tar Resolutions and working with Oracle support using Metalink and OWC.
• Complete Life cycle implementation of Application on Oracle database 10g in 10 countries.

Lead Oracle Architect/DBA American

Confidential, Dallas Texas

Responsibilities:

• Implementation of DR site using Data Guard and Physical Standby databases.
• Implemented Oracle 10g RAC and Load Balancer on Linux.
• Integration of Oracle apps server 10g with Oracle ERP 11.5.10.
• Cloning, Patching, performance tuning of Database Instances.
• Worked as Customer Contact for Oracle on Demand Solution.
• Advised the Customer for new products and directions in Oracle Technologies.
• Supported the Mission Critical Production databases of 1 TB Size.
• Troubleshoot Various Linux and Network related Issues.