SUMMARY:

• 9+ years of experience as Oracle Database administrator, having hands on experience in database administration, production support, installation, configuration, upgrades, performance tuning, backup and recovery, cloning, space management, and database security with Oracle (9i, 10g, 11g, 12c ) on Sun Solaris, Red Hat Linux, HP - UX, AIX, and Windows 2000/2003/2008 Platform.
• Over 5 + years of IT experience in SQL Database Administration, System Analysis, Design, Development & Support of MS SQL Servers 2005, 2000 and 7.0 in Production, QA, Reporting Services, Development environments & Replication and Cluster Server Environments.
• Experience On-Call 24x7 production support DBA .
• Worked as L3/Sr. Oracle DBA for 6 years.
• Experience in Configuring Single instance to multimode, Oracle Real Application Clusters (RAC), Automatic Storage Management (ASM), Data guard.
• Experience with very large scale database environment and mission critical OLTP and OLAP systems.
• Good exposure of Oracle DBA tasks Installation, Patching, Cloning, and Upgrade of Oracle Databases.
• Experience in Backup & Recovery, Disaster Recovery options, Oracle Recovery Manager (RMAN).
• Experience in Managing Security, User groups and Users by using roles, grants, privileges and Profiles.
• Installed Oracle Golden Gate
• Experience in implementing the Golden Gate.
• Experience in working with Grid Control and Oracle Enterprise Manager (OEM).
• Experience in Automatic Storage Management (ASM) .
• Developing and implementing EBS concepts.
• Solid understanding of the Hadoop file distributing system.
• Expertise in Hadoop Security and Hive Security.
• Good knowledge of CPAN and mod perl.
• Excellent in object oriented programming using perl.
• Could work with packages and modules of perl.
• Expertise in Installing and configuring ASM and RAC for high availability databases.
• Performed Strategic Planning, Logical and Physical Data Modeling & Application Tuning.
• Experience in Performance Tuning (I/O, Memory & SQL Tuning etc) by using tools/utilities like tkprof, sql profile Automated Workload Repository (AWR), Automatic Database Diagnostics Monitor (ADDM).
• Strong MySql and SQL Server skills but also significant general system administration skills on UNIX/HP Open VMS, Linux and Windows environment. Proficient writing shell scripts as well as knowledge in general systems administration tasks..
• Experience in installation, configuration, Maintenance and Administration of SQL Server 2012,1008/2005.
• Experienced in Database optimization and developing stored procedures, Triggers, Cursors, Joins, Views, Cursors and SQL on databases: MySQL, Oracle10g, OMWB tool.
• Experience as Oracle PL/SQL developer in systems Analysis, design and development of complex software systems in both OLTP and OLAP.
• Expertise in replicat ion via Golden Gate to WebLogic JMS .
• Thorough knowledge and experience in Administrating PeopleSoft Server components like PeopleSoft Application Servers, Process Scheduler Servers, Tuxedo, Web logic Servers, PIA (PeopleSoft Internet Architecture), Application Messaging, Integration Broker, Sql server, Application Issues and technical issues, etc.
• Experience in performance tuning, installing servers, and migrating to new servers. Installing and Administering PeopleSoft software configuring Workstations, Application Server, Process Scheduler, Tuxedo, Web Servers, PIA, Report Repository, Report Nodes for PeopleSoft applications. Applying Application Updates and Fixes and Tools Patches. Upgrading Tools to higher level s.
• Proficiency in migration activities in PeopleSoft, Tax updates, Patches, Maintenance packs, Service packs, tools upgrade for different applications versions of PeopleSoft.
• Expertise working with various versions of Oracle Database including 11g, 10g, 9i, and 8i, with proficient SQL and PL/SQL Development abilities.
• Expertise in using PL/SQL wrappers to protect the PL/SQL procedures or packages.
• Experience with SQL, PL/SQL coding, stored procedures, triggers, cursors, packages,performance Tuning, UNIX Shell Scripting, Indexes, Logical and Physical database design to implement the business logic.
• Management in Share Point Databases.
• Experience in Hot/Cold Backup and Recovery and Cloning of databases using RMAN.
• Expertise Oracle Enterprise Manager (OEM), Grid Control, TOAD, RMAN.
• Experience in EXADATA.
• Ability to support Sybase ASE, TimesTen & Sybase IQ as needed.
• Expertise knowledge of Oracle Architecture, SGA, PGA, LISTENER, TNSNAMES, V$ and DBA Views.
• Cloned Database from Production to Test and Development.
• Expertise Oracle Identity Management
• D eveloping BI applications using Cognos, OBIEE, etc.
• Exporting and Importing of dumps using expdp and impdp.
• Experience on handling VERY LARGE DATABASES(VLDB).
• Experience in Delivering Oracle Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE, ORADEBUG, AWR report, 10gOEM Grid Monitoring custom scripts troubleshooting oracle databases using sql trace utilities.

