SUMMARY

• Over 8 years of experience in Information Technology as an Oracle DBA on Linux, Unix, Solaris and Windows operating system environments.
• Experience in maintaining large databases of various sizes from 40GB to 4TB.
• Experience in both managing and supporting Production, Development and Staging instances of Oracle versions 9i, 10g & 11g.
• Experience wif Dataguard - - Physical Standby and Logical Standby Databases and for Disaster Recovery using Standby databases.
• Experience in Import and Export backups, Online and Offline backups and recovery, Cold and Hot backups using Datapump utility.
• Experience in setting Backup and Recovery Procedures using RMAN and Flashback Databases.
• Experience in Cumulative and differential incremental backup using RMAN.
• Experience in Cloning databases using RMAN as well as User managed cloning.
• Configured and maintained RAC environment for high availability and scalability.
• Experience in implementation of ASM for RAC databases storage interface.
• Experience in maintaining tables, indexes, views, materialized views and optimize queries.
• Experience in installing and configuring/monitoring Enterprise Manager Grid Control.
• Experience in tuning of complex SQL statements, Explain Plan, TKPROF and DBMS STATS.
• System wide tuning using UTLBSTAT and UTLESTAT (statspack).
• Experience wif upgrading Oracle databases versions from 9i to 10g to 11g.
• Involved in migrating of non oracle databases to Oracle database.
• Experience in working and administrating Oracle GlodenGate.
• Experience in SQL and PL/SQL, writing stored procedures, triggers and functions.
• Experience wif Linux OS tasks, shell scripting, auditing system process.
• Good working noledge of the tools like Netbackup, Grid Control, Oracle Enterprise Manager, TOAD, SQL Developer, Export/Import using Datapump and SQL Plus.
• Experience in applying Patch sets, Security Patches and Interim patches.
• Broad technical noledge of Networking, Server and SAN configuration.
• Worked as a part of team in 24x7 production environment/on-call and day-to-day support.
• Excellent communication and inter-personal skills and has the ability to work under pressure and strict deadlines.

TECHNICAL SKILLS

Databases: Oracle 11g/10g/9i/8i

Operating Systems: Red Hat Server 3.x/4.x/5, AIX 5.x/6.x, HP-UX 11/11i, Sun Solaris 8/9, Windows Server 2k3 Windows Xp/7

Language: SQL, PL/SQL, C

Tools: /Utilities: Data Pump, Data Guard, OEM, DBCA, ASM, TOAD, SQL*LOADER, SQLPLUS, OEM, RMAN, SQL Developer, TOAD

Backup tools: RMAN wif VERITAS Netbackup

Scripting: Perl Scripting, Shell Scripting, Unix Cron jobs.

PROFESSIONAL EXPERIENCE

Oracle DBA

Confidential, Cincinnati, OH

Responsibilities:

• 24 X 7 Production Oracle database support and administration and on call rotation for managing Prod/Dev/Test databases.
• Configured and Installed Oracle 11g software on Red Hat Linux 5 Servers.
• Created and monitored Physical standby databases on maximum protection, performance mode using Dataguard for Disaster Recovery and performing production databases maintenance.
• Experience in maintaining Automatic Storage Management (ASM) for Oracle 11g RAC databases for reducing disk contention and providing centralized management for disks.
• Monitoring and administrating RAC databases on Oracle 11g Clusters.
• Experience wif GlodenGate for replication between RAC clustered databases.
• Creating and Maintaining databases Manually as well as using DBCA.
• Provide at least double redundancy for all development databases.
• Monitoring of Oracle Instances, Users, Tablespaces, Memory Structures, Roll Back Segments, Redo Logs, Archive Logs and Alerts.
• Responsible for granting required privileges and roles to users.
• Configuration of Listener and Net Service names using NETCA and NETMGR.
• Experience wif working wif Oracle Data Guard which is used for Disaster Recovery.
• Managing backup strategy for all production databases (at least triple redundancy).
• Used Datapump for Exporting and Importing schemas and tablespaces.
• Performed database Refreshes using Export/Import, Datapump and RMAN.
• Database Backup & Recovery for non archive and archive database wif RMAN.
• Experience wif Backup, Cloning, and Recovery using RMAN utility.
• Performing Analysis and Diagnosis of database performance statistics.
• Tuning performance using Advisors, AWR, ADDM, SQL tuning, etc.
• Experience wif SQL Review and Tuning on Oracle 10g and 11g databases.
• Experience working wif PL/SQL scripting and programming.
• Applied various patches on regular basis to oracle software homes.
• Performed database Migration from Windows platform to Linux using RMAN and Datapump.
• Reading Alert Log and User trace files and diagnosing the problem.
• Involved in performing Migration from Oracle 11gR1 to Oracle 11gR2 RAC database.
• Migration of data between databases over the network.
• Experience wif using KSH (shell scripting) for scheduling daily tasks.
• Efficient in using the Oracle tools like SQL Plus, TKPROF, STATSPACK, Datapump, Flashback, Dataguard, ASM and RMAN.
• Worked closely wif a development team to make sure the database tier is used in the right way.

