Oracle Developer

RESUME

PERSONAL DETAILS:

NAME

:

SATHEESHKUMAR PACHIAPPAN

ADDRESS

:

#**, ******* ******, **********, ************-(PO), SALEM-(DT), TAMILNADU, INDIA-637501.

NATIONALITY

:

INDIAN

CURRENT OCCUPATION

:

Oracle DBA Module Lead

EDUCATIONAL BACKGROUND

(YEAR OF PASSING)

:

SSLC GENERAL (2002)

HSC SCIENCE (2004)

B.C.A (2007)

M.CA.(2010)

PANCARD NO

:

DJLPS7438P

D.O.B

:

25/07/1986

EMAIL ID

:

************.******@*****.***

CONTACT NO

:

+91-812******* / +91-962*******

SKILL SET:

IT Certifications:

Certification

Oracle10g OCE RAC DBA

Oracle10g OCP DBA

Oracle10g OCA DBA

Technical Skills:

Category

Name

Database tools Software

Oracle SQL Developer, Oracle SQL PLUS, Toad, Red Gate, Oracle Enterprise Manager database console.

DataBase Software

Oracle11g R2 and all lower versions until 8i, SQL server, MySQL, MS Access.

Operating Systems

Windows XP, Windows 7,Windows 2k3 Server r2, 2k8 Server r2,Windows 2k12 Server r2, RHEL 5.x,RHEL 6.x, OEL 5.x,OEL6.x and other Linux,AIX Versions.

IT EXPERIENCE / EXPERIENCE SUMMARY:

Company Name: Tech Mahindra Ltd Duration: Jul 2016 - PRESENT

CLIENT: Volvo Cars Corporation, LOCATION: Sweden.

Role: Oracle DBA- Module Lead (U4).

Oracle DBA Lead:

Volvo Cars Corporation is a Sweden based Automobile Manufacturing Company and One of Leading Top company in the Automobile Industries, providing a range of multi variant higher end cars, heavy vehicles, trucks …etc. They have many production and supply units, sales office in around the world wide. Supported as an Oracle DBA implemented and installed Oracle 12c R2&R1 and 11g R2&R1,10g R2&R1 databases and Upgraded to 12c R1 & 12c R2/11g R2 and thus provided 24*7 Production support.

Responsibilities:

24x7 Production Oracle Database Administration.

Maintaining production, development& test databases and Oracle Application server.

Configured, created and Managed Oracle Data Guard databases.

Installed and Managed Oracle Database 10g R1&R2,11g R1&R2,12c R1&R2.

Upgraded Oracle Database 10g R2 to Oracle Database 11g R2 (11.2.0.4.0) and 11g R2 (11.2.0.4.0) to 12c R1&R2.

Rolling upgraded Data Guard Primary and Standby database from Oracle 11g R2 to 12c R1/R2 with minimal down time.

Installed and Configured, Managed Oracle Database 11g R2 RAC databases on Linux/Unix.

Provide extend support and monitor Oracle Database 11g R2 RAC databases on Linux/IBM AIX.

Automates cloning using OEM from Oracle 11g Grid control.

Managing Oracle Application Server 10g (10.1.2.0.2 & 10.1.3.3).

Designed, Developed and Tested Data security on database.

Configured ACL list for Mailer with IMAP & SMTP for inbound and outbound processing

Configured Disaster Recovery Environment with 10g,11g,12c R1/R2 Data guard.

Rebuild/Reconfigured Oracle Standby database using RMAN Active Standby/RMAN Tape Backup/RMAN Disk Backup.

Performed Data Guard Primary and Standby database switchover activity according business requirements and Quarterly switchover test.

Performed Data Guard Primary and Standby database failover activity during primary database unavailability.

Configured Fast Start Failover technology on Oracle Data Guard Primary and Standby database according business requirements.

Responsible for developing a plan to upgrade the existing production environment from 10g R2 to 11g R2/11g R2 to 12c R1/R2.

Experience in writing UNIX shell/Windows scripts for automating daily, weekly and monthly activities.

Installing, configuring and maintaining oracle Grid control and OMS agent.

Designed and implemented standards for UNIX/Linux/Windows-based ORACLE systems.

Database duplication using RMAN active database or from the Storage Media.

