We provide IT Staff Augmentation Services!

Oracle Database Administrator Resume

SUMMARY:

  • Over 7 Years experience as Oracle Database Administrator. Oracle 11g RAC/10g RAC/9i/8i databases running on different environments such as Sun Solaris, HP-UX, AIX, Red Hat Linux, and Windows.
  • Proficient in Oracle Database Administration activities such as Upgrades, Migrations, Patches, Cloning, Backup & Recovery, Performance Tuning, capacity planning, shell scripting, and documentation.
  • Extensive knowledge on database administration for Oracle 8i, 9i, 10g & 11g with experience within very large scale database environment and mission critical OLTP and OLAP systems.
  • Excellent experience in migrating the Databases.
  • Fulfilled DBA daily activities including user management (creating users, synonyms, privileges, roles, quotas, table, index, sequence etc.), space management, and monitoring
  • Experience in OLTP/DSS database systems, implementing and managing large Oracle databases (VLDB).
  • Hands On Experience in installing, configuring and managing Oracle 11g R2 RAC, Oracle 10g RAC
  • Experienced at using Oracle Enterprise Manager/Grid Control (OEM/GRID CONTROL)
  • Performance monitoring and tuning with EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE, 10046 TRACE, AWR, ADDM.
  • Successfully implemented physical Standby database using Oracle Data Guard feature for High availability configuration.
  • Experience in regular DBA activities such as Upgrades, Patches, TAR support, Cloning, Backups and Recovery Manager, Performance Tuning, Capacity Planning and documentation.
  • Experience in Flash-Back Recovery, Data Pump, AWR, ASM, ASH and ADDM, Recycle Bin and Grid Monitoring.
  • Migrated databases from Windows to Linux, Sun Solaris to AIX
  • Troubleshoot Database performance issues using Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM).
  • Knowledge on Oracle Support processes for technical requests through Meta link.
  • Planning and scheduling for the backup of database information using UNIX shell script and Crontab jobs.
  • Experienced in using Oracle's Transportable Table space (TTS) feature allows users to quickly move a user Table space across Oracle databases.
  • Strong knowledge and experience of managing Oracle8i, 9i,10g and 11g RAC environments using the OEM Grid Control tools.
  • Data transferring with Export, Import, Data Pump and SQL* Loader utilities.
  • Experience in using packages like DBMS_JOBS, DBMS_SCHEDULER to schedule tasks and used DBMS_STATS to gather the statistics.
  • Database backup concepts and options such as user-managed backup, RMAN-managed backup with or without catalog, operating system backup, cold and hot backup, full backup, incremental and cumulative backup.
  • Skilled in database upgrades 8i to 9i, 9i to 10g R2 and 10g to 11g.
  • Refresh/Cloning of Database and applications for development and testing purpose.
  • On call 24x7 Production Support Worked beyond regular hours.
  • Dealing with database security and auditing.
  • Excellent communication, interpersonal and strong analytical skills, Documentation & Problem-solving skills with customer service oriented attitude. A very good team player, self motivated, dedicated in any work environment.

TECHNICAL SKILLS:

Operating Systems : HP-UX 10.x, 11.x, Sun Solaris 8, 9, 10, AIX 5.1, 5.2,5.3,6.1,7.1 Red Hat Linux 4.x, 5.x,6.x, MS Windows 98/2000/ME/NT/XP/Vista
Programming Languages: SQL, PL/SQL, Unix Shell Scripting.
RDBMS : Oracle 8i/9i/10g RAC/11g RAC
Software’s, Applications and Tools: DBCA, DBUA, Oracle Data Guard, OEM (GC), RMAN, ASM, Clusterware, SQL*PLUS, SQL*LOADER, EXP, IMP, Data Pump (expdp, impdp), TOAD, DB Artisan, SQL TRACE, EXPLAIN PLAN, TKPROF, STATSPACK, AWR and ADDM, SQL Developer, Golden Gate
Web Related and Other Tools : HTML, XML, JSP, HTTP, TCP/IP, FTP, SFTP, SCP, EMC Storage, Metalink, MS Visio

EDUCATION:

Bachelor of Engineering

Experience:

Confidential, Irving, TX December 2010 - Till Date
Sr. Oracle DBA

