SUMMARY

• Oracle DBA certified with over 8+ years of IT experience in Database Administration.
• Performed all aspects of database administration including design, installs, builds, upgrades monitoring space allocation, exports /imports and SQL Loader.
• Excellent knowledge in Cluster Ready Services, Enterprise manager Grid Control, Data Guard, RDBMS, Data Modeling and managing Schema objects on Unix,Solaris,RedhatLinux.
• Performance tuning of the database - SQL Tuning, Used Tuning utilities like STATSPACK, TKPROF, EXPLAIN PLAN, AWR, ADDM and Tuning of SGA, Distribution of disk I/O, Sizing of tables and indexes by using Korn shell scripting.
• Strong experience with Application Tuning and SQL query optimization, query optimization, index tuning, caching and buffer tuning.
• Deployment and configuration of RAC on multiple nodes in 10gR1, 10gR2 and 11g.
• Lead the DBA team for creation and migration of databases from RAC instances and Application Servers.
• Experience in Oracle 8i/9i/10g Database Administration on Production, Development, Migration and Test Databases including Disaster Recovery, High Availability Solutions (RAC, Extended RAC & Data Guard) and Backup & Recovery (RMAN).
• Good experience in setting up networks for a Telecom sector for Oracle 10g installation .
• Have good hands in moving a datacenter to recover the disaster failure.
• Troubleshoot database and application exceptions by debugging the shell scripts.
• Design and script automated database jobs using Korn and Bash shells.
• Expertise in Shell tracing and syntax correction for all shell scripts and Vb scripts.
• Extensive performance tuning experience, specializing in Instance tuning, Oracle 9i RAC tuning, stored procedures and SQL optimization.
• Expertise in Operating System, Database and Application (SQL, PL/SQL) tuning.
• Creation of database, rollback segments and tuning the physical structure of database.
• Gathered and written Unix Scripts in k shell, c shell and korn shell to compress, backup and maintain remote databases.
• Provided Production Support for database management, administration and disaster recovery for several Oracle 9i, 10g,11g and SQL server 2000/2005 RDBMS.
• Have implemented ORACLE STREAMS and DATAGUARD (logical standby and physical standby databases).
• Migration from RAC to a Non RAC on Unix/AIX, Redhat Server and Solaris.
• Running upgrades and installs on testing databases and loading them on server.
• Extensive experience in Oracle Grid Control in both 10g and 11g.
• Upgrade databases and apply security patches both server and Client.
• Provided On call 24X7 Production Support.
• Migrated databases from 9i and 10g to 11gr2.
• In depth knowledge and experience in full life-cycle database including data architecture, logical and physical database design.
• Good Experience as System Administrator in Windows, Linux and Solaris on SUN SPARC servers.
• Skilled in using ERWIN for data modeling.
• Extensive experience in Extraction, Transformation and Loading of data from different sources such as Flat files, Excel, CSV, Oracle, SQL Server.
• Having hands on experience in Hot/Cold Backup, Recovery and Cloning of databases using RMAN with VERITAS Net Backup.
• Migrated existing databases from Veritas cluster Server to ASM.
• Worked in upgradation of Oracle Applications from 11.5.10.2 to 12.1.1
• Preparing Clustered Environment including hardware and software installation, configuration of RHEL 3.0/4.0 & Windows 2003 Server for oracle 9i/10g RAC (Real application clusters).
• Expertise in Installing, Configuring, Creating & Cloning Oracle 8i/9i/10g databases on Sun Solaris, Linux, UNIX and Windows platforms.
• Expertise in upgrading, migrating & patching Oracle 8i/9i/10g database using Oracle migration utilities .
• Created development, testing, staging, production, RAC and standby databases for OLTP, DSS (Data Warehousing) using customized shell scripts and stepwise.
• Involved in different scenarios of OLTP as well as DSS (DATA WAREHOUSE) Databases.
• 24x7 production database support to developers & end-users.
• Worked on Automatic Storage Management (ASM) for managing data in SAN.
• Have worked on large-scale databases with size of more than 1TB in large system environments.
• Expertise in Designing, implementing and managing Backup strategy using Oracle Utilities RMAN, Export/Import and Data Pump.
• Implemented automated backup strategy using the UNIX shell script CRON UTILITY.
• Data loading using SQL*LOADER, Logical backups using full export and DATAPUMP.
• Installation and Configuration of Oracle Grid Control.
• Used Oracle CRM to maintain good relationships with the clients
• Arranging the orders in respect to priority placed by the clients in order to fulfill the orders in time
• Used Oracle PIM in respect with the Oracle Application Server
• Administering & Managing Oracle Users, roles, privileges & creating Database objects.
• Performed database modeling, design, sizing, tuning, capacity planning.
• Management of schemas, objects, tables & indexes partitioning.

