OBJECTIVE

• Seeking a good position with a company which will require me to utilize my skills, abilities and experience gained to ensure the company's success.

SUMMARY

• Over 12+years as Oracle Database Administrator (Proficient in Oracle Database Administration Activities) on variety of UNIX (Solaris, HP - UX, AIX), Linux, Windows Servers with Oracle (8i, 9i, 10g, 11g), SQL net, SQL*Plus etc.
• Installed, configured and maintained enterprise environments with 24X7 production databases.
• Support performance testing, identify tuning and design changes to gain performance with AWR/Statspack.
• Hands on Oracle Data Guard (10g/11g) both logical & Physical Standby experience on Unix & Windows NT servers.
• Experience with database backup, restore, and disaster recovery procedures. Hands on experience of database backups and Recovery strategies using RMAN (9i/10g/11g), 10g/11g Data pump (expdp, impdp) Export/Import and Transportable Tablespaces.
• Monitor and manage Oracle database Security by implementing SOX Policies through Cronjob and OEM Grid Control.
• Extensive experience with Oracle Database Migration/Upgrade.
• Expertise in Creating/troubleshooting/monitoring script, creation of log files, packages & development of scripts for SQL*Loader, Export, Import, Involved in optimizing SQL queries. Monitoring and optimizing the Performance of the database using AWR/ADDM tools, Statspack & tkprof. Strong experience in tuning database performance from system as well as query tuning perspective.

TECHNICAL SKILLS

Database: Oracle 12c/11g/10g/9i/8i & MS-Access

Hardware: Sun Sparc E series, HP ProLiant HP 9000, IBM POWER5+ Servers, IBM RS6000, DELL PowerEdge, Compaq, EMC, Intel Servers, SPARC M5000 series

OS: Sun Solaris 8.x, 9.x & 10.x, HP-UX 11.x, IBM-AIX 5L 5.x, Digital UNIX 4.x, SCO UNIX 7.x, RedHat, Linux, ES 2.x, 3.x & 4.x, SUSE Linux Enterprise Server 9.x & 10.x, OpenVMS 1.x Windows, NT/2000/2003

DB Tools: OEM 9i & 10g, OEM 10g Grid Control, RAC, RMAN, Data Pump, Export/Import, SQL Loader, OWB, OID, 9i/10g RAC, Toad, 10g/11g Data Guard.

CASE Tools: ERWIN

Reporting Tools: Discoverer

Miscl Tools: Veritas Clusters, Veritas NetBackup, Tivoli Data Protection, Cron Processes, Remedy, VCS, Hummingbird

Languages: SQL*Plus, awk and Unix Shell Scripting

PROFESSIONAL EXPERIENCE

Confidential, NJ

Senior Oracle DBA

Responsibilities:

• Provide day-to-day databases support for users & application teams. Implementing database backup & restorations
• Implemented new features of Oracle 11g like Automatic Memory Management, Automatic SQL Tuning, AWR Baseline Enhancements, Case Sensitive Passwords, Data Recovery Advisor, Database Replay, Query Result Cache, Read-Only Tables, Secure Files, SQL Access Advisor, SQL Performance Analyzer, and SQL Plan Management, Statistics Collection Enhancements, Table Compression Enhancements, Tablespace Encryption, Tablespace Enhancements to the Dev/TST/PROD environments successfully.
• Installed and Configured 4 Node 11gR2 RAC on Red Hat Linux 5 platform and added 2 Node to make it a 6 Node RAC.
• Installed 11g Physical Data Guard in Maximum Performance Mode. Verify the Redo Generation, Redo Transfer and Redo Apply Services between the primary and standby database. Performed the Switchover, Switchback and Failure tests of the primary and physical standby and verified the successful catching up of standby with the primary DB.
• Installation, setup and configuration of physical Standby Database using Active data Data Guard.
• Created RAC Database on Test Hosts refreshed them with the latest snapshot of data from Prod Environment.
• Recovering the database from Block corruption, Objects-drop and using TSPITR.
• Setup DEV/TEST/UAT/QA environments from Production database using Snap mirror and RMAN.
• Installed & Configured Oracle 11g Grid Control for monitoring over 200 Prod / Non Prod Hosts.
• De-fragmentation/Reorganizing of database using Export/Import, Rebuild Index and move table.
• Used Materialized Views (snapshots) for replication of data.
• Experience in migrating large databases up to three TB
• Used Oracle streams for Data replication, Data warehouse loading, Event notification as well as business event mgt.
• Cloning/Duplicating production databases using scripts as well as RMAN.
• UNIX shell scripting in csh, ksh to be controlled from Crontab.
• Troubleshoot 11g RAC Database Performance Tuning issues using Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM). Tuned database for optimum performance.
• Upgraded Oracle Databases from 9i to 10g and 10g to 11g
• Provide primary DBA support for establishing, upgrading and maintaining the RDBMS software environments.
• Rendering 24*7 on call production DBA support

