MICHAEL VELUPPILLAI

acvjlg@r.postjobfree.com

+324********

PROFILE

Michael is an Oracle certified DBA with more than 26 years experience in national and international companies in sectors such as accounting, public sector, telecommunications, financial, IT services and consulting

Michael has developed an extensive skill-set to manage all areas of the Oracle RDBMS, database and Application Server suite on both Unix and Windows right up to the latest 12c software versions

SKILLS SUMMARY

Oracle 8i, 9i, 10g and 11g Certified Professional DBA.

Installation, configuration, patching, development and administration of Oracle databases including Oracle Migration and Application Migration

Oracle RDBMS versions 7, 8, 8i, 9i, 10g, 11g and 12c RAC (Real Application Clusters), Oracle 12c Could Control

Utilisation SAN and NAS storage

SQL Server 2005/2008/2012

Oracle EXADATA Database Server X3-2 including 11g and 12c RAC and OEM 12c

Oracle Application Server 8, 9iAS, 10gAS, Weblogic Server and Websphere including clustered configuration

Oracle EBS R12/11.5.8 administration and configuration

Oracle RDBMS on Windows, Linux including VM Ware and Unix including Virtualised/Logical Environments

Oracle Security, hardening, fine-grained access control and auditing

Oracle Advanced Security including Application Data Encryption, Built-in encryption key lifecycle management and Oracle Exadata integration, and direct integration with database technologies

Utilisation of DB Vault in T-systems in order to prevent the privileged users from accessing trading application data, and enforces controls over how, when and where the application data can be accessed

Utilisation of Audit Vault in T-systems in order to detect suspicious activities by automating the collection and consolidation of audit data from Trading Systems.

Utilisation of Data Masking in T-systems in order to mask the sensitive data when copying from production to non-production environments.

Oracle database backup and restore strategies including RMAN

Oracle database performance tuning

Oracle Enterprise Manager, Grid Control, Oracle Intelligent Agent

Oracle Fail Safe and Data Guard standby database high availability solutions

Oracle Partitioning, Oracle Spatial, Oracle Text

Oracle Single Sign On, iFS, Workflow, Discoverer, LDAP, OID, ODM

Oracle HTTP Server (Apache) configuration

SQL, PL/SQL and Java programming and tuning

Docker plus Nagios/Zabbix/ELK to package application and its dependencies into a standardized unit for installing on other servers

CD ( Nolio, Jenkins, GIT, Nexus ) to release multi applications and continue delivery nacross application life cycle.

TIBCO EMS to implement Java Message Service.

Multi-tier database design, data loading and data modelling including OLAP (Data Ware Housing) and OLTP (Transactional Processing) including utilisation of SQL Developer and Toad.

Capacity planning, space management, schema management

TCP/IP networks

Administration of Unix and Windows including servers and Clusters

ITIL Frameworks for Incident, change and Problem management

Work Experience Summary:

Oracle Database and EBS Administration 26/10 years

Oracle RAC and OPS Administration 20 years

Oracle 11g/12c on Unix/Linux 8 Years

Oracle Migration and upgrade – 20+ years

Oracle EXADATA/EXALOGIC X2-8/X3-2 2 Years

Advanced Security (2 Years)

Oracle Data Guard/Physical Standby Administration 18 years

Oracle Application Server 15 years

SQL Server 2005/2008/2012 10 years

Application and Interfaces – 20+ years

Unix/Linux 26/16 years

Unix - Logical/Virtualised /Linux-VMWare 16/10 years

MS Windows System Administration 15 years

Oracle SQL / PLSQL Developer 15 years

Oracle 12c Cloud Control 3 Years

Utilisation of SAN AND NAS storage 15 Years

Experience of ITIL Frame work/Principle 12 Years

EMPLOYMENT HISTORY

T-Systems Eindhoven/The Hague, The Netherlands May 2008 – Present

Principal Oracle DBA (Contract)

Summary:

Principal Oracle DBA and WebLogic Administrator working as a production support engineer for all day to day support tasks on Oracle database 10g, 11gR2 and 12c on Unix and Linux including VMWare and Virtual/Logical Environments respectively

The role also incorporates project based support of test and pre-production systems for transition of new software releases into the production databases and servers

Focused on administering, maintaining, loading, performance tuning and securing systems for our clients SHELL and Philips and their associated application tiers, which currently serve Oracle Forms, Reports and Discoverer tools.

On calls

Key Responsibilities:

Part of a Specialised Application Migration and Support team, based in The Netherlands

