SUMMARY:

• 10+ years of experience in teh IT Environment as an Oracle Database Administrator Providing 24/7 support.
• Manage Oracle database administration assignments for diverse industry clients.
• Experienced in upgrading and migrating oracle 9i,10g R2 databases to 11.2.0.1 and 11.2.0.2 on Linux5 and Solaris10.
• Experienced in migrating oracle 11.2 databases to 12.1.0.2.0 on linux and AIX platforms
• Excellent experience in installing and configuring oracle RDBMS and oracle client softwares using SILENT INSTALLATIONS and SOFTWARE CLONING.
• Experience with Oracle 12c/11g/10gRAC in manufacture, insurance, financial,telecom and banking industries in both Business Intelligence/Data warehouse Systems and OLTP Systems.
• Installation and configuration of 12c/11g/10g RAC on UNIX, solaris, HP and Windows environment.
• Experience in GOLDENGATE replication and SHAREPLEX for migrating teh databases.
• Experienced in installing and configuring UNIDIRECTION and Bi directional replication usingoracle
• Involved in Installation and Configuration of MS SQL Server 2000/2005/2008 /2012/2014/2016 Versions.
• Experience in installing and configuration of Sybase databases
• Experience working with data replication tools IBM CDC and informatica
• Experience working on HP - UX, AIX, SUN SOLARIS, Linux and Windows environments.
• Involved in administrating multiple 24*7 Production Oracle 8i/9i/10g/11g/12c RAC Databases as well as UAT/Dev/Test databases.
• Experience in migrating Oracle databases from Solaris to Linux, Non-ASM to ASM and Non RAC to RAC.
• Experience with Oracle Data Center infrastructures use commodity servers, network storage and full virtualization.
• Excellent experience in database migrations from stand alone to 11gR2 & 12.1.0.2.0 RAC and also cross platform migrations.
• Excellent experience in implementing data masking in oracle 11g,12c databases .
• Experience in 11g and 12C OEM Oracle Grid Control, Quest central and Quest Fog light for databases.
• Experience in AppWorx on Windows, LINUX, and AIX environments.
• Experience in Writing Perl Scripting, Shell Scripting, bash scripting and Partitioning.
• Experienced in Developing Oracle 9i/10g/11g PL/SQL Packages, Dynamic SQL, Triggers, Stored Procedures, Functions, DDL, and DML.
• Experienced in administration setup, data migration and data dictionary reconciliation.
• Worked on application servers Web logic, Web sphere in combination to oracle DB Oracle 10g.
• Experience on installing and Administrating Oracle Enterprise Security Manager (ESM).
• Experience working with Oracle E-Business Suite applications 11i & R12
• Experience in Database Administration tools like OEM (Oracle Enterprise Manager) Grid Control and TOAD.
• Experience in implementing ROLE based security as per SOX and OCC compliance and audit.
• Oracle Database capacity planning, space management and storage allocation.
• Strong Knowledge in Oracle Data ware house DBA skills relating to administration and management of VLDB environments, Oracle OLAP and Cognos.
• Knowledge and done POC on NOSQL,MYSQL, & MONGODB databases
• Working Experience with Hadoop & Bigdata
• Knowledge and experience in AWS, Microsoft Azure cloud and cloud technologies
• Strong Knowledge in People soft, SAP, Meta data & billing applications and also involved in reviewing performance reports with People soft & SAP Application developers.
• Highly Experienced in Hot/Cold Backup and Recovery and Cloning of databases using RMAN & HOT BACKUP methods.

TECHNICAL SKILLS:

Operating Systems: HP-UX 10.x, 11.x, Sun Solaris 9.0/10.0, AIX 5.1, 5.2, Red Hat Linux RHEL 2.1, 3.x, 4.x,5,6,7,SOA servers and Windows 98/NT/2000/2003/2008/2012/2014/2016

RDBMS: Oracle 12C 12.1.0.2.0,11gRAC/10gRAC/10g/9i/8i, SQL Server 2000/2005/2008/2012, MYSQL 4.1, 5.X

Languages: SQL, PL/SQL, Dynamic SQL, C, C++, UNIX Shell Scripting, Perl Script, korn scripting XML,GIT,JENKINS

DB Management: TOAD, OEM 9.2,11g,12c,13c, Cassandra-2.1, PostgreSQL 8.1/9.1

