SUMMARY:

Over **+ Years of as Senior Oracle Database Administration/Lead Ver. 21c, 19c, 12c, 11G R1,R2/10G/9i on a variety of UNIX (Solaris, HP-UX, AIX), Windows NT 4.0/2000/2003 with Oracle ( 9i, 10g,11g), Stored Procedures, DB Triggers, Developer 2000, Sql*Plus etc and Supporting MS SQL Server, WebLogic Administration.

Installed oracle database server on LINUX 6/7/8, SOLARIS, HP-UX, AIX, WINDOWS NT, Exadata, ODA and migration of oracle server from 8i to 9i and 9i to 10g, 11g,12c, 18c applied oracle patches.

Installed Oracle 11g RAC software with ASM and OCFS2 File systems

Excellent knowledge on server’s infrastructure and communication with team.

Installed and Configured Oracle 11g,12c databases instance running across two oracle RAC nodes on Red Hat Linux AS 4 Server

Installation, maintenance and tuning of RAC Applications.

Created development, testing, staging, production, RAC and standby databases for OLTP and Data Warehousing using customized shell scripts.

Used for the SAP applications BR TOOLS(Backup, Table Reorg, Tablespace, Instance)

Planning/Implementing, Memory Management, Tablespace Management, File Management, Segment Management, User Management, Resource Management, Password Management. Backup & Recovery Planning & Testing

24*7 production database support with Support to developers & end-users.

Having hands on experience in Hot/Cold Backup, Recovery and Cloning of databases using RMAN with VERITAS Net Backup.

Implemented and delivered core edge technologies of Oracle 12g (EM Grid Control, and RAC).

Implemented RMAN backup (Full, incremental and cumulative) and recovery, Incomplete recovery and disaster recovery using DataGuard.

Implemented automated backup strategy using the UNIX shell script CRON UTILITY.

Expertise in PL/SQL, SQL and UNIX Scripting (Used to write UNIX Scripts & implemented by Using CRONJOB for Day – to – Day activities.)

Performance tuning of the database - SQL Tuning, Used Tuning utilities like STATSPACK, TKPROF, EXPLAIN PLAN, AWR, ADDM and Tuning of SGA, Distribution of disk I/O, Sizing of tables and indexes.

Performance Tuning i.e. tuning applications, shared pool, I/O distribution, rollback segments, buffer cache, redo mechanisms

Installation and Configuration of Oracle Grid Control.

Strong knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes, ETL processes, dimensional modeling and reporting tools.

Extensive experience with designing and implementing Oracle databases, data warehouse design, implementation and tuning.

Data loading using SQL*LOADER, Logical backups using full export and DATAPUMP.

Good knowledge data modeling using Erwin.

Excellent knowledge on Golden gate installation configuration 12.2 and older versions

Database replication using snapshots, materialized views and advanced replication methods.

Worked on different types of storage structures (SAN/NAS).

Good co-ordination and communication with system administrators, business data analysts and development teams.

Good Knowledge on DB2 and MVS, AS/400, JCL

TECHNICAL SKILLS:

OPERATING SYSTEMS: HP-UX 10.x, 11.x, Sun Solaris 2.5, 2.6, 8, 9, 10, AIX 5.1, 5.2, IBM, Red Hat Linux RHEL 2.1, 3.x, 4.x and Windows 95/98/NT/2000/XP.

RDBMS: Oracle 21c,19c,12c,11g/10g/9i, Oracle 12c,11g & 10g Real Application Clusters (RAC), SQLServer2005.Oracle Streams, DB2

LANGUAGES: SQL, PL/SQL, Java, C, XML, UNIX Shell Scripting(KSH & SH).

SOFTWARE APPLICATIONS/ TOOLS: ORACLE 8.x/9i/10g, Recovery Manager (RMAN), Real Applications

Cluster (RAC), STATSPACK, ERWIN, Teradata, Clusters, Veritas Backup, Developer 2000, SQL Loader, TOAD 7.6/7.5, Oracle Enterprise Manager, GOLDEN Gate, Exadata X-2, X-3, X4-2,X5-2 BR tools, Data Warehouse, SAP, Rubrik

WEB TOOLS HTML, XML

