PROFESSIONAL SUMMARY:

• Oracle DBA IT experience managing products Oracle 8i/9i/10g/11g/12c in Production, Test & Development environments.
• Installed and maintenance of ORACLE 11g RAC 2 node cluster database for high availability
• Experience in very large scale database environment and mission critical OLTP and OLAP systems
• Experience in configuring, managing and monitoring ASM for standalone database and RAC database.
• Experience in Korn Shell scripting.
• Expertise in Alert Monitoring and Ticketing.
• Strong Trouble - shooting, Problem solving, Analytical & Design Skills.
• Experience in Installation, Configuration and Re-Configuration of Oracle Database on Solaris OS, Red hat Linux and Windows servers.
• Extensive experience In Siebel Administration, Root Cause Analysis and trouble shooting.
• Monitoring and scheduling jobs for all the databases using latest OEM 12c cloud control
• Expertise in SQL and PL/SQL programming.
• Working on a project using elastic search to extract security data from APIs, process Skills the data as per client's rules and visualize them using Kibana.
• Strong Knowledge and Understanding of upgrading and implementing OBIEE 11g.
• Experience in Installation and Configuration of OBIA, including Informatica, DAC and OBIEE.
• Administered DB2 Z/OS for v 9.x/8.x/7.x/6.x on IBM mainframe and AIX DB2 environments.
• Expertise in Administration and scheduling jobs in Control-M Enterprise Manager versions 6.3, 6.4, 7.0 and 8.0.
• Proficiency in analysis, design, development, testing, implementation and maintenance of applications in Oracle Application Express (APEX) and client/server configurations. I was involved in Maintaining critical interfaces with MMIS NCTRACKS using Curam batch framework - Curam V6
• Experience in Upgrading E-Business Suite releases … to R12.2
• Patch analysis and management using ADOP, ADPATCH, OPATCH, Patch Wizard utilities for Oracle E-Business Suite releases
• Worked as Couchbase DBA/Architect for Customer Experience Portal and Sales Portal.
• Created a separate Couchbase Database 3-node cluster to store flight control data log information and administered.
• Installed Multi-Node E-Business Suite 12.2 release for NON-RAC databases
• Thorough understanding of how the Curam batch works for Recipient File and also Provider Mass Change Process.
• Developed database objects such as stored procedures, packages, functions, schemas, tables, objects, indexes.
• Written complex Oracle SQL queries with complexity using Inner/Outer joins, Indexes, Sequences, Union All, Intersect & Minus set operators.
• Experience in setting up Golden Gate and deep knowledge and understanding about Advance Golden Gate.
• Excellent working experience on Golden Gate Installation and Migration.
• Application and database hosting and migration of services to Amazon Web Services (AWS)
• Automating cloud infrastructure AWS Lambda and Dynamo DB.
• Worked on few of AWS Services like RDS, EC2, SQS and SES.
• Designed application framework and developed Oracle APEX Application.
• Knowledge of data encryption (transparent encryption), data-at-rest, and unstructured data protection, Key Management Solution (KMS).
• Designed and implemented a new database for Automation, developed multiple procedures.
• Worked at various levels right from capacity planning, procuring hardware through ISP to setting up required components to successfully run Fusion Middleware.
• Experience in upgrading Database using DBUA, Manual Upgrade and export/Import
• Good understanding in Data Marts and data warehousing concepts (OLTP & OLAP )
• Responsible for Installing, configuring, patching of Oracle WebLogic server, Identity and Access Management Suite and Oracle HTTP Server as Stage, Development & Production Environments..
• Experience working with Oracle Streams and Change Data Capture (CDC).
• Installed oracle 12c databases and 12c cloud control on Linux Server.
• Designed and developed components using Python with Django framework. Implemented code in python to retrieve and manipulate data.
• Used Mysql as backend database and Mysqldb of python as database connector to interact with Mysql server
• Administration of Control-M users via Control-M Security
• Managing CONTROL-M Servers/agents using CONTROL-M/Configuration Manager
• Experience in installation and configuration of oracle Log miner.
• Working experience in implementing Oracle RAC and Data Guard on Windows 2012
• Worked on the physical and logical designing of the database
• Administered DB2 Z/OS for v 9.x/8.x/7.x/6.x on IBM mainframe and AIX DB2 environments.
• Support and Administer Db2 Queue replication between DB2 Z/OS and distributed environments
• Implemented Test Automation program for Oracle 11g applications.
• Administrated database of various sizes ranging from 40GB to 3TB.
• Experience in Design, Creating and Maintaining the Oracle Database.
• Managed and maintained Oracle and NoSQL databases in production domain.
• Experience in Performance SQL Tuning of SQL statements and Database using tools like Explain plan, TKPROF, SQL developer, PL/SQL developer, SQL Analyze, UTLBSTAT, UTLESTAT, STATSPACK, AWR, ASH, ADDM Reports
• Experience in Online and Offline backups and recovery.
• Experience in upgrading the JDA 3rd party software (Demand Planning and Fulfillment) from Rls 7.42 to 8.20
• Coded SQL/PL-SQL, SQL* Loader and Korn Shell scripts for high volume data warehouse instances.
• Experience in JBoss and SVN
• Experience in constructing the triggers, tables, collections, functions, user defined data type, procedures etc.
• Working Experience with Perl environment.
• Support JDA SCPO application
• Installed ODI. Set up the ODI connection with Oracle, flat files.
• Experience in backups and recovery using RMAN and Scripts.
• Experience in using RMAN with and without Catalog database.
• Configuring a flash cache in an Oracle Real Application Clusters environment.
• Experience working with data pump to move data from prod to Dev & test environments
• Taking Physical & Logical backups using RMAN and Data pump utilities
• Proficient in Oracle utilities and tools (Export, Import, SQL*loader, PL/SQL, OEM, TOAD, SQL Developer) .
• Expertise in Database control as well as Grid control.
• Provided Oracle DBA support, backup and restore, performance monitoring and SQL tuning; Experience of using Oracle Enterprise Manager (OEM), Grid Control, and Data Guard.
• Worked as a part of team in 24x7 production environment and provided on-call day-to-day support.

