CV PLSQL oriented

 Turloch O'Tierney

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

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

Professional Development                                                                                                               Mar2024-Present 

    • IT Specialist Python Certification: Aug2024. Additional interests: Django/Ecommerce.

Experience

PL/SQL experience. (Oracle/Oracle partner: UNIX/Linux/Database Migrations/PL/SQL/Java/DBA up until Mar 2024))

    • Oracle Database UNIX/SINIX porting and support: Core Oracle on Siemins Nixdorf UNIX (SINIX).

    • Microsoft T-SQL to Oracle PL/SQL auto convert (Java/Javacc)

    • SQL Developer worksheet (SQL/PL/SQL script support). SQLcl (SQL/PL/SQL script support)

    • Data Pump PL/SQL Package use in SQL Developer wizard/SQLcl command line. 

    • Recruited/Interviewed 40 developers for PL/SQL positions.

    • UNIX/Linux: 4 years UNIX ((SINIX)/HP): 26 years Linux (Oracle Linux/Like CentOS/Linux server/network config)

    • Development DBA 5 years: installing/configuring/patching/putting in Docker and Virtualbox/11gDBA OCP certification. 

    • Secondary skills: Solaris, Postgres, DB2, MySQL, Informix. Oracle Database configurations: RAC, ASM, OEM

    • Performance tuning task forces, and product functionality: AWR, ADDM, SQL Profile, and ASH.

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, 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.

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

    • Some JEE/Docker setup&configure/Recompile dependencies. Not very relevant for DBA/Admin/ITIL.

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