oracle

EDUCATION

Master of Commerce (Management Science & Information Systems) - University of Auckland, New Zealand

Postgraduate Diploma in Information Technology - University of Waikato, New Zealand

B.Sc - University of Colombo, Sri Lanka

UNIX Systems Administration - Sun Microsystems, 2003

Object Oriented Analysis and Design Using the UML w/Rational Rose - Cap Gemini Ernst & Young

HIPAA Security Training - Stanford University

Consultant Skills Entry Program - Cap Gemini Ernst & Young

Certificate in COBOL Programming

Oracle, Java, WebObjects, Perl training

TECHNICAL SUMMARY

Oracle 8i/9i/10G/11G/12C DBA, Oracle RAC DBA, MS SQL Server 7/2000 DBA, Ipedo Native XML DBA, Sybase, Data Security (TDE, COST, PKI), MS Access, MySql, Postgres, Ingres, PL/SQL, Explain Plan,XQueries, XSLT, XML, Perl, JSP, ASP, JavaScript, VB Script, Visual Basic, HTML, Some Java, JDBC, ActiveX, UML, Rational Rose, COBOL, Perl, MS Front Page, MS Visual Studio, Macro Media DreamWeaver, Visual Inter Dev, WebObjects, Visual Source Safe, JBuilder3.0, Crystal Reports, Business Objects, Brio Query, Business Objects, ERWin, Rational Rose, ERStudio, Visio 2000, SAS, SQL Analyzer, OCI Tools, TOAD, SQL Loader, Import-Export Utilities, RMAN, OMWB, DTS, Query Analyzer, OEM, Statspack, Query Analyzer, SSDLC, MS Excel, Macros, Apache, Java Web Server, ODBC/JDBC, Netscape Enterprise Server, IIS, UNIX, awk, sed, Mac OS/X, Linux, Windows 95/98, Windows NT/2000, SNMP, TCP/IP, Socket Programming, EMC/SAN storage, GoldenGate, NoSQL database systems, Hadoop, TDE, PKI, SSL, PCI data audits

PROFESSIONAL SUMMARY

15+ years experience in IT

10+ years of extensive experience in database security and database administration with Unix, Linux, Windows.

Extensive experience in data modeling (ERWIN/ERStudio), data analysis, physical/logical database design and documentation

5+ years experience in report development, report automation

Extensive experience in database security(TDE, COST, PKI, SSL) and PCI data audits

Advanced knowledge in NoSQL database systems (HP Vertica, Hadoop, MongoDB)

Extensive experience in supporting product development thru Dev, QA, Build and Release cycles

Extensive experience in automation of database installation and maintenance tasks

Extensive experience in developing n-tier Client/Server applications using Visual Basic, SQL Server, MTS, Oracle, HTML, MS Site Server and PL/SQL

Extensive experience in developing Web applications using ASP, .NET, VB Script, JavaScript, WebObjects, Java, MS SQL, Oracle

Extensive experience in configuring web servers (Apache, IIS, Netscape Enterprise Server), SSL Security and web server administration.

Extensive experience in using FTP, SFTP, Telnet, and SSH

PROFESSIONAL EXPERIENCE

HEWLETT PACKARD COMPANY(TELECOMMUTE)

Sr. Technical Consultant (Oracle DBA) June 2011 – present

Lead a team of DBA’s to maintain oracle RAC and Veritas Cluster instances

Effectively manage highly complex data environments and data structures

Implement database security via encryption (TDE, COST, PKI, SSL, PCI data audits) and access features (roles, privileges, permissions etc.)

Develop and maintain database support documentation

Use best practices, work plans, checklists and defined processes

Test databases for security standards quarterly, perform audit scans and fix security holes

Automate audit reports, data synchronization and application statistics

Take ownership of complex database incidents and problems, providing resolutions within SLAs

Engage SMEs or vendors to provide assistance to resolve more complex incidents as required

Monitor database environments, proactively identify and prevent incidents

Implement database change requests

Proactively support application teams, release cycles, schema changes and advice on application data issues

Support development, test, and production Oracle database environments

Follow and contribute to database best practices

Perform database optimization and performance tuning

Install and configure Oracle 11G/12C RAC database servers on RedHat Linux/Solaris

Perform database replication using GoldenGate, DataGuard

Perform Veritas (VCS) to RAC migrations

Perform database migrations between data centers

Upgrade and patch database servers

Implement database backup and recovery procedures

Troubleshoot database and SQL query performance issues

Maintain and support high available oracle RAC and Veritas cluster environments

Provide Oracle database 12x7 on call support to include participation in Severity 1 production outages for critical airline systems.

HEWLETT PACKARD COMPANY (PPM RND)

Sr. Database Administrator (contractor) April 2010 – June 2011