TECHNICAL SKILLS:

Operating Systems: Windows 2003/2007/2008/ XP/VISTA, Linux, UNIX, Solaris, IBM-AIX,HP, RHEL ES/AS/4/5, Db2 Z/OS

Database: Oracle 9i/10g/11g/12c, MS Server 2008/2012/2014 and Enterprise DB

Programming languages: SQL and Oracle PL/SQL.

Database Tools: PL/SQL Developer,DB2, PgAdmin, SQL*Plus, TOAD, OEM, Microsoft Visual Source Safe, SVN, Putty, WinScp, SQL Loader, Oracle Golden Gate Repository database, Fusion Middleware, Web logic, Curam V6

Utilities: UTL FILE, DBMS PIPE, Exp, Imp and Data pump, RMAN, TKPROF, pg dump, BMC utilities,OMEGAMON

Web Technologies: PSP (PL/SQL Server Pages), HTML

Script Languages: UNIX, Korn Shell Scripting, Perl Scripting, Python

Others: Oracle Data Integrator (ETL Tool), MS Visio, Alfresco, Life ray, Object Oriented Designing Methodology, RDBMS Concepts, Transparent Data Encryption(TDE), Transparent Network Substrate.AWS

PROFESSIONAL EXPERIENCE:

Oracle DBA

Confidential, Burbank, CA

Responsibilities:

• Installed Configured and maintained 2 node 11.2.0.3/12 c RAC databases in Linux/Solaris Server.
• Configured oracle Active-Active (Bi-directional) golden gate replication and setup CDR.
• Upgraded oracle golden gate from 11.2.1.0.3 to 11.2.1.0.25 version.
• Oracle Migrations without down time using Oracle Golden gate 10g TO 11 g Cross platforms.
• Responsible for installing and configuring Golden Gate on Oracle Servers.
• Involved in the Migration projects by using Data pump and RMAN utilities.
• Configured CDC Process to have minimal performance impact on source database.
• Performing Transition activities for Non-Mainframe DB2 Database Servers and basic administration activities of Oracle database.
• Server system Admin - release deployments, Patch apply (Siebel 8.1.1.10) for IE8 compatibility
• Implemented CDC Process to capture all effects of insert, update, and delete operations including data values before and after update operations.
• Installation , Configuration & Deployment of Oracle E- Business Suite 11i/R12 .
• Applying CPU and PSU patches for all the development and UAT servers when required
• Configured 11g Physical standby RAC databases.
• Worked efficiently on OLAP Data Warehouse, Design, Model and Implementation.
• Excellent experience in using Data pump utility for refreshing databases
• Designed and developed components using Python with Django framework. Implemented code in python to retrieve and manipulate data.
• The work included installation of database software like Couchbase
• The work involved Configuration and installation of Couchbase 2.5.1 NoSQL instances on AWS EC2 instances day to day monitoring and maintenance of couchbase clusters in Production
• Coding of the business layers in Curam framework
• Used Mysql as backend database and Mysql db of python as database connector to interact with Mysql server
• Understanding the OLAP processing for changing and maintaining the Warehousing, Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Extensive experience in OBIEE Administration Tool, OBI Answers, OBI Intelligent Dashboards, OBI Publisher, Delivers and agents with OBIEE Applications.
• Upgraded E-Business Suite from 12.2.0 to 12.2.4.
• Installed and Configured 11g Discoverer and WebLogic Products
• Installation and configuration of Oracle EBS R12.2 and Oracle database 11g and 10g on Amazon AWS servers.
• Experience in developing Model, server and client Application in Curam
• Developed OBIEE Repository and implemented the business logic by creating Tables, Level based metrics, Dimensional Hierarchies, Aggregate Navigation, Level Based Measures, etc.
• Performed the performance tuning of the OBIEE application by following the Oracle Guidelines for the Out of the Box Reports to meet the SLA for all the reports.
• Implemented Oracle RAC and Data Guard on Windows 2012.
• Implemented and configured Elasticsearch, Logstash and Kibana on AWS Cloud, collecting system and user logs for data analysis and visualization.
• Automating cloud infrastructure AWS Lambda and Dynamo DB
• Design and administer complex database clusters on virtual, physical and AWS servers.
• Application and database hosting and migration of services to Amazon Web Services (AWS)
• Worked at various levels right from capacity planning, procuring hardware through ISP to setting up required components to successfully run Fusion Middleware.
• Successfully run Fusion Middleware
• Created various dashboard on Kibana for the purpose of monitoring. Resolving real customer Incidents within the given SLA.
• Excellent skills in Designing and Development of applications using SQL, PL/SQL, Oracle Database 11g, 10g.
• Worked with data transformations and loading using Export/Import file packages and SQL* Loader and also created external tables to manage data which is stored at the operating system.
• Administered DB2 Z/OS for v 9.x/8.x/7.x/6.x on IBM mainframe and AIX DB2 environments.
• Sound knowledge on JAVA to troubleshoot and understand the components of all middleware components.
• Designed and implemented a new database for Automation, developed multiple procedures.
• Monitoring and managing more than 12,000 jobs running in six different Control-M Servers
• Involved in the migration of huge databases of sizes ranging from 100GB to 7TB
• Experience in Migration from NON-ASM databases to ASM database.
• Responsible for Installing, configuring, patching of Oracle WebLogic server, Identity and Access Management Suite and Oracle HTTP Server as Stage, Development & Production Environments.
• Apply latest PSU and one-off patches on Oracle FMW 11g & WebLogic Server.
• Performed SYSADM and Production DBA function for all DB2 subsystems and applications. Resulted in a stable environment for a company with a 24X7 uptime requirement.
• Coordinating with Unix/Wintel team while performing activities related to Control-M
• Installed of log miner procedures to capture the database transactions.
• Proficiency in analysis, design, development, testing, implementation and maintenance of applications in Oracle Application Express (APEX) and client/server configurations.
• Designed application framework and developed Oracle APEX Application.
• Performed Troubleshooting of database using AWR and ADDM reports for 11g databases.
• Configured RMAN backup jobs for newly built databases.
• Supported JDA Enterprise Planning (EP) implementation.
• Upgraded the Couchbase from 4.5.1 to 5.1.0 in UAT environments
• Assisted in JDA Assortment Planning Business design.
• Knowledge of data encryption (transparent encryption), data-at-rest, and unstructured data protection, Key Management Solution (KMS).
• Re-designed and documented processes to prepare for re-implementation of JDA MMS enterprise application.
• Support JDA SCPO application providing custom solutions to JDA framework,
• Experience in upgrading the JDA 3rd party software (Demand Planning and Fulfillment) from Rls 7.42 to 8.20
• Managing CONTROL-M Servers/agents using CONTROL-M/Enterprise Manager versions 6.4 - 9
• Respond to callers'/customers' queries on Control-M basics and concepts.
• Upgraded oracle Grid Control 11g to Oracle Enterprise Manager 12c.
• Installed Golden Gate server 11.2.1.0.6 and in implementation of GG initial-loads, Uni-directional replication.
• Building new databases and schemas from the scratch for new projects/application on Linux and UNIX boxes.
• Expert in transforming complex business logic into Database Design
• Worked on the physical and logical designing of the database , which includes the distribution of data- files on different disks
• Developing logical and physical data models using No-SQL.
• Configure firewall traffic restriction using SQL*Net and TNS Listener configuration.
• Designed and developed NoSQL solutions for all users.
• Managed and administered all NoSQL database systems.
• Administered DB2 Z/OS for v 9.x/8.x/7.x/6.x on IBM mainframe and AIX DB2 environments.
• Support and Administer Db2 Queue replication between DB2 Z/OS and distributed environments
• Suggested latest upgrades and technologies for NoSQL databases.
• Evaluated system performance and validated NoSQL solutions.
• Managed and maintained Oracle and NoSQL databases in production domain.
• Cloned databases and schemas using data pump for 10g and 11g versions.
• Cloned 10g and 11g databases using RMAN Duplication.
• Worked on Golden gate to setup unidirectional replication on 4 node RAC database.
• Worked with Oracle Support and performed root cause analysis for critical issues.
• Worked on multiple projects and delivering projects within timeline.
• Supported Perl Oracle Web UI for customer account representatives.
• Responsible to provide 24 x 7 database administrative activities over different database servers.

