Position: Senior Database Engineer (PostgreSQL)
Company: Ciklum
Category: SQL
Experience required: 3y
English level: intermediate
Published: 2020-09-01T00:00:00+03:00

Responsibilities

Manage database security and monitoring
Take care of Database backups and disaster recovery setup
Be a master of query optimisation and query planning
Build close relationships with platform engineers to identify bottlenecks before they get to production
Maintain and develop a custom Postgres setup on GCP hosted in Europe (which is 2TB+)
Ensure data confidentiality, integrity, and availability
Govern the compliance of data protection regulations
Be a mentor on database related topics for the System Engineering and Tech team as a whole
Contribute to Center of Excellence (CoE) activities and community building, participate in conferences, provide excellence in exercise and best practices.

Requirements

6+ years of experience in a DBA / software engineer specialised in DBs
Solid experience at managing huge PostgreSQL databases
An “automation-first” mindset and knowledge of scripting
Experience with any programming language will be a plus (Golang, RoR, Java, etc…)
Our stack is based on Kubernetes and GCP, any experience with those platforms will be a plus
Exposure to high availability and disaster recovery strategies is a plus
Knowledge of SQL and MPP databases (e.g. Vertica, Netezza, Greenplum, Aster Data)
Knowledge of professional software engineering best practices for the full software
Knowledge of Data Warehousing, design, implementation and optimization
Knowledge of Data Quality testing, automation and results visualization
Knowledge of development life cycle, including coding standards, code reviews, source control management, build processes, testing, and operations.
Experience participating in an Agile software development team, e.g. SCRUM
Experience designing, documenting, and defending designs for key components in large distributed computing systems
A consistent track record of delivering exceptionally high quality software on large, complex, cross-functional projects
Demonstrated ability to learn new technologies quickly and independently
Ability to handle multiple competing priorities in a fast-paced environment
Undergraduate degree in Computer Science or Engineering from a top CS program required. Masters preferred
Desirable
Understanding of cloud infrastructure design and implementation
Experience in backend development and deployment
Experience in CI/CD configuration
Good knowledge of data analysis in enterprises

Personal skills

A curious mind and willingness to work with the client in a consultative manner to find areas to improve;
Upper-Intermediate or Advanced English;
Good analytical skills;
Good team player motivated to develop and solve complex tasks;
Self-motivated, self-disciplined and result-oriented;
Strong attention to details and accuracy.

What's in it for you

A Centre of Excellence is ultimately a community that allows you to improve yourself and have fun. Our centres of excellence (CoE) bring together all Ciklumers from across the organisation to share best practices, support, advice, industry knowledge and to create a strong community.
Close cooperation with the client;
A constant flow of new projects;
Dynamic and challenging tasks;
Ability to influence project technologies;
Projects from scratch;
Team of professionals: learn from colleagues and gain recognition of your skills;
European management style;
Continuous self-improvement.