SUMMARY:

• Experienced Oracle Database Administration with over 10 years’ experience in large production, test and development environments in diversified domains, on various versions of UNIX/LINUX and Windows operating systems.
• Strength includes installation, upgrades, migrations, patching and administration of multiple Oracle Enterprises. Expert in troubleshooting of production and development database environments with proactive performance monitoring in application databases using AWR and Oracle Enterprise Manager (OEM).
• Solid experience in installation, configuration and administration of Oracle 11g RAC, 10g RAC, Standby Databases for High Availability and Disaster Recovery purposes.
• Proficient in using Oracle utilities like export/import Data Pump, Flash Back Recovery, SQL Loader, Data Guard, ASM and OEM.
• 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.
• Strong ability to script the database models into SQL to create the database objects including tables, views, triggers, indexes, foreign keys and sequence counters.

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, Roseville, MN

Sr.Oracle DBA Lead

Responsibilities:

• Performed day-to -day DBA activities like Performance Tuning, Space Management, Backup and Recovery, Users and Security Management, Query Optimization, testing, implementation and Shell scripting. Database Administration support (24x7) for large mission critical production databases
• Ensuring the scheduled loading routines are converted/managed in the Linux environment.
• Testing the database migration process. Validating the migration with business stewards.
• Support additional Operational and Maintenance and system enhancement requests as required.
• Applying database patches for both Server side and Client side.
• Oracle 12c/11g/ RAC installation, configuration and support.
• Involved in Patching/upgrade of the oracle databases from one version to another.
• Install Oracle DB 11g and migrate data from different database version using export import utilities. Also, provide necessary documentation for the OS and Database level system requirements
• Experience using Export/Import and Data pump for migration of databases.
• Installing and configuring ASM.
• Utilized Point in time Recovery using RMAN
• Installation, configuration and administration of Oracle 12c RAC,11g RAC, 10g RAC, Standby Databases for High Availability and Disaster Recovery purpose.
• Responsible for Creation and maintenance tablespace, data files, 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.
• Implemented strong backup and recovery strategies and monitored backups
• Worked on creating and managing the table/tablespace partitions
• Working with SAN people for additional storage on disk/mount point if having any space issue

Confidential, Bayport, MN

Sr.Oracle DBA Lead

Responsibilities:

• Continuous Oracle Database Administration support (24x7) for large mission critical production databases. Extensive experience in Oracle RAC, SQL and performance tuning. Subject matter expert on different Oracle database 10g, 11g and 12c.
• Installation and configuration of Oracle Enterprise Manager Cloud Control 12c. Involved in Upgrade/Migration of the oracle databases from Oracle 11g to 12c.
• Utilized Export/Import and Data pump for migration of databases.
• Hands on experience in designing and implementing High Availability and Disaster Recovery Procedures. Setting up standards and writing required scripts for Log shipping, and Mirroring.
• Standby Database (Data Guard) setup and configuration. Managed OEM 11g Grid Control and OEM 12C Grid Control for administration, monitoring, patching, provisioning, backup, recovery and standby configuration. Used Oracle utilities i.e. export/import, Data Pump, Flash Back Recovery, SQL Loader, Data Guard, ASM and OEM Grid Control. 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 Creation and maintenance tablespace, datafiles, redo log files and renaming /relocating of data files on servers based on OFA model.
• Worked on creating and managing the partitions
• 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.
• Refresh/Cloning of Database and applications for development and testing purpose.
• Ability to manage time effectively including planning, organizing, and prioritizing multiple project workloads.

Confidential, St. Paul, MN

Sr.Oracle DBA Lead

Responsibilities:

• Installed, configured and administered Oracle 11g RAC, 10g RAC, Standby Databases for High Availability and Disaster Recovery purpose.
• Involved in Upgrading / Migration of the oracle databases from 9i to 10g, 9i, 10g to 11g.
• Installed and configured Oracle Enterprise Manager Cloud Control 12c.
• Installed Oracle DB 11g and migrated data from different database version using export import utilities. Provided necessary documentation for the OS and Database level system requirements.
• 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. Migrating Oracle databases from Windows to Linux. Ensured the scheduled loading routines are converted / managed in the Linux environment.
• Database Security Management involving managing Users, Roles and Privileges Handled troubleshooting problems. Providing necessary privileges or roles to users as per the requirement.
• Supported additional Operational and Maintenance and system enhancement requests as required.
• Mentored existing database staff on the administration, management, operation and maintenance of the new data warehouse environment.
• Applied patches for both Server side and Client side. Experience using Export/Import and Data pump for migration of databases.
• 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. Responsible for Creation and maintenance table space, data files, redo log files and renaming /relocating of data files on servers based on OFA model.
• Involved in scheduling file system backup using Net backup or FDR/Upstream. Installed and configured ASM. Utilized Oracle utilities i.e. export/import, Data Pump, Flash Back Recovery, SQL Loader, Data Guard, ASM and OEM Grid Control.
• Worked with SAN people for additional storage on disk/mount point if having any space issue.
• Supported (24x7) for large mission critical production databases
• SQL Server Installation, Configuration, Migration, SSIS, SSRS and administration, applied periodic Service packs and hot fixes (cumulative updates) and complimentary third party tools. Ensured all interfaces that transfer data to and from the warehouse/RCA/SAAS are enabled.

Confidential, Libertyville, IL

Oracle DBA

Responsibilities:

• Responsible for 24x7 Oracle Production Database Administration.
• Installed, configured and maintained Oracle Databases and Applications of Oracle 11g/10g RAC .
• Involved in Upgrade/Migration of the oracle databases from 9i to 10g, 9i and 10g to 11g. Worked with Oracle 9i and 10g partitioned tables.
• Utilized the Export/Import and Data pump for migration of databases.
• Refreshed/Cloned Database and applications for development and testing purpose.
• Table Partitioning, Creating Locally managed Tablespaces. Applied patches for both Server and Client side.
• Standby Database (Data Guard) setup and configuration.
• Installed Oracle DB 11g and migrated data from different database version using export import utilities.
• Migrated Oracle databases from W indows to Linux. Refreshed/cloned databases using RMAN
• Monitored an online performance monitor examines information as transactions are processed, and immediately points to trouble spots using OEM Grid Control.
• Proficiently used Oracle utilities i.e. export/import, Data Pump, Flash Back Recovery, SQL Loader, Data Guard, ASM and OEM
• Installation and configuration of Oracle Enterprise Manager Cloud Control 12c.
• Experienced in working with Oracle support to resolve the issues quickly as per the business requirement.
• Installed and configured ASM. Used expdp/impdp for export and import.
• Created and maintained Materialized Views for replication.
• Cloned Oracle databases from Production to Development, Test. Refreshed /cloning databases using RMAN. Refresh/Cloning of Database from production environment to test environment and application of patches and security patches downloaded from Oracle Metal ink
• Set up backup and recovery procedures.
• Responsible for continuous database monitoring and reorganization for ensuring performance.
• Partitioned large objects to improve the performance and manageability.
• Proactively monitored Oracle Database & Applications, which include Space management, Standard services availability check, quickly identify and resolve database and application level errors.

Environnent : Oracle 10g/9i/8i, OEM (Grid Control), Oracle Data guard, ASM, RAC, RMAN, Data pump, SQL*Loader, Import Export, AIX, HP-UX, and Red Hat.

Confidential, Dallas, TX

Oracle DBA

Responsibilities:

• Performed 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. 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.
• Responsible for Upgrading the Database from 9i to 10g, 9i, 10g to 11g. Involved in migration of Database and Up gradation from Oracle 10g to 11g.
• Migrated SQL server 2008 to SQL Server 2012 in Microsoft Windows Server 2012 Enterprise Edition. Performed installation of SQL Enterprise 2012 SP1 CU 5 64bit version on Windows 2012 Sp1 Clusters. Migrated SSIS packages from SQL Server 2008 R2 to SSIS 2012. Extensively worked on SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS).
• Used DMVs, Performance dash board, Mirroring, database snapshots and tracking Performance Counters.
• Rebuilt / Monitored the indexes at regular intervals for better performance. Recovered the databases from backup in disasters. Implementing Point-In-Time Recovery solutions.
• Migrated data from different database version using export import utilities. Also provided necessary documentation for the OS and Database level system requirements
• Troubleshoot Golden Gate whenever Extract or Replicate process’ got abended. Implemented both unidirectional replication as well as bi-directional replicate using Golden Gate. Worked with High transaction databases (OLAP) using Golden Gate to replicate the data to source. Installed and configured Golden Gate Veridata on production, development and testing.
• Analyzed 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.
• Documented and communicated changes to the OLTP, OLAP systems and data warehouse teams, including Data Modeling, ETL and Database teams.
• Installed patch sets and upgraded Teradata.
• An online performance monitor examined information as transactions are processed, and immediately points to trouble spots using OEM Grid Control.
• 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.
• Worked with 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.
• Utilized Point in time Recovery using RMAN.
• Installed and monitored database using security tools like TIVOLI, BMC PATROL. Escalated the issues as per the severity of database and resolving it immediately without any delay.
• Applied latest versions of database patches to minimize the bug issues which caused by the previous versions of patches.

Environment: s: 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, MS SQL SERVER 2008,2012

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. Along with maintenance and troubleshooting.
• Responsible for Creation and maintenance tablespace, datafiles, redo log files and renaming /relocating of data files on servers based on OFA model.
• 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.
• Installed 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 setting up, maintenance of Standby Database with Data Guard for Disaster recovery.
• Worked 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.
• Pre-Build checks on UNIX box whether number of LUNS from SAN team allocated perfectly.
• Pre-Build checks on UNIX box whether number of LUNS from SAN team allocated perfectly.
• Performance tuning included collecting statistics, analyzing explains & determining which tables needed statistics. Increased performance by 35-40% in some situations. PL/SQL, Stored Procedures, Packages, Functions, Database Triggers and Shell scripting. A batch performance monitor collects application performance data, collates it and produces reports that illustrate application efficiency
• Utilized 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.
• Multiload, BTEQ, created & modified databases, performed capacity planning, allocated space, granted rights for all objects within databases, etc
• Installed patch sets and upgraded Teradata. Performed database health checks and tuned the databases using Teradata Manager.
• Worked on creating and managing the partitions. Worked with SAN people for additional storage on disk/mount point if having any space issue.
• Automated data warehousing and data mart refreshes using Transportable table space option. Performed backup and recoveries on OLTP database like IBM Informix 7.1, Oracle database. Documented and communicated changes to the OLTP, OLAP systems and data warehouse teams, including Data Modeling, ETL and Database teams
• 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.
• Capacity planning tool utilized outlined 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.

Environment: s: 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:

• Migrated databases from Oracle 9i to Oracle 10g. Installed and configured Oracle 9i & 10gRAC database and Performed DBA tasks. Supporting large mission critical databases in a 24x7 environment. Responsible for Upgrading the Database from 9i to 10g, 9i, 10g to 11g.
• Worked 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.
• Cloned 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. Reviewed performance stats and recommended changes for tuning SQL queries, database, server, and storage configurations. 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.
• Worked in diamond relational tables of SQL server 2005 management studio.
• Participated 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.
• Performed 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 data mart refreshes using Transportable table space option.
• Coordinated interaction with vendors in critical database problem situations.
• Submitted 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 / Developer

Environment: s: Oracle 8i, 9i, 10g, HP-UX, Red Hat Linux, RMAN, TOAD, Data Pump, EXPLAIN PLAN, STATSPACK, TKPROF, SQL*Loader, SQL*Plus.