We provide IT Staff Augmentation Services!

Oracle Dba Resume Profile

Summary:

Over 8 years of experience as an Oracle Database Administrator having hands on experience in database administration, production support, installation, configuration, upgrades, patches, performance tuning, backup and recovery, cloning, space management, database security.

  • Over 8 yrs of experience as an Oracle DBA on production / stage /development environment.
  • Installation, patching, updates, configuration maintenance of Oracle 10g RAC, 11g RAC, Standby Databases Data Guard .
  • Created development, testing, staging, production, RAC and standby databases.
  • Management of schemas, objects Partitioning the tables indexes.
  • Development experience in creating Procedures, Packages, Functions, Triggers and other database objects using SQL, PL/SQL.
  • Proactive Monitoring, identifying areas that need to be improved in the database using Stats pack, AWR, ADDM and OEM Grid Monitoring.
  • Experienced in using Data Pump, Flash-Back Recovery, AWR, ASM, ADDM, Grid Monitoring, and Recycle Bin.
  • Participated in SDLC cycles and release management using ITIL tools like JIRA , ITT
  • Experience in cloning the oracle homes and upgrades
  • Working experience on database 10g, 11g upgrades.
  • Experiencedin user management, roles, profiles.
  • Experienced in Hot/Cold Backup and Recovery and Cloning of databases.
  • Experienced in Backups and Recovery and Cloning of databases using RMAN.
  • Extensive performance tuning experience, SQL Tuning, Database/Instance Tuning.
  • Planned and implemented Disaster Recovery high availability solutions using Oracle Standby Database.
  • Delivering Oracle Database performance-tuning services for customers with Explain Plan, Tkprof, Stats pack, SQL Trace, AWR, ADDM, OEM Grid Control custom scripts troubleshooting Oracle databases using SQL trace utilities.
  • Performance Tuning i.e. tuning applications, shared pool, I/O distribution, buffer cache, redo mechanisms.
  • Experienced in using golden gate for data replication.
  • Experienced in Oracle Support processes for technical requests through Metal ink and other Support Procedures
  • Experience in golden gate maintenance, installation and troubleshooting.
  • Migrating databases from physical disks to ASM related disks.
  • Good experience in SQL, PL/SQL, Shell Scripting, Partitioning, OLAP, Backup and Recovery procedures.
  • Experience in replication using RMAN and experience in using OEM, TOAD, Database Migrations using transportable table spaces, transportable database, benchmarking using load testing tools
  • Experienced in installation, maintaining and troubleshooting database using precision.
  • Experienced in database migration across platforms using transportable table spaces and RMAN.
  • Good written and verbal communication skills with a customer service oriented attitude.

Technologies:

Languages

SQL, PL/SQL, C, C , Java, Unix Shell Scripting, Pro C.

Operating Systems

HP-UX 10.x/11.x, Sun Solaris 2.5/2.6/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

Database

Oracle 7.3.2/8i/9i/10g/11g, Oracle 10g RAC, Oracle 11g RAC,Goldengate.

Tuning Tools

TKPROF, Explain Plan, Stats pack, AWR, ADDM, Grid Control Tuning advisors

Development Tools

TOAD, SQL Plus, SQL Developer, RMAN, OEM, SQL Loader, EXP, IMP, Data Pump expdp,impdp , VMware, Informatica, Putty

Professional Experience:

Confidential

Oracle database consultant

Responsibilities:

Handling 100 databases including finance related, mission critical, business critical data warehouse and sensitive health care related databases within the stringent response/resolution SLA timelines.

Database Administration DBA :

  • 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 the databases up to date with the Oracle security updates
  • Providing support to 10g/11g RAC, databases.
  • Rolling patching and upgrades of 10g/11g RAC databases.
  • Upgrading the databases from 9i to 10g, 10g to 11g.
  • Cloning oracle homes.
  • Creating health monitoring UNIX shell scripts.
  • Experienced with data replication using golden gate.
  • Developed various SQL and PL/SQL scripts for verification of the required functionalities.
  • Scheduling the health scripts using cron tab, mailx.
  • Trouble shooting the user access issues.
  • Installing maintaining and troubleshooting databases with precision.
  • Working experience in data replication using golden gate
  • Creating User profiles and roles.
  • Hands on experience in Golden gate installation and troubleshooting.
  • Developed various database objects using sql, plsql.
  • Migrating databases across platforms using transportable table spaces and golden gate
  • Migrating databases from physical disks to ASM related disks.
  • Working closely with the application teams on scheduling the patching windows.
  • Cloning the databases regularly for the reporting databases and stage environments.
  • Tuning the database level performance issues.
  • Taking AWR reports and analyzing them periodically for better performance.
  • Creating Backup schedules and taking periodic backups both offline and online using RMAN
  • Taking logical backups using data pump.
  • Participating in corporate DR drills and ensuring the data protection.
  • Working with Oracle on critical database bug/issues.
  • Creating process documents for the DBA activities and making sure that team adhere to the process outlined.
  • Migrating databases across platforms using transportable table spaces and RMAN.
  • Creating partitions for partitioned tables periodically.
  • Managing materialized views and refreshes
  • Creating DB links.
  • Periodic index management, index rebuilding.

