Skills

• Please use this table to list the skills noted in the Required/Desired section of the requirement. Be sure to respond with the years of experience for each skill and the last time each skill was used.
• Add or delete rows, as needed.

Employment History

Confidential

Oracle Database Administrator

Responsibilities:

• Provided 24x7on call support for all the production and development databases.
• Implemented 10g/11g with one physical database.
• Configured and Upgraded to Oracle 11gR2 from 10g.
• Designed, configured and maintained backup and recovery policies including RMAN backups.
• Writing PL/SQL triggers, procedures, and functions.
• Creating and Managing Table Spaces, Tables, Views, Indexes, and Partitions.
• Optimized the query result cache for best performance.
• Extensively used AWR, ADDM for database performance statistics.
• SQL query tuning using tools like Explain Plan, SQL Trace, TKPROF and Stats pack
• Oracle Database and SQL Tuning using STATSPACK, EXPLAIN PLAN, TKPROF, AWR and ADDM reports.
• Good understanding of the Software development lifecycle SDLC
• Performed Range Partitioning as a cause to improve the performance of the database.
• Experience in code migration, database change management and data management through the various stages of the development life cycle
• Experience performing a full restore to an Oracle database from tape
• Provide support to developers and users with trouble-shooting and oracle performance tuning.
• Performed Cross platform migration using transportable table spaces and RMAN.
• Handled all standard database administrative tasks, such as: proactive performance tuning and monitoring, troubleshooting, back-up and recovery, installations and configurations on an as needed basis.
• Performed version upgrades and patch installs.
• Designed and implemented database backup/restore methodologies, responsible for Troubleshooting performance and networking issues.
• Solid discipline in providing end-users timely updates on their problems. Installing server software.
• Checking database performance on a regular interval, which includes checking various log files.
• Addition of users, objects etc as and when required and granting proper privileges for Database access.
• Taking care of database by checking the size the database and addition of table spaces, data files.
• Worked with OEM Oracle Enterprise Manager and Net Configuration Assistant.
• Migrating and upgrading the Oracle 9i database to Oracle 10g and incorporating the changes in the database design.
• Created standby database using data guard on testing server.
• Provided Oracle database administrative support.
• Oracle 9i,10g,11g grid control OGC , Putty, SQL plus, RMAN, Data Pump
• Maintenance and monitoring of table spaces, data file, control files etc.
• Implement and maintain database security create and maintain users and roles, assign privileges
• Database monitoring and maintenance activities which include checking alert logs, space management, undo management, gathering database statistics, database locking issues, scheduling of jobs, creation of users, schemas, table spaces and other database objects.
• Implemented scripts, which monitor database health check at regular interval, upon error, send email to the concerned person.
• Monitor and Configured Oracle 10g and 11g Database using OEM.
• Creating table spaces, tables, indexes, users, etc.
• Importing of dumps using Expdp/Impdp utilities.
• Define Backup Strategies and Implementation.
• Loading bulk data from flat files using SQL loader and external tables

Environment: Oracle 9i/10g/11g/11gR2 databases, Data pump, Export/Import, Physical Backups, Oracle Streams, Solaris9.0, AIX, Windows 2000/XP, HTTP, F-Secure SSH, , F-Secure FTP, Oracle Enterprise Manager, TOAD.

Confidential

Oracle Database Administrator

Responsibilities:

• Provided 24x7on call support for all the production and development databases.
• Implemented 10g/11g with one physical database.
• Configured and Upgraded to Oracle 11gR2 from 10g.
• Designed, configured and maintained backup and recovery policies including RMAN backups.
• Writing PL/SQL triggers, procedures, and functions.
• Creating and Managing Table Spaces, Tables, Views, Indexes, and Partitions.
• Optimized the query result cache for best performance.
• Extensively used AWR, ADDM for database performance statistics.
• SQL query tuning using tools like Explain Plan, SQL Trace, TKPROF and Stats pack
• Oracle Database and SQL Tuning using STATSPACK, EXPLAIN PLAN, TKPROF, AWR and ADDM reports.
• Good understanding of the Software development lifecycle
• Performed Range Partitioning as a cause to improve the performance of the database.
• Experience in code migration, database change management and data management through the various stages of the development life cycle
• Performed Cross platform migration using transportable table spaces and RMAN.
• Handled all standard database administrative tasks, such as: proactive performance tuning and monitoring, troubleshooting, back-up and recovery, installations and configurations on an as needed basis.
• Experience performing a full restore to an Oracle database from tape
• Performed version upgrades and patch installs.
• Extensive Experience in Oracle Performance Tuning.
• Designed and implemented database backup/restore methodologies, responsible for Troubleshooting performance and networking issues.
• Solid discipline in providing end-users timely updates on their problems. Installing server software.
• Checking database performance on a regular interval, which includes checking various log files.
• Addition of users, objects etc as and when required and granting proper privileges for Database access.
• Taking care of database by checking the size the database and addition of table spaces, data files.
• Worked with OEM Oracle Enterprise Manager and Net Configuration Assistant.
• Migrating and upgrading the Oracle 9i database to Oracle 10g and incorporating the changes in the database design.
• Created standby database using data guard on testing server.
• Provided Oracle database administrative support.
• Oracle 9i,10g,11g grid control OGC , Putty, SQL plus, RMAN, Data Pump
• Maintenance and monitoring of table spaces, data file, control files etc.
• Implement and maintain database security create and maintain users and roles, assign privileges
• Database monitoring and maintenance activities which include checking alert logs, space management, undo management, gathering database statistics, database locking issues, scheduling of jobs, creation of users, schemas, table spaces and other database objects.
• Implemented scripts, which monitor database health check at regular interval, upon error, send email to the concerned person.
• Monitor and Configured Oracle 10g and 11g Database using OEM.
• Creating table spaces, tables, indexes, users, etc.
• Importing of dumps using Expdp/Impdp utilities.
• Define Backup Strategies and Implementation.
• Loading bulk data from flat files using SQL loader and external tables

Environment: Oracle 9i/10g/11g/11gR2 databases, Windows 2003,Data pump, Export/Import, Physical Backups, Oracle Streams

Confidential

Oracle Database Administrator

Responsibilities:

• Installation Configuration and maintenance of Oracle 10g/11g on AIX, Solaris and Linux.
• Planning and scheduling Backups, Database Recovery, taking Logical Backups with Export /Import , Database backup Hot cold .
• Installation of Oracle database 10g, 11g RAC 2 node using Oracle Cluster ware. Oracle Data Guard setup done for RAC.
• Installation of Oracle 10g management agent and grid control.
• Experience performing a full restore to an Oracle database from tape
• Constantly monitoring the performance of the databases and viewing alert log files trace files.
• Proficient in managing Oracle Instance, database storage structure, schema objects.
• Experienced with SRVCTL, OCR and Voting Disk of 10g RAC.
• Installation of 9i 10g client Server with AIX.
• Install and configure Oracle Golden Gate and Veridata.
• Applied patches Patch sets and CPU patches and worked closely with Oracle to make Application environment up to date.
• Hands of experience Cost-Effective and Complete Enterprise Content Management.
• Strategic content infrastructure for managing documents, images, rich media files, and records in Management
• Good understanding of the Software development lifecycle SDLC
• End-to-End content lifecycle management from creation to archiving
• Hands of experience in content management on Contextual enterprise application integration
• Worked extensively on RMAN backups and recoveries and database cloning using RMAN Duplicate. Trouble shooting and maintenance of RMAN backups and user managed backups.
• Installing ASM environment and migrating database from NON-ASM to ASM.
• Experience in Planning Database, Sizing table space, Create database, scripts, Interact with developers and 24x7 production support.
• Generating Stats pack reports and AWR and ADDM reports for Database for Application tuning and also database Partitioning, Collected performance statistics memory usage, data storage.
• Adding the required User Logins, Groups and Users, Granting and Revoking Permission to/from the users. Co-coordinating with on-site counterpart as well as Clients and understanding requirements.
• Database Up-gradation from 9i to 10g and 10g to 11g on Linux environment.
• Performed Daily Monitoring of Oracle instances using OEM Grid Control, Monitor users, table spaces, memory structures, rollback segments, logs, and alerts.
• Involved in Performance Planning and Tuning, using baselines and proactive monitoring, bottleneck elimination and the wait event interface to identify issues.
• Extensive Experience in Oracle Performance Tuning.
• Extensively used PL/SQL for designing packages, stored procedures, functions and database triggers.
• Review changes in segment growth when compared to previous reports to identify segments with a harmful growth rate.
• Experience in shell scripts through Cronjobs to automate different types of backups including RMAN. Implemented and maintained Database security and atomized Administrative tasks.
• Implemented Backup-using RMAN Recovery Manager as media management layer

Environment: Oracle 10g with RAC, ORACLE 9i, Java, J2EE, SQL, PL/SQL, Toad, Pl/SQL Developer, Erwin, And O/S: RHEL 4.2, HPUX, Windows 2003, Golden Gate 10x, Oracle Golden Gate Veridata v2x/3.0 And OEM.

