Database Developer Postgresql
Bridge Axis, Pakistan

You will be tasked with the development, installation, configuration, upgrading, administration, monitoring and support of our database environment.

You will need to have at least 4 years’ experience in a DBA or Database Developer and administration role, and have a strong working knowledge of PostgreSQL.

• Create the database/tablespaces and scheduling the maintenance jobs
• Knowledge of message queuing, indexing, and high-performance data concepts
• Familiarity with data structure and algorithms
• Ability to profile databases
• Ability to write database queries and code while maintaining data quality, privacy, and security
• Managing database security/integrity and backup procedures
• Understand the complexities of advanced techniques – e.g. table partitioning
• Experience in Postgres EFM and patroni configuration across multiple servers
• Backup and restore the database and clusters
• Experience on pgdump and analyze and reindexes
• Experience on Failover and switchover the servers and fix
• Creation of PostgreSQL data models
• Review of existing models
• Optimizations of data models
• Porting models from Oracle, MS SQL, etc. to PostgreSQL
• Familiarity with PostgreSQL support for JSON
• Fixing and optimizing data types
• Expertise in time-series databases

Job Rewards and Benefits