SUMMARY:

• An accomplished professional with above EIGHT years of experience as an Oracle Database Administrator having hands on experience in database administration, production support, installation, configuration, upgrades, migrations, patches, performance tuning, backup and recovery, cloning, space management, database security, auditing, troubleshooting, database design, TAR support, Unix shell scripting and documentation.
• A strategic planner with competency in conceptualising efficient Database strategy and executing the same with a view to achieve highest availability and performance.
• Experienced in Oracle 11g databases on various flavours
• Experienced in Oracle (Grid Infrastructure / Cluster Ready Services) on RAC
• Experienced in Oracle Grid Control 11g, Oracle Golden Gate, Oracle Dataguard
• Experienced in Red Hat Enterprise Linux5.8 and 6.2 servers
• Experience inOLTPdatabase systems, managing large Oracle databases.
• Experienced with MYSQL databases
• Oracle Database Administrationexperience in variety of different environments likeUnix (HP - UX, Sun Solaris, AIX, Red Hat Linux) andWindows ( 2000/2003/2005 Server)
• Hands on experience with Installation, Configuration, Upgrades, Migrations, Administration, Oracle Data Guard, Backup and Recovery usingRMAN, Disaster RecoveryandPatchingof Oracle Databases.
• Planned and implemented DR & high availability solutions using Oracle 10gData Guard,Configured and maintained Standby Databasein OLTP environment to automatically synchronize with production database.
• Excellent knowledge in logical backups,Hot/Cold Backup and Recoveryand Cloning of databases usingRMAN.
• Experience in complete recovery, incomplete recovery, recovering data files, tablespaces, control files, block corruption.
• Installed Oracle Software9i/10g/11gonRed Hat Linux& Sun Solaris platforms. Monitor database space requirements and adjust for future needs.
• Creation of database in versions8i/9i/10g/11gon all flavours of UNIX (Red Hat Linux, Solaris, Hp-Unix) and Windows ( /2005 )
• Working with business to define requirements and build the data architecture to support the business, establish development standards, recommend best practices in all areas of data warehouse i.e. data modelling; data and system integration; data management; etc.
• Experienced in System administration activities like - defining Concurrent programs, Request sets, Profile settings, Printer settings, concurrent manager, workflows, troubleshooting CM issues and User/Responsibility management.
• Experienced managing multiple Production and Development Oracle Applications environments of different releases.
• Experienced with cloning of Oracle Application from Production to Test, Dev
• Experienced on all the Oracle DBA related functions - Monitoring, Cloning, Patching, performance tuning, troubleshooting DB issues in a 24x7 environment.
• Experienced in database patches with Opatch utilities.
• Good knowledge and experience of the Oracle 10g, 11g features, OEM, ASM, and Grid Control
• Performed databasePerformance TuningandNetwork Trouble Shootingusing TNS configuration; Designed and Created primary structures such as tablespaces, tables, views and indexes; Created Database Links and Synonyms
• Database Performance Tuning usingSqlTrace, TKPROF, Explain plan, Statspack, AWR, and ADDM.
• Experience in Monitoring and Tuning system resources associated with the database performance, hit ratios, I/O, lock, and latch contention.
• Experienced in using10g featuresData Pump, Flash-Back Recovery, Grid monitoring,and Recycle bin.
• Experience usingOEM (Oracle Enterprise Manager), TOAD, Data Migrationsusing export/import, benchmarking using load testing tools.
• Expertise in loading data from flat files using external tables, SQL*LOADER.
• Participatedin Disaster Recovery Drills, documented database and application validation steps.
• Performed all daily Maintenance tasks, interacting with Oracle Customer service as and when required.
• Monitored the database growth on daily basis, Modification of databases, Addition of tablespaces, datafiles and Modification of tablespaces, datafiles. Modification and addition of primary storage objects.
• Database start-up and shutdown, alter database parameters, tablespace management, space monitoring and analyses, alter and move data files, table reorganization, index rebuild, export and import, manage database statistics, manage flashback database .
• Writing scripts for the system and database for the effective functionality and report generation.
• Scripts for Start-up and Shutdown, Health Check of Databases, Analyzing of Tables, Cold Backups.
• Knowledge on Oracle Support processes for technical requests with Metalink.
• Good Programming Skills inSQL, PL/SQL, Shell Scripting, Partitioning, Data modelling, Logical and Physical Design, Backup and Recovery Procedures.
• Use dynamic performance views (data dictionary views) for the daily activities of the databases. Monitor the alert logs for Oracle internal errors
• Maintain the security and access to the database by granting and revoking roles to and from users. Individually performed full database off-line backup weekly.
• Knowledge of Implementation and maintenance Golden Gate Replication Technology.
• Good understanding of ITIL framework mainly Change, Problem, Release, Incident, Security Management.
• Expert in supervising the team members and communicate effectively by maintaining healthy relationships with them.
• Gotthe best performer for my prompt responseand the way I handled various responsibilities.