TECHNICAL SKILLS:

Databases: Oracle 7i, 8i, 9i, 10g, 11g, 12c, SQL Server 2005, 2008, 2016, Teradata, Informix, DB2, Mainframe, Sybase, Mongo DB

Red Hat Linux, HP: UX, AIX, Sun Solaris and Windows

Languages: SQL, PL/SQL developer, C, Shell Scripting,Python

Utilities: RMAN, Oracle 10g Grid Control, Data Guard, SQL*Loader, EXP, IMP, Datapump, SQL developer, VERITAS NetBackup, APEX, Shareplex

Tools: TKPROF, TOAD, EXPLAIN PLAN, AWR, STATSPACK, ASH, AUTO Trace, Toad, Pl/Sql, OEM 12c, Developer, ERWIN, appworx, putty.Midd

PROFESSIONAL EXPERIENCE:

Confidential, Roseland, OR

Sr.Oracle Database Administrator

Responsibilities:

• Experience in Working with RAC Databases.
• 24/7 on call production database support.
• Tuning the databases for optimal performance.
• Building new physical standby databases from scratch.
• Created PL/SQL packages, procedures, cursors & exception handling.
• Worked with Partition tables and indexes to improve the performance of data loading and query processing.
• Created Oracle RAC 4 node cluster databases.
• Generated DDL Queries for creation of new database objects like tables, views, sequences, functions, synonyms, indexes, triggers, packages and stored procedures.
• Performing all the Database Administration activity like space management in database, user and roles administration, schema management, checking alert log of all the databases.
• Used shadow Image replication and mirroring tool to backup the data in the disk level.
• Determined a good understanding of shell scripting language including sed and awk.
• Experience working with pairsplit and pairresync operations in Shadow image tool.
• Segregated root level tasks and dba level tasks in such a way that junior DBA's can perform the tasks by themselves.
• Converted single instance to RAC instance.
• Enhance logging of rman backups in such a way that the archive logs are retained for some period of time and then get deleted.
• Enhance rman performance by using rman control file backup instead of using catalog.
• Modify the shell script in order to migrate to a new rman catalog.
• Supported technical team members for creation and implementation of configuration management tools.
• Worked as PeopleSoft Production Support Admin and took care of day-to-day activities like migrations and support to the DEV, TEST and PROD environments.
• Perform tools upgrade for different PeopleSoft application, and work on patches and update for different technologies.
• Created integration broker message nodes for the Source and Target PeopleSoft Applications, configured report nodes.
• Developed complex PL/SQL programs and modified the existing PL/SQL units.
• Development of PL/SQL and Web PL/SQL stored procedures.
• Involved in SQL tuning, PL/SQL tuning and Application tuning using various tools/utilities like Explain plan, DBMS Profiler, Auto*Trace, SQL Trace, TKPROF etc.
• Use Synchronous Change Data Capture (CDC) to Track and Consume Incremental Data Changes in ETL.
• 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 both Linux (5.0, 5.1) and Mac OS X.
• Increased database performance by utilizing MySQL config changes, multiple instances and by upgrading hardware.
• Effectively configured MySQL Replication as part of HA solution.
• Maintaining Complex database environments(50+ databases) with Golden gate replications.
• Applying upgrade patches, maintenance and interim patches on all the databases.
• Ability to support Sybase ASE, TimesTen & Sybase IQ as needed
• Worked on Automatic storage management (ASM) with EMC storage for managing data in SAN.
• Successfully implemented 10g RAC on nodes for high availability.
• Developing Oracle Streams.
• Experience in Working with RAC Databases.
• Managing in Share Point Databases.
• Developing and Managing Clusters.
• Hands on experience in troubleshooting RAC environment, using srvctl, crs stat and crs profile.
• Performance tuning for optimized results using tools like EXPLAIN PLAN, SQL*Trace and TKPROF, STATSPACK.
• Continuous Performance monitoring and tuning of the databases and application using OEM Tuning Pack, Diagnostics Pack, and STATSPACK.
• Worked with T-SQL statements like DELETE and UPDATE statements and also like BULK insert of data into the datable.
• Other activities like applying RDBMS patches, security patches, sox reporting proactive monitoring of databases and applications.
• Implementing Oracle Identity Management applications.
• Experience in maintaining with high available databases.
• Loads databases, reorganizes as necessary, and assists in monitoring database performance
• Developing and Implementing Disaster Recovery (DR) Plan using Datagaurd.
• I along with team implemented physical standy database using Datagaurd.
• Daily Health Check Up of the Database using staspack, AWR, ADDM & ASH.
• Rebuilding of Indexes for better performance, maintenance of Oracle Database.
• Maintaining security of databases and users.
• Reading Alert Log and User trace Files and Diagnosing the Problem.
• Automation of Startup Shutdown on all Production and Development Database.
• Installation and configuration of Oracle Client software and Tools.
• Written SQL scripts to monitor tablespace and extent growth.
• Developing web applications.
• Performance tuning which includes creating indexes, analyze, explain plan, optimizer hints