Oracle database restore/recover at different types from disk/tape.

Data Movement Traditional exp/imp & expdp&impdp, RMAN ...etc.

Configured TSM setting for Oracle RMAN Backup/Restore.

Configured, Managed Oracle Flashback Database Technology.

Configured, Managed ASMM/AMM on database, To Control SGA & PGA on database side.

Develop shell and/or, PL/SQL and/or SQL scripts to implement automation of ongoing administration and maintenance tasks.

Database migration during old servers to new servers.

Set and document standards for use of databases with objectives of data integrity, data security, and efficient operation and audit requirements.

Daily activities include taking backups with RMAN, Hot and Cold Backups which ever failed from scheduled execution and also analysis and resolve scheduler issue.

Prepared RMAN BACKUP/RESTORE scripts for the database backup.

Converted the database from 32-bit into 64-bit on Linux Environment.

Tuning of I/O, which includes Separating of Data files and Redo log files on different locations, and Separating of tables and indexes on different locations. Applications Tuning of Database using Schema gather stats and Index Rebuild, EXPLAIN PLAN, SQL TRACE, ANALYZE, analysis top activity, top utilizations ...etc.

Setup a cronjobs using crontab for Production Environment to receive alerts related to TS issues, OS level space issues, locking issues etc.

Configured, Managed Automatic Storage Management (ASM) enabled database.

Monitoring of database for growth and performance, Take necessary proactive actions.

Created new concurrent managers, Purged concurrent requests table.

Review incidents and resolve on time according problematic level basis. Provide technical support during P1/P2 incidents and resolve within priority time and Prepared RCA for problematic P1/P2.

All database the implementations, changes managed by User Change Request/RITM request and issues handled by incidents priority basis (P5,P4, .. P1) on ITSM Tools.

Generated and analyzed AWR, ADDM, ASH reports and monitored statistics for performance tuning of the database.

Worked on Oracle Real Application Testing combined with a workload capture and replay feature with an SQL performance analyzer (SPA) to test changes against real-life workloads, and then fine-tune the changes before putting them into production.

Managing SQL*Net configuration (over TCP/IP) TNS Services & Listener.

Create Container and Pluggable database according business requirements.

Decommission pluggable database and container databases, manage pluggable database.

Database upgrade from Oracle 11g R2 normal database to 12c R1/12c R2 container and pluggable database.

Managing Oracle Windows databases.

Installed and configured Oracle client 11gr2/12c.

Manage tablespaces, datafiles, redolog files, temp files.

Monitor and resolve OEM alerts.

Load millions of records using sqlloader from flat file to oracle database table.

Raise SR request with Oracle support and follow up with them timely manner and resolve issue, mostly we’ve raise Oracle Internal error and some unresolvable error, binary level issue, the issue which does not have MOSC document on Oracle Meta link.

Prepare scheduled plan for implement Oracle CPU/PSU patch according Oracle Patch release calendar cycle and as per VCC Standard.

Install and apply Oracle CPU/PSU patch set using Opatch utility.

Environment: Unix/Linux, Solaris, Oracle 9i&10g, 11g, Oracle Applications 11i and R12

Since October 2011 to June 2016 I was work as an Oracle Senior DBA with Invensoft Technologies (P) Ltd, Mysore, Karnataka, India:

All of my experience has been gained across the major Oracle versions (10g & 11g R2) and a wide range of operating systems (windows XP/Windows 7/8/8.1/10, windows 2003 server, windows 2008 server, windows 2012 r2 all Version of Windows Server.)

Oracle Database Production and Develop and Demo Support Experience:

Installation and Configuration of Oracle Database10g R2/11g R1/11g R2 software on Windows 2003R2/2008R1/2008R2/2012R2.

Configure Backup and recovery (RMAN and Oracle Enterprise Manager).

Configure Flashback Database Technologies.

Oracle High availability and Disaster Recovery on Windows 2008R2 Enterprise Server Demo Environment (Oracle 10g R2 Data guard, Physical and Logical Standby Database Maintenance, switchover, failover on Demo Server).

Oracle 10g R2 RAC (Installation and Configure RAC, Adding and Remove Node from Existing RAC Database, Using these file system OCFS, ASM, Maintenance OCR and Voting disk configuration. Cluster Level Backup and Recovery Using RMAN, Disaster and High availability in RAC environment on Demo Server (Windows 2008R2 Enterprise Server Environment))