TECHNICAL SKILLS

Operating Systems: Unix(Sun Solaris 7/8/9, HPUX, AIX 5.x), Linux(Red Hat Enterprise Linux 3.0/4.0, SLES/SUSE), Windows 2000/2003/NT Server, Windows 98/XP

Database tools: RMAN, TOAD, ERWIN, SQL Developer, PIM, SDP, Fusion

High Availability: Oracle 9i/10g RAC, Data Guard/Standby Replication, Oracle Streams, Symmetric Replication, VERITAS Cluster

Utilities: Oracle Import/export utility, SQL * Loader, SVRMGRL and SQL*PLUS, OEM, TKPROF, SQL Trace, EXPLAIN PLAN, STATSPACK, AWR, ADDM, DBCA, SQL Adviser, Oracle Data Pump, SQL diagnostics, AUTOTRACE, Grid Control, Opatch, SVRCTL, CRSCTL, UTLBSTAT/UTLESTAT.

Network: SQL*Net 2.0, Net 8 and Oracle Net

Virtual Technology: VMware Server, VM Player

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

MS components: MS Office 2003/2007, MS FrontPage

PROFESSIONAL EXPERIENCE

Confidential - Lebanon, NJ

Sr. Oracle DBA/Application Developer

Responsibilities:

• Responsible for 24 X 7 Production database administration, support and monitoring.
• Migrating databases from two Extended RAC instances and Application servers to ASM using Virtual Cluster Server.
• Migration of databases from Non RAC Production Database to RAC client database using Virtual Cluser Server.
• Installed and controlled Grid Control to monitor RAC, Extended RAC and Non RAC instances patched and upgraded the grid control to 10.2.0.4 .
• Used Query Tuning to assist developers to design their applications to ensure Query Optimizer uses te best plan and improve congruence.
• Used the Grid control to monitor and manage Streams Replication which includes the availability of queue for queuing messages.
• Integrated RMAN with OEM and GRID providing optimizations and cloning techniques.
• Administered Oracle Server and SQL Server databases.
• Configured and installed Oracle 10g with two nodes Extended RAC in ASM storage with normal redundancy on Linux (RHEL4).
• Upgraded the Oracle Projects from 11.5.10.2 to 12.1.1
• Migrated Oracle databases from windows to Linux and vice versa and also between versions 10g to 11g.
• Supported different OLTP/OLAP Databases like Production, Development, Testing, and Training.
• Performed Data load on different databases using SQL*Loader.
• Involved in logical and physical databases design.
• Proactive database monitoring and management using 10g grid control tool.
• Made performance improvements to the database by building Partitioned tables, Index Organized Tables, Materialized Views and Bitmap Indexes.
• Performed database and memory tuning using tools like STATSPACK, TKPROF, EXPLAIN PLAN, OPTIMIZER, AWR and SQL tuning advisor.
• Performed database cloning to setup test and development database.
• Conducting sizing & capacity planning for Oracle databases.
• Upgrading development and production databases to Oracle 10g.
• Applied patches to Oracle Databases.
• Provided support to Application Database Administrators in designing the database.
• Planned, tested and implemented backup strategies using RMAN, Oracle Utilities (Export/Import) and OS methods.
• Implemented Hot, Cold and Logical backup plans.
• Recovered critical databases from failures with minimum downtime.
• Responsible for setting and managing user accounts, Granting required privileges to users.
• Responsible for network configuration and involved in a Client - Server environment using TNS, LISTNER, Net Configuration Assistant and other configuration files.
• Worked on Automatic Storage Management (ASM) for managing data in SAN.
• Involved in Design and implementation of oracle 10g Data Guard both physical/logical standby databases.
• Performed other regular DBA activities including space management and performance monitoring.
• Involved in process improvement, Oracle Server Installations/Upgrade/Patches, Space Management, Capacity Planning, Backup & Recovery, Disaster Recovery, Database Performance Tuning, Memory Tuning, Application Tuning, Security Administration, Data Warehousing, Data Guard, Oracle Advanced Replication, Real Application Clusters, Oracle Standby.
• Used Oracle CRM to maintain good relationships with the clients
• Arranging the orders in respect to priority placed by the clients in order to fulfill the orders in time
• Actively participated in billing
• Made use of SDP for effective functioning of middleware
• Used Oracle PIM in respect with the Oracle Application Server
• Developed UNIX shell scripts to perform the above tasks efficiently.