TECHNICAL SKILLS:

Operating Systems: Unix (HP, Sun, Red Hat Linux, Aix) and Windows 2000/2003/2005

Web Technology: Shell Scripting

Databases: Oracle8i/9i/10g/11g:Database Architecture, Backup & RecoveryAnd performance tuning.

SqlServer: Backup & Cloning

Programming Languages: Basic Concepts of C, C++

Database language: SQL, PL/SQL.

Tools: TOAD,OEM, TKPROF, AUTOSYS, BMC REMEDY,Statspack, AWR, Sql-Developer and ADDM

WORK EXPERIENCE:

Confidential, Connecticut

Environment: -Oracle10g/11g on Unix(Red Hat Linux), Solaris, Aix, HP-UX environments

Tech Lead/Oracle Database Administrator

Responsibilities:

• My responsibility includes handling the Oracle databases and looking after and implementing their backup and recovery scenarios, General Database maintenance, handling Oracle tasks etc.
• Implemented 10g RAC, Grid infrastructure for 2 nodes on Red Hat LinuxusingOCFS, Oracle Cluster ware.
• Implemented Dataguard on Linux server
• Provided 24/7 Support on Oracle production instances for their esteemed clients.
• Cloning and Refreshing Oracle Database Instances.
• Oracle Database Patching and Tax updates.
• Database Health check and Space Management.
• SupportedRACinstances usingSRVCTLutility.
• Worked on configurations ofVoting Disk, OCR, Srvconfig.loc, ASM.
• Taking periodic backup of the databases on 9i/10/11g and full environments using extensive shell scripts.
• Implemented Backup & Recovery procedures.
• Solid experience in Oracle Recovery Manager (RMAN), and standby database usingData Guard 9i/10g.
• ImplementedHot, Cold and Logical backup plans, UsedRMANfor backup and recovery. Performed backup validations using RMAN.
• Worked on all various features of Oracle likeImport/Export, Oracle OEM, Impdp/Expdp, Flashback, ADDM and AWR.
• Performance tuning for optimized results using tools likeExplain Plan, SQL*Trace and TKPROF, Statspack.
• Performed regular database cloning and refreshes to setup test and development database
• Setup of Standby database for faster disaster recovery and data guard setup for high availability.
• Load balancing, databases/schema/table re-organization for faster performance.
• Responsible for optimizing the queries and application tuning. Performed SQL tuning and assisted developers with coding PL/SQL
• Used various tools for monitoring and general database management likeSQL Developer, TOAD, OEM
• Shell scripting,cron scripting, RMAN backup scriptingand developed SQL control files to load data throughSQL Loader.
• Write and execute PL/SQL statement against database and its objects.
• Experienced in maintaining high availability of databases for global operation using Oracle RAC and Data Guard/ Standby databases.
• Create and manage Standby databases at remote data centre asDisaster Recovery.
• Migration of Database from 9i to 10g and 9i/10g to 11g.
• Continuous Performance monitoring and tuning of the databases and application using OEM Tuning Pack Diagnostics Pack, STATSPACK, etc.
• Providing Solutions to the Problems Faced by end Users or Programmers.
• Recovery of Database(Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption).
• Installation and configuration of Oracle Client software and Tools.
• Automated the process of analyzing tables every night.
• Handling general tuning escalations on production databases time to time.
• Handling general Database maintenance, looking for tablespace level checks, memory issues etc.
• Using data dictionary views for the daily activities of the databases. Monitor the alert logs for Oracle internal errors
• Maintain the security and access to the database by granting and revoking roles to and from users.
• Responsible for the overall application architecture planning, design, and delivery for all Data Warehouse initiatives

