Position: Senior Oracle/PostgreSQL Database Administrator (Open for relocation)
Company: Luxoft
Experience required: 5y
Category: Other
English level: fluent
Published: 2022-11-01T00:00:00+02:00

We are looking for Senior Oracle/PostgreSQL Database Administrator in Wroclaw, Poland

Project Description:
We are looking for a hands-on DBA, technologist and architect who has experience in Oracle/PostgreSQL implementation to focus on building the PostgreSQL on Cloud platform and manage 14000+ Oracle Databases.

Responsibilities:
• Manage Oracle Databases in 11g and 12c/18c/19c, Real Application Clusters and Data Guard
• Support Recovery Manager and OEM (Oracle Enterprise Manager).
• Manage PostgreSQL Database environment including tuning, clustering, troubleshooting including versions 9,10,11,12.
• Architect the PostgreSQL environment to support application requirements including the use of read replicas, number of connections, managing concurrency etc.
• Lead efforts to develop and improve procedures for automated monitoring and proactive intervention, reducing any unplanned downtime.
• Knowledge of Performance tuning skill to identify Database operational issues and operating system level and able to provide the solution quickly to resolve production issues. Experience in analyzing the Database Health check reports like AWR, ADDM, OEM Diagnostics Packages.
• Help in developer SQL code review to ensure queries are optimized and tuned to perform efficiently prior to production release.
• Establish and implement processes/automation which ensures repetitive tasks are taken care by automation process using IPsoft, Ansible etc.
• Automate and perform regular database maintenance (e.g., Vacuum, Reindexing, Archiving, Connection pooling).
• Ensure compliance with operational / change management guidelines.
• Support for application and infrastructure BCM tests.

Mandatory Skills Description:
• 7+ years of experience in providing DBA support for medium/large number of databases in Oracle and/or experience in PostgreSQL Databases
• Oracle RDBMS 11g,12c ,18c,19c
• PostgreSQL 9.6,10,11,12
• Oracle Data Guard, RAC and RMAN
• Oracle Performance Tuning and Troubleshooting
• PostgreSQL Replication, Tuning, Troubleshooting
• Good working knowledge of Solaris and RedHat Linux
• Excellent verbal and written communication skills
• Good troubleshooting skills with an attention to detail and an ability to follow process
• Ability to work and remain calm in a high-pressure environment
• Good team working skills but equally must be capable of working alone
• Analytical and logical - a problem solver
• Good communicator and team player
• Customer and quality oriented, motivated, self-directed and driven
• Experience in big, international environment

Nice-to-Have Skills:
• Automation experience using Shell scripts, IPsoft, Python, etc.
• Knowledge on Automation tools and processes
• Knowledge of supporting databases on Cloud