Job Search

1653Open Positions

1653Open Positions

share

Senior PostgreSQL DBA IRC123735

Job IRC123735
Location Ukraine - Kyiv
Designation Senior Software Engineer
Experience 3-5 years
Function Engineering
Skills PostgreSQL

Description

Project Software helps leading companies around the world put technology at the forefront of business
transformation, improving the delivery and consumption of digital services. From mainframe to
cloud to mobile, Project delivers innovative IT management solutions that have enabled more than
15,000 customers to leverage complex technology into extraordinary business performance –
increasing their agility and exceeding anything they previously thought possible.  
Thanks to our ongoing expansion we have the opportunity to grow our Site Reliability Engineering team. We’re looking for people who are just as passionate about solving issues with distributed systems as they are to automate, code and collaborate to tackle problems.

Requirements

    We are looking for a passionate and highly experienced PostgreSQL DBA to help build the next-gen data migration and Automation platform on the cloud and assist on-Prem to AWS migrations from SQL Server and Oracle DB to PostgreSQL.

    • You have strong experience with PostgreSQL and it has been your primary database for a minimum of 3-5 years
    • Deep understanding of systems performance of PostgreSQL, and advanced knowledge of Postgres internals 
    • Understand automation concepts to speed up the work Using Ansible 
    • Experience implementing high availability by setting up either streaming replication or logical replication and decoding 
    • Expertise implementing Foreign Data Wrappers to sync data across multiple PostgreSQL servers and Advanced query tuning for large data sets
    • Knows how to optimize queries/schemas 
    • Knows backup solutions and strategies 
    • Knows HA solutions and strategies 
    • Knows proxy usage as it relates to Postgres 
    • Ability to troubleshoot methodically, identifying and applying fixes for known errors, and when necessary, capacity to think outside of the box to resolve complex issues 
    • Experience with system performance counters and metrics relevant to the operation of high-concurrency PostgreSQL implementations, and resolve database performance and scalability issues.

Job Responsibilities

    • You will be responsible for implementation, configuration, maintenance, and performance of system health for high-concurrency PostgreSQL database systems ensuring availability and consistent performance, supporting product development teams.
    • Build high-scale data pipelines and data infrastructure for migrating SQLServer and Oracle DB to PostgreSQL on AWS RDB.
    • Specific experience in complex large data architectures using AWS Aurora PostgreSQL and AWS data lake (S3 and Glue) with IAM roles and KMS key encryption. 
    • Resolve database performance and scalability issues and implement Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools. 
    • Design and implement scalable database schemas and configurations, File system layout, Physical partitioning, Sharding and Replication, incremental backups, Restores, and recovery models. 
    • Implement High Availability (HA) and Disaster Recovery (DR) options for PostgreSQL 
    • Develop DevOps policies and procedures as it relates to PostgreSQL 
    • Manage PostgreSQL databases through multiple product lifecycle environments, from development to mission-critical production systems dealing with upgrades. 
    • Independently analyzes, solves, and corrects issues in real-time, providing problem resolution end-to-end. 
    • Refines and automates regular processes, tracks issues, and documents changes. 
    • Assists developers with complex query tuning and schema refinement. 
    • Provides on-call support, as part of team rotation, for critical production systems. 
    • Performs pre-scheduled maintenance and support release deployment activities after hours. 
    • Shares domain and technical expertise, providing technical mentorship and cross-training to other peers and team members. 
    • Design and implement a complex system to combine and merge data from multiple database servers into a target database. 
    • Create complex queries to produce materialized views collating data from multiple servers based on which server is deemed authoritative for each record. 
    • Tune performance of source and target servers to ensure performance is maintained even after replication/merge engine is added.

We Offer

Exciting Projects: Come take your place at the forefront of digital transformation! With clients across all industries and sectors, we offer an opportunity to participate in creating market-defining products using the latest technologies.

Collaborative Environment: Expand your skills by collaborating with a diverse team of highly talented people in an open, laidback environment — or even abroad in one of our global centers or client facilities!

Work-Life Balance: GlobalLogic prioritizes work-life balance, which is why we offer flexible opportunities and options.

Professional Development: Our dedicated Learning & Development team regularly organizes certification and technical / soft skill training to help you realize your professional goals.

