Strefainzyniera.pl


RYNEK PRACA ROZWÓJ

  • Analiza
  • Architektura
  • Badania i rozwój
  • Budownictwo i Geodezja
  • Energetyka i Gazownictwo
  • Geologia i Hydrologia
  • Informatyka/Administracja
  • Informatyka/Programowanie
  • Instalacja i Serwis
  • Internet / E-commerce
  • Inżynieria/Elektronika/Technologia
  • Kontrola jakości/BHP
  • Logistyka i transport
  • Motoryzacja
  • Nieruchomości/Budownictwo
  • Ochrona środowiska
  • Produkcja / Przemysł
  • Rolnictwo i Hodowla
  • Telekomunikacja

Oracle Database Developer

Polska, Wrocław, dolnośląskie
2018.01.15
Aptitude Software (Poland) Sp. z o.o. (wcześniej Microgen Poland Sp. z o.o.)

We are looking for a Oracle Database Developer to design and develop our financial application products and perform tuning of the database instances and queries.

You will be involved in the full application development lifecycle working within an agile team environment.

 

  • Design, develop, implement and maintain SQL and PL/SQL stored program units/packages and maintain coding standards

  • Write and perform unit tests for the PL/SQL stored program units/packages

  • Conduct performance analysis and tuning of the processes and database

  • Diagnose performance issues using both AWR and ASH reports, and Statspack 

  • Identify and analyze performance issues and provide solutions

  • Determine data partitioning, indexing, shared pool configurations to optimise the performance

  • Develop business logic and complex calculation rules

  • Help support lab based benchmarking exercises

  • Collaborate with key business and technology stakeholders to define functional and technical design

  • Lead and/or participate in delivery activities using an Agile development methodology, working as part of a multi discipline team

  • Participate and present at formal and informal design reviews, playbacks, and retrospectives

  • Collaborate with Testers to develop comprehensive and appropriate test strategies for each release. 


The ideal candidate will have the following skills, attributes & experience:

  • Experience in application development and design

  • High proficiency with SQL and PL/SQL

  • Expert level understanding of Oracle database architecture

  • Excellent knowledge of both database and program code performance    tuning

  • Experience in analysing AWR reports and use as baseline for proactively  monitoring and tuning

  • Familiar with the peculiarities and sensitivities of the query optimiser and  methods to force particular behaviours

  • Understanding of execution plans, use of statistics

  • Good skills in all Oracle tools including Oracle Enterprise Manager

  • Understanding of related hardware configurations, IOPS, disk subsystems, etc.

  • Familiar with Oracle 12c, RAC and Exadata

  • Knowledge of UNIX and Windows operating systems and tools

  • Track record of adapting to frequently changing requirements and priorities

  • Strong interpersonal, teamwork and problem-solving skills

  • Motivated, adaptable, results-focused, and accountable for delivering        accurate and timely results

  • Educated to degree level or higher, preferably in Computer Science,      Mathematics or Economics

  • Good spoken and written English

 Advantageous Skills

  • Oracle Database 12c Performance Management and Tuning Certified Expert Certification

  • Experience with Teradata database

  • Experience with DevOps, Continuous Delivery, Continuous Integration

  • Working knowledge of Jira

  • Experience of designing Financial Systems/General Ledger

  • Knowledge of accounting and regulatory compliance

  • Experience of Scaled Agile Framework (SAFe)

 

wszystkie oferty