Environment: Red Hat Linux, HP -UX 11.31, Solaris, MYSQL, Windows XP, Oracle 10g/12c, RAC, OEM, Grid ControlRMAN, DBCA, Data Guard, Putty, TOAD 8.1, UNIX, Linux 4.0, SQL Developer

Confidential, Parsippany, NJ

Oracle DBA

Responsibilities:

• Setup standby database using dataguard for 11g databases
• Primary support for 2 new applications and worked on all 3 phases of project dev, qa and prod.

  with organizational impacts

• Install, configure and support Oracle databases for Business Systems environments
• Monitor database space and capacity, estimate sizing and growth requirements
• Plans, implements and maintain Oracle database backups via RMAN and maintains Backup and Recovery procedures
• Database refreshes, archiving and partitioning
• Migration of sql 2008 to Oracle 11g database.
• Work with vendors and application support teams to gather information, determine and implement resolutions

Confidential, Sacramento, CA

Oracle Database Administrator

Responsibilities:

• Supported 50+ databases including RAC Production database, a Data warehouse database and lot of Development and Test databases.
• Primary DBA for 1GB - 2.5TB database for 24/7 support.
• Configuration, Installation and maintenance of Oracle 11gR2 RAC databases including Grid Infrastructure.
• Maintaining and Implementing ETL in Dataware housing.
• Using the different transformation operators to design an ETL task.
• Implementing cluster databases.
• Performed upgrades from Oracle 10g to 11g and applied patches.
• Involved in creating procedures for Raw Data Reports using PL/SQL.
• Involved in setting up of data guard for 2-node standby.
• Installed and configured Golden Gate in a prod and non-prod environments.
• Worked on Features: Data Pump, ASM and RMAN. Data Base Recovery (complete & Incomplete).
• Proficient in managing Oracle Instance, database storage structure, schema objects.
• Experienced with SRVCTL, OCR and Voting Disk of 10g, 11g RAC.
• Developing BI applications using Cognos, OBIEE, etc.
• Developing and Implementing EXADATA database.
• Providing workflows and other information required in the development of code of the perl scripts.
• Working with XML and HTML technologies.
• Programming in Python as well as Perl.
• Develop the post-processor script in PERL for American Funds ingestion process to move the pdf files to the NAS mounted directory structure based on the config file format.
• Develop the pre-processor and post-processor scripts in PERL for the Mercer Funds files to create the index files for the incoming zip files and to update corresponding DB2 tables during the post ingestion process.
• Administration of all database objects, including tables, Indexes, views, sequences, packages and procedures.
• Installing ASM environment and migrating database from NON-ASM to ASM.
• Experience in Planning Database, Sizing table space, Create database, scripts, Monitor databases, Interact with developers, Oracle Install, Upgrade.
• Performance Tuning on a daily basis for preventing issues and providing capacity planning using MySQL Enterprise Monitor.
• Developed stored procedures, triggers in MySQL for lowering traffic between servers & clients.
• Skilled with AWR, ADDM, SAR to check health of database & hardware.
• Installation of Oracle database 10g software with RAC using Oracle Clusterware. Oracle Data Guard setup done for RAC. Installation of Oracle 10g management agent and grid control.
• Identity and Access Management Security using the Oracle Identity Management
• Experience in Performance and Tuning databases using various techniques. Collected performance statistics memory usage, data storage.
• Generating Statspack reports and AWR and ADDM reports for Database for Application tuning and also database Partitioning.
• Extensively used PL/SQL for designing packages, stored procedures, functions and database triggers.
• Using TSQL for the Data Management and Retrievement.
• Created Cluster database, Cloning of Cluster database on Linux, start and stop Cluster database services.