Environment: Linux (RHEL AS 4/5), Sun Solaris 10, Sun-Sparc (M5000,M8000 etc), HP ProLiant ( BL460, BL490 etc), IBM AIX 5.5, Netapp Filer, AN, NFS, EMC, VERITAS, Oracle (11g/ 10g/ 9i,8i), SQL Server 2005/2000, Grid Control,PL/SQL, SQL Scripting, UNIX Shell Scripting, Unix CRON jobs, AWR, ADDM, STATSPACK, TOAD, Netbackup

Confidential

Sr. Oracle DBA

Responsibilities:

• Upgraded Oracle Databases from 9i to 10g.
• Configured 10gR2/11gR2 RAC with ASM on AIX/ RHEL AS 4.8 servers and GPFS/Oracle cluster files systems and also configured workload management (both server side and client side Load Balancing).
• Installed and Configured Oracle 10.2.0.1 Grid Control.
• Implemented Physical Standby Data Guard for 3 Node RAC System.
• Installed Oracle 10.2.0.3 on Production DB Servers, applied OPatches to fix the known bugs and Upgraded 15 production databases sizing between 700GB and 2 TB from Oracle 9.2.0.7 to 10.2.0.3.
• Implemented the Oracle 10.2.0.3 Physical Data Guard in Maximum Performance Mode for re hosting of data center using Data Guard.
• Member of SOX team in implementing security on DB side.
• Troubleshoot Database performance (tuning) issues using Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM).
• Experience in implementation of enterprise databases on enterprise Storage Solutions using Storage area Networks.
• Downsizing and defragmenting the Very Large Databases by export / import, Cloning them using RMAN Duplicate features and then upgrading them to Oracle 10g
• Setup backup and recovery procedures using OEM, RMAN and third party tools like Veritas. Used hot backups and cold backups, incremental and full backups.
• Used Flashback technology to recover (Point-in-Time-Recovery) accidentally dropped or modified database objects.
• Experience in migrating large databases up to 5.5 TB
• Responsible for data integrity, user security, daily monitoring for production and non-production systems. Used standard, value-based and FGA auditing.
• Implemented backup strategies for archiving and non-archiving databases. Involved in planning, implementation and testing of disaster recovery.
• Developed new technique for reducing the downtime in migration of big database.

Environment: Linux (RHEL),IBM AIX 5.3, Open VMS, Windows NT, Dell poweredge 4400, IBM POWER5+ Servers, IBM RS/6000,HP9000, Sun E5000, SAN, Oracle (9i/10g/11g),SQL Server 2005, Erwin 7.1, Pro*C, PL/SQL, SQL Scripting, UNIX Shell Scripting, STATSPACK, AWR, ADDM, TOAD

Confidential

Sr. Oracle DBA

Responsibilities:

• Provide day-to-day databases support for users & application teams. Implementing database backup and restorations.
• Involved in 24*7 Remote / Onsite DBA support to Production Data Centers and interacting with offshore team in India and meeting the timelines of various projects.
• Involved in upgradation of more than 40 Databases having sizes varying from 500GB to 3 TB.
• Creation and setup of Dev/TEST/QA environment from Production database
• Installation, Upgrade and Configuration of Oracle 9i, 10g and 10g EM.
• Setting up and Auditing RMAN Hot and Cold Backups, Exports.
• Implement backup and recovery procedures using (RMAN) for Oracle databases and test regularly in conjunction with Operations. Configuring scripts for backups (hot, cold and incremental).
• Installed 10g Physical Data Guard in Maximum Performance Mode. Verify the Redo Generation, Redo Transfer and Redo Apply Services between the primary and standby database. Performed the Switchover, Switchback and Failure tests of the primary and physical standby and verified the successful catching up of standby with the primary DB.
• Installation, Configure, setup of 10g RAC on LINUX cluster with SAN storage.
• Setting up Two node RAC cluster on Windows and HP environment.
• Configured 10g R2 RAC with ASM on HP servers and OCFS cluster file system and also configured workload management (both server side and client side Load Balancing).
• Database migrating Oracle 9i to 10g.
• Plan and Schedule the Online/Offline Backups. Database and Log Backups & Restoration, Backup Strategies, Scheduling Backups. Backing up master & system databases and restoring them when necessary.
• Involved in ASO Implementation.
• Automated processes using SQL Server jobs.
• Creating and managing schema objects such as tables, views, indexes, procedures, triggers and maintaining Referential Integrity.
• De-fragmentation/Reorganizing of database using Export/Import.
• Involved in Creating / Renaming the database and implementing SOX policy.
• Implemented Password Administration, User Schema Account Naming by using standard Oracle profiles, enable password encryption, data encryption in accordance to the SOX policies of the company
• UNIX shell scripting in csh, ksh to be controlled from Crontab.
• Extensive Performance Tuning, Memory (SGA) Tuning, etc.
• Provided technical support to development team to fine tune SQL and PL/SQL code using SQL Execution Plan, SQL TRACE, ANALYZE DBMS STATS and evaluating & monitoring database to resolve performance issues including troubleshooting errors, recovering databases and failures as needed.
• Involved in design and enforcing of standards in place to ensure that all application design and code is produced with proper integrity, security and performance.