Plan, co-ordinate and administer all functions in migrating, supporting, upgrading the Database/BI/Weblogic Server environments of various applications for our clients, SHELL and Philips

Performs installing and maintaining Weblogic Server instances including cluster configuration with apache and Big IP load balancing

Performs capacity planning required to create and maintain the databases including tuning, backup and recovery.

Control migrations of programs, database changes, reference, data changes and menu changes through the development life cycle.

Place standards in place to ensure that all application design and code is produced bwith proper integrity, security and performance with appropriate documentation.

Troubleshoot with problems regarding databases, applications and development tools.

ETL process monitoring and issue resolution on 24/7 shift work schedule

Perform database and application server patching and configuration changes as required

Perform backup and recovery of data as required

Work with Infrastructure and Development teams to provide regular database clones

Continually assessment of current technical processes and advising/proposing/implementing process improvement

Configure and maintain Grid Control software

Implement the Oracle Advanced Security including Application Data Encryption in database columns and entire tablespaces, Built-in encryption key lifecycle management with assisted key rotation and Oracle Exadata integration, and direct integration with database technologies such as Oracle RMAN, ASM, RAC, Advanced Compression, Active Data Guard, and Golden Gate

Utilisation of DB Vault in order to prevent the privileged users from accessing trading application data, and enforces controls over how, when and where the application data can be accessed

Utilisation of Audit Vault in order to detect suspicious activities by automating the collection and consolidation of audit data from Trading Systems.

Utilisation of Data Masking in T-systems in order to mask the sensitive data when copying from production to non-production environments.

Configured and built databases on the both EXADATA Database Servers X2-8 and X3-2 in order to run Trading and dataware house applications for SHELL and Order Processing, Dataware housing applications for PHILIPS.

Administrating EBS 11i/R12 for General Ledger, ERP and HRMS modules

Configured and built Enterprise Manager 12c on the EXADATA Database Server on X3-2 for monitoring, provisioning and managing inventory for billing purposes.

Configured and built active Dataguard and RAC databases on the both EXADATA Database Servers X2-8 and X3-2 for the disaster recovery, high availability and scalability in order to safeguard the applications.

Supporting and maintaining the DB2 databases for SHELL Company’s billing systems including use of DB2 Data Studio.

The project to migrate billing systems data from DB2 databases into Oracle databases including utilisation of DB2 Audit logs and Transparent Gateways.

Technologies: Oracle 11g/12c, EXADATA/EXALOGIC, RMAN, RAC, Dataguard, Weblogic, OrackeAS, Grid Control, SQL Server 2005/2008/2012, DB2 9.7, Unix (Solaris 10/11 (ZONE), AIX 5/6/7 (LPAR), HP-UX 11), Linux Redhat 5/6 (VM), ITIL

Man Investments Ltd London, England January 2008 – May 2008 Senior Oracle DBA (Contract)

Summary:

Due to the complex nature of database requirement, a highly experienced (with over 10 years) DB consultant with experience of working with very large databases (Oracle 10g/11g), experience in upgrading and migrating Oracle databases, experience in tuning database for optimal performance, knowledge of Sun Solaris 10 operating system.

Key Responsibilities:

Database design & build including review/amendment of database High Level Design, completion of database Low Level Design, input to Deployment Plan, input to Support Model, input to 1st, 2nd, 3rd level support documentation, Database implementation, data migration, support for testing (performance testing and db tuning), warranty support

Operators are required to disclose ‘data’ to Law Enforcement Authorities when requested (Police, Defence Forces, Revenue Commissioners, GSOC), requests are managed by Meteor’s Risk Management Department (Scolari)

Project purpose is to store Call Data Records (CDR’S)/ISP authentication generated data in a secure Database(s) for a defined period of time to comply with the Communication Retention of Data Act 2011 enacted January 2011

Technologies: Oracle 11g, RMAN, CRS, ASM,Grid Control, ITIL

Citi Group London, England May 2007 – January 2008

Senior Oracle DBA (Contract)

Summary:

Worked as a production support engineer managing all support tasks on Oracle database 10gR2 and 11GR1 with ASM over Oracle CRS Clusterware on Solaris 10 /HP/ Linux

The role also incorporated on call support of test and pre-production systems for transition of new software releases into the production databases and servers

Merged with different businesses within CitiGroup, directly involved on the integration of several Oracle databases coming from the different participants of the merge

Key Responsibilities:

Manage RMAN backups with FRA and ASM for 10g and 11g databases.

Automate housekeeping, health check and monitoring scripts using Grid Control

