SUMMARY

• 6+ years of experience in Oracle Database Administration on a variety of UNIX (HP - UX, RHEL, Solaris, IBM-AIX) and Windows Server 2003 platforms with Oracle databases 7.3, 8i, 9i, 10g, 11g, Oracle Application Server 9i Installation, Configuration, Migration, Sizing and Space management, Backup and Recovery, Performance tuning and troubleshooting.
• Expertise in Oracle database administration, installation, configuration, upgrades, migration, performance tuning, backup and recovery, cloning, space management, patching, and auditing.
• Excellent experience in Installation and configuration of 7.3, 8i, 9i, 10g & 11g databases on HP-UX, Solaris, AIX and Windows Server environments.
• Installation and Configuration of Oracle 10g & 11g Real Application Clusters (RAC) on different nodes with Automatic Storage Management (ASM) and configuring TAF.
• Experience with 10G grid control for administration, monitoring and tuning of the databases.
• Experience in Implementation of different backup strategies using hot, cold & RMAN using UNIX shell scripts.
• Experience in cloning and recovery of databases using RMAN and automating logical and physical backups, data refreshes using the shell scripts with cron utility.
• Extensively worked on RMAN, media management, backup sets, lists and reports, channel allocation, restoring files, media recovery, recovery catalog and integrity checks.
• Used Oracle database 10g feature, flashback database to setup training databases by reverting all the changes done periodically.
• Expert in tuning the databases manually and also using automatic database diagnostic monitor (ADDM) and using automatic workload repository (AWR), SQL Tuning advisor, SQL Access advisor
• Extensive performance tuning experience, specializing in operating system tuning, SQL Tuning, database/instance tuning and designing databases and supported databases up to 3TB in size.
• Experience in managing of schemas, objects and partitioning the tables, indexes and in creating and optimizing indexes for high-performance applications.
• Experience in SQL, PL/SQL programming, data modeling with ERWin, Logical and Physical Database Design, procedures, functions, packages and triggers.
• Knowledge of oracle streams, logical standby and physical standby supported by dataguard.
• Expertise in tuning applications, shared pool, I/O distribution, rollback segments, buffer cache, redo mechanisms and utlbstat/utlestat.
• Expert in capacity planning, space management, storage allocation
• Experience in applying Oracle Critical Patch Updates (CPU) and/or Patch Set Updates (PSU).
• Experience as on-call 24x7 production DBA and application/development DBA and working with Oracle support.
• Experience in all phases of SDLC like analysis, design, code, unit test, system test, and implementation, Integration testing and User acceptance testing.
• Presented knowledge transfer and training sessions to the client and delivered associated documentation, instruction manuals and setup documents for the database environment.
• Troubleshooting, analysis, design, code, unit test, system test, implementation with excellent interpersonal, communication and problem solving skills.

TECHNICAL SKILLS

Databases: Oracle 7.3, 8i, 9i, 10g, 11g, RAC & Hardware clusters, MS-Access, SQL Server 2005

IDE: TOAD 9.7.2.5/11, PL/SQL Developer, Eclipse, JDeveloper, SQL Developer, Benthic Golden

Tools: and Utilities: SQL * Loader, SQL * Plus, RMAN, Lab 128, Oracle Enterprise Manager, expdp/impdp, exp/imp, Developer 2000, Autosys, WinSCP, Core FTP, CA Service Desk Manger, Quest Foglight, iSQLPlus, Oracle Warehouse Builder

Reporting Tools: Oracle Reports 6i/10g, Discoverer 9i, 10g, XML Publisher 5.6.2, Cognos 8

Programming /Scripting: SQL, PL/SQL, shell scripting (ksh), Bash Scripting, C/C++, JIL (Job Information Language), Windows batch programming

Data Modeling: ERWin, TOAD Data Modeler, SQL Developer Data Modeler

Operating platforms: HP-Unix 10.x, 11.x, Sun Solaris 9, 10, VM Ware ESX, AIX 5.1, 5.2, RHEL 4.x, 5.x and Windows 2000, XP/Vista, Windows Server 2003, 2008

Miscellaneous: Microsoft Office Suite, Visio, TFS (Team Foundation Server), VSS, PVCS, BMC Remedy 7

PROFESSIONAL EXPERIENCE

Oracle DBA

Confidential, Chicago, IL

Environment: Oracle Database 7.3, 8i, 9i, 10g, 11g, Oracle Application Server 9iASr2, 10g, Oracle E-Business Suite 10.7.0, Discoverer Administrative/Desktop Edition 9.0.4, Discoverer Plus, HP-UX 10.20/11.23, RHEL 5, BMC Remedy User 7, Windows 2000/2003/2008, OEM (Oracle Enterprise Manager), TOAD 9.0.1, 11 SQL * Plus, SQL * Loader, export/import, Data Pump, Putty, TSM, FileZilla 3.3, SQL Developer

