The Oracle database. And its infrastructure dependencies. Automated product and service deployment. Hence scripting (loads of it).
Aktualisiert am 15.05.2024
Profil
Freiberufler / Selbstständiger
Remote-Arbeit
Verfügbar ab: 21.04.2024
Verfügbar zu: 100%
davon vor Ort: 0%
Oracle RDBMS
Scripting on Unix platforms
Technical analysis / detailed writing
Project management (PRINCE2)
Ansible (Python-based collections)
Parallelized shell scripting
HTML / CSS / Javascript
VBScript / Classic ASPs
HTML / Ms Office documentation generation automation
Windows / Ms Office object models
VMware / ESXi
IBM DB2 export
Slackware Linux
Some Linux specifics (networking / systemd / kernel tunables / minimal install footprint)
HTTPd / Tomcat
English
Near-native
German
Rudimentary level
French
Muttersprache

Einsatzorte

Einsatzorte

Deutschland, Schweiz, Österreich
möglich

Projekte

Projekte

2 years 8 months
2021-09 - now

DevOps / Ansible IaC

Work conducted in a personal capacity from time to time.

Taking Ansible works having taken place FEB & MAR 2021 further:

Regarding Clusterware:
  • Switched from ASMLib to ASM Filter Driver (ASMFD) when it comes to ASM instances.
  • Automated the deployment of Real Application Clusters? HAS & CRS stacks.
    ? (Slackware 14.2- & Windows 10-hosted VirtualBox VMs.)
    ? (Leveraging Bind for local authoritative DNS services.)
    ? (Local SCANs.)

Deployment automation encompasses:
  • 21c release multitenant standalone database products.
  • 21c CDBs and PDBs.
  • Database client products.
  • Fast-start failover Data Guard topologies.
  • TDE-encrypted databases via united-mode wallet configuration.
  • TLS self-signed certificates for mTLS DN matching-based authentication (all products).

Management automation encompasses:
  • RMAN-driven active database duplications.
  • RMAN- & DGMGRL-driven Data Guard topology deployments.
  • PDB unplug / relocation / re-plug operations.
  • Mass rebuild of global and local inventories.
  • OPatch mass updates.
  • Release Update & Release Update Revision apply.

Notes:
  • Read-Only Oracle Homes as per 21c requirement.
  • Vaulted passwords (Ansible).
  • Full RSA key-based SSH equivalence.
  • Fully abstracted file system item locations through OMF (Oracle Managed Files).

As of August 2023:
  • Developing series of Python-based Ansible collections / modules to shrink payload footprint.
  • Will address full requirement and specification checks and (en)force clear rational implementation standards platform-wise.
5 months
2023-11 - 2024-03

DB2 -to- Oracle 19c database migration of Temenos Transact (T24) archive tables

DB2 -to- Oracle 19c database migration of Temenos Transact (T24) archive tables.


Due to:

  • Temenos' end-of-support for IBM DB2.
  • Temenos Transact r10 -to- r21 upgrade.


Advisory as to ways per which current progress can be improved:

  • Storage sub-system.
  • Korn and bash scripting techniques.
  • DB2 export and SQL*Loader loading techniques.
  • Oracle database instance capacity / resource allocation options / rationale (big table caching, partitioning and sub-partitioning ...).


Technical context:

  • ~700 million rows.
  • DB2 export and SQL*Loader utilities in either LLS or ? terminated by ? LOBFILE mode.
  • Range, list and hash partitioning and sub-partitioning at Oracle end.
  • LOB and XMLtype data types at play.
  • Parallelized korn and bash scripting.
1 year 3 months
2022-01 - 2023-03

Oracle advanced support

Advanced support:

  • Liaison with Oracle Premier Support global expertise centers when it comes to following up on issues related to patching, Oracle Net tracing, BCT, ...


Consultancy regarding the implications of lifting-and-shifting Clearstream's on-premise databases to Google Cloud-hosted VMware engines. The said-implications being:

  • The transition of the current Veritas clusters-based DR solution to 3-node Data Guard maximum protection topologies.
  • Network traffic TLS-based encryption.
  • mTLS client / server authentication.
  • A possible upgrade from 19c non-CDBs to 21c multi-tenant containers.
  • A possible from-FS-to-ASM migration when it comes to the databases' storage option.