Environment: IBM-AIX, SunSparcSolaris64bit, and Redhat Linux, Oracle Database Server 10g/11g, Golden Gate 11.1, TOAD, PL/SQL,TSQL

Confidential, Boston, MA

Oracle Database Administrator

Responsibilities:

• Responsible for installing, supporting the oracle stand alone, RAC(2node) and RAC(2node) with dataguard databases of the version 11g, 10g and 9i on Sun Solaris 10, RHEL 5.5, AIX 5.3 and Windows 2008.
• Used Vertias Cluster File System (VCFS), ASM file system and SCAN LISTENER in installing Oracle 11g RAC and also installed oracle grid agents on standalone and RAC databases.
• Maintaining and developing the EBS concepts.
• Worked with maintaining the OCR and VOTING DISK in normal and external redundancies and also worked with cluster ready services (CRS) and used CRSCTL for maintaining CRS.
• Maintaining Identity and Access Management using Oracle Identity Management
• Worked on resolving the gap between primary and standby databases in dataguard by registering the missing archive logs in the standby database.
• Worked on installing CPU patches manually and also using enterprise manager grid control. Worked on installing the Rollover patches for RAC databases.
• Worked on refreshing the objects using exp & imp and also using expdp & impdp. Refreshed the databases from PROD to UAT, QA, and DEV using RMAN.
• Worked on DR tests using dataguard and VVR, resolved the issues during switch over and switch back.
• Migrated the databases from 9i and 10g to 11gr2 from Solaris 1o to RHEL 5.5. Supported PeopleSoft applications as backup dba.
• Upgraded the databases from 9i and 10g to 11gr2 and resolving the issues during upgrade.
• Worked on RMAN backup and recovery. Recovered the databases (full recovery) during database upgrade and point in time recovery as per the user request using RMAN.
• Created the dblinks (private and public), synonyms (private and public) and views. Validated the views and compiled the views which are invalid.
• Have used different tools like TOAD (10.6), DBArtisan (8.7.2), EXPLAIN PLAN, AWR, ADDM, Tkprof, STATSPACK, Oracle enterprise manager (GRID CONTROL) 11g to solve the performance issues.
• Helped developer in installing Oracle Client, troubleshoot and establish the connection to Oracle database through JDBC.
• Responsible for monitoring RMAN backup jobs and analyze tables and indexes of Oracle database periodically for better performance.
• Responsible for monitoring the daily jobs and resolving and finding reasons for failed jobs.
• Perform production system problem analysis and recommend corrective measures in a timely manner.