EXPERIENCE:

Computershare, MA Jan 2023 – Till date

Sr. Oracle DBA/Lead

All High-Level activities, Perform the build, design and development of database Applications Migrations from Wells Fargo to Computer shares, Complete migrations of 30 db’s, working in Oracle 19c/20c, Oracle Real Application Clusters (20c,19c), Oracle Data Guard and Oracle RMAN, SQL, PL/SQL, Weblogic OEM, Weblogic Veridata, Rubrik, Multinet databases

Installs and upgrades at the infrastructure level.

Install RBMS and DBMS utility software.

Server Management & Engineering and Set up monitoring on file systems

Provide OS level support and patching support

Manage Server Access and Security

Managing OEM (12c,13c) at Enterprise level, including patching OMS servers.

Configuration of ODA machine and EXADATA X9

Working with client very closely also with Vendors

Excellent working capacity to dealing with client’s different customer

Configuring the Golden Gate and Replication active passive and active-active

Configuring the Dadaguard and Managing the Dadaguard issues.

Excellent experience in Performance tuning

Upgrading Grid Infrastructure 19C to 20c with node by node.

ORACEL Database Migration using Goldengate bi directional and Unidirectional

Weblogic configuration for the OMS and maintain along with OEM support

Weblogic configuration for the Veridata servers, Goldengate purposes and managing it.

Implementing monitoring and alerting for cloud infrastructure and services

Having knowledge of AWS/Azure/OCI/GCP and their managed database offerings CloudSQL/RDS/AzureSQL

Environment: Oracle 21c/19c, ORACLE Linux 7, OEM 13.5, RMAN, TOAD 12.1, SQL*Plus, PL/SQL, SQL*Loader,, ASM, RAC,CRS, DATAGUARD, WEBLOGIC 12, F5 Load Balancer, Exadat Servers, EMC storage, Golden Gate, MAA, IORM, DBRM, DBFS, DATAWARE HOUSE, KORN SHELL, BORN SHELL, Dataguard, Rubrick, GCP, OCI

American Express, Phoenix, AZ Aug 2014 – Jun 2022

Sr. Oracle DBA/Lead

All High-Level activities, Perform the build, design and development of database Applications

working in Oracle 19c,18c,12c/11G/10G, Oracle Real Application Clusters (10g, 11g, 12c,18c,19c), Oracle Data

Guard and Oracle RMAN, SQL, PL/SQL, Weblogic OEM, Weblogic Veridata, Mysql, Postgres

Installs and upgrades at the infrastructure level.

Install RBMS and DBMS utility software.

Server Management & Engineering

Set up monitoring on file systems

Provide OS level support and patching support

Manage Server Access and Security

Managing OEM (12c,13c) at Enterprise level, including patching OMS servers.

Configuration of ODA machine and EXADATA X5, X6, X7 and X8

Working with client very closely also with Vendors

Excellent working capacity to dealing with client’s different customer

Configuring the Golden Gate and Replication active passive and active-active

Configuring the Dadaguard and Managing the Dadaguard issues.

Excellent experience in Performance tuning

Upgrading Grid Infrastructure 12 to 19C with node by node with Dadaguard

Configured Dataguard over 120 TB db’s and migrated from ODA to Exadata Half/Full Rack machines.

Implemented American Express Oracle Cloud for Internal projects.

Migrating the Database from IBM Mainframe to ORACEL Database using Goldengate

Small size db’s configured in Postgres

Configure APEX Inventory system maintain and support

Weblogic configuration for the OMS and maintain along with OEM support

Weblogic configuration for the Veridata servers, Goldengate purposes and managing it.

Cassandra Database configuration No sql database’s

Using Terraform to provision and maintain infrastructure for software development teams

Supporting and Deploying Kubernetes (AWS Elastic Kubernetes Service) based applications

Implementing monitoring and alerting for cloud infrastructure and services

Having knowledge of AWS/Azure/OCI/GCP and their managed database offerings CloudSQL/RDS/AzureSQL

