Oracle Data
Resume:
MICHAEL VELUPPILLAI
*******************@*******.***
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