Team Leader, Database Administrator (PostgreSQL)
Team Leader, Database Administrator (PostgreSQL)
egyptian banks companyEarly Applicant
- Posted 22 days ago
- Be among the first 10 applicants
Job 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
- 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
More Info
Key Skills
Database Performance Optimization
CitusData
Database clustering and replication technologies
About Company
Skills:
Databases, Uipath, Rpa, Automation Anywhere, Ansible, PowerShell, Blue Prism, Rest Apis, Python, Orchestration, application integrations, Production Support, infrastructure automation, Scheduling, unattended RPA architecture, Ansible Automation Platform
Skills:
architectural patterns , Microsoft .NET Framework, Tfs, VB.NET, CSS, Ms Sql Server, JQuery, HTML, Angular, Sdlc, Oop, Javascript, Xml, Oracle, Web Apis, Web Services, AI-assisted Development Tools, Agile Development Practices
Skills:
architectural patterns , Microsoft .NET Framework, C#, Tfs, VB.NET, CSS, Ms Sql Server, HTML, Angular, Sdlc, Oop, jQuery, Javascript, Er Diagrams, Xml, Oracle, Web Apis, Web Services, Stored procedures, Agile development practices, Performance optimization
Skills:
control testing , Oracle system
Skills:
mendix , Application Lifecycle Management, Appian, Apis, Power Platform, Javascript, outsystems, SQL databases, Low-code platforms, system integrations