Tools/Utilities/Products: RMAN, OEM Grid Control 10g,11g & 12C, Ignite, ESM, SQL Navigator, SQL* Loader, ASM, SQL Server, Export/Import, TOAD, Patch Management, Oracle Warehouse Builder, Oracle Retek, SQLNET, ETL, Cognos, ODBC, Oracle Streams, Shareplex, Data pump, Data Guard, VERITAS Net Backup, VMware MS Office, Oracle EBS 11i/R12,Weblogic,Foglight,Precise,Informatica,TIBCO BC 5.2, TIBCO BE 3.2/5.x,TIBCO HAWK 4.9,TIBCO ADB6.x/SAP/File/MQ Adapters, Teradata V2R5, V2R6, V2R12

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, ADDM, AWR

Database Modeling: Erwin 4.0

PROFESSIONAL EXPERIENCE

Confidential, Wakefield, MA

ORACLE DBA

Responsibilities:

• Installed and configured 2 Node RAC of Oracle 12c 12.1.0.2.0 on half rac Exadata machine x6-2.
• Installed and configured GOLDENGATE 12.3.0.1.0 for teh Bi-directional replication for high availability mission critical oracle databases.
• Installed and configured Gloden Gate 12C for cascading replication on Red hat Linux platforms
• Expertise in debugging teh oracle gloden gate issues from ggserr.log and analyzing trial files using log dump utility
• Expertise in Gloden gate configuration in 12c and 11g for bidirectional, unidirectional and cascading replication
• Maintained ASM disk groups using ASMCMD and command utility.
• Installed and configured Oracle software using silent Installations on Exadata x6-2 server.
• Installed and configured 2node RAC cluster databases on Exadata x2-2 & x6-2 server.
• Performed Migration of 10TB data from windows server to Linux Exadata server using Gloden Gate unidirectional method and data pump.
• Configured Oracle Advanced Security Encryption Disk level & network level Encryption for teh databases.
• Performed numerous schema & table level refreshes from production to test and development databases using DATAPUMP and traditional exports & import Method
• Installed and configured Oracle 12C Release 2 Container & pluggable databases on Linux.
• Upgraded teh Oracle 11gR2 databases to 12c databases on teh AIX, Red hat Linux platform & Exadata.
• Supported Amdocs billing Software applications on 12C databases on teh AIX & HP Platform.
• Knowledge and done POC on NOSQL,SQL, DymamoDb & MONGODB databases.
• Worked on Creating, Reading and Updating Data in MongoDB.
• Configuring and monitoring replica sets in MongoDB
• Experience in Optimizing, monitoring, and understanding of MongoDB
• Worked on Installation and configuration of MongoDB
• Experience Sharding setup, sharding monitoring, shard key selection, inserting large amounts of data in MongoDB
• Performing Backup and recovery in MongoDB
• Worked on MongoDB database concepts such as locking, transactions, indexes, Sharding, replication, schema design.
• Experience in managing MongoDB environment from availability, performance and scalability perspectives
• Experience in performing Mongo DBA operational routines
• Working Experience with Hadoop & Bigdata
• Knowledge and experience in AWS Redshift and cloud technologies
• Experience in a Linux environment with Apache Tomcat on Amazon AWS
• Installed and configured MySQL on Linux and Windows environments
• Managing/Troubleshooting MySQL 5.0.22 and 5.1.24 in production and developer environments on Linux (5.0, 5.1)
• Increased database performance by utilizing MySQL config changes, multiple instances and by upgrading hardware
• Ability to carry out security tasks at network level such as block/unblock TCP/IP ports through firewall on both Linux and windows and block/unblock remote access to MySQL server
• Used Netezz SQL to maintain ETL frameworks and methodologies
• Sound noledge with Netezza SQL
• Participated in extraction and loading of data for Netezza data warehouses
• Performed RMAN backup and restore for 12c R2 databases.
• Installed and configured data guard for 11gR2 and 12c databases.
• Installed and configured SQL Server 2008 R2/2012/2014/2016.
• Experience working with shareplex replication
• Applied one off patches and PSU's to fix software related bugs, security related bugs and patch set upgrades using Opatch utility.
• Upgraded production databases from 11g R2 databases to 12.1.0.2.0 on linux and solaris platforms.
• Supported oracle databases for Amdocs billing applications
• Worked and supported teh Oracle ERP applications R12 & 11i on oracle 12C databases.
• Proficient in installation and upgrading Oracle Applications11i e-business suite to R12
• Applied patches to update and implement security fixes to Oracle E-Business Suite 11.5.5, 11.5.9, 11.5.10.2
• Installed, upgraded and maintained Oracle ERP applications version 11.5.10.2
• Administration of Oracle ERP applications version 11.5.10.2
• Clones/Refreshes of 11i instances
• Monitoring CPU usage, I/O Contention, memory paging on Exadata server. Provide technical direction to system administrator
• Experience working closely with teh application and developer teams and very good at communication with teh teams
• Developed Scripts that automated DDL and DML statements used in creations of Databases, Tables, Constraints, and updates.
• Extensively used Metadata & Data Dictionary Management, Data Profiling, Data Mapping.
• Resolved issues, planned requests as point-of-contact to vendors, oversaw developers, business users, following change control procedure, reported result
• Resolved performance issues by analyzing AWR & ADDM reports.
• Performance monitoring using OEM grid 12c & 11g
• Flash Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption).
• Created users and allocated appropriate table space quotas with necessary privileges and roles for all databases