Environment: Oracle 11.2.0.3/12 c,RHEL 4.x, Solaris 10,Window 2008, Oracle Enterprise Manager Database Control, RDBMS, TOAD, PL/SQL, AWS, Python, DB2, Korn Shell Scripting, Stored Procedures, OLAP, ASM, Data guard, Curam V6.

Oracle DBA

Confidential, Rhode Island

Responsibilities:

• Experience in Design, Creating and maintaining Oracle Databases 10g and 11g from the scratch on UNIX, LINUX, AIX and WINDOWS environments.
• Handled critical tickets and escalations (Incident & Change Requests) as per the service level agreement using BMC remedy and JIRA Tool.
• Migrated 11g databases to different server using golden gate with minimal down time.
• Installed 10g & 11g 2 Node RAC & cluster ware installation on RHEL 5/6.x server.
• Successfully implemented physical standby database using Oracle Data guard and Active Data guard feature for High availability configuration.
• Install and configure Siebel Enterprise Servers and Web-Plugin (SWSE) for multi-lingual Arabic on multi-clustered heterogeneous VM platform.
• Performed SYSADM and Production DBA function for all DB2 subsystems and applications. Resulted in a stable environment for a company with a 24X7 uptime requirement.
• Participated in setting up of oracle streams for reporting database
• Audited application SQL code with DB2 Explain prior to production implementation
• Designed, created, and maintained DB2 database objects
• Automating cloud infrastructure AWS Lambda and Dynamo DB
• Worked on few of AWS Services like RDS, EC2, SQS and SES.
• Leveraged AWS cloud services to build secure, highly scalable and flexible systems
• Implemented Test Automation program for Oracle 11g applications;
• Upgrade Fusion Middleware 11g Components and WebLogic Server from base version to the latest patch-sets.
• Responsible for Load balancing and Performance tuning for various WebLogic server Instances of Oracle Fusion Middleware stack.
• Golden Gate troubleshooting using Log miner
• Knowledge of the Oracle Golden Gate installation, configuration, troubleshooting GG issues.
• Installed and configured Elastic Search and created the index references to Couchbase buckets for replication through XDCR used ansible tool to deploy the software on couchbase nodes.
• Upgraded the Couchbase from 2.5.1 to 2.5.2 and 3.0.1 in UAT environments
• Working as Lead Engineer on multi-year program to implement transparent data encryption(TDE)
• Implemented transparent data Encryption (TDE). Used TDE with Encrypted columns and Data Pump.
• Developed and customized scripts to monitor the health, functioning and performance of standby databases.
• Efficiently carried out DBA responsibilities in planning DB2 version migration activities, in migration phases and in performing post migration tasks
• Validate OR test database HA and COB solutions and automatic application failover ensuring proper TNS connection string, DB services or configuration is used
• Worked with ETL Tool.
• Production Support and Maintenance of Oracle E-Business Suite R12
• Installation and configuration of Oracle WebLogic Server 10.3.6 and integrating with the oracle database 11g on Linux.
• Upgrading Oracle EBS applications from 11.5.10.2 to R12.2.4 on Solaris Operating System
• Implemented OBIA Out of the Box Sales, Procurement and Marketing using Oracle EBS Informatica, DAC, OBIA and OBIEE 11g
• Installed, Configured and Upgraded OBIA and OBIEE and resolved the issues across the environments.
• Involved in migrating all data from legacy application to Oracle Apex environment.
• Expertise in developing front end screens using Oracle
• Responsible for developing interactive Reports, data entry forms, hypertext linked reports using Oracle APEX 5.0.
• Implemented Oracle APEX API'S such as APEX ITEM, APEX MAIL, APEX COLLECTION, APEX APPLICATION, APEX PLSQL JOB and APEX UTIL.
• Identified manual tasks and developed Python scripts as a part of automation which eventually saved 30 hrs. of monthly resource tasks and also made the system robust and error prone.
• Working experience in implementing Oracle RAC and Data Guard on Windows 2012
• Experienced in database security management
• Developed database objects such as stored procedures, packages, functions, schemas,tables,objects, indexes.
• Written complex Oracle SQL queries with complexity using Inner/Outer joins, Indexes, Sequences, Union All, Intersect & Minus set operators.
• Used Python and Django creating graphics, XML processing of documents, data exchange and business logic implementation between servers.
• Sending oracle Golden gate Trail files from Linux to AIX server for reporting purpose
• Created entire application using Python, Django, MySQL and Linux.
• Involved in working with Python open stock API's.
• Fixed Memory issues like OPMN memory leak. Analyzed the memory usage for WebLogic with third party tools
• Involved in Performance tuning of WebLogic server with respect to heap, threads and connection pools
• CONTROL-M Server/Agent monitoring and troubleshooting issues found
• Expertise in Standalone TEST database built and running with a copy of SWISSLOG from WMS site
• Creating templates and developing notification methods in OEM to support monitoring functionality for oracle databases and database/application servers
• Involved in the migration of huge databases of sizes ranging from 100GB to 7TB
• Daily Health Check Up of the Database and SQL Queries using 12c OEM, AWR, ADDM,ASH and TKProf
• 12c OEM agent upgrade on RAC databases
• Performed Schema and Table level Replication using Oracle Streams.
• Working experience with JBoss and SVN
• Creating Calendars and uploading same in Control-M Server Database.
• CONTROL-M Jobs monitoring, job flow analysis and troubleshooting
• Building new databases and schemas from the scratch for new projects/application on Linux and UNIX Boxes.
• Used Database Configuration Assistant (DBCA), Database Upgrade Assistant (DBUA) for upgrading Oracle10gR2 to the latest Oracle 11gR2 and applied patches as required.
• Regular schema, table and database refreshing from production to development, UAT and SIT environments using RMAN and data pump utility.
• Setup oracle streams for replication of selected tables
• Assisted in the development of Logical database design
• Designed the Physical data model
• We used LogMiner to calculate table Access Statistics.
• Cloned database and schemas using Data pump for 10g and 11g versions.
• Cloned 10g and 11g databases using RMAN duplication(with and without backup)
• Configured Oracle Data guard(ADG) for Oracle Disaster recovery on standalone databases using 11g ACTIVE DUPLICATION
• ASM Disk storage and user Management
• Worked on the Oracle RAT for managing the performance solutions.
• Performance SQL Tuning for the SQL queries by scrutinizing long running sql queries
• Worked on Golden gate to setup unidirectional replication on 4 node RAC database.
• Generated Email notification for users using Perl.
• Responsible to provide 24 x 7 database administrative activities over different database servers.

