📍 Job Overview

Job Title: Database Architect – DB2 & PostgreSQL
Company: VAM Systems
Location: Manama, Al ‘Āşimah, Bahrain
Job Type: Full-time
Category: Database Administration
Date Posted: 2025-06-18
Experience Level: 10+ years
Remote Status: On-site

🚀 Role Summary

Key Responsibilities: Administer and support IBM DB2 environments, manage AWS-hosted PostgreSQL environments, perform database performance analysis, and support ongoing database operations.
Key Skills: Database Administration, IBM DB2, PostgreSQL, Performance Tuning, High Availability, Disaster Recovery, Database Security, Backup Strategies, AWS, SQL Query Optimization, Monitoring, Collaboration, Configuration, Installation, Health Monitoring, Documentation.

💻 Primary Responsibilities

Database Administration:
- Administer and support IBM DB2 environments, including installation, configuration, HADR, TSA, Pacemaker, and DB2MON for performance and health monitoring.
- Manage AWS-hosted PostgreSQL environments, including configuration, administration, and performance tuning, with a focus on stability and cloud best practices.
Database Performance Analysis:
- Perform database performance analysis, query tuning, and proactive monitoring to ensure optimal system performance and availability.
- Validate and document current DB configurations, stored procedures, replication models, and performance settings.
Database Operations Support:
- Support ongoing database operations, including backup and recovery procedures, SQL query optimization, patching, and upgrades across environments.
- Design and implement best practices for BAU operations, monitoring, and failover handling.
Collaboration and Compliance:
- Collaborate with development and infrastructure teams to ensure database solutions meet performance, scalability, and compliance requirements.

🎓 Skills & Qualifications

Education: Bachelor's degree in Computer Science, Information Technology, or a related field.

Experience: Minimum of 7-10 years in database administration, with strong expertise in IBM DB2 and 2+ years of exposure to PostgreSQL.

Required Skills:

Proven experience in production-grade database transitions and support.
Strong understanding of database security, HA/DR, and backup strategies.
Ability to coordinate with application, infrastructure, and vendor teams.

Preferred Skills:

Experience with AWS services and cloud best practices.
Familiarity with banking industry standards and regulations.

📊 Web Portfolio & Project Requirements

Portfolio Essentials:
- Demonstrate strong expertise in IBM DB2 and PostgreSQL with relevant case studies and success stories.
- Showcase experience in high-availability, mission-critical environments with a focus on performance tuning and optimization.
- Highlight skills in database security, HA/DR, and backup strategies with practical examples.
Technical Documentation:
- Provide well-documented database configurations, stored procedures, replication models, and performance settings.
- Include SQL query optimization examples and performance metrics to showcase technical proficiency.

💵 Compensation & Benefits

Salary Range: The salary range for this role is not specified in the job listing. However, based on regional market standards and the required experience level, a competitive salary range would be around BHD 3,500 - 5,000 per month (USD 9,280 - 13,220 per year).

Benefits:

Joining time frame: maximum 4 weeks
Additional benefits may include health insurance, retirement plans, and other perks, as per the company's standard benefits package for full-time employees.

Working Hours: The standard working hours for this role are 40 hours per week, with flexibility for maintenance windows and project deadlines as needed.

🎯 Team & Company Context

🏢 Company Culture

Industry: Banking

Company Size: Medium-sized organization with a focus on database management and support for mission-critical environments.

Founded: Not specified in the job listing.

Team Structure:

The database administration team consists of experienced professionals responsible for managing and supporting IBM DB2 and PostgreSQL environments.
The team works closely with development, infrastructure, and vendor teams to ensure database solutions meet performance, scalability, and compliance requirements.

Development Methodology:

The company follows best practices for database administration, including proactive monitoring, performance tuning, and regular maintenance.
The team uses AWS services and cloud best practices to manage and optimize database environments.

Company Website: VAM Systems

📈 Career & Growth Analysis

Web Technology Career Level: Senior Database Administrator/Architect

Reporting Structure: This role reports directly to the Database Administration Manager or a similar senior-level position within the organization.

Technical Impact: The Database Architect plays a crucial role in ensuring optimal system performance, high availability, and data integrity for the company's mission-critical applications.

Growth Opportunities:

Opportunities for professional development and skill enhancement in emerging database technologies and cloud services.
Potential career progression into senior management or technical leadership roles within the database administration team.

🌐 Work Environment

Office Type: Modern, on-site office environment with a focus on collaboration and teamwork.

Office Location(s): Manama, Al ‘Āşimah, Bahrain

Workspace Context:

The workspace is designed to facilitate collaboration and communication among team members, fostering a productive and innovative environment.
The office is equipped with state-of-the-art technology and tools to support the team's work in managing and optimizing database environments.

Work Schedule: The standard work schedule is 40 hours per week, with flexibility for maintenance windows, project deadlines, and on-call rotations as needed.

📄 Application & Technical Interview Process

Interview Process:

Technical Assessment: A hands-on assessment or coding challenge focused on IBM DB2 and PostgreSQL administration, performance tuning, and query optimization.
Technical Deep Dive: A detailed discussion of the candidate's experience and expertise in database administration, high availability, disaster recovery, and backup strategies.
Behavioral and Cultural Fit Assessment: An evaluation of the candidate's communication skills, problem-solving abilities, and cultural fit within the organization.

Portfolio Review Tips:

Highlight relevant case studies and success stories demonstrating expertise in IBM DB2 and PostgreSQL administration.
Include examples of SQL query optimization, performance tuning, and database security best practices.

Technical Challenge Preparation:

Brush up on IBM DB2 and PostgreSQL administration skills, focusing on performance tuning, query optimization, and high availability.
Familiarize yourself with AWS services and cloud best practices for database management.

ATS Keywords: Database Administration, IBM DB2, PostgreSQL, Performance Tuning, High Availability, Disaster Recovery, Database Security, Backup Strategies, AWS, SQL Query Optimization, Monitoring, Collaboration, Configuration, Installation, Health Monitoring, Documentation.

🛠 Technology Stack & Web Infrastructure

Database Technologies:

IBM DB2 (including HADR, TSA, and performance tuning)
PostgreSQL (including query performance and tuning)

Cloud Platform:

AWS (Amazon Web Services)

Monitoring and Health Check Tools:

DB2MON (IBM DB2 health monitoring tool)
AWS CloudWatch (cloud-based monitoring and observability service)

Collaboration and Communication Tools:

Not specified in the job listing, but common tools include Slack, Microsoft Teams, or similar platforms for team communication and collaboration.

👥 Team Culture & Values

Database Administration Values:

Strong focus on performance, availability, and data integrity.
Commitment to best practices in database administration, including proactive monitoring, regular maintenance, and continuous improvement.
Collaboration and communication with development, infrastructure, and vendor teams to ensure database solutions meet performance, scalability, and compliance requirements.

Collaboration Style:

The database administration team works closely with other teams within the organization to ensure optimal system performance and data integrity.
The team fosters a collaborative environment, encouraging knowledge sharing, technical mentoring, and continuous learning.

⚡ Challenges & Growth Opportunities

Technical Challenges:

Managing high-availability, mission-critical database environments with minimal downtime and optimal performance.
Transitioning production-grade databases and supporting ongoing operations in a dynamic and evolving environment.
Staying up-to-date with emerging database technologies and cloud services to ensure the organization remains competitive and innovative.

Learning & Development Opportunities:

Professional development and skill enhancement in emerging database technologies and cloud services.
Technical mentorship and leadership opportunities within the database administration team.
Opportunities to collaborate with development and infrastructure teams to expand knowledge and skills in related areas.

💡 Interview Preparation

Technical Questions:

DB2 Administration: Describe your experience with IBM DB2 administration, including installation, configuration, HADR, TSA, Pacemaker, and DB2MON for performance and health monitoring.
PostgreSQL Administration: Discuss your experience with PostgreSQL administration, focusing on query performance, tuning, and cloud best practices.
Database Performance Analysis: Explain your approach to database performance analysis, query tuning, and proactive monitoring to ensure optimal system performance and availability.
Database Security and Backup Strategies: Describe your understanding of database security, HA/DR, and backup strategies, and provide examples of implementation in previous roles.

Company & Culture Questions:

Company Culture: Research the company's values, mission, and culture to demonstrate a strong fit and understanding of the organization.
Team Dynamics: Ask questions about the database administration team's structure, collaboration, and communication to showcase your interest in the role and the company.

Portfolio Presentation Strategy:

Case Studies: Prepare detailed case studies demonstrating your expertise in IBM DB2 and PostgreSQL administration, performance tuning, and query optimization.
SQL Query Optimization: Include examples of SQL query optimization and performance metrics to showcase your technical proficiency.
Presentation Style: Tailor your presentation style to the company's culture and values, emphasizing your ability to work collaboratively and effectively within the team.

📌 Application Steps

To apply for this Database Architect – DB2 & PostgreSQL position:

Submit your application through the VAM Systems job portal.
Customize your resume and portfolio to highlight your relevant experience and skills in IBM DB2 and PostgreSQL administration, performance tuning, and query optimization.
Prepare for the technical assessment and interview by brushing up on your database administration skills and familiarizing yourself with AWS services and cloud best practices.
Research the company's values, mission, and culture to demonstrate a strong fit and understanding of the organization during the behavioral and cultural fit assessment.

⚠️ Important Notice: This enhanced job description includes AI-generated insights and database administration industry-standard assumptions. All details should be verified directly with the hiring organization before making application decisions.

Database Architect – DB2 & PostgreSQL