Confidential, RICHMOND, VIRGINIA

ORACLE DBA

Responsibilities:

• Installed and configured 2 Node RAC of Oracle 11gR2 on half rac Exadata machine x2-2.
• Installed and configured GOLDENGATE 11.1 for teh uni-directional replication for high availability mission critical oracle databases.
• Maintained ASM disk groups using ASMCMD and command utility.
• Installed and configured Oracle software using silent Installations on Exadata server.
• Installed and configured 2node cluster databases on Exadata server.
• Performed Migration of 2TB data from windows server to Linux Exadata server using Gloden Gate unidirectional method and data pump.
• Performed numerous schema & table level refreshes from production to test and development databases using DATAPUMP and traditional exports & import Method
• Installed and configured Oracle 12C Release 1 on Linux.
• Upgraded teh Oracle 11gR2 databases to 12c databases on teh AIX platform.
• Supported People Soft applications on 12C databases on teh AIX Platform.
• Performed RMAN cloning using Active database feature in 11gR2 databases.
• Installed and configured Physical standby databases for 11gR2 databases.
• Installed and configured SQL Server 2008 R2.
• Configured Transactional Replication and SQL server log shipping on SQL server 2008 R2.
• Installed and configured Shareplex 8.0 on Linux server
• Experience working with shareplex replication
• Worked on Installation and configuration of MongoDB 2.4 versions
• Performing Backup and recovery in MongoDB
• Experience working with informatica data replication 9.6.2 version for teh oracle 12c databases
• Working Experience with SOA servers and file transfers using SFTP between teh servers
• Experience in setting up Oracle Advanced Security data encryption and integrity features
• Applied one off patches and PSU's to fix software related bugs, security related bugs and patch set upgrades using Opatch utility.
• Experienced in Automation using korn & Shell Scripting.
• Upgraded more than 30 production 10g databases to 11.2.0.4.1 on linux and solaris platforms.
• Supported oracle databases for people soft, Sap applications and Siebel CRM.
• Created and enhanced teh SAP roles, user Accounts in CUA (Central User Administration) environment, used SCAT for bulk changes in testing system
• Monitored all production systems using SAP Solution Manager (Solman) and fixed issues, also scheduled teh background jobs needed for teh project and dealt with teh job fails if any
• Performed SAP EHP 5.4 Installation on windows server 2008 R2 with Oracle 10g
• Configured SAP to enhance functionality and reporting
• worked with SAP profile Generator
• Monitoring CPU usage, I/O Contention, memory paging on Exadata server. Provide technical direction to system administrator
• Experience working closely with teh application and developer teams and very good at communication with teh teams
• Resolved issues, planned requests as point-of-contact to vendors, oversaw developers, business users, following change control procedure, reported result
• Resolved performance issues by analyzing AWR & ADDM reports.
• Flash Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption).
• Created users and allocated appropriate table space quotas with necessary privileges and roles for all databases

Confidential, MIAMISBURG, OHIO

ORACLE DBA

Responsibilities:

• Installed and configured 2, 3 & 4 node oracle 10g and 11gR2 RAC on Red hat Linux 5 for databases upto 3TB on ASM. Provided 24/7 production support to over 300+ databases ranging from oracle 10g to 11gR3 in Linux, solaris and AIX.
• Maintained ASM disk groups using ASMCMD and command utility.
• Performed Database Refreshes from Production to Test and Development environments using Clone process by RMAN Duplicate.
• Installed and configured OEM 12C Grid control for monitoring all Production and cert databases.
• Installed and configured Oracle 12C databases on Solaris Platform.
• Experience working on performance tuning on Oracle 12C databases.
• Installed and configured GOLDENGATE 11.1 for teh uni-directional replication for high availability mission critical oracle databases.
• Implemented data masking on columns having sensitive data using OEM.
• Experience in troubleshooting and fixing database and glodengate performance issues.
• Installed and configured oracle standalone 11gR2 databases using Oracle Database Configuration Assistant (DBCA) and through silent Installations Method.
• Performed numerous schema & table level refreshes from production to test and development databases using DATAPUMP and traditional exports & import Method.
• Configured and maintained physical standby for oracle 10g, and performed DR switch over test every month.
• Configured and maintained physical standby using 11.2.0.1 active DATAGUARD for disaster recovery and reporting.
• Experience in supporting teh oracle EBS application 11i on 11gR2 RAC databases
• Proficient in installation and upgrading Oracle Applications11i e-business suite to R12
• Installed, security, and maintenance of Linux based systems including Apache and MySQL 5.0.22 configuration
• MySQL database administration on a large scale MySQL installation.
• Experience with MySQL on both Linux and Windows
• Involved in migration and re-engineering of MySQL database from 4.1 to MySQL 5.1
• Responsibilities include Upgrading for two applications from MS SQL Server 2000 to MS SQL Server 2005
• Resolved performance issues by analyzing AWR & ADDM reports.
• Performed SQL statement Tuning using Explain Plans and SQL Trace using TKPROF utility an AUTOTRACE utility
• Experienced in upgrading SQL server 2005 to 2008.
• Upgraded and Migrated Database from 10g to 11g and applying patches whenever required.
• Applied one off patches and PSU's to fix software related bugs, security related bugs and patch set upgrades using Opatch utility.
• Flash Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption).
• Monitoring CPU usage, I/O Contention, memory paging on UNIX server. Provide technical direction to system administrator and monitoring teh Oracle EBS applications with teh team.
• Created users and allocated appropriate table space quotas with necessary privileges and roles for all databases.
• Performed logical and physical data modeling and database design for an Oracle Retail Data ODS designed to enable Retail LOB fraud detection data mining with teh use of analytics tools.
• Analyzing tables and indexes for performance tuning. Optimizing database objects and streamlining applications

Confidential, COLUMBUS,OHIO

Oracle DBA

Responsibilities:

• Installed and Monitored teh Oracle database on 10g and 11gR2 in RHEL 5
• Installed Oracle 11gR2 in PeopleSoft environment.
• Upgrade GOLDENGATE from 10 to 11.1
• Installed and configured GOLDENGATE 10 and 11.1 for teh unidirectional and Bidirectional replication for high availability oracle databases.
• Identified and resolved errors through log dump utility, GGSEVT
• Performed GOLDENGATE upgrades from V10.4 to 11.1 for oracle 11G databases
• Experience in managing teh Gloden Gate performance by reducing lag between source and target
• Installed and configured 2 node oracle 11.2.0.2 Rac on AIX 6.1 for a 15TB database on ASM and Raw devices.
• Experienced in setting up Oracle 10g and 11gR2 2 and 4 Node RAC implementations & administration using CRSCTL, SRVCTL command utilities in AIX 6.1 environments
• Maintained ASM disk groups using ASMCMD and command utility.
• Converted numerous single instance databases to 11gR2 RAC on 2node and 3node architectures
• Experience in maintaining large databases upto10TB supporting SAP and Peoplesoft applications.
• Dealt with teh problems or bugs with SAP software by interacting with SAP Service team through OSS (Online service support) messages and applying SAP Notes or patches required
• Tested custom SAP transactions to ensure proper functionality.
• Performed SAP EHP 5.4 Installation on windows server 2008 R2 with Oracle 10g
• Installing SAP GUI for windows & enabling teh WEBGUI
• worked with SAP profile Generator
• Installed and configured OEM 11g Grid control for monitoring all Production databases.
• Configured alerts, thresholds and reports using OEM across all teh enterprise databases.
• Experienced in upgrading SQL server 2005 to 2008.
• Configured MS SQL server 2005 on windows server 2003.
• Migrated over 50 schemas from AIX 5.2 platform to AIX 6.1up to 50 TB.
• Performed Data guard switch over and failovers using SQL commands and DGMGRL utilities.
• Configured and maintained physical standby using 11.2.0.1 active DATAGUARD for backup and reporting.
• Successfully performed several quarterly DR switchover exercises.
• Developed batch processes for financial reporting applications and modules using Korn shell scripts on Oracle databases
• Provided DBA support during code releases and quarterly updates
• Implemented and improvised database security using Role based security model.
• Maintained large OLTP databases sizing upto30 TB in my current project.
• Created and configured 10g and 11.2.0.2 databases using Oracle Database Configuration Assistant (DBCA) and through silent Installations Method.
• Monitoring CPU usage, I/O Contention, memory paging on UNIX server. Provide technical direction to system administrator and monitoring teh Oracle EBS applications with teh team
• Daily monitoring of over 120 databases using OEM Oracle Enterprise Manager and Toad.

