SUMMARY

• Over 8+ years of experience in Oracle Database Administration encompassing Installation, Configuration, Patch Installation, Migration, Upgrades, Backup and Recovery, Cloning, Replication, Database Security, Memory Management, Data Modeling, Performance Monitoring and Tuning, auditing, RAC, Data Guard, Grid Control, Oracle Streams, Oracle Spatial, production support and golden gate.
• Installation and administration of Oracle 11g/10g/9i on OEL, RHEL, Windows, Unix and Sun Solaris in OLTP environment.
• Extensive knowledge on database administration for Oracle 9i, 10g, 11g, with experience within very large scale database environment and mission critical large OLTP and OLAP systems ranging from 40gb to 2TB.
• Performed Migration and Upgrade of 30+ databases to 11g and 10g
• Upgradation of databases applying patches, patch sets and critical patch updates.
• Installation and configuration of Oracle Server 11g RAC with ASM & OCFS2 file systems on multi node systems, 11g, 10g and 9i in different operating systems according to OFA for OLTP and Data Warehouse(OLAP) environment on Very Large Databases(VLDB).
• Experience on oracle 11g/ASM/RAC and upgradation of standalone databases to 11g RAC environment.
• Configuration of Automatic Storage Management (ASM)
• Developed database monitoring/health check alert scripts for database uptime/downtime status, and sizing issues using grid control (OEM) and extensively used Oracle Enterprise Manager to do the daily tasks regarding the performance, maintenance.
• Configuration and Management of Data Guard on RHEL, OEL.
• Extensive experience with Database Cloning and Refreshing pre - prod/dev databases with prod/pre-prod databases.
• Extensive experience in installation and implementing OEM and TOAD and setup of Oracle Grid Control.
• Experience in implementation of enterprise databases on enterprise Storage Solutions using Storage area Networks (SAN) /Network Attached Storage (NAS).
• Experience on Data Replication using Snapshot, Materialized views, import/export and Oracle Streams.
• Regular database synchronization for test database environments through automation.
• Installation and configuration of RMAN with and without Recovery Catalog on Oracle 11g/10g/9i.
• Design and implementation of Backup and Recovery strategies (both cold and hot backups) and performing periodical backup, restoration and recovery using RMAN(full and incremental)
• Testing and implementing different physical and logical backup and recovery methods including point in time, media recovery, full/partial, datapump export/import.
• Implementation of Flashback Technology, Log Miner, Automatic Database Diagnostic Manager (ADDM).
• Experience of Oracle GoldenGate installation, configuration and troubleshooting Golden Gate issues.
• Extensive experience using SQL* Loader, External Tables and Oracle Application Express for data loading.
• Detecting and diagnosing production system performance problem by analyzing STATSPACK reports, Oracle trace and log files, AWR, ADDM, analyzing SQL statements, measuring system and database activity, Querying Oracle dynamic performance views.
• Monitoring and Optimization of database performance through database tuning, system tuning and application tuning.
• Experience in SQL Tuning, Optimization, rule based optimization, cost based optimization and Hints
• Delivering Oracle Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE.
• Monitoring and optimizing the performance of the database through Database Tuning - Tuning Applications, Tuning Instance, and Tuning Disk Usage.
• Proficient in INDEX REBUILDING and INDEX TUNING
• Knowledge on Oracle Advanced Security Options such as Data Encryption to ensure data privacy.
• Experience working with Database Resource Management
• Proficient in writing PL/SQL Procedures, Functions and Triggers.
• Experience using ERwin as a Data Modeling tool.
• Designing the ETL processes
• 24*7 on-call production database support and maintenance including remote database support
• Possess technical ability and self-initiative to learn and implement new concepts in short duration.
• Ability to work in a team as well as to take individual responsibility.

TECHNICAL SKILLS

Database: Oracle 11g, Oracle 10g, Oracle 9i, Oracle 8i, SQL server 2005, MS SQL Server 7/2000 Oracle Products OEM, Oracle FileSafe(OFS), SQL*Loader

Operating System: Solaris 10/9/8, Sun Sparc, RHEL 5.X/4.X, OEL, IBM AIX 5.0/5.1, HP UX 11i, AIX4.3, Windows 2000/2003 server

Technologies: Log Miner, VERITAS Net Backup, ERWin Data Modeller

Languages: SQL, PL/SQL, C, C++, XML, UNIX Shell Scripting, Perl, HTML

Tools: /UtilitiesToad, Win SCP, Putty, Spot-light for Oracle, Space manager, TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ADDM, ASH

Others: VERITAS Volume manager, Veritas Cluster Manager (Java Console) v3.5, VERITAS Quick I/O