Responsibilities:

  • 24x7 on-call production database support
  • Installation and Configurations of Oracle 11g, 10g.
  • Installed Oracle 11g RAC, 10g RAC, Standby Databases for high availability and disaster recovery/reporting purpose.
  • Installation, configuration, maintenance and tuning of Oracle 11g and 10g databases.
  • Upgraded Oracle Database from 9i to 10g, 10g to 11g.
  • Applied CPU patches
  • Migration of the database from Sun Solaris to IBM AIX, Windows to Linux.
  • Expertise in recovering the database. Performed complete and incomplete database recovery.
  • Configured and maintained Grid Control Repository and Deployed OMS Agents on different database servers.
  • Automated the nightly RMAN backups
  • Writing and modifying UNIX shell scripts, Perl scripts to manage Oracle environments and for Backend Oracle Processes.
  • PL/SQL Programming.
  • Developed PL/SQL scripts for Extraction, Transporting & Transforming (ETL) data from Production databases to Data Warehouse Databases.
  • Using the 11g Grid control, OEM for the database tasks like adding the data file, resizing the data file, code compilation, User/Role creation and maintenance etc.
  • Experience in taking backups with RMAN in both Catalog/ No catalog modes.
  • SQL tuning and Database performance tuning has been done based on reports generated by SQL Trace, TKPROF, STATSPACK, Explain Plan, AWR, ADDM and monitor the database performance on daily basis.
  • Planning Backup/Recovery Strategy, Planning and scheduling Backups, taking Logical Backups (with Export/Import Data pump utilities).
  • RMAN Incremental backups
  • Logical and Physical Database Design
  • Capacity Planning and bench marking
  • Partitioning of the tables for better performance and manageability
  • Creating & Managing Database Structures, Storage Allocations, Table/Index segments, Rollback segments, Constraints, Database Access, Roles and Privileges.
  • Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics for the same.
  • Performed policies on data confidentiality, integrity, availability, and auditability, Based on Access Controls for Access to Data at the database level.
  • Performed SQL and PL/SQL tuning, oracle contention and monitored production database using automatic workload repository (AWR), automatic database diagnostic monitor (ADDM) and automatic session history.
  • Cloning databases using scripts as well as RMAN.
  • Experienced in Database Security User Management, Privileges, Roles, Auditing, Profiling, Authentication.
  • Worked closely with the Oracle developers for the better performance in Applications in writing the Packages, Triggers, Mat Views and Indexes on the tables.
  • Experienced in documentation, provided documentation for database design, analysis, modifications, creating schemas etc.
  • Enabled the audit on all the dev/test databases, analyzed and reported the audit records about the suspicious activity in the database.
  • Monitoring the database storage and day-to-day activities.
  • Table partitioning for better performance.
  • Golden Gate installation and configuration.
  • Replication using Golden Gate.
  • Performed all aspects of database administration including installs, upgrades, object sizing, object creation, backup/recovery, patches, monitoring, export/imports and SQL loader.

Environment: Oracle 11g RAC, Oracle 10g RAC, RedHat Linux, IBM AIX, Sun Solaris, HP-UX, Windows, Shell Scripts, ASM, RMAN, OEM/Grid Control, TOAD,SQL Developer, SQL*Loader, ERWIN, Data Pump

Confidential, Temple Terrace, FL October 2009 – November 2010
Oracle DBA

Responsibilities:

  • 24x7 on-call production database support
  • Installation and Configurations of Oracle 11g, 10g.
  • Installed Oracle 11g RAC, 10g RAC, Standby Databases for high availability and disaster recovery/reporting purpose.
  • Implemented Data Guard for Disaster recovery
  • Setup and configure Standby database for high availability by using Data Guard.
  • Migrated & upgraded databases from Oracle 10g to oracle 11g
  • Installed and implemented Golden gate to replicate data between databases.
  • Replication using Oracle Streams.
  • Documented instructions for migrating & upgrading databases.
  • Refreshed schemas from Production environment to Dev/Test environment using exp/imp and expdp/impdp utilities.
  • Wrote various shell scripts to automate tasks.
  • Creating PL/SQL procedures for Extraction, Transformation and Loading of data
  • Created schema (tables, Indexes, views, sequences, synonyms, packages).
  • Setup database auditing, granted privileges to users through system/object roles.
  • Implement and maintain database security.
  • Created db link for inserting large tables directly without taking export.
  • Online index rebuilds
  • Created PL/SQL Procedures, Functions, Triggers.
  • Taking Hot and cold backups.
  • Creating and managing partitioned tables and indexes.
  • Monitor and tune database performance using STATSPACK, AWR, ADDM
  • Increased performance of sql queries by creating materialized views and by enabling query re-write.

Environment: Oracle 11g RAC, Oracle 10g RAC, HP-UX, RedHat Linux, Sun Solaris, Windows, Shell Scripts, ASM, RMAN, OEM/Grid Control, TOAD,SQL Developer, SQL*Loader, ERWIN, Data Pump

Confidential, Pittsburgh, PA June 2008 – October 2009
Oracle DBA

Responsibilities:

  • 24x7 on-call production database support
  • Installation and Configurations of 9i, 10g databases.
  • Installed Oracle 10g RAC, Standby Databases for high availability and disaster recovery/reporting purpose.
  • Organizing Oracle Database operations, installation, creation, configuration of Databases, laying out database tables and database schema design, startup and shutdown of Databases.
  • Load data into Oracle using SQL *Loader, RMAN backups, Export/Import database objects/schema, Enforce database accuracy and integrity.
  • Creating users and roles for database and give the privileges.
  • Performance monitoring and tuning using Automatic Workload Repository (AWR) & Automatic Database Diagnostic Monitoring (ADDM)
  • Automated the Replication process using Materialized Views for reporting databases.
  • Using the ADDM to analyze performance problem and with help of AWR reports for individual SQL statements. Analyzing recent session activity with an ASH report.
  • Responding immediately to any critical conditions, and proactively to any developing conditions, including: locking, corruption, disk spaces and Performance issues.
  • Cloning of production database to the test environment using Recovery Manager (RMAN).
  • Created Standby databases for Disaster Recovery, using Data Guard.
  • Load data using SQL*Loader
  • Backup and Recovery
  • Created database objects like tables, views, indexes, partitions.
  • Develop, document and enforce database standards and procedures.
  • Setting Oracle Streams for replication between two databases.

Environment: Oracle 10g RAC, Oracle 9i, Sun Solaris, RedHat Linux, IBM AIX, HP-UX, Windows, Shell Scripts, ASM, RMAN, OEM/Grid Control, TOAD,SQL Developer, SQL*Loader, Data Pump

Confidential, Dallas, TX October 2007 – May 2008
Oracle DBA

Responsibilities:

  • 24x7 on-call production database support
  • Installation and Configurations of 9i, 10g databases.
  • Installed Oracle 10g RAC, Standby Databases for high availability and disaster recovery/reporting purpose.
  • Performed backup and recovery activities.
  • Daily database administration tasks including backup and recovery using RMAN, Import/Export.
  • Designed the database schema and created any necessary database objects.
  • Applied patches, upgraded databases
  • Worked on all phases of the project lifecycle including mapping data requirements, data definitions and construction of logical data models.
  • Performance Tuning of Applications/Databases using various Oracle tools like SQL Trace, TKPROF, Explain Plan, AWR and ADDM.
  • Tuned memory structures such as the database buffer cache, shared pool and library cache.
  • Assist application developers to meet their day to day requirements related to performance.

Environment: Oracle 10g RAC, Oracle 9i, IBM AIX, Windows, RedHat Linux, Shell Scripts, ASM, RMAN, OEM/Grid Control, TOAD,SQL Developer, SQL*Loader, Data Pump

Confidential, Hyderabad June 2005 – September 2007
Oracle DBA

Responsibilities:

  • Responsible for maintenance of production.
  • Created tables, views, materialized views
  • Database administration tasks included performing regular Hot & Cold Backups, Job Scheduling.
  • Managing Database Structure, Storage Allocation, Table/Index segments
  • Cloned databases from PRODUCTION to create TEST, DEVELOPMENT and UAT
  • Configured and managed OEM to stabilized oracle database into healthy environment.
  • Monitoring Growth of tables and undertaking necessary re-organization of database as and when required.
  • Trouble shooting performance issues using Explain Plan and TKPROF.
  • Involved in numerous Unix Korn Shell Scripting pertaining to the activities of the DBA
  • Maintenance & modification of Shell Scripts.
  • Implemented Oracle's Advanced Features such as Partition table, Partition Index, Function Based Indexes and Loaded bulk data with SQL*Loader.
  • Develop, document and enforce database standards and procedures.
  • Generated scripts for daily maintenance activity like analyzing the tables/indexes, and monitoring their growth.
  • Troubleshooting and fixing database listener issues.
  • Worked in a 24/7 supporting environment with ON-CALL rotation

Environment: Oracle 10g, Oracle 9i, Oracle 8i, RedHat Linux, Sun Solaris, Windows, Shell Scripts, RMAN, OEM/Grid Control, SQL*Loader, Data Pump

Hire Now