Environment: Oracle 9i/10g RAC, Grid, OEM, AWR, ASM, Streams, SQL*Plus, OLTP, OLAP, Grid Control, Data Guard, RMAN, Oracle TOAD 9.4, Database Cloning, SDP, PIM, CRM, Red Hat Enterprise Linux 4.0, Windows 2003, Sun Solaris, AIX

Confidential - San Francisco, CA

Sr. Oracle DBA/Application DBA

Responsibilities:

• Responsible for 24 X 7 Production database administration, support and monitoring.
• Migrating databases from two Extended RAC instances and Application servers to ASM using VERITAS Cluster Server.
• Developed Java framework for Oracle Forms and Reports for Oracle 11g.
• Writing stored procedure in MYSQL, PL/SQL to help developers in developing applications.
• Wrote PL/SQL, awk, sed and shell scripts to email and Production SBA team for monitoring server status.
• Created scripts on a daily basis scheduled with Cron jobs and Autosys.
• Designed complex data models of database object structures for Oracle CRM framework and RDBMS framework using ERWIN and Power Designer.
• Developed stored procedures and complex packages using PL/SQL.
• Developed some PL/SQL scripts, which will change the server data across all the components in the system.
• Creating and maintaining the data model and physical integrity of Oracle CRM databases using ERWIN and configuring them.
• Migration of databases from Non RAC Production Database to RAC client database using Virtual Cluster Server and storage servers using Exadatas.
• Installed and controlled Grid Control to monitor RAC, Extended RAC and Non RAC instances patched and upgraded the grid control to 10.2.0.4 .
• Used Query Tuning to assist developers to design their applications to ensure Query Optimizer uses the best plan and improve congruence.
• Used the Grid control to monitor and manage Streams Replication which includes the availability of queue for queuing messages.
• Integrated RMAN with OEM and GRID 10g and 11g providing optimizations and cloning techniques.
• Administered Oracle Server and SQL Server databases for CRM and SDLC cycle.
• Configured and installed Oracle 10g with two nodes Extended RAC in ASM storage with normal redundancy on Linux (RHEL4).
• Upgraded the Oracle Projects from 11.5.10.2 to 12.1.1
• Migrated Oracle databases from windows to Linux and vice versa and also between versions 10g to 11g.
• Supported different OLTP/OLAP Databases like Production, Development, Testing, and Training.
• Performed Data load on different databases using SQL*Loader.
• Involved in logical and physical databases design.
• Proactive database monitoring and management using 10g grid control tool.
• Made performance improvements to the database by building Partitioned tables, Index Organized Tables, Materialized Views and Bitmap Indexes.
• Performed database and memory tuning using tools like STATSPACK, TKPROF, EXPLAIN PLAN, OPTIMIZER, AWR and SQL tuning advisor.
• Performed database cloning to setup test and development database.
• Conducting sizing & capacity planning for Oracle databases.
• Upgrading development and production databases to Oracle 10g.
• Applied patches to Oracle Databases.
• Provided support to Application Database Administrators in designing the database.
• Planned, tested and implemented backup strategies using RMAN, Oracle Utilities (Export/Import) and OS methods.
• Implemented Hot, Cold and Logical backup plans using Export/ Import and Flashback technology.
• Recovered critical databases from failures with minimum downtime.
• Responsible for setting and managing user accounts, Granting required privileges to users.
• Responsible for network configuration and involved in a Client - Server environment using TNS, LISTNER, Net Configuration Assistant and other configuration files.
• Worked on Automatic Storage Management (ASM) for managing data in SAN.
• Involved in Design and implementation of oracle 10g Data Guard both physical/logical standby databases.
• Performed other regular DBA activities including space management and performance monitoring.
• Involved in process improvement, Oracle Server Installations/Upgrade/Patches, Space Management, Capacity Planning, Backup & Recovery, Disaster Recovery, Database Performance Tuning, Memory Tuning, Application Tuning, Security Administration, Data Warehousing, Data Guard, Oracle Advanced Replication, Real Application Clusters, Oracle Standby.
• Used Oracle CRM to maintain good relationships with the clients
• Arranging the orders in respect to priority placed by the clients in order to fulfill the orders in time
• Actively participated in billing
• Made use of SDP for effective functioning of middleware
• Used Oracle PIM in respect with the Oracle Application Server
• Developed UNIX shell scripts to perform the above tasks efficiently.

