We provide IT Staff Augmentation Services!

Senior Oracle Dba Resume

San Francisco Ca, JuN

SUMMARY
Over 7 years experience as 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 and auditing.

PROFESSIONAL SUMMARY

  • Over 7 years of experience as Oracle Database Administrator with proficiency in Oracle 11g/10g/9i/8i on Linux, Sun Solaris, HP UX, IBM-AIX and Windows.
  • Experienced in cross platform migrations from Windows to Linux, Solaris to Linux, HP-UX to Linux.
  • Expertise in leading the teams for maintenance of 24x7 high-availability applications.
  • Fulfilled DBA daily activities including user management, space management, monitoring etc.
  • Experience in OLTP/DSS database systems, implementing and managing large Oracle databases (VLDB).
  • Experienced in setting up/installation and configuration of release 11g R1 RAC with ASM and Raw Devices and 11g CRS.
  • Hands on experience with Installation, Configuration, Migrations, Oracle Data Guard, Backup and Recovery using RMAN, Disaster Recovery and Patching, upgrading and administering up to 10 Terabytes of Oracle Databases on Oracle 11g/10g/9i.
  • Installed Oracle Clusterware to provide infrastructure for RAC and configured 2 node Oracle 10g RAC with ASM.
  • Excellent knowledge in developing functions, Procedures and Packages.
  • Supported a large number of Development Databases, mainly in tuning the SQL code to improve Performance.
  • Planned and implemented DR & high availability solutions using Oracle 11g Standby Database using Oracle Data Guard, 11g and 10g RAC.
  • Experience in upgrading databases. (10g R2 to 11g, 10g R1 to 10gR2, 9i to 10gR1).
  • Performing Database Cloning in Oracle 9i, 10g and 11g using RMAN.
  • Performed backups using Cold, Hot backups and RMAN and also tested various crash recovery procedures.
  • Experience with Data Modeling, Logical and Physical database design.
  • Excellent work experience in developing applications using Oracle SQL Scripts, PL/SQL, shell programming, and PRO*C optimization.
  • Recovery of Databases (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption etc.).
  • Extensive Performance tuning experience, specializing in instance tuning, Oracle9i and 10g RAC tuning.
  • Proficient in Database Administration activities such as Upgrades, Patches, TAR support, Cloning, Backup and Recovery, Performance Tuning, Capacity Planning, Script development and documentation.
  • Proactive monitoring, identifying areas that need to be improved in the application and database using STATSPACK, EXPLAIN PLAN, SQL TRACE, ORADEBUG, AWR, ADDM, and 10g OEM Grid Monitoring.
  • Experience in Data Warehousing using ETL Tools and Oracle.
  • Sound experience in different phases of a project life cycle including design, architecture, programming, testing, end user support, and preparing customer specifications as a part of software requirements.
  • Experienced in using Data Pump, Flashback Recovery and Recycle Bin.
  • Good knowledge on Oracle streams, data guard physical standby databases, working knowledge on BCV’S, SRDF, and managing of partitions and clustering of tables.
  • Experience in basic and advanced replication using Oracle Streams and experience in using OEM, TOAD, Data Migrations & benchmarking using load-testing tools.
  • Expertise in Replication of Oracle Database using Logical Standby, Streams and Shareplex.
  • Expertise in using Golden Gate for supporting data replication in oracle database environment.
  • Knowledge on Oracle Support processes for technical requests through Metalink and other Support Procedures.
  • Experience with VERITAS NETBACKUP, HP Data Protector & IBM TSM.
  • Exposure to MS SQL Server 2005 Installation, Configuration, Maintenance, Backups & Restores, Security Management, DTS import/export, Performance Tuning.
  • Hands on experience in SQL, PL/SQL, Partitioning, Data modeling, OLAP, Logical and Physical Database Design.
  • Strong knowledge and experience of managing Oracle 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 automating many common tasks using Crontab including Backups, exports and imports, archiving old records and verification of such processes
  • Involved in doing Data Modeling, data mart, designing data warehousing boundaries and parameters, Data Transformation, PL/SQL.
  • Experience in oracle 11g partitioning, SQL plan management and SQL access advisor.
  • Experience in Migration of Database from 9i to 10g, 10g to 11g.
  • Scheduling jobs through Oracle Job Scheduler, Cronjobs (UNIX), Autosys jobs, Scheduled Tasks (Windows).
  • Managed the migrations of SQL Server 2000 databases to SQL Server 2005.
  • On call 24x7 Production Support Worked beyond regular hours.

KNOWLEDGE BASE


Hardware

Pentium, PC AT-486, IBM, Dell and Apple Mac.

Operating System