Environment: Oracle 11g R1 & R2 RAC, RHEL 5, OEM Grid Control, OEM Database control, Shell Scripting, GlodenGate, SQL Plus TOAD and other Oracle Tools.

Oracle DBA

Confidential, Bloomington, IL

Responsibilities:

• 24x7 Oracle Database Administrator for Production, Development and Standby databases and provided on-call support.
• Installed, configured and maintained Oracle 11g software on RH Linux Servers.
• Created and monitored Physical standby databases on maximum protection Dataguard for Disaster Recovery and performing production databases maintenance.
• Monitored Standby Databases and performed switchover mechanisms of Dataguard.
• Involved in performing migration from Oracle 10g to Oracle 11g database.
• Applied different patches as they were release by oracle on regular basis.
• Monitored databases using Enterprise Manager and resolved issues based upon severity level.
• Loaded/Refreshed data into database using Export, Import and Datapump, etc.
• Experience wif Full/Incremental backups using Oracle Recovery Manager (RMAN).
• Created Clone and Duplicate databases for different environments using RMAN.
• Performed Backups (Full, Cumulative, Differential), Recoveries using RMAN
• Created Materialized Views/Materialized Views Logs for data replications.
• Tuned SQL and PL/SQL code using Oracle Enterprise Manager (OEM) Tools, Query Analyzer and Explain Plans.
• Monitored Alert log and wrote scripts in SQL for quick health check of the databases.
• 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 TOAD, OEM, Tuning Pack, Diagnostics Pack, and STATSPACK.
• Daily health Checkup of the database using STATSPACK, AWR, ADDM.
• Prepared backup strategy and disaster recovery management of the databases by using in-house tools written using shell scripts.
• Scheduling for the backup of database information using crontab jobs.
• Monitored and tuned rollback segment, temporary tablespaces, redo log buffer, sort area size.
• Creating and dropping of users, granting and revoking rights as and when required on Oracle databases.
• Administrated database regarding space related issues- monitoring tablespaces, users security of data accessibility and Configuring archive log destinations and flash recovery area.
• Managed and resolved admin issues during development stage. Worked closely wif developers.

Environment: Oracle 10.1/10.2/11 g, Red Hat Enterprise Linux 4/5, Solaris, TOAD, and SQL developer.

Oracle DBA

Confidential, FL

Responsibilities:

• Installing Oracle 9i/10g on Redhat Server and creating database for Production, Development and Test environments.
• Setup and configured Standby Databases for disaster recovery and reports generation in maximum performance mode using Dataguard.
• Setup and configured Physical Standby and Logical Standby databases.
• Configured and monitored Automatic Storage Management to reduce me/O contention.
• Monitored databases performance using Oracle Enterprise Manager.
• Patched/Upgraded Oracle 9i databases to Oracle 10g databases using DBUA/Manually.
• Estimated the size of Data files and Redo log files based current transactions rate, time for recoveries, etc.
• Configured and performed automated and various levels of backups using RMAN.
• Monitored and maintained Security by managing Roles/Privileges for users of the databases.
• Worked on AWR repository, Statspack report and Session Trace 10046 to find/fix root causes for performance degradation in the databases.
• Responsible for instance tuning, me/O tuning, identifying and fixed contention waits.
• Used Oracle wait interface, to identify the top most wait events and their causes.
• Used advisor tasks like ADDM, SQL/Access Tune and Undo Advisors for performance tuning.
• Installed and updates critical security Patches using Oracle Enterprise Manager.
• Worked extensively wif tools like SQL * Loader, Datapump, Export/Import, for loading data into database and monitoring and querying databases using TOAD etc.
• Created Materialized Views/Snapshots for replications and increase query performance.
• Partitioned Tables, Index for increased query performance and easier maintenance.
• Refreshed PROD, DEV, UAT databases using Datapump, RMAN, Tablespaces etc.