Environment: Oracle Enterprise Manager Database Control, RDBMS, TOAD, PL/SQL ASM Disk storage Korn Shell Scripting, Fusion Middleware, DB2, AWS, Stored Procedures, 12c OEM, AWR, ADDM, ASH and TKProf

Oracle DBA

Confidential, St. Louis, MO

Responsibilities:

• Installation, configuration, and maintenance of Oracle 11gr2 on AIX 5.3 and AIX6.1.
• Responsible for setup and implementation of 2 node RAC on Oracle 11g.
• Configured ASM with high redundancy for high availability in RAC databases
• Responsible to provide 24 x 7 database administrative activities over different database servers
• Implemented and managed Oracle Data Guard on Oracle 10g and 11g for Disaster Recovery.
• Upgrading Oracle 10gr2 to the latest Oracle 11gr2 using Manual and DBUA methods
• Implemented oracle GOLDENGATE one-way replication on Oracle database 11.2.0.2
• Monitoring golden gate LAG from source to target using 12c OEM
• Used Oracle Transparent data encryption(TDE) to encrypt table and tablespace that contain PII data.
• Installed 12c database in Development environment as part of POC work
• Audited application SQL code with DB2 Explain prior to production implementation
• Designed, created, and maintained DB2 database objects
• Responsible for setting up Oracle Golden Gate to help in propagating information between databases.
• Working continuously captures and deliver changed data in real time between source databases and the Teradata warehouse.
• Golden Gate troubleshooting using Log miner
• Knowledge of the Oracle Golden Gate installation, configuration, troubleshooting GG issues
• Created the plan for automation of all the tasks involved with validation steps
• Creating Calendars and uploading same in Control-M Server Database.
• Configured database system security using Virtual Private Database (VPD), user profiles, data encryption using DBMS CRPTO and firewall traffic restriction using SQL*Net, TNS Listener configuration, remote hosts configuration, and listener ports configuration.
• Monitored the performance using the Couchbase Web console and REST APIs (cbstat tool).
• Worked with Couchbase support team for sizing the Couchbase cluster
• Evaluated system performance and validated NoSQL solutions.
• Participated in setting up of oracle streams for reporting database
• Developed OBIEE Repository and implemented the business logic by creating Tables, Level based metrics, Dimensional Hierarchies, Aggregate Navigation, Level Based Measures, etc.
• Performed the performance tuning of the OBIEE application by following the Oracle Guidelines for the Out of the Box Reports to meet the SLA for all the reports.
• Experience in Upgrading E-Business Suite releases … to R12.2
• Patch analysis and management using ADOP, ADPATCH, OPATCH, Patch Wizard utilities for Oracle E-Business Suite releases
• Installed Multi-Node E-Business Suite 12.2 release for NON-RAC databases
• Trouble shooted the ODI connection with oracle by fixing the tnsnames.ora file, TNS listener and DNS entries
• Expertise in working with development tools like SQL developer
• Experience in implementing Oracle RAC and Data Guard on Windows 2012
• Developed APEX 5.0 Dynamic Actions to enrich the user experience, minimize user interaction and reduce key strokes. Apex, SQL and PL/SQL.
• Monitored AWS environment using Cloud Watch and used Amazon Kinesis to analyze real-time streaming data
• Developed AWS lambda functions using python and used python to automate daily tasks
• Formulated SQL queries, functions and processes as per customization requirement for APEX.
• Supported APEX applications and conducted performance tuning for PL/ SQL.
• Expertise in Standalone TEST database built and running with a copy of SWISSLOG from WMS site
• Applying CPU and PSU patches for all the development and UAT servers when required
• Developed DDL & DML SCRIPTS and applied in the production database during production releases
• Experience in Administering Oracle Database 10g and 11g using Oracle Enterprise Manager (OEM), Toad, SQL Developer and PL/SQL Developer.
• Skilled in using collections in Python for manipulating and looping through different user defined objects
• Used Test driven approach for developing the application and Implemented the unit tests using Python Unit Test framework.
• Responsible for Daily Health Checks and Support for (WebLogic,Fusion Applications & OEM )
• Performed (RPD & Catalog) Deployment for Financial Analytics Fusion Edition
• Daily Health Check Up of the Database and SQL Queries using Statspack, AWR, ADDM and TKProf.
• Configure and manage RMAN backup and recovery Created User accounts, Roles and granting required access permissions and privileges to the database based on the applications they are accessing.
• Worked on the physical and logical designing of the database , which includes the distribution of data- files on different disks
• Responsible for Installing, configuring, patching of Oracle WebLogic server, Application Developer and Database as Production Environment
• Built Two Node Cluster Setup for WebLogic and Application Developer
• Implemented and Monitored Data Guard on Oracle 10g.
• Used Database Configuration Assistant (DBCA), Database Upgrade Assistant (DBUA) for migrating Oracle 10gR2 to the latest Oracle 11gR2 and applied patches as required.
• Export and import of database objects using traditional export/import and Data pump utility.
• Cloning of schemas, objects and data on new server using RMAN and Data pump utilities
• Table partitioning to improve performance and I/O access.
• Involvement in space management, rectification of lock problems, user management.
• Data Refreshes from Production to test and Development environments using RMAN or Data Pump
• Alert log monitoring every day in all non-production environments.
• Performed replications using Oracle Streams.
• Performance SQL Tuning for the SQL queries which are running slow and taking more CPU cost.
• Creation of database objects like Tables, Indexes, Views, Users, and DB Links etc.
• Scheduled Oracle Jobs and Backups using CRONTAB and OEM.
• Experience in moving the data from one server to another server using SFTP,FTP and SCP
• Restoration and Recovery of databases at the times of occurrence of critical failures
• Experience in Online and Offline backups and recovery.
• Expertise in Standalone TEST database built and running with a copy of SWISSLOG from WMS site
• Experience in backups and recovery using RMAN and Scripts. good knowledge on STREAMS Replication

