We provide IT Staff Augmentation Services!

Senior Oracle Resume

Santa Ana, CA

EXPERIENCE SUMMARY

  • Over all 7+ years of IT experience as an Oracle Database Administrator providing 24/7 production and development support of Oracle 11g RAC,10g RAC, 9i, 8i, 7.x.
  • Proficient in Database Administration activities such as installation, database creation, sizing, backup and recovery, performance tuning and capacity planning.
  • Experience in query optimization, cloning, patches, up gradation, migration, troubleshooting, TAR support, space management and UNIX Shell Scripting.
  • Excellent experience as an Oracle DBA in various platforms such as Sun Solaris, HP-UX, AIX, Red Hat Linux, Windows etc.
  • Plan, install, configure and perform upgrades of Oracle software on various platforms.
  • Implementation of high availability solutions with Oracle 10g RAC, Physical and Logical Standby database(Data Guard), Materialized views, VCS, Streams Replication, Golden Gate.
  • Experience in database administration of OLTP and Data Warehousing applications.
  • Experience with Systems Analysis, Design and Data Modeling.
  • Backup and recovery with RMAN.
  • Recovery of Databases (Recovering from Media failure, Recovering Tables dropped accidentally, Recovering data files, Recovering from Block Corruption etc.).
  • Excellence in Performance Tuning using STATSPACK, TKPROF, EXPLAIN PLAN, SQL TRACE, AWR, ADDM.
  • Proactive monitoring, identifying areas that need to be improved in the application and database using AWR, ADDM and OEM Grid Control.
  • Experience with writing PL/SQL Packages, Stored Procedures, Functions and Database Triggers.
  • Proficient in SQL, PL/SQL Programming, Shell Scripting and analyzed Batch programs.
  • Worked on 4 nodes Linux RAC with ASM.
  • Expert experience in Hot and Cold Backup and Recovery, cloning of databases using RMAN, Veritas NetBackup and IBM Tivoli Storage Manager (TSM).
  • Used DataPump (expdp,impdp) to take backup at database level or tablespace level and also to accomplish table level and full database de-fragmentation.
  • Proficient in using various database Utilities like EXPORT/IMPORT, Datapump, TOAD.
  • Experience in Extracting, Transforming and Loading (ETL) data using SQL loader, External Tables and PL/SQL.
  • Experience with oracle ERP and interfacing with Oracle ERP.
  • Automated many common tasks using crontab including Backups, exports and imports, archiving old records and verification of such processes.
  • Worked on OLTP/DSS database systems, implementing and managing Large Oracle databases (VLDB).
  • Expertise on upgrading and patching of CRS, ASM and Oracle RDBMS.
  • Good Knowledge of SQL Server.
  • Worked on different types of storage structures (SAN/NAS).
  • Strong analytical and problem solving skills, a very good team player and also has the ability to work independently when needed and a quick learner of new technologies.
  • Excellent written and verbal communication skills.

TECHNICAL SKILLS

Operating Systems: UNIX (Sun Solaris 8, 9,10/HP-UX 10.x,11.x/IBM AIX 5.1,5.2,5.3,6.1), RHEL 3.x, 4.x,5.x, SLES 9 and Windows NT/2000/2003

Relational Databases: Oracle 8i, Oracle 9i, Oracle 10g RAC, Oracle 11g RAC, SQL Server, TERADATA

Data Modeling Tool: ERWIN, Designer 9i

Tuning Tools: SQL TRACE, TKPROF, EXPLAIN PLAN, STATSPAK, AWR, ADDM

Tools and Utilities: RMAN, Import / Export, DataPump, SQL*Loader, ASM, TOAD

ETL Tools: Informatica 5.1, Data Stage 6.0

Querying/Reporting: PL/SQL, SQL

Languages: SQL, PL/SQL, C, C++, JAVA, VB, UNIX Shell Scripting

Administration Tool: Oracle Enterprise Manager, SQL Navigator, BMC Patrol, Spotlight

Protocols: FTP, SFTP, Ssh, Telnet, TCP/IP

Other: EMC, Veritas NetBackup, IBM TSM, TAM, NetApp

EDUCATION:

Bachelor of Technology in Computer Science.