Confidential, NY

Environment: -Oracle10g/11g, Unix(Linux, IBM-AIX), Windows (NT/2005)

Tech Lead/Oracle Database Administrator

Responsibilities:

• Oracle Database Administration experience on different flavours of UNIX.
• Done Installation, Configuration, Upgrades, Migrations, Administration of Oracle Databases.
• Worked on logical backups,Hot/Cold Backup and Recoveryand Database Refreshes.
• Experience in complete recovery, incomplete recovery, recovering data files, tablespaces, control files, block corruption.
• Installed Oracle Software 9i/10g on Windows and Sun Solaris platforms. Monitor database space requirements and adjust for future needs.
• Performed databasePerformance TuningandNetwork Trouble Shootingusing TNS configuration, Listener settings, Sqlnet settings.
• Database Performance Tuning usingStatspack, AWR, and ADDM.
• Worked in Monitoring and Tuning system resources associated with the database performance, hit ratios, I/O, lock, and latch contention.
• Worked on various tools likeSQL*LOADER, OEM, RMAN, RAC, Export/Import, SQL * Loader, TKPROF, Materialized Views, Replication.
• Worked on Oracle Support processes for technical requests with Metalink.
• Participatedin Disaster Recovery Drills, documented database and application validation steps.
• Performed all daily Maintenance tasks. Interacting with Oracle Customer service as and when required.
• Monitoring the database growth on daily basis, Modification of databases, Addition of tablespaces, datafiles and Modification of tablespaces, datafiles. Modification and addition of primary storage objects.
• Database start-up and shutdown, alter database parameters, tablespace management, space monitoring and analyses, alter and move data files, table reorganization, index rebuild, export and import, manage database statistics, manage flashback database .
• Writing scripts for the system and database for the effective functionality and report generation, Automation of Start-up Shutdown on all Production and Development Database, Scripts for Start-up and Shutdown, Health Check of Databases, Analyzing of Tables, Cold Backups.
• Good Programming Skills inSQL, PL/SQL, Shell Scripting, Partitioning, Data modelling, Logical and Physical Design, Backup and Recovery Procedures.
• Use dynamic performance views (data dictionary views) for the daily activities of the databases. Monitor the alert logs for Oracle internal errors

Confidential

OracleDatabase Administrator

Responsibilities:

• My responsibility includes handling the databases for allstation clients, includes looking after and implementing there backup and recovery scenarios, General Database maintenance, handling Oracle tasks.
• Installed of Oracle version 11g onLinux, Solaris, HP-UX, AIX, Windows& Created databases for Testing, Development and Production.
• Implemented Manufacturing, Financials, Purchasing for this client on Linux environment
• Maintained databases on 10g/11g for more than 15+ customers including all daily activities and DBA jobs.
• Performed Clones of Oracle Applications R12 instances.
• Taking periodic backup of the databases on 9i/10/11g and full environments using extensive shell scripts.
• Implemented Backup & Recovery procedures.
• Solid experience in Oracle Recovery Manager (RMAN), and standby database usingData Guard 9i/10g.
• ImplementHot, Cold and Logical backup plans, UsedRMANfor backup and recovery. Performed backup validations using RMAN.
• Worked on all various features of Oracle likeImport/Export, Oracle OEM, Impdp/Expdp, Flashback, ADDM and AWR.
• Used Export and Import of databases for Logical backups.
• Performance tuning for optimized results using tools likeExplain Plan, SQL*Trace and TKPROF, Statspack.
• Developer Environment Setup, Support, Cloning and Refreshes.
• Performed regular database cloning and refreshes to setup test and development database
• Setup of Standby database for faster disaster recovery and data guard setup for high availability.
• Load balancing, databases/schema/table re-organization for faster performance.
• Responsible for optimizing the queries and application tuning. Perform SQL tuning and assist developers with coding PL/SQL
• Used various tools for monitoring and general database management likeTOAD,OEM
• Shell scripting,cron scripting, RMAN backup scriptingand developed SQL control files to load data throughSQL Loader.
• Write and execute PL/SQL statement against database and its objects.
• Experienced in maintaining high availability of databases for global operation using Oracle RAC and Data Guard/ Standby databases.
• Create and manage Standby databases at remote data centre asDisaster Recovery.
• Database dot release upgrades using oracle universal installer and catpatch.sql.
• Migration of Database from 9i to 10g and 9i/10g to 11g.
• Continuous Performance monitoring and tuning of the databases and application using OEM Tuning Pack Diagnostics Pack, STATSPACK, etc.
• Providing Solutions to the Problem Faced by end Users or Programmers.
• Automation of Start-up Shutdown on all Production and Development Database.
• Write and executeSQL, PL/SQL, and Stored Procedures, shell scripts, XML, HTMLas and when required.
• Health Check of Databases, Cold Backups.
• Recovery of Database(Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption).
• Installation and configuration of Oracle Client software and Tools.
• Automated the process of analyzing tables every night.
• Handling general tuning escalations on production databases time to time.
• Handling general Database maintenance, looking for tablespace level checks, memory issues etc.
• Using data dictionary views for the daily activities of the databases. Monitor the alert logs for Oracle internal errors
• Maintain the security and access to the database by granting and revoking roles to and from users. Logical Backup of important data.

Confidential

Environment: Oracle 10g/9i, UNIX/Red Hat Linux, Sun Solaris, Windows NT/2000/2005.

Oracle Database Administrator

Responsibilities:

• Oracle Installation on different flavours of UNIX and windows for various applications of Solaria.
• Creating and maintaining the database users and controlling the usage of resources by using profiles. Maintain the security and access to the database by granting and revoking roles to and from users.
• Implemented the backup policies and involved in all the activities related to database administration
• ImplementedOracle Fail-Safe/Active-Passivesetup for different clients.
• Export and import of database objects usingData pumputilitiesEXPDPandIMPDP.
• Optimized tuning of user sessions and system level performance usingSQL TRACEand gathered statistics using DBMS STAT
• Performance tuning of database regularly, worked on developers request of general SQL-TUNING, Database tuning usedExplain Plan, SQL*Trace and Statspack.
• Responsible for handling Red Hat Linux servers and setting up the security in database. Automated the monitoring of databases regularly using shell-scripts, HTML, Cron-jobs.
• Configuring of kernel-parameters of the environments according to the end-requirements.
• Oracle Database Administration experience on different flavours of UNIX.
• Performed Installation, Configuration, Upgrades, Migrations, Administration of Oracle Databases.
• Worked on logical backups,Hot/Cold Backup and Recoveryand Cloning of databases.
• Experience in complete recovery, incomplete recovery, recovering data files, tablespaces, control files, block corruption.
• Installed Oracle Software 9i/10g on Windows and Sun Solaris platforms. Monitor database space requirements and adjust for future needs.
• Performed databasePerformance TuningandNetwork Trouble Shootingusing TNS configuration, Listener settings, Sqlnet settings.
• Database Performance Tuning usingStatspack, AWR, and ADDM.
• Worked in Monitoring and Tuning system resources associated with the database performance, hit ratios, I/O, lock, and latch contention.
• Worked on various tools likeSQL*LOADER, OEM, RMAN, RAC, Export/Import, SQL * Loader, TKPROF, Materialized Views, Replication.
• Worked on Oracle Support processes for technical requests with Metalink.
• Participatedin Disaster Recovery Drills, documented database and application validation steps.
• Performing all daily Maintenance tasks. Interacting with Oracle Customer service as and when required.
• Monitoring the database growth on daily basis, Modification of databases, Addition of tablespaces, datafiles and Modification of tablespaces, datafiles. Modification and addition of primary storage objects.
• Database start-up and shutdown, alter database parameters, tablespace management, space monitoring and analyses, alter and move data files, table reorganization, index rebuild, export and import, manage database statistics, manage flashback database .
• Writing scripts for the system and database for the effective functionality and report generation, Automation of Start-up Shutdown on all Production and Development Database, Scripts for Start-up and Shutdown, Health Check of Databases, Analyzing of Tables, Cold Backups.
• Good Programming Skills inSQL, PL/SQL, Shell Scripting, Partitioning, Data modelling, Logical and Physical Design, Backup and Recovery Procedures.
• Use dynamic performance views (data dictionary views) for the daily activities of the databases. Monitor the alert logs for Oracle internal errors

