Location: Qatar
Duration: 18 Months
Job Purpose:
To design, develop, optimize, and maintain reliable database solutions using PostgreSQL and Metabase, ensuring data availability, performance, integrity, security, and effective business reporting.
Database Development & Management
- Design, develop, and maintain PostgreSQL databases, schemas, tables, views, and stored procedures.
- Develop efficient SQL queries for data extraction, transformation, and reporting.
- Ensure database integrity, availability, and reliability.
- Manage database changes and support data migration activities.
Database Performance & Optimization
- Monitor and optimize database performance, queries, indexes, and execution plans.
- Identify and resolve database performance bottlenecks.
- Implement appropriate indexing, partitioning, and optimization techniques.
- Support capacity planning and database scalability.
- Develop and maintain Metabase dashboards, reports, and data visualizations.
- Create reusable questions, models, and datasets for business users.
- Translate business requirements into meaningful reports and dashboards.
- Ensure accuracy and consistency of reported data.
Data Integration & Management
- Support integration of PostgreSQL with applications, APIs, and external data sources.
- Develop data transformation and extraction processes.
- Validate data quality and resolve data inconsistencies.
- Support ETL/ELT processes and data pipelines where required.
Security, Backup & Production Support
- Implement database access controls, roles, permissions, and security standards.
- Support database backup, recovery, and disaster recovery activities.
- Troubleshoot and resolve production database issues.
- Conduct root cause analysis and implement corrective actions.
- Maintain database architecture, data models, technical documentation, and procedures.
- Collaborate with developers, BI teams, QA, DevOps, and business stakeholders.
- Participate in database design, code reviews, testing, and deployments.
- 4–6 years of relevant experience in Application Security, Cybersecurity, or Information Security.
- Strong experience in application security testing and vulnerability assessment.
- Hands‑on experience with web applications, mobile applications, APIs, and cloud environments.
- Strong understanding of OWASP Top 10 and secure coding practices.
- Experience with SAST, DAST, SCA, penetration testing, and vulnerability management.
- Experience integrating security into SDLC and CI/CD environments.
- Strong knowledge of application security threats, vulnerabilities, and remediation techniques.
Education and Certification Requirements
- Bachelor’s degree in Computer Science, Cybersecurity, Information Security, or a related field.
- Relevant certifications such as OSCP, CEH, GWAPT, CSSLP, or Security+ are an advantage.
Job Specific Technical Skills
- Application Security
- OWASP Top 10
- API Security
- SAST / DAST / SCA
- Vulnerability Assessment & Penetration Testing
- Secure SDLC / DevSecOps
- Secure Coding Practices
- CI/CD Security Integration
- Source Code & Security Review
- Security Testing Tools