Creation and management of standby databases using Oracle Dataguard

Performance tuning, investigation and analysis for Oracle database (tracing, tkprof, AWR reports)

Upgrade Oracle 10g (10.2.0.4) database to Oracle 11g (11.1.0.7)

Participating in relocation of our production Data Centre to a new data centre

Migrating databases and working in bank integrations

PLSQL Support to Developer teams in the Bank

Technologies: Oracle 10g, 11g, RMAN, CRS, ASM, Grid Control, Dataguard,ITIL

BSKYB London, England October 2005 – May 2007

Oracle Senior Technical Engineer (Contract)

Summary:

Worked on a major project for migrating data to BSKYB’s Data Centre in Southampton, running 10gR2 RAC Database (over CRS and Veritas SFRAC) and 10gR2.

Application Server on the HP-UX Itanium 64-bit platform. The role incorporated support of development and test phases on multiple application software releases as well as ongoing production system support.

Key Responsibilities:

Design lead for implementation of technical solutions/ maintenance automation and procedures

Being involved in business/technical analysis/support of financial products

Day-to-Day DBA tasks, such as performance & tuning, database design, data modeling, system, security database implementation, technical support. Evaluation of new technologies

Configure RMAN backups with FRA for 10g RAC (HP-UX 11.23)

Automate housekeeping under Grid Control for RAC, 10gAS, CRS and Oracle Dataguard

Performance tuning, investigation, analysis for RAC DB/Flexcube application code (tracing, tkprof, AWR reports)

Mentoring and training junior DBAs and automating production database health checks

Patching of RAC and CRS to 10.2.0.4, application of CPU patches

Configure Grid Control for alerting and system monitoring

Creation and management of Oracle standby databases, using Dataguard Broker

Configuring RMAN Catalog, Automation of RMAN backup scripts and disaster recovery strategy

Technologies: Oracle 10gRAC, 10gAS, RMAN, CRS, SFRAC, Grid Control, Dataguard, ITIL

4

Atos Origin, London, England January 2005 – October 2005

Senior Database & Oracle Consultant (Contract)

Summary:

Worked on the design and modelling phase of a major project for the Dept of Health to modernize systems used to track data in Hospitals

The Andalusian Health Service (SAS) in Spain delivers public health services to 7.4 million citizens with 33 hospitals, 1,400 primary health centres employing nearly 80,000 people

Key Responsibilities:

Working as Project Lead-Oracle DBA and handling hospitals databases. Each hospital got separate working environments, creating and maintaining documentation for cloning, patching, up gradation, and any customizations Role also included mentoring of junior DBAs for technical issues

Major activity was configuring new oracle databases for Andalusian Hospitals.

Performed Day-to-Day DBA tasks, such as performance & tuning, database design, data modelling, system security database installation, technical support, and investigation of new technologies.

Also involved in business/technical analysis/support of health products.

Restoring/cloning of Oracle database for development team, creating new instances databases using Export & Import utility, implementing schemas & modifications, managing user security & profiles, regular DBA activities including monitoring databases using db health scripts, allocating System storage & planning future storage requirement for database system, creating primary database storage structures (tablespaces) once developers have designed an application, creating primary objects (Tables, Views, Indexes, Stored Procedures, Triggers) once developers have designed an application. Configured backups with Legato Systems. RMAN Catalog, Automated RMAN backup script and part of disaster recovery

Technologies: Windows 2003, OFS, Oracle 10g, Sun OS, Clusterware + RAC + Oracle 10g, Backup: Legato, ITIL, Grid Control

Eurocontrol Brussels, Belgium January 2004 – December 2004

Senior Production Oracle DBA (Contract)

Summary:

Administering databases for Flights Management systems, providing integrated data messaging technology and services

Key Responsibilities:

Plan and design solution for disaster recovery and 24/7 operation

Implement RMAN backups

Reduced disk contention by physically reorganizing datafiles, using partitions, separating data and indexes. As a result decreased disk usage by 60%, and improved performance

Create and manage standby databases

Upgrade 8i (8.1.7) databases to 9i (9.2.0.7)

Performance tuning, investigation and analysis (tracing, tkprof, Oracle wait interface)

Production Support for databases

Mentoring and training junior DBA

Technologies: Oracle 8i, 9i, RMAN, TRU64 UNIX, OEM, ITIL

Oracle Corporation UK Reading October 1998 – December 2003

Onsite Oracle Consultant

Summary:

Worked on various customer sites as an onsite consultant in order to provide consultancy and support for customers on their request. The customer sites include British Telecom, Barclays, Abbey National, BSKYB, BBC, HSBC, Credit Suisse, Bank Of America, BNP Paribas, (France), ABN AMRO/ING (The Netherlands), and Amadeus (Germany)

Designed/implemented highly available (HA) and disaster recovery (DR) solutions for clients.

Evaluation of new Oracle releases and review of patches and provide recommendations appropriately to the customers in question

Key Responsibilities:

Handled the tasks of installing, patching, supporting and configuring new database server and software

Responsible for data modelling, creation of database device logical and physical design of the database

Evaluated/reconfigured Oracle, Oracle Application Server, Weblogic Server setup, UNIX, Linux and Windows including scalable high availability solution.

Trouble shooting including solving very complicated issues and investigating bugs to see whether a patch needs to be applied. This involved discussing with my colleagues back in Oracle in order to get best outcome.

Improved system and database security through setup and ongoing maintenance. Delivered a cohesive solution for managing users and their roles for systems and databases.

Performance Monitoring, estimated the number of users, CPU and Disk space requirement, identified bottleneck and rectified it, fine-tuned store procedures to improve performance, database loads performance improvements, proper setup of database files and file groups to boost performance on Oracle and SQL Server databases.

Technologies: Windows, UNIX, Linux, ORACLE 8i and 9i, Oracle OEM, RAC/OPS, Petitioning, Dataguard, EXPLAIN Plan, JSP, HTML, BCP, ISQL, Oracle Database Assistance, Backup And Recovery Utility, Exp/Imp, Net app s snapshot utility, Schema Manager, Sport light, SQL, Shell Scripting, ITIL

European Central Bank Frankfurt, Germany October 1994 – October 1998

Oracle DBA/Developer

Summary:

Administering databases for Account Management and Trading systems, providing with an integrated High Availability, Scalability and data messaging technologies and services

Key Responsibilities:

Plan, design and build databases on Sun Solaris and Windows

Responsible for incidents, changes and supporting users.

Propose and implement backup and recovery solutions

Production Support for databases

Create and manage standby databases

Install and Patch Solaris Operating systems, Oracle and Business Objects

Upgrade databases to 8i (8.1.7)

Write SQL and Shell scripts

Performance tuning, investigation and analysis (tracing, tkprof, Oracle wait interface)

Technologies: Oracle 7, 8i, SUN Solaris, Business Objects, Windows

European Space Agency Darmstadt, Germany January 1992 – October 19984

Oracle DBA/Developer

Summary:

Building and Administering databases for Human Resources and Space Data Systems, providing with an integrated High Availability, Scalability technologies and services

Migrating databases from DB2 to Oracle including use of Oracle Transparent Gateway for DB2

Key Responsibilities:

Plan, design, build, Test databases and Applications on IBM AIX and Windows

Propose and implement backup and recovery solutions

Create and manage standby databases

Produce Requirement Specification, System Design and Internal Design documents

Install and Patch AIX Operating systems, Oracle

Upgrade databases to 8i (8.1.7)

Write SQL and Shell scripts to implement batchload, backup etc.

Performance tuning, investigation and analysis (tracing, tkprof, Oracle wait interface)

Technologies: Oracle 7, 8i, SQL* Forms, DB2, IBM AIX, Windows, Cluster

British Telecom Ipswich, England July 1989 – December 1991

Oracle Developer/Analyst Programmer

Summary:

Building and Administering databases for Network Management systems, providing with an integrated Oracle database and Business Objects technologies and services.

The Access Managements was built using mainly BT billing systems (CSS) on DB2 databases and other resoces.

Key Responsibilities:

Plan, design and build databases and Business Objects on Sun Solaris and Windows

Production and development Support for databases and Business Objects

Install and Patch Solaris Operating systems, Oracle and Business Objects

Upgrade databases to 7.3.4

Write SQL and Shell scripts

Performance tuning, investigation and analysis (tracing, tkprof, Oracle wait interface)

Technologies: Oracle 7, SUN Solaris, Business Objects, Windows, DB2, DB2 Audit

QUALIFICATIONS

London South Bank University, London, England September 1985 – July 1989

Bachelor of Computer Studies with First Class honours

Certifications

Oracle Database 11g/10g/9i Oracle Certified Professional

Oracle Database 10g:Real Application Cluster Administrator Certified Expert

Sun Certified System Administrator Solaris 10

ITIL. Foundation Certificate in IT- Service Management

References will be available upon request.

Contact this candidate