PROFESSIONAL EXPERIENCE

Confidential Santa Ana, CA Jan 2011 – Present
Senior Oracle DBA

Responsibilities:

  • 24 X 7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues
  • Performed database cloning to setup test and development database.
  • Conducting sizing & capacity planning for Oracle databases.
  • Upgrading production and development databases to Oracle 11g.
  • Installation, Configuration and Administration of Oracle 11g RAC.
  • Applied patches to Oracle Databases and Oracle Applications.
  • Applied Oracle Applications and database patches.
  • Cloned/Refreshed Oracle Databases and Oracle Applications for development and testing.
  • Responsible for optimizing the queries and application tuning.
  • Perform SQL tuning and assist developers with coding PL/SQL.
  • Provided support to Application Database Administrators in designing the database.
  • Installed and Implemented Backup & Recovery procedures.
  • Used RMAN for backup and recovery. Performed backup validations using RMAN.
  • Implement Hot, Cold and Logical backup plans.
  • Involved in taking Backups using Oracle RMAN (Recovery Manager) and TSM (Tivoli Storage Manager). Customization and development of Korn shell scripts.
  • Management of schemas, objects partitioning the tables & indexes.
  • Automation of data load using Korn shell scripting and SQL*Loader.
  • Responsible for setting and managing user accounts, Granting required privileges to users.
  • Defining and Implementation of backup and recovery strategies
  • Perform other regular DBA activities including space management and performance monitoring.
  • Optimization and tuning SQL queries using TRACE FILE, TKPROF, EXPLAIN PLAN.
  • Continuous monitoring of database performance during peak and non-peak loads using STATSPACK.
  • Implemented the replication of data between multiple databases using Streams.
  • Involved in process improvement, Oracle Server Installations / Upgrades/Patches, Space Management, Capacity Planning, Backup & Recovery, Disaster Recovery, Database Performance Tuning, Memory Tuning, Application Tuning, Security Administration, Data Warehousing, Data Guard, Oracle Advanced Replication, Real Application Clusters, Oracle Standby.

Environment: PL/SQL, SQL, SQL*Plus, Oracle 11g RAC, 10g RAC , Sun Solaris Unix, AIX, RHEL, Windows XP, Streams, BART, TOAD, DataPump.

Confidential Sacramento, CA. Sep 09 - Jan 2011
Senior Oracle DBA

Responsibilities:

  • 24x7 production database and applications support.
  • Installation, Configuration and Administration of Oracle 9i, 10g RAC and 11g RAC databases for Testing, Development and Production.
  • Converted single instance to RAC
  • Added nodes to RAC
  • Upgraded Oracle different version from 9.2.0.4 to 10.2.0.4 and 10.2.04 to 11.2.0.2
  • Involved in Capacity Planning and Optimal setting of Storage Parameters.
  • Performed Database administration activities like user and roles administration, schema management and checking alert log of all the databases.
  • Involved in database cloning, tuning, patching and monitoring
  • Performing Backup/Recovery of Oracle databases.
  • Implemented RAC and Standby databases for high availability/ disaster recovery purpose.
  • Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption).
  • Developed stored procedures, packages and database triggers.
  • Proactive analysis of systems by running AWR, ADDM reports and taking necessary measures.
  • Experience in monitoring and tuning system resources associated with the database performance, hit ratios, I/O, lock and latch contention.
  • Create tablespaces, tables and indexes, sizing the tablespaces, allocating default table space for users.
  • Creating and dropping of users, granting and revoking permissions to users/roles as and when required.
  • Experience with Systems Analysis, Design and Data Modeling.
  • Knowledge of writing Automated Scripts in the cron for backups and restoration.
  • Used TKPROF, EXPLAIN PLAN, and STATSPACK to improve the performance.
  • Monitor CPU usage, I/O contention, memory paging and identify the resource and performance bottleneck.
  • Involved in design and implementation of standby databases ( Oracle Dataguard ).
  • Experience in replication using golden gate, materialized views.
  • Replication and Extracting data and applying on production using GoldenGate.
  • Extracting, Transforming and Loading (ETL) data using SQL loader, External Tables and PL/SQL.
  • Writing SQL scripts to monitor Archive log gaps in DR, monitor table space and extent growth.
  • Working with Materialized views with Query Rewrite, Bitmapped Indexes, etc
  • Involved in the migration of databases from Windows to Linux
  • Automation of Startup, Shutdown on all production and development databases.
  • Handling day-to-day activities.

