We provide IT Staff Augmentation Services!

Oracle Dba Resume

St Louis, MO

SUMMARY:

  • Over 8+years of experience as an Oracle DBA. Expertise in database administration, production support, installation, upgrades, patches, performance tuning, backup and recovery, UNIX shell scripting and documentation.
  • Installation and configuration of Oracle 11g/10g/ 9i/8i in UNIX/LINUX and Windows environment.
  • Experience with working on RedHat Linux, HP UX, AIX, Sun Solaris and Windows environments.
  • Involved in administration of multiple 24/7 Production Oracle 11g/10g/9i/8i databases as well as Development/Test databases.
  • Very hands on in both traditional cold, hot backups and RMAN based incremental backups.
  • Very good experience in Oracle database upgrades including patchset upgrades and applying one-off patches.
  • Database Administration tools like OEM (Oracle Enterprise Manager) and TOAD Suite for Oracle DBAs.
  • Oracle Database capacity planning, space management and storage allocation.
  • Experience in Shell Scripting to automate routing DBA tasks and activities.
  • Worked on Data transferring with export/import utilities and Data pump.
  • Worked with Creating and maintaining of Oracle Data Guard configuration.
  • Performed basic functions like space management, Undo segments management, invalid objects recompilation and creation of primary Database storage structures (Table spaces) and primary objects (Tables, Indexes, Views, materialized Views, Synonyms, Database Links), SQL, PL/SQL Programs (Procedures, Functions, Packages and Triggers).
  • Excellent interpersonal and strong analytical skills with very good focus on customer satisfaction.
  • Great communication skills.

Skills:
Relational Databases: Oracle 11g/10g/9i/8i, MS SQL Server 2005/2003, MySQL 5.0
Languages: SQL, PL/SQL, UNIX Shell Scripts, DOT NET, JavaScript, C, C++, VB
Tools: Oracle Enterprise Manager, Toad 8.0, Visual Studio, Microsoft Office Visio,
Oracle Utilities: RMAN, Export, Import, expdp/impdp, SQL* Loader, DBVerify, DBCA,
DBUA
Disaster Recovery: Physical Standby (Data Guard).
Operating System: UNIX, Sun Solaris, HP-UX, IBM AIX, Red Hat Enterprise Linux, Windows
98/2000/2003.

Education:
B.S in Computer Science and Engineering.

Projects:
Confidential,St Louis, MO November 2009 – Till date
Sr. Oracle DBA

Responsibilities:

  • Responsible to provide 24 x 7 database administration activities
  • Managing multiple production, testing, QA and development Utility database instances.
  • Administering ORACLE Databases 10g, 11g databases.
  • Setup Oracle10g RAC, Oracle 11g RAC, Oracle Standby (Active Data Guard) fro High Availability, Disaster Recovery and Reporting purpose.
  • Upgrade database 9i to 10g, 10g to 11g.
  • Experience in managing databases on high availability environment using Oracle Cluster.
  • Configured Oracle grid control to manage the entire database in single centralized location.
  • Applied database patches using Opatch utility & building Clone Databases for Development and Test teams.
  • Implemented centralized backup (hot) and recovery strategy for all the databases using shell scripts, SQL scripts and cron job.
  • Cloned/Refreshed databases from production database Implemented backup and recovery strategies using RMAN (Incremental Backups)
  • Created shell scripts and scheduled them for monitoring Oracle Databases.
  • Performance tuning and Monitoring using Grid Control database & managing instances using OEM.
  • Working with Development, QA and other teams to support the related issues.
  • Space management, Undo segments management, invalid objects recompilation and creation of primary Database storage structures (Table spaces) and primary objects (Tables, Indexes, Views, materialized Views, Synonyms, Database Links), SQL, PL/SQL Programs (Procedures, Functions, Packages and Triggers).
  • Creating primary database storage structures (tablespaces), altering, and modifying the database structure according to the business requirements.
  • Implemented Oracle RAC with Data Guard implementation for disaster recovery
  • Installation, Configure, setup of 10g RAC, 11g RAC and add new nodes to RAC.
  • Planning and implementing Backup and Recovery procedures (RMAN), scheduling daily backups and performed periodic recovery tests.
  • SQL tuning using SQL Trace and TKPROF, Explain Plan.
  • Tuning init.ora parameters for optimal performance.
  • Configured Oracle streams.
  • Designing and developing packages in the database layer, stored procedures, functions and triggers.
  • Querying V$ dynamic performance tables to figure out bottlenecks in throughput and Scalability.
  • UNIX scripting for automation of statistics collection as well as for other processes.
  • Worked with Very large Databases (VLDB)
  • Writing Shell Scripts to automate various routine jobs & designing the logical and physical database structure.
  • Designing the security and database access strategies & cloning databases and partitioning tables.
  • Creating and refreshing materialized views & performing SQL*loader jobs for data loading.
  • Writing PL/SQL procedures for Extraction Transformation and Loading of data.
  • Performance tuning and Monitoring using Grid Control database.
  • Users and responsibilities Maintenance
  • Working with Development, QA and other teams to support the related issues.

Environment: Oracle 11g RAC, 10g RAC, 9i, Sun Solaris, HP-UX, IBM AIX, RedHat Linux, PL/SQL, SQL Scripts, Shell Programming, TOAD, Data Guard, RMAN, ASM, SQL*Loader, TOAD, Golden Gate

Confidential,Dayton, OH
December 2005 – November 2009
Sr. Oracle DBA

Responsibilities:

  • Responsible to provide 24 x 7 database administrative activities over different database servers.
  • Supported different Databases like Production, Development, Testing, UAT and Training.
  • Responsible for Oracle 10g RAC, 11g installation and configuration.
  • Responsible for upgrade & migration of data from file system based solution to Oracle ASM solution on RHEL5 using ASM Normal Redundancy.
  • Worked with LINUX System Administrators on partitioning of disks and sizing requirements.
  • Upgraded databases from Oracle 9i to 10g, 10g to 11g.
  • Performed Database Cloning to create testing and development instances from production.
  • Distributed the data in different Tablespaces by table partitioning to get the high performance and I/O balancing.
  • Applied latest releases of the RDBMS patches from Oracle to the Production and test instances to resolve few technical challenges & issues using Oracle OPATCH utility
  • Contacted Oracle for Technical Assistance to track the problems in the database and resolved accordingly.
  • Enabled RMAN based compressed backupset option for all backup programs.
  • Converted all manual based cloning methods using RMAN DUPLICATE command
  • Involved in conducting training sessions for fellow DBAs in administering Oracle databases using ASM technology.
  • Monitored and tuned long running jobs by working closely with the application development team and analyzing objects, rebuilding indexes.
  • Performance tuning using SQL TRACE, TKPROF, Explain Plan and provided the ADDM reports per request.

Environment: Oracle 11g, Oracle 10g RAC, 9i, Oracle Enterprise Manager, RedHat Linux, HP-UX, RMAN, ASM, SQL*Loader.

Confidential,Pittsburgh, PA
April 2004 – November 2005
Sr. Oracle DBA

Responsibilities:

  • 24*7 Oracle Production Database Administrations.
  • Involved in Installation, Upgrade from Oracle 9i to Oracle 10g and Configuration of Oracle NET services.
  • Extensive Performance Tuning, Memory Tuning etc.
  • Applied patches including both one-off patches using OPatch as well as patchsets.
  • Refresh/Cloning of database and applications for development and testing purpose.
  • Standby Database setup and configuration.
  • Worked alongside programmers and database developers for contributing to the development processes.
  • Enabled and analyzed trace files including TKPROF analysis and system wide event tracing.
  • Configuration of TNSNAMES.ora, LISTENER.ora for SQL*NET connectivity and resolving connection problems.
  • Involved in decision making for the naming convention of datafiles, redolog files, tablespaces and segments
  • Written shell scripts and automated nightly jobs using cron to schedule the backups, exports and refreshing databases from production.
  • Tuning and balancing I/O by monitoring file system and tablespace I/O statistics.
  • Tuning SGA, I/O Tuning, Identifying database contention and the offending connections.
  • Written and configured RMAN for cloning databases.
  • Proactive monitoring of databases and applying RDBMS patches along with quarterly CPU updates.
  • Monitored the background processes activity including trace files along with setting the appropriate number of DBWR processes along with init.ora configuration for the database.
  • Assisted with the migration of database procedures and code from development to production instances by working extensively with the change management team.

Environment: Oracle 10g, 9i, Red Hat Linux, HP-UX, Sun Solaris, Oracle Enterprise Manager, RMAN, ASM, SQL*Loader.

Hire Now