We provide IT Staff Augmentation Services!

Oracle Database Administrator Resume

Atlanta, GA

Professional Summary

  • 7+ years of professional IT experience in Administration, Systems Design Development, Maintenance, Testing, Integration, documentation in high-availability environments.
  • Expert in Architecture of Oracle Databases 11g RAC, 10g RAC, 9i, 8i with objectives of saving costs and time.
  • Excellent experience in Installing, Configuring and maintaining Oracle 8.1.x/9.x/10g/11g on Operating Systems such as Sun Solaris, IBM AIX, HP-UX, SCO-Unix, Red Hat Linux, Oracle Enterprise Linux and Windows
  • Strong experience in supporting production, development, unit test, system test, Integration test, certification test databases under UNIX/LINUX.
  • Experience in managing large mission critical databases high availability and disaster recovery environments in 24*7 using Oracle RAC, Standby databases (Active Data Guard).
  • Experience in Upgrading databases (8i to 9i, 9i to 10g, 10g to 11g, 9i to 11g)
  • Involved in doing Data Modeling, Data Mart, Data Warehousing, Data Transformation.
  • Proficient in Database Administration activities such as Upgrades, Patches, Backup and Recovery, Performance Tuning, capacity planning, script development, and documentation.
  • Expert in Administration, Productivity and Modeling Tools including OEM, Data pump, Exp/Imp, VERITAS, OLAP/Partition/RAC, Erwin, TOAD, SQL,Home-made Scripts.
  • Expert in Database Health Maintenance using Stats pack, TKPROF, RACDIAG, RDA, Explain Plan ,Enterprise Manager, Self-developed Scripts & methodology, Procedures.
  • Expertise in cloning databases using manual methods and using RMAN Duplicate DB to create Test, Development databases.
  • Experience in Database Space Management, Memory Tuning and Application Tuning.
  • Expertise in troubleshooting and performance monitoring and tuning
  • Experience in Backup and Recovery activities using RMAN and conventional backups.
  • 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.
  • Expert in configuration of 11gRAC, 10gRAC, Standby Databases (Active Data Guard) for High Availability, Disaster Recovery and reporting.
  • Extensive experience with proactive monitoring, Capacity planning, benchmarking, partitioning.
  • Experience in SQL (DDL, DML, and DCL), and PL/SQL and experience in writing stored procedures, packages, functions, and triggers.
  • Expertise in Replication of Oracle Databases using Streams and Golden Gate.
  • Expertise in data archive and purge methodologies using korn scripting and pearl scripting.
  • Expert in using Bitmap, B-Tree Indexes, Composite indexes, partitioning and histograms.
  • Team player, maintained client/customer relationships by providing timely, quality and services, understanding of client/customer needs, opportunities and satisfaction criteria.
  • Proficient in interpersonal relations, leadership skills, Project Management, Communication, Partner Teamwork, and Organization

Technical Skills

Databases : Oracle 11g RAC, Oracle 10g RAC, Oracle 9i, Oracle 8i, Oracle 7.3
Operating System : HP UX 10.x, 11.x SunOS 10, 9, Linux RHEL 4.x, 5.x, AIX5L Windows 9x/NT/2000, UNIX, DOS
Programming : PL/SQL, Pro*C, SQL*Plus, C, C++, Shell Scripting, HTML
Tools : RMAN, ASM, Golden Gate, Streams, DataPump, TOAD, SQL*Loader, AWR, ADDM, TKPROF, STATSPACK, Putty.

Education

Bachelor of Technology from Jawaharlal Nehru Technological University, Hyderabad, India.

Professional Experience

Confidential, Atlanta, GA. Apr 10 - Present
Oracle Database Administrator

Responsibilities

  • 24x7 Production database and applications support.
  • Administering ORACLE Databases 9i, 10g, 11g and also Oracle10g RAC/11g RAC.
  • Applied patching for upgrading databasefrom 9i to 10g,10g to 11g and also for other updates.
  • Experience in managing databases on high availability environment (Oracle RAC & Active DataGuard).
  • Configured Oracle grid control to manage the entire database in single centralized location.
  • Applied database patches using Opatch utility, building Clone instances for Development and Test teams.
  • Managing multiple production, testing, QA and development databases.
  • Cloned/Refreshed databases from production database to test and development.
  • Implemented backup and recovery strategies using export/import, RMAN Incremental backups), Traditional hot, cold backups.
  • Created shell scripts and scheduled them for monitoring Oracle Databases.
  • Working with Development, QA and other teams to support the related issues.
  • Creating primary database storage structures (tablespaces), altering, and modifying the database structure according to the company’s requirement as necessary, from information givenbased on business requirements.
  • Migrated databases from HP-UX to LINUX.
  • Setup Standby databases including Active Data Guard for disaster recovery and reporting.
  • Implemented Oracle RAC with Data Guard implementation for disaster recovery.
  • 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, STATSPACK, AWR, ADDM.
  • Tuning init.ora parameters for optimal performance and scalability.
  • Running AWR reports to figure out the bottleneck and analyze using ADDM.
  • Database Maintenance and clearing of locks, cleaning of database logs, Rebuilding indexes, Tablespace monitoring, database objects monitoring.
  • Designing and developing PL/SQL packages in the database layer, stored procedures, packages, functions and triggers.
  • UNIX scripting for automation backups, monitoring, statistics collection as well as for other routine tasks.
  • GoldenGate installation, configuration for replication.
  • 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 with External Tables.
  • Applied database patches using Opatch utility & worked on conversion from single node to Multi Node RAC.
  • Performance tuning and Monitoring using OEM/Grid Control.
  • Problem resolution repository is built in custom DBA ticketing tool.
  • Working with Development, QA and other teams to resolve the issues.