Database level performance tuning.

Memory Management using ASMM and AMM.

Transportable table space and Transportable Database configuration.

Maintenance Oracle ASM Instance and its disk groups on Demo Server.

Maintenance Oracle Enterprise Manager.

Monitoring the Database using Oracle Enterprise Manager.

Designing Database objects like Users, Roles, Granting/Revoking Permission, table space, Drop/Creating all database objects.

Database creation, deletion and migration using DBCA/DBUA.

SQL*Net configuration (over TCP/IP) TNS Services & Listener.

Replication (table, schema, table space, database level) on demo environment.

Bulk loads and data migrations (using SQL*Loader, imp/exp, impdp/expdp).

Database Level

Schema Level

Table Level

Only Table Data

Remotely monitoring/configuring all Database activities like installation, configuration, drop, and maintenance.

Oracle Database Performance Tuning.

Database migration from older version to newer version

Reviewing all database log files like database alert logfile, listener log file, other trace files and other logfiles.

Review RMAN backup logfiles using EM/Open Flat file using Notepad.

Configured ASM technology in Oracle 10g R2 database on Demo Server.

Configure/Deconfigure or Create/Drop Oracle EM db console using EMCA tools

Created Database Management Applications which is called Oracle DB Management, This is web url based application which will display daily/weekly schedule database maintenance scripts spool files, all daily/weekly scheduled scripts scheduled using windows scheduler or oracle scheduler. below listed Oracle DB Maintenance scripts are running,

-Oracle Database Complete status like Open R/W, Platform, Archive log mode...etc.

-Oracle Control status and list of control file details.

-Oracle Redolog Group status and list of Redolog Group member file details.

-Oracle Database Complete size like Total Size, Free space, Used...etc.

-Oracle Database Tablespace status details.

-Oracle Database All Tablespace size details completely.

-Application schemas Index Analysis details like No of Index Valid & No of Index Invalid.

-Application schema objects Analysis details like as

No of Valid Procedure & No of Procedure Invalid.

No of Valid Functions & No of Functions Invalid.

No of Valid Triggers & No of Triggers Invalid.

No of Valid Views & No of Views Invalid.

-Oracle AMM allocations Analysis details for Oracle 11g R2.

-Oracle SGA& SGA memory allocations Analysis details for Oracle 10g R2.

-Generate scripts for Application Oracle Logical schema level daily backup log files.

-Generate scripts for RMAN Daily backup logfiles.

-Weekly review database alert logfile and weekly once physically logon into server complete weekly database maintenance activity.

Install and Configure Oracle11g R2/Oracle11 R1/ Oracle 10g R2 Clients on Windows 10/8/7/XP.

Install and Configure Oracle11g R2/Oracle11 R1/ Oracle 10g R2 Clients ODP.NET for Visual Studio 2010/2012/2013/2015 on Windows 10/8/7/XP.

Install and Configure Oracle11g ODP.NET for Xcopy deployment on Windows Server 2008R1/2008R2/2012R2.

Here I have maintained database with Maximum size 200 GB+ per each database and these database supports web based applications called XBS (eXtended Business Solutions) – ERP on Development/Production/UAT environment servers.

Project Implementation:

1.)Invensoft DB – Management for LDC – ASP-XBS Project:

Project : Invensoft DB Management –Global

Client: Louis Dreyfus Commodities Pvt Ltd

Present Project Location: Singapore

Site: Onsite(Remote Support)

Role: Senior DBA

DBA Team Size: 1

Environment

SGP-XBS-ASP Production & UAT

Employment Type: Full-Time

Duration: Sept 2011 – Present

Skill Used: Oracle 10g R2 database software, Oracle 10g R2 Client software, Oracle 10g R2 ODP.NET for .NET 3.5 framework, RMAN,SQL,VB scripts, Oracle Scheduler, Segment Advisor and SQL Tuning Advisor, ADDM,ASMM. Oracle SQL Plus, Oracle 10g r2 EM database console, Oracle SQL developer and IIS web Server, VPN Client, and Invensoft DB Management web application.

2.)Invensoft DB – Management for LDC – DNET-XBS Project:

Project : Invensoft DB Management –Global

Client: Louis Dreyfus Commodities Pvt Ltd

Present Project Location: Singapore

Site: Onsite(Remote Support)

Role: Senior DBA

DBA Team Size: 1

Environment

SGP-XBS-DNET Production & UAT

Employment Type: Full-Time

Duration: Sept 2012 – Present

Skill Used: Oracle 11g R2 database software, Oracle 11g R2 Client software, Oracle 11g R2 ODP.NET for .NET 4.0 framework, RMAN,SQL,VB scripts, Oracle Scheduler, Segment Advisor and SQL Tuning Advisor, ADDM,AMM. Oracle SQL Plus, Oracle 11g r2 EM database console, Oracle SQL developer and IIS web Server, F5 VPN Client Invensoft DB Management web application.

3.)Invensoft DB – Management for BERO – DNET-XBS Project:

Project : Invensoft DB Management –Global

Client: Bero Coffee Singapore Pte. Ltd.

Present Project Location: Singapore-Windows Azure

Site: Onsite(Remote Support)

Role: Senior DBA

DBA Team Size: 1

Environment

BERO-XBS-DNET Production & UAT

Employment Type: Full-Time

Duration: Feb 2015 – Present

Skill Used: Oracle 11g R2 database software, Oracle 11g R2 Client software, Oracle 11g R2 ODP.NET for .NET 4.0 framework, RMAN,SQL,VB scripts, Oracle Scheduler, Segment Advisor and SQL Tuning Advisor, ADDM,AMM. Oracle SQL Plus, Oracle 11g r2 EM database console, Oracle SQL developer and IIS web Server, F5 VPN Client Invensoft DB Management web application.

Invensoft DB – Management Project Details:

Project Details:

1.) Implemented Invensoft DB Management web application in LDC SGP-XBS-ASP/LDC SGP-XBS-DNET/Bero SGP-XBS-DNET Windows Azure/Private Datacenter cloud Production and UAT database server.

2.)To using this web interface or application reviewed the database daily and weekly maintenance scheduled jobs generate spool log files.

-Review XBS Production/UAT Database Complete status like Open R/W, Platform, Archive log mode...etc

-Review XBS Production/UAT Database Control status and list of control file details.

-Review XBS Production/UAT Database Redolog Group status and list of Redolog Group member file details.

-Review XBS Database Complete size like Total Size, Free space, Used...etc.

-Review XBS Database Tablespace status details.

-Review XBS Database All Tablespace data files size details completely.

-Review XBS Database Application schemas Index Analysis details like No of Index Valid & No of Index Invalid.

-Review XBS Database Application schema objects Analysis details like as

No of Valid Procedure & No of Procedure Invalid.

No of Valid Functions & No of Functions Invalid.

No of Valid Triggers & No of Triggers Invalid.

No of Valid Views & No of Views Invalid.

-Review XBS Database Oracle AMM allocations Analysis details if Oracle 11g R2.

-Review XBS Database Oracle SGA& SGA memory allocations Analysis details if Oracle 10g R2.

-Review Daily XBS Application Oracle Logical schema level backup log files.

-Review Daily XBS Database RMAN backup logfiles.

-Weekly review database alert logfile and weekly once physically logon into LDC SGP-XBS-ASP/LDC SGP-XBS-DNET/Bero SGP-XBS-DNET Windows Azure/Private Datacenter cloud Production & UAT server complete weekly database maintenance activity.

3.)During this daily/weekly maintenance log files review if I found any issues and I would notify to LDC SGP/Bero SGP IT-Infrastructure team, All these issue processing handling by Invensoft Customer Connect CRM, once they have raised request to fix this issue through Invensoft Customer Connect CRM, thereafter I have been analysis and fix the issues and detailed information’s about these issues will be highlighted on Invensoft Weekly database report. While this Issue processing I’ve directly coordinated to LDC SGP/Bero SGP IT-Infrastructure team.

4.)Every Monday I’ve send Invensoft Weekly database maintenance report to LDC SGP/Bero SGP Management team, LDC SGS/Bero SGP IT-Infrastructure team and our local bodies.