Excellent Benefits: We provide our consultants with competitive compensation and benefits

Fun Perks: We want you to love where you work, which is why we host sports classes, cultural, social and team building activities such as sports competitions and end-of-year corporate parties. Our vibrant offices also include dedicated GL Zones and rooftop decks where you can drink coffee or tea with your colleagues over a game of table football or darts!

About GlobalLogic

GlobalLogic is a full-lifecycle product development services leader that combines chip-to-cloud software engineering expertise and vertical industry experience to help our customers design, build, and deliver their next-generation products and digital experiences. We expertly integrate design, complex engineering, and agile delivery capabilities to deliver superior business outcomes for global brands in telecom, automotive, healthcare, technology, media and entertainment, manufacturing, and semiconductor industries.

Headquartered in Silicon Valley, GlobalLogic unites over 18,000 designers and engineers across the globe. Analysts like NASSCOM and Zinnov have recognized us for being a top company in our field, and we are consistently nominated as a preferred company by both global HR consulting firms and local boards. By creating an environment that is exciting and flexible, and by fostering growth through ongoing learning and development programs, we empower our consultants to achieve both their professional and personal goals.

At GlobalLogic, we make amazing products — and careers.

Apply Now

    Attach your file here or browse

    Only .docx, .rtf, .pdf formats allowed to a max size of 5 MB
    Test
    Recruitment for this and similar positions in GlobalLogic is constantly open. In order to apply and give GlobalLogic your consent to process your personal data for the purpose of such recruitments press the “Submit” button below. More details on how we process your personal data and what are your rights can be found in EU Recruitment Policy. Remember that you can withdraw your consent anytime, for example by sending an e-mail at privacy@globallogic.com/se/
    In order to apply and give GlobalLogic your consent to process your personal data for the purpose of this recruitment process, press the “Submit” button below.
    Check this box if you want us to process your personal data also for future recruitment processes for other positions. More details on how we process your personal data and what are your rights can be found EU Recruitment Policy. Remember that you can withdraw any consent anytime, for example by sending an e-mail at privacy@globallogic.com/se/
    Recruitment for this and similar positions in GlobalLogic is constantly open. In order to apply and give GlobalLogic your consent to process your personal data for the purpose of such recruitments press the “Submit” button below. More details on how we process your personal data and what are your rights can be found in EU Recruitment Policy. Remember that you can withdraw your consent anytime, for example by sending an e-mail at privacy@globallogic.com/se/
    In order to apply and give GlobalLogic your consent to process your personal data for the purpose of this recruitment process, press the “Submit” button below.
    Check this box if you want us to process your personal data also for future recruitment processes for other positions. More details on how we process your personal data and what are your rights can be found EU Recruitment Policy. Remember that you can withdraw any consent anytime, for example by sending an e-mail at privacy@globallogic.com/se/
    Recruitment for this and similar positions in GlobalLogic is constantly open. In order to apply and give GlobalLogic your consent to process your personal data for the purpose of such recruitments press the “Submit” button below. More details on how we process your personal data and what are your rights can be found in EU Recruitment Policy. Remember that you can withdraw your consent anytime, for example by sending an e-mail at privacy@globallogic.com/se/
    In order to apply and give GlobalLogic your consent to process your personal data for the purpose of this recruitment process, press the “Submit” button below.
    Check this box if you want us to process your personal data also for future recruitment processes for other positions. More details on how we process your personal data and what are your rights can be found EU Recruitment Policy. Remember that you can withdraw any consent anytime, for example by sending an e-mail at privacy@globallogic.com/se/
    Recruitment for this and similar positions in GlobalLogic is constantly open. In order to apply and give GlobalLogic your consent to process your personal data for the purpose of such recruitments press the “Submit” button below. More details on how we process your personal data and what are your rights can be found in EU Recruitment Policy. Remember that you can withdraw your consent anytime, for example by sending an e-mail at privacy@globallogic.com/se/
    In order to apply and give GlobalLogic your consent to process your personal data for the purpose of this recruitment process, press the “Submit” button below.
    Check this box if you want us to process your personal data also for future recruitment processes for other positions. More details on how we process your personal data and what are your rights can be found EU Recruitment Policy. Remember that you can withdraw any consent anytime, for example by sending an e-mail at privacy@globallogic.com/se/