SUMMARY:

• Over 7 years of experience in IT industry as an Oracle DBA working for various organizations.
• Experience on Oracle 10g/11g/12c database planning, installation, upgrade and migrations, performance tuning, backup, recovery, security provisioning, data guard, golden gate etc. on production, staging, development environments, understanding ITIL guidelines.
• Hands on experience with backup and recovery using RMAN, applying patches, cold and hot backup, full and incremental backups, oracle streams etc.
• Proficient in SQL, PLSQL, Stored procedures, Functions and Database triggers.
• Experience on working with Amazon Web services (AWS).
• Strengths include skills in Shell Programming, SQL and PL/SQL.
• Proficiency in standby database (Data guard) installation, configuration, maintenance, and administration for disaster recovery.
• Worked on SQL server 2008/2012 in Database design, development and support.
• Experience with tools like SQL server management studio and SQL server 2005/2008 integration SSIS and reporting services(SSRS)
• Usage of HP Database middleware automation (DMA) for creating runbooks.
• Experienced in writing UNIX shell scripts, Perl and setting up cron jobs for database needs.
• Monitor system performance, identify bottlenecks and ensure problem resolution.
• Implemented 10g/12c Grid Control and applied Applications Management Pack for monitoring Applications.
• Instance Cloning and Code migration processes.
• Availability for 24/7 support, timely resolution of tickets and on call rotation.

TECHNICAL SKILLS:

Operating Systems: Solaris, IBM AIX 5,6, HP - Unix 10.x, 11.x, Sun Solaris 5.8, 8, 9, 10, Linux RHEL 5,6,7, Windows 2003/2008/2012, UNIX

Databases: ORACLE 10g/11gR1, 11gR2, Real Application Clusters (RAC 10g/11g), SQL Server 2000/2005/2008, Exadata servers.

Tools: SQL PLUS, SQL Developer, Toad, Export & Import utility, Data Pump, RMAN, Golden gate, APEX, veridata with ssh, Data Guard 9i/10g, Tkprof, Stats pack, Discoverer, SQL navigator, Oracle reports, OAM, OEM, MS Office, Informatica 8, Cognos, MS Visio, Explain Plan, Putty, AWR/ASM/ADDM/ASH, VM Ware Work station, Amazon web services (AWS), Virtual box.

Languages: SQL, PL/SQL, shell scripting, C, C++, Python, html, JavaScript, VERITAS Net Backup

PROFESSIONAL EXPERIENCE:

Confidential, Irving, TX

Sr. Oracle DBA

Responsibilities:

• Oracle 11gR2 RAC and Standalone planning, installation, configuration, upgrade, performance tuning, backup and recovery, Data pump, migration, management and troubleshooting on Linux and Windows operating systems.
• Expertise in creating table spaces, users, assigning roles & privileges, indexes and other databases objects.
• Configuring HAIP for Oracle RAC
• Applied PSU, ONE OFF patches on UAT, STRESS, PROD environments.
• Analyzing storage analysis for creating databases.
• Enabling audit parameters.
• Experience in RAC administration (Oracle clusterware setup and configuration, ASM, Grid infrastructure and Database instances)
• Installed and configured Golden gate in 2node RAC
• Configure GG for unidirectional and bi directional replication.
• Performed core database activities live user/schema creation, adding datafiles, password reset, unlocking accounts, creating profiles, roles, assigning privileges and roles.
• Created and scheduled DBA Jobs, Scheduler Jobs.
• Trouble shoot and resolve issues related to Network configuration like LISTENER, TNSNAMES, and SQL NET on database and ASM.
• Creating disk groups onASM & ACFS file system and rebalancing disks by adding additional disks to disk group.
• Used TOAD & SQL Developer.
• Worked on restoring files from Net backup.
• Provided support for PROD, PROD -1 environments.
• Load balancing, Databases/Schema/Table Re-Organization for faster performance using export/import & Move procedures
• Daily Health Check Up of the Database using staspack, ASM, AWR, ADDM & ASH, Oracle streams.
• Rebuilding of Indexes for better performance, maintenance of Oracle Database.
• Performance tuning of Oracle Database Objects by fixing row chaining.
• Taking periodic Backup of the Database and the software using RMAN and VERITAS NetBackup.
• Written shell scripts for digitization the process. Scheduling jobs through Oracle Job Scheduler.
• Coded various PERL, SHELL scripts to automate the backup and restore backups.
• Maintaining security of databases and users.
• Reading Alert Log and User trace Files and Diagnosing the Problem.
• Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption).
• Installation and configuration of Oracle Client software and Tools.
• Created scripts to query performance views in an effort to reduce parse times and tune memory structures such as the database buffer cache, shared pool, library cache and PGA for a shared server configuration·
• Written Shell scripting, PERL which monitors the server’s performance and logs output on periodic basis to database.
• Supported Production issues relating our data warehouse databases.
• Worked along with the teams supporting various applications relating to data warehouse.
• Experienced with monitoring the database security issues and resolving them on timely basis.

