SUMMARY:

• Overall 7+ years of IT related experience. With over 5 years of hands - on experience as an Oracle Database and Fusion Middleware Administrator and over 3 years’ experience planning, designing, implementing and maintaining system applications in AWS Cloud in Windows and Linux environments as a cloud security and apps engineer. I am very comfortable supporting a full database system development life cycle. Worked with Oracle 10g, 11g and 12c versions where database administration duties involved production support, installation, configuration, upgrades, patches, migration, backup and recovery, performance tuning, cloning, space management and security. Apply patch, upgrade & cloning of Oracle E-Business suite. Working on both OEM 12c and 13c.
• AWS - EC2, RDS, S3, Glacier, SQS, SNS, SES, CloudFormation, VPC, IAM, Route53, EBS, DynamoDB, Lambda, Kinesis, Cloudwatch
• Experience in maintenance and configuration of user accounts for dev, QA, and production servers and created roles for EC2, RDS, S3, CloudWatch, EBS resources to communicate with each other using IAM.
• Experience in migrating and implementation of multiple applications from on premise to cloud using AWS services like SMS, DBMS, CloudFormation, S3, Route53 Glacier, EC2, RDS, SQS, SNS, Lambda and VPC.
• Build and configure a virtual data center in the Amazon Web Services cloud to support Enterprise Data Warehouse hosting including Virtual Private Cloud (VPC), Public and Private Subnets, Security Groups, Route Tables, Elastic Load Balancer.
• Build servers using AWS, importing volumes, launching EC2, RDS, creating security groups, auto-scaling, load balancers (ELBs) in the defined virtual private connection.
• Designed AWS Cloud Formation templates to create multi region Web applications and databases.
• Highly Experienced in Hot/Cold Backup and Recovery and Cloning of databases using RMAN.
• Database upgrades from 11g to 12c using DBUA, DATA PUMP and Transportable tablespaces
• Developed custom Oracle Forms, custom APIs, data uploading scripts, custom packages and triggers, E-business Suite Personalizaions and developed code for Custom.pll library for enhanced functionalities
• Oracle Database performance-tuning services with EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE. Applying patches under UNIX platform.
• Configured and administered 12c PDB and CDB databases.
• Planned and implemented high availability solutions such as Real Application Cluster (RAC) in Oracle 11gR2 Grid and 10g on ASM and OCSF2 file systems.
• Performance tuning of application and database, identification and resolution of contention, defining and implementing Backup Recovery policy, and day-to-day monitoring of the Production database
• Extensively implemented Datapump, conventional Export/Import (Oracle 11g, 10g) for migration and logical backup of database.
• Strong skills in applying security patches (Patch set, Critical Patch Updates (CPU) / Patch Set Updates (PSU), One-off Patch) using “runInstaller” and perl based utility “opatch”.
• Knowledge in configuring ASM (Automatic Storage Management)
• Installed, configured and maintained Physical, Logical, Active standby databases supported by Data guard on Oracle 11g, 10g RAC servers for the purpose of disaster recovery procedures.
• Proficient with Database Cloning, Migration, and Patching of Oracle Databases.
• Highly experienced in implementing Oracle's Fusion Middleware components from Weblogic server, Oracle identity manager including OID and OAM integration for Single-Sign-on (SSO).
• Oracle Identity and Access Management suits. (OID, OVD, OUD)
• Experienced in using 10g features like 10g RMAN, Data pump Flash-Back Recovery and ASM, NOsql.
• Knowledge of Database Recovery Techniques and implementation of those recovery techniques to ensure business continuity.
• Expertise in maintaining Database Security using auditing.
• Experience in PeopleSoft HRM and PeopleSoft Finance modules
• Configured Manager, Replicate and Extract processes and implemented unidirectional, bidirectional replication using Oracle 11g Golden Gate on RHEL 5 platform.
• Oracle forms and reports. Oracle ADF
• Strong knowledge of BI solution with Star Schema, Snow Flake Schema, Dimension and Fact table.
• Configure OBIEE and SQL Reporting Services (SSRS) for Developing Drill Tabular Reports, Matrix Reports and Drill Down Reports. Experience in doing upgrades including maintenance & monitoring implementation.
• Extensive knowledge in UNIX platforms includes SOLARIS, AIX, and LINUX.