Confidential

Oracle Database Administrator

Responsibilities:

• Installed and configured 10g/11g database.
• Worked with OEM Oracle Enterprise Manager, Net Configuration Assistant.
• Setup maintenance of DATA GUARD for disaster Recovery and reporting purpose with various modes. Developing methodology to create logical/physical standby configuration with help of RMAN.
• Database creation, Table space management, User Management.
• Analyzing Database and tables.
• Monthly, Weekly and daily call report generation using AWR and ADDM.
• Monitoring the system and performing the daily checks.
• Refreshing databases for the testing/developing purpose DB only .
• Gather Oracle Database statistics -- like Table space sizes, Data files sizes, etc.
• Upgrade and Migration of Database from 9i to 10g.
• Creation of Database Health Check reports including database growth, cpu/memory utilization, Top sql etc .
• Communicate and coordinate with Oracle using TAR system for major database issues/ problems, apply the required patches, test unit test/ system test and roll out and implement the patches into production.
• Good understanding of the Software development lifecycle SDLC
• Extensive Experience in Oracle Performance Tuning.
• Performance Tuned and optimized SQL Query, SGA, and Disk I/O using Oracle Enterprise Manager and by monitoring the Stats pack report generated from snapshots taken at the peak business hours.
• Created and managed users, roles and profiles, audited and monitored databases and user access.
• Used import/export utility and Data Pump utility to transfer data.
• Working knowledge of DATAWAREHOUSING tools like ETL Extraction, Transformation and Loading

Environment: Oracle 10g/11g, SQL Loader, Windows 2000/XP, Sun Solaris 5.6/10, Linux, Data Guard, SQL, Pl/SQL, OEM, RMAN, Exp/Imp, Putty, SQL Trace.

Confidential

Oracle Database Administrator

Responsibilities:

• Created procedures, functions, packages, and triggers using PL/SQL.
• Taking Backups on scheduled time and Monitoring Scheduled Backups.
• Creating and dropping of users, granting and revoking rights as and when required.
• Involved in the Design Logical Physical and maintenance of Databases
• Preparing Backup and Recovery Plan.
• Involved in the installation of Oracle 9i/10gon Solaris and UNIX platform.
• Oracle database administration on Solaris platform.
• Storage and space management including table spaces and data files.
• Creating Databases and all database objects. Database Designing ,Designing Table space and Rollback Segments
• Extensive Experience in Oracle Performance Tuning.
• Management of table space growth, monitoring data files additions, extent growth
• Constantly monitor the performance of the Databases and viewing Alert log files Trace files.
• Using EXPLAIN PLAN for the Better performance.
• Good understanding of the Software development lifecycle
• Creating and implementing backup and recovery strategies
• Setting up and maintaining user accounts and profiles, Space management
• Ensuring proper online and offline backup. Periodical reading and checking of backups taken.

Environment: SQL Plus, Shell Scripting, Windows-NT, Red hat Linux, Oracle 8i/9i/10g.

Confidential

Oracle Database Administrator

Responsibilities:

• Installed and configured 9i/ 10g database and applied patches on it.
• Day to day monitoring like availability of system, listener, database, alter log file, trace file.
• Migrated critical database from one server to other with minimal downtime using Workbench.
• SQL, PL/SQL script to determine database growth by month
• Replicated data between two database using materialized view and DB link.
• Performed Daily Monitoring of Oracle instances using OEM Grid Control, TOAD to monitor users, table spaces, memory structures, rollback segments, logs, and alerts.
• Design and create various database objects like Tables, indexes, Triggers, synonyms, sequence and etc.
• Provide disaster recovery by configuring and maintaining physical standby database using Oracle Data Guard.
• Created users and involved in database security by granting roles, privileges, and profile.
• Configured Auditing to audit information about database activity.
• Performed, developed and maintained database backup and recovery using RMAN
• Performed logical backup of database, schemas, tables using Export/Import and DATAPUMP.
• Granted and revoked privileges to users as per requests and maintained database security procedure. Performed SQL tuning by using Explain Plan and Tkprof.
• Analyzed database object tables, indexes to get statistics.
• Involved in developing simple UNIX shell script to start-up / shutdown the databases.

Environment: Oracle 9i/10g, SQL, PL/SQL, SQL Plus, SQL Developer, Red Hat Enterprise Linux, SQL Loader, Windows NT/XP.