5.)I was configured Production and UAT Daily/Weekly/Monthly/Yearly scheduled RMAN backup and Daily/Weekly/Monthly/Yearly scheduled application schema level Logical backup while implementation of XBS Database. All these backup plans backup will be stored in Professional Storage as Tape Storage/NAS&SAN Storage/Cloud Storage. Monthly once RMAN backup restoration testing will be done on LDC SGP-XBS-ASP/LDC SGP-XBS-DNET/Bero SGP-XBS-DNET Windows Azure/Private Datacenter cloud UAT DB Server.

6.)I have to connect LDC SGP-XBS-ASP/LDC SGP-XBS-DNET/Bero SGP-XBS-DNET Windows Azure/Private Datacenter cloud server using their web/client based url VPN, Invensoft DB Management applications hosted on LDC SGP-XBS-ASP/LDC SGP-XBS-DENT/Bero SGP-XBS-DNET Windows Azure/Private Datacenter cloud Production & UAT server and also I have been accessed externally through their Public IP.

XBS – DNET Product

Product : XBS DNet Coffee and Metal ERP

Product Founder: Invensoft Technologies Pvt Ltd

Present Project Location: Mysore

Site: Onsite

Role: Senior DBA

DBA Team Size: 1

Environment

Production

Employment Type: Full-Time

Duration: Nov 2011 – Present

Skill Used: Oracle 11g R2 database software, Oracle 11g R2 Client software, Oracle 11g R2, Oracle 11g R2 ODP.NET for .NET 4.0, 4.5 framework, RMAN, SQL, VB scripts, Oracle Scheduler, Segment Advisor and SQL Tuning Advisor, ADDM, AMM, Invensoft DB Management, imp, exp, impdp, expdp, NETCA, DBCA, NETMGR, Oracle SQL Plus, Database Performance tuning, Oracle 11g r2 EM database console, Oracle SQL developer and IIS web Server.

Project Details:

1.) To implement & Host XBS DNET ERP Product application and Hosted All Customer XBS ERP Production and UAT applications (DOT NET PLATFORM and Oracle11g R2 DATABASE).

2.) To Install and Configure Oracle 11g R2 database in Development Production Server and Configure necessary Preliminary parameter, create schema, roles, other database objects, and configure and test RMAN database backup and schema logical backup, scheduled those configured rman backup and logical schema in Development Production database server.

3.) To implement install and configure oracle 11g R2 client in all developers laptop/desktop machine and also installed and configure oracle 11g R2 ODP.NET Provider Client for Visual studio in laptop/desktop machine, configure and create oracle TNS service in laptop/desktop machine.

4.) To configure and create TNS Service and Oracle Listener in Development Production Server, Scheduled Segment Advisor and SQL Tuning Advisor, ADDM, and configured AMM technologies.

5.) To implement install and configure Oracle 11g r2 dot net provider ODP.NET in Development Production server.

6.) Here I’ve done Store Procedure Performance Tuning in XBS ERP Product schema. The schema it contains more than 800 oracle stored procedures, These All procedures I’ve done analysis step by step and all queries in the inside procedure, thereafter I gave proper recommendation to improve performance of the procedure execution time, these recommendation like as add index to column, change column data type and increase data type value, add or drop or change constraints in the table, change query structure to improve query performance, also advise developer to create cursor to improve the procedure performance Analysis, and while developer creating new procedure/modifying existing procedure I will give some recommendation to improve performance and resolve developer clarification and also give some recommendation to developer during critical issues.

7.) I have created RMAN backup and scheduled it and the backup happened daily RMAN FULL backup, I have recovered full backup until current state from the time of server crashed, Here I’ve recovered 6 times for this development dotnet production database.

8.) Also Here I’m doing logical schema dump reloading, like customer live dump reload with appropriate schema in development XBS Product database. In this database contain all customer project data and product schema and each project keep schema basis, almost this database size around 200 GB. Analysis database performance tuning and implement the recommendation using advisor.

9.) These database support Multilanguage Character set Unicode AL32UTF8 and National Multilanguage Character set AL16UTF16.

10.) Import particular table in the dump, to extract object DDL/DATA statements from the dump.

11.) Compare two schema object’s and take schema objects difference DDL and generate scripts. Extract data from schema and generate scripts using SQL Developer or Red Gate tools.

12.) Here Daily I have reviews the scheduled logical backups and also review the scheduled RMAN backup for this XBS-Product database and schema’s.