Environment: Oracle 11g RAC, Oracle 10g RAC, 9i, HP-UX, Sun Solaris, RHEL, AIX , RMAN, ASM, SQL*Loader, DataPump, OEM (GridControl), Golden Gate.

Confidential Oaks, PA. Oct 08 – Aug 09
Senior Oracle DBA

Responsibilities:

  • 24x7 production database and applications support.
  • Installation, Configuration and Administration of Oracle 9i, 10g RAC and 11g RAC databases for Testing, Development and Production.
  • Converted single instance to RAC
  • Added nodes to RAC
  • Upgraded Oracle databases from 9i to 10g, 10g to 11g
  • Involved in Database Design with Data Architects.
  • Evaluating database products and third party tools for the Project.
  • Setup of the database environments for the Dev and QA teams.
  • Setup of High Availability of the database for business with RAC.
  • Reorganizing Tables and Indexes for improving performance.
  • Created the database objects based on the requirements for project requirement.
  • Table space analysis, space allocations for tables, rollback segment monitoring and as member of application development team.
  • Implemented complex business rules using database triggers and constraints.
  • Adding, dropping users, creating Roles, and Grants based on the Role of the user.
  • Planned and implemented database Backup and Recovery procedures.
  • Performed backups and recoveries
  • Implemented Hot and Cold Backup and Recovery, cloning of databases using IBM Tivoli Storage Manager (TSM).
  • Testing of Backup’s and Documenting backup strategies.
  • Developed stored procedures, packages and database triggers.
  • Involved in design and implementation of standby databases ( Oracle Data guard ).
  • Participate in disaster recovery exercises using Oracle DataGuard technologies including Fail-over and Switch-over operations.
  • Performed Diagnosis & Tuned database and SQL statements as and when required.
  • Managing Production as well as Development Instances.
  • Identified and provided solutions for poorly written queries.

Environment: Oracle 11g RAC, Oracle 10g RAC, 9i,8i , Sun Solaris, HP-UX, RHEL, RMAN, ASM, SQL*Loader, DataPump, Toad.

Confidential Irving, TX. Feb 07 – Sep 08
Oracle DBA.

Responsibilities:

  • 24 X 7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues.
  • Database sizing &tuning
  • Installation, Configuration and Administration of Oracle 9i, 10g RAC, 11g databases for Testing, Development and Production.
  • Involved in Database migration from Oracle 8i,9i to Oracle 10g, 9i to 11g
  • Setup of High Availability of the database using RAC, Standby, Dataguard
  • Backup and Recovery
  • Database performance monitoring and tuning
  • Created the database objects based on the requirements for project requirement.
  • Created partitions & indexes for better performance.
  • Database Security and Auditing.
  • Optimizing the SQL statements for optimum performance by using TKPROF, EXPLAIN PLAN, and STATSPACK, AWR, ADDM.
  • Scheduled & automated back-end jobs.

Environment: Oracle 11g, 10g RAC, Oracle 9i,8i, RMAN, OEM, SQL Server 2000, AIX, Sun Solaris, Redhat Linux, Windows, TOAD, SAS, Rational Clear Case

Confidential Hyderabad, India Jan 06 – Jan 07
Oracle DBA.