Confidential

Environment: Oracle 10g/9i, UNIX/Red Hat Linux, Sun Solaris, Windows NT/2000/2005.

Oracle DBA(Systems)

Responsibilities:

• Started working as an only Oracle DBA. Involved in full database creation of the project. Backend and Front-end database both.
• Involved in24x7 supports for 1.5TB 2 Node production RAC databaseand monitoring to ensure a proactive problem recognition and resolution of database issues.
• Creating and maintaining the database users and controlling the usage of resources by using profiles. Maintain the security and access to the database by granting and revoking roles to and from users.
• Designing thelogical and physical database structure.
• Designing the security and database access strategies.
• Enforcing the Null and check constraints.
• Involved in Database migration fromOracle 9i to Oracle 10g.
• Performing backups and recoveries usingRMAN/ conventionalhot backups.
• Setting up and testing the backup and recovery strategies.
• Experience withSQL, PL/SQL, Korn ShellScripting.
• Contributed to team effort by accomplishing related results as needed.
• Responsible for optimizing the queries and application tuning. Perform SQL tuning and assist developers with coding PL/SQL
• Oracle Database and SQL tuning usingSTATSPACK, EXPLAIN PLAN, TKPROFetc…
• UsedExternal Tablesto Load data from flat files to database.
• Experienced with various tools for general database management likeTOAD, OEM.
• Performed analysis and designed the logical & physical data model.
• Implemented different Partition methodologies to improve performance and manageability.
• Cloning databases and Setting up Disaster Recovery Databaseusing Physical Standby.
• Monitored and effectively tuned the database instances by utilizing own scripts, Oracle Statspack utilities.
• Involved in database administration includingDatabase cloning, tuning, patching and monitoringconcurrent manager processing.
• Monitoring Growth of tables and undertaking necessary re-organization of database as and when required.
• Monitoring of database for growth and performance
• Ensuring proper online and offline backup. Periodical reading and checking of backups taken.
• Conducted multiple “dry runs” (test runs) to gather timings for production upgrades
• Recovered the instance production database as a result of data corruption by successfully applying the archive redo log files.
• Implemented database auditing, data security and Remediate high-risk violation in production environment.
• Created Database objects like Tables, Views, Indexes, Sequences, etc. and maintained Database sizing like tablespaces, adding of datafiles, multiplexing of control files.
• Responsible for database user administration and setting up the security in database.
• Implemented various backup policies and daily maintenance tasks in the project.
• Was not only involved in database creation but made several oracle and smallshell scriptsto automate various functionalities in project.
• Memory Tuning: (SGA) such as the database buffer cache, library cache, data dictionary cache and redo log buffer cache by changing several parameters at runtime.
• Was fully involved in making regions or an instance of software up fully. So know the full backend and front-end utilities well and automated many of them
• Was side-by-side administering much other different vendor software required in project implementation likeDefect Change Management System