TECHNICAL PROFICIENCIES:

Tunning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, AWR, and ADDM.

Languages: SQL, PL/SQL, UNIX Shell Scripting, PERL. JSON, Python, s3 API

Tools: and Utilites: Cloudwatch, RMAN, OEM, SQL*Loader, EXP, IMP, Data pump, TOAD, Oracle SQL Developer.

RDBMS: Oracle 10g, 11g, 12c

Operating Systems: HP-UX 10.x, 11.x. Sun Solaris 2.5, 2.6, 8, 9, 10. AIX 5.1, 5.2, 5.3, 6.1 RHEL 2.1, 3.x, 4.x, 5.x. Linux Enterprise Server 9, 10. Windows 95/98/NT/2000.

PROFESSIONAL EXPERIENCE:

Confidential, San Diego, CA

Oracle Database Administrator

Responsibilities:

• Responsible for installing, configuring, managing and supporting all Production, Development environments of Oracle Version 10g and 11g databases on Linux and HP-UX.
• Responsible for creating roles, assign system /object level privileges to the roles and assign users to these roles.
• Applying upgrade patch, maintenance and interim (opatch) patches on all the databases.
• Refreshing Dev and Test instances with data from Production on a regular basis.
• Installed Oracle 11g on Linux platform using ASM.
• Working with optimizer Hints and Explain Plan for estimating performance and to generate optimal solutions.
• Worked on building and rolling out new 12c databases for TEST/DEV/QA environments.
• Implemented oracle 12c active standby database for test database environment
• Performing all the Database Administration activity like space management in database, user and roles administration, schema management, checking alert log of all the databases.
• Configured RMAN Catalog database and registered target databases with catalog.
• Performance Tuning for Optimized results using Explain-Plan, SQL-Trace, STATS PACK reports and AWR Reports. Provided recommendations using ADDM reports. Analyzed the trace files Using TKPROF utility.
• Gathered statistics, rebuilt indexes and updated statistics on tables to improve performance.
• Diagnosed Oracle bugs and coordinating with Oracle support to resolve them in timely manner.
• Performed various tasks like Administering RAC using SRVCTL, adding nodes and instances, Administering Storage Components, Parameter Management, and Configuring High Availability Features for RAC.
• Responsible for database sizing, Tablespace Management and Rollback Tablespace Management, Transaction Management and Security Administration.
• Scheduling repetitive activities like gathering schema statistics, exports, tablespace usage report using crontab.
• Applied PSU Patches (10.2.0.4, 10.2.0.5) as a part of maintenance activity.
• Extensively used Data pump, conventional export/import utilities for loading data to and from databases, logical backups and migration of databases.
• Monitoring and optimizing the performance of the database/application using OEM along with scripts.
• Capacity planning: Allocate system storage and plan future storage requirements.
• Worked on SQL tuning using SQL Tuning Advisor, SQL Access Advisor, SQL Profiler and SQL Optimizer.
• Installation and configuration of Oracle databases environments (10/11g), upgrades, patching for security vulnerabilities (CPU and PSU).
• Performing monthly and annual performance reports for trend analysis and capacity planning.
• Assist in SQL tuning and providing consultation such as creating Materialized views, adding indices, dropping unnecessary indices, using hints wherever possible, amongst others.
• Troubleshooting of various database performances by proper diagnosis Confidential all levels
• Knowledge in Oracle Data warehouse DBA skills relating to administration and Oracle OLTP.
• Experience in writing UNIX/SHELL scripts for providing the reports.
• Diagnosed Oracle bugs and coordinated with oracle support to resolve them in timely manner. creating partition tables using Range, hash, list partitioning and indexing them for the purpose of improving performance of database
• Performing daily maintenance tasks like space management, rectifying locking problems and performance monitoring and configuring network management components like TNSNAMES

Environment: Oracle 11g/11g RAC/10g, VMS, Sun Solaris, Windows Server 2003, Red Hat Linux, TOAD, RMAN, SQL server, OEM.

Confidential

Oracle Database Administrator

Responsibilities:

• Designed, developed and maintained UNIX shell scripts to collect and monitor database metrics and Statspack snapshots and reports.
• Performed Table Partitioning, created Index Organized tables and Locally Managed Tablespaces.
• Provided maintenance of user accounts, privileges, profiles and roles.
• Involved with OLTP relational databases system analysis, design, implementation and management.
• Involved in a fresh installation of the Oracle E-Business 11.5.9 on IBM/AIX for the Gulfstream Oracle A/R project; implemented Oracle 11i upgrade plan and performed installations, upgrades, and configurations for Oracle application iStore from release 11.5.7 to release 11.5.9 on SUN-Solaris platform.
• Upgrade/Migration of Databases from Oracle 11g to 12c, Cross platform migration from different platforms.
• Provides Functional Support for Kofax (Markview) Invoice Document Management and Integration with Oracle E-Business Suite.
• Utilized Grid Control to administer multi-node RAC database also managed redo and undo in the RAC environment. Load balancing of RAC instances.
• Management, RAC, Flashback features, DBMS Scheduler, ASSM and ASMM to improve performance and manageability.
• Implemented the Oracle 11g Physical Data Guard in Maximum performance mode for production system in case of disaster recovery, maintained primary and standby databases.
• Applied Patches on RAC, Standalone, Standby databases based on the requirements to E-Business suites applications.
• Evaluated mix of backup and recovery methods based on organizational needs. Implemented, tested and documented various backup/recovery scenarios for knowledge base.
• Used Data Pump for export and import. Wrote scripts for Backup of databases, maintenance of archive logs for databases. Streamlined backup procedures and implemented RMAN for backup and disaster recovery.
• Refreshing Dev and Test instances with data from Production on a regular basis.
• Performance tuning of application and database, identification and resolution of contention, defining and implementing
• Backup Recovery policy, and day-to-day monitoring of the Production database Experience in writing UNIX/SHELL scripts for providing the reports.
• Installed and configured Oracle 11g database on a test server using Oracle standard procedures and OFA, for performance testing and future 10g production implementation.
• Responsible for the Installation, Configuration and Maintenance of Oracle 10g/11g/11c Single Instances and RAC databases for High Availability and Disaster Recovery. • Performed patching, upgrade and migration of multiple development, test and production databases from 10g/11g to 12c and migration to different platforms.
• Performed backup and recovery strategy using Recovery Manager (RMAN) - physical backup - and Data Pump (Import/Export) - logical backup, respectively.
• Installed, configured and manage OEM 12c and 13c
• Performed Performance Tuning using SQLTRACE, EXPLAIN PLAN, TKPROF, STATSPACK, AWR and ADDM.

Environment: AWS/oracle - EC2, S3, Glacier, SMS, DBMS, RDS, SQS, SNS, SES, CloudFormation, VPC, Redshift, DynamoDB, Oracle 12c, 11g, 10g, Linux, OEM 12c, RMAN, Python, MySQL, MS SQL Server 2012, E-Business Suite 11r2, E-business suite 12. OEM 13c.

Confidential, Suitland, MD

Oracle Database Administrator

Responsibilities:

• Experience on working with data guard physical/logical standby databases.
• Used Data Pump for export and import. Wrote scripts for Backup of databases, maintenance of archive logs for databases. Streamlined backup procedures and implemented RMAN for backup and disaster recovery.
• Provided PeopleSoft technical support to developers for maintaining overall performance of databases while troubleshooting daily issues as they arise.
• Used SBM and remedy to engage in day to day support of tickets
• Formulated and managed database stored procedures, database administration scripts and database functions.
• Troubleshoot daily production issues from user authentication to session wait events and locks to general performance optimization
• Worked with development team to rewrite application codes to provide better execution plans to ensure optimal performance.
• Performance tuning of application and database, identification and resolution of contention, defining and implementing Backup Recovery policy, and day-to-day monitoring of the Production database Created, managed and analyzed disaster recovery plan, database backup and capacity planning strategies.
• Examined, identified and formulated solutions to resolve issues in PeopleSoft environments for best performances.
• Maintained and updated SOP technical documents for the team.
• Monitored and managed performance of PeopleSoft environments Confidential every phase including installation of patches, updates, and upgrades.
• Designed and implemented technical upgrades of all PeopleSoft applications.
• Install and configure oracle Weblogic and Fusion Middleware components including weblogic server, BI Publisher, Forms and Reports instances on RedHat Linux 6.
• Configure and administer oracle Identity manager (IDM), including OID and OAM and integration of both for Single-sign-on (SSO) and more robust user security.
• Created logical and physical design installed and upgraded databases.
• Experience in troubleshooting server configuration issues on Forms and Reports, oracle Identity.
• Evaluate, install deploy and administer ADF applications including security patches and other changes across environments.
• Applying upgrade patch, maintenance and interim (opatch) patches on all the databases.
• Refreshing Dev and Test instances with data from Production on a regular basis.
• Developed PL/SQL packages, DML, DDL, Oracle tables, Stored Procedures, functions, cursors, triggers and UNIX shell scripts.
• Knowledge in Oracle Data warehouse DBA skills relating to administration and management of VLDB environments, Oracle OLTP.

