PostgreSQL Database Administrator (DBA)

Reverside is an established it
services provider focusing on delivering high-quality software development, it
resourcing, digital transformation, and systems support solutions. We are
always looking for skilled professionals to join our growing team and contribute
to innovative technology projects across various industries.

The successful resource will be
expected to Maintain database availability and stability, Ensure successful
execution of backup and recovery processes, Optimize database performance and
capacity, Support application and infrastructure projects, Implement and
maintain high-availability solutions and Ensure compliance with security and
governance requirements. 

Key
Responsibilities: 

Database
Administration 

• Install, configure, and maintain
  PostgreSQL database environments. 
  
• Manage database upgrades,
  patching, and migrations. 
  
• Monitor database performance and
  proactively identify issues. 
  
• Configure and maintain
  high-availability and disaster recovery solutions. 
  
• Perform database capacity
  planning and performance tuning. 
  

Database
Operations 

• Manage backup and recovery
  processes. 
  
• Ensure database security, access
  controls, and compliance requirements are implemented. 
  
• Monitor database health,
  availability, and resource utilization. 
  
• Troubleshoot and resolve database
  incidents and performance bottlenecks. 
  
• Support application deployments
  and database releases. 
  

Performance &
Optimization 

• Analyze and optimize SQL queries
  and database workloads. 
  
• Implement indexing, partitioning,
  and database optimization strategies. 
  
• Conduct root cause analysis for
  database-related issues. 
  
• Drive continuous improvement
  initiatives to enhance database efficiency and reliability. 
  

Governance &
Compliance 

• Enforce database standards,
  policies, and best practices. 
  
• Maintain documentation for
  database architecture, configurations, and operational procedures. 
  
• Ensure compliance with
  organizational security and data management standards. 
  

Collaboration 

• Work closely with Infrastructure,
  Application Development, DevOps, and Cloud teams. 
  
• Provide technical guidance and
  mentoring to junior team members. 
  
• Support project delivery
  activities and database design reviews. 
  

Minimum
Requirements: 

• Bachelor's Degree, National
  Diploma, or equivalent qualification in Computer Science, Information
  Technology, or related field. 
  
• Relevant PostgreSQL
  certifications advantageous. 
  
• Minimum 5 years' experience as a
  Database Administrator. 
  
• Minimum 3 years' hands-on
  PostgreSQL administration experience in enterprise environments. 
  
• Experience supporting
  mission-critical production databases. 
  
• Experience with database
  migration and upgrade projects. 
  
• Experience working within
  ITIL-based support environments. 
  

Technical
Skills: 

Essential 

• Strong PostgreSQL administration
  experience. 
  
• PostgreSQL backup and recovery
  methodologies. 
  
• Performance monitoring and
  tuning. 
  
• Replication technologies
  (Streaming Replication, Logical Replication). 
  
• High Availability and Disaster
  Recovery solutions. 
  
• Linux administration
  skills. 
  
• SQL scripting and query
  optimization. 
  
• Database security and user access
  management. 
  
• Monitoring tools and database
  health checks. 
  

Desirable:

• PostgreSQL clustering solutions
  (Patroni, Pgpool-II, Repmgr, etc.). 
  
• Cloud database platforms (AWS RDS
  PostgreSQL, Azure Database for PostgreSQL, Google Cloud SQL). 
  
• Experience with Kubernetes and
  containerized database deployments. 
  
• DevOps tools and CI/CD
  pipelines. 
  
• Automation using Shell, Python,
  or Ansible. 
  
• Experience with monitoring tools
  such as Prometheus, Grafana, Zabbix, Datadog, or SolarWinds.