Senior Oracle Developer

• Consulting and supporting application developers on database topics

• Design and development of interfaces

• Performance optimization

• Automation of rollout and release processes in the DB environment

• Implementation of security requirements

• Delivering key figures to management

• Rollout automation: development of new scripts to automate rollouts, implementation of security requirements, adapting scripts for database deployments (PL/SQL, SQL, Git, Artifactory, Shell)

• Migration of Oracle databases from Oracle 12 to Oracle 19: identifying issues, adjusting DB parameters, permissions and roles, script adjustments (Oracle 12, Oracle 19, PL/SQL, Toad, Git, Artifactory)

• Migration of Oracle instances from AWS EC2 to AWS RDS: feasibility study and migration of structure and data (Oracle 12c, Toad, Git, AWS RDS)

• Migration of software versioning from SVN to Git/Artifactory: enhancing a delivery/packaging tool via Artifactory REST API and process alignment (Ruby, Git, Artifactory)

• Performance optimization of various Oracle instances: analysis of Statspack/AWR reports, configuration recommendations, SQL optimization (Oracle 12c, PL/SQL, Toad, SVN, Oracle AWR)

• SSL/TLS encryption of an Oracle DB: proof of concept, server and client configuration, rollout plan (Oracle 12c, Toad, SVN)

• Oracle user authentication with Kerberos: proof of concept, single sign-on configuration, permission concept, rollout plan (Oracle 12c, Toad, SVN)

• Database selection consulting: workshops for requirement analysis, presenting SQL/NoSQL/Amazon S3 solutions, team collaboration

• Creating a containerized Postgres DB: data modeling, stored procedures for partitioning, Liquibase scripts for Git pipeline (PostgresSQL, PL/SQL, Docker, YAML, Git)

• Refactoring an interface for mass data export: analysis and optimization of SQL queries, redevelopment of a PL/SQL package (Oracle 12c, PL/SQL, Toad, SVN, Oracle AWR)

• Connecting a REST service to an Oracle database: developing a PL/SQL package for SOAP communication, response evaluation, HTTPS configuration (Oracle 12c, PL/SQL, Toad, SVN)

• Cloud migration of an Oracle DB: on-premise analysis, migration scripts, AWS RDS (Oracle 12c, PL/SQL, Toad, PL/SQL Developer, Oracle AWR, Amazon RDS)

• Development/enhancement of PL/SQL functions: performance optimization, application integration, offloading business logic

• Planning and preparation of new databases/database schemas: evaluation of SQL execution plans, use of the Automatic Workload Repository (Oracle 11g/12c, PL/SQL, Toad, PL/SQL Developer, Oracle AWR)

• Import of SSIM flight schedule data into an Oracle database
• Import of flight schedule data in various airline-specific formats

Tools used: Powerbuilder 10.5, 11.5, Oracle 11g/12c

• Data modeling
• Development of forms and user interfaces
• Reporting and data analysis

Tools used: MS Access (up to Access 2019), VBA, ODBC, MS Office (up to Office 365)

• Imported various SAP IDOC formats (LOIBOM, MATMAS) into a Powerbuilder/Oracle application
• Created various IDOC types (ORDERS, MBGMCR, ALEAUD) for export to SAP
• Imported SAP master data in XML format into Oracle DB

Tools used: Powerbuilder 10.5, 11.5, C++, Oracle 11g