PROFESSIONAL SUMMARY

• 7+ years of experience in Database Administration in various environments, Development on Production and Test environments with ORACLE 11g/10g/9i/8i.
• Experience in 11g New enhancements related to Oracle RDBMS, ASM, Performance Parameters, Cluster Installation and Patching
• Experienced in installing Oracle RAC on nodes 2,3,4 on different flavors of UNIX like Solaris, HP - UX, Linux, IBM-AIX, experienced with SRVCTL,
• Successfully installed and configured Oracle RAC, ASM and non-RAC databases on UNIX platforms.
• Oracle Goldengate installation, configuration, troubleshooting GG issues.
• Performs Goldengate replication monitoring, tuning, and capacity planning.
• Configured Oracle Goldengate and parameter files in an active-active architecture.
• Experience in implementing physical standby Data guard for large databases.
• Provided physical and logical design and database creation for production & standby databases.
• Upgraded standalone databases to 10g/11gRAC environments.
• Administered Oracle Golden Gate 11g application for transactional data change capture
• Experience in basic replication using Oracle Streams.
• Experience in table level, schema level replication using Oracle Streams.
• Configured and monitored Oracle Enterprise Manager (OEM) grid control 10g/11g for database diagnostics and performance issues.
• Experience in implementing Flash Recovery Area for Flashback Technology and Flash
• Experience in Database Backup, Recovery and Disaster Recovery procedures and proficient in RMAN.
• Performing backups and recoveries using conventional hot/cold backups and RMAN
• Worked extensively on RMAN for implementing Tablespace Point in Time recovery (TSPITR), cloning, refreshing of databases.
• Proficient in Database Administration activities such as Upgrading Oracle database, applying patches, and patchsets and Critical patch update.
• Experienced in upgrading and migrating Oracle database to a higher version and other platforms using manual method and traditional Export/Import, Transportable Tables.
• Extensively worked on refreshing the databases, tables and schemas using Transportable Table space (TTS).
• Worked on Oracle automatic performance tuning features like Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM), SQL Tuning Advisor for optimum performance tuning.
• Expert in Performance Tuning of Databases, Oracle instances, and Applications. Finding Performance bottlenecks using STATSPACK, UTLBSTAT, UTLESTAT, ESTIMATE, ANALYSE, EXPLAINPLAN, SQLTRACE, and TKPROF.
• Very strong in PL/SQL, SQL and Shell Programming and developed stored procedures, packages, triggers, and automation scripts.
• Monitored frees space in tablespaces, Archive log destination, Database/Listener availability, Blocking Locks monitoring etc
• Experienced in Patching using Patch set, Critical Patch Update, Patch Set Update and One-Off patches using OPatch and run installer utilities.
• Physical and Logical Database design, entity modeling and architecture.
• Developed database standards for object naming and design practices, application migration policies and propagation of schema change from Development - QA - Staging - Production environments.
• Experience in working with Oracle support in resolving ORA-600 /7445 internal errors.
• Supporting development/ 24*7 production systems. Providing on call support for mission critical applications.
• Leadership skills and Goal Oriented, Good Co-ordination and Co-operation with the Team and Management. Adept at learning and adaptable to complex work environment.
• Excellent communication skills, good organizational skills, outgoing personality, self-motivated, hardworking, ability to work independently and grasp quickly.

TECHINICAL SKILLS:

Operating Systems: HP-UX 10.x, 11.x, Sun Solaris 2.5, 2.6, 8, 9, 10, AIX 5.1, 5.2, Red Hat Linux RHEL 2.1, 3.x, 4.x and Windows 2000,2003,2008R2

RDBMS: Oracle 11g R2/10g/9i/8i

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

Tools/Utilities: NETCA,DBCA,RMAN, OEM, SQL*Loader, SQL Server, EXP, IMP, expdp, impdp, TOADTuning Tools: ASH,ADDM,AWR,TKPROF, EXPLAIN PLAN, STATSPACK

Database Modeling: Erwin 4.0,Toad Data Modeler,Datanamic and start UML

Other: EMC, NetApp, Veritas, Netbackup, HP Data Protector,tsm

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, TX

Oracle Database Administrator

Responsibilities:

• AM (application maintenance) teams and maintain and the database environment of Oracle databases spanning version 9i to 11g on Solaris and Linux platforms.
• Troubleshooting during SEV1 and SEV2 outages
• Install DBMS software and apply patches
• create, move (migrate) or remove databases
• Maintain and configure the DB monitoring tools, such as Oracle Enterprise Manager
• Maintain Disaster Recovery and High Availability DB architecture, using Oracle Data Guard
• Respond to monitored database events
• Setup DB jobs (Statistics gathering, index rebuilds, table archives)
• Execute database backups and recoveries using hot backups and RMAN
• Develop and maintain database documentation
• Perform capacity planning (proactively monitor database usage trends for stroage, Cpu, io, etc.) and report on those trends
• Perform performance monitoring and tuning (recommend DB configuration changes to maintain or improve performance, supportability and avoid operating issues.

Environments: Oracle 9i/10g, 11g, OEM 11g Grid Control, OEM 12c Cloud Control, RMAN, Import/Export, Data Guard, SQL, PL/SQL, SQL*PLUS, AIX, Solaris, Linux, Windows

Confidential, CA

Oracle Database Administrator

Responsibilities:

• Installation and creation of 11g R2 databases for Testing, Development and Production.
• Upgrading to new versions, co-coordinating with hardware changes and applying database patches.
• Installed, configured and maintained 11g R2RACdatabase (2 node instances) with ASM on LINUX platform.
• Installed and Maintained 11g R2 RAC using ASM cluster file system on Oracle Enterprise Linux 5 with oracle clusterware.
• Efficiently managed disks by using Automatic Storage Management.
• Configuring Oracle 11g R2 Data Guard Physical Standby to ensure high availability, data protection and disaster recovery for enterprise data.
• Worked on Oracle’s data protection solution, Data guard, to detect and stop the corrupted data propagation to the target systems.
• Implemented schema replication using Oracle streams.
• Implemented Physical and Logical standby database and schema replication using Oracle streams
• Installed and configured OEM Grid control and intensively used Diagnostic&tuning packs along with AWR&ADDM reports.
• Backup plan designing and implementation using RMAN backup technology. .
• Worked extensively on Oracle 11g R2 RMAN cloning for promoting data to lower environments from production.
• Written Shell scripts to Monitor activates like availability of database & listeners, space utilization, gathering statistic for the cost base optimizer, index rebuilding etc.
• Successfully providing 24x7 supports for production, development, and test database.
• Work as the subject matter expert in the matters of performance issues, major reorganizations, auditing the required down times and the effect on the business applications between the developers, System Administrators and the end clients.
• Re-organizing the database architecture to work efficiently and for better response time.
• Plan and acquire the new technologies for evaluation and implementation, suitable for the applications in regard to the specific future requirements of the company's business projections and growth.

Environments: Oracle 9i/10g, OEM Grid Control, RAC, RMAN, Import/Export, Data Guard, SQL, PL/SQL, SQL*PLUS, Perl, Shell Scripting, AIX, HP-UX PA RISC

Confidential, Redwood City, CA

Oracle Database Administrator

Responsibilities:

• Analyzed requirements and prepared system flows, specifications, and database designs.
• Installed, Upgraded and Configured Oracle 10.2.0.3/ 9.2.0.8/8i on Red Hat Linux 5 environment.
• Worked with lead DBAs for preparing cluster, configuring, installing Cluster ware and Oracle RAC on Red Hat Linux
• Written various Shell Scripts for production, development and QA databases such as startup, shutdown, backup, analyze statistics and generate consolidated status reports.
• Startup and Shutdown of Individual instances on RAC database using OEM.
• Successfully maintained Oracle RAC environments.
• Experienced in using the commands srvctl, crsctl to start, stop manage configuration information for the Server Control Utility and for Oracle Cluster ware management in Oracle RAC environment.
• Implemented schema replication, information propagation from one database to another database using Oracle Streams.
• Used Data guard cluster techniques to provide a high level of data protection and data availability.
• Built and configured RMAN Recovery Catalog for Backup and Recovery strategy.
• Management of schemas, Data modeling, objects & partitioning the tables & indexes.
• Worked on Advanced Replication including synchronous and asynchronous scenarios
• Designed, Developed and generated reports to provide up-to-date information for production planners using Crystal Reports and MS Office.
• Upgrade and Migration of Database from lower version to 11g R2 and applied patches whenever required.
• Successfully provided 24x7support and monitoring of databases.
• Implemented the data migration from the previous database.
• Worked with cross-functional team of marketing team, engineers, and production planners to understand business process and develop functional specifications.
• Gathered requirements by interviewing production employees, production planners and management team.
• Involved in extensive usage of Erwin 4.0 for Data Modeling for both logical & physical design of the database including creation of E-R diagrams, Function Hierarchy diagrams, Process diagrams, and Data Flow diagrams.
• Automated the Sending, receiving data from clients (Electronic Data Transfer) and uploading data into database from flat files using SQL*Loader and shell scripts.

Environments: Oracle 9i/8.x, SQL, PL/SQL, SQL*PLUS, SQL*Loader, Import/Export, OEM, RAC, RMAN, Crystal Reports, Developer/2000, Erwin, Shell Scripting, Solaris, HP-Unix, Windows 2000.

Confidential, Columbus, OH

Oracle Database Administrator

Responsibilities:

• Create, maintain, and clone Oracle database versions of 8i/9i on Sun Solaris and Linux platforms
• Creating users, allocation to appropriate tablespace quotas with necessary privileges and roles for all databases.
• Involved in enrolling the users and maintaining the system security.
• Used OEM (Oracle Enterprise Manager) for routine administration, database monitoring, replication process and performance tuning.
• Implemented clustered database using RAC.
• Worked in Tuning Shared Pool, Buffer Cache, Redo Log Buffer and SGA parameters
• Planned and Performed Daily, Weekly and Monthly Backups. Tested and implemented restore procedures for complete and incomplete recovery.
• Export and import of database objects using Data pump utilities EXPDP and IMPDP
• Disaster Recovery implementation using remote standby databases. Automated the replication process using Shell Scripts replicating tables from Production to Reports database and used materialized views for reports
• Creating and Maintaining of databases: tablespaces, tables, indexes, data files.
• Helping the developing team and data warehousing team.
• Writing complex queries and procedures using SQL *plus and toad.
• Perform capacity planning required to create and maintain database environments
• Developed shell scripts and automated nightly jobs using crone to schedule the backups, exports, refresh test DB from production site and build development, testing DB’s.
• Report Generation using crystal reports 8.0.
• Configured Statspack for Tuning databases.
• Perform capacity planning required to create and maintain database environments
• Migrated flat files from different sources into Oracle Database using SQL*Loader.
• Configuring TNSNAMES.ORA and LISTENER.ORA for SQL*NET connectivity.
• Monitoring tablespace size, resizing tablespace, relocating data files for better disk I/O.
• Monitoring alert log and trace files.
• Managing archive logs, DB-links, partitions.
• Guiding and leading warehousing team for better performance.

Environments: Oracle 9i/8i, Toad, SQL*PLUS, Oracle Enterprise Manager (OEM), RMAN, Data Guard, SQL*Loader, Sun Solaris and Linux

Confidential, Somerset, NJ

Oracle Database Administrator

Responsibilities:

• Creation and Management of Tablespaces, Data files, Indexes, Rollback Segments, Tables, views, indexes, triggers and procedures.
• Database performance monitoring, Application performance monitoring, tuning database and application with efficient database parameters, Monitoring the Storage Usage by Resizing Older Tablespaces, Creation of New Tablespaces and relocation of data files for better Disk I/O.
• Oracle Network Administration (Implementation of Oracle Local Names).
• Configured Statspack for Tuning databases.
• Database Memory management (shared pool, db buffer cache and log buffer).
• RMAN implementation.
• Upgrading, analysis and testing of the test and production database.
• Database physical/logical layout design and procedures for production, development.
• Perform capacity planning required to create and maintain the database environments.
• Optimization and performance tuning of database, SGA and SQL*Net/Net8 related problems.
• Managing archived redo files, DB-links & Partitions, loading data for users by using SQL*loader.
• Installing Oracle 8i on Win’NT 4.0 Server and Setting up Oracle Clients.
• User Creations with allocation to appropriate tablespaces and quotas with necessary privileges and roles.
• Prepare logical model of the database and get it into normal form.

Environments: Oracle 9i/8i, SQL*PLUS, RMAN, SQL*Loader, Sun Solaris and Windows

Confidential

Jr. Oracle DBA/Developer

Responsibilities:

• Development and administration of Oracle databases.
• Developed automated scripts to monitor the size of tablespace extents and space utilization.
• Defining storage parameters for tables, indexes, clusters, table spaces, rollback segments, redo logs and data files
• User administration, define roles & profiles and partitioning tables.
• Involved in the installation of Oracle 9i on Solaris and UNIX platform.
• Tracking database security and auditing
• Managing System Global Area
• Monitoring and troubleshooting auto extension of table spaces
• Using TKPROF, EXPLAIN PLAN for the Better performance
• Constantly monitor the performance of the Databases and viewing Alert log files & Trace files.
• Design and implementation of backup and recovery strategy using user managed backup and recovery
• Hot and cold backups, Restore and recovery
• Exporting & importing of database data and table structure as needed
• Creation of stored procedures, packages and triggers
• Loading of Data from flat files into the Database using SQL*Loader
• Monitor database and system performance
• Tuning SQL Statements, memory (SGA), I/O operations and contention

Environments: Oracle 9i/8i, Windows XP/NT/2000, Standby Databases, Export/Import, RMAN, SQL*Loader, TOAD.