Environment: Oracle 11g/10g/9i, TOAD, DBARTISAN(8.7.2), DBCONTROL, GRID CONTROL(11g), STATSPACK, DATAGUARD, AWR, SUN SOLARIS(10), RHEL(5.5), WINDOWS(2008), AIX(5.3), PeopleSoft, E-business, Trading, Websphere, Java, EXADATA.

Confidential, Seattle, WA

Oracle DBA

• Responsibilities:
• Installation and Maintenance of Oracle Databases.
• Loaded bulk data with SQL*Loader.
• Created table spaces and managed tablespaces adding/deleting/ resizing data files.
• Most of the operations are done with Oracle Package and shell scripts at the backend.
• Created clearance break report, Delivery Advice Break report and customer exercise/assignment report in PL/SQL.
• Created backend objects like views, synonyms, sequences, procedures and packages.
• Maintenance and troubleshooting of oracle network files like listener, tnsnames.ora.
• Performed logical backup & recovery using export/import utilities. Involved in Configuration.
• Actively involved with application team in coding SQL statements in PL/SQL.
• Developing complex shell scripts (korn mainly) for backup, rotating logs/files, etc.
• Design and implement database backup and recovery procedures (RMAN).
• Monitor and tune database performance including SQL tuning.
• Implement effective database security practices and procedures.
• Maintain and improve high availability and disaster recovery.
• Migrate data to other databases.
• Monitor usage of the databases and perform database tuning.
• Extensive use of Crontab in UNIX environment for scheduling routine tasks.
• Involved in Performance tuning, database monitoring activities using STATSPACK
• Responsible for creating and maintain development and QA databases.
• Data loading using oracle SQL Loader, developed SQL*Loader scripts to load Global data.
• Drastically reduced unscheduled downtime and improved performance.
• Automated backups, software release installs, performance tuning and database metrics gathering.
• Rebuilt, reorganized and simplified databases, enhancing development, maintenance and performance.
• Requirement analysis and database design.
• Implemented and managed the basic data replication.
• Trouble shooting performance issues using Explain Plan and TKprof.
• Maintenance & modification of Shell Scripts.
• Active Participation in the System Study Created tables, indexes and views.

Environment:: Oracle 10g/11g, Sun Solaris, Linux, HP-UX, Putty, OEM, TKPROF, Data Guard, Shell Scripts, RMAN, Golden Gate, Oracle RAC.

Confidential

Oracle Database Administrator

Responsibilities:

• Installing Oracle 9i and upgraded it to latest 9i patch set on HP-UX 11.23.
• Migrating applications from non-clustered oracle 8i/9i databases to new 10g RAC Database environments.
• Monitoring and supporting Applications using OEM 9i Grid Control.
• Configured two node Oracle 9i RAC cluster.
• Created PARTIONING of its types like Range, List & Hash by the specific use.
• Implemented Oracle Streams for Replication.
• Implemented schema level, table level and bidirectional oracle streams.
• Registering Databases to RMAN Catalog.
• Planning and scheduling Backups, RMAN, taking Logical Backups.
• Experience in Export/Import and Datapump.

Environment: Oracle Grid Control, Oracle 9i, HP-UX 11.23

Confidential

Jr. Oracle DBA

Responsibilities:

• Providing Production support and troubleshooting user issues.
• Performing daily database operations, maintenance and support.
• Administration of databases- Physical and logical structures.
• Export/Import data to/from PROD and Non Production systems as required.
• Expertise in database backup and recovery management (Hot/Cold, Exp/Imp).
• Identifying and resolving resource contention issues and monitoring database performance.
• Troubleshooting based on Alert logs.
• Maintaining of Space requirements on the Tablespaces by adding/re-sizing data files based upon the space available on the file systems and existing volumes.
• Creating and Managing Users, Granting, Revoking privileges for the users in order to ensure the Database security.
• Responsible for refreshing/cloning test instances with Production Instance periodically.
• Creation of Database Links and Materialized Views between different databases.
• Coordinate with Oracle Support to resolve database performance issues.

Environment:: Oracle 9i/10g, Solaris, Linux.