iServeU Technology - PostgreSQL Administrator - Performance Tuning

About the job :

Key Responsibilities :

Database Installation and Configuration :

- Install, configure, and manage PostgreSQL databases.

- Optimize database performance through tuning and configuration.

- Implement data replication and high availability strategies.

Data Modeling :

- Design and implement PostgreSQL data models that align with application requirements.

- Optimize data schema for efficient querying and updates.

Performance Tuning :

- Monitor database performance and identify bottlenecks.

- Tune PostgreSQL settings to improve query response times and throughput.

- Optimize data distribution and indexing strategies.

Backup And Recovery :

- Implement and maintain backup and recovery procedures.

- Test disaster recovery plans regularly.

Security & Troubleshooting :

- Implement security measures to protect PostgreSQL data.

- Manage access controls and permissions.

- Monitor for security threats and vulnerabilities.

- Diagnose and resolve PostgreSQL-related issues.

- Analyze logs and metrics to identify problems.

- Provide technical support to development teams.

Requirements :

Required Skills and Qualifications :

- Strong understanding of PostgreSQL architecture and concepts.

- Experience with relational databases and data modelling.

- Proficiency in scripting languages (e.g., Bash, Python).

- Knowledge of database administration concepts (e.g., backups, replication, tuning).

- Experience with performance tuning & optimization.

- Problem-solving and troubleshooting skills.

- Strong communication and collaboration skills.

Preferred Skills And Qualifications :

- Certifications in PostgreSQL (e.g., PostgreSQL Certified Professional).

- Experience with cloud-based PostgreSQL deployments.

- Familiarity with other relational databases (e.g., MySQL, Oracle)