SUMMARY:

• Installed oracle database server on SOLARIS, HP - UX, AIX, WINDOWS NT, LINUX and migration of oracle server from 9i to 10g and 10g to 11gR2, 12c applied oracle patches.
• Migrated single instance databases to multimode 10g, 11gR2 Real Application Cluster environments for high availability and load balancing.
• Installed, configured and maintained single node/multi nodes E-Business instances with RAC Clusters, ASM, Shared Application Top, Parallel Concurrent Processing.
• Have implemented ORACLE STREAMS, and two types of standby databases supported by DATAGUARD, logical standby and physical standby databases.
• Hands on experience in Data guard, Grid control, streams, replication.
• Expertise in Oracle Grid control installation OEM, monitoring and maintenance.
• Extensive knowledge on database backup/recovery strategy (RMAN), RMAN duplicate Import/Export & Data pump, Capacity Planning, Replication (Streams) standby databases, Oracle configuration management, Data guard, database cloning, refresh and patch management.
• Installed and administered Goldengate for data replication between 2 sites.
• Established Disaster Recovery for Oracle 11g R2RAC database.
• Delivering Oracle Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE, ORADEBUG, 10g OEM Grid monitoring custom scripts troubleshooting oracle databases using SQL trace utilities.
• Experience with SQL coding including DDL, DML and fine tuning those sql’s for better performance.
• Experience in using 10g features Flash-Back Recovery, Data Pump, AWR, ASM, ADDM, ASH, Recycle Bin, 10g Grid Monitoring.
• Experience in using Oracle development tools such as Tool for Oracle Application Development (TOAD), Oracle Reports builder, Forms 6i, SQL developer, SQL* Plus, Oracle Enterprise Manager (OEM), Crystal reports and PL/SQL Developer.
• Skilled in cross platform migrations from Windows to Linux, Solaris to Linux.
• Skilled in database upgrades 9i to 10g R2 and 10g to 11gR2 and to 12c
• Expertise in creating Oracle Tables, Table Partitions, Views, and Materialized Views.
• Experience with SQL, PL/SQL coding, stored procedures, triggers, cursors, functions, packages, UNIX Shell Scripting, Indexes, Logical and Physical database design Confidential o implement the business logic.
• Worked on cloud computing/Virtualized environment.
• Experience with Installation and Support of NoSQL Databases (MongoDB, Cassandra, HBase).
• Installed and Maintained Cassandra Cluster/ring in multiple virtual and physical data centers to ensure the system was highly redundant and scalable.
• Added Cassandra cluster nodes to ring as part of horizontal scaling.
• Implementation of MySQL High Availability using Master Slave Replication and MySQL proxy for Application level Load Balancer.
• Supported Veritas cluster environment in a passive-active setup.

TECHNICAL SKILLS:

Operating Systems: HP-UX 10.x, 11.x, Sun Solaris 2.5, 2.6, 8, 9, 10AIX 5.1, 5.2, 6.1, 6.3, IBM, Red Hat, Linux RHEL 2.1, 3.x, 4.x, 5.x And Windows 95/98/NT/2000/XP.

Databases: Oracle 12c,11g,10g/9i/8.x/7.x, Oracle 11g RACMS SQL Server 2000/2005/2008 , MYSQL 5.4, Percona MySQL cluster, Cassandra, MongoDB, Hadoop

Software Applications: Srvctl, Crsctl, Recovery Manager (RMAN), Real Applications Cluster (RAC), STATSPACK, ERWIN, IBM RSA, ClustersVeritas Backup, SQL Loader.

Tools: SSIS, SSRS, SSAS, Informatica, Sqoop.

Languages: SQL, PL/SQL, JSP, C#, C, C++, XML, UNIX Shell Scripting, Perl.

Web Tools: HTML, XML.

PROFESSIONAL EXPERIENCE:

Confidential, Tampa, FL

Oracle Database Administrator

Responsibilities:

• Oracle database administration of 8i, 9i, 10g, 11g & 12C.
• Install and support SQL Server 2008 & 2012.
• Oracle database servers design & capacity planning.
• Upgrading Oracle ASM, Non-ASM databases.
• Upgrading Oracle servers from older versions to 12C.
• Configure RMAN backups and enabling the on the RMAN catalog server.
• Design and deployment of monitoring tools.
• Configure RMAN backups on VERITAS NetBackup server.
• Oracle administration on Solaris 5.10, 5.11 and Windows 2008 and 2012 R2.
• Use Oracle utilities like Data Pump, SqlLoader and Upgrade tools for the transfer/migration of data between databases.
• Experience in creating design documents (HLD, DDD)
• Solaris knowledge, VERITAS cluster, Windows server 2008 & 2012.
• High level understanding of the Networking Concepts.
• Migrating databases in complex application architecture.
• Work with tier2 support scheduling tasks in controlled environment.
• Create/design documents for database upgrade and or Build projects.
• Participate in on-call for database support during weekends.
• Provide support in controlled environment during warranty period of the project.
• Work with application and production support in troubleshooting application connectivity with database.
• Perform database tuning and monitoring post upgrade.
• Provide recommendations to the production support on any issues and best practices.
• Provide knowledge transfer of the oracle database upgrade to production support after successful completion of the upgrade.
• Coordinate with offshore team for timely completion of tasks.

Environment: Oracle 12c, 11g, 10g, 9i, 8i, MS SQL 2008 & 2012, Solaris 10, 11, RHEL 5.x.6.x, Windows 2008 & 2012, Shell Scripting.

Confidential, Atlanta, GA

Oracle Database Administrator

Responsibilities:

• Installation and administration of 4 node RAC Clusters, configuring and monitoring daily backups, troubleshooting errors to improve performance.
• Installed 12c RAC on RHEL, scheduled housekeeping jobs and monitoring tools.
• Created RAC physical standby database using RMAN duplicate from active database
• Setting up and monitoring Cron jobs to schedule database backups with the help of RMAN scripts and daily night exports.
• Monitoring Growth of tables and undertaking necessary re-organization of tables and indexes as and when required.
• Applied monthly Linux OS patches to the database RAC clusters.
• Created and maintained oracle maintenance scripts for rotation and trimming of various logs.
• Regular RAC health check using RAC-check tool to look for any inconsistencies and best practices.
• Performing Database Administration activities like space management, user and roles administration, schema management, checking alert log of all the databases.
• Handling support tickets in timely manner based on the severity level and always be available for developers.
• Administered Oracle 11gR2 production environment on RHEL, IBM-AIX, and Sun Solaris.
• Installed OSWatcher black box on database servers for capturing server stats.
• Extensively used ADR tool for troubleshooting incidents and creating packages.
• Skilled with STATSPACK, AWR, ADDM, ASH to check health of database & hardware.
• Interpretation of AWR, ADDM reports.
• Worked on tools such as TKPROF, EXPLAIN PLAN, ORADEBUG and TRACE FILE to tune SQL Queries.
• Installed Golden gate on oracle database 11g.
• Performed database cloning to setup DR database.
• Conducted sizing & capacity planning for Oracle databases.
• Upgraded Databases from 11.2.01 to 11.2.0.3 and 11.2.0.3 to 11.2.0.4
• Experienced with CRSCTL, SRVCTL, OCR and Voting Disk of 11g RAC
• RAC Troubleshooting.
• Worked on maintaining schemas and partitioning tables.
• Implementation and release of database changes as submitted by the development team.
• Experienced with Data guard Implementation.
• Installed and administered Golden gate uni directional for data replication between 2 sites.
• Implemented custom replication using rsync between database servers.
• Expertise in Database Performance Tuning, Performance Monitoring
• Installed MYSQL 5.x database in RHEL 6 environment.
• Installed MySQL cluster and percona MySQL cluster.
• Performed Master-slave setup of MySQL Database.
• Implementation and support NoSQL databases (MongoDB, Cassandra, HBase).
• Installed and Maintained Cassandra Cluster/ring in multiple virtual and physical data centers to ensure the system was highly redundant and scalable.
• Added Cassandra cluster nodes to ring as part of horizontal scaling.
• Install HDFS (HDP 2.X) and components using Ambari.
• Check environment for production readiness and suggest required improvements.
• Performed Basic administration tasks on Linux/Unix Machines (RHEL, SOLARIS)).

Environment: Oracle 12c/11g RAC, Dataguard, Sun Solaris 10, RHEL 5.x.6.x, Cassandra, Shell Scripting.

Confidential, Columbus, OH

Oracle Database Administrator

Responsibilities:

• Involved in the installation of 11gR2 RAC on AIX 5.3/6.1 tl4,tl6 environment.
• Administered Oracle 11gR2/10gR2 production, test, development environment on RHEL, IBM-AIX.
• Skilled with STATSPACK, AWR, ADDM, SAR to check health of database & hardware.
• Interpretation of AWR, ADDM reports.
• Worked on tools such as TKPROF, EXPLAIN PLAN, ORADEBUG and TRACE FILE to tune SQL Queries.
• Performed database cloning to setup test and development database.
• Conducted sizing & capacity planning for Oracle databases.
• Involved in Migration of Database from 10g to 11g and applying patches whenever required.
• Upgraded Databases from 10g to 11g
• Experienced with CRSCTL, SRVCTL, OCR and Voting Disk of 11g RAC
• RAC Troubleshooting.
• Worked on maintaining schemas and partitioning tables.
• I mplemented the Security using ORACLE Database Vault.
• Implementation and release of database changes as submitted by the development team.
• Expertise in Database Performance Tuning, Performance Monitoring and Optimization using tools such as PL/SQL, Oracle Hints, SQL Trace, Explain plans.
• Experienced with all kinds (Status, Performance, and Trend Analysis,OEM) of DB Monitoring.
• Rebuilding of Indexes for better performance, maintenance of Oracle Database.
• Developed RMAN scripts for database backup and recovery including hot and cold backup options for both RAC and standalone instances.
• Installing ASM environment and migrating database from NON-ASM to ASM.
• Created tablespaces, tables, and users for custom applications.
• Developed views, materialized views, Partitioning, indexes, Global Temporary Tables, functions, procedures, triggers, packages using PL/SQL & SQL to transform data between source staging area to target staging area.
• Creating and dropping of users, granting and revoking permissions to users/roles as and when required.
• Experienced with working streams, leading tool for data replication.
• Experienced with precise (DB performance tuning tool)
• Generated ERD, OOM, PDM, CDM and Class Diagrams with Data modeling tools ERWIN.
• Experienced with Dataguard Implementation.
• Implemented oracle high availability solution using oracle 10g Physical Standby.
• Importing data from flat files into database using SQL loader and External Tables.
• Supported NoSQL databases running on virtual machines.

Environment: Oracle 11g, 10g RAC, GridControl 10gR5 &11g, ASM, AIX 5.3,6.1, Shell Scripting.

Confidential, NJ

Oracle DBA

Responsibilities:

• Administration of a 3 node RAC, configuring and monitoring daily backups, troubleshooting errors, to improve performance.
• Managing Security, User groups and Users by using roles, grants, privileges and Profiles.
• Creating new environments for data loading and manipulation for various states in the US, according to the specification provided by Century Link.
• Assisting the ETL team to improve performance by analyzing SQL statements, reorganizing database objects and design indexes to improve response of queries.
• Involved in the documentation of every task involved in the recovery issues or backups.
• Setting up and monitoring Cron jobs to schedule database backups with the help of RMAN scripts and daily night exports.
• Monitoring Growth of tables and undertaking necessary re-organization of tables and indexes as and when required.
• Delivering Oracle Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE, ORADEBUG, 10g OEM Grid monitoring custom scripts troubleshooting oracle databases using SQL trace utilities.
• Used Explain Plan to monitor the query execution and views to make sure the operations run without roadblocks.
• Troubleshooting Database performance issues using Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM).
• Creation of various database objects including materialized views.
• Troubleshooting errors and using the expdp/impdp utility on a very regular basis for copying data across schemas.
• Running scripts and monitoring the load process to avoid roadblocks in ETL jobs running for a long duration.
• Troubleshooting expdp/impdp errors in a RAC environment, configuring storage accordingly.
• Monitored Database growth and provide Database capacity planning for applications expansion.
• Upgraded from 9.2.0.x to 10.2.0.x.
• Performing Database Administration activities like space management, user and roles administration, schema management, checking alert log of all the databases.

Environment: Oracle 10g with RAC, 11g, Grid Control 10g, Oracle 9i, Oracle 8i, TOAD, Solaris8,9.

Confidential, TX

Oracle DBA

Responsibilities:

• Creation of Test and production databases of Oracle Enterprise Edition 8.1.7
• Monitored the growth of the database objects for capacity planning.
• Has primary responsibility for Oracle Data Base and Application performance tuning, physical/logical design and optimization and availability.
• Responsible for database backup strategies, database recovery and validation & reporting database statistics.
• Monitoring and management of various database components (logical & physical) like table spaces, segments (tables, index, rollback).
• User creation and enforcing security using privileges and roles.
• Export and import of database objects.
• Routine reorganization of databases, (disaster) hot backup recovery exercises.
• Validation of SQL and PL/SQL scripts before deploying into the production database.
• Conversion of database from file system to Oracle RDBMS using tools like SQL Loader and UNIX shell scripting to automate the process.
• Responsible to troubleshoot both Oracle applications and backend data base errors
• Built database links to connect users on different databases.
• Creation of cluster indexes, bit-map indexes and creation of index organized tables to enhance performance.
• Coordinated with other developers in tuning long running SQL queries to enhance system performance. Documentation of Data Base Setup.

Environment: RHEL, Sun Solaris, Oracle 10g, 9i, ASM, RMAN, SQL, PL/SQL, UNIX scripting.

Confidential, TX

Oracle Administrator

Responsibilities:

• Provided 24X7 supports for all the production and development databases.
• Installed and configured Oracle 10g.
• Other duties include applying oracle database patches, design and creation of databases as per user requirement, creation of database users, monitoring, tuning, troubleshooting, and backup and recoveries.
• Applied patches using OPATCH and Patch sets using OUI
• Cloned/Refreshed Oracle Databases.
• Implemented Disaster Recovery plans
• Responsible for optimizing the queries and application tuning.
• Perform SQL tuning and assist developers with coding PL/SQL.
• Provided support to Application Database Administrators in designing the database.
• Installed and Implemented Backup & Recovery procedures.
• Implement Hot, Cold and Logical backup plans.
• Worked on several shell scripts to maintain the database activities
• Mentoring the Database Performance using automated scripts.
• Answerable for setting and managing User Accounts, Granting required privileges to users.
• Experienced in Security Administration and Space Management
• Perform other regular DBA activities including space management and performance monitoring.
• Optimization and tuning SQL queries using TRACE FILE, TKPROF, EXPLAIN PLAN.
• Continuous monitoring of database performance during peak and non-peak loads using STATSPACK.
• Involved in process improvement, Oracle Server Installations/Upgrades/Patches, Space Management, Capacity Planning, Backup & Recovery, Disaster Recovery, Database Performance Tuning, Memory Tuning, Application Tuning, Security Administration, Data Warehousing, Dataguard, Oracle Advanced Replication, Real Application Clusters, Oracle standby services.
• Implement “Stored Procedures and Triggers” based on business plans using PL/SQL.
• Automation of data load using Korn shell scripting and SQL*Loader.

Environment: Oracle 10g/9i/8i, RHEL 3, 4.

Confidential

Oracle DBA Developer

Responsibilities:

• Database Installations, Creations and Upgrades of 8i/9i on Windows 2000/NT
• Analyzed the structures using Analyze command.
• Involvement in all phases of the project life cycle
• Written, tested and implemented various UNIX Shell, PL/SQL and SQL scripts to monitor the pulse of the database and system
• Assuring appropriate backup and recovery procedures to be in place to meet the Company’s requirements.
• Worked closely with developers in Designing Schema / tuning PL*SQL/ SQL code
• Performed Database Tuning for Oracle 8i & 9i servers including reorganization, SGA, kernel, redo log tuning, Rollback tuning.
• Implemented automated backup strategy using the UNIX shell script CRON UTILITY

Environment: Windows 98/NT / 2000, HP-UX, Oracle 9i/8i/7, TOAD, Database Tools/Utilities

Confidential

Oracle PL/SQL developer

Responsibilities:

• Involved in the analysis, design, build, and testing phase of the life cycle for the project.
• Developed PL/SQL packages to capture end of day transactions.
• Implemented UTL HTTP oracle built in package to acquire data from external websites.
• Involved in designing the database, identification of the objects and creating tables.
• Latest features of Merge/Multiple Table Insert/Loading and logging error in a single statement/Grouping sets, Cube, Rollup have been used to improve the performance and reduce IO.
• Created various Database triggers using PL/SQL.
• Extensively used Explicit Cursors in stored procedures.
• Developed several intricate procedures and functions to accommodate data manipulation.
• Created Tables, Views, Synonyms, Sequences and Indexes.
• Developed PL/SQL scripts for exception handling.

Environment: RHEL, Windows, Oracle 8i, SQL, PL/SQL, UNIX Shell scripting.