Database Specialist

3 miesięcy temu

Warsaw, Polska HIRELY Pełny etat

Spółkę HIRELY tworzą profesjonaliści, którzy posiadają wiele lat doświadczenia w takich obszarach jak: IT, BI, zarządzanie projektami i przedsiębiorstwami. Cechuje nas wysoka jakość i efektywność realizowanych projektów poprzez właściwe dopasowanie kandydata do profilu poszukiwanego stanowiska i kultury organizacyjnej panującej w firmie.

Partnerstwo, rzetelność i transparentność – to wartości, którymi kierujemy się we wszystkich naszych działaniach.

About the company

HIRELY company is formed by professionals who have many years of experience in such areas as IT, BI, project and enterprise management. We are defined by high quality and efficiency of projects carried out through proper matching of the candidate to the profile of the position sought and the organizational culture prevailing in the company.

Partnership, reliability and transparency - these are the values that guide us in all our activities.

Opis stanowiska

Poszukujemy specjalisty ds. baz danych dla projektu migracji i długoterminowej konfiguracji bazy danych. Kandydat będzie częścią zespołu programistów. 

Projekt dotyczy nowego produktu:  Elektronicznego Rejestru Medycznego (EMR) opartego na przeglądarce, stworzonego specjalnie dla okulistów. Zapewnia pełen zakres funkcji jako system zarządzania praktyką (PMS) i integruje się ze wszystkimi urządzeniami medycznymi i interfejsami oprogramowania w środowisku oprogramowania praktyki lub kliniki.
Oprogramowanie jest obecnie oparte na bazie danych Firebird. Ze względu na wymagania klienta i projektu, zostanie ono zmigrowane do bazy danych PostgreSQL. 

Job description

We are looking for support from a database specialist for the migration project and the long-run set-up of the database. The candidate will be part of the development team.

It is the new product generation:  A browser-based Electronic Medical Record (EMR), specially built for ophthalmologists. It provides a full range of functions as a Practice Management System (PMS) and integrates with all medical devices and software interfaces within a practice’s or clinic’s software environment.

The software is currently based on a Firebird database. Due to customer and project requirements, this shall be migrated to a PostgreSQL database. 

Benefity

  • Karta Multisport
  • Prywatna opieka medyczna

Benefits

  • Multisport card
  • Private medical care

Wymagane doświadczenie

Zakres obowiązków:

  • Planowanie i realizacja migracji danych z Firebird do PostgreSQL.
  • Konwersja i dostosowanie zapytań SQL, procedur, wyzwalaczy i innych funkcji związanych z bazą danych do składni i funkcjonalności PostgreSQL.
  • Zapewnienie spójności i integralności danych podczas procesu migracji.
  • Przeprowadzanie testów wydajności i optymalizacja nowej bazy danych PostgreSQL.
  • Wspieranie konfiguracji serwera PostgreSQL w celu zapewnienia optymalnej wydajności.
  • Tworzenie dokumentacji procesu migracji i nowej struktury bazy danych.

Wymagania:

  • Doświadczenie w migracjach baz danych: 
    - Kilkuletnie doświadczenie w migracji relacyjnych baz danych, najlepiej z Firebird do PostgreSQL.
  • Znajomość PostgreSQL:
    - Solidne zrozumienie systemu baz danych PostgreSQL, w tym jego architektury, składni SQL i technik optymalizacji. Idealnie, solidna znajomość systemu baz danych Firebird.
  • SQL i PL/pgSQL:
    - Doskonałe umiejętności w zakresie SQL i skryptów do migracji danych. 
    - Pożądana jest znajomość PL/pgSQL (języka proceduralnego PostgreSQL).
  • Administracja bazami danych: 
    - Doświadczenie w zarządzaniu i konfigurowaniu serwerów baz danych, w szczególności PostgreSQL.
  • Integralność i bezpieczeństwo danych:
    - Znajomość technik zapewniających integralność danych i minimalizujących ich utratę podczas migracji.
  • Znajomość strategii tworzenia kopii zapasowych i przywracania baz danych.
  • Doświadczenie w dostrajaniu wydajności i optymalizacji baz danych PostgreSQL.
  • Podstawowa znajomość konfiguracji sieci i ustawień bezpieczeństwa dla serwerów baz danych

 