Environment: Sun Solaris, HP UX, AIX, Linux RHEL, Oracle 10gRAC/11g RAC, Data Guard, Datapump, RMAN, ASM, GoldenGate , PL/SQL, SQL Scripts, Shell Programming, TOAD, Putty.

Confidential, Omaha, NE Oct 08 - Apr 10
Oracle Database Administrator

Responsibilities

  • Managed several production, test and development instances (24x7 Support).
  • Installed, configured and managed Oracle 10g RAC/ 11g RAC, Standby databases.
  • Administering ORACLE Databases 11g, 10g, and 9i.
  • Applications Patch management: Patch application and impact analysis, and trouble shooting.
  • Involved in implementing Dashboard-based Monitoring solution by developing shell scripts and SQL scripts.
  • Performance Tuning Databases using SQL Trace, TKPROF, Explain Plan, STATSPACK, AWR, ADDM.
  • Migrating Oracle databases from Windows to Linux.
  • Monitoring growth of tables and undertaking necessary re-organization of database objects when required and generating trace files for problem resolution.
  • Responsible for backup/recovery using and performing backups and recoveries.
  • Responsible for setting-up and managing Standby databases.
  • User Maintenance (Creation, modification and deletions) and Custom code migrations.
  • Proactive database monitoring using Oracle 10g grid control.
  • Worked on user documentation like Instance strategy, Instance management, Problem manager, Setup document and Change management docs.
  • Problem resolution repository created to reduce issue resolution timings.
  • Creating primary database storage structures (tablespaces), altering, and modifying the database structure according to the company’s requirement as necessary, from information given by the application developers.
  • Creating and managing users, roles and profiles, auditing and monitoring user access.
  • Planning and implementing Backup strategy for the databases, Scripting backups.
  • Planning and implementing Backup and Recovery procedures (Hot, Cold Backups and RMAN), scheduling daily backups and performed periodic recovery tests.
  • Involved in a project, which analyzes and applies quarterly Security patches (CPU&PSU).
  • Maintenance and troubleshooting of oracle network files like listener, tnsnames.ora
  • Allocated system storage and planned for future storage requirement for the database.
  • Created primary database storage structure for developers to develop and test the Application.
  • Data loading using Oracle SQL Loader, developing SQL Loader scripts to load global data, and fine tuned SQL Loader performance using Direct-load mechanism.
  • Estimating the space requirements for database growth for next 12 months and availability of hardware to support the processes.
  • Developing, Implementing and administering database policies and procedures.

Environment: HP UX, AIX, Linux RHEL 4, Oracle 11g RAC, 10gRAC, Oracle 9i, PL/SQL, SQL Scripts, Shell Programming, TOAD, Data Guard, RMAN, ASM, GoldenGate, Putty.

Confidential, Las Vegas, NV. Aug 07 – Oct 08
Oracle DBA