Effectively managed development, QA and production database environments for PPM R&D software group

Provided expert direction and guidance to application developers on application data issues and best practices

Communicated with developers, data analysts, and business liaison on daily basis

Assisted troubleshooting query performance issues on Business Objects reporting application

Develop and maintain database support documentation

Implemented database security and change requests

Installed and configured Oracle 110G/11G RAC database servers on RedHat Linux, AIX, Windows platforms.

Installed Oracle patches and database schemas, and upgraded the databases to new versions

Automated database server installation, database creation and maintenance functions (Oracle Provisioning)

Provided database support for product development thru Dev, QA, build and release cycles for PPM application

Configured data modeling (in-house) and documentation tools for new software releases

Performed database optimization and performance tuning for servers, applications, and SQL queries

Performed database monitoring via OEM and Sitescope monitoring tool

2WIRE INC

San Jose, CA

Sr. Database Administrator Nov 2005 – Dec 2009

Maintained Production/Development/QA Oracle 9i/10G, Oracle RAC on RedHat Linux Advanced Servers

Maintained/Installed MS SQL Server production database servers

Migrated a large production MS SQL Server database to Oracle 10G

Installed latest database schemas, patches and upgraded existing Oracle 10G servers

Supported product development thru DEV/QA, Build and Release cycles

Proactively supported application teams, release cycles, schema changes and advice on application data issues

Wrote and converted T-SQL scripts to PL/SQL and partitioning scripts to upgrade schemas

Identified performance bottlenecks and tuned SQL and server memory structures

Performed database backup and recovery procedures

Implemented database security via Oracle Advanced Security features (TDE, COST, PKI)

Designed/developed custom SQL/PL-SQL scripts to implement UI functionalities.

Performed 24X7 on-call duties on production database servers and application servers.

Defined business requirements, wrote technical specifications, designed and developed finance and manufacturing reporting solutions (Crystal Reports XI)

Wrote Shell scripts to automate EXCEL financial reports generated via Oracle production databases

NAVIO SYSTEM INC

Cupertino, CA

Sr. Database Administrator (Contract) Mar 2005 – Nov 2005

Installed, maintained Oracle 9i RAC and document-based Native XML (Ipedo) database servers on RedHat Linux

Deployed a reporting server synchronized with production database server

Designed and developed finance reporting solutions

Implemented solutions that improved the performance of Oracle RAC.

Installed staging and QA Oracle and native XML database servers (Ipedo) on development and production RedHat Linux AS3 and SuSE Linux platforms

Capacity planning on EMC/SAN storage environment

Migrated and maintained staging and production Native XML database (Ipedo) servers.

Wrote Perl/Shell scripts to automate database replication for reporting server

Wrote Perl scripts to automate management reports

Implemented corporate data retention policy for Navio Systems Inc.

Integrated 3rd party reporting tools with Native XML database for business and ad-hoc reporting

SANDISK CORP

Sunnyvale, CA

Sr. Database Architect/Administrator (Contract) Feb 2004 – Dec 2004

Designed and developed a web-based reporting system (using Crystal Reports, Cognos, .NET) for Product Engineering Group.

Designed and developed corporate engineering database using ERStudio and MS SQL Server.

Designed logical and physical data models and optimized and tuned SQL and database.

Resolved database replication issues and generated scripts to create databases.

Designed and implemented Fault Analysis reporting systems using Accurev Configuration Management Software.

Trained various product systems engineering groups in using the database, the reporting system, the Fault Analysis and bug tracking systems.

STANFORD UNIVERSITY SCHOOL OF MEDICINE

Stanford University, CA

Database Administrator July 2001 – Dec 2003

Participated in the planning and implementation of the hardware/software configuration and related database server environment.

Installed, configured and maintained Oracle, Postgres, MS SQL Server, MySql database servers.

Developed and implemented backup and recovery strategies and procedures (RMAN).

Developed data models (using ERWIN/ERStudio) and created the physical implementation of databases.

Managed high-availability databases on multiple development (Linux) and productions servers (Solaris).

Automated monitoring of key database server components and events.

Enforced database security policies in compliance with HIPAA security and regulations.

Implemented solutions that improved the performance of server functions.

Provided expert information and advice to application developers to assist them in making the most effective and efficient use of database management system capabilities.

Performed migration of various databases (Postgres, Sybase, SQL Server, and Access) into Oracle 8i/9i on Solaris/Linux platforms.

Tuned SQL using Explain Plan and TkProf and developed table fragmentation strategies.

Developed Stored Procedures, Functions, Triggers, SQL and Perl/Shell scripts to automate day-to-day administrative tasks.