Responsibilities:

• Instance tuning & database tuning of the 3TB datawarehouse environment for optimum reporting performance and reduction in ETL processing times.
• Partitioned very large tables using range & list partitioning, introduced parallel query and tuned sql queries using explain plan, tkprof, 10046 trace and optimizer hints.
• Supported two-node 10g RAC environment and configured TAF, created and manage disks and disk groups using ASM.
• Developed scripts to monitor database growth and generated capacity plans to estimate immediate and future storage requirements for databases.
• Maintenance of the disaster recovery environment and monitoring stand by database status and resolving issues with applying archive logs.
• Created tables, indexes, users with external authentication, constraints, partitions, views, database triggers, database links, and materialized views, set up users with resource limits and profiles and role based security.
• Used statspack and AWR on Oracle 9i, 10g and 11g databases to collect performance data and generated reports to diagnose instance wide performance problems, wait event analysis and supported application tuning by identifying high load SQL statements.
• Used datapump, traditional export/import to refresh the QA and development environments from production. Used Oracle Enterprise Manager (OEM) for day-to-day database activities and to schedule database jobs..
• Partitioned very large datawarehouse tables using range, hash methods to improve query response times and manageability, created local and global indexes, used exchange partitions to make updates to the tables in datawarehouses.
• Developed shell scripts to automate data load into the databases from flatfiles using SQL*Loader
• Supported the migration of data from existing Oracle datawarehouse to SAP by creating views with transformation logic.
• Developed and implemented backup strategy integrating RMAN with TSM Tivoli Data Protection for Oracle.
• Cold and hotbackups - daily incremental backups of production databases, cloning Dev & QA databases with data from production environment and compressed exports using unix pipes.
• Used Oracle Management Server (OMS), Oracle Intelligent Agents & Grid control for monitoring and tuned the databases to ensure optimum performance and taking appropriate action.
• Managed multiple production instances running Oracle 10g and installation, configurations amd maintenance of Windows 2003 server HA cluster.
• Developed custom packages for sending email notification to users using UTL SMTP and procedures to generate alerts on low tablespace and shell scripts to monitor standby database status, listener status and recycling the log and trace files.
• Developed custom packages to dump datawarehouse table data to flatfiles in csv format using UTL FILE and DBMS SQL packages.
• Developed ERD diagrams for the datawarehouses and databases, created EULs, folders, items in Discoverer.
• Administration of Oracle Application Server 9i, Discoverer desktop edition and Discoverer plus used in the reporting environment.
• Used ASH (Active Session History) reports to identify top SQL for tuning, configured alerts, baseline metrics for comparison of performance through OEM.
• Worked as on-call dba and coordinated with offshore development resources.

Oracle DBA

Confidential, Camp Hill, PA

Environment: Oracle 10.2.0.1/10.2.0.4, HP-UX 11.31 (HP Integrity RX8640), TOAD 9.7.2, SQL Developer, SQL * Plus, ERWin 7, Data Pump, Team Foundation Server (TFS), Core FTP, Xming, Putty, Autosys r 11.1, LAB 128, Putty, Core FTP

Responsibilities:

• Installed oracle database software, created and maintained multiple databases on different host machines and also multiple database instances on the same host.
• Used Oracle Enterprise Manager (OEM) for day-to-day database activities, SQL Tuning Advisor and SQL Access Advisor to analyze top queries and improve performance by creating indexes.
• Partitioned tables using range, hash, list partitioning methods to age off data and improve query performance.
• Configured multiple listeners on different ports on the same host to support multiple production instances.
• Enabled flashback to recover from user errors and configured the production databases to archive log mode with archive log multiplexing.
• Developed shell scripts and scheduled using cron for automating nightly compressed export using unix pipes from production database and import into lower environments.
• Used DBMS SPACE package to estimate current usage and space requirements for capacity planning.
• Used RMAN with catalog to facilitate hot backups of the production instances, established and documented backup and recovery strategies and procedures and validating backups.
• Upgraded Oracle database 10.2.0.1 to release 10.2.0.4.
• Used Oracle 10g feature AWR (automated workload repository) snapshots and generated reports to monitor performance statistics, instance tuning and resolving bottlenecks during the load testing phase.
• Developed triggers to maintain history data for regular transaction tables and lookup tables.
• Created tables, global temporary tables, views, synonyms, sequences, database links, index organized tables, check constraints, contexts, referential integrity constraints, indexes, bit-map indexes, function based indexes, roles, CLOB and XML type columns.
• Developed SQL Loader control file to load data from flat files into staging tables, developed unix shell scripts to unload data from database tables to csv files using PL/SQL procedures.
• Installed, configured and maintained CA Autosys (job scheduling) software and setup client/remote agents, and used Workload Command Centre (WCC), JIL (job information language) to schedule jobs, setup downstream dependencies.
• Cloning the production databases to testing and development databases, restored the training databases periodically to old state using flashback database to support the training team.
• Created external tables to monitor the contents of alert.log file.
• Created users with custom profiles with resource limits for querying the production databases.
• Tuned SQL queries and long running reports to decrease execution times by using explain plan, tkprof, autotrace, optimizer hints and SQL Trace.
• Installed oracle client software and ODAC (Oracle Data Access Components ) on multiple application servers, commodity servers.
• Migrated database changes and packages to higher environments as a part of the release process.
• Developed detailed instruction manuals for setup, backup and recovery, data dictionary, logical and physical data models using ERWin, power point presentations and knowledge transfer sessions to the client.
• Developed shell scripts for checking listener status, connectivity, cpu usage, free space on the production databases and send out alerts by email notification.
• Developed shell scripts and scheduled using crontab for periodic cold backups and transfer of archive log files to backup server at a remote location
• Developed utility packages for gathering statistics, truncating tables, closing database links by enforcing security through roles, utility functions and procedures, PL/SQL scripts for creating day-zero data and security matrix for the application users, used dbms obfuscation package to hash, encrypt/decrypt passwords for the security module, used dbms scheduler to schedule gather statistics jobs.
• Used RMAN for backing up production databases
• Involved in SGA tuning, resolving Help Desk Tickets, Documenting problem resolution, Root Cause Analysis, Creating Data Definition Language for database objects for promotion to production with the release

