SUMMARY:

• Having 7+ years of IT experience which includes 6+ years of experience as an Oracle DBA on Production/ QA/ PSE/ DEV, Advanced/Multi Master Replication, RMAN, ASM, RAC, DataGuard, RHEL 5/6, CENTOS 5/6, SUSE 10, PostgreSQL 8.3, Symanac 10d Tape Backup.
• Expertise in Oracle 11g, 10g, 9i, 8i specializing in installation on Red hat, OEL, CentOS & SUSE 10 Linux, SUN Solaris Unix configuration.
• Setup/configured oracle RMAN for database backup and recovery. Applied different recovery procedures for complete and incomplete recoveries depending on the type of failure by using export/import & o/s scripts like shell & korn scripts.
• Migrating a Non ASM Single instance Oracle 10g Database to 10g RAC Database configured on ASM.
• Experienced in configuring Oracle Advanced/Multi Master Replication on 10g.
• Good understanding and knowledge of Oracle 10g/11g multi node RAC on OEL 5.6 & CentOS, & Dataguard.
• RDBMS Software Install/Upgrade/CPU - PSU Patching/Migrations, Database/Server Consolidations, Data center relocations.
• DBA - Utilities - Reorg, Index Builds, Export Jobs, Analyze/Stats, Resource manager, PL/SQL and Scripting to achieve this.
• Experience in Installation and Administration of Greenplum/ PostgreSQL on RedHat, SUSE, Fedora & CentOS Linux.
• Expertise working as a Linux Administrator (Red hat-RHEL 4/5, OEL 5.6, CentOS 5/6, Fedora 12 & SUSE 10 Linux) including Installation, Administration, Middle Level Performance Monitoring etc.
• Provided 24/7 On-call support for production databases.
• Clone/Refresh of Production databases to Testing and environments.
• Experience Working on VMware Server 2.0 on Linux and Windows workstation.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 8.1.1

RDBMS: Oracle 11g/10g/9i, PostgreSQL 8, MS SQL Server 2003/2000.

Tools: Toad, SQL*Loader, RMAN.

Languages: SQL, PL/SQL, UNIX Shell Scripting, C,C++

Operating Systems: Linux, Solaris, Windows NT, Windows 95/98/00/xp.

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, TX

Oracle 10g/11g DBA

Responsibilities:

• Installation, configuration of Oracle 10g and 11g on Oracle Enterprise Linux 5.6 (OEL)
• Oracle 11g Administration and support.
• Created, Managed, Monitored & Configured Network Settings, Archive logs, Undo segments, Control Files, Standby by, Tablespaces, Data file, Alert logs, Trace log, RMAN, Enrolling User Management & Security, DBVerify Utility, Monitoring Multimaster Replication, Online backup, logical backup.
• RDBMS Software Install/Upgrade/CPU-PSU Patching/Migrations, Database/Server Consolidations, Data center relocations.
• Database user/role/access management to maintain security.
• Maintaining Oracle Databases in Cluster Environment.
• Replicating Oracle Databases as per requirement.
• Running the health check for databases on regular basis.
• Setup/configured oracle RMAN for database backup and recovery. Applied different recovery procedures for complete and incomplete recoveries depending on the type of failure by using export/import & o/s scripts like shell & korn scripts.
• Migrating a Non ASM Single instance Oracle 11g Database to 11g RAC Database configured on ASM.
• Optimization and fine-tuning the database by planning storage requirements, building indexes and altering storage clauses for tables and indexes. Monitor and Tuning of Database Performance by using various optimization techniques.
• Provide database administration on production, testing and development database servers. Creation of database objects like tables, indexes, stored procedures and views etc. Creation of users and roles and maintaining system security.
• Installed and setup Oracle BI Apps 11g environment (OBIEE 11G, OBIA 7.9.6.3, DAC 10.1.3.4.1 , INFORMATICA 9.1) on Linux and windows servers.
• Setup and helped design database for ETL Testing Tool developed using Perl and PHP.
• Basic Monitoring of Oracle 11g RAC and DataGuard environments.

Confidential, Richardson, TX

Database Administrator

Responsibilities:

• Install, Configure, Managing, Monitor for all Production and UAT servers.
• Oracle 9i/10g Administration, Installation, configuration on Linux and Windows 2003 servers.
• Other responsibilities included Creating, Managing, Monitoring & Configuring Network Settings, Archive logs, Undo segments, Control Files, Standby by, Tablespaces, Data file, Alert logs, Trace log, Enrolling User Management & Security, DBVerify Utility.
• Monitoring Multimaster Replication.
• Database user/role/access management to maintain security.
• Maintaining Oracle Databases in Cluster Environment.
• Replicating Oracle Databases as per requirement.
• Running the health check for databases on regular basis
• Managing Monitoring RMAN Hot/Online backups, logical backup running on 24/7 .
• Design and implementation of database backup strategy and performed full, incremental and Cumulative backups using RMAN. Troubleshooting with RMAN backup problem.
• Coordinating with Developers and users connecting to different databases, setting policy and procedures as they relate to database maintenance, Security, backup & Recovery etc.
• Estimate Storage requirement, Creation of Tablespaces and other Database Primary Objects.
• Clone/Refresh of Production databases to Testing and environments.
• Worked closely with application team members to perform SQL Tuning using Explain Plan, SQL Trace, Optimizer Hints, Statspack, AWR and TKPROF utility.
• Postgresql Administration: Installation, Configuration Postgresql Standy Server, Scheduling Hot backup, pg dump, pg restore, Managing Slony Replication, Ruby Replication, Vacuum analyze.
• Check and Verify all instances are up/running using Nagios.
• Managing and Monitoring Servers using Citrix system.
• Checking Email alerts on Daily/Montly and Hourly basis for all running on Production/UAT instances.
• Linux Administration: Installation, Scheduling Cronjobs, writing shell scripts, monitoring logs, Basic Performance Linux.

Environment: Oracle 9i,10g Database Administrator, PostgreSql 8.3/9.1 Adminstrator & Linux (SUSE 10, RHEL Server 4.0 and Fedora 12).

Confidential, WA

Database Administrator

Responsibilities:

• Installation, configuration and maintenance of Oracle 10g on Linux, Windows Server 2003.
• Creating, Managing, Monitoring & Configuring Network Settings, Archive logs, Undo segments, Control Files, Tablespaces, Data file, Alert log, Trace logging, RMAN, Enrolling User Management & Security, DBVerify Utility.
• Managing Monitoring RMAN Hot/Online backups, logical backup running on 24/7 .
• Design and implementation of database backup strategy and performed full, incremental and Cumulative backups using RMAN. Troubleshooting with RMAN backup problem.
• Coordinating with Developers and users connecting to different databases, setting policy and procedures as they relate to database maintenance, Security, backup & Recovery etc.
• Checking Email alerts on Daily/Montly and Hourly basis for all running on Production/UAT instances.
• Linux Administration: Installation, Scheduling Cronjobs, writing shell scripts, monitoring logs, Basic Performance Linux.

Environment: Oracle 10g, RMAN, RHEL 4, Window 2003 server.

Confidential, DE

Database Administrator

Responsibilities:

• Installed, set up and maintained Oracle 10g on Linux, Windows XP.
• Wrote SQL Queries, PL\SQL Procedure, Packages, Cursors.
• Creating, Managing, Monitoring & Configuring Network Settings, Archive logs, Undo segments, Control Files, Standby by Database, ASM, Flash Recovery Area, LOGMNR utility, Tablespaces, Data file, Alert log, Trace logging, RMAN, Enrolling User Management & Security, DBVerify Utility.
• Backup & Recovery RMAN (Differential, Cumulative), Export/Import, Data Pump, User Managed Backups.
• Managed and installed Third Party Tool Accord Client software on Pharma instrument machines.
• Setup Symentac 10d Backups.

Environment: Oracle 9i, RMAN, Symentac 10d Backups, Window 2003 server.

Confidential

Oracle Developer

Responsibilities:

• Requirements Analysis and Gathering
• Placing & generating indents on planning bases.
• Preparing purchase orders for the indents.
• Preparing GRNs & then Bill Passing, Material issues & returns handling.
• Generate various types of reports related stores, purchase, and planning.
• Developed the end users screens using Forms.
• Wrote many PL/SQL codes, Triggers, Stored procedures and PL/SQL Blocks Pro *C programs, modified some shell scripts, modified/converted forms and reports.
• Used SQL Trace and Explain plan to optimize the SQL Statement.
• Used SQL * Loader to load the data from the text files.
• Performed necessary validations for each screen developed by writing procedures and functions available along with the objects, events and methods.
• Wrote SQL statements to access data from the Oracle database.
• Generated necessary reports periodically using Reports.

Environment: Oracle 7.3, PL/SQL, SQL* Plus, Developer/2000 (Forms & Reports), Windows NT.