MS-DOS, MS Windows 95/98/2000/ME/NT/XP/Vista, HP-UX 10.x, 11.x, Sun Solaris 2.5, 2.6, 8, 9, 10, AIX 5.1, 5.2, Red Hat Linux 2.1, 3.x, 4.x, 5.x.

Programming Languages

C/C++, Java (J2EE), SQL, PL/SQL, Delphi, Unix Shell Scripting.

RDBMS

Oracle 8i, Oracle 9i, Oracle 10g, Oracle 11g RAC, MS SQL Server 2000 & 2005, MS Access.

Tools & Utilities

SSIS, RMAN, Data Pump, Dataguard, OEM,SQL*Loader, Golden Gate, RMAN, Grid Control, Erwin, TOAD.

Tuning Tools

TKPROF, EXPLAIN PLAN, STATSPACK, SQL*TRACE, AWR, ADDM

Other

EMC, NetApp, VMware, NetApp, Shareplex, VERITAS Net Backup, TSM, HP omni back up, IBM Tivoli.

HANDS ON EXPERIENCE


Confidential,San Francisco, CA Jun 10 – Till Date

Senior Oracle DBA

Responsibilities:

  • DBA support on 24X7 environment, Supporting Central Administration Service Desk for Database related issue and work on Ticket to resolve the identified issues.
  • Conducting sizing & capacity planning for oracle databases.
  • Involved in database installations/upgrades/patches, space management, capacity planning, backup & recovery, disaster recovery, database performance tuning, memory tuning, application tuning, security administration, Data Guard, real application clusters.
  • Automation of startup shutdown on all production and development databases.
  • Involved in the installation, configuration and support of Oracle 11g R2 databases.
  • Upgrade and Migration of Databases from 10g R2 to 11g R1 and applying patches as per requirement.
  • Actively participated in installing of 11g RAC on Linux environment with two nodes and ASM as storage.
  • Configured DATA GUARD to provide high availability by implementing physical stand-by database and worked with various Oracle 11g features: Streams, 11g Grid Control and Automatic Storage Management (ASM).
  • Responsible for installing and configuring Golden Gate 9.5 on Oracle Servers
  • Responsible for upgrading Golden Gate 9.5 to Golden Gate 10.0.
  • Experience in using GoldenGate in moving large moving of transactional data with minimal impact to online systems and performing GoldenGate on process of extract and replication of single instance as well as RAC Databases.
  • Highly experienced in using STATSPACK, AWR to check health of database & hardware.
  • Good Intensive Knowledge in using operating system command line utilities like SAR, TOP, MPSTAT, VMSTAT
  • Deep Knowledge in using tools such as TKPROF; EXPLAIN PLAN, ORADEBUG and TRACE FILE to tune.
  • Performed database Cloning using hot backup and RMAN to setup test and development database.
  • Monitored database log files, data block corruption, segment fragmentation, performance issues, security threats, and contention issues.
  • Installing ASM environment and migrating database from NON-ASM to ASM.
  • Applied critical patch updates (CPU) released by oracle quarterly.
  • Developed scripts to proactively monitor the databases and alert the DBA on events such as running out of extents, disk space, password expiry etc.
  • Responsible for daily monitoring of Oracle instances and maintenance of databases using Oracle Enterprise Manager (OEM), Oracle GRID (OGC) and SQL*Plus Command line scripts.
  • Created database users and managed database security to ensure for the continued accuracy, reliability and integrity of the data systems.
  • Creating and managing tablespaces and rebuilding of indexes.
  • Responsible for handling some critical errors like ORA-600, ORA-7445 by creating SR’s with Oracle Tech Support
  • Responsible for performing system enhancements, including SGA, memory tuning and SQL Tuning, hardware and software modifications.
  • Performance tuning for optimized results using tools like EXPLAIN PLAN, SQL TRACE, TKPROF, STATSPACK
  • Taking periodic Backup of the Database and the software using RMAN and VERITAS NETBACKUP.
  • Migration of Database from RHEL 4 to Sun Solaris and applying patches whenever required.

Environment: Oracle 10g, 11g, RAC, RMAN, SQL Server 2000 & 2005, Red Hat Linux, Solaris 9, 10, Database Grid Control, Windows 2003, HP-UX, SSIS, Dataguard, TOAD, VERITAS NetBackup

Confidential,Memphis, TN Jun 08 – may 10

Senior Oracle DBA

