PostgreSQL Database Administrator (Consultant)

10785315

Location

Amsterdam, Netherlands

Contract Duration

6 Months

Start Date

June 2026

Experience Required

4–6 Years

Role Overview

We are seeking an experienced PostgreSQL Database Administrator to join our team and support the administration, maintenance, optimization, and security of enterprise PostgreSQL database environments.

The ideal candidate will have strong hands-on experience managing PostgreSQL databases in production environments, ensuring high availability, performance, security, and reliability. You will work closely with development, infrastructure, and application teams to design, implement, and maintain robust database solutions that support critical business applications.

Key Responsibilities

PostgreSQL Database Administration

• Install, configure, upgrade, and maintain PostgreSQL database environments.
• Manage database instances across development, testing, and production environments.
• Perform database patching, version upgrades, and maintenance activities.
• Ensure databases operate efficiently and reliably with minimal downtime.
• Monitor database health and proactively address issues before they impact operations.

Performance Monitoring & Optimization

• Monitor database performance and resource utilization.
• Analyze database workloads and identify performance bottlenecks.
• Optimize SQL queries, indexes, and database configurations.
• Perform database tuning to improve performance and scalability.
• Implement performance monitoring solutions and reporting mechanisms.

Backup, Recovery & High Availability

• Design, implement, and maintain backup and recovery strategies.
• Perform regular backup validation and recovery testing.
• Ensure disaster recovery procedures are documented and tested.
• Support high availability and failover configurations.
• Develop and maintain business continuity plans for database services.

Security & Compliance

• Implement database security best practices.
• Manage user accounts, roles, and access permissions.
• Ensure data integrity, confidentiality, and compliance with organizational standards.
• Monitor database access and security events.
• Support audit and compliance requirements.

Automation & Scripting

• Develop and maintain scripts for:
  • Database monitoring
  • Backup automation
  • Health checks
  • Maintenance tasks
  • Performance reporting
• Automate repetitive administrative activities to improve efficiency.
• Support infrastructure and database automation initiatives.

Database Design & Development Support

• Collaborate with application developers and solution architects on database design.
• Review database schemas and data models.
• Provide recommendations for database architecture and best practices.
• Support application deployments and database releases.
• Assist development teams with database-related troubleshooting and optimization.

Incident & Problem Management

• Investigate and resolve database incidents and performance issues.
• Participate in root cause analysis and problem management activities.
• Ensure timely resolution of production issues.
• Maintain operational documentation and support procedures.

Required Skills & Experience

Mandatory Technical Skills

PostgreSQL Administration

• 4–6 years of hands-on experience administering PostgreSQL databases.
• Strong experience with:
  • Installation and configuration
  • Database upgrades and migrations
  • Backup and recovery
  • Performance tuning
  • Security management
  • Troubleshooting and support

Database Performance & Optimization

• Experience optimizing PostgreSQL databases for performance and scalability.
• Strong understanding of:
  • Query optimization
  • Indexing strategies
  • Execution plans
  • Database statistics
  • Resource management

Backup & Recovery

• Experience implementing and managing backup and disaster recovery solutions.
• Knowledge of PostgreSQL replication and high-availability configurations.

Database Security

• Experience managing database roles, permissions, and access controls.
• Knowledge of database security best practices and compliance requirements.

Scripting & Automation

• Experience creating automation scripts for database administration and monitoring.
• Familiarity with Linux/Unix shell scripting and database automation tools.

Preferred Skills

• Experience working in enterprise-scale database environments.
• Knowledge of cloud-based PostgreSQL deployments.
• Experience with monitoring and observability tools.
• Familiarity with DevOps and Infrastructure-as-Code practices.
• Experience supporting high-availability and mission-critical systems.

Personal Competencies

• Strong analytical and problem-solving skills.
• Attention to detail and commitment to data integrity.
• Ability to work independently and manage priorities effectively.
• Strong communication and collaboration skills.
• Proactive and solution-oriented mindset.
• Ability to perform effectively in fast-paced production environments.

Key Technologies

• PostgreSQL
• Linux/Unix
• SQL
• Database Monitoring Tools
• Backup & Recovery Solutions
• High Availability & Replication Technologies
• Shell Scripting