Responsibilities:

  • Production database administration support
  • Installation of Oracle 10g on HP-UX and AIX.
  • Load data into Oracle using SQL *Loader, RMAN backups, Export/Import database objects/schema, Enforce database accuracy and integrity.
  • Monitor the scheduled oracle jobs, manage data feeds, verify the log tables and tune the performance of the database.
  • Provide user account administration, optimizing SQL queries; optimizing developer code, manage table partitions, large data sets and provide manual reports using SQL.
  • Backup and Recovery via RMAN scripts and troubleshooting.
  • Cleanup demographic Data Warehouse tables, develop PL/SQL scripts, monitor data feed and data replication, address/resolve data issues.
  • Handle service requests from the business using Helpdesk Service Management.
  • The work also involves system administrator tasks like creation of users, file systems, volume groups and logical volumes etc.
  • Upgrade of Database from 9i and to 10.2.0.2.
  • Partitioned large table spaces to increase the performance of the database.
  • Converted dictionary based table spaces to locally managed table spaces to eliminate fragmentation, better performance and reduced maintenance.
  • Performed Tuning of various SQL queries to improve the performance of the database.
  • Logical and Physical data modeling.
  • Hard disk and Database space monitoring.
  • Migrated file systems to ASM (Automatic Storage Management).
  • General database administration including the management of instances, redo logs, temp space, rollback/undo segments and schema management.

Environment: Oracle 10g/ 9i, HP-UX, IBM AIX, TOAD, OEM, STATSPACK, TKPROF, AWR, ADDM, Erwin.

Confidential Hyd, India Mar 04 – Nov 05
Oracle DBA

Responsibilities:

  • Installation, Configuration, Upgrade, Patching of Oracle RDBMS and Applications.
  • The work involves overall ORACLE Database Maintenance, Performance Tuning, Backup, Recovery and other Database related activities.
  • The work also involves system administrator tasks like creation of users, file systems, volume groups and logical volumes etc.
  • Installation of 9i, 10g
  • Upgrade of Database from 8i, 9i to 10g
  • Designing the logical and physical database structure.
  • Designing the security and database access strategies.
  • Logical and Physical data modeling.
  • Create table spaces, tables, and users for custom applications.
  • Creating and dropping of users, granting and revoking permissions to users/roles as and when required.
  • REFRESH/CLONING of Database and applications for development, testing
  • Performance Tuning of the database (Memory Allocation Tuning, I/O Tuning, Tuning Contentions)
  • Performance monitoring and tuning using TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ADDM for the Better performance.
  • Taking Backups on scheduled time and monitoring scheduled Backups
  • Performing backups and recoveries using RMAN conventional hot backups.
  • Establish and Document Backup and Recovery strategies and procedures after evaluating various options including RMAN.
  • Partitioning Strategies for very large tables.
  • Implementing Range, List Partitions, Hash Sub Partitions, Creating and refreshing materialized views.
  • Performing SQL*Loader jobs for data loading.
  • Data refresh from production to test and development.
  • Assist Programmers and Developers with Oracle problems.
  • Write Korn shell scripts to monitor and maintain the Oracle database.
  • Write SQL scripts to Monitor Tablespace and Extent Growth.
  • Resolve various application failures due to data entry errors or system errors.
  • Involves identifying problems and implementing corrective actions.
  • Providing Solutions to the Problem Faced by End Users Or Programmers.
  • OS level activities like space monitoring of Mount points.
  • Automation of Startup Shutdown on all Production and Development Database.
  • Daily Health Check of the Database.
  • Diagnose and troubleshoot Database problems and failures.
  • Ensuring proper online and offline backup. Periodical validation/checking of backups taken.

Environment: Oracle 10g/9i/8i/7.3, SQL, RHEL, AIX, Sun Solaris, Shell Scripting, SQL Server

Confidential Hyderabad, INDIA Aug 03 - Mar 04
Jr. Database Administrator

Responsibilities::

  • Installation of Oracle Database and Oracle products.
  • Creating users and maintaining database security.
  • Designing and enforcing standards and naming conventions.
  • Testing of Backup’s and Documenting backup strategies.
  • Implementing Backup/Recovery Strategies.
  • Writing UNIX shell scripts for backup and recovery.
  • Monitored SGA, Shared Memory, Memory Segments, LRUs and Buffers etc.
  • System tuning for better performance.
  • Creating stored procedures, packages and database triggers.
  • Worked with application developers to debug PL/SQL procedure, tune queries and database sizing.
  • Writing SQL Loader control files for data loading.
  • Database tuning, backup and recovery and general day to day running of the system.
  • Start up and shut down databases, to check for locks, monitor and kill user sessions, monitor database performance and other day-to-day tasks.
  • Systems analysis and design.

Environment: Oracle 9i/8i/7.3, HP-UX,Windows

Hire Now