Environment: AIX 5L, Linux, Sun Solaris 9, HP-UX 11.0, Windows NT, IBM RS/6000,HP9000, Sun E5000, SAN, VERITAS, Oracle (8i/9i/10g), Pro*C, PL/SQL, SQL Scripting, Unix Shell Scripting, Unix CRON jobs

Confidential

Oracle DBA

Responsibilities:

• Creation and setup of Dev/TEST/QA environment from Production database.
• Installation, Configure, setup of 10g RAC.
• Implemented 3 node RHEL RAC with 10g Cluster to migrate existing 9i database.
• Performed several RDBMS upgrades from 8i to 9i, 8i to 10g, 9i to 10g on HP 64 bit platforms.
• Administered in Oracle Parallel Server, in managing a cluster environment (on Veritas CFS) that provides highly available and highly scalable database servers using SRVCTL utility.
• Setting up and Auditing RMAN Hot and Cold Backups, Exports.
• Configuration of Oracle Enterprise Manager (OEM 9i & 10g) tools for monitoring, performance enhancement and debugging.
• Real Application Clusters monitoring, tuning, load balancing using SRVCTL, OEM (Oracle Enterprise Manager), Statspack, and GV$ dynamic views.
• Automated failover of applications within a data center or to remote data centers.
• Implemented Fine Grained Access Control (FGAC) as per multi Organizational security.
• Provided disaster recovery testing without affecting the primary environment.
• Implemented fine grained auditing using dbms fga of Oracle 9i in order to comply the SOX policy of the Company.
• Installation, setup and configuration of logical and physical Standby Database using DataGuard.
• Installation and Configuration of SQL server 2005 on windows server.
• Involved in design and enforcing of standards in place to ensure that all application design and code is produced with proper integrity, security and performance.
• Database Refreshing / Replication from production to testing using hot backup.
• Rendering 24*7 Oncall Production database support.

Environment: Linux (RHEL), Sun Solaris, HP-UX 11.0, AIX 5.3, Windows NT, Sun E5000, SAN, VERITAS, Oracle (10g/9i), SQL Server 2005/2000, Questa Shareplex,Erwin 7.1,OWB, DataStage 7.5 EE, Pro*C, PL/SQL, SQL Scripting, UNIX Shell Scripting, STATSPACK, DBArtisan, TOAD

Confidential

Oracle DBA

Responsibilities:

• Design and implement of database backup strategy and performed full incremental and Cumulative backup using RMAN. Troubleshooting with RMAN backup problem.
• Extensive Performance Tuning, Memory (SGA) Tuning, Net backup, EMC, RAID, RAW Devices.
• Cloning databases using scripts as well as RMAN.
• Used PL/SQL, SQL Loader as part of ETL process to populate the operational data store.
• Developed several stored procedures. Setting up Replication using Database Triggers and Stored Procedures.
• Expertise in Scheduling Control-m for scheduling jobs.
• Setup, Installation, configuration and UNIX System Administration. UNIX shell scripting. UNIX CRON jobs.
• Table Partitioning, Creating Index Organized tables, Creating Locally managed Table spaces.
• Managing the partitioned tables and partitioned indexes.
• Taking Hot and Cold Backups, Exports etc
• Installation, Upgrade and Configuration of Oracle (8i, 9i).
• Configuration, maintenance and tuning of Oracle 9iRAC.
• Configuring Recovery Manager (RMAN).
• Configuration, tuning and setup of 9iAS portal and single signon.
• Creating the database, tables, tablespaces, data objects, setting privileges, indexes, user logins, password (security).
• Security User Management, Privileges, Roles, Auditing, Profiling, Authentication..
• Unix Shell scripting in csh, ksh for automating startup/shutdown of databases, getting system alerts etc.

Environment: HP-UX 11i, Sun Solaris5.9, Linux Red Hat, Windows NT/2000/2003, Oracle Server 9i/8i, SQL Server 2000, OEM, SQL*Plus, PL/SQL, Questa Shareplex, Veritas Clusters Failover, Net Backup