13.) Monthly once I have review the schema’s available in the database and drop the unwanted schema’s from the database, Here also I’m doing all kind of database administration activities.

14.) Here I’m doing additional responsibilities to take care of complete infrastructure maintenance. Configure scheduled daily and weekly backup of all customer development applications and product, other documents, Team Foundation Server backup into external drive.

15.) Recently I have successfully migrated all data & oracle RMAN full backup restore and recovery from existing IBM Tower Box Server into HP DL60 Gen9 RACK server, I have implemented RAID 1+ technology on this rack server. Configured OS level backup into external drive monthly once.

XBS – ASP Product

Product : XBS ASP Coffee ERP

Product Founder: Invensoft Technologies Pvt Ltd

Present Project Location: Mysore

Site: Onsite

Role: Senior DBA

DBA Team Size: 1

Environment

Production

Employment Type: Full-Time

Duration: Nov 2011 – Present

Skill Used: Oracle 10g R2 database software, Oracle 10g R2 Client software, Oracle 10g R2, Oracle 10g R2 ODP.NET for .NET 3.5 framework, RMAN, SQL, VB scripts, Oracle Scheduler, Segment Advisor and SQL Tuning Advisor, ADDM, ASMM, Invensoft DB Management, imp, exp, impdp, expdp, NETCA, DBCA, NETMGR, Oracle SQL Plus, Database Performance tuning, Oracle 10g r2 EM database console, Oracle SQL developer and IIS web Server.

Project Details:

1.) To implement and hosted XBS ERP application (ASP PLATFORM and Oracle10g R2 DATABASE);

2.) To Install and Configure Oracle 10g R2 database in XBS ASP ERP Product Server and Configure necessary Preliminary parameter, create schema, roles, other database objects, and configure and test RMAN database backup and schema logical backup, scheduled those backups using windows scheduler or oracle scheduler.

3.) To install and configure oracle TNS service and Listener, Scheduled Segment Advisor and SQL Tuning Advisor, ADDM, and configured AMM technologies.

4.) Here I’ve done Store Procedure Performance Tuning in XBS ASP ERP Product schema. The schema it contains more than 300 oracle stored procedures, These All procedures I’ve done analysis step by step and all queries in the inside procedure, thereafter I gave proper recommendation to improve performance of the procedure execution time, these advisors like as add index to column, change column data type and increase data type value, add or drop or change constraints in the table, change query structure to improve query performance, also create cursor to improve the procedure performance Analysis, and the developer created new procedure and give some recommendation to improve performance and resolve developer clarification and critical issues.

5.) I have recovered rman full backup recovery until current state from the time of server crashed, Here I’ve recovered 4 times for this Oracle XBS ASP ERP product database.

6.) Also Here I’m doing logical schema dump reloading, like customer live dump reload with appropriate schema in XBS ASP Product database. In this database contain all customer project data and product schema, almost this database size around 170 GB.

7.) Analysis database performance tuning and implement the recommendation using advisor. These database support Multilanguage Character set Unicode AL32UTF8 and National Multilanguage Character set AL16UTF16.

8.) Import particular table in the dump and to extract object DDL statements from the dump. Compare two schema object’s and take schema objects difference DDL and generate scripts using SQL Developer and Red Gate Tools.

9.) Here Daily I have reviews the scheduled logical backups and also review the scheduled RMAN backup for this XBS-ASP Product database. Monthly once I have review the schema’s available in the database and drop the unwanted schema’s from the database. Here also I’m doing all database administration activities and Configured server OS level backup monthly once, configure scheduled daily and weekly all applications product backup into external drive.

RMS (Resource Management System) and Customer Connect (CRM) and Demo XBS

Product : RMS & Customer Connect and XBS Demo DNet

Product Founder: Invensoft Technologies Pvt Ltd

Present Project Location: Mysore

Site: Onsite

Role: Senior DBA

DBA Team Size: 1

Environment

Production

Employment Type: Full-Time

Duration: Oct 2011 – Present