The aforementioned consultancy included documenting the entire Data Guard framework capabilities and implementation best practices (contents available at https://orcl.cf-o.net).

4 months
2022-01 - 2022-04

Exadata discovery work

Discovery work pertaining to Exadata Cloud@Customer Database Machines:

  • Documentation federation (available at https://exa.cf-o.net).
  • Exadata-related books reading.
  • Analysis of field engineering materials such as internal config- and check-lists.
  • Production of network topology- and hardware-centered schematics (DB and cell server back panels, Cisco RoCE and management switches arrangement...).
  • Admin-managed to policy-managed clustered database conversion testing.
  • Exawatcher archives fetched consolidation.
  • Scheduled jobs and systemd services inventory.
  • Exadata & Cell Servers-centered database dynamic view querying.
  • ...


Having had access to an ExaC@C lab environment, scripted the following in bash (assembled in one convenient support package):

  • Automated database instance discovery in terms of names, owning Unix groups and logins, supplementary groups, Oracle product home locations ...
  • Automated .profile file generation on a per database instance basis (i.e. automated discovery of the Unix process environments under which instances run).
  • Automated O/S platform memory configuration discovery in terms of RAM allocation, usage, and huge pages.
  • Automated Linux kernel tunable configuration gathering for reconciliation against Oracle requirements. (The same applying to so-called shell limits).
  • Built-up a set of SQL statements conveniently submittable through wrapped SQL*Plus calls generating readable tabbed Excel data (cell servers, cell disks, ASM disks and disk groups, ASM consumers, database instance initialization parameters ...).
7 months
2020-10 - 2021-04

RDBMS & Clusterware 19c products on Oracle Linux 7.9 and IBM PowerHA SystemMirror w/ Hyperswap

System architecture, implementation prototyping, technical counselling / documentation.


Context:

  • Migration of 59 business applications.
  • Clusterware / ASM-hosted standalone 19c Oracle database instances.
  • Incrementally-updated backup copies leveraging Fast Recovery Areas.
  • Non-HADR active / passive HyperSwap-enabled PowerHA SystemMirror stretched clusters.
  • ONTAP 9 and NetApp filers, exposing NTFS security-style file systems via SMB and NFSv3. Implicit user name mapping backed by LDAP-based (Ms AD) user principal provisioning (including Oracle Unix logins).


PM Assistance:


  • Counseled RBC application custodians, IBM project managers as well as delivery teams regarding the following technologies / methods and their proper implementation:
    ? Oracle Databases.
    ? Database data migrations.
    ? PowerHA SystemMirror.
    ? NetApp's ONTAP.

  • In that regard, liaised / worked with the following delivery teams / competencies.
    ? Oracle DBAs.
    ? Unix engineers.
    ? SAN & NAS engineers.
    ? Directory & IAM engineers.

  • Established the so-called « Oracle IWS » (Integration Work Sheet), for the purpose of facilitating the collection of requirements / specifications having to drive the provision of Oracle Databases.


Technical Documentation:

  • Established convention, requirement, as well as specification documentation regarding the provision of Oracle Database services (similarly to what was done for the CJUE).
  • With regard to specifications, proposed a Bronze / Silver / Gold offering.


Prototyping & Automation:

  • Prototyped, validated and documented the platform-agnostic, standardized implementation of The Oracle Clusterware / Database stack using Ansible 2.9 on Oracle Linux 7.9 running as VirtualBox VMs on 64-bit Slackware Current.
  • Also seized this opportunity to extend platform-agnostic Ansible automation processes to Oracle Linux 7.9 settings (kernel parameters via sysctl, shell limits, huge pages).
  • This endeavor resulted in the conception of a standardized, near-procedural Ansible playbook framework. Able, for example, to automate the collection and time-stamped naming of compressed log files.
  • Extended to the automation of the following operations:
    ? Database refreshes through RMAN-driven over-the-network duplications.
    ? Database backups.
7 months
2020-03 - 2020-09

Project management (8-node, two-cluster HPE Simplivity infrastructure platform delivery)

Assistance to State Street with regards to the delivery of an 8-node, two-cluster HPE Simplivity infrastructure platform aimed at substituting for legacy VMware ESXi 5.5-based hypervisors.

Such HPE Simplivity infrastructure having had to eventually host a set of 100+ migrated virtual machines, supporting business applications used by the Luxembourg branch of State Street Bank International GmbH.

Whose operation fell under IBM GTS Luxembourg's responsibility.

Change order abstract:
  • Coordinate and manage the technical activities of IBM's personnel.
  • Establish and maintain communications through the SSC Project Manager.
  • Assist the SSC Project Manager prepare and maintain the project plan which lists the activities, tasks, assignments, milestones and estimates for performance.
  • Measure, track and evaluate progress against the project plan.
  • Resolve deviations from the project plan with the SSC Project Manager.
  • Conduct regularly scheduled meetings, as necessary, with the SSC project team to review project status.
  • Prepare standard Status Reports through project duration for presentation to SSC Project Focal.

Liaised with Ireland- and India-based State Street project management and technical lead, so as to ensure jointly-driven, consensus-based technical decision making as regards OmniStack releases, network and Simplivity topologies.

Maintained required communication channels with IBM GTS India, the support of whom got obtained as regards proper engagement of HPE's support from a pure contractual perspective.

Liaised with IBM GTS Luxembourg VMware / Windows delivery teams involved in the operation / management / maintenance of State Street Luxembourg's virtualized environments.

Automated the generation of PDF-formatted Project Management Products for metrics publishing, including forecasts and rolling figures aggregated on a per billing code, per competency center basis.

Having allowed State Street Project/Program Management to get regularly updated so as to meet contracted Project Management requirements in that regard.
5 months
2020-02 - 2020-06

Project management (20+ Windows-based virtualized servers stock base delivery)

Management of the delivery of a 20+ Windows-based virtualized servers stock base.

This project was loosely-coupled with the latter.

So as to support the migration of business applications from Win2k8 to Windows 2016 servers running MS SQL Server instances.

Change order abstract:

  • Planning, coordination and communication across all segments of the projects.
  • Providing regular progress statements to client over the duration of the project that include, but are not limited to, completion reports and validation of budget vs actuals on all agreed to cadence.
  • Measure, track and evaluate progress against the project plan.
  • Resolve deviations from the project plan with the Client Project Manager.
  • Conduct regularly scheduled meetings, as necessary, with the client project team to review project status.

Liaised with U.S.- as well as India-based State Street technical support teams for handling enterprise identity authentication and authorization.

Liaised with Luxembourg-based State Street business application custodianship for counselling as to Release Management process best practices.

Maintained required communication channels with IBM GTS India to whom behooved the provision of the target O/S platform and hand-over to Luxembourg teams.

Maintained required communication channels with Luxembourg-based Windows and DBA delivery teams involved in setting up MS SQL Server instances and enforcing CSSF-mandated IT compliancy.

Automated the generation of PDF-formatted Project Management Products for metrics publishing, including forecasts and rolling figures aggregated on a per billing code, per competency center basis.

Having allowed State Street Project/Program Management to get regularly updated so as to meet contracted Project Management requirements in that regard.
2 months
2018-06 - 2018-07

Oracle schema migrations

Within the broader context of the migration of business applications from a legacy network shared by multiple banking entities to an IT infrastructure exclusively-dedicated to BIL, undertook the specific migration of database schemas by porting them from AIX-based 11gR2 Oracle Databases to Exadata X6-based, Linux-hosted Multi-Tenant 12c Containers.

This mainly involved Data Pump exports and imports.
  • Automated schema migration through shell scripting, encapsulating proper SQL DDL/DML statements.
  • Wrote data dictionary queries so as to perform prior scoping.

Schema migrations were required to be automated as much as possible, so as to ease the process for production DBAs. A migration involved a two-step process: first export, then import.

The export and import phases, which could be conducted independently as one piece, could be both run repeatedly until the migration process was definitively established. The creation of the target 12c PDBs was (obviously) a pre-requisite, and occurred once, independently.

Bash scripts encapsulating calls to SQL deliverables handling export and import jobs as well as a base canvas for pre- and post-import SQL scripts, were generated in a unified manner based on a set of input constants such as Unix login names, database instance names, 12c container service names, database account names ...

Which, among other things, allowed relevant scripts to reference file system locations hosting Data Pump dumps identically-exposed to both source and target systems via NFS.

Bash shell scripts were written so as to automatically execute, upon invocation, any additional, freely scriptable SQL-only pre-export and post-import deliverables, provided they were prefixed by a two-digit string acting as a simple ordering mechanism, and dropped at the proper file system location.
10 months
2017-08 - 2018-05

Level 2 & 3 database support

Provided level 2 & 3 support for customers of IBM Luxembourg Sàrl regarding operations of:
  • Oracle 11gR2 and 12cR1 RDBMSes on AIX, Linux and Windows operating environments (level 2 & 3).
  • Ms SQL Server 2008 R2, 2012 and 2016 databases (level 2).
  • SAP SQL Anywhere 17 databases on Linux and Windows operating environments (level 2).

Operations conducted primarily in support for a large Kirchberg-based financial institution in coordination with India-based teams.

Activities took place using a variety of tools.
  • Scheduling and storage management:
    ? BMC CONTROL-M.
    ? IBM Tivoli Storage Manager.
    ? User-managed.
  • Working environment:
    ? IBM's Red Hat Linux 7-based KVM (Windows 7 VM).
    ? Cross-firewall direct network connection to customer platforms via IBM's GSNI through OpenText SOCKS Client.
    ? IIS/ASP-, Korn, VBS-based scripting.

Level 2 & 3 support activities included:
  • Database copies/refreshes via either file copy, restore/recovery, and schema dumps (i.e. export/import).
  • Database software releases.
  • Compliancy (deviation assessment/correction based on IBM Tivoli Security Compliance Manager reports).
  • Performance troubleshooting (Oracle Databases).
  • Session tracing.
  • AWR/ASH report generation.
  • Automated reporting of Oracle tablespace capacities, database account privilege and ownership.

Oracle Database-related activities leveraged the development of a self-authored suite of IIS/ASP-Based tools that automate the generation of a variety of reports/routines, remotely (i.e. in such a manner that does away with the requirement of having to get a handle on the platform where the managed databases sit).

Examples:
  • Word or .pdf documents embedding pure-text and/or graphical GnuPlot-based graphs.
  • Operation SQL / Bash scripts.

Please see earlier experience at the Court of Justice of the European Union for examples of, for further examples, AWR reports.

This suite, whose purpose consists in getting around the possible unavailability of management tools such as OEM, Toad for Oracle... is installed locally to the DBA's Windows workstation, and therefore requires no installation other than of a local Oracle Client, alongside local Microsoft II Services.

Technologies and context:
  • ~350 databases.
  • Oracle Database releases 11gR2, 12cR1.
  • Ms SQL Server 2008 R2, 2012, 2016.
  • SAP SQL Anywhere 17.
  • IBM AIX.
  • 64-bit Red Hat Linux.
  • Microsoft Windows Server Platforms.
  • BMC CONTROL-M.
  • IBM Tivoli Storage Manager.
10 years 5 months
2007-03 - 2017-07

Oracle database administration (development through production environments).

Cleansed encountered Oracle implementation disorder following assessment of installed database platform / stock base.
  • Database product home installation standardization.
  • Management and scheduling centralization.
  • Database schema migrations/consolidations.

Abstracted database service presentation via implementation of load-balanced Oracle Connection Manager listeners.

Brought production, pre-production, and development databases to 24/7 service availability.

Centralized catalog-based RMAN backup management/scheduling.



Other activities included:

  • Database Product Home installation and patching.
    ? Appropriate SunOS Resource Control Facility and ZFS settings enforcement.
    ? Implementation of relevant Oracle Linux kernel parameterizations and resource limits.
    ? PSU/CPU patching via OPatch and Datapatch.

  • Database instantiation.
    ? Load of base options only.
    ? Oracle Text, XML DB, Spatial installation on demand.
    ? Enforcement of adequate direct/non-direct asynchronous I/O settings for UFS, ZFS, and ext4 file systems.
    ? Unified auditing management for 12cR1 releases.

  • Capacity reporting of AWR and non-AWR indicators (ad-hoc and automated dashboarding).
    ? 400+ AWR and non-AWR tabbed report topics covered.
    ? 40+ AWR GnuPlot-based graphical reports can be generated on-the-fly with no prior data consolidation.
    ? AWR reports are based on statements leveraging analytics functions.
    Examples:
    ? ASH ? Most active sessions (by CPU & wait counts).
    ? ASH ? Most active sessions (top statements by elapsed time & cost).
    ? Memory advisors ? Memory/SGA Target advice
    ? System metrics ? Commit & Rollback average.
    ? System metrics ? O/S load, instance & O/S CPU usage maximums.
    ? System statistics ? File I/O wait & service time.
    ? System statistics ? User calls & transaction rate.
    ? RMAN ? Job throughputs.
    ? Online Redo ? Daily & hourly switches.
    ? Online Redo ? Database work.
    ? ...

  • Database operations.
    ? Database intra-landscape copies as well as duplications (RMAN-based as well as user-managed).
    ? Inter- and intra-release database migrations/upgrades (8.1.5 ?> 9iR2, 10gR2 ?> 11gR2).

  • Advisory service to the AM (Application Management) business function for resolution of database-related, application-driven bottlenecks.
    ? SQL tuning sets-based statement profiling.
    ? Index creation advisory via SQL Access Advisor.

  • Database instance bottleneck assessment via:
    ? Confio's Ignite for Oracle (www.confio.com. Now known as Solarwinds. www.solarwinds.com).
    ? AWR-based ADDM, ASH and GnuPlot reports.

  • System-administration related:
    ? File system cleanup, consisting of archival, compression, and/or removal of Oracle-related items, such as old distributions, log and trace files.
    ? Oracle-related Unix login environments implementation rationalization.
    ? RSA-based ssh equivalence establishment/maintenance.
    ? 64-bit Oracle and Slackware Linux installation/optimization (O/S shrinkage in terms of packages as well as daemons).

Technologies and context:

  • ~100 databases (including Oracle AS & WebLogic infrastructure repositories).
  • Oracle Database product releases 9iR2, 10gR2, 11gR2, and 12cR1.
  • Oracle Recovery Manager.
  • 64-bit Oracle Unbreakable Linux releases 4.x, 5.x, 6.x
  • 64-bit Slackware Linux releases 14.1, 14.2.
  • SunOS5.10, SunOS5.9, and Microsoft Windows Server Platforms.
7 months
2014-04 - 2014-10

ASM-driven and ext4 file system-based Oracle 11gR2/12cR1 databases on 64-bit Oracle Linux 6.5 and VMware ESXi 5.5.

Prototype implementation: ASM-driven and ext4 file system-based Oracle 11gR2/12cR1 databases on 64-bit Oracle Linux 6.5 and VMware ESXi 5.5.

Data Guard 12c-enabled topologies in Maximum Performance Mode and Real-Type Apply.

As part of a project that retained VMware's ESXi hypervisor as the replacement platform for aging SPARC-based Oracle SunOS 5.10 global and local zones:


Examined candidate virtualization solutions:
  • Oracle VM 3.2.
  • VMware ESXi 5.5.
    ? CPU and memory resources allocation/reservation.
    ? Clustering mechanisms.
    ? Storage and networking.



Examined retained FAST (Fully Automated Storage Tiering) storage platform (EMC VNX 5500 series appliances).

  • FAST VPs.
  • FAST Cache.
  • Tiering policies.
  • Pool LUNs.



Implemented ASM-driven as well as ext4 file system-based Oracle 11gR2/12cR1 databases on retained virtualized O/S platform (64-bit Oracle Linux).


  • 64-bit Oracle Linux 6.5 installation and scripted configuration/tuning.
    ? Package set shrinkage.
    ? Huge pages and transparent huge pages management.
    ? Kernel limits.
    ? UEK kernel (ASMlib drivers) selection for Clusterware.
    ? RedHat compatible kernel otherwise.

  • Oracle Clusterware and Database 11gR2/12cR1 products scripted installation/configuration.
    ? Response files.
    ? File system layout.

  • Oracle ASM instance and disk group parameterization, management.

  • Oracle Database scripted configuration/instantiation.
    ? Light footprint (minimal set of database options).
    ? Automatic SGA/PGA Memory Management enabled (huge pages requirement).
    ? Automatic Memory Management disabled.

  • VMware template and virtual machine management.
    ? Reserved CPU and memory resources.
    ? Deployable 64-bit Oracle Linux 6.5 image shipping pre-installed Clusterware and Database products.
2 years 7 months
2011-06 - 2013-12

Apache HTTPd & Tomcat administration

Established and implemented Tomcat installation best practices.

  • JVM process isolation on a per-Unix basis.
  • Oracle Instant Client coupling.
  • Partition of ${CATALINA_HOME} & ${CATALINA_BASE} folder trees.
  • Scripted deployment and bounce procedures.
  • Ensured ${CATALINA_BASE} visibility to AM business function in a setgid-based restricted fashion in higher-level environments and via RBAC/pfexec on SunOS 5.10.

Load balanced Tomcat containers.

  • Port- and name-based virtual hosting management of forwarded AJP requests.
  • Sessionless load balancing via mod_jk.
  • Mod_rewrite usage.

Technologies and context:

  • ~20 multi-webapps Tomcat 6.0.x, 7.0.x containers.
  • 1.6, 1.7 64-bit JDKs.
  • 2.0, 2.2, 2.4 HTTPd.
4 years 4 months
2007-03 - 2011-06

Oracle Application Server (OAS) administration

  • OAS 10.1.2 and 10.1.3 installation/patching.
  • OC4J container instantiation, parameterization, and tuning.
  • Oracle Internet Directory bootstrapping / syncing with Ms Active Directory.
  • Oracle Web Cache & HTTPd 11.1.1.5 installation and administration.
  • Oracle Portal transportset exports and imports.

Technologies and context:

  • ~45 10gRx OAS instances.
  • Oracle Application Server 9.0.4 (10gR1), 10.1.2 (10gR2) and 10.1.3 (10gR3).
2 months
2008-09 - 2008-10

Consultancy on Oracle Database security technologies

Technical consulting on Oracle Database security technologies.
  • Technical counseling to a 4-person-large team of Oracle developers, regarding the following technologies:
  • Application context and Fine-Grained Access Control (Virtual Private Databases).
  • Secure Application Roles.
  • Support to this 4-person-large Oracle developer team took place at an average rate of 8 hours per week, over one and a half month.

Technology and context:
  • 400-table large Informix-to-Oracle migration.
  • Oracle Database 10gR2.
2 months
2006-06 - 2006-07

Reverse engineering, development amendments

Reverse engineering of Unix Korn-interpretable scripts, gluing software components within the implementation framework of Datazone's Miramo document management solution (www.miramo.com).

Amendment of Victor Buck Services' development, within the prospect of:

  • Richer runtime information logging.
  • Standardized logging formats, so that a supervision solution be implemented in a common fashion.
  • Compliance with newly established development guidelines.

Activities included:

  • Analysis of existing code.
  • Re-arrangement of file system structures better-able to organizing binaries, scripted contents, logging information pieces, and data subject to processing.
  • Development of a scripted logging facility, standardizing log output formats and calling methods.
  • Re-writing of scripted contents, leaning on newly developed procedural logging facility.

Technology and context:

  • SunOS5.9 on SPARC and Intel platforms.
  • Languages and technologies: Korn shell scripting.
9 months
2005-08 - 2006-04

Oracle Database administration (SAP Enterprise, WEBAS)

Oracle Database administration and performance auditing (SAP Enterprise, WEBAS).


Context:

  • Multiple-environment system landscapes (development, test, quality, production).
  • 22 databases (16 Enterprise, 4 WEBAS) sizing from 300Gb to 1.4Tb.
  • Oracle Database 9iR2.
  • SAP Enterprise releases 4.6C, WEBAS 6.20.


Activities:

  • System copies having involved restore operations of large databases, as well as point in time recovery and database re-incarnation (via control file re-creation).
  • Database and SAP basis performance-related statistical data collection and reporting.
  • Performance audit at Oracle and SAP module level (ABAP programs and SAP transactions).
  • Oracle and SAP parameterization adjustments when necessary.
  • Application design improvement proposals.

Technologies and context:

  • Oracle Database 9iR2.
  • IBM AIX 5.3.
  • Microsoft Windows Server platforms.
  • Languages and technologies: Unix Korn shell, IIS 5.0, VB Scripting edition, JavaScript, ASP, ADO, FSO.
2 years 7 months
2001-11 - 2004-05

Oracle Database and system administration

Oracle Database and system administration.

Context:

  • 30 databases sizing from a few hundreds MB to 20GB.
  • Oracle Database releases 7, 8, 8i and 9iR2.
  • 25 OLTP databases, 5 legacy datawarehouses.
  • 20 Windows Server hosts.

Activities:

  • Installation and daily database administration (backup, restore, scheduling, supervision).
  • Implementation of Oracle Data Guard (releases 8i and 9i).
  • Implementation of Oracle Enterprise Manager.
  • Oracle Database performance audit (wait event-, ratio-based analysis).
  • Consolidation of 15 Oracle servers within the context of operating system upgrades (NT4.0 -> W2K).
  • Inter- and intra-release Oracle migrations and upgrades.
  • Ms SQL Server 6.5 -> Oracle 9i migration.
  • ITIL documentation pertaining to offered Oracle services (Service Level Agreements).

Other activities: courses given on:

  • Contingency planning within the ITIL framework: 5 persons.
  • Web application development using Microsoft technologies: 10 persons.
  • Web development tips and techniques: 10 persons.
  • A groupware workflow solution (e-Works) developed by Robert Bosch GmbH: 10 persons.

Technologies and context:

  • Oracle Database releases 7.3.4, 8.0.6, 8.1.7, 9iR2, 10gR2.
  • Microsoft Windows Server platforms.
  • Languages and technologies: IIS 5.0, VB Scripting edition, JavaScript, ASP, ADO, WMI, FSO.
6 months
2001-05 - 2001-10

Procurement process analysis and computerization

Development of an ASP-scripted, HTML/DHTML procurement form, integrated to a Robert Bosch GmbH-made workflow system, served by Microsoft's IIS web server.

Connection to SAP's MM module repository achieved via DCOM Connector.

Activities included:

  • Attending classes given on e-Works, a proprietary workflow solution developed by Robert Bosch GmbH, leaning on a full-featured/customizable ASP-based engine, maintaining configuration and runtime data in an Oracle Database.
  • Installing Ms Windows NT 4.0 Server and configuring IIS. NTLM authentication. Two-environment landscape. Development and production. Local workstation and Compaq Proliant host respectively.
  • Scripting ASP pages involved manipulation of several object models, notably DCOM (allowing for dynamic retrieval/update of SAP's MM-module data).
  • Prototyping / validating functionalities in collaboration with a restricted group of end users.
  • Testing, implementation, and rollout.

Technologies and context:

  • Merise method.
  • SAP DCOM Connector.
  • Microsoft Windows Server platforms.
  • Languages and technologies: IIS 5.0, VB Scripting edition, JavaScript, ASP, ADO.
2 months
1999-07 - 1999-08

Software reengineering.

A solution based on a three-tier architecture supersedes the 1998 development (see 1998 experience), as an Oracle 8.0.6 database replaces the Ms Access data repository.

  • Back end tier: Oracle Database 8.
  • Business logic tier: Ms IIS 4.0.
  • Front end tier: Ms Internet Explorer.

This new implementation was motivated by easier application technical support, maintenance and deployment. Debuts took place in Frankfurt On The Main.

Activities included:

  • Installing Ms Windows NT 4.0 Server on top of which IIS also needed to be configured (NTLM authentication) in a two-environment landscape (development - local workstation, production - Compaq Proliant host).
  • Scripting ASP pages involving several object models, notably DAO (enabling access to the Oracle Database harboring inventory repository).
  • Prototyping / validating functionalities in collaboration with a restricted group of end users.
  • Testing, implementation, rollout.

Technologies and context:

  • Oracle Database 8.0.6.
  • Microsoft Windows Server platforms.
  • Languages and technologies: IIS 4.0, VB Scripting edition, JavaScript, ASP, ADO.
4 months
1998-06 - 1998-09

End-systems integration technical process analysis and computerization.

Process analysis based on the Merise method. Interviews, modelization, organizational improvement proposals.

End-systems: printers and personal computers.

Development of an Ms Outlook 98 form, which:

  • Collected process information as it programmatically navigated a set of Microsoft Exchange public folders, conceptually implementing the steps the form had to go through from process initiation to completion.
  • Made use of an Ms Access data repository.
  • Sent collected process information to Robert Bosch (France) S.A.S. suppliers via e-Mail, so that end-systems could be integrated with minimal inside assistance.

Technologies and context:

  • Merise Method.
  • Microsoft Windows NT 4.0 Workstation.
  • Languages and technologies: VB Scripting edition, VB for Applications, Microsoft Office 97 and Outlook 98 object models, CDO, DAO.

Einsatzorte

Einsatzorte

Deutschland, Schweiz, Österreich
möglich

Projekte

Projekte

2 years 8 months
2021-09 - now

DevOps / Ansible IaC

Work conducted in a personal capacity from time to time.

Taking Ansible works having taken place FEB & MAR 2021 further:

Regarding Clusterware:
  • Switched from ASMLib to ASM Filter Driver (ASMFD) when it comes to ASM instances.
  • Automated the deployment of Real Application Clusters? HAS & CRS stacks.
    ? (Slackware 14.2- & Windows 10-hosted VirtualBox VMs.)
    ? (Leveraging Bind for local authoritative DNS services.)
    ? (Local SCANs.)

Deployment automation encompasses:
  • 21c release multitenant standalone database products.
  • 21c CDBs and PDBs.
  • Database client products.
  • Fast-start failover Data Guard topologies.
  • TDE-encrypted databases via united-mode wallet configuration.
  • TLS self-signed certificates for mTLS DN matching-based authentication (all products).

Management automation encompasses:
  • RMAN-driven active database duplications.
  • RMAN- & DGMGRL-driven Data Guard topology deployments.
  • PDB unplug / relocation / re-plug operations.
  • Mass rebuild of global and local inventories.
  • OPatch mass updates.
  • Release Update & Release Update Revision apply.

Notes:
  • Read-Only Oracle Homes as per 21c requirement.
  • Vaulted passwords (Ansible).
  • Full RSA key-based SSH equivalence.
  • Fully abstracted file system item locations through OMF (Oracle Managed Files).

As of August 2023:
  • Developing series of Python-based Ansible collections / modules to shrink payload footprint.
  • Will address full requirement and specification checks and (en)force clear rational implementation standards platform-wise.
5 months
2023-11 - 2024-03

DB2 -to- Oracle 19c database migration of Temenos Transact (T24) archive tables

DB2 -to- Oracle 19c database migration of Temenos Transact (T24) archive tables.


Due to:

  • Temenos' end-of-support for IBM DB2.
  • Temenos Transact r10 -to- r21 upgrade.


Advisory as to ways per which current progress can be improved:

  • Storage sub-system.
  • Korn and bash scripting techniques.
  • DB2 export and SQL*Loader loading techniques.
  • Oracle database instance capacity / resource allocation options / rationale (big table caching, partitioning and sub-partitioning ...).


Technical context:

  • ~700 million rows.
  • DB2 export and SQL*Loader utilities in either LLS or ? terminated by ? LOBFILE mode.
  • Range, list and hash partitioning and sub-partitioning at Oracle end.
  • LOB and XMLtype data types at play.
  • Parallelized korn and bash scripting.
1 year 3 months
2022-01 - 2023-03

Oracle advanced support

Advanced support:

  • Liaison with Oracle Premier Support global expertise centers when it comes to following up on issues related to patching, Oracle Net tracing, BCT, ...


Consultancy regarding the implications of lifting-and-shifting Clearstream's on-premise databases to Google Cloud-hosted VMware engines. The said-implications being:

  • The transition of the current Veritas clusters-based DR solution to 3-node Data Guard maximum protection topologies.
  • Network traffic TLS-based encryption.
  • mTLS client / server authentication.
  • A possible upgrade from 19c non-CDBs to 21c multi-tenant containers.
  • A possible from-FS-to-ASM migration when it comes to the databases' storage option.


The aforementioned consultancy included documenting the entire Data Guard framework capabilities and implementation best practices (contents available at https://orcl.cf-o.net).

4 months
2022-01 - 2022-04

Exadata discovery work

Discovery work pertaining to Exadata Cloud@Customer Database Machines:

  • Documentation federation (available at https://exa.cf-o.net).
  • Exadata-related books reading.
  • Analysis of field engineering materials such as internal config- and check-lists.
  • Production of network topology- and hardware-centered schematics (DB and cell server back panels, Cisco RoCE and management switches arrangement...).
  • Admin-managed to policy-managed clustered database conversion testing.
  • Exawatcher archives fetched consolidation.
  • Scheduled jobs and systemd services inventory.
  • Exadata & Cell Servers-centered database dynamic view querying.
  • ...


Having had access to an ExaC@C lab environment, scripted the following in bash (assembled in one convenient support package):

  • Automated database instance discovery in terms of names, owning Unix groups and logins, supplementary groups, Oracle product home locations ...
  • Automated .profile file generation on a per database instance basis (i.e. automated discovery of the Unix process environments under which instances run).
  • Automated O/S platform memory configuration discovery in terms of RAM allocation, usage, and huge pages.
  • Automated Linux kernel tunable configuration gathering for reconciliation against Oracle requirements. (The same applying to so-called shell limits).
  • Built-up a set of SQL statements conveniently submittable through wrapped SQL*Plus calls generating readable tabbed Excel data (cell servers, cell disks, ASM disks and disk groups, ASM consumers, database instance initialization parameters ...).
7 months
2020-10 - 2021-04

RDBMS & Clusterware 19c products on Oracle Linux 7.9 and IBM PowerHA SystemMirror w/ Hyperswap

System architecture, implementation prototyping, technical counselling / documentation.


Context:

  • Migration of 59 business applications.
  • Clusterware / ASM-hosted standalone 19c Oracle database instances.
  • Incrementally-updated backup copies leveraging Fast Recovery Areas.
  • Non-HADR active / passive HyperSwap-enabled PowerHA SystemMirror stretched clusters.
  • ONTAP 9 and NetApp filers, exposing NTFS security-style file systems via SMB and NFSv3. Implicit user name mapping backed by LDAP-based (Ms AD) user principal provisioning (including Oracle Unix logins).


PM Assistance:


  • Counseled RBC application custodians, IBM project managers as well as delivery teams regarding the following technologies / methods and their proper implementation:
    ? Oracle Databases.
    ? Database data migrations.
    ? PowerHA SystemMirror.
    ? NetApp's ONTAP.

  • In that regard, liaised / worked with the following delivery teams / competencies.
    ? Oracle DBAs.
    ? Unix engineers.
    ? SAN & NAS engineers.
    ? Directory & IAM engineers.

  • Established the so-called « Oracle IWS » (Integration Work Sheet), for the purpose of facilitating the collection of requirements / specifications having to drive the provision of Oracle Databases.


Technical Documentation:

  • Established convention, requirement, as well as specification documentation regarding the provision of Oracle Database services (similarly to what was done for the CJUE).
  • With regard to specifications, proposed a Bronze / Silver / Gold offering.


Prototyping & Automation:

  • Prototyped, validated and documented the platform-agnostic, standardized implementation of The Oracle Clusterware / Database stack using Ansible 2.9 on Oracle Linux 7.9 running as VirtualBox VMs on 64-bit Slackware Current.
  • Also seized this opportunity to extend platform-agnostic Ansible automation processes to Oracle Linux 7.9 settings (kernel parameters via sysctl, shell limits, huge pages).
  • This endeavor resulted in the conception of a standardized, near-procedural Ansible playbook framework. Able, for example, to automate the collection and time-stamped naming of compressed log files.
  • Extended to the automation of the following operations:
    ? Database refreshes through RMAN-driven over-the-network duplications.
    ? Database backups.
7 months
2020-03 - 2020-09

Project management (8-node, two-cluster HPE Simplivity infrastructure platform delivery)

Assistance to State Street with regards to the delivery of an 8-node, two-cluster HPE Simplivity infrastructure platform aimed at substituting for legacy VMware ESXi 5.5-based hypervisors.

Such HPE Simplivity infrastructure having had to eventually host a set of 100+ migrated virtual machines, supporting business applications used by the Luxembourg branch of State Street Bank International GmbH.

Whose operation fell under IBM GTS Luxembourg's responsibility.

Change order abstract:
  • Coordinate and manage the technical activities of IBM's personnel.
  • Establish and maintain communications through the SSC Project Manager.
  • Assist the SSC Project Manager prepare and maintain the project plan which lists the activities, tasks, assignments, milestones and estimates for performance.
  • Measure, track and evaluate progress against the project plan.
  • Resolve deviations from the project plan with the SSC Project Manager.
  • Conduct regularly scheduled meetings, as necessary, with the SSC project team to review project status.
  • Prepare standard Status Reports through project duration for presentation to SSC Project Focal.

Liaised with Ireland- and India-based State Street project management and technical lead, so as to ensure jointly-driven, consensus-based technical decision making as regards OmniStack releases, network and Simplivity topologies.

Maintained required communication channels with IBM GTS India, the support of whom got obtained as regards proper engagement of HPE's support from a pure contractual perspective.

Liaised with IBM GTS Luxembourg VMware / Windows delivery teams involved in the operation / management / maintenance of State Street Luxembourg's virtualized environments.

Automated the generation of PDF-formatted Project Management Products for metrics publishing, including forecasts and rolling figures aggregated on a per billing code, per competency center basis.

Having allowed State Street Project/Program Management to get regularly updated so as to meet contracted Project Management requirements in that regard.
5 months
2020-02 - 2020-06

Project management (20+ Windows-based virtualized servers stock base delivery)

Management of the delivery of a 20+ Windows-based virtualized servers stock base.

This project was loosely-coupled with the latter.

So as to support the migration of business applications from Win2k8 to Windows 2016 servers running MS SQL Server instances.

Change order abstract:

  • Planning, coordination and communication across all segments of the projects.
  • Providing regular progress statements to client over the duration of the project that include, but are not limited to, completion reports and validation of budget vs actuals on all agreed to cadence.
  • Measure, track and evaluate progress against the project plan.
  • Resolve deviations from the project plan with the Client Project Manager.
  • Conduct regularly scheduled meetings, as necessary, with the client project team to review project status.

Liaised with U.S.- as well as India-based State Street technical support teams for handling enterprise identity authentication and authorization.

Liaised with Luxembourg-based State Street business application custodianship for counselling as to Release Management process best practices.

Maintained required communication channels with IBM GTS India to whom behooved the provision of the target O/S platform and hand-over to Luxembourg teams.

Maintained required communication channels with Luxembourg-based Windows and DBA delivery teams involved in setting up MS SQL Server instances and enforcing CSSF-mandated IT compliancy.

Automated the generation of PDF-formatted Project Management Products for metrics publishing, including forecasts and rolling figures aggregated on a per billing code, per competency center basis.

Having allowed State Street Project/Program Management to get regularly updated so as to meet contracted Project Management requirements in that regard.
2 months
2018-06 - 2018-07

Oracle schema migrations

Within the broader context of the migration of business applications from a legacy network shared by multiple banking entities to an IT infrastructure exclusively-dedicated to BIL, undertook the specific migration of database schemas by porting them from AIX-based 11gR2 Oracle Databases to Exadata X6-based, Linux-hosted Multi-Tenant 12c Containers.

This mainly involved Data Pump exports and imports.
  • Automated schema migration through shell scripting, encapsulating proper SQL DDL/DML statements.
  • Wrote data dictionary queries so as to perform prior scoping.

Schema migrations were required to be automated as much as possible, so as to ease the process for production DBAs. A migration involved a two-step process: first export, then import.

The export and import phases, which could be conducted independently as one piece, could be both run repeatedly until the migration process was definitively established. The creation of the target 12c PDBs was (obviously) a pre-requisite, and occurred once, independently.

Bash scripts encapsulating calls to SQL deliverables handling export and import jobs as well as a base canvas for pre- and post-import SQL scripts, were generated in a unified manner based on a set of input constants such as Unix login names, database instance names, 12c container service names, database account names ...

Which, among other things, allowed relevant scripts to reference file system locations hosting Data Pump dumps identically-exposed to both source and target systems via NFS.

Bash shell scripts were written so as to automatically execute, upon invocation, any additional, freely scriptable SQL-only pre-export and post-import deliverables, provided they were prefixed by a two-digit string acting as a simple ordering mechanism, and dropped at the proper file system location.
10 months
2017-08 - 2018-05

Level 2 & 3 database support

Provided level 2 & 3 support for customers of IBM Luxembourg Sàrl regarding operations of:
  • Oracle 11gR2 and 12cR1 RDBMSes on AIX, Linux and Windows operating environments (level 2 & 3).
  • Ms SQL Server 2008 R2, 2012 and 2016 databases (level 2).
  • SAP SQL Anywhere 17 databases on Linux and Windows operating environments (level 2).

Operations conducted primarily in support for a large Kirchberg-based financial institution in coordination with India-based teams.

Activities took place using a variety of tools.
  • Scheduling and storage management:
    ? BMC CONTROL-M.
    ? IBM Tivoli Storage Manager.
    ? User-managed.
  • Working environment:
    ? IBM's Red Hat Linux 7-based KVM (Windows 7 VM).
    ? Cross-firewall direct network connection to customer platforms via IBM's GSNI through OpenText SOCKS Client.
    ? IIS/ASP-, Korn, VBS-based scripting.

Level 2 & 3 support activities included:
  • Database copies/refreshes via either file copy, restore/recovery, and schema dumps (i.e. export/import).
  • Database software releases.
  • Compliancy (deviation assessment/correction based on IBM Tivoli Security Compliance Manager reports).
  • Performance troubleshooting (Oracle Databases).
  • Session tracing.
  • AWR/ASH report generation.
  • Automated reporting of Oracle tablespace capacities, database account privilege and ownership.

Oracle Database-related activities leveraged the development of a self-authored suite of IIS/ASP-Based tools that automate the generation of a variety of reports/routines, remotely (i.e. in such a manner that does away with the requirement of having to get a handle on the platform where the managed databases sit).

Examples:
  • Word or .pdf documents embedding pure-text and/or graphical GnuPlot-based graphs.
  • Operation SQL / Bash scripts.

Please see earlier experience at the Court of Justice of the European Union for examples of, for further examples, AWR reports.

This suite, whose purpose consists in getting around the possible unavailability of management tools such as OEM, Toad for Oracle... is installed locally to the DBA's Windows workstation, and therefore requires no installation other than of a local Oracle Client, alongside local Microsoft II Services.

Technologies and context:
  • ~350 databases.
  • Oracle Database releases 11gR2, 12cR1.
  • Ms SQL Server 2008 R2, 2012, 2016.
  • SAP SQL Anywhere 17.
  • IBM AIX.
  • 64-bit Red Hat Linux.
  • Microsoft Windows Server Platforms.
  • BMC CONTROL-M.
  • IBM Tivoli Storage Manager.
10 years 5 months
2007-03 - 2017-07

Oracle database administration (development through production environments).

Cleansed encountered Oracle implementation disorder following assessment of installed database platform / stock base.
  • Database product home installation standardization.
  • Management and scheduling centralization.
  • Database schema migrations/consolidations.

Abstracted database service presentation via implementation of load-balanced Oracle Connection Manager listeners.

Brought production, pre-production, and development databases to 24/7 service availability.

Centralized catalog-based RMAN backup management/scheduling.



Other activities included:

  • Database Product Home installation and patching.
    ? Appropriate SunOS Resource Control Facility and ZFS settings enforcement.
    ? Implementation of relevant Oracle Linux kernel parameterizations and resource limits.
    ? PSU/CPU patching via OPatch and Datapatch.

  • Database instantiation.
    ? Load of base options only.
    ? Oracle Text, XML DB, Spatial installation on demand.
    ? Enforcement of adequate direct/non-direct asynchronous I/O settings for UFS, ZFS, and ext4 file systems.
    ? Unified auditing management for 12cR1 releases.

  • Capacity reporting of AWR and non-AWR indicators (ad-hoc and automated dashboarding).
    ? 400+ AWR and non-AWR tabbed report topics covered.
    ? 40+ AWR GnuPlot-based graphical reports can be generated on-the-fly with no prior data consolidation.
    ? AWR reports are based on statements leveraging analytics functions.
    Examples:
    ? ASH ? Most active sessions (by CPU & wait counts).
    ? ASH ? Most active sessions (top statements by elapsed time & cost).
    ? Memory advisors ? Memory/SGA Target advice
    ? System metrics ? Commit & Rollback average.
    ? System metrics ? O/S load, instance & O/S CPU usage maximums.
    ? System statistics ? File I/O wait & service time.
    ? System statistics ? User calls & transaction rate.
    ? RMAN ? Job throughputs.
    ? Online Redo ? Daily & hourly switches.
    ? Online Redo ? Database work.
    ? ...

  • Database operations.
    ? Database intra-landscape copies as well as duplications (RMAN-based as well as user-managed).
    ? Inter- and intra-release database migrations/upgrades (8.1.5 ?> 9iR2, 10gR2 ?> 11gR2).

  • Advisory service to the AM (Application Management) business function for resolution of database-related, application-driven bottlenecks.
    ? SQL tuning sets-based statement profiling.
    ? Index creation advisory via SQL Access Advisor.

  • Database instance bottleneck assessment via:
    ? Confio's Ignite for Oracle (www.confio.com. Now known as Solarwinds. www.solarwinds.com).
    ? AWR-based ADDM, ASH and GnuPlot reports.

  • System-administration related:
    ? File system cleanup, consisting of archival, compression, and/or removal of Oracle-related items, such as old distributions, log and trace files.
    ? Oracle-related Unix login environments implementation rationalization.
    ? RSA-based ssh equivalence establishment/maintenance.
    ? 64-bit Oracle and Slackware Linux installation/optimization (O/S shrinkage in terms of packages as well as daemons).

Technologies and context:

  • ~100 databases (including Oracle AS & WebLogic infrastructure repositories).
  • Oracle Database product releases 9iR2, 10gR2, 11gR2, and 12cR1.
  • Oracle Recovery Manager.
  • 64-bit Oracle Unbreakable Linux releases 4.x, 5.x, 6.x
  • 64-bit Slackware Linux releases 14.1, 14.2.
  • SunOS5.10, SunOS5.9, and Microsoft Windows Server Platforms.
7 months
2014-04 - 2014-10

ASM-driven and ext4 file system-based Oracle 11gR2/12cR1 databases on 64-bit Oracle Linux 6.5 and VMware ESXi 5.5.

Prototype implementation: ASM-driven and ext4 file system-based Oracle 11gR2/12cR1 databases on 64-bit Oracle Linux 6.5 and VMware ESXi 5.5.

Data Guard 12c-enabled topologies in Maximum Performance Mode and Real-Type Apply.

As part of a project that retained VMware's ESXi hypervisor as the replacement platform for aging SPARC-based Oracle SunOS 5.10 global and local zones:


Examined candidate virtualization solutions:
  • Oracle VM 3.2.
  • VMware ESXi 5.5.
    ? CPU and memory resources allocation/reservation.
    ? Clustering mechanisms.
    ? Storage and networking.



Examined retained FAST (Fully Automated Storage Tiering) storage platform (EMC VNX 5500 series appliances).

  • FAST VPs.
  • FAST Cache.
  • Tiering policies.
  • Pool LUNs.



Implemented ASM-driven as well as ext4 file system-based Oracle 11gR2/12cR1 databases on retained virtualized O/S platform (64-bit Oracle Linux).


  • 64-bit Oracle Linux 6.5 installation and scripted configuration/tuning.
    ? Package set shrinkage.
    ? Huge pages and transparent huge pages management.
    ? Kernel limits.
    ? UEK kernel (ASMlib drivers) selection for Clusterware.
    ? RedHat compatible kernel otherwise.

  • Oracle Clusterware and Database 11gR2/12cR1 products scripted installation/configuration.
    ? Response files.
    ? File system layout.

  • Oracle ASM instance and disk group parameterization, management.

  • Oracle Database scripted configuration/instantiation.
    ? Light footprint (minimal set of database options).
    ? Automatic SGA/PGA Memory Management enabled (huge pages requirement).
    ? Automatic Memory Management disabled.

  • VMware template and virtual machine management.
    ? Reserved CPU and memory resources.
    ? Deployable 64-bit Oracle Linux 6.5 image shipping pre-installed Clusterware and Database products.
2 years 7 months
2011-06 - 2013-12

Apache HTTPd & Tomcat administration

Established and implemented Tomcat installation best practices.

  • JVM process isolation on a per-Unix basis.
  • Oracle Instant Client coupling.
  • Partition of ${CATALINA_HOME} & ${CATALINA_BASE} folder trees.
  • Scripted deployment and bounce procedures.
  • Ensured ${CATALINA_BASE} visibility to AM business function in a setgid-based restricted fashion in higher-level environments and via RBAC/pfexec on SunOS 5.10.

Load balanced Tomcat containers.

  • Port- and name-based virtual hosting management of forwarded AJP requests.
  • Sessionless load balancing via mod_jk.
  • Mod_rewrite usage.

Technologies and context:

  • ~20 multi-webapps Tomcat 6.0.x, 7.0.x containers.
  • 1.6, 1.7 64-bit JDKs.
  • 2.0, 2.2, 2.4 HTTPd.
4 years 4 months
2007-03 - 2011-06

Oracle Application Server (OAS) administration

  • OAS 10.1.2 and 10.1.3 installation/patching.
  • OC4J container instantiation, parameterization, and tuning.
  • Oracle Internet Directory bootstrapping / syncing with Ms Active Directory.
  • Oracle Web Cache & HTTPd 11.1.1.5 installation and administration.
  • Oracle Portal transportset exports and imports.

Technologies and context:

  • ~45 10gRx OAS instances.
  • Oracle Application Server 9.0.4 (10gR1), 10.1.2 (10gR2) and 10.1.3 (10gR3).
2 months
2008-09 - 2008-10

Consultancy on Oracle Database security technologies

Technical consulting on Oracle Database security technologies.
  • Technical counseling to a 4-person-large team of Oracle developers, regarding the following technologies:
  • Application context and Fine-Grained Access Control (Virtual Private Databases).
  • Secure Application Roles.
  • Support to this 4-person-large Oracle developer team took place at an average rate of 8 hours per week, over one and a half month.

Technology and context:
  • 400-table large Informix-to-Oracle migration.
  • Oracle Database 10gR2.
2 months
2006-06 - 2006-07

Reverse engineering, development amendments

Reverse engineering of Unix Korn-interpretable scripts, gluing software components within the implementation framework of Datazone's Miramo document management solution (www.miramo.com).

Amendment of Victor Buck Services' development, within the prospect of:

  • Richer runtime information logging.
  • Standardized logging formats, so that a supervision solution be implemented in a common fashion.
  • Compliance with newly established development guidelines.

Activities included:

  • Analysis of existing code.
  • Re-arrangement of file system structures better-able to organizing binaries, scripted contents, logging information pieces, and data subject to processing.
  • Development of a scripted logging facility, standardizing log output formats and calling methods.
  • Re-writing of scripted contents, leaning on newly developed procedural logging facility.

Technology and context:

  • SunOS5.9 on SPARC and Intel platforms.
  • Languages and technologies: Korn shell scripting.
9 months
2005-08 - 2006-04

Oracle Database administration (SAP Enterprise, WEBAS)

Oracle Database administration and performance auditing (SAP Enterprise, WEBAS).


Context:

  • Multiple-environment system landscapes (development, test, quality, production).
  • 22 databases (16 Enterprise, 4 WEBAS) sizing from 300Gb to 1.4Tb.
  • Oracle Database 9iR2.
  • SAP Enterprise releases 4.6C, WEBAS 6.20.


Activities:

  • System copies having involved restore operations of large databases, as well as point in time recovery and database re-incarnation (via control file re-creation).
  • Database and SAP basis performance-related statistical data collection and reporting.
  • Performance audit at Oracle and SAP module level (ABAP programs and SAP transactions).
  • Oracle and SAP parameterization adjustments when necessary.
  • Application design improvement proposals.

Technologies and context:

  • Oracle Database 9iR2.
  • IBM AIX 5.3.
  • Microsoft Windows Server platforms.
  • Languages and technologies: Unix Korn shell, IIS 5.0, VB Scripting edition, JavaScript, ASP, ADO, FSO.
2 years 7 months
2001-11 - 2004-05

Oracle Database and system administration

Oracle Database and system administration.

Context:

  • 30 databases sizing from a few hundreds MB to 20GB.
  • Oracle Database releases 7, 8, 8i and 9iR2.
  • 25 OLTP databases, 5 legacy datawarehouses.
  • 20 Windows Server hosts.

Activities:

  • Installation and daily database administration (backup, restore, scheduling, supervision).
  • Implementation of Oracle Data Guard (releases 8i and 9i).
  • Implementation of Oracle Enterprise Manager.
  • Oracle Database performance audit (wait event-, ratio-based analysis).
  • Consolidation of 15 Oracle servers within the context of operating system upgrades (NT4.0 -> W2K).
  • Inter- and intra-release Oracle migrations and upgrades.
  • Ms SQL Server 6.5 -> Oracle 9i migration.
  • ITIL documentation pertaining to offered Oracle services (Service Level Agreements).

Other activities: courses given on:

  • Contingency planning within the ITIL framework: 5 persons.
  • Web application development using Microsoft technologies: 10 persons.
  • Web development tips and techniques: 10 persons.
  • A groupware workflow solution (e-Works) developed by Robert Bosch GmbH: 10 persons.

Technologies and context:

  • Oracle Database releases 7.3.4, 8.0.6, 8.1.7, 9iR2, 10gR2.
  • Microsoft Windows Server platforms.
  • Languages and technologies: IIS 5.0, VB Scripting edition, JavaScript, ASP, ADO, WMI, FSO.
6 months
2001-05 - 2001-10

Procurement process analysis and computerization

Development of an ASP-scripted, HTML/DHTML procurement form, integrated to a Robert Bosch GmbH-made workflow system, served by Microsoft's IIS web server.

Connection to SAP's MM module repository achieved via DCOM Connector.

Activities included:

  • Attending classes given on e-Works, a proprietary workflow solution developed by Robert Bosch GmbH, leaning on a full-featured/customizable ASP-based engine, maintaining configuration and runtime data in an Oracle Database.
  • Installing Ms Windows NT 4.0 Server and configuring IIS. NTLM authentication. Two-environment landscape. Development and production. Local workstation and Compaq Proliant host respectively.
  • Scripting ASP pages involved manipulation of several object models, notably DCOM (allowing for dynamic retrieval/update of SAP's MM-module data).
  • Prototyping / validating functionalities in collaboration with a restricted group of end users.
  • Testing, implementation, and rollout.

Technologies and context:

  • Merise method.
  • SAP DCOM Connector.
  • Microsoft Windows Server platforms.
  • Languages and technologies: IIS 5.0, VB Scripting edition, JavaScript, ASP, ADO.
2 months
1999-07 - 1999-08

Software reengineering.

A solution based on a three-tier architecture supersedes the 1998 development (see 1998 experience), as an Oracle 8.0.6 database replaces the Ms Access data repository.

  • Back end tier: Oracle Database 8.
  • Business logic tier: Ms IIS 4.0.
  • Front end tier: Ms Internet Explorer.

This new implementation was motivated by easier application technical support, maintenance and deployment. Debuts took place in Frankfurt On The Main.

Activities included:

  • Installing Ms Windows NT 4.0 Server on top of which IIS also needed to be configured (NTLM authentication) in a two-environment landscape (development - local workstation, production - Compaq Proliant host).
  • Scripting ASP pages involving several object models, notably DAO (enabling access to the Oracle Database harboring inventory repository).
  • Prototyping / validating functionalities in collaboration with a restricted group of end users.
  • Testing, implementation, rollout.

Technologies and context:

  • Oracle Database 8.0.6.
  • Microsoft Windows Server platforms.
  • Languages and technologies: IIS 4.0, VB Scripting edition, JavaScript, ASP, ADO.
4 months
1998-06 - 1998-09

End-systems integration technical process analysis and computerization.

Process analysis based on the Merise method. Interviews, modelization, organizational improvement proposals.

End-systems: printers and personal computers.

Development of an Ms Outlook 98 form, which:

  • Collected process information as it programmatically navigated a set of Microsoft Exchange public folders, conceptually implementing the steps the form had to go through from process initiation to completion.
  • Made use of an Ms Access data repository.
  • Sent collected process information to Robert Bosch (France) S.A.S. suppliers via e-Mail, so that end-systems could be integrated with minimal inside assistance.

Technologies and context:

  • Merise Method.
  • Microsoft Windows NT 4.0 Workstation.
  • Languages and technologies: VB Scripting edition, VB for Applications, Microsoft Office 97 and Outlook 98 object models, CDO, DAO.

Vertrauen Sie auf GULP

Im Bereich Freelancing
Im Bereich Arbeitnehmerüberlassung / Personalvermittlung

Fragen?

Rufen Sie uns an +49 89 500316-300 oder schreiben Sie uns:

Das GULP Freelancer-Portal

Direktester geht's nicht! Ganz einfach Freelancer finden und direkt Kontakt aufnehmen.