Responsibilities:

  • Provided 24 X 7 on call support for all the production and development databases.
  • Implemented 10g/11g RAC consisting of 2 to 6 nodes.
  • Implemented 10g/11g Data guard with one physical database.
  • Partitioned large tables to increase the performance.
  • Daily Health Check of the Database.
  • Designed, configured and maintained backup and recovery policies including RMAN backups.
  • Extensively used AWR, ADDM for database performance statistics.
  • SQL query tuning using tools like Explain Plan, SQL*Trace, TKPROF and Statspack.
  • OEM / GRID (OGC) installation and configuration for monitoring and performance tuning.
  • Proactive performance monitoring, and capacity planning for future database and server growth.
  • Performed Range Partitioning as a cause to improve the performance of the database.
  • Performed Cross platform migration using transportable table spaces and RMAN.
  • Planned and performed the database migration from SQL Server to Oracle.
  • Handled standard database administrative tasks, such as: proactive performance tuning and monitoring, trouble-shooting, back-up and recovery, installations and configurations on an as needed basis.
  • Responsible for some data modeling using tools like Erwin.
  • Experience in Installation of Golden Gate on Oracle Servers.
  • Expertise in Oracle Golden Gate configuration and troubleshooting GG issues
  • Transformed logical database designs into physical databases; Build and implement test, quality assurance, and production databases and environments.
  • Checking database performance on a regular interval, which includes checking various log files.
  • Addition of users, objects etc as and when required and granting proper privileges for Database access.
  • Taking care of database by checking the size the database and addition of table spaces, data files
  • Actively involved in strategic Backup, Restore and Recovery using RMAN for complete recoverability.
  • Performed Import and Export using Oracle Data pump utilities EXPDP and IMPDP.
  • Administrated all database objects, including tables, clusters, indexes, views, packages and procedures.
  • Install, configure and maintenance of Advanced Queues via JMS
  • Upgradation and Migration of Database from 9i to 10g, 10g to 11g and applying patches when required
  • Experiences in Wait Interface, Materialized Views, ASM, ADDL and SQl Tunning

Environment: Oracle 9i, 10g, RAC, Grid Control, SQL Loader, OEM, SQL Server 2000 & 2005, Linux, UNIX, Windows 2003, HP-UX, PL/SQL, Discoverer, SAN, RMAN, Sun Fire 4800, Fire 880

Confidential,Milwaukee, WI Jan 07 – May 08

Oracle DBA

Responsibilities:

  • Responsible for providing 24x7 supports for production and Development databases.
  • Installed and upgraded the database server and application tools
  • Cloning the databases for TEST, DEVP and PROD and regularly refreshing the databases.
  • Installation, Configuration and Maintenance of 10g RAC.
  • Created maintenance plans for user and system databases
  • Performance tuning for optimized results using tools like Explain Plan, SQL*Trace, TKPROF and Statspack.
  • Automation of startup shutdown on all production and development databases.
  • Setup of Standby database for faster disaster recovery and data guard setup for high availability.
  • Migration of Database from 9i to 10g
  • Installed SQL server 2005 on stand alone and clustered servers and applied service packs and hot fixes
  • Created SSIS packages to transfer the data from development to testing and production
  • Creating and managing tablespaces and rebuilding of indexes.
  • Scripts for startup and shutdown, cold backups, health check of databases, to check oracle errors in alert log file and send mails.
  • Planned and implemented for backup and recovery of database.
  • Created a Dblink between two Oracle servers.
  • Developed scripts to proactively monitor the databases and alert the DBA on events such as running out of extents, disk space and actively involved in Shell Scripting for various CRON jobs to be run.
  • Managed Database security and Auditing

Environment: Oracle 9i, 10g, RAC, SQL, Pl/SQL, SQL Loader, OEM, Linux, Solaris 10.

Confidential,India Aug 05 – Dec 06

Oracle DBA

Responsibilities:

  • Provided support for the Development database.
  • Database upgrades from 8i to 9i and 9i to 10g.
  • Highly skilled in Unix Shell Scripting using VI and AWK in environment such as UNIX.
  • Cross platform migration using export import from windows to Linux
  • Cloning databases and partitioning tables.
  • Monitored database space usage and system sizing.
  • Analyzed oracle database performance.
  • Troubleshoot and supported data system.
  • Used to Interact with Business Analysts to understand the business requirements and also worked with Java developers to develop procedures, package and functions.
  • Implemented standby database and database replication to realize database high availability.
  • Worked on several V$views and dba_* to monitor the database and solve different kinds of problems.
  • Solving problems related to extent allocation.
  • Participated in Disaster Recovery Drills, documented database and application validation steps
  • Monitoring Growth of tables and undertaking necessary re-organization of database as and when required.
  • Monitoring Scheduled jobs of the daily activities for the performance of all the databases.
  • Applied High priority, security patches downloaded from Metalink.
  • Creating custom concurrent requests to perform database maintenance.
  • Developing SQL scripts to monitor tablespace and extent growth.

Environment: Oracle 9i, Oracle 10g Sun Solaris, AIX 5L, SQL Server 2000, Windows NT/2000, PERL

EDUCATIONAL PROFILE

    • Bachelors in Engineering, Computer Science.

Hire Now