Skill Used: Oracle 11g R2 database software, Oracle 11g R2 Client software, Oracle 11g R2, Oracle 11g R2 ODP.NET for .NET 3.5,4.0, 4.5 framework, RMAN, SQL, VB scripts, Oracle Scheduler, Segment Advisor and SQL Tuning Advisor, ADDM, ASMM, Invensoft DB Management, imp, exp, impdp, expdp, NETCA, DBCA, NETMGR, Oracle SQL Plus, Database Performance tuning, Oracle 11g r2 EM database console, Oracle SQL developer and IIS web Server.

Project Details:

1.) To implement and hosted XBS ERP Demo application (DOT NET PLATFORM and Oracle11g R2 DATABASE);

2.) To Install and Configure Oracle 11g R2 database in RMS Product and XBS DEMO Server and Configure necessary Preliminary parameter, create schema, roles, other database objects, and configure and test RMAN database backup and schema logical backup, scheduled those jobs using Windows Task scheduler/Oracle Scheduler.

4.) To install and configure oracle 11g R2 oracle TNS service and Listener using NETCA/NET MANAGER, Scheduled Segment Advisor and SQL Tuning Advisor, ADDM, and configured AMM technologies. Analyze database performance tuning and implement the recommendation using advisor.

5.) To implement install and configure Oracle 11g r2 dot net provider ODP.NET in RMS & XBSDEMO Server.

6.) I have recovered oracle rman full backup recovery until current state from the time of server crashed, Here I’ve recovered 3 times for oracle XBS DEMO and RMS database.

7.) Also Here I’m doing logical schema dump reloading for demo purpose, In this database contain all Demo Product schema and RMS Schema Productions schema, almost this database size around 30 GB. 8.) These database support Multilanguage Character set Unicode AL32UTF8 and National Multilanguage Character set AL16UTF16.

9.) Import particular table in the dump, to extract object DDL statements from the dump. Compare two schema object’s and take schema objects difference DDL and generate scripts using SQL Developer & RED Gate tools.

10.) Here Daily I have reviews the scheduled logical backups and also review the scheduled RMAN backup for this XBS-DEMO and RMS database. Monthly once I have review the schema’s available in the database and drop the unwanted schema’s from the database. Here also I’m doing all database administration activities and Configured server OS level backup monthly once, configure scheduled daily and weekly all applications XBS DEMO, RMS backup into external drive.

XBS –DNET-Cloud

Project : XBS DNet ERP – Cloud

Invensoft Cloud Demo Server

Present Project Location: Windows Azure Cloud –India

Site: Onsite(Remote)

Role: Senior DBA

DBA Team Size: 1

Environment

Product Demo – Cloud

Employment Type: Full-Time

Duration: Oct 2013 – Present

Skill Used: Oracle 11g R2 database software, Oracle 11g R2 Client software, Oracle 11g R2, Oracle 11g R2 ODP.NET for .NET 4.0,4.5 framework, RMAN,SQL,VB scripts, Oracle Scheduler, Segment Advisor and SQL Tuning Advisor, ADDM. Oracle SQL Plus, Oracle 11g r2 EM database console, Oracle SQL developer and IIS web Server.

Project Details:

1.) To implement and hosted XBS ERP -Cloud several demo application (DOT NET PLATFORM and Oracle11g R2 DATABASE).

2.) To Install and Configure Oracle 11g R2 database in Cloud Demo Server and Configure necessary Preliminary parameter, create schema, roles, other database objects, and configure and test RMAN database backup and schema logical backup, scheduled those jobs using Windows scheduler / Oracle Scheduler in cloud demo database server.

3.) To install and configure ODP.NET Provider for oracle 11g R2 database in Cloud Demo server, configure and create oracle TNS service and Listener, Scheduled Segment Advisor and SQL Tuning Advisor, ADDM, and configured AMM technologies.

4.) Here Daily I have reviews the scheduled logical backups and also review the scheduled RMAN backup for this Cloud XBS-DEMO database. Monthly once I have review the schema’s available in the database and drop the unwanted cloud database schema’s from the cloud demo database. Here also I’m doing all database administration activities and Configured server OS level backup monthly once, configure scheduled daily and weekly all Cloud XBS DEMO applications backup into external cloud drive.

DOT NET – XBS ERP Metal Warehouse/Coffee Warehouse/Coffee Trading/Coffee Processing Project:

1.)XBS-DNET –Bero Global Coffee:

Project :

Contact this candidate