SUMMARY:

• An Oracle certified Database Consultant with 7 years of professional IT experience as an Oracle Database Administrator.
• Experienced in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using different Utilities.
• Technical Project Manager, Application Support Manager and member of IT Risk Management and Information Security Program in financial sector.
• Worked on various backend Procedures and Functions using PL/SQL.
• Expertise in snapshot, import/export, database optimization with the help of explain plan.
• Experience of Database Administration, design, development, maintenance and production support of relational databases, business applications, new server setup, MySQL Server installation, upgrade, migration.
• Hands on experience of setup & configuration, implementation of (Oracle 11g RAC two - nodes/ ASM /Grid Control /Automation/Database Flashback/RMAN SQL/Shell Script) implementation, management, Production Support, monitoring & troubleshooting with a Single Instance Physical Standby (Data Guard) for Maximum Availability Architecture (MAA).
• Installation and Configuration of Oracle 11gdata file objects including Tablespace and data files, object sizing as well as monitoring Managing database usage and growth.
• Managing backup/recovery using RMAN and UNIX shell scripts.
• Data replication (Basic) using Advanced Replication, Database cloning using RMAN, data loading using SQL loader, remote DBA, 24*7 production DBA supports for 3-tier applications of data size ranges from gigabytes to terabytes.
• Experience in Optimization techniques include cost based technique and analyzing the tables for gathering the statistics using EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE, ORADEBUG, 10gOEM Grid Monitoring custom scripts troubleshooting oracle databases using sql trace utilities.
• Experience with Oracle Database performance-tuning services for customers with Performance Tuning using AWR, Statspack, creating indexes, materialized views to tune queries.
• Experienced in Data migrations using Export/Import.
• Good understanding of DAS, NAS and SAN storage, Storage virtualization, Tape libraries, networking, backup software like EMC Networker, VERITAS and backup solutions like BCV.
• Experience in implementing SOX to comply with government data access and security regulations.
• Worked in a team of 19 DBAs supporting multiple primary and secondary databases and supported more than 100 servers and 185 production, QA and test databases during on-call.
• Immaculate problem-solving skill, strong verbal/written communication & work ethic and versatile team player.
• An Out-of-Box thinker with great zeal for cutting-edge technology and improving the status quo.
• Worked on setting Up High Availability Oracle Golden Gate (OGG) systems on Oracle 11g/12c and 11gR2 RAC environments (Front-end: IBM AIX 6.0, Back-end: Oracle Exadata).
• Experienced in Golden Gate Install, Configuration, Maintenance, Trouble Shooting and Upgrade.
• Solid experience in disaster recovery routine maintenance for Oracle databases.
• Implemented Materialized Views for efficient and high availability of Processed Sales data.
• Regular database activities, backups monitoring and troubleshooting.
• Involved in User management, Tablespace Management and regular maintenance activities
• Installed patch sets and upgraded Oracle (RDBMS).
• Involved in Creation and Maintenance of table partitions and indexes
• Cloning the databases regularly for the reporting databases and stage environments.

TECHNICAL SKILLS:

RDBMS: Oracle 12c, Oracle11g, Oracle10g, Oracle 9i, Microsoft SQL Server.

Applications: Oracle Apps 11i, Oracle EBS R12, Oracle Golden Gate, Primavera, OTM.

Operating Systems: Oracle Linux, Sun Solaris, Red Hat Linux, IBM AIX, HP Tru64, HP-UX PA-RISC, HP-UX IA-64, Microsoft Windows.

Programming: SQL, Unix Shell scripting.

Oracle Tools & Other Utilities: Oracle Diagnostics Tool, OEM Grid Control, RMAN, Statspack, ADDM, AWR, Tkprof, LogMiner, Export/Import, Data Pump, Oracle SQL Loader, AD Utilities, Quest TOAD, Quest STAT, Cisco TIDAL, HP Kintana.

PROFESSIONAL EXPERIENCE:

Confidential - Richardson, TX

Oracle Database Administrator

Responsibilities:

