Devexperts is hiring a
Middle Oracle & Postgres Database Administrator

Summary

The job is for a Database Administrator at Devexperts. The role involves managing Oracle and Postgres databases, resolving performance issues, creating backup strategies, maintaining security measures, providing technical support, and documenting database configurations. The required skills include 2 years of experience in a similar role, specific versions of Oracle Database and Postgres, high availability environments, disaster recovery environments, backup and restore using RMAN, hands-on experience with table spaces, indexes, partitions, and query performance tuning, creation, migration, maintenance and administration of Oracle and PostgreSQL databases in different environments, experience with Oracle Enterprise Manager, Docker Management, Liquidbase, and tasks automation.

Requirements

• At least 2 years of experience in a similar role
• Installation and administration of Oracle Database 19c and Postgres 13 and forward
• High availability environments (Failover or RAC)
• Disaster Recovery Environments (Data Guard)
• Backup and restore using RMAN
• Hands-on experience with table spaces, indexes, partitions, and query performance tuning
• Creation, migration, maintenance and administration of Oracle and PostgreSQL databases in different environments (Production, Pre-Production)
• Experience with Oracle Enterprise Manager
• Docker Management
• Experience with Liquidbase
• Experience in tasks automation
• Advanced knowledge of information technology necessary for performing work duties (including database skills at the administrator level, having domain of Unix and Windows environments at the user level, networking knowledge)

Responsibilities

• Manage, monitor, and optimise Oracle and Postgres database systems
• Design and implement Oracle and Postgres database structures based on business requirements
• Identify and resolve performance issues, optimise queries, and proactively monitor database performance
• Develop and implement backup and recovery strategies to ensure data protection and disaster recovery capabilities
• Implement and maintain database security measures to safeguard sensitive data
• Investigate and resolve database-related issues, provide technical support to users, and collaborate with developers and other IT staff
• Create and maintain comprehensive database documentation, including configurations, processes, and procedures
• Plan and execute database upgrades and apply patches to ensure the latest features, security enhancements, and bug fixes

Preferred Qualifications

• Experience with Foglight
• Experience with Ansible (AWX)
• Knowledge of Java programming language
• Experience with trading/exchange/risk management software usage
• Experience with Atlassian software (JIRA, Confluence, FishEye, etc.)

Benefits

• Flexible schedule
• Work from anywhere opportunity
• 30 working days of vacation in a year
• Additional accident insurance
• Modern, well-equipped office next to the English garden and with the panoramic views of the Alps
• Parking space in the office
• Reimbursement of lunch expenses
• Monthly vouchers
• Parents bonuses
• Corporate events
• Language courses