Environment: Oracle 9i/10g RAC, Grid, OEM, AWR, ASM, Streams, SQL*Plus, OLTP, OLAP, Grid Control, Data Guard, RMAN, Oracle TOAD 9.4, Database Cloning, SDP, PIM, CRM, Red Hat Enterprise Linux 4.0, Windows 2003, Sun Solaris, AIX

Confidential - Alpine, CA

Oracle DBA

Responsibilities:

• Responsible for administration and supporting Oracle 9i and 10g databases.
• Installation, maintenance and troubleshooting of RAC and single instance databases and Enterprise Manager Grid Control for end client HN telecom Services.
• Installing and configuring database of HN telecom as per new requirements.
• Moving and configuring Datacenter for supporting client end.
• Wrote shell scripts to email and Production SBA team for monitoring server status.
• Configured database environments with Shell Scripting specially in korn shell.
• Used RMAN for backup and recovering the client’s database.
• Installed and configured Standby Database for LMS.
• 24 x 7 production support for several mission critical systems which utilize multiple Oracle databases.
• Work with developers and management team to ensure smooth life cycle progress from development through testing and production implementation.
• Troubleshooting application failures including performance and database connectivity problems and job failures.
• Involved in performing migration from Oracle 9i and10g to Oracle 10gR2 RAC database.
• Upgrade databases and apply security patches both server and Client.
• Migrated database schemas from Development to Integration Test and Production environments.
• Database Cloning from Production to test database to identify the problems.
• Set up backup and recovery procedure using RMAN for both OLTP/OLAP databases.
• Installed and Implemented Backup & Recovery procedures. Implemented Hot, Cold and Logical backup plans.
• Created duplicate databases using RMAN duplicate.
• Worked on import/export, import/export Data Pump and SQL- loader.
• Configuration of Oracle OEM (Oracle Enterprise Manager) to monitor database and report on events as defined by the DBA group.
• Set up, configured and maintained oracle Data Guard(primary and standby databases) to ensure disaster recovery, high availability and data protection.
• Worked on Automatic Storage Management (ASM) for managing data in SAN.
• Installation of Grid Control Server and Management Server.
• Unix Shell scripting for automating startup/shutdown of databases, getting system alerts etc.
• Manage users, privileges, profiles, schemas using Grid Control of Oracle Enterprise Manager (OEM).
• Performed Database and SQL tuning by using various Tools like STATSPACK, TKPROF, and EXPLAIN PLAN, AWR, and optimizer hints.
• Created custom Statspack scripts and implementation documentation for corporate-wide roll-out to all databases for automatic periodic statistics gathering and reporting.
• Perform production system problem analysis and recommend corrective measures in a timely manner.
• Work with other vendors to support their applications.

