Proffesional summary:

• Oracle certified Professional with over 10 years of experience as a Database Administrator Oracle and seeks to achieve the zenith in my career by working with innovative professional skills with equal dedication and positive attitude, assuring high standards of efficiency with the best of abilities in a challenging environment.
• Extensive experience on 7X24 Production environments for large databases using database solutions such as OEM, RMAN, data guard and Oracle Goldengate.
• Area of expertise include high availability, space management, capacity planning, backup & recovery, disaster recovery, database performance tuning, memory tuning, PL/SQL objects tuning, security administration, table partitioning and Oracle standby server.
• Deployment, installing, maintaining and upgrading Oracle Goldengate (Single and Bi-directional).
• Analyzing, solving and creating solutions for challenging performance tuning situations. All standard database administrative tasks, such as: proactive performance tuning, load testing, monitoring and profiling, trouble-shooting, back-up and recovery, partitioning, replication, installations, capacity planning and configurations on an as needed basis as well as applying patches and upgrades.
• Implemented Oracle database tuning and administration including security management, table space utilization, schema object management, database capacity planning, bottlenecks and offensive SQL activity monitoring and resolution.
• Consulted with senior management to determine production infrastructure requirements, boundaries and priorities of new projects, and to discuss system capacity and equipment acquisitions.
• Oracle implementation, planning, designing, installing and maintaining Databases (11g, 10g, 9i) on multiple nodes (RAC and clustering) on Sun solaris, Linux, HP.
• Experience with Oracle automatic storage management (ASM), dataGuard, and oracle upgrade 9i to 10g / 9i to 11g.
• Full life cycle experience on software projects with a strong process oriented approach.
• Applied family and critical patch update (CPU), and individual patchsets software upgrade for Oracle database servers and application servers.
• Enhanced and improved performance by tuning includes indexing, compression, drive distribution, load-balancing, replication, setup and maintain accounts, access levels, and security.
• Evaluated and recommended new database software, utilities, and tools and set the strategy for implementing new technologies.
• Designed logical and physical databases for data warehouse and OLTP systems.

Technical Expertise:

Languages: Oracle 8i/9i/10g/11g, Unix scripting (ksh , tcsh, sh, perl), Oracle PL/SQL
Databases: Oracle 11g, 10g, 9i, 8i, Oracle RAC, Teradata, Oracle Timesten, Windows NT, Essbase 9.3.1/11.1.1.3
Oracle Tools: Oracle Enterprise Manager (OEM), Oracle Universal Installer,
Database Configuration Assistant (DBCA), RMAN, TOAD, SQL developer, Websphere, Cold Fusion
Exceed On demand, Precise, Statspack, Export/Import,
Veritas NetBackup, Oracle Goldengate, Clarify, Foglight, Nagios.
Microsoft Tools: MS Office Suite: MS Visio, MS Excel, MS Word, CSV files
Specialization: High Availability, Standby Databases, Clustering,
Automatic Storage Management (ASM) and Configuration, Disaster Recovery, Oracle Goldengate
Environment: UNIX, Sun Solaris, MS-DOS, Linux Itanium, Linux 64-bit, HP-UX, Windows

Confidential, PA Lead Oracle Database Administrator