PROFESSIONAL EXPERIENCE

Confidential, Sunrise, FL

Sr. Oracle DBA

Responsibilities:

• Installed, configured, and maintained Oracle 10g on RHEL 4 and 11g on RHEL 5 and also Upgraded from Oracle 10g to 11g.
• Performed day to day administrative tasks by analyzing the database like checking for failed processors, verifying the query for particular issues and validating disk space.
• Using list partitions for large tables and bitmap indexes for the OLAP databases.
• Responsible for setup and implementation of Two node RAC on Oracle 11g.
• Created a Clone Database using RMAN on remote Server and used SRVCTL commands for Real Application Cluster (RAC) Databases.
• Upgrading the Oracle 10g to the latest Oracle 11g Release 2 by applying patches. Used both patch sets and interim patches.
• Performed Database Refresh from Production to UAT/QA/SIT and Development databases.
• Implemented Times Ten optimizer to design to generate the best possible plan within reasonable time and memory constraints.
• Proactively monitoring the database's health and taking preventive or corrective actions.
• Implemented ongoing system migrations and maintenance with no downtime in Golden gate.
• Replicated data using Oracle GoldenGate and import/export.
• Experience in creating dump files in oracle Golden gate
• Configured Oracle Dataguard for Oracle Disaster Recovery.
• Implemented Dataguard on Production Database.
• Planning, Installation and Configuration of Oracle 10g on HP-UX and Windows 2003 Server.
• Looking into day-to-day activities of Production database, Monitoring its growth and performance.
• Monitoring of Oracle Instances, Users, Tables, Memory Structures, Rollback Segments, Redo Logs, Archive Logs and Alerts.
• Responsible for the generation of the presentations and graphs by utilizing the data from the clients.
• Responsible for the analysis, designing and coding of the database.
• Handled the client problems and troubleshoot and fixed the bugs.
• Creating and maintaining Databases manually as well as using DBCA.
• Creation of users and granting the users required privileges and roles.
• Configuration of Listener and Net Service names using NETCA and NETMGR.
• Managing backup strategy for all production databases (at least triple redundancy).
• Provide at least double redundancy for all development databases.
• Configured and implemented Oracle Streams (Advanced Replication) for high availability.
• Performed Schema as well as Table level Replication using Oracle Streams.
• Implemented down streams capture at the destination database using Oracle Streams.
• Database backup & Recovery for non archive and archive database with RMAN commands.
• Used Data pump for exporting and importing tables, schemas and table spaces.
• Archive weekly all production database exports to Tapes, stored both onsite and offsite.
• Develop and enforce both database and OS-level security policies for data protection.
• Administered all databases in the areas of maintenance, tuning, performance, and troubleshooting.
• Managed more than 4 databases using OEM Grid Control.
• Undo table space management.
• I used Times Ten for cost-based query optimizer to choose the best query plan based on factors such as the ordering of tables and choice of access method.
• Post installation process, kernel upgrade, applying support packs and add-ons.
• Monitoring Day-Day Backups, Log's & recovering them as per the requirement. Utilized LOG MINER Technology & applied Application Database Transactions on other Databases.
• Worked extensively on Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics.
• Worked extensively on monitoring grid control database, configuration of error notifications, installing listeners, and adding them to the grid control.
• Efficient in using the Oracle Tools like OEM, SQL* Plus, SQL* Loader, TKPROF, LOGMINER, AWR, ADDM, STATSPACK, Data Pump, FLASHBACK and RMAN.
• SQL tuning and Database tuning has been done based on reports generated by Run time SQL execution plans, AWR Reports, ASH reports, Explain Plans and monitor the database performance on daily basis.
• Developed Scripts for transferring data from production server to testing/development servers.
• Cloning databases with RMAN and also with user managed.
• Managing databases on multiple servers.
• Disk Space Monitoring.
• Developed table structures, PL*SQL stored procedures and database triggers to implement business rules.
• Managing and providing 24X7 supports for various versions of databases.
• Performed on-call technical support to minimize the impact of system disruptions.

Environment: Oracle 10.1.0.4/10.2.0.4/11 g R1 and R2, RHEL 4 and 5, Oracle Enterprise Manager Grid Control, HP-UX, Windows 2003 server, OEM Database control, PL/SQL, Shell Scripting, Stored Procedures, TOAD, ASM, Golden Gate, Data Guard and Oracle Tools.

Confidential, Saint Louis, MO

Oracle DBA

Responsibilities:

• Installed, configured, upgraded and maintained the Oracle databases and related software, managed users and maintained security, populated databases of Oracle 10g on RHEL.
• Implemented Data Guard for disaster recovery.
• Configuration and maintenance of a Two node RAC on Oracle 10g
• Developed backup and recovery strategies, batch processing, performance monitoring, log maintenance and automating functions wherever possible.
• Configuration of ASM with normal and external redundancy.
• Restoration of databases from Critical failures.
• Responsible for scheduling backups.
• 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.
• Responsible for logical and physical database design, implementation, transforming logical data models into physical databases, and defining strategies for database implementation, high performance, replication & failover.
• Taking Incremental backup using RMAN.
• Creation and maintenance of databases.
• Creation of tables, tablespaces, users, views and related objects.
• Configured and implemented Oracle Streams (Advanced Replication) for high availability.
• Performed Schema as well as Table level Replication using Oracle Streams.
• Implemented down streams capture at the destination database using Oracle Streams.
• Performed analysis and diagnosis of database performance statistics.
• Implemented procedures to detect the poor database performance, collecting required information, root cause analysis, successfully tuned and improved the performance of the database.
• Tuning performance using Advisors, AWR, ADDM, SQL tuning etc.
• Performed Online and Offline backups with RMAN as well as User managed.
• Schema and Table level replication using Oracle Streams.
• Tuning SQL queries when the performance is poor.
• Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical IO and Memory Usage.
• Upgraded databases from 10.0.1.0 to 10.0.4.0 using Patch sets.
• Responsible for planning, testing and implementing different backup and recovery strategies.
• Alert monitoring and Ticketing.
• Implemented downstream capture at the destination database using Oracle Streams.
• Implementing backup procedures using Cron Tab.
• Performed activities such as Query Optimization, Database Consistency Monitoring.
• Used Shell Scripting to backup database.
• Physical and logical data modeling using Erwin tool.
• Responsible for granting required privileges and roles to users.
• Duplicating production databases.
• Renaming and resizing databases.
• Implementation of logical backups using Log Miner.
• Scheduling Oracle Jobs in the database.
• Implemented Point in time recovery using RMAN.
• Configuration of Multiple Listeners in the server and Net Service Names for the target databases using NETCA and NETMGR.
• Responsible for Space management and resolving dead lock issues.
• Supported development teams by providing SQL statement tuning and optimizing ETL procedures and removing load and query performance bottlenecks by using tools EXPLAIN PLAN, STATSPACK, and TKPROF
• Managing table spaces, user profiles, indexes, storage parameters.
• Involved in developing and implementing PL/SQL stored procedures and triggers.
• Responsible to provide 24 x 7 database administrative activities over different database servers.
• Provided all kinds of DBA support to development teams as well as production support to various applications.

Environment: Oracle 10.2.0.3/11.1.0.6/.7 , Linux, Solaris 10, Window 2003, Oracle Enterprise Manager Database Control, RDBMS, TOAD, PL/SQL, Shell Scripting, Stored Procedures, ASM, Data guard.

Confidential, Indianapolis, IN

Oracle DBA

Responsibilities:

• Oracle Database software installation, Instance creations, schema creations.
• Configuration and Maintenance of Physical Standby databases.
• Supported different Databases like Production, Testing, Staging and Training.
• Online and Offline Database backup and Recovery.
• Upgrading databases from 9i to 10g. Creating databases manually or with DBCA.
• Installed and configured Oracle 10g database on a test server using Oracle standard procedures and OFA, for performance testing and future 10g production implementation
• Supported different Databases like Production, Development, Testing, and Data warehouse.
• Upgraded Databases from Oracle 9i to Oracle 10g on Solaris.
• Troubleshoot databases, provide reports on the database health check, follow up and recommendations.
• Operational Responsibilities - Database refreshes/ backs, security, documenting standards and procedures, data migration, data clean-up, copy data archiving, etc.
• Automated monitoring the databases, performance parameters, backup and recovery activities by running Cron jobs and customized various Unix Shell Scripts in sending Email for ORA- errors, reports for Quick Morning Check (QMC), automate routine DBA tasks of taking backups, exports, space usage monitoring, move Archive Logs to different mount point when Archive Destination is full and Resync RMAN catalog.
• Worked with a team for installation and maintenance of ORACLE 10g RAC, ASM database for high availability.
• Well conversed using the CRSCTL and SRVCTL tools for maintaining database, ASM and node applications
• Monitored and tuned long running jobs by working closely with the application development team and analyzing objects, created or rebuilt indexes, query tuning using SQL TRACE, TKPROF, Explain Plan, TOAD.
• Performed troubleshooting of database using AWR and ADDM reports.
• Planned, tested and implemented backup strategy using RMAN, Oracle Utilities (Export/Import) EXPDP and OS methods.
• Performed Database replication from production to test/development environment Using RMAN, Data pump utilities and manually
• Responsible for network configuration and involved in a Client - Server environment using TNSNames, LISTENER, Net Configuration Assistant and other configuration files.
• Extensively used SQL LOADER as a tool for loading data.
• Installed and Configured of Oracle OEM (Oracle Enterprise Manager) Grid Control and OEM Database Control to monitor database.
• Handling large database environments (Data warehouse) using Oracle Enterprise Manager (OEM) on daily basis observing the performance of the production database and constantly active regarding performance and space management issues and accordingly providing on-fly solutions to make database healthy and running.
• Extensively compressed large tables in Data warehouse Environment to reduce space usage.
• Created and Managed users, user profiles, table spaces, data files, archive log.
• Created database links that are required for databases.
• Tuning SGA, Rollback segments, Latch contention issues, Optimize sort operations.
• Perform extensive testing on new versions of database products and tools to identify and resolve migration issues before these products are installed in the production environment.
• Worked as a member of production DBA team in perfect coordination with seniors and team members.

