SUMMARY:

• Experienced with over 10 years in Oracle Database Administration in very large Production, test and development environments in a diversified domains, on various versions of UNIX/LINUX and Windows operating systems.
• Oracle DBA proficiency in installation, upgrading, patching, administration of multiple Oracle Enterprise Edition 9i, 10g, 11g databases on RHEL, Sun Solaris, IBM - AIX and Windows.
• Good experience in installation, configuration and administration of Oracle 11g RAC, 10g RAC, Standby Databases for High Availability and Disaster Recovery purpose.
• I've involved in migration of Database and Up gradation from Oracle 10g to 11g.
• Install Oracle DB 11g and migrated data from different database version using export import utilities. Also provided necessary documentation for the OS and Database level system requirements
• Exceptional Knowledge of various states of Software Development Life Cycle (SDLC) i.e. System Analysis, Applications Design, Development, Integration & System Testing Support of Oracle 8i,9i, 10g, 11g in Production, Staging, and Development environments.
• Install Oracle DB 11g and migrated data from different database version using export import utilities. Also provided necessary documentation for the OS and Database level system requirements
• Developed backup and recovery policy and used new features/technologies to optimize system maintenance and extensive knowledge on Partitions and Oracle Streams.
• Proficient in implementation, maintenance of Database Security (Users, Roles, Privileges), space management of logical structures (i.e. table spaces, rollback segments) and auditing of users.
• Proficient in using Oracle utilities like export/import Data Pump, Flash Back Recovery, SQL Loader, Data Guard, ASM and OEM.
• Expert in effective troubleshooting of production, development database environments on daily basis with Proactive performance monitoring for better performance in applications database using AWR and Oracle Enterprise Manager (OEM).
• Performed backup and recoveries on OLTP database like IBM Informix 7.1, Oracle database.
• Maintaining centralized data from OLTP databases like Informix, Sybase as well as IBM DB2.
• Experienced in performance tuning of various aspects of the database by using oracle utilities like TKPROF, EXPLAIN PLAN, STATS PACK, SQL TRACE, TOAD and Automatic Database Diagnostic Monitor (ADDM).
• Expert in Optimization of SQL queries, PL/SQL, Stored Procedures, Functions, Database Triggers and Shell scripting and worked with the users to meet business requirements
• Data modeling knowledge designing logical, physical and conceptual database schemas.
• Strong ability to script the database models into SQL to create the database objects including tables, views, triggers, indexes, foreign keys and sequence counters.
• Performed and monitored Hot and cold database backups and implemented backup and recovery using RMAN and Knowledge of storage technologies SAN, NAS.
• Ability to restore and recover databases from file system backup in order to bring to the original state as per the business and user requirement.
• Installing and monitoring database security tools like TIVOLI, BMC PATROL. Escalating the issues as per the severity of database and resolving it immediately without any delay.
• Applying latest versions or releases of database patches to minimize the bug issues which caused by the previous versions of patches.

TECHNICAL SKILLS:

Databases: Oracle 11g R2 RAC, 10gR2RAC, 9i

Operating Systems: HP-UX, Sun Solaris, AIX, Linux and Windows, IBM DB2, Informix on IBM.

Languages: SQL, PL/SQL, Java, C, UNIX Shell

Scripting.Tools: RMAN, OEM, SQL*Loader, EXP, IMP, Data Pump, TOAD, DB Artisan 4.0.

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ADDM, OEM Grid Control

ETL Tools: Informatica 5.1, Data pump, Share Plex.

Other: EMC, Net App, VERITAS, Golden Gate, Oracle Wallet Manager.

PROFESSIONAL EXPERIENCE:

Confidential, St.Paul, MN

Sr.Oracle DBA Lead

Responsibilities:

• Database Administration support (24x7) for large mission critical production databases
• Database Security Management involving managing Users, Roles and Privileges Expert in troubleshooting problems. Providing necessary privileges or roles to users as per the requirement.
• Installation, configuration and administration of Oracle 11g RAC, 10g RAC, Standby Databases for High Availability and Disaster Recovery purpose.
• Performed Data guard switch over to check the standby database is in SYNC with production as per the business requirement and also operated standby database using Data Guard broker.
• Responsible for the analysis of the current data warehouse environment. Designing the migration process for the existing Windows 2008R2 Oracle 11G warehouse to the new Linux Oracle RAC environment.
• Ensuring all interfaces that transfer data to and from the warehouse/RCA/SAAS are enabled.
• Ensuring the scheduled loading routines are converted/managed in the Linux environment.
• Testing the migration process. Validating the migration with business stewards.
• Support additional Operational and Maintenance and system enhancement requests as required.
• Mentor existing database staff on the administration, management, operation and maintenance of the new data warehouse environment
• Migrating Oracle databases from windows to Linux
• Applying patches for both Server side and Client side.
• Oracle 11g/10g RAC installation, configuration and support.
• Involved in Upgrading of the oracle databases from 9i to 10g, 9i, 10g to 11g.
• Install Oracle DB 11g and migrated data from different database version using export import utilities. Also provided necessary documentation for the OS and Database level system requirements
• Involved in Upgrade/Migration of the oracle databases from Oracle 9i to Oracle 10g.
• Experience using Export/Import and Data pump for migration of databases.
• Installing and configuring ASM.
• Installation, configuration and administration of Oracle 11g RAC, 10g RAC, Standby Databases for High Availability and Disaster Recovery purpose.
• Table Space management, Database Refreshes, and User Administration. Adding additional data file to table space whenever there is required and also involved in shrinking of table space size.
• Involved in scheduling file system backup using Net backup or FDR/Upstream.
• Proficient in using Oracle utilities i.e. export/import, Data Pump, Flash Back Recovery, SQL Loader, Data Guard, ASM and OEM Grid Control.
• Responsible for Creation and maintenance tablespace, datafiles, redo log files and renaming /relocating of data files on servers based on OFA model.
• Proficient in using Oracle utilities i.e. export/import, Data Pump, Flash Back Recovery, SQL Loader, Data Guard, ASM and OEM.
• Worked on creating and managing the partitions
• Working with SAN people for additional storage on disk/mount point if having any space issue.

Confidential, Libertyville,IL

Oracle DBA

Responsibilities:

• 24x7 Oracle Production Database Administration.
• Installed, configured and maintained Oracle Databases and Applications.
• Involved in Upgrade/Migration of the oracle databases from Oracle 9i to Oracle 10g.
• Experience using Export/Import and Data pump for migration of databases.
• Refresh/Cloning of Database and applications for development and testing purpose.
• Table Partitioning, Creating Locally managed Tablespaces.
• Applying patches for both Server side and Client side.
• Oracle 11g/10g RAC installation, configuration and support.
• Involved in Upgrading of the oracle databases from 9i to 10g, 9i, 10g to 11g.
• Install Oracle DB 11g and migrated data from different database version using export import utilities. Also provided necessary documentation for the OS and Database level system requirements
• Refresh/Cloning of Database from production environment to test environment and application of patches and security patches downloaded from Oracle Metalink
• Working alongside programmers and contributing to the development process
• Defining and Setting backup and recovery procedures.
• Responsible for continuous database monitoring and reorganization for ensuring performance.
• Partitioning large objects to improve the performance and manageability.
• Proactive monitoring of Oracle Database & Applications, which include Space management, Standard services availability check, quickly identify and resolve database and application level errors.
• Environment: Oracle 10g/9i/8i, OEM (Grid Control), Oracle Data guard, ASM, RAC, RMAN, Datapump, SQL*Loader, Import Export, AIX, HP-UX, and Red Hat. ThyssenKrupp, Dallas, TX Oct 10 - Dec 13Oracle DBAResponsibilities:
• Database Administration support (24x7) for large mission critical production databases
• Database Security Management involving managing Users, Roles and Privileges Expert in troubleshooting problems. Providing necessary privileges or roles to users as per the requirement.
• Installation, configuration and administration of Oracle 11g RAC, 10g RAC, Standby Databases for High Availability and Disaster Recovery purpose.
• Performed Data guard switch over to check the standby database is in SYNC with production as per the business requirement and also operated standby database using Data Guard broker.
• Configured Oracle wallet manager on windows file management system or in the user profile area of the Microsoft Windows system registry storing for better access control and easier management.
• Troubleshooting the database performance using Oracle Enterprise Manager, generating the monthly reports on the database to see how much load has been applied on database constantly.
• Participated in doing schema refresh like taking export of one schema and importing it into another schema using different ways of utility tools like REMAP SCHEMA, REMAP TABLESPACE.
• Space management of logical structures (i.e. table spaces, rollback segments) and auditing of users
• Optimization of SQL queries, PL/SQL, Stored Procedures, Functions, Database Triggers and Shell scripting and worked with the users to meet business requirements.
• I've involved in migration of Database and Up gradation from Oracle 10g to 11g.
• Responsible for Upgrading the Database from 9i to 10g, 9i, 10g to 11g.
• Install Oracle DB 11g and migrated data from different database version using export import utilities. Also provided necessary documentation for the OS and Database level system requirements
• Good knowledge on troubleshooting Golden Gate whenever Extract or Replicate process get abended.
• Implemented both unidirectional replication as well as bi-directional replicate using Golden Gate.
• Working with High transaction databases (OLAP) using Golden Gate to replicate the data to source.
• Installing and configuration of Golden Gate Veridata on production, development and testing.
• Analyzing SOX application for validating business inventory for critical ones and risk assessment.
• Responsible for automation of startup, shutdown of database without the involvement of DBA to start the database manually. Effective knowledge of working with System Administrator’s.
• Administration, Optimization, Monitoring, Tuning of Oracle Databases. Extensive Conceptual knowledge on designing Data Modeling like Data Models, Conceptual, Logical, Physical Schemes, Data Modeling Process, Modeling Methodologies, Entity Relationship Diagrams, Generic Data modeling, Semantic Data modeling.
• Document and communicate changes to the OLTP, OLAP systems and data warehouse teams, including Data Modeling, ETL and Database teams.
• Performing day-to -day DBA activities like Patching, Performance Tuning, Space Management, Backup and Recovery, Users and Security Management, Query Optimization, testing, implementation and Shell scripting.
• Installed patch sets and upgraded Teradata.
• An online performance monitor examines information as transactions are processed, and immediately points to trouble spots using OEM Grid Control.
• Knowledge of storage technologies like SAN, NAS whenever we have a disk outage or mount point issues due to database growth. Raising a request to SAN or NAS to request for additional storage.
• Table Space management, Database Refreshes, and User Administration. Adding additional data file to table space whenever there is required and also involved in shrinking of table space size.
• Involved in scheduling file system backup using Net backup or FDR/Upstream.
• Proficient in using Oracle utilities i.e. export/import, Data Pump, Flash Back Recovery, SQL Loader, Data Guard, ASM and OEM Grid Control.
• Used Data Modeling tools for data message in order to show the output results in different formats using Erwin, Informatica and some other ETL tools.
• Effective implementation of Rational Rose to design schemas and data modeling for business require.
• Ability to restore and recover databases from file system backup in order to bring it to the original state as per the business or user requirement. I have done Point in time Recovery using RMAN.
• Installing and monitoring database using security tools like TIVOLI, BMC PATROL. Escalating the issues as per the severity of database and resolving it immediately without any delay.
• Experienced in working with Oracle support to resolve the issues quickly as per the business require.
• Applying latest versions of database patches to minimize the bug issues which caused by the previous versions of patches.

Environments: Oracle 11g RAC, 10g RAC/9i, IBM AIX, HP-UX, Red Hat Linux, Sun Solaris, Windows XP, SQL*Plus, SQL*Loader, SQL Developer, Import/Export, Data Pump, TOAD, Oracle Data Guard.

Confidential, San Mateo, CA

Oracle DBA

Responsibilities:

• Database Administration support (24x7) for large mission critical production databases
• Installation, configuration and administration of Oracle 11g RAC, 10g RAC, Standby Databases for High Availability and Disaster Recovery purpose.
• Responsible for Creation and maintenance tablespace, datafiles, redo log files and renaming /relocating of data files on servers based on OFA model.
• Oracle 10g & 11g Databases maintenance and troubleshooting.
• Upgraded from 9i to 10g, 10g to 11g database and applied critical patches update (CPU) for latest versions. Good experience in managing Very Large OLTP and Data ware housing databases.
• Install Oracle DB 11g and migrated data from different database version using export import utilities. Also provided necessary documentation for the OS and Database level system requirements
• Good knowledge on replication tools like Golden Gate to extract and replicate Databases.
• Involved in setting up, maintenance of Standby Database with Data Guard for Disaster recovery.
• Working knowledge on NETAPP storage from disk to tape to copy the RMAN Backup Data and mirroring of databases (BCV Split backup) from one database to another using NETAPP utility.
• Proficient in using Oracle utilities i.e. export/import, Data Pump, Flash Back Recovery, SQL Loader, Data Guard, ASM and OEM
• Designed conceptual schemas using Rational Rose like Entities, Relationships, and Integrity rules.
• Responsible for implementing backup procedures using RMAN. Responsible for creating RMAN catalog Database and Registering the Databases in Catalog Database. Implemented strong backup and recovery strategies and monitored backups.
• Performance tuning, including collecting statistics, analyzing explains & determining which tables needed statistics. Increased performance by 35-40% in some situations.
• Multiload, BTEQ, created & modified databases, performed capacity planning, allocated space, granted rights for all objects within databases, etc
• Moved databases between machines.
• Installed patch sets and upgraded Teradata.
• Automated data warehousing and datamart refreshes using Transportable table space option.
• Worked on creating and managing the partitions.
• Performed database health checks and tuned the databases using Teradata Manager.
• Performed backup and recoveries on OLTP database like IBM Informix 7.1, Oracle database.
• Working with SAN people for additional storage on disk/mount point if having any space issue.
• Pre-Build checks on UNIX box whether number of LUNS from SAN team allocated perfectly.
• The GUI is a multi-platform Java client that contains a variety of wizards suitable for novice users.
• For security administration used oracle Wallet Manager to manage public key security credentials on Oracle clients and servers.
• A batch performance monitor collects application performance data, collates it and produces reports that illustrate application efficiency
• Extensive Conceptual knowledge on designing Data Modeling like Data Models, Conceptual, Logical, Physical Schemes, Data Modeling Process, Modeling Methodologies, Entity Relationship Diagrams, Generic Data modeling, Semantic Data modeling.
• Document and communicate changes to the OLTP, OLAP systems and data warehouse teams, including Data Modeling, ETL and Database teams
• An online performance monitor examines information as transactions are processed, and immediately points to trouble spots using OEM Grid Control.
• A capacity planning tool outlines how a future application will function and determines whether or not a company will have to upgrade its CPU or add disk storage to keep users happy.
• PL/SQL, Stored Procedures, Packages, Functions, Database Triggers and Shell scripting.

Environments: Oracle 9i, 10g RAC& 11g RAC, OEM Grid Control, Sun Solaris, HP-UX, RHEL, Windows 2000/XP, RMAN, TOAD, RATIONAL ROSE, TKPROF, EXPLAIN PLAN, STATSPACK, AWR and ADDM

Confidential, Secaucus, NJ

Oracle DBA

Responsibilities:

• Installation and configuration of Oracle 9i & 10gRAC database and Performed DBA tasks
• Supporting large mission critical databases in a 24x7 environment.
• Migration of database from Oracle 9i to Oracle 10g.
• Working with database Monitoring and Tuning. Lead efforts to develop and improve procedures for automating monitoring.
• Integrated the Backup status reporting for the entire database in the enterprise to enable the web reporting using Oracle SQL, PL/SQL and korn shells, Unix shell Scripting.
• Cloning of databases from production to development and test databases
• Used RMAN for Backup & Recovery.
• Performance Tuning of application by identifying the SQL, which are not written well, providing inputs to the application programmer, correcting and implementing the right components
• Reviewing performance stats and recommended changes for tuning SQL queries, database, server, and storage configurations.
• Responsible for Upgrading the Database from 9i to 10g, 9i, 10g to 11g.
• Responsible for SQL query tuning, optimization. Performance tuning using tools such as SQLTRACE, TKPROOF, STATSPACK, Explain Plan, AWR and ADDM.
• Automatic Health Monitoring, security, SQL Performance Analyzer.
• Responsible for using Flashback query mechanism along with automatic undo management.
• Refresh/Cloning of Database from production environment to test environment and application of patches and security patches downloaded from Oracle Metalink.
• Working and good experience in diamond relational tables of SQL server 2005 management studio.
• Participating in periodic backup audits, including test restores ensuring all databases and associated logs are being backed-up
• Actively involved in Backup Management of Disaster Crash recovery supporting 24-7 assurance.
• Performing day-to -day DBA activities like Patching, Performance Tuning, Space Management, Backup and Recovery, Users and Security Management, Query Optimization, testing, implementation and Shell scripting.
• Installed patch sets and upgraded Teradata.
• Automated data warehousing and datamart refreshes using Transportable table space option.
• Worked on creating and managing the partitions.
• Performed database health checks and tuned the databases using Teradata Manager.
• Extensive experience customizing one or more of the Oracle eCommerce products including ATG Commerce and ATG Search.
• Coordinate interaction with vendors in critical database problem situations.
• Submitting Tickets using remedy communicating with other groups like UNIX, Configuration Team.
• Oracle utilities i.e. export/import Data Pump, Flash Back Recovery, SQL Loader, Data Guard, ASM and OEM.
• Actively involved in Backup Management of Disaster Crash recovery supporting 24-7 assurance.

