DBA

Role Overview: As a Database Developer, you will be responsible for developing simple and complex stored procedures, functions, and views to meet enhancement requirements. You will provide best practice guidance to the development team regarding database design and usage. Your role will also involve developing automation technologies to expedite the process of loading data into the end target, designing and developing relational databases, and optimizing database performance. Additionally, you will be required to develop ETL strategies for integrating data from multiple sources in data warehouses and design database schema to meet new enhancement requirements. Key Responsibilities: - Develop simple and complex stored procedures, functions, and views - Provide best practice guidance on database design and usage - Develop automation technologies for data loading processes - Design and develop relational databases - Optimize database performance - Develop ETL strategies for data integration - Design database schema for new enhancement requirements Qualifications Required: - Proficiency in developing stored procedures, functions, and views - Strong knowledge of database design and usage best practices - Experience in developing ETL strategies for data integration - Familiarity with optimizing database performance - Knowledge of PostgreSQL and PG_DUMPALL - Experience in setting up WAL archiving and PGBASE BACKUP using BART - Hands-on experience in implementing and configuring PostgreSQL Replication for hot Standby - Ability to handle concepts like transferring WAL to standby machines for zero percent data loss,