PostgreSQL Database Administrator

Talent Search Technology; Bari; In loco; EUR 55.000 - 90.000; Tempo pieno

Descrizione del lavoro

Talent Search Technology is seeking an experienced PostgreSQL Database Administrator to manage, maintain, and optimize PostgreSQL, MySQL, and Oracle databases. The role focuses on performance, reliability, monitoring, and continuous optimization across on-premises and Azure environments.

The candidate will work with Windows Server infrastructure and collaborate with application and dev teams to ensure high availability and fast, reliable data access.

Competenze

• Experience with PostgreSQL, Azure, Windows Server, MySQL and Oracle database administration.
• Strong understanding of database performance tuning and troubleshooting.
• Proficient in SQL query optimization, indexing, EXPLAIN plans, and database diagnostics.

Mansioni

• Manage PostgreSQL, MySQL, and Oracle databases to ensure high availability and optimal performance.
• Install, configure, patch, upgrade, and maintain database environments.
• Handle database objects such as tables, indexes, schemas, and tablespaces.

Conoscenze

PostgreSQL DB Admin

Azure Database Services

Windows Server

MySQL

Oracle

SQL performance tuning

SQL optimization

Monitoring

DB maintenance

Troubleshooting

Strumenti

AWR reports

EXPLAIN plans

Descrizione del lavoro

We are looking for an experienced PostgreSQL Database Administrator to manage, maintain, and optimize database environments across PostgreSQL, MySQL, and Oracle platforms. The role will focus on database performance, reliability, availability, monitoring, and continuous optimization.

Key Responsibilities

Database Administration

• Manage and maintain PostgreSQL, MySQL, and Oracle databases to ensure high availability, reliability, and optimal performance.
• Perform database installation, configuration, patching, upgrades, and maintenance activities.
• Manage database objects including tables, indexes, schemas, tablespaces, and related structures.
• Support database administration activities across Azure Database Services and on-premises environments.

Performance Monitoring & Optimization

• Monitor database health, capacity, utilization, and growth trends.
• Analyze and optimize SQL queries, indexes, and database structures.
• Identify and resolve performance bottlenecks, blocking issues, and slow-running queries.
• Perform database performance tuning using appropriate diagnostic and monitoring tools.
• Use tools and techniques such as AWR reports and EXPLAIN plans to identify performance issues and recommend improvements.
• Continuously tune and refine database configurations and structures to improve efficiency and performance.

Infrastructure & Support

• Work with Windows Server environments supporting database platforms.
• Troubleshoot database-related incidents and provide timely resolution.
• Collaborate with application, infrastructure, and development teams to resolve database performance and availability issues.
• Follow database administration best practices, operational procedures, and security standards.

Required Technical Skills

• Strong hands-on experience in PostgreSQL Database Administration.
• Experience with Azure Database Services.
• Good knowledge of Windows Server administration.
• Experience with MySQL and Oracle database administration.
• Strong understanding of database performance tuning and troubleshooting.
• Hands-on experience with SQL query optimization, indexing, EXPLAIN plans, and database diagnostics.
• Knowledge of database monitoring, capacity planning, and performance management.
• Database performance tuning and optimization
• Database installation, configuration, and upgrades
• SQL troubleshooting and query optimization
• Database monitoring and capacity management