CV Java orientated

 Turloch O'Tierney

Dublin, Ireland 0868256032 turloch@gmail.com www.linkedin.com/in/turlochotierney/

Skills: 30 years experience. Java, Oracle Database, Linux, git, 11g DBA OCP, C and Docker.


Professional Development                                                                                                               Mar2024-Present 

    • IT Specialist Python Certification: Completed Aug2024. Small Python/Django web app. Ecommerce/Shoppify investigation. 

Experience

Senior Software Developer. (Oracle EMEA – Server Technologies, Java/Oracle Programmer)                      2006-22Mar2024

Worked in a small development org on database access tools: SQL Developer (>1 million downloads) and SQLcl, and REST: ORDS

Business area: (followed by task list)

Database as a Service (DBaaS):

    • Contributed to the development and successful launch of a Database as a Service data transfer solution, demonstrated at Oracle OpenWorld. Created a streamlined wizard for SQL Developer, which contributed to over 1 million downloads.

    • Executed data pump commands in SQLcl by integrating SQL Developer’s Data Pump Wizard using PL/SQL anonymous blocks, enhancing the efficiency of database migrations.

    • Integrated the Cloud Premigration Advisor Tool (CPAT) into SQLcl, improving the identification of key issues related to database transfers to the cloud.

    • Prior to DBaaS, developed and distributed a public VirtualBox OVA file, offering customers and prospects the fastest way to access the Oracle Database.

    • Certified on Oracle 11g DBA (OCP), responsible for providing comprehensive database configurations and versions for developers, streamlining development workflows.

Application Java code:

    • Contributed to the development of Oracle’s primary database access tool, SQL Developer, enhancing user experience for millions of developers.

    • Played a key role in a specialized sub-team developing SQLcl, a Java-based replacement for Oracle’s SQLPlus command line interface, optimizing its functionality for modern scripting needs.

    • Worked on the migration capabilities within SQL Developer, enabling seamless migration from Microsoft SQL Server, Sybase, Informix, DB2, and MySQL to Oracle Database, which was previously handled by the standalone ‘Migration Workbench’ tool active 1998 to 2007.

    • I led the Microsoft T-SQL to Oracle PL/SQL parsing and stored procedure automated translation team in 1998-2002 for the ‘Migration Workbench’. I led expansion into Sybase, Informix ESQL, and Access queries.

    • Automatically rewrote customer-supplied PL/SQL anonymous blocks to ensure functional completeness and address compatibility issues with Oracle JDBC.

    • Rewrote a significant Java Sybase migration component as a PL/SQL anonymous block to eliminate database round trip time, addressing the limitation that Java code might not be executed on the database server.

    • Delivered key command-line functionalities, including connect, net, startup, shutdown, alias management, and enhanced authentication methods (Kerberos/RADIUS), significantly expanding SQLcl’s usability.

    • Collaborated as part of a small team to achieve performance parity between Java SQLcl and Oracle’s C-based SQLPlus. Performance parity was achieved through extensive benchmarking of a 10-minute Oracle APEX installation, removing unnecessary queries, deduplication, and query optimization.

    • Designed and deployed a Docker-based testing infrastructure for on-demand testing, streamlining product and database validation processes.

Newer technologies: JEE, HTTP applications and REST: (Oracle REST Data Services: ORDS) 

    • Proposed a multi-threading solution for handling delayed results, though it was ultimately ruled out in favor of shorter REST calls with a URL for later callback for results.

    • Compiled and released third- and fourth-party software for JEE (JSON-P, JSON-B, and servlet server) to address security vulnerabilities (CVEs), ensuring the product remained compliant and secure.

    • Provided a Docker solution for product and database testing on the server. A later enhancement of a dedicated Docker environment for each database was implemented by another team member.

    • Developed the OREST JDBC driver, enabling a non-proprietary REST-based solution to replace Oracle’s proprietary JDBC interfaces. Successfully demonstrated this approach using the SQLcl product as a case study, proving the viability of REST JDBC integration.


Comments

Post a Comment

Popular posts from this blog

CVs from google drive:

Download_Standard_CV.pdf : https://drive.google.com/file/d/1jR7T0LJx84vyOYMJXNPnb3PjqqPs0wIo/view?usp=drive_link Download_PLSQL_Oracle_CV.pdf https://drive.google.com/file/d/1WuEqC3JeBXekDKxH_nwZYnMQDuCD0c_a/view?usp=drive_link ( Spread to 2 pages: General after jobcare review : https://drive.google.com/file/d/19Tv8hgJS4WVbFeypsMkjqCw-KSnq5gMK/view?usp=drive_link PLSQL after jobcare review : https://drive.google.com/file/d/1FcwUsWXPRJQ--6rR2S8P8CsOF4xU0NK3/view?usp=drive_link ) Oracle Reference 1998-2024 : (Added 15th October 2025) https://drive.google.com/file/d/1i3xQbK45rUM9lNoZVyl5P-u4292P42Gq/view?usp=drive_link
Read more

Topics for 12hr investigation/blog welcome. Java/PLSQL/DBA

New content being created. No longer at Oracle. Suggested post:  minor Database docker/free tier log. For: CV/portfolio/interview discussion. Topics for 12hr investigation/blog welcome. Available for immediate employment. (1hr commute from Beaumont, Dublin 9, Ireland. (North Dublin, 30mins from city centre)) https://ie.linkedin.com/in/turlochotierney Senior PLSQL/Java/Oracle Database Professional at Oracle Dublin. 30 years expertise. PLSQL | Java | Oracle Database | Linux | git | 11g DBA OCP | Gitlab | C |  macOS
Read more

Training for my 18 year old

 "All" development these days html javascript framework(react) front end... backend varies a bit.... if I was to pick a demo... AWS serverless with fancy enough secure auth login. Java or python on javascript/Node.js.  (or javascript electron / vscode for desktop. ) javascript framework beyond basic chatgpt cut and past out of scope for summer set up. ie tiny bit of react plus forms / javascript enough for front end. Certs: (my oracle certs were from 1 week courses and notes, memorise for a month.) Demo apps slightly better than certs. hello world on git hub better. Need a 5 minute cool slick interview description with buzzwords and equivalent 35hr a week work experience number if absolutely necessary. No one interviewing gets around to/has time even for screen shots. Python. Can get very basic cert in 2 months, a lot of memorisation. 40 hrs a week. Cybersecurity comptia a+ network security... 18 months... Linked in... connect to me... my 1st connections I can  comment on...
Read more