SUMMARY

• 11+ years of experience as an Oracle Database Administratorhaving hands on experience in ASM/RAC administration,GlodenGate Replication, BCV Splits (EMC Snapshots, backups & Recovery), production support, installation, configuration, upgrades, patches, performance tuning, backup and recovery, cloning, space management, database security, auditing.
• Progressive experience in Oracle database Design and Architect. Proven track record of providing strategic direction while deploying tactical technical solutions.
• Exceptional analytical and problem solving skills. Excellent ability to look at problems from a macro level and a detailed level; always keeping teh appropriate business prospective.
• Excellent experience in Installation, configuration and cloning of Oracle 8i, 9i, 10g, 11g, 12c and 11g RAC and standalone in UNIX/LINUX and Windows environment.
• Installation, patching, updates,configuration maintenance of Standby Databases (DataGuard).
• Administering glodengate replication and performance issues.
• Created development, testing, staging, production, and standby databases for OLTP, DSS and Data Warehousing using customized shell scripts and stepwise.
• Experienced in database migration across platforms.
• Good experience in SQL, PL/SQL, Shell Scripting, Partitioning, OLAP, Logical and Physical Database Design, Backup and Recovery procedures.
• Management of schemas, objects & Partitioning teh tables & indexes.
• Experienced in using Data Pump, Flash - Back Recovery, AWR, ASM, ADDM, Grid Monitoring
• Proactive Monitoring, identifying areas that need to be improved in teh application and database using Statspack, AWR, ADDM and OEM Grid Monitoring.
• Planned and implemented Disaster Recovery & high availability solutions using Oracle Standby Database.
• Delivering Oracle Database performance-tuning services for customers with Explain Plan, Tkprof, Statspack, SQL Trace, AWR, ADDM, OEM Grid Control custom scripts troubleshooting Oracle databases using SQL trace utilities.
• Excellent noledge in Hot/Cold Backup and Recovery and Cloning of databases
• Performance Tuning me.e. tuning applications, shared pool, me/O distribution, buffer cache, redo mechanisms.
• Having Knowledge onOracle’sWeblogic Administration.
• Experience in Migrating teh database across Operating systems e.g Solaris to Linux.
• Working experience on database 10g, 11g and 12c upgrades.
• Excellent noledge in user management, roles, profiles
• Excellent noledge in Backups and Recovery and Cloning of databases using RMAN.
• Extensive performance tuning experience, SQL Tuning, Database/Instance Tuning.
• Experienced in Oracle Support processes for technical requests through Metalink and other Support Procedures
• Development experience in creating Procedures, Packages, Functions, Triggers and other database objects using SQL, PL/SQL.
• Experience in replication using RMAN and experience in using OEM, TOAD, Database Migrations.
• Expertise in maintaining Database Security using security compliance auditing(SOX), expertise in loading data from flat files using external tables, SQL*LOADER.
• Worked on different types of storage structures (SAN/NAS)
• Good written and verbal communication skills with a customer service oriented attitude.
• Involved in different scenarios of OLTP as well as Data warehouse databases.
• Worked with a team to provide 24x7 on-call production database support.
• 11yrs of experience as an Oracle DBA on production / stage /development environments
• Experience of working on SQL Server database administration
• Experience in HP-UX, AIX, SUN SOLARIS, Linux and Windows environments.
• Working as a DBA Lead for a team of 6 DBAs
• Excellent noledge of Oracle 12c Cloud Control
• Having noledge of EMC storage management and snapshot configuration

TECHNICAL SKILLS

Languages: SQL, PL/SQL, Unix Shell Scripting.

Tuning Tools: TKPROF, Explain Plan, Statspack, AWR, ADDM, Grid Control Tuning advisors

Web Technologies/Middleware: Oracle 10g Application Server

Operating Systems: HP-UX 10.x/11.x, Sun Solaris 8/9/10, AIX 5.1/5.2/5.3/6.1 , Red Hat Linux RHEL 2.1/3.x/4.x/5.x, MS Windows 95/98/ME/NT/2000/XP

Databases: Oracle 7.3.2/8i/9i/10g/11g/12c, Oracle 11g RAC, gloden gate

Development Tools: TOAD, SQL Plus, SQL Developer, RMAN, OEM, SQL*Loader, EXP, IMP, DataPump (expdp,impdp), VMware, Putty

PROFESSIONAL EXPERIENCE

Confidential, Webster, NY

Oracle Database Administrator lead

Responsibilities:

• Handling high availability (24/7) database in onshore-offsite model
• Handling Performance issues at application level and database level
• Applying regular quarterly CPU/PSU patches and keeping teh databases up to date with teh Oracle security updates
• Providing support to 10g, 11g, 12c and11g RAC databases.
• Providing support to teh datawarehouse jobs and tuning queries.
• Upgrading teh databases from 10g to 11g and 11g to 12c.
• Installation, configuration and maintenance of standby databases using Data guard
• Installation and maintaining of Glodengate.
• Installation and configuration of oracle 12c Cloud control
• Migration of databases to Virtual Machines.
• Cloning teh Oracle home and upgrades.
• Creating health monitoring Unix shell scripts
• Scheduling teh health scripts using cron tab, mailx.
• Trouble shooting teh user access issues.
• Creating User profiles, roles
• Partitioning of huge tables using dbms redefinition package.
• Working closely with teh application teams on scheduling teh patching windows.
• Cloning teh databases regularly for teh reporting databases and stage environments.
• Tuning teh database level performance issues.
• Taking AWR reports and analyzing them periodically for better performance.
• Participating inSOX audits and providing teh justifications to teh corporate.
• Creating SOX level auditing scripts and making teh validations and changes as required.
• Creating Backupschedules and taking periodic backups both offline and online using RMAN
• Participating in corporate DR drills and ensuring teh data protection.
• Trouble shooting teh application server issues.
• Defragmentation of teh tables using exp/imp, reorg,shrink
• Working with Oracle on critical database bug/issues.
• Creating process documents for teh DBA activities and making sure that team adhere to teh process outlined.
• Handling a team of 6 offshore members.
• Creating shift schedules
• Maintaining stringent response / resolution SLAs.
• Taking teh client requirements and working closely with teh business teams on their requirements and providing teh solutions
• Creating partitions for partitioned tables periodically
• Managing materialized views and refreshes
• Creating DB links to heterogeneous environments for teh data warehouse
• Periodic index management, index rebuilding.
• Training Junior DBAs on DBA activities