• Managed multiple instances (production/development/test) of different sizes ranging from 700GB to 2 Tb running on different Oracle versions from Oracle 12c RAC under DS8300 and DS8100 storage.
• Prepared Oracle environment for new workflow applications (Oracle installation, configuration, RAC setups, ASM setups, space estimation) and load testing.
• Setup Development, CIT, Training, ST, UAT (Two node RAC) and PROD (Two nodes RAC) servers with grid infrastructure with ASM.
• Extensive experience in migration of databases with RMAN, Export/Import, Expdp/Impdp
• Migrated Oracle database and applications from Oracle 11.2.0.4 to 12.2.0.1 on AIX 5.3 to AIX 6.1 with two node RAC
• Setup Advanced Replication for data replication to master sites using API.
• Writing UNIX shell script for various database activities like space cleanup, snapshot refresh, file transfer.
• Oracle 11g/12c database backup / recovery and network activities such as Oracle Instance and Media Recovery, Oracle Recovery Manager configuration, User-Managed Complete Recovery, Recovery Catalog Creation and Maintenance, Oracle Net Services Server and Client-side Configuration, Configuring the Database in Archiving Mode, Oracle Recovery Manager configuration, User-Managed Incomplete Recovery, Transporting data between databases, Oracle Shared Server Configuration, RMAN Backups, RMAN Complete, Incomplete Recovery and Maintenance, Loading Data, Maintaining Network Storage Devices by using OEM 10g Console, Oracle Management Server, RMAN, Toad, EXP, IMP, TKPROF, DBVERIFY
• Managed knowledge transfer to team member. Handling of all day-to-day Oracle DBA activities such as performance problems, tracing/analyzing of SQL queries of development and production environment, space problems etc.
• Generated Statspack, Automatic Workload Repository (AWR), and ADDM & SQL Tuning Advisor to tune the database.
• Identify and Create indexes, materialized views for SQL Tuning of bad queries using Explain Plan and TKPROF.
• Implemented Oracle 10g/11g/12c database flashback and doing database recovery Prepared 11.2.0.1 Grid Control environment and DBAs are using for database monitoring.
• Understanding the legacy system, and newly under development UCMS system, conversion mappings and writing loading/conversion scripts SQL, PL/SQL, Shell Scripts and Data stage.
• Wrote a data cleansing shell script to clean up the legacy data, which reduced the Mock Conversion time from weeks to days.
• Formulized a fastest loading/inserting mechanism which reduced the processing times for many processes from 7+ hours to less than 3 hrs.

Environment: and tools: Red Hat LINUX 4.0/5.0/6.0, Oracle 12c/11g/10g RAC, SQL SERVER 2005/2008R2/2012/2014, Informix 10, MySQL 4.0/5.0, Erwin, PL/SQL, T-SQL, PERL., VMS, Sun Solaris, Windows Server 2003, Red Hat Linux, TOAD, RMAN, SQL server, OEM.

Confidential - New Jersey, NJ

Oracle Database Administrator

Responsibilities:

• Managed multiple instances (production/development/test) of different sizes ranging from 700GB to 2 Tb running on different Oracle versions from Oracle 11g RAC under DS8300 and DS8100 storage.
• Prepared Oracle environment for new workflow applications (Oracle installation, configuration, RAC setups, ASM setups, space estimation) and load testing.
• Setup Development, CIT, Training, ST, UAT (Two node RAC) and PROD (Two nodes RAC) servers with grid infrastructure with ASM.
• Extensive experience in migration of databases with export/import, expdp/impdp, RMAN.
• Migrated Oracle database and applications from Oracle 10.2.0.4 to 11.2.0.1 on AIX 5.3 to AIX 6.1 with two node RAC
• Setup Advanced Replication for data replication to master sites using API.
• Writing UNIX shell script for various database activities like space cleanup, snapshot refresh, file transfer.
• Oracle 10g/11g/12c database backup / recovery and network activities such as Oracle Instance and Media Recovery, Oracle Recovery Manager configuration, User-Managed Complete Recovery, Recovery Catalog Creation and Maintenance, Oracle Net Services Server and Client-side Configuration, Configuring the Database in Archiving Mode, Oracle Recovery Manager configuration, User-Managed Incomplete Recovery, Transporting data between databases, Oracle Shared Server Configuration, RMAN Backups, RMAN Complete, Incomplete Recovery and Maintenance, Loading Data, Maintaining Network Storage Devices by using OEM 10g Console, Oracle Management Server, RMAN, Toad, EXP, IMP, TKPROF, DBVERIFY
• Managed knowledge transfer to team member. Handling of all day-to-day Oracle DBA activities such as performance problems, tracing/analyzing of SQL queries of development and production environment, space problems etc.
• Generated Statspack, Automatic Workload Repository (AWR), and ADDM & SQL Tuning Advisor to tune the database.
• Identify and Create indexes, materialized views for SQL Tuning of bad queries using Explain Plan and TKPROF.
• Implemented Oracle 10g/11g/12c database flashback and doing database recovery Prepared 11.2.0.1 Grid Control environment and DBAs are using for database monitoring.
• Understanding the legacy system, and newly under development UCMS system, conversion mappings and writing loading/conversion scripts SQL, PL/SQL, Shell Scripts and Data stage.
• Wrote a data cleansing shell script to clean up the legacy data, which reduced the Mock Conversion time from weeks to days.
• Formulized a fastest loading/inserting mechanism which reduced the processing times for many processes from 7+ hours to less than 3 hrs.

