SUMMARY:

• Over Eight years of IT experience, where 7 plus years working as Oracle Database Administrator on different UNIX flavor ( Solaris, HP - UX, Red-Hat LINUX ) with Oracle (9i, 10g, 11g, 12c).
• Expertise in Performance Tuning, managing large databases, Streams, Data management, Backup & Recovery, Oracle CDC ( Change Data Capture ).
• Expertise in database administration, installation, configuration, upgrades, migration, performance tuning, backup & recovery, cloning, space management, patching, security, Fine grained auditing, capacity planning and designing databases.
• Excellent hands on installations, Upgrades and configuration of Oracle 9i to 10g, 10g to 11g R2 and 11g to 12c on *NIX and Windows environment.
• Expertise in Oracle database management including creation and maintenance of Database (Backup & Recovery, Tuning, Security, Capacity Planning & Migrations) System Analysis, design, develop-ment and implementation of backup strategies, Oracle Data Pump (export/import) utility using UNIX shell scripting.
• Expertise in installing Oracle 10/11g RAC software with ASM File system, maintenance and tuning of RAC application.
• Implementing RMAN backup (Full, incremental and cumulative) and recovery, Incomplete recovery and disaster recovery using standby database Data Guard.
• Hands on SQL, PL/SQL SQL+ and UNIX Scripting.
• Performance Tuning of databases, SQL tuning, Used Tuning utilities like STATPACK, TKPROF, EXPLAIN PLAN, AWR, ADDM, Tuning of SGA, distribution of disk I/O, sizing of Tables and Indexes.
• Hands on experience in 11g and 12c Golden Gate.
• Proactive monitoring, identifying areas that need to be improved in application and database using STATPACK, AWR, ADDM and Oracle 12c OEM grid monitoring.
• Expertise in basic and advanced replication using Oracle streams and experience using OEM, TOAD, Data migration using TTS, export/import, benchmarking using load testing tools, Oracle CDC (Change Data Capture).
• Installation and configuration of Oracle 12c Real Application Cluster (RAC).
• Very strong understanding of container and pluggable databases.
• Administration of SQL server 2008/2010/2012 databases.
• Working knowledge of Microsoft SQL Clustering.
• Comfortable working on Cassandra and Mongo database.
• Comfortable working on PostgreSQL, MySQL (5.5) and MariaDB database.
• Experience with VLDB (Very Large Databases) with understanding in large table partitioning which include secured Databases.
• Expertise with TTS (Transportable Tablespace).
• Comfortable with both command line and GUI interface.
• Possess strong UNIX skills; intermediate administration skills.
• Possess excellent oral and written communication skills.
• Strong Data Guard skills. Configured and Implemented Physical Standby on both 11g and 12c dbs.

TECHNICAL SKILLS:

Languages: SQL, PL/SQL, C, C++, OOPS, JAVA, Visual Basics, People Tools, C#, .NET, PHP.

Scripts and Markup Languages: Unix bash shell programming, HTML, Windows Batch files, Korn shell.

Web Servers: Apache, Java Web Server (1.1.3,2.0)

Oracle Web/ Application Server (3.0, 4.0, 9iAS): Familiar with Web logic and WebSphere

OS & Administration: Sun Solaris, HPUX, Linux, NT/2000/2003, Novell Netware, Windows Server 2012, AIX.

Database: Oracle 9i,10g, 11g, 12c MYSQL, MSSQL, PostgreSQL, Cassandra, Mongo

PROFESSIONAL EXPERIENCE:

Confidential, Phoenix, AZ

Senior Oracle DBA Consultant

Responsibilities:

• Participates in code and design reviews to ensure quality and conformance to product standards.
• Assumed ownership of the operation responsibilities for more than 60 complex database servers that need to be monitored whether production, UAT, QA or development environments.
• Proactive measured space capacity requirements based on the historical data growth pattern, consult with Data owner on data purges, and work closely with the Storage team when more space is needed for future growth, mass load or temporary assignments.
• Install 11g, 12c databases and clients on RHEL and other win/*nix platforms.
• Set up Bi-directional streams replication (schema level & table level).
• Performed data refresh in lower environment from production in a streams environment.
• Manage 5 node RAC cluster.
• Add and delete node in RAC environment.
• Stop and start nodes via srvctl and manually.
• Reconfiguring Services via srvctl utility.
• Working with Oracle to solve multiple RAC issues.
• Troubleshoot connectivity issues and solved listener configuration.
• Worked with Unix Administrators to create new 4 node RAC cluster.
• Configure and install database control.
• Managed agents for Database Control monitoring tool.
• Troubleshoot OEM repository.
• Update sysman passwords to troubleshoot OEM connection issues.
• Manage security and grants for database users.
• Created Materialize Views on remote host to refresh multiple times in a day.
• Responsible for writing shell scripts to automate tasks.
• Responsible for managing daily full backups.
• Recovered corrupted datafiles from backups.
• Created scripts to transfer archivelogs to remote server for manual dataguard purpose for standard Edition purpose.
• Use of Opatch for quarterly security patches and other patches for database.
• User creation and giving proper grants and privileges.
• Managed incremental and cumulative backups both from database control and shell scripts.
• Export/ Import using DataPump.
• Refreshing tables/ schemas on regular basis.
• Refreshed database from production to non-production.
• Create yearly table partitions for range partitions.
• Upgraded 9i to 10g, 10g to 11g, 11g to 12c.
• Use AWR and ASH reports to pinpoint the wait events.
• Used explain plan to view the cost of each parsing step to determine the best execution plan.
• Migrated Single standalone database to two node RAC cluster.
• Applied CPU every quarter.
• Written scripts to transfer daily backups to offsite backup server.
• Restored and recovered database to earlier point after accidental drop to tables.
• Used Toad for database administration activities.
• Configured dbconsole for both standalone and RAC environment.
• Use SQL Advisor in dbconsole for both standalone and RAC environment.
• Monitor performance with and without dbconsole, Grid control.
• Managed and troubleshoot log shipping job failures.
• Created and managed SQL server 2012 databases.
• Worked with service broker to manage server efficiently.
• Created roles, databases users and managed security.

Environment: Oracle 12c 11gR2, 10g, Cassandra, PostgreSQL, Streams, AIX6L, Solaris 10/9, LINUX (RED HAT), SUN Sparc E 4500/5000/450, RMAN, TOAD, SQL LOADER, DATA PUMP.OEM/Grid Control

Confidential, Phoenix, AZ

Oracle DBA

Responsibilities:

• Experience in Installation and configuration of Oracle 9i, 10g, 11g, 12c on RHEL, Solaris and Windows environment.
• Experience in Installation of Oracle 11g Real Application Clusters (RAC) databases on Linux and Sun Solaris operating system.
• Experience in migrating Standalone Database to High Availability RAC environment with ASM
• Hands on experience in configuration, administration, maintenance & recovery of single-instance & Real Application Clusters (RAC) Databases.
• Configured Data guard environments for disaster recovery and high availability, experience setting up physical & logical standby, active dataguard.
• Hands on Experience using Oracle utilities Datapump, SQL Loader, RMAN, Original export/import.
• 24*7 production database support and on call for Production database supporting developers & end-users.
• Extensive experience in planning and execution of Database Backup and Recovery using RMAN.
• Implemented automated backup strategy using the UNIX shell script CRON UTILITY
• Expertise in SQL and UNIX Scripting (Used to write UNIX Scripts & implemented by Using CRONJOB for Day - to - Day activities.)
• Proactive monitoring, identifying areas that need to be improved in the database using Statspack, AWR, ADDM and 11g OEM Grid Monitoring.
• Performance tuning of the database - SQL Statement Tuning. Used Tuning utilities like STATSPACK, TKPROF, EXPLAIN PLAN, AWR, ADDM and Tuning of SGA, Distribution of disk I/O, Sizing of tables and indexes.
• Extensive experience of Performance tuning of various aspects of the database using utilities like TKPROF, Explain Plan, Stats pack.
• Experienced user of Oracle PL/SQL in stored procedures, functions, and triggers
• Extensive knowledge in creating and tuning SQL queries and PL/SQL procedures and functions for optimum performance.
• Install SQL Server 2008 on Server 2012.
• Administration of SQL server 2008/2010/2012 databases.
• Working knowledge of Microsoft SQL Clustering.

Operating System: Windows, UNIX, Linux.

Language: C, C++, Java, Oracle, DBMS, HTML, CSS, Perl.

Hardware: TCP/IP hardware, Cisco routers and switches, modem.

Database: Oracle 9i/10g/11g, Mongo, MySQL, MSSQL.

Confidential, Torrance, CA

Oracle DBA

Responsibilities:

• Installation of 11gR2 Grid infrastructure, 10gR2 & oracle clusterware on AIX 6L, Solaris 5.x.
• Creation of Database using DBCA, configuring ASM storage.
• Administrating Oracle 11gR2/10gR2 Production/staging/ Development databases.
• Administration of RAC databases involving starting/stopping RAC databases, instances, asm instances, clusterware using srvctl/crsctl utilities.
• Collecting and analyzing data for capacity planning for three-years of PRODUCTION growth.
• Administering large sized tables involving partitions, experience with parallel dml.
• Performance tuning with in-depth analysis of ADDM, AWR reports, utilizing OS utilities (vmstat, sar, netstat) to analyze & identify performance bottle necks.
• Resolved replication issues in Goldengate.
• Utilizing DBMS SQL Tune to analyze & improve performance of application queries.
• Configured RMAN backup and tested restore and recovering the db along with setting up database monitoring scripts.
• Involved in creating shell scripts to assist application teams execute daily maintenance/purge tasks, to automate & schedule backups with RMAN.
• Implemented Dataguard, physical standby database in maximum protection mode, ensure logs are shipped & applied on standby database.
• Strong PL/SQL and stored procedure coding abilities with Oracle 10g new features and utilizing tools like TOAD, SQL Developer, SQL*Plus, SQL* Loader.
• Participation in 24x7 database support for project releases.
• Applying CPU & one-off patches to standalone & RAC databases, patching of grid infrastructure software.
• Manually gather table stats to enhance the query performance.
• Experience using change management process, working with global workforce, co- ordination with off shore teams for problem resolutions.
• Multi-tasking with involvement in different projects, experience with on-call rotation for 24x7 supports.

Environment: Oracle 11gR2, 10g, AIX6L, Solaris 5.x, OEM/Grid Control, SQL*Loader, FTP, SFTP, Winscp, Unix Shell scripting, AWR reports, ADDM analysis, Partitioning, SQL Tuning pack, SQL, Pl/SQL, TOAD, SQL developer, RMAN, Peregrine service center.

Confidential, Columbus, OH

Oracle DBA

Responsibilities:

• Installation and configuration of Oracle 9i/10g/11g with ASM.
• Installation & configuration of RAC database using Oracle clusterware on RHEL 5.x to provide a high availability solution.
• Configured ASM for shared storage, installed ASM libraries.
• Migrating single instance databases to RAC database using RMAN
• Work closely with developers to tune SQL queries.
• Performing logical backups using Datapump utility
• Developed SQL and shell scripts for database monitoring.
• Schema management, space management as per the requirements of team.
• Assigning appropriate privileges through the use of roles.
• Monitoring object usage & allocating space as per requirement.
• Creating tables and views and supporting developers.
• Implementing a backup policy with incremental backups.
• Sizing database objects for effective space management and optimal performance.
• SGA tuning including tuning the shared pool, database buffers and redo buffers.
• Using shell scripts and SQL scripts to schedule backups.
• Utilizing Enterprise manager to monitor alerts, schedule jobs, monitor SQL loads, generate AWR reports
• Cloning production databases for development, test environment with RMAN Duplicate feature.

Environment: Oracle 9i, 10g, 11g, ASM, RAC, RHEL 5.x, Solaris 5.x, Windows 2003, SQL developer, Datapump, Remedy.