PostgreSQL Database Administrator

Talent Search Technology; Bari; In loco; EUR 45.000 - 75.000; Tempo pieno

Descrizione del lavoro

Talent Search Technology in Bari, Italy, is looking for an experienced PostgreSQL Database Administrator to manage and optimize PostgreSQL, MySQL, and Oracle environments. The role emphasizes performance, reliability, and availability across on-premises and cloud platforms.

You will monitor health, tune queries, handle upgrades, and collaborate with developers and IT teams to ensure smooth operation. Experience with Azure Database Services and Windows Server is essential for this role in a

Competenze

• Strong hands-on experience in PostgreSQL Database Administration.
• ?
• Experience with Azure Database Services.

Mansioni

• 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.
• ?
• 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.
• ?
• 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.

Conoscenze

PostgreSQL DBA

Azure Database Services

Windows Server Administration

MySQL Administration

Oracle Administration

SQL Performance Tuning

Query Optimization

DB Monitoring

Capacity Planning

SQL Troubleshooting

SQL Diagnostics

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