Environment: Sun Solaris, Linux, Windows, Oracle 10g and 11g

Confidential

Senior Oracle Database Administrator

Responsibilities:

• Handling high availability (24/7) database in onshore-offsite model
• Handling Performance issues at application level and database level
• Applying regular quarterly CPU patches and keeping teh databases upto date with teh Oracle security updates
• Providing support to teh data warehouse jobs and tuning queries.
• Upgrading teh databases from 9i to 10g and 11g
• Installation, configuration and maintenance of standby databases using Dataguard
• Cloning teh Oracle home and upgrades.
• Creating health monitoring Unix shell scripts
• Scheduling teh health scripts using cron tab, mailx.
• Trouble shooting teh user access issues.
• Creating User profiles, roles
• Partitioning of huge tables.
• Working closely with teh application teams on scheduling teh patching windows.
• Cloning teh databases regularly for teh reporting databases and stage environments.
• Tuning teh database level performance issues.
• Taking AWR reports and analyzing them periodically for better performance.
• Creating SOX level auditing scripts and making teh validations and changes as required.
• Creating Backup schedules and taking periodic backups both offline and online using RMAN
• Participating in corporate DR drills and ensuring teh data protection.
• Trouble shooting teh application server issues.
• Defragmentation of teh tables using exp/imp, reorg and shrink
• Working with Oracle on critical database bug/issues.
• Creating process documents for teh DBA activities and making sure that team adhere to teh process outlined.
• Creating shift schedules
• Maintaining stringent response / resolution SLAs.
• Taking teh client requirements and working closely with teh business teams on their requirements and providing teh solutions
• Creating partitions for partitioned tables periodically
• Managing materialized views and refreshes
• Creating DB links to heterogeneous environments for teh data warehouse
• Periodic index management, index rebuilding.

Environment: Sun Solaris, Linux, Windows, Oracle 9i, and 10g

Confidential

Oracle DBA

Responsibilities:

• Handling high availability (24/7) databases
• Handling Performance issues at database level
• Oracle 9iDatabase Administration
• Setting up Disaster Recovery for teh mission critical databases.
• Database installation, migration and upgrade
• Applying regular quarterly CPU patches and keeping teh databases upto date with teh Oracle security updates
• Regular database administrator activities like export/import, adding data files, creating user accounts, security settings etc
• Creating health monitoring Unix shell scripts
• Scheduling teh health scripts using cron tab, mailx.
• Trouble shooting teh user access issues.
• Creating User profiles, roles
• Partitioning big tables
• Working with teh development team on DBA issues.
• Creating partitions for partitioned tables periodically
• Managing materialized views and refreshes
• Creating DB links to heterogeneous environments for teh data warehouse
• Periodic index management, index rebuilding.
• Generating and monitoring database performance using stats pack and trace files.
• Configuring and scheduling database health check scripts
• Configuring and scheduling teh database backups.
• Upgrade of databases from 9i to 10g.

Environment: Sun Solaris, HP-UX Oracle 8i, 9i and 10g

Confidential

Oracle DBA

Responsibilities:

• Handling high availability (24/7) databases
• Handling Performance issues at database level
• Oracle 9iDatabase Administration
• Setting up Disaster Recovery for teh mission critical databases.
• Database installation, migration and upgrade
• Applying regular quarterly CPU patches and keeping teh databases upto date with teh Oracle security updates
• Regular database administrator activities like export/import, adding data files, creating user accounts, security settings etc
• Creating health monitoring Unix shell scripts
• Scheduling teh health scripts using cron tab, mailx.
• Trouble shooting teh user access issues.
• Creating User profiles, roles
• Partitioning big tables
• Working with teh development team on DBA issues.
• Creating partitions for partitioned tables periodically
• Managing materialized views and refreshes
• Creating DB links to heterogeneous environments for teh data warehouse
• Periodic index management, index rebuilding.
• Generating and monitoring database performance using stats pack and trace files.
• Configuring and scheduling database health check scripts
• Configuring and scheduling teh database backups.
• Upgrade of databases from 9i to 10g.

Environment: Linux Oracle 8i and 9i

Confidential

Oracle DBA 

Responsibilities:

• Handling high availability (24/7) databases
• Oracle 8i,9iDatabase Administration
• Regular database administrator activities like export/import, adding data files, creating user accounts, security settings etc
• Creating health monitoring Unix shell scripts
• Scheduling teh health scripts using cron tab, mailx.
• Trouble shooting teh user access issues.
• Creating User profiles, roles
• Partitioning big tables
• Working with teh development team on DBA issues.
• Managing materialized views and refreshes
• Periodic index management, index rebuilding.
• Configuring and scheduling database health check scripts
• Configuring and scheduling teh database backups.

Environment: Sun Solaris Oracle 8i and 9i