Environment: Oracle 10g/11g, RAC, sunsolris, AIX, Linux, OEM, TOAD, Shell Scripting, RMAN and Putty.

Confidential

Oracle DBA

Responsibilities:

Database Administration DBA :

  • Handling Oracle performance related issues at instance level and SQL level for enterprise data warehouse.
  • Finding the right materialized view refresh techniques using explain mview, tune mview procedures.
  • Working with the partitions.
  • Tuning the Oracle instance, SGA components, DB files etc.
  • Tuning the PL/SQL code.
  • Tuning at the object level including tables, indexes, views etc.
  • Generating AWR report and analyzing the top events and other
  • Generating ADDM reports
  • Providing support to 10g/11g RAC, databases.
  • Taking the StatsPack reports
  • Analysing the trace files using TKPROF
  • Tuning the SQLs with different optimizers 9i,10g
  • Training the developers on effective SQL writing
  • Scheduling the ETL jobs legitimately on Unix machines.
  • Providing on-call support during the crucial periods like Yr End etc
  • Co-coordinating with the Unix team , developer, application support and DBA team.
  • Taking AWR reports and analyzing them periodically for better performance.
  • Creating Backup schedules and taking periodic backups both offline and online using RMAN
  • Participating in corporate DR drills and ensuring the data protection.
  • Working with Oracle on critical database bug/issues.
  • Creating process documents for the DBA activities and making sure that team adhere to the process outlined.
  • Golden gate installation, maintenance.
  • Planning Backup/Restoration Strategy, Planning and scheduling Backups, taking Logical Backups with Export / Import utilities.
  • Maintaining stringent response / resolution SLAs.
  • Creating partitions for partitioned tables periodically.
  • Managing materialized views and refreshes
  • Creating DB links.
  • Periodic index management, index rebuilding.

Environment: Oracle 10g/11g,,AIX, Linux, Solaris, OEM, TOAD, Shell Scripting, RMAN, Goldengate.

Confidential

Oracle DBA Consultant

Role and responsibilities:

  • Configuration and implementation of Backup and Recovery using RMAN
  • Maintenance of Password file and other parameter files
  • Experience in Writing stored procedures, packages on database
  • Creation and management of Databases, Control files, Redo Log files, Table spaces, Schemas and Rollback segments.
  • Creating users and grant the roles and privileges
  • Configure Database Backup using RMAN
  • Taking cold and Hot Backups regularly
  • Performed portioning on oracle large tables.
  • Enabled achieving and backing up archives on to tape.
  • Performed PL/SQL and SQL queries, debugging and tuning
  • Automated UNIX shell scripts and scheduled batch jobs

Environment: Oracle 10g/11g,,AIX, Linux, OEM, TOAD, Shell Scripting, RMAN and Putty

Confidential

Oracle DBA Consultant

Role and responsibilities:

  • Handling high availability 24/7 database in onshore-offsite model.
  • Cloning the Oracle home and upgrades.
  • Creating health monitoring Unix shell scripts.
  • Scheduling the health scripts using cron tab, mailx.
  • Trouble shooting the user access issues.
  • Taking logical backups using data pump
  • Creating User profiles and roles.
  • Migrating databases from physical disks to ASM related disks.
  • Working closely with the application teams on scheduling the patching windows.
  • Cloning the databases regularly for the reporting databases and stage environments.
  • Tuning the database level performance issues.
  • Taking AWR reports and analyzing them periodically for better performance.
  • Creating Backup schedules and taking periodic backups both offline and online using RMAN
  • Participating in corporate DR drills and ensuring the data protection.
  • Working with Oracle on critical database bug/issues.
  • Creating process documents for the DBA activities and making sure that team adhere to the process outlined.
  • Maintaining stringent response / resolution SLAs.
  • Creating partitions for partitioned tables periodically.
  • Managing materialized views and refreshes
  • Creating DB links.
  • Periodic index management, index rebuilding

Environment: Oracle 10g/11g,,AIX, Linux, OEM, TOAD, Shell Scripting, RMAN and Putty

Confidential

Oracle DBA Consultant

Role: Oracle DBA

Responsibilities:

  • Handling high availability 24/7 database in onshore-offsite model
  • Handling Performance issues.
  • Applying regular quarterly CPU patches and keeping the databases upto date with the Oracle security updates
  • Creating health monitoring Unix shell scripts
  • Scheduling the health scripts using cron tab, mailx.
  • Trouble shooting the user access issues.
  • Creating User profiles, roles.
  • Working with the development team on DBA issues.
  • Application support functions
  • Application issue trouble shooting,
  • Collecting the requirements
  • Analyzing the requirements
  • Testing the updates.

Environment: Oracle 10g/11g,,AIX, Linux, OEM, TOAD, Shell Scripting, RMAN and Putty

Hire Now