(Jan'11- Present)
Comcast Corporation is the largest cable operator, home Internet service provider, and third largest home telephone service provider in the United States, providing cable television, broadband Internet, telephone service and home security [in some areas] to both residential and commercial customers in 40 states and the District of Columbia. Comcast also has significant holding in several cable networks, distribution (ThePlatform), and related businesses. The company is headquartered in Philadelphia, Pennsylvania.
Roles & Responsibilities:

• Setting up of Oracle 11g databases with RAC and non-RAC.
• Installation of Oracle RAC 11g.
• Maintaining and configuring Oracle RAC databases.
• Maintained, configuring and implementing ASM diskgroups.
• Developing and implementing disaster recovery (DR) plan.
• Deploying latest CPU release patchset to the oracle database.
• Configuring Oracle Goldengate for databases with RAC/non-RAC.
• Configuring disaster recovery environment for production databases through GolgenGate.
• Implemented Oracle Goldengate monitoring to perform regular checks on the lag and checkpoint.
• Upgrading Oracle Goldengate to the latest version.
• Configuration of daily monitoring scripts required in the maintaining Oracle databases.
• Implementing flash recovery area for RMAN backup and archivelogs for Oracle cooked file-system and ASM disks.
• Performed backups and tested crash recoveries using conventional hot & cold backups and RMAN, cloning databases using RMAN and VERITAS Netbackup.
• Performing daily and incremental level of backup through RMAN.
• Implementing automated logical backups for the schemas available in the databases using export and datapump utility.
• Scheduling and maintaining Oracle and application jobs.
• Skilled in developing RMAN scripts for database back up including hot and cold backup options for both RAC and standalone instances.
• Performance tuning for CRM product.
• Unix shell scripts for major dba activities.
• Supporting UAT for development and testing purposes.
• Providing 24*7 Supports.
• Suggesting the best practices like Index rebuilding, gathering statistics etc for improved performance.
• Creating various users and maintaining system level security including controlling the access to the database.
• Calculated current growth and planned future growth with the changes in the database system.
• Assisted report writers in query performance tuning as requested and helped in identify inefficient queries and suggest alternatives.

Technology/Platform: Oracle Databases 11g, Oracle Goldengate, Oracle RAC, Oracle RMAN, Clustering, Oracle Toad, sql developer, ASM, OEM, FRA, Linux Operating System.

Confidential, TX Lead Oracle Database/ Infrastructure Administrator

(Nov'08- Dec'10)

Confidential, is an American multinational telecommunications corporation headquartered in Whitacre Tower, downtown Dallas, Texas. AT & T is the largest provider both of mobile telephony and of fixed telephony in the United States, and also provides broadband subscription television services. AT & T is the seventh largest company in the United States by total revenue, and the fourth largest non-oil company. It is the third-largest company in Texas (the largest non-oil company, behind only ExxonMobil and ConocoPhillips, and also the largest Dallas company). As of 2011, AT & T is the 14th largest company in the world by market value, and the 9th largest non-oil company. It is also the 20th largest mobile telecom operator in the world, with over 100.7 million mobile customers.

Roles & Responsibilities:

• Worked as an application as well as production database administrator.
• Performance tuning involves AWR reports, tkprof, precise tool.
• Experience in partitioning objects.
• Worked on creating Unix shell scripting.
• Expertise in managing database jobs and implementing them.
• Experience in troubleshooting and managing the jobs failures
• Performing backup and recovery through RMAN and BCV.
• Providing 24*7 Support for critical databases
• Production upgrade for Oracle Database from Oracle 9i to oracle 11g.
• Application Patch upgrade for CRM and other products.
• Identified the high CPU utilization, long running and offensive queries and advised development team to modify the queries accordingly.
• Training and mentoring other team members on Oracle and other database administration skills.
• Proven ability to work well in a crisis and under pressure.
• Develop documentation and other materials to support ongoing database development, change control, production maintenances and DBA tasks.
• Coordinate testing with other development groups and operations. Identify appropriate level of testing and ensure that testing is complete before signing off.
• Improved performance tuning using statspack, explain plan , sql trace,tkprof,awr, and addm reports..

Technology/Platform: Oracle Database 9i, 10g,11g, Various Performance tools like Precise, RMAN, BCV backups , HP-UX and sun solaris Operating System.

Confidential, IL Senior Oracle Database Administrator

(Nov'07 - Oct'08)
Roles & Responsibilities:

• Creating and implementing database backup and recovery procedures (RMAN).
• Determining the Oracle RAC architecture
• Choosing the RAC servers and hardware
• Configuring the ASM devices for the databases
• Installing and maintaining the Oracle RAC databases
• Worked on Oracle parallel servers
• Automated Oracle daily jobs with the unix shell scripting

Technology/Platform: Oracle Database 9i,10g, RMAN, RAC, Linux and sun solaris Operating System

Confidential, Hoffman Estates IL, USA Senior Oracle Database Administrator

(Nov'07 - Oct'08)
Roles & Responsibilities:

• Creating and Implementing database backup and recovery procedures (RMAN).
• Determining the Oracle RAC architecture
• Choosing the RAC servers and hardware
• Configuring the ASM devices for the databases
• Installing and maintaining the Oracle RAC databases
• Worked on Oracle parallel servers
• Automated Oracle daily jobs with the unix shell scripting
• Creating and updating the Metalink support service requests with the ongoing Oracle issues.
• Implemented and supported a multi-byte data warehouse database
• Supported Oracle developers with the PL/SQL performance
• Created database alerts scripts, monitoring scripts
• Gathering statistics and creating unix scripts to compress
• Analyzed and applied EBS patches, complete upgrades, and database enhancements
• Provided end-to-end support of Oracle Databases and application server technologies for development, testing, and production environments including installing, upgrading, cloning and maintaining of Fusion middleware, Apache, SOA, Apex, and EBS environments.
• Extensive experience in SQL tuning and Oracle database performance tuning for the EBS environments
• Implemented role bases security procedures.
• Full life cycle experience on software projects with a strong process oriented approach.
• Implemented Oracle database tuning and administration including security management, table space utilization, schema object management, database capacity planning, bottlenecks and offensive sql activity monitoring and resolution.

Technology/Platform: Oracle Database 9i/10g, RMAN, TOAD, Exceed on demand, HP-UX and sun solaris Operating System

Confidential, PA Senior Oracle Database Administrator

(Oct'05 - Oct'06)

Roles & Responsibilities:

• Manage and support production environment, Oracle 8i, 9i.
• Database creation, setup, configuration and maintenance.
• Creation of LMT and DMT tablespace on production server.
• Performing the re-organization of the database objects.
• Performing the re-organization of the tablespaces on the production environment.
• Oracle data guard and standby databases experience.
• Creating, maintaining and monitoring physical and logical Standby databases.
• Rebuilding indexes.
• Managing cron-tab file.
• Restoring the archive logs as required for diagnostics.
• Performed de-fragmentation.
• Creating and implementing database backup and recovery procedures (RMAN).
• Creating and implementing database hot back-up using RMAN and disk-based backup.
• Generating log-mining reports according to the requirements.
• Managing tablespaces, datafiles, redo logs, tables and its segments.
• Managing users, privileges and granting Roles to them for the application requirement.
• Managing rollback segments.
• Cloning/Restore the databases for the various applications as and when required.
• Patch upgrade.
• Proactively monitored the database\'s health and taking preventive or corrective action as required.
• Recommend changes to increase efficiency, or improve accuracy and timeliness of application systems.
• Developed some Unix shell scripts to automate database operation and database monitoring for all the production databases.
• Monitor and tune database performance including SQL tuning.
• Knowledge Oracle's Enterprise Manager (OEM), stats pack reports, explain plans, and sql Trace.
• Perform tuning at the instance level via adjustment of init.ora parameters, sizing of the SGA and other appropriate measures.
• Lock monitoring.
• Query optimization.
• Creation of Unix scripts for daily basis production database monitoring.
• Maintaining databases in archive and no archive log mode.
• Providing 24*7 Support for critical databases.
• Interacting with Oracle Support.
• Weekly Status call with entire team (Onsite and offshore team).
• Daily updates via emails.

Technology/Platform: Oracle Database 9i,10g, RMAN, HP-UX and sun solaris Operating System

Confidential, Richmond, Virginia Senior Oracle Database Administrator

(Jan'04 - Oct'05)
Roles & Responsibilities:

• Creating and updating the Metalink support service requests with the ongoing Oracle issues.
• Implemented and supported a multi-byte data warehouse database
• Used Teradata technologies like fatsload, multiload, tpump to load the data.
• Supported Oracle developers with the PL/SQL performance
• Created database alerts scripts, monitoring scripts
• Gathering statistics and creating unix scripts to compress
• Implemented role bases security procedures

Technology/Platform: Oracle Database 9i, Teradata, RMAN, TOAD , Exceed on demand, HP-UX and sun solaris Operating System

Confidential,Indonesia Senior Oracle Database Administrator

(Jun'02 - Jan'04)

Confidential, is a brand name of a GSM and UMTS Mobile phone network operator which is operating in Indonesia. It was found in 1995, and is a subsidiary of Telkom Indonesia. At the end of 2010 the company set 94 million subscribers or increased by 15 percent from last year and makes Telkomsel still the biggest network operator in Indonesia by market share.
Roles & Responsibilities:

• Involved in designing the production architecture for the Telkomsel.
• Installing Oracle Client and Software.
• Creating, implementing the Timesten databases.
• Experience in Unix Shell Scripting.
• Creating Oracle Database, designing various schemas.
• Experience in Oracle RAC upgrades.
• Routine Major Dba activities and providing the automation strategies.
• Configuring backups and verification.
• Maintaining oracle databases with Raw Devices/file systems.
• Knowledge of FR/RB in Timesten database.
• Performance Tuning at various levels (involving Statspack , AWR, Tkprof).
• Supporting the UAT for the development/testing teams.
• RAC Configurations and implementation.
• Providing 24*7 Support for critical databases.
• Experience in partitioning.(Range, hash partitioning of Index organized tables).

Technology/Platform: Oracle Database 8i/9i, Oracle RAC, Oracle Timesten, RMAN, Raw devices filesystems, Sun solaris and HP-UX Operating System.

EDUCATION:
Bachelors of Engineering (Computer Science)

Reference available upon request