Environment: Oracle 10g RAC/9i, Sun Solaris, AIX, PL/SQL, Oracle Streams, DATAGUARD, Import Export, TOAD, OLTP, LDAP, RMAN, Remedy, Shell Script.

Confidential

Oracle DBA

Responsibilities:

• Part of INM DBA Support team for the Production/UAT databases pertaining to various entities of the HSBC Group.
• 24x7 support for Critical Applications on Global Banking and Check Transaction System.
• Installed and Configured Oracle 9i/10g on different operating systems.
• Performed Backup and Recovery using RMAN.
• Worked as Production Support for Oracle based systems and UNIX based Server environments.
• Managed Users access control and security by creating appropriate roles and profiles.
• Involved in designing and creating the Oracle 9i database.
• Enforced security by creating roles, giving grants on the tables, stored procedures, and other database objects depending on role.
• Implemented automated backup strategy using the UNIX shell script and CRON Utility.
• Used SQL*Loader to load data from flat files to Oracle database.
• Created database links for data transfer to support distributed transactions.
• Migration of database from Oracle 9i to Oracle 10g.
• Performing day-to -day DBA activities like Patching, Performance Tuning, Space Management, Backup and Recovery, Users and Security Management, Query Optimization, testing, implementation and Shell scripting.
• Installed patch sets and upgraded Teradata.
• Actively involved in Backup Management of Disaster Crash recovery supporting 24-7 assurance.
• DBA activities including creation, management, startup and shutdown of Oracle databases, management of data files, redo log files, control files, tablespace, segments, extents and data blocks & physical storage, creation, monitoring and management of database users, granting/revoking of system/object privileges, management of roles & resources and setting of init.ora parameters.

Environments: Oracle 9i, 10g, HP-UX, Red Hat Linux, RMAN, TOAD, Data Pump, EXPLAIN PLAN, STATSPACK, TKPROF.

Confidential

Oracle DBA

Responsibilities:

• Responsible for installation, Maintenance, Backup, Recovery of Oracle 9i database on Sun Solaris and setting up and maintaining user accounts and profiles
• Ensured proper online and off line Backups on scheduled time and Monitoring Scheduled Backups.
• Creating and dropping of users, granting and revoking privileges when required.
• Involved in Database logical Designing (Table spaces and Rollback Segments).
• Monitoring of database objects like rollback segments, temp segments and table spaces.
• Performed Backup and Recovery using RMAN.
• Storage and space management including table space growth, monitoring data files additions, extent growth
• Constantly monitor the performance of the Databases by viewing Alert log files & Trace files.
• Monitoring of database for growth, data fragmentation and correcting them for better performance
• Partitioned large tables to increase the performance.
• Defined backup procedures using daily hot backups and weekly cold backup.
• Using TKPROF, EXPLAIN PLAN for the better performance tuning.

Environments: Oracle 9i, SQL, PL/SQL, Sun Solaris, TKPROF, EXPLAIN PLAN, STATSPACK.

Confidential

Oracle DBA / Developer

Responsibilities:

• Involved in 24x7 production database maintenance and on-call support.
• Responsible for administering and supporting production and development Oracle 8i databases. Migrated production and development environments from Oracle 8i to Oracle 9i environment.
• Responsible for installing, upgrade and configuring the Oracle server, creating databases, storage structures and objects; database backup and recovery, monitoring and optimizing database performance.
• Designed backup and recovery procedures for OLTP system. Conducted periodic cold and hot backups. Data Pump Utilities to move the data between different databases and for backups
• Instance cloning done to create test and training environments.
• Created PL/SQL procedures (jobs) to automate maintenance tasks.
• Partitioned large tables to increase the performance.
• Configured scripts to monitor activity with database.
• Generated scripts for daily maintenance activity like analyzing the tables/indexes, and monitoring their growth rate.
• Developed PL/SQL Functions, Procedures, Packages and Triggers.
• Created tables, indexes, synonyms, views, database links, tablespace
• Worked on re-organization of tables.