Confidential, Seattle, WA

Oracle DBA

Responsibilities:

• Installed and Monitored teh Oracle database on 11g RAC in RHEL.
• Involved in performing migration from Oracle 10g to Oracle 11gRAC database.
• Upgraded oracle RAC 11.1.0 to 11.2.2 using Oracle Gloden Gate and in PeopleSoft environment.
• Supported Remote DBA Support for Oracle 9i/10g and 11g.
• Monitored and Tuned database to optimize teh performance of Oracle EBS applications.
• Installed and Monitored teh Oracle database on 10g RAC in Solaris Servers using ASM and also with Oracle EBS applications.
• Upgrade and Migration of Database from 9.2.0.6 to 10.2.0.2 and applying patches wheneverrequired.
• Installation and maintenance of Oracle 11g 24*7 Production Environment.
• Implemented Oracle Streams for teh replication of data in Development to Production.
• Experience in Data modeling.
• Upgrade and Migration of Database from 10g to 11g and applying patches whenever required.
• Configuring database entries, monitoring and maintaining user security for all of teh databases using Oracle Enterprise Manager (OEM) Grid Control and Enterprise Security Manager (ESM).
• Troubleshooting on teh databases for Application Server and Oracle database related issues.
• Developed PL/SQL packages, Dynamic SQL, DML, DDL, Oracle tables, stored procedures, functions, Cursors, triggers and UNIX Shell scripts.
• Administration of Oracle networking using Sqlnet, Tcp/Ip and Listener setup for oracle databases.
• Created Heterogeneous services for accessing teh database links from an Oracle database to SQL server database.
• Data Refresh from Production to Test and Development environments using RMAN Duplicate Database.
• Daily Health Checkup of teh database using STATSPACK, AWR, ADDM.
• Involved in Oracle Warehoused Builder creating Star schemas, Partitioned Materialized Views and logs utilizing Query Rewrite and Start Transformation.
• SQL statement Tuning using Explain Plans and SQL Trace using TKPROF utility and AUTOTRACE utility.
• Analyzing tables and indexes for performance tuning. Optimizing database objects and streamlining applications.
• Optimizing Oracle RMAN and ASM environment.
• Taking Periodic Backup of teh databases and teh software using RMAN.
• Flash Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption).

Confidential

Oracle DBA

Responsibilities:

• Installed Oracle 10gRAC database on Redhat Linux using ASM.
• Migrated Databases from 9.2.0.3 on Linux to 10.2.0.3 on HP-UX.
• Monitored and Tuned database to optimize teh performance and satisfy teh availability and Oracle EBS applications.
• Performance Tuning by using Oracle utilities like EXPLAIN PLAN, STATSPACK, and TKPROF for addressing performance bottlenecks is performed.
• Logical and Physical data modeling using Erwin, Dimensional/OLAP data modeling.
• Taken Backup & Recovery by using RMAN.
• Analyzed and monitored that data got by ADDM performed logical database using Export utility.
• Adopted general DBA tasks like Indexes, Partitioning and Flashback Recovery.
• Used Oracle Retek Space Optimization for optimal space and allocation recommendations.
• Used Snapshots for Replication and synchronization data with other branches.
• Used Snap Mirror for creating duplication of production databases.
• Implemented Oracle Data Guard for maintained oracle disaster recovery
• Manage Enterprise databases, users and roles by Oracle Enterprise Grid Control.
• Developed Dynamic SQL, PL/SQL Scripts, Packages and views.
• Created Data Modeling and Data definition Language (DDL) to support development efforts.
• Created and maintained different database entities included table spaces, data files; redo log files, rollback segments and renaming/relocating of data files on servers.
• Created PARTIONING of its types like Range, List & Hash by teh specific use.
• Supported development effort by providing SQL statement tuning and query performance bottlenecks by using tools Explain Plan, SQL Trace, TKPROF, TOAD and Oracle Enterprise Manager.
• Trouble shooting and resolving any database and/or application issues or errors that occurred.
• Developing shell scripts and using various tools monitored teh various database activities.
• Utilizing OEM SQL Analyze, OEM Grid Control, STATSPACK, SQL Trace, and TKPROF etc.