iServeU Technology - PostgreSQL Administrator - Performance Tuning

<p><p><b>About the job :</b><br/><br/><b>Key Responsibilities :</b><br/><br/><b>Database Installation and Configuration :</b><br/><br/>- Install, configure, and manage PostgreSQL databases.<br/><br/>- Optimize database performance through tuning and configuration.<br/><br/>- Implement data replication and high availability strategies.<br/><br/><b>Data Modeling :</b><br/><br/>- Design and implement PostgreSQL data models that align with application requirements.<br/><br/>- Optimize data schema for efficient querying and updates.<br/><br/><b>Performance Tuning :</b><br/><br/>- Monitor database performance and identify bottlenecks.<br/><br/>- Tune PostgreSQL settings to improve query response times and throughput.<br/><br/>- Optimize data distribution and indexing strategies.<br/><br/><b>Backup And Recovery :</b><br/><br/>- Implement and maintain backup and recovery procedures.<br/><br/>- Test disaster recovery plans regularly.<br/><br/><b>Security & Troubleshooting :</b><br/><br/>- Implement security measures to protect PostgreSQL data.<br/><br/>- Manage access controls and permissions.<br/><br/>- Monitor for security threats and vulnerabilities.<br/><br/>- Diagnose and resolve PostgreSQL-related issues.<br/><br/>- Analyze logs and metrics to identify problems.<br/><br/>- Provide technical support to development teams.<br/><br/><b>Requirements :</b><br/><br/><b>Required Skills and Qualifications :</b><br/><br/>- Strong understanding of PostgreSQL architecture and concepts.<br/><br/>- Experience with relational databases and data modelling.<br/><br/>- Proficiency in scripting languages (e.g., Bash, Python).<br/><br/>- Knowledge of database administration concepts (e.g., backups, replication, tuning).<br/><br/>- Experience with performance tuning & optimization.<br/><br/>- Problem-solving and troubleshooting skills.<br/><br/>- Strong communication and collaboration skills.<br/><br/><b>Preferred Skills And Qualifications :</b><br/><br/>- Certifications in PostgreSQL (e.g., PostgreSQL Certified Professional).<br/><br/>- Experience with cloud-based PostgreSQL deployments.<br/><br/>- Familiarity with other relational databases (e.g., MySQL, Oracle)</p><br/></p> (ref:hirist.tech)