Back to search
Egyptian Banks Company Linkedin · Posted 27d ago

Junior / Senior Database Administrator (PostgreSQL & Cassandra)

Cairo

Linkedin
Continue to application Add your email once, then Caio opens the original posting.

Indexed description

  • Must Have hand on experience in Database clustering and replication technologies including EDB Enterprise Failover Manager (EFM) & PGD and CitusData
  • PostgreSQL & Cassandra DB Administration: Expert in installing, configuring, and maintaining PostgreSQL & Cassandra instances in production, staging, and development environments
  • Database Performance Optimization: Advanced skills in query optimization, indexing, partitioning, and caching strategies to boost database performance & Optimize database stability and performance throughout the migration lifecycle
  • High Availability & Disaster Recovery: Skilled in setting up replication (synchronous & asynchronous), failover mechanisms, and backup strategies to ensure maximum uptime and data protection
  • Scalability & Load Balancing: Experience in implementing horizontal and vertical scaling techniques, managing large datasets, and balancing loads to improve performance
  • Database Security: Ensuring database security through access control, encryption, and regular audits to protect sensitive data and comply with industry standards
  • SQL & PL/pgSQL Development: In-depth knowledge of writing complex SQL queries, stored procedures, functions, and triggers for both transactional and analytical applications
  • Data Migration & ETL: Expertise in migrating large volumes of data across different PostgreSQL instances and performing ETL operations
  • Infrastructure: Experience in deploying and managing PostgreSQL databases on different platforms
  • DevOps & Automation: Familiarity with infrastructure as code (IaC), CI/CD pipelines, and automation tools like Ansible, Docker, and Kubernetes for seamless PostgreSQL deployment and management
  • Execute migration of Oracle and SQL Server databases to PostgreSQL environments
  • Ensure all migration activities comply with the Change Advisory Board (CAB) process, coordinating pre-production and production releases
  • Implement and enforce the principle of least privilege across all database users and roles
  • Configure and enable Transparent Data Encryption (TDE) with minimal impact on production environments
  • Conduct daily operational health checks to ensure optimal database performance
  • Provide timely business and application support to resolve database-related issues.\
  • Perform patching and minor version upgrades while minimizing system downtime
  • Document all database activities, procedures, and incidents comprehensively
  • Redis database experience
  • hands on experience in Database clustering and replication technologies including EDB Enterprise Failover Manager (EFM) & PGD and CitusData

Requirements

  • +3 Years in similar role, experienced in managing and supporting PostgreSQL (version 14 and above) on both Linux and Windows platform
  • Hands on experience in Database clustering and replication technologies including EDB Enterprise Failover Manager (EFM) & PGD and CitusData
  • Database administration certifications
  • Experience with MS SQL Server, and Cassandra DB
  • Proven experience as a Database Administrator with strong knowledge of database management systems (e.g., Oracle, MySQL, SQL Server)
  • Experience in database security and data protection measures
  • Familiarity with backup and recovery processes
Free. 20 seconds. No password. See every match in this search.

Create a free Caio profile to unlock more results and save your role and location preferences.

Unlock free search
Want help applying to roles like this? Search Caio for free. If repetitive applications get heavy, Managed Job Search adds supervised execution for $99/month.
View Managed Job Search