Wrote PL/SQL scripts to log all database errors to a table demonstrate database triggers, list foreign keys in tables, show database versions with options installed, and load data from a cursor in PL/SQL.

Wrote PERL scripts to change the Sybase DATE formats and setup Cron jobs to load text data files into Oracle database server.

Participated in 24X7 on-call rotation as necessary.

Communicated with users, developers, data analysts, and business liaison on daily basis.

Configured/installed and maintained Web Servers (Apache, Netscape Enterprise Server, IIS) on Windows, Mac OS/X platforms.

Configured Video Servers (Windows Media Server, Real Server) on Windows 2000 platform for the Media Server project for local and distance teaching, research, and clinical outcome analysis.

Designed, developed, maintained and supported multimedia web database applications (http://studentbodies.stanford.edu/, http://stayingfree.stanford.edu/, http://bml.stanford.edu/) using WebObjects, Java, Oracle, ASP, Visual Basic, VB Script, Java Script and SQL Server.

CAP GEMINI ERNST & YOUNG

Cupertino, CA

Senior IT Consultant Jan 2001 - July 2001

Developed use cases (Rational Rose, UML) for eSiebel application for Microsoft in Seattle.

Designed and the developed an internal application using ASP, jhtml, SQL Server and ATG Dynamo for the

consulting firm.

GBA INC

Los Altos, CA

Software Developer/DBA Jan 1999 - Jan 2001

Designed and developed an GBA ImageArchive software using Webobjects, Java, Oracle

Installed, configured, maintained Oracle 8i/MySql Server database servers and created instances.

Migrated a hierarchical text database into MySql

Monitored logical logs, daily backups, and shared memory allocations.

Exported and imported databases frequently.

Wrote Shell and Perl scripts to automate database administration functions.

Managed and implemented schema level upgrades.

Developed Stored Procedures and Triggers.

PORTERA SOFTWARE LTD

Sydney, Australia

Implementation Consultant Dec 1997 - Jan 1999

Implemented Practice Management Software including Time & Billing, Administration, Planning, Bulk Billing and Consultant Management for leading financial, software and consultancy firms in Sydney.

Developed project specifications, work plans, change management documentation, implementation plans and reports using tools such as Visual Basic, MS SQL Server, MS Access and MTS.

Developed data extraction processes, stored procedures, triggers

Involved with the integration of INVISIC software to SAP interface for Microsoft Consulting Services (Sydney) and lead a team of developers on development efforts.

Defined business requirements, supported product and systems upgrade issues and assigned them to team members.

DATACOM SYSTEMS LTD

Auckland, New Zealand

Software Developer Oct 1996 - Nov 1997

Designed and developed n-tier Client/Server applications using Visual Basic, MS SQL Server, MTS, Oracle, HTML, VB Script, Java Script, ASP, MS Site Server and PL/SQL.

Designed and developed a MAPI Programming interface for Fletcher Forests Ltd, New Zealand.

Developed a Tax Information Management System for Fletcher Challenge Ltd, New Zealand.

Provided system support for upgrading major Bank Information Management System at Countrywide Bank, New Zealand.

Developed Excel Macros and automated Excel reports for Telecom New Zealand.

Developed a Restaurant Information Capture System for McDonald's in New Zealand.

Developed a Vehicle Handling System for Car Haulaways Ltd.

Developed testing plans (QA) for a Customer Management System at Mercury (Vector) Energy Ltd, New Zealand.

Provided system support for Internet/Web development project at Fletcher Forest Ltd, New Zealand.

UNIVERSITY OF AUCKLAND

Auckland, New Zealand

Information Systems Instructor Jan1996 - Oct 1996

Taught various different software applications including MS Access at undergraduate level.

Installed, upgraded, and maintained software and hardware in the computer labs.

AUCKLAND NEW VENTURE TRUST

Auckland, New Zealand

Database Support Jan 1995 - Dec 1995

Designed and developed a MS Access database and the interface using Access Basic to a Student Information Management System.

Produced reports in a timely manner using the Student Information Management System.

PUBLICATIONS AND PRESENTATIONS

Proceedings of the Americas Conference on Information Systems (AMCIS2000), CA, USA, JAYAWARDANA, T. and GUTIERREZ, J., "Integration of the Helpdesk with SNMP Network Management: A Case Study Approach", AMCIS2000, Long Beach, California, Aug 2000, p.516-22.

University of Auckland, New Zealand, Thesis: "Integration of the Helpdesk with SNMP Network Management", Aug 1999.

TRAINING/INSTRUCTION

UNIX Systems Administration (SUN) - 2003.

Oracle Database Administration

HIPAA patient security training (Advanced) - Stanford University School of Medicine.

Object Oriented Analysis and Design Using the UML w/Rational Rose – Cap Gemini Ernst & Young

Contact this candidate