Environment: OEM Grid Control, Oracle 9i, 10g RAC, Solaris 7, RMAN, Sql*Loader, Import & Export, Data pump, Data guard, RMAN, AWR, ADDM, Statspack, ASM, TOAD 7.4, Shell scripting, Data warehouse, AIX 4.3 etc.

Confidential, Fishers, IN

Oracle Developer/DBA

Responsibilities:

• Installation and maintenance of Oracle 9i/10g on Linux OS
• Installed, upgraded and patched Oracle installations.
• Managed data files, control files, redo log files, tables, indexes, constraints for performance and availability.
• Worked on user management mainly on grants, privileges, roles and profiles.
• Designing and developing SQL procedures, query performance tuning.
• Performed hot and cold backup and recovery using RMAN and UNIX Scripts
• Monitored database and SQL performance using Stats pack, OEM, EXPLAIN PLAN and tuned problem areas to enhance performance.
• Monitored database and system performance.
• Configured the Event Manager to notify support personnel.
• Worked on application and database security (data access, passwords, network, etc).
• Handled daily production problems/change requests with Oracle.
• Performed daily database administration tasks: User management, Space monitoring, Performance monitoring and tuning, Alert Log monitoring and backup monitoring.
• Performed Physical backup (hot and cold) as well as Logical backup (Export/Import).
• Proactively managed the databases; set up alarms for managing any exceptions in day to day management of the databases; pre-empted and prevented issues, disasters from happening.
• Monitoring tablespace issues, creating tablespaces and adding datafiles.
• Involved in session management and monitored the critical wait events, blocking sessions in the database.
• Wrote Stored Procedures according to specs and control files for input to SQL*Loader utilities for loading data from external files into the Oracle database.
• Tuning test and production database by altering the parameters.
• Export and Import of database objects to copy from one database to another database.
• Investigating suspicious database activity using Auditing.
• Involved in query optimization and using rule based optimizers and cost based optimizers.
• Detecting and correcting instance performance problems. Locating and tuning SQL statements.

Environment: Oracle 9.2.0.7, Window NT/2000/2003, Oracle Enterprise Manager, MS SQL Server 7/2000, RDBMS, VERITAS Net backup, SQLDBA, PL/SQL, TOAD 7.5, Shell Scripting, HTML, Stored Procedures, Triggers.

Confidential

PL/SQL Developer/Jr.Oracle DBA

Responsibilities:

• Installed and Configured Oracle 9i Software.
• Worked on Oracle 9i OEM for regular database management.
• Performed day-to-day DBA jobs for managing Development databases
• Wrote PL/SQL procedures and triggers to carry out database maintenance tasks
• Created different views as per the business needs
• Created materialized views and snapshots for high end application usage.
• Created and used different types of sequences and indexes.
• Planning, Installation and Configuration of Oracle 9i on Sun Solaris and Windows 2000 Server.
• Performance tuning of database using stats pack reports.
• Backup and Recovery operations over all databases, ensuring 100% recoverability using RMAN.
• Wrote control files for input to SQL*Loader utilities for loading data from external files into the Oracle database.
• Created Table space, Data files, Indexes and monitoring them.
• Created Users and Granted privileges and roles.
• Designed and created schema objects like Database tables, indexes, views, synonyms, and all schema objects in Oracle.
• Understanding business data relation ships
• Prepared documents and loaded on to knowledge base portal of the company.

Environment: Oracle: 8i/9i, Windows (NT/2000), Sun Solaris, TOAD, PL/SQL, SQL*PLUS, Explain Plan, Stats pack etc.