Environment: Oracle 19c, 18c, 12c, 11g R2 &10gR2, Linux AS 7/5, SQL Server 2005 OEM (Grid Control), RMAN, TOAD 12.1, SQL*Plus, PL/SQL, SQL*Loader, MS Visio 2010, Erwin 6.0, AWR, Explain Plan, ASM, RAC,CRS, DATAGUARD, WEBLOGIC 12/10, F5 Load Balancer, VMWare Servers, OEM 13c/12c, EMC storage, Golden Gate, MAA, IORM, DBRM, DBFS, DATAWARE HOUSE, ColdFusion, KORN SHELL, BORN SHELL, Dataguard, Postgress, Mysql, AWS,GCP, OCI

Lakeland Community College, Cleveland, OH Sep 2013–July 2014

Sr. Oracle DBA/Lead

Responsibilities:

Installation, configuration, maintenance and tuning of Oracle 12c OEM, 11gR2 and 10g on Red hat Linux 6.1 and Manage Dataguard, Replication, Backup and Recovery.

Expertise designing, creating, analyzing and documenting Relational and Dimensional data models with ERwin, Enterprise DW Frameworks, and Oracle RDBMS.

Excellent knowledge on servers infrastructure and communication with team.

Configuring and administering the Golden Gate replication tool for real-time data replication. Managing the configuration and data changes in between two data centers

Architect, Design and Configured Directional replication using GoldenGate 11.2 between three new production servers

Successfully Migrated the Solaris to RHEL and upgraded ORACLE 10g to 11.2.0.4 on RHEL 6.1.

Conducted Performance Review of Oracle Database for business critical applications

Generated Statspack/AWR reports from Oracle 11g/10g database and analyzed the reports for Oracle wait events, time consuming SQL queries, table space growth, database growth

Used Explain Plan, Oracle hints and creation of new indexes to improve the performance of SQL statements

Support the third party Vendor application Banner.

Architect / Design /Develop the Golden gate replication between the RAC systems.

SQL tuning and Database performance tuning has been done based on reports generated by SQL Trace, TKPROF, STATSPACK, Explain Plan, AWR, ADDM, ASH and monitor the database performance on daily basis.

Planning Backup/Restoration Strategy, Planning and scheduling Backups, taking Logical Backups (with Export/Import Data pump utilities).

Worked as a part of team in Data Center Migration project for 6 months.

I/O Resource management IORM and Database Resource management DBRM.

Creating & Managing Database Structures, Storage Allocations, Table/Index segments, Rollback segments, Constraints, Database Access, Roles and Privileges.

Creating and Managing the Data Warehouse Databases and applying patch PSU/CPU.

Experience in cloning RAC databases using RMAN tool.

Experienced in Design, implementation and generating documentation of Oracle 10g Data Guard on both physical/logical standby databases in high availability mode.

Implemented Data guard, creating both Logical and Physical Standby databases in 10g &11gRAC environment for the Production databases.

Switchover and Failover in Dataguard.

Validate and Crosscheck the RMAN backups.

Automated the nightly RMAN backups for the Production and Test Databases in Crontab.

Creating and Scheduling Oracle Backend Process Jobs in Crontab.

Cloning & duplicating databases using scripts as well as RMAN.

Creating Data Models using Erwin

Expertise in recovering the database. Performed complete recovery, data file recovery, incomplete recovery.

Experienced in Database Security User Management, Privileges, Roles, Auditing, Profiling, Authentication.

Applying security patches both Server side and Client side and Performed testing.

Worked closely with the Oracle developers for the better performance in Applications in writing the Packages, Triggers, Mat Views and Indexes on the tables.

Used Secure SCP & FTP extensively for the File transfers from machines to remote server.

Experienced in documentation, provided documentation for database design, analysis, modifications, creating schemas etc.

Implementation of Oracle & Application Software Patches and maintaining SW License and maintenance agreements.

Resolved TAR issues 24x7 while assisting the functional team and oracle support (Metalink) and managing database security.

Installed Middleware Weblogic, Java and Fusion Middleware, HTTP, HTTPS, OHS, SSH for the New Applications.

Knowledge on the WEBLOGIC and adding Servers/cluster ware to the new instances and JDBC connections and Coldfusion.

Applying patches to Banner application (Financial aid, Student, Web General, Faculty and Advisors Self-Service, Employee Self-Service, Student Self-Service, General, Human Resources, Financial Aid, Accounts Receivable, Web Tailor) and required patches to database also applied.

Excellent experience on writing unix Korn shell scripting (KSH).

Involved in meetings upgrade 10g to R12 and my inputs were given to client

Environment: Oracle 12c, 11g R2 &10gR2, Linux AS 5, SQL Server 2005 OEM (Grid Control), RMAN, Solaris, TOAD 12.1, SQL*Plus, PL/SQL, SQL*Loader, DBArtisian 8.7, MS Visio 2010, Erwin 6.0, AWR, Explain Plan, ASM, RAC,CRS, DATAGUARD, WEBLOGIC 10, Banner, F5 Load Balancer, VMWare Servers, OEM 12c, EMC storage, Golden Gate, MAA, IORM, DBRM, DBFS, DATAWARE HOUSE, ColdFusion, KORN SHELL, R12

AT&T, St. Louis, MO Oct 2012-Aug2013

Sr.Oracle DBA/ Lead

Vehicles tracking system is part of the U-Dash, Basically this system will tracks all vehicles for Installation or repair for each of the requested client and his location along with crew member who is his boss and reporting prospective.

Responsibilities:

Architect, Design and Configured Directional/Bi-Directional replication using GoldenGate 11.2 between three new production servers

Configuring and administering the Golden Gate replication tool for real-time data replication. Managing the configuration and data changes in between three data centers

Installation, configuration, maintenance and tuning of Oracle 11g and 10g on Red hat Linux 6.1 and Manage Dataguard, Replication, Backup and Recovery.

Expertise designing, creating, analyzing and documenting Relational and Dimensional data models with ERwin, Enterprise DW Frameworks, and Oracle RDBMS.

Successfully Migrated the Solaris to RHEL and upgraded ORACLE 11.1.0.7 to 11.2.0.4 on RHEL 6.1.

Conducted Performance Review of Oracle Database for business critical applications

Generated Statspack/AWR reports from Oracle 11g/10g database and analyzed the reports for Oracle wait events, time consuming SQL queries, table space growth, database growth

Used Explain Plan, Oracle hints and creation of new indexes to improve the performance of SQL statements

Created a purge script to remove more than one year old data

Disaster recovery of Dataguard Physical Standby.

Failover/Switchover/Loss of service/Rebuild/Corruption/Loss of datafile testing on Exadata full rack

Used for the SAP applications BR TOOLS Backup, Table Reorg, Tablespace, Instance etc.

Provide DBA implementation and support for SAP/Oracle migrations and upgrades, including environments using Oracle DataGuard.

Configured by directional replication using ORACLE Advanced Replication between three DB’s.

Acted as a lead for the offshore team at onsite. Managing the team and Estimates and Delivery on time.

SQL tuning and Database performance tuning has been done based on reports generated by SQL Trace, TKPROF, STATSPACK, Explain Plan, AWR, ADDM, ASH and monitor the database performance on daily basis.

Planning Backup/Restoration Strategy, Planning and scheduling Backups, taking Logical Backups (with Export/Import Data pump utilities).

Creating & Managing Database Structures, Storage Allocations, Table/Index segments, Rollback segments, Constraints, Database Access, Roles and Privileges.

Created UNIX scripts for monitoring the Golden gate replication status.

Maintained the Heart beat tables to check the lag between the sites.

Importing and exporting files, databases, schemas and tables using SQL* loader and utilities like Import, Export and Data Pump features of Oracle database.

Involved in designing and creating schema objects like Database tables, indexes, views, materialized views and synonyms

Checking of Alert log and Trace files to monitor the database on a daily basis. Also wrote monitoring scripts to check reports for space, Max. Extents, coalescing etc kept in CRONJOB.

Daily database administration tasks including backup and recovery through RMAN, Import/Export

Installed monitoring tools OEM, GRID CONTROLE for the 24x7 support.

Performed data transfer using Export/Import using command line as well as in interactive mode and through Data pump.

Used SQL*Loader to move data from flat files into an Oracle database.

Memory management on table spaces and data files.

Involved in Installation and configuration of Oracle 10g &11gRAC using Cluster ware and ASM.

24x7 remote support and on call Database support for Database developers & end-users.

Written shell Scripts for Goldengate to monitor the lag between SOURCE and TARGET using the KORN SHELL.

Worked with PeopleSoft Human Capital Management Application on Production, Development and testing servers with backend Oracle 11g Databases and used People Tools 8.48 and 8.49.

Environment: Oracle 11g R2, HP-UX 11.31, Linux AS 5, OEM (Grid Control), RMAN, Solaris, TOAD 10.6.0, SQL*Plus, PL/SQL, SQL*Loader, MS Visio 2010, AWR, ADDM, ASH, Explain Plan, Golden Gate, ASM, RAC, Exadata, SAP, DATAGUARD, BR TOOLS SAP, ERwin, Enterprise DW Frameworks, KORN SHELL, PEOPLESOFT.

HHSC (Health and Human services), Austin, TX Nov 2011- Oct 2012

Sr. Oracle DBA

Texas Integrated Eligibility Redesign System (TIERS) is an integral part of the Texas Health and Human Services Commission’s efforts to modernize its eligibility system. TIERS system is welfare, web-based system that integrates the application process for more than 50 health and human services programs. TIERS will link to two dozen government agencies to enhance data collection and save time. These interfaces will allow TIERS to retrieve extensive data, including birth certificates, credit information, number of school-age children in the household and information indicating if an applicant may have been sanctioned in the past for welfare fraud or may owe child support

Responsibilities:

Installation, configuration, maintenance and tuning of Oracle 11g and 10g on Red hat 5.0 and Manage Data Guard, Replication, Backup and Recovery on over 12 TB DB’s.

Successfully upgraded Oracle 10g (10.2.0.4) to Oracle 11g (11.2.0.4) on Solaris nodes.

Working experience on both OLTP/OLAP and Batch environments.

Disaster recovery of Exadata Dataguard Physical Standby.

Failover/Switchover/Loss of service/Rebuild/Corruption/Loss of datafile testing on Exadata half rack.

Worked as a part of team in Data Center Migration project for 6 months.

Daily database administration tasks including backup and recovery through RMAN, Import/Export

Installed monitoring tools OEM, GRID CONTROLE for the 24x7 support.

Performed data transfer using Export/Import using command line as well as in interactive mode and through Data pump.

Used for the SAP applications BR TOOLS Backup, Table Reorg, Tablespace, Instance etc.

Provide DBA implementation and support for SAP/Oracle migrations and upgrades, including environments using Oracle DataGuard.

Used SQL*Loader to move data from flat files into an Oracle database.

Memory management on table spaces and data files.

Involved in Installation and configuration of Oracle 10g &11gRAC using Cluster ware and ASM.

24x7 remote support and on call Database support for Database developers & end-users.

Having experience in setting up transparent data encryption (TDE) feature.

Experienced in implementing Oracle Database advanced security practices.

Implemented Golden gate replication between RAC and non RAC database environments.

Successfully configured and installed Oracle Golden Gate for replication.

Maintained the Heart beat tables to check the lag between the sites.

Worked with application team to resolve conflict handlers and trouble shooted the replication issues.

Experience in cloning RAC databases using RMAN tool.

Experienced in Design, implementation and generating documentation of Oracle 10g Data Guard on both physical/logical standby databases in high availability mode.

Implemented Data guard, creating both Logical and Physical Standby databases in 10g &11gRAC environment for the Production databases.

Writing and modifying UNIX shell scripts, Perl scripts to manage Oracle environments and for Backend Oracle Processes.

Installed Oracle Streams as an enhancement for the Client’s DW method and monitored Streams Issues using Grid Control.

Utilized Oracle Streams to capture, propagate, and apply the transfer of data, transactions, and events within managed databases.

Oracle streams configuration and performance tuning.

SQL tuning and Database performance tuning has been done based on reports generated by SQL Trace, TKPROF, STATSPACK, Explain Plan, AWR, ADDM and monitor the database performance on daily basis.

Planning Backup/Restoration Strategy, Planning and scheduling Backups, taking Logical Backups (with Export/Import Data pump utilities).

Creating & Managing Database Structures, Storage Allocations, Table/Index segments, Rollback segments, Constraints, Database Access, Roles and Privileges.

Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics for the same.

Performance tuning and diagnosing DBMS and individual Production databases. Organized various migration review meetings with the application team to discuss the migration strategy based on their requirements.

Performed policies on data confidentiality, integrity, availability, and auditability, Based on Access Controls for Access to Data at the database level.

Performed SQL and PL/SQL tuning, oracle contention and monitored production database using automatic workload repository (AWR), automatic database diagnostic monitor (ADDM) and automatic session history.

Logical and Physical Database Modeling using CA Erwin 4.1.

Automated the nightly RMAN backups for the Production and Test Databases in Crontab.

Creating and Scheduling Oracle Backend Process Jobs in Crontab.

Cloning & duplicating databases using scripts as well as RMAN.

Expertise in recovering the database. Performed complete recovery, data file recovery, incomplete recovery.

Experienced in Database Security User Management, Privileges, Roles, Auditing, Profiling, Authentication.

Applying security patches both Server side and Client side and Performed testing.

Worked closely with the Oracle developers for the better performance in Applications in writing the Packages, Triggers, Mat Views and Indexes on the tables.

Used Secure SCP & FTP extensively for the File transfers from machines to remote server.

Experienced in documentation, provided documentation for database design, analysis, modifications, creating schemas etc.

Implementation of Oracle & Application Software Patches and maintaining SW License and maintenance agreements.

Resolved TAR issues 24x7 while assisting the functional team and oracle support (Metalink) and managing database security.

Written shell Scripts for schema comparisons between SOURCE and TARGET using the KORN SHELL.

Environment: Oracle 11g R2 &10gR2, DB2, z/OS, HP-UX 11.31, Linux AS 5, AIX 5.3, SQL Server 2005 OEM (Grid Control), RMAN, Solaris, TOAD 10.6.0, SQL*Plus, PL/SQL, SQL*Loader, DBArtisian 8.7, MS Visio 2010, ERWIN 6.0, AWR, Explain Plan, Golden Gate, ASM, RAC, DATAGUARD,SAP, SAP BRTOOLS, KORN SHELL.

AT&T, Atlanta, GA Jan 2011 – Oct 2011

Sr. ORACLE DBA

IT MOBILITY CARE OPERATIONS AND PRODUCTION SUPPORT TEAM is to extend and integrate knowledge that contributes towards the improvement of the applications and to educate users with the latest information and also provides services from configuration to user assistance, system monitoring and also ongoing training and continuous improvement. Provided support for 16 Applications including 3 Mission Critical applications and implementing an internal tool for End-End Transaction Monitoring.

Responsibilities:

Responsible for all the DBA related jobs for all the instances; performance tuning, backup & recovery using RMAN, managing users, roles & privileges etc.

Design and develop efficient pl/sql packages/procedures/functions, configuration files, tables and views; implement best practices to maintain optimal performance.

Provide on call support to production system to resolve any issues.

Responsible for their day to day issues and processing’s of all databases, taking care of performance tuning of database.

Working experience on both OLTP and Batch environments

Used SQL*Loader to move data from flat files into an Oracle database.

Memory management on table spaces and data files.

Major contribution: Automatic gathering of all statistics (tables/indexes and application schemas)

Periodically rebuild indexes, archive and drop old partitions.

Configuring and administering the Golden Gate replication tool for real-time data replication. Managing the configuration and data changes in between Bothell and Windward data centers.

Coordinating with the PDBA team for the changes related to Golden Gate replicated tables and making appropriate changes at the target.

Managing the user control and security management

Adding users and removing privileges to the user by pre defied industry standards as per the HR systems.

Environment: Oracle 11g R2 &10gR2, HP-UX 11.31, Linux AS 5, AIX 5.3, SQL Server 2005 OEM (Grid Control), RMAN, Solaries, TOAD 10.6.0, SQL*Plus, PL/SQL, SQL*Loader, DBArtisian 8.7, MS Visio 2010, ERWIN 6.0, AWR, Explain Plan, Golden Gate, OIM, RAC, DATAGUARD

Express scripts, IBM, MN Jan 2010 to Dec 2010

Sr. ORACLE DBA

Responsibilities:

Involved in configuring two node RAC on 11gR1, oracle clusterware on Red hat Linux AS 5.

Configured server/client side load balancing.

Added node for the existing two nodes RAC and also configured the services.

Re design the existing database based on Business rules to overcome the existing issues in the Application and drawn Visio Diagrams to give high level presentation to Manger.

Involved in designing and creating database objects.

Created Partitions on large tables for easier manageability.

Performed day to day activities such as managing user privileges, tablespaces, file system, undo segments, temp segments and indexing.

Migrated single instance database to multiple instance database (RAC) using export/import, datapump.

Performed cross-platform migration (AIX to LINUX) using Transportable Tablespace (TTS).

Refresh schema using Export/Import. Creating the database, table spaces, tables, indexes, setting privileges And user logins

Working experience on both OLTP and OLAP environments

Utilized Oracle Enterprise Manager (OEM), Grid control to manage users, privileges, profiles, and schemas.

Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics for the same

Created Partitions on large tables for easier manageability

Extensive UNIX Shell scripting in csh, ksh.

Importing and exporting files, databases, schemas and tables using SQL* loader and utilities like Import, Export and Data Pump features of Oracle database 10g.

Involved in designing and creating schema objects like Database tables, indexes, views, materialized views and synonyms

Checking of Alert log and Trace files to monitor the database on a daily basis. Also wrote monitoring scripts to check reports for space, Max. Extents, coalescing etc kept in CRONJOB.

UNIX shell scripting in csh, ksh to be controlled from Crontab.

Security User Management, Privileges, Role, Auditing, Profiling, Authentication.

Tuning Oracle databases and tuning applications (SQL), for tuning SQL working closely with development Team.

Storage Management Managing Space, Table spaces, Segments and Extents, Rollback Segments & Data Dictionary.

Extensive Performance Tuning, Memory (SGA) Tuning, Net backup, EMC (Time finder and SRDF), RAID, RAW Devices.

Cloning databases using scripts as well as RMAN.

Deciding the naming conventions of data file, redo log files, table spaces, and segments.

Generation of the AWR (Automatic Workload Repository), ADDM, ASH Reports and using them for tuning the database.

Managing the user control and security management

Adding users and removing privileges to the user by pre defied industry standards as per the HR systems.

On call support 24/7

Environment: Oracle 11g R1 &10gR2, HP-UX 11.31, Linux AS 5, AIX 5.3, SQL Server 2005 OEM (Grid Control), RMAN, Solaris, TOAD 9.7.2, OIM, RMAN, SQL*Plus, PL/SQL, SQL*Loader, DBArtisian 8.7, MS Visio 2010, ERWIN 6.0, AWR, Explain Plan, RAC

State Street, Boston, MA Feb 2007 to Dec 09

Sr. ORACLE DBA

Responsibilities:

Involved and Configured Oracle 11g database instance running across two oracle RAC nodes on Red Hat Linux AS 4 Server

Setting up the primary and physical Standby databases for disaster recovery using Oracle Data Guard and successfully conducted switchover operation as part of planned outage

Creating and defining redo log files and undo tablespaces for RAC environments

Used start schema for approaching for designing of Data warehouse design

Performed upgrades from Oracle 9.2.0.8 to 10.2.0.3 on Linux and AIX Boxes.

Installed and created 10g databases and 10g OEM.

Designed Star data mart for their clients using Visio and translated business requirements into it and implemented logical design physically into Oracle Database

Installed Oracle Grid Control and monitored Streams Issues using Grid Control.

Refresh schema using Export/Import. Creating the database, table spaces, tables, indexes, setting privileges And user logins

Configuration, maintenance and tuning of Oracle 9iRAC and 10gRAC.

Configured Failover Database using Datagaurd for Streams Database.

Performed Network Traffic Tests for Streams.

Configured Streams setup from HP-UX boxes to SUSE Linux Boxes.

Installing and configuring Recovery Manager (RMAN).

Extensive Performance Tuning, Memory (SGA) Tuning, Net backup, EMC (Time finder and SRDF), RAID, RAW Devices.

Cloning databases using

Contact this candidate