Environment: Oracle 11g/12c, OEM 12c, RHEL 6,Tectia client, SQL Developer, ASM, Datapump, Golden gate, RMAN etc.

Confidential, Bothell, WA

ORCALE DBA

Responsibilities:

• Performed all aspects of database administration including installs, builds, upgrades, object sizing, object creation, backup/recovery, patches, monitoring, export/imports
• Hands on experience in troubleshooting RAC databases.
• Installation and creation of 10g and 11g databases for Testing, Development and Production.
• Successfully implemented oracle 11g grid control.
• Installed and applied patches for oracle 11g and 10g databases for supporting applications.
• Up-gradation and Migration of Database from 10.2.0.4 to 11.2.0.3 and applying patches whenever required.
• Involved in applications administration including 11g Database/Applications cloning, tuning, patching and monitoring concurrent manager processing etc.
• Experienced in handling database issues using OEM as well as command prompt.
• Developing and Implementing Disaster Recovery (DR) Plan using Data guard.
• I along with team implemented physical standby database using Data guard.

Environment: Red Hat Linux, HP -UX 11.31, Solaris, Exadata, MYSQL,Windows XP, Oracle 10g, RAC, OEM, Grid Control, RMAN, DBCA, Data Guard, Putty, TOAD 8.1, UNIX, Linux 4.0,SQL DEVELOPER

Confidential, Newark, DE

ORACLE DBA

Responsibilities:

• Installation and configuration Standby Database.
• Responsible to perform Oracle upgrades from 10g to 11g.
• Applying PSU and CPU patches.
• Involved in Database migrations (Host to Host)
• Installation and configuration of RAC and disaster recovery systems.
• Troubleshoot performance issues for the RAC instances
• Experience with Oracle Supplied Packages such as DBMS SQL and DBMS JOB
• Perform Backup and Recovery on Oracle databases.
• Monitoring the database performance using OEM Grid Control, ASM.
• Database tuning, Application Tuning & performance monitoring. Fine tuning Initialization parameters, I/O, Memory and Operating System kernel parameters.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.
• Generated Stats pack/AWR reports from Oracle 10g/9i database and analyzed the reports for Oracle wait events, time consuming SQL queries, table space growth, database growth
• Understanding execution plan of top SQL statements by using Explain plan, Auto trace and Tkprof.
• Scheduled a regular hot backup process and involved the in the backup activities
• Worked on Export Import Utility (Classical & Data Pump) and Transportable Table spaces.
• Clone of Production databases using RMAN to Testing and training environments.
• Involved in Installation, Configuration and deployment of Real Application Clusters (RAC) on different nodes and experience in adding and removing nodes.
• Configured physical standby database (Data guard) and tested for failover and switchover.
• Implement and maintain database security (create and maintain users and roles, assign privileges).
• Managed undo segments, control file and Redo Log Files.
• Create and maintain materialized views.

Environment: Oracle 9i/10g/11g RAC with Redhat, MS SQL 2005, Expdp/Impdp, RMAN, Disaster Recovery Oracle Enterprise Manager (OEM), Toad, SQL plus, Shell Scripting.

Confidential

Oracle Database Administrator/ System Administrator

Responsibilities:

• Installation and configuration Standby and RAC Database.
• Up-gradation and Migration of Database from 10g to 11g and applying patches whenever required.
• Experience with Oracle Supplied Packages such as DBMS SQL and DBMS JOB
• Perform Backup and Recovery on Oracle databases.
• Responsible for moving data from one database to other using Data Pump Export/Import.
• Backup/Recovery of Oracle databases using Oracle RMAN.
• Monitoring the database performance using OEM Grid Control
• Database tuning, Application Tuning & performance monitoring. Fine tuning Initialization parameters, I/O, Memory and Operating System kernel parameters.
• Performed SQL and PL/SQL tuning, oracle contention and monitored production database using automatic workload repository (AWR) and automatic database diagnostic monitor (ADDM).
• Experience in Database Cloning and refreshing using Data Pump Export & Data Pump Import.
• Scheduled a regular hot backup process and involved the in the backup activities
• Involved in Installation, Configuration and deployment of Real Application Clusters (RAC) on different nodes and experience in adding and removing nodes.
• Managing two nodes Real Application Cluster databases on Red hat Linux
• Database refresh from Production to Test as needed.

Environment: Oracle 9i/10g RAC with Red hat, MS SQL 2005,Expdp/Impdp, RMAN, Disaster Recovery Oracle Enterprise Manager (OEM),Toad, SQL plus, Shell Scripting.