Oracle DBA

Confidential, Washington, DC

Environment: Oracle 9i, 10g, HP-UX 11.23 (IA64), Red Hat Enterprise Linux 5, TOAD 9.2, SQL developer, SQL*Plus, SQL*Loader, ERWin, Import/Export, Visual Source Safe (VSS), Win SCP, Hammerora, EditPlus

Responsibilities:

• Design, installation, configuration and maintenance of Oracle 10g RAC & non-rac databases with ASM
• Implemented database security by managing users with roles and assigning privileges.
• Developed shell scripts for generating alerts on ORA errors by monitoring the alert.log file.
• Developed shell scripts to automate data refresh from production to lower environments using expdp/impdp.
• Involved in operating system tuning, optimizing database performance, query tuning using Explain Plan, TKPROF and Oracle Enterprise Manager (OEM)
• Developed shell scripts for automatic logical and physical backups of the databases and sending email notifications.
• Assisted and provided business users with queries and data in the form of spreadsheets and flat files.
• Created and documented database maintenance plans on updating statistics, reorganizing indexes, disk optimization by managing data files and tablespaces.
• Created dbms scheduler jobs for gathering statistics after the batch processing window.
• Used the table partitioning and compression features for large tables.
• Developed procedures to purge obsolete data and reclaim space, analyzed long-running queries to avoid full tablescans and created indexes as required.
• Made tuning recommendations to developers related to PL/SQL, assisting them on expensive queries.
• Generated solutions aligned with business and IT strategies and complying with the organization's architectural standards.
• Allocation of system storage and planning for future database storage requirements.
• Built proactive monitoring scripts to monitor outage conditions and notify the team.
• Performed database tuning using Oracle Enterprise Manager.
• Created and maintained various database-related documents such as manuals and data dictionary spreadsheets.
• Upgraded the databases to the latest patch sets on server side and client side.
• Work on user requests for various tasks like contention issues such as deadlocks.
• Developed triggers to monitor the databases for unusual activities over the database links
• Used Low Archive Log Space event triggered RMAN backup job that would clean out the directory
• Storage Management Managing Space, Tablespaces, Segments and Extents, Rollback Segments & Data Dictionary.
• Created SQL tuning sets for long running batch jobs via Enterprise Manager, Created database maintenance plans, including updating statistics, re-indexing, structure modifications, capacity plans, and index analysis.
• Performed Hot and Cold backups of production databases and configured listener timeout failover.
• Design and creation of logical and physical data models using ERWin data modeler.
• Writing scripts for Import and export procedure, setting up new environments, backup and recovery, Import and export procedure.

Oracle DBA

Confidential, North Canton, OH

Environment: Oracle Database 10.2.0.1, 9i,,8i, Sun Solaris 10, Red Hat Enterprise Linux 4, TOAD, Erwin, Citrix, Oracle Enterprise Manager, SQL Server 2000, RMAN, SQL*Plus, PL/SQL, SQL*Loader, Quest Foglight

Responsibilities:

• Installation, creation and maintenance of Oracle 10g databases.
• Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical I/O and Memory Usage.
• Performance Tuning i.e. Tuning SGA, shared pool, I/O distribution, rollback segments, buffer cache, redo mechanisms.
• Reverse engineering and forward engineering using Erwin, Data Modeling, Database Design and Creation DBCA.
• Working closely with developers to design tables and created primary database storage structures.
• Refreshed the development and testing environments with production data.
• Used transportable tablespaces for database migrations across mixed operating system platforms.
• Made performance improvements to the database by building partitioned tables, Index Organized Tables, Materialized Views and Bitmap Indexes.
• Used DBMS SPACE package to track database object growth and get estimates for future storage needs.
• Performance tuning of SQL queries by using Autotrace, explain plan, analytic functions, indexing and use of optimizer hints.
• Created Users, Roles, Profiles and assigned roles to users and granted privileges and appropriate permissions.
• Devised and Implemented backup strategies using hot, cold, and exports based on the business requirements.
• Worked on recovering tables and databases using Oracle 10g feature Flashback.
• Installed and configured Oracle 10g database on a test server using Oracle standard procedures and OFA, for load/performance testing and future production implementation.
• Cloned schemas, objects and data onto new server using exports from 9i database and imported into 10g using Oracle exp/imp.
• Trouble shooting and performance tuning of the databases at all levels like SQL, PL/SQL procedures, functions and packages, tables, indexes, memory and the underlying operating system memory and swapping.
• Developed UNIX shell scripts to perform regular maintenance and automate day-to-day activities.

Oracle DBA

Confidential, Pittsburgh, PA

Environment: Oracle 8i, 9i, IBM-AIX 5.3, Red Hat Enterprise Linux, Oracle Enterprise Manager (OEM), SQL, PL/SQL, TOAD, RMAN, STATSPACK, DB Artisan 8.1.2, SQL* Loader, SQL*Plus, Windows Server 2003.

Responsibilities:

• Installation and creation of 9i and 10g databases for Development, Testing, Production including configuration, backup & performance tuning.
• Data refresh and cloning from production database to development and testing environments.
• Assisted developers with setting coding development standards and naming conventions to be followed.
• Conducting sizing and capacity planning for Oracle databases.
• Involved in 24x7 supports forboth production and development databases.
• Created logical and physical data models using ERWin.
• Designing the security and database access strategies.
• Scheduled periodic backups and monitoring and testing the backups.
• Performing hot and cold backups using RMAN.
• Establish and document backup and recovery strategies and procedures after evaluating various options includingRMAN.
• Partitioning very large tables, Implementing Range, List Partitions, Hash Partitions.
• Creating and refreshing materialized views, Management of schemas, objects partitioning the tables & indexes.
• Performing and scheduling scripts for SQL Loader jobs for daily data loading.
• Database monitoring, troubleshooting and resolving the service desk tickets.
• Responsible for setting and managing user accounts, Granting required privileges to users and maintain security through proper roles and privileges.
• Performance tuning and optimization of SQL queries using AUTOTRACE, TKPROF, EXPLAINPLAN.
• Continuous monitoring of database performance during peak and non-peak loads using STATSPACK.
• Tuning heavy data loads during batch job processing. Monitoring and performance tuning.
• Performing all daily Maintenance tasks and Interacting with Oracle Customer service to resolve ORA 600 errors.

Oracle DBA

Confidential

Environment: Oracle 8i, Sun Solaris 8, Windows 2000/2003, Oracle Enterprise Manager, SQL, PL/SQL, SQL*Loader, SQL TOAD, exp/imp

Responsibilities:

• Install, upgrade and maintain multiple Oracle databases on Solaris.
• Database monitoring and performance tuning using OEM (Oracle Enterprise Manager) and STATSPACK.
• Application Tuning by tuning queries, identifying problematic code, creation of indexes, re-writing queries using an optimized path.
• Creation of users, roles, tables, triggers, views, indexes, partitions, referential integrity and check constraints, database links and gathering necessary statistics.
• Implementing Database Security, Management of role-based security, SQL tuning using StatsPack reports, SQL Trace, Autotrace utilities.
• Created data model diagrams using ErWin
• Performing day-to-day database administration tasks like tablespace usage, checking alert.log, trace files, monitoring disk usage, Table/index analyze jobs, database backups.
• Analysis and management of Oracle problems/bugs using service requests with Metalink Oracle support.
• Write and modify existing UNIX shell scripts to manage the Oracle database environment.
• Security User Management, Privileges, Roles, Auditing, Profiling and Authentication.
• Creating logical Backup Scripts and Standardization, Performed Database Installations and upgrades.
• Involved in user creation and user access control, design and creation of database schemas and management.
• Used Triggers to maintain history for delete and update.
• Used DBMS JOB package for scheduling gather statistics and table refresh jobs.
• Involved in query optimization and using rule based optimizers and cost based optimizers.
• Developed control files and used SQL* Loader for loading bulk data in flat files into the staging tables.
• Written, tested and implemented various UNIX Shell, PL/SQL and SQL scripts to monitor the pulse of the database and system.