Experience required

Responsibilities:

  • Planning and execution of data migration from Firebird to PostgreSQL.
  • Conversion and adjustment of SQL queries, procedures, triggers, and other database-related functions to PostgreSQL syntax and functionality.
  • Ensuring data consistency and integrity during the migration process.
  • Conducting performance tests and optimizing the new PostgreSQL database.
  • Supporting the configuration of the PostgreSQL server to ensure optimal performance.
  • Creating documentation for the migration process and the new database structure.

Requirements:

  • Experience with database migrations: 
    - Several years of experience in migrating relational databases, preferably from Firebird to Post-greSQL.
  • Knowledge of PostgreSQL:
    - Solid understanding of the PostgreSQL database system, including its architecture, SQL syntax, and optimization techniques. Ideally, solid knowledge of the Firebird database system as well.
  • SQL and PL/pgSQL:
    - Excellent skills in SQL and scripting for data migration. 
    - Knowledge of PL/pgSQL (PostgreSQL’s procedural language) is desirable.
  • Database administration: 
    - Experience with managing and configuring database servers, particularly PostgreSQL.
  • Data integrity and security:
    - Familiarity with techniques to ensure data integrity and minimize data loss during migration.
  • Knowledge of backup and restore strategies for databases.
  • Experience with performance tuning and optimization of PostgreSQL databases.
  • Basic knowledge of network configurations and security settings for database servers

  • Database Specialist

    5 miesięcy temu

    Warsaw, Polska 300Brains Sp. z o. o. Pełny etat

    Database SpecialistFULL REMOTE About us:We are an international, Polish-American company called 300Brains, operating in the area of Information Technology with the aim of supporting international companies, primarily startups, in the implementation of their brilliant ideas.For our client, we are seeking an experienced Database Specialist to manage and...

  • Database Specialist

    1 miesiąc temu

    Warsaw, Polska Michael Page Pełny etat

    Database Development & Management: Design, optimize, and maintain PostgreSQL databases to ensure high performance and reliability, especially for high transaction volumes typical in financial systems.Stored Procedures & Compliance: Develop complex stored procedures in PL/pgSQL to meet banking and regulatory requirements, with an emphasis on data integrity...

  • Cloud Database Engineer

    5 miesięcy temu

    Warsaw, Polska PAYBACK Pełny etat

    PAYBACK is unique worldwide in data-based marketing. With the ability to develop digital business models and implement technical trends, we are pioneers of the data economy. The technical solutions for our 31 million customers relating to the PAYBACK program are designed and operated in-house. To this end, we work with the latest technologies and in a...

  • Expert IT Security Specialist

    7 miesięcy temu

    Warsaw, Polska emagine Consulting Pełny etat

    Industry: Finance / Banking Location: Gdańsk / Warsaw (Hybrid Work Model) Project Languages: English and Polish Rate: -zł/h net+VAT Duration: Long term Join dynamic team in the Finance/Banking industry! We are currently seeking a skilled Expert IT Security Specialist to contribute to our data protection and information security initiatives....

  • Database Software Test Engineer

    1 miesiąc temu

    Warsaw, Polska Visa Pełny etat

    Job DescriptionSr Software Test Engineering team is part of Sales, Client Service and Experience PD and is responsible for managing system requirements, design, development, integration, quality assurance, implementation, and maintenance of corporate applications. The team works closely with business owners of these services to deliver industry leading...

  • Data Processing Specialist

    4 miesięcy temu

    Warsaw, Polska NielsenIQ Pełny etat

    Job Description About this Job Data Processing Specialist  delivers one of the processes necessary to create a database or report for our clients (top FMCG companies and retailers). The processes include validating the data, setting up the database, coding products by providing characteristics and managing data samples.  Responsibilities ...

  • Recruitment Specialist

    2 tygodni temu

    Warsaw, Polska eolica_corcaigh_bv Pełny etat

    Forte Renewables is a global renewable energy consultancy specialising in wind, solar and energy storage generation. Our mission is to be an industry leader by providing best-in-class technical services tailored to the complex and diverse needs of our clients to ensure they achieve their project goals. Since its inception in 2012, Forte has delivered...

  • Technical Sales Specialist

    6 miesięcy temu

    Warsaw, Polska Microsoft Pełny etat

    Overview Microsoft’s mission is to empower every person and every organization on the planet to achieve more. As employees we come together with a growth mindset, innovate to empower others, and collaborate to realize our shared goals. Each day we build on our values of respect, integrity, and accountability to create a culture of inclusion where...

  • Cloud Infrastructure Specialist

    2 tygodni temu

    Warsaw, Polska Chabre IT Services Sp. z.o.o Pełny etat

    In the role of an Infrastructure Cloud Specialist, you can expect to work within the IT operations team, where you will support various initiatives and projects aimed at modernizing their IT environment. The team consists of an internal infrastructure support team and an external Managed Service Provider (MSP), handling recurring tasks and improvements...

  • Trainee Recruiting Specialist

    6 miesięcy temu

    Warsaw, Polska Andersen Pełny etat

    Summary Making it into IT is the dream of many people today, and if you are ready to learn new things and work hard, we will help you make this dream come true! Andersen is an international IT company uniting over 3,500 top-class professionals: developers, architects, testers, analysts, and other specialists. Operating in the market since 2007, we...

  • Tender Specialist

    7 miesięcy temu

    Warsaw, Polska Thermo Fisher Scientific Pełny etat

    When you are part of Thermo Fisher Scientific, you will do challenging work, and join a team that values performance, quality and innovation. As part of a successful, growing global organization you will be encouraged to perform at your best. With revenues of more than $40 billion and the largest investment in R&D in the industry, we give our people...

  • Lead Sourcing Specialist

    7 miesięcy temu

    Warsaw, Polska Baker Hughes Pełny etat

    Are you passionate about being part of a successful team? Do you like working in collaborative teams and solving critical issues? Join our Team! As a Lead Sourcing Specialist - Contract Management you will manage Indirect Sourcing contract details including but not limited to tracking of contractual obligations between Baker Hughes...

  • Sales Administration Specialist with French

    4 miesięcy temu

    Warsaw, Polska Mettler Toledo Pełny etat

    Our Opening and Your Responsibilities ...

  • Sales Administration Specialist with English

    3 miesięcy temu

    Warsaw, Polska Mettler Toledo Pełny etat

    Our Opening and Your Responsibilities ...

  • Merchant Onboarding Specialist with Czech

    4 miesięcy temu

    Warsaw, Polska Worldline Pełny etat

    The Opportunity As a Merchant Onboarding Specialist, you will be a part of the team who is supporting the markets of Eastern Europe and Benelux. You will have daily exposure to supporting our Merchants with data collection and documents verification in the system. If you enjoy working with documents and data, this role is for you! Day-to-Day...

  • Sales Administration Specialist with Italian

    4 miesięcy temu

    Warsaw, Polska Mettler Toledo Pełny etat

    Our Opening and Your Responsibilities ...

  • Payroll Specialist with Dutch language skills

    4 tygodni temu

    Warsaw, Polska GLOBRECS | Global Recruitment Solutions Pełny etat

    GLOBRECS | Global Recruitment Solutions specializes in fast and accurate recruitment services across Europe and the USA.Our client, a Fortune 500 company, is a renowned global distributor of electronic components. They collaborate closely with leading global manufacturers to offer a wide range of products.We are currently seeking a Payroll Specialist with...

  • Junior Order Processing Specialist with German

    4 miesięcy temu

    Warsaw, Polska Mettler Toledo Pełny etat

    Our Opening and Your Responsibilities ...

  • Merchant Onboarding Specialist

    2 miesięcy temu

    Warsaw, Polska Worldline Pełny etat

    The Opportunity As a Merchant Onboarding Specialist, you will be a part of the team who is supporting the markets of Eastern Europe and Benelux. You will have daily exposure to supporting our Merchants with data collection and documents verification in the system. If you enjoy working with documents and data, this role is for you! Day-to-Day...

  • Sales Administration Specialist with German

    3 miesięcy temu

    Warsaw, Polska Mettler Toledo Pełny etat

    Our Opening and Your Responsibilities ...