Responsibilities:

  • Configured and managed Large database using latest features of Oracle 9i/10g like Undo-Table space, Locally Managed Table space and Sorting Parameters.
  • 24x7 Oracle Production Database Administration including Oracle 10g RAC.
  • Wrote proactive scripts monitoring like monitoring the disk usage and the memory usage of the server and monitoring tablespaces and mailing alerts when required.
  • Involved in Logical backups, RMAN backups, Hot backups and Cold backups.
  • Created and configured Data guard for physical Standby database on a fresh server starting from Oracle Installation in No-Data-Loss mode.
  • Developer Environment Setup, Support, Cloning and Refreshes.
  • Installed Oracle 9i and 10g, RAC database on HP-UX 11.0, Redhat4 and Sun Solaris.
  • Installed RAC on Oracle 10g and worked on ASM feature of Oracle.
  • Extensive use of Crontab in UNIX environment for scheduling routine tasks like Backups, exports and imports, archiving old records and verification of such processes.
  • Used DBMS scheduler to schedule the jobs and DBMS stats to gather the statistics along with analyze command.
  • Installation of Oracle RDBMS server software and version upgrades.
  • Maintenance and troubleshooting of oracle network files like listener, tnsnames.ora
  • Applied patches.
  • Created Materialized views to make query response faster and have written shell scripts to refresh them.
  • Created and managed tablespaces by adding/deleting/ resizing data files.
  • Finest granularity approach to Oracle implementation and de-fragmentation.
  • Creating DATAGUARD with logical- standby configuration with hot backup and testing it for fail-over and switch over in different modes.
  • Extensively Installed Oracle10g and Upgraded the database from Oracle 10gR1 to 10gR2 on Linux platform.
  • Monitored growth of data and purged old records through automated scripts.
  • Database activities include allocation and maintenance of Rollback Segments, Automatic Undo Management, table spaces, data files, redo log files, mirroring of redo log files across multiple disks.

Environment: Oracle 9i/10g, RAC, Sun Solaris 5.9, AIX 5.3,Redhat LINUX, Windows Server 2003, OEM, SQL*Loader, SQL*PLUS, TOAD, RMAN.

Confidential, India Mar 06 - Jul 07
Oracle Database Administrator

Responsibilities

  • Responsible for installing, upgrading and configuring the Oracle server.
  • Supported different Oracle 10g, 9i Databases of Production, Testing, Staging and Training.
  • Involved in logical and physical data modeling and schema design using Erwin tool.
  • Created database manually using Oracle Database Configuration Assistant.
  • Developed PL/SQL packages, stored procedures, functions, Cursors, triggers.
  • Creating databases, tablespaces, objects, roles and privileges.
  • Partitioned large tables to increase the performance and to improve I/O access.
  • Responsible for Data load on different databases using SQL*Loader.
  • Export and import of database objects using EXP and IMP Utilities.
  • Enforce Database Security by Managing user privileges and efficient resource management by assigning profiles to users.
  • Using database level triggers code for database consistency, integrity and security.
  • Involved in the database design, installation, creation of various instances, and creation of tables, granting roles to users and maintain the security according to application.
  • Performed daily maintenance tasks like space management, rectified locking problems, managed quotas etc. Created users and roles, and maintained system security.
  • Efficient in using the Oracle Tools like SQL* Plus, SQL* Loader, TKPROF, STATSPACK, SQL*Net, IMPORT/EXPORT, DataPump and RMAN.
  • Managing table spaces, user profiles, indexes, storage parameters.
  • Develop table structures, PL*SQL stored procedures and database triggers to implement.
  • Responsible to provide 24 x 7 database administrative activities over different database servers.

Environment: Sun Solaris, HP UX, AIX, Linux RHEL, 10gRAC, Oracle 9i, Oracle 8i, PL/SQL, SQL Scripts, Shell Programming, Oracle Enterprise Manager, TOAD, Data Guard, RMAN

Confidential, Hyderabad, INDIA Jul 04 - Feb 06
Oracle DBA/Developer

Responsibilities:

  • Configured and installed Oracle 9i on UNIX environment.
  • Upgraded database from Oracle 7.3 to 8i, 8i to 9i
  • Actively participated in team meetings with Business team for changes in design of the database.
  • Worked on database setup and monitored the database growth on daily basis.
  • Involved in the logical and physical design of the database tables.
  • Sizing database objects for effective space management and optimal performance.
  • Actively participated in Database and application developers troubleshooting.
  • Developed scripts for hot, cold and logical backup.
  • Performed Backup and Recovery using RMAN and user managed techniques.
  • Modified and established backup and recovery strategies and procedures.
  • Administrated User accounts by creating users, roles and privilege and managing those using grants and profiles.
  • Created tables, views and other schema objects with appropriate table space sizes.
  • Database maintenance, upgrades, and patches release.
  • Worked on database performance monitoring using OEM.
  • Carried out Physical and Logical database design and database reorganization.
  • Written SQL, PL/SQL functions, procedures, packages and triggers.
  • Written shell scripts for backup and cloning automation, custom monitoring
  • Created database links for accessing data from remote databases.
  • Used EXPORT/IMPORT utility for performing logical backup for table level and full databases.
  • Used the Crontab in UNIX and Scheduler in Windows for Automatic Tasks (Analyzing tables, loading into Tables, Imp/Exp).

Environment: Oracle 9i, 8i, 7.3, SQL*Loader, SQL*Plus, OEM, ASM, PL/SQL, RMAN, LINUX, HP-UX, Sun Solaris, HP-UX,SQL Server 2005,My SQL, Erwin, Windows 2000.

Hire Now