Confidential, PA

Oracle Database Administrator-Consultant

Responsibilities:

• Successfully implemented Disaster Recovery solutions for different oracle database environment using RMAN, COMMVAULT, and User managed systems
• Efficiently performed installation, setup and creation of four node cluster RAC with Oracle 11.2.0.3 database using GRID infrastructure with ASM file systems on RHEL 5.5.
• Maintenance of Oracle 11gR2 Real Application Cluster (RAC) Database for High Availability, Scalability and Performance by determining the best Cluster architecture, choosing the best hardware configuration for Oracle RAC.
• Successful in installation/maintenance of Physical Standby database using Oracle Data Guard for Oracle 11.2.0.3 and Oracle 10.2.0.5 RAC databases.
• Implemented switchovers on primary and standby databases as a part of planned maintenance activities.
• Evaluated Oracle 11gR2 Golden Gate for future purposes that is for reducing the complexity involved in Oracle Streams.
• Configured Oracle Streams on Oracle 11g, 10g databases for data replication and monitored them using Grid Control.
• Used import/export utilities for cloning/migration of small sized databases and Datapump import/export to move data between 9i and 10g/11g environments.
• Automated the processes like moving files, managing alert log, efficient backup by developing UNIX scripts.
• Involved in the installation, configuration and extended support to Oracle 11g, 10g two Node RAC (Real Application Cluster) with ASM file system on AIX platform.
• Involved in converting Oracle 11g, 10g RAC to single instance databases to databases for disaster recovery solutions
• Installed ASM environment and migrated databases from NON-ASM to ASM and vice versa. Administer NOsql databases
• Used PUTTY for database management.
• 24 X 7 Production & Development database support and administration.

Environment: Oracle 11.1.0.7, 10.2.0.5, IBM AIX V6.1, RHEL 5.2, RAC, ASM, RMAN, AWR, COMMVAULT, SQL* Plus, PUTTY.

Confidential, MN

Oracle Production Support Database Administrator

Responsibilities:

• Installation and configuration of Oracle database 9i (9.2.0.4), 10g (10.2.0.1) on various OS platforms like HP-UX, Linux, and Windows NT, 2000
• Monitored Customer Databases, physically located in U.S and Remote administration of fifteen Production Databases in UNIX environment
• Performance tuning of application and database, identification and resolution of contention, defining and implementing Backup Recovery policy, and day-to-day monitoring of the Production database
• Worked on the physical and logical designing of the database, which includes the distribution of data- files on different disks
• Controlled and monitored user access to the database. Optimized the performance of the database. Tuned SGA data dictionary and set database parameters.
• Cooperated with PeopleSoft domain architect to ensure compliance of PeopleSoft HR solutions with established standards.
• Proposed solutions for process enhancements and provided feedback on PeopleSoft project migrations.
• Identified long-running database queries, refining queries for better performance, and working with end- users to implement changes
• Created primary database objects (tables, views, indexes) once application developers have designed an application
• Worked with Oracle Diagnostics tools such as Explain Plan, SQL Trace, TKPROF Used to analyze timing and execution plan for SQL query to tune the SQL statements
• Reorganized data files, identified and eliminated contention factors like I/O, buffers and locks
• Allocated the separate rollback segments for the Batch processing jobs in order to speed up processing
• Reorganized data files, identification and elimination of contention factors like I/O, buffers and locks

Environment: Oracle 10g/11g RAC/9i, VMS, Sun Solaris, Windows Server 2003, Red Hat Linux, TOAD, RMAN, SQL server, OEM.