Environment: Oracle 9i/10g, RH Enterprise Linux 4, Windows 2k3, SQL developer, TOAD and other oracle tools.

Oracle DBA

Confidential

Responsibilities:

• Performed day-to-day DBA jobs for managing Production and Development databases.
• Provide database administration on production and development database servers.
• Experience in data conversion from 9i to 10g.
• Good experience wif Oracle productiondatabase (physical database implementation and administration).
• Migrated Oracle 10g non-ASM Database to ASM Database using RMAN.
• Restore and recover of the databases using RMAN (point-in-time recover, media failures recover, data files recover and block recover).
• Backup & Recovery (Hot and Cold, RMAN and classic methods), involved in Disaster Recovery procedures.
• Performed Datagaurd set up for failover strategy.
• Estimated Storage requirement, creation of tablespaces and other database primary objects.
• Implementation and maintenance of database security. Major point of contact of database users as and when required and administers their respective quotas. Create and maintain roles and assign necessary privileges to users according to business rules.
• Perform tuning of databases based on analysis of utilities such as AWR, ADDM, STATSPACK, and EXPLAIN PLAN.
• Clone/Refresh of production databases to testing and training environments.
• Develop/customize shell scripts to automate routine DBA tasks of taking backups, exports and monitoring space availability and database performance database.
• Creation of database objects like tables, indexes, stored procedures, snapshots and views etc.
• Creation and maintaining users, profiles and roles and maintaining system security.
• Interacted wif oracle support for resolving various critical database issues.

Environment: Oracle 9i/10g, Redhat Linux Server, Windows Server2003, OEM, SQL Plus.

Jr. Oracle DBA

Confidential

Responsibilities:

• Installing Oracle 8i/9i on AIX server and creating database for different environments.
• Designing the structure of the database to reduce contention and fragmentation backing up the database using Cold & Hot backups.
• Created tables, indexes, table spaces, users, integrity constraints and supported all phases of a development cycle.
• Migrated databases from Oracle 8i to 9i in cross platform.
• Maintaining the oracle database security like Users, Privileges, Roles and Profiles using OEM.
• Contributed to team effort by accomplishing related results as needed.
• Responsible for optimizing the queries and application tuning.
• Performed SQL tuning and assist developers wif coding SQL.
• Optimizing database performance by analyzing tables and indexes
• Writing shell scripts to automate day-to-day database administration activities like monitoring the disk space, alert logs, and archive logs.
• Scheduling for the automated backup of database information jobs.
• Refreshing the test database wif production data periodically.
• Performing management tasks on schemas and objects.
• Using SQL*Loader, Export, Import in order to extract and load data.
• Performing monitoring and performance tuning.
• Installation and configuration of oracle client software and tools.

Environment: Oracle 8.1.7/9i, AIX 5.x, Red hat Linux, OEM, and Export/Import.

System Administrator

Confidential

Responsibilities:

• Installing, configuration and support of three Windows 2003 Advance Servers as a FTP, Data Base and Web Server. Configuration of DNS (DC and ADC) servers.
• Familiar wif Oracle Application and Oracle Database installation on the servers.
• Installation, configuration and support of Data Base, FTP and Web Servers wif two nodes each for full redundancy.
• For storage Hp Proliant Clusters for MSA1000 external fibre storage system (wif 14x72GB SCSI controllers wif RAID5).
• Implementation of backup and recovery.
• Network Infrastructure elements such as network topology, routing, IP addressing, and subnetting.
• Name resolution such as WINS, DNS and remote access.
• Building and upgrading Intel based PCs and servers.
• Configuring TCP/IP and troubleshooting TCP/IP related problems.
• Configuring and managing network printers.
• LAN installations and network related problems (like system is not in network, not able to access other machines, etc.).
• Built, maintained, and repaired computer systems to improve speed, reliability, and efficiency of operation by upgrading of hardware.
• Applying the Windows Service Packs and patches and anti-virus patches and troubleshooting.
• Monitor regular maintenance and updates on 24x7 support.