Environment: Oracle 9i and 10g, TOAD 9.0.1, Erwin, Oracle Enterprise Manager, RMAN, RAC, ASM, Data Guard, SQL*Plus, PL/SQL, SQL*Loader, OLTP, OLAP, Windows NT / 2000, HP-UX, AIX and Linux,.

Confidential - Alpine, CA

Oracle DBA

Responsibilities:

• Providing 24 x 7 support to maintain all Databases up and running in Production environment.
• Monitored the Standby database allowing LPAR required for the financial client.
• Regular Instance Level Performance Tuning for the critical Production database servers
• Worked with the SQL Developers, to create logical and physical database design
• Analysis and Design of Oracle DB with its total Storage and fault tolerance.
• Creation and migration of Database and other related Objects.
• Implementing Database Security, Management of role-based security and database auditing.
• Managing Data Guard Database and Staging Database.
• Participated in disaster recovery testing.
• Data Migration as part of enterprise data warehouse project.
• Database Restore using RMAN, Cold Backup and Export.
• Applying Patches 9.2.0.6 and applying Oracle DST Patches on Oracle database.
• Extensive Performance Tuning, Memory (SGA) Tuning, RAC tuning, NetBackup, EMC (Time finder and SRDF), RAID, RAW Devices.
• Cloning databases using scripts as well as RMAN. Installation, setup and configuration of Data Guard.
• Managing and configuring database user accounts and permissions.
• Identifying and implementing standard operating procedures for large size db files.
• Performed fine tuning by creating indexes, TKPROF, EXPLAIN PLAN and TRACE events.
• Setting and troubleshooting of oracle listener, network connection, user security and administration. Tuning for optimum performance.
• Analyzing, designing and implementing fault tolerance system and automated error tracking system, which sends any error, occurred to concerned personnel by email. Actions to Critical Alerts.
• Defining the strategies for Backup and Recovery at physical level using RMAN and Export/ Import utilities.
• Used PL/SQL, SQL Loader as part of ETL process to populate the operational data store.

Environment:, Oracle 8i/9i/10gR1, OEM, Data Guard, RMAN, SQL* Plus, SQL*Loader, Oracle Toad, Oracle Replication, MS Office, RHEL 3.0, Windows XP/NT/2000/2003, Sun Solaris 8.0/9.0/10.0.

Confidential

Oracle Developer/ DBA

Responsibilities:

• Responsible for installing, maintaining, performance tuning and monitoring of Oracle databases version 8i/9i in different Environments like development and production.
• Responsible for testing and debugging the applications.
• Logical and Physical Modeling using ERWIN Data Modeler.
• Management of tablespaces for different users by granting quota on Default & Temporary tablespaces.
• Analyze tables to detect those affected by row migration or chained rows. Checks storage for objects growth to detect those close to their max extent limit and reorganize them as necessary.
• Estimated Storage capacity for database objects.
• Monitored the growth of the database objects UNIX Shell scripting. Implemented capacity planning.
• Created UNIX shell scripts to automate batch jobs through Cron.
• Extraction of data from different flat files into Oracle Database using SQL*Loader. Utilized SQL*loader and data pump import to load data into tables.
• Utilized Oracle Enterprise Manager (OEM) to manage users, privileges, profiles, schemas.
• Database Administration and Planning including logical design, physical design, backup & recovery.
• Oracle MTS Configuration, Password management, Disaster recovery using Data Guard.
• Ensuring security of the data in the database by monitoring environment to identify improper access.
• Accomplished quality, stability and efficiency of the database across the projects by undertaking initiation and coming up with several proposals.
• Design and implement backup and recovery system. Responsible for backups and recovery of the database using RMAN.
• Implementing security of the database by creating profiles for each user.
• Extensively involved with the Export and Import utilities to backup and recover the database.
• Constantly checking the availability of the database 24x7.
• Supported in migration of oracle applications by applying security patches.
• Developed UNIX Shell Scripts for monitoring Oracle database and to gather performance statistics.

Environment: Oracle 8i/9i, utlbstat/utlestat, OEM, RMAN, OLAP, OLTP, Shell Scripts, Erwin and Designer 2000, Export & Import, SQL*LOADER, UNIX, Windows NT/2000, Sun Solaris 8.

Confidential

System/Database Administrator

Responsibilities:

• Involved in production support activities 24/7 during on call and resolved database issues.
• Installation, Implementationand maintenance the Oracledatabase.
• Createdand managing the database objects such as tables, indexesand views.
• Involved in user creation, user access control, Schema creation and management.
• Created and managing the database storage structures which include data table spaces, index table spaces, rollback table spaces and rollback segments.
• Implemented Oracle security features and audit mechanisms for Fine grained access control.
• Maintained the RMAN repository and customized recovery catalog.
• Customized Data Guard as a tool for Disaster Planning and implementation.
• Created Logical and Physical standby Databases to ascertain high availability of database during system crashes using Data Guard.
• Involved in session management and monitored the critical wait events in the database.
• Loading the data into database with SQL*Loader.
• Written the control files for SQL*Loader to load the files in database tables.
• To improve the performance by Using the Hints, Indexes, Explain Plan, SQL Trace and TKPROF for effective retrievaland processing of queries used for retrieving the data.
• Involved in query optimization and using rule based optimizers and cost based optimizers.
• Performing the logical and physical structures for tables, indexes, modeling, normalization and foreign key constraints.
• Database maintaining including backups, recovery, imports/exports.
• Monitoring the database daily activities.
• Used Triggers for database activities, like delete and update.

Environment: UNIX AIX 5.1, Windows NT, ORACLE 8i/9i, Import/Export, SQL, PL/SQL, Toad, SQL*Loader, SQL*Net, UTLBSTAT/UTLESTAT, Cronjob, Erwin.

Confidential

Oracle Developer/ DBA

Responsibilities:

• Installed and configured Oracle RDBMS on UNIX and Windows environments.
• Responsible for administering and supporting production and development Oracle 7.1/8i Databases.
• Responsible for installing, upgrade and configuring the Oracle Server, Creating Databases, Storage Structures and Objects, Database Backup and Recovery.
• Involvement in all phases of the project life cycle.
• Responsible for troubleshooting hardware and software issues.
• Responsible for Operating System Installation and updates.
• Responsible for updating the database with the information received from various vendors.
• Analyzed the structures using Analyze command.
• Creating primary database storage structures (tablespaces, rollback segments, etc).
• Monitoring Growth of tables and undertaking necessary re-organization of database as and when required.
• Developing Hot, cold and logical backup scripts to automate the backup procedures.
• Taking Backups on scheduled time and Monitoring Scheduled Backups.
• Ensuring proper online and offline backup. Periodical reading and checking of backups taken.
• Planning for storage spaces requirements and placing them for optimum I/O performance.
• Cloned Environments to create Patch Test, Development and QA Environments.
• Partitioned large tables to increase the performance.
• Participated in Disaster Recovery Drills, documented database and application validation steps.
• Performing all daily Maintenance tasks. Interacting with Oracle Customer service as and when required.
• Creating and dropping of users, granting and revoking rights as and when required.
• Using TKPROF, EXPLAIN PLAN for the Better performance.
• Monitoring Growth of tables and undertaking necessary re-organization of database as and when required
• Resolving technical issues and Troubleshooting.

Environment: Windows 98/XP/NT, UNIX, Oracle 7.1/8i, SQL*Net, RMAN, Data Guard, CRONJOB, UTLBSTAT/UTLESTAT, TKPROF, EXPLAIN PLAN, MS Access, MS Office