Environment: and tools: Red Hat LINUX 4.0/5.0/6.0, Oracle 12c/11g/10g RAC, SQL SERVER 2005/2008R2/2012/2014, Informix 10, MySQL 4.0/5.0, Erwin, PL/SQL, T-SQL, PERL., VMS, Sun Solaris, Windows Server 2003, Red Hat Linux, TOAD, RMAN, SQL server, OEM.

Confidential

Oracle Database Administrator

Responsibilities:

• Installed, configured, and maintained Oracle 10g and 11gR2 on Linux and also Upgraded from Oracle 10g to 11g
• Extensive Experience with RMAN Backups, Hot Backups and Logical Backups.
• Extensively implemented Data pump, conventional Export/Import (Oracle 11g, 10g) for migration and logical backup of database.
• Strong skills in applying security patches (Patch set, Critical Patch Updates (CPU) / Patch Set Updates (PSU), One-off Patch) using "runInstaller" and perl based utility "opatch"
• Effectively made use of Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views & Query Re-Write.
• Supported functional data warehouse projects.
• Worked with database export & import scripts to backup database structures and automation procedures.
• Installation, Configuration, Upgrade, patching of Oracle RDBMS and applications Work on different versions of Databases with OEM Grid control to maintain the database effectively.
• Performed Installation, Configuration, troubleshooting, performance tuning, Backup and Recovery and production support of Oracle 11g, 12C databases (Single Instance and RAC) on Red Hat Linux
• Database monitoring and performance tuning using OEM (Oracle Enterprise Manager)
• Index creation and management for optimization of DB Processes
• Planned and implemented high availability solutions such as Real Application Cluster (RAC) in Oracle 11gR2 Grid and 10g on ASM and OCSF2 file systems.
• Highly experienced in Oracle 11g, 10g Automatic Storage Management (ASM) required to fulfill the storage needs.
• Installed, configured and maintained Physical, Logical, Active standby databases supported by Data guard on Oracle 11g, 10g RAC servers for the purpose of disaster recovery procedures.
• Supported & maintained the Production/Development databases on various servers
• Extensively worked on setting up auditing in many databases we supported
• Managing Database Structure, Storage Allocation, Table/Index segments, Rollback Segments, Undo Segments, and Constraints.

Environment: and tools: OEM Grid Control, Data Guard, RMAN, TOAD, SQL TRACE, TKPROF, AWR, ASH, ADDM, Explain Plan, Statspack, SQL*PLUS, SQL*LOADER, EXP, IMP, Data Pump (expdp, impdp)

Confidential

Oracle Database Administrator

Responsibilities:

• Monitored the growth of the database objects for capacity planning.
• Export and Import of database objects to copy from one database to another database.
• Database security, job scheduling and documentation.
• Investigating suspicious database activity using Auditing.
• Regular database activities, backups monitoring and troubleshooting.
• Involved in User management, Tablespace Management and regular maintenance activities
• Installed patch sets and upgraded Oracle (RDBMS).
• Involved in Creation and Maintenance of table partitions and indexes
• Cloning the databases regularly for the reporting databases and stage environments.
• As a part of recommendation various server side stored procedures were rewritten, database files moved on different LUNs to reduce the I/O contention.
• Performance monitoring and tuning of database, server and storage devices by capturing various dynamic statistics.
• Extracted information from the Core Banking system as part of the resolving issues process,
• Supported all Bank’s branches related with Core Banking modules like Retail Banking and Credit Banking,
• Made investigation and provide Diagnosis, Resolution and Recovery for Core Banking issues,
• Logged and tracked core banking issues with the software vendor’s online support using their portal,
• Involved in development of new products with collaboration with concerned party and test accordingly

Environment: and tools: OEM Grid Control, Data Guard, RMAN, TOAD, SQL TRACE, TKPROF, AWR, ASH, ADDM, Explain Plan, Statspack, SQL*PLUS, SQL*LOADER, EXP, IMP, Data Pump (expdp, impdp)