Environment: Oracle 10.1.0.4/10.2.0.4/11 g R1 and R2, RHEL 4.X,5.X, Oracle Enterprise Manager Grid Control, OEM Database control, PL/SQL, Fusion Middleware, Weblogic, AWS, Korn Shell Scripting, Stored Procedures, TOAD, ODI, Oracle Streams and all Oracle Tools.

Oracle DBA

Confidential, New York, NY

Responsibilities:

• Installation, Configuration of oracle 10g on RHEL 4.x
• Configuration and maintenance of a Two node RAC on Oracle 10g
• Configuration of ASM with normal and external redundancy.
• Restoration of databases from Critical failures.
• Responsible for scheduling backups.
• Taking Incremental backup using RMAN.
• Responsible for refreshing and cloning of databases per customer requirements using RMAN, Data Pump, and hot backup scripts
• Creating and maintenance of databases using DBCA and manual scripts.
• Configured and implemented Oracle Streams (Advanced Replication) for high availability.
• Performed Schema and Table level Replication using Oracle Streams.
• Tuning performance using Advisors, AWR, ADDM, SQL tuning etc.
• Setup oracle streams for replication of selected tables
• Upgrading databases from 10.0.1.0 to 10.0.4.0 using Patch sets.
• Alert monitoring and Ticketing.
• Administered DB2 Z/OS for v 9.x/8.x/7.x/6.x on IBM mainframe and AIX DB2 environments.
• Support and Administer Db2 Queue replication between DB2 Z/OS and distributed environments
• Implementing backup procedures and jobs using Crone Tab.
• Performed activities such as Query Optimization, Database Consistency Monitoring.
• Creating roles and granting privileges to the users.
• Expertise in Standalone TEST database built and running with a copy of SWISSLOG from WMS site
• Responsible for planning, testing and implementing different backup and recovery strategies.
• Scheduling Oracle Jobs in the database.
• 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.

Environment: Oracle 10.2.0.3/11.1.0.6/.7, RHEL 4.x, Solaris 10,Window, Oracle Enterprise Manager Database Control, RDBMS, TOAD, PL/SQL, Korn Shell Scripting, Stream, Stored Procedures, ASM, Data guard.

Oracle DBA

Confidential

Responsibilities:

• Oracle Database software installation, Instance creations, schema creations.
• Supported different Databases like Production, Development, Testing, and Data warehouse.
• Upgraded Databases from Oracle 9i to Oracle 10g on Solaris.
• Installed and Configured of Oracle OEM (Oracle Enterprise Manager) Grid Control and OEM Database Control to monitor database.
• I was involved in Maintaining critical interfaces with MMIS NCTRACKS using Curam batch framework - Curam V6
• Thorough understanding of how the Curam batch works for Recipient File and also Provider Mass Change Process.
• Created and Managed users, user profiles, table spaces, data files, archive log.
• Created database links that are required for databases.
• Experience in Data conversion using RMAN in the migration process of Oracle databases in Cross platforms.
• 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
• Created physical standby database and worked with data guard to provide Disaster Recovery.
• Performed troubleshooting of database using AWR and ADDM reports.
• Extensively used SQL LOADER as a tool for loading data.
• Performed replications using Oracle Streams.

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