4 Pgbouncer Jobs

Job Summary: We are looking for an experienced and detail-oriented PostgreSQL Database Administrator (DBA) to manage and maintain our database systems. The ideal candidate will have a strong background in PostgreSQL administration, performance tuning, backup and recovery, and high availability solutions. Key Responsibilities: Install, configure, upgrade, and maintain PostgreSQL database servers. Monitor database performance, implement changes, and apply new patches and versions when required. Ensure high availability, backup, and disaster recovery strategies are in place and tested. Perform regular database maintenance tasks including re-indexing, vacuuming, and tuning. Manage database access, roles, and permissions securely. Write and maintain scripts for automation of routine database tasks. Work closely with developers to optimize queries and schema design. Troubleshoot and resolve database-related issues promptly. Implement and monitor replication strategies (logical and physical replication). Perform regular security assessments and apply best practices to secure data. Participate in on-call rotation and provide production support as needed. Required Skills: Minimum 4 years of hands-on experience with PostgreSQL administration. Strong experience in performance tuning and query optimization. Experience with database backup, restore, and disaster recovery planning. Good understanding of PostgreSQL internals. Familiarity with tools like pgAdmin , pgBouncer , pgBackRest , or Patroni . Knowledge of Linux/Unix systems for managing PostgreSQL on those platforms. Experience with shell scripting and automation tools. Basic understanding of cloud platforms like AWS/GCP/Azure (RDS, Aurora, etc.) is a plus. Knowledge of monitoring tools like Prometheus , Grafana , or similar.

Enlog is a leading provider of electricity management solutions for energy-conscious smart buildings. Our mission is to create a greener earth by promoting the smart and efficient use of electricity. Since our inception in 2017, we have focused on transforming homes and businesses into energy-conscious smart spaces, enhancing quality of life and comfort through our innovative energy management technologies. Join our dynamic team and be part of our journey to make energy-conscious living a reality. As a member of our team, you will be responsible for: - Possessing in-depth knowledge of object-relational mapping, server-side logic, and REST API. - Demonstrating expertise in databases such as MySQL, PostgreSQL, and other relational and non-relational databases. - Utilizing AWS Lightsail, Celery, Celery-beat, Redis, and Docker. - Conducting testing of REST APIs using Postman. - Managing code and projects on Git to ensure synchronization with other team members and managers. - Coordinating with front-end developers to ensure seamless integration. Why You Should Work Here: At Enlog, we value innovation, collaboration, and continuous improvement. By joining our team, you will have the opportunity to work on cutting-edge technologies and contribute to projects that have a significant impact on energy management and sustainability. Our dynamic and supportive work environment fosters personal and professional growth. We are committed to maintaining a diverse and inclusive workplace that enables everyone to thrive. Joining Enlog means becoming part of a team dedicated to promoting smart and efficient energy use, and making a positive impact on the environment and society. Technologies We Use: - AWS EC2 - AWS Lightsail - Docker - Kafka - PostgreSQL - Golang - Django REST Framework - MQTT protocols - Kubernetes - PgBouncer - Clickhouse - Scylladb - DragonFly About Enlog: Founded in 2017, Enlog provides electricity management solutions for energy-conscious smart buildings. Our innovations in energy management enhance quality of life and comfort while promoting responsible electricity use. Our flagship product, Smi-Fi, is an energy-assistant IoT device that encourages energy conservation in residential and commercial spaces. With over 3,000 active installations and a growing customer base, we are at the forefront of energy management solutions in India.,

Job description for a PostgreSQL Database Administrator: Key Responsibilities 1. *Database Design and Implementation*: Design, implement, and maintain databases to meet organizational needs. 2. *Database Administration*: Manage and administer databases, including data modeling, normalization, and optimization. 3. *Data Security and Backup*: Ensure data security, integrity, and availability by implementing backup and recovery procedures. 4. *Performance Monitoring and Optimization*: Monitor database performance, identify bottlenecks, and optimize database configuration for improved performance. 5. *Troubleshooting and Support*: Troubleshoot database issues, provide technical support, and resolve database-related problems. 6. *Data Migration and Integration*: Plan, coordinate, and execute data migrations and integrations with other systems. 7. *Database Upgrades and Patches*: Apply database upgrades, patches, and fixes to ensure database stability and security. 8. *Documentation and Reporting*: Maintain accurate documentation, reports, and metrics on database performance, security, and usage. Requirements 1. *Technical Skills*: Proficiency in database management systems (DBMS) such as Oracle, Microsoft SQL Server, MySQL, or PostgreSQL. 2. *Database Design and Development*: Knowledge of database design principles, data modeling, and normalization. 3. *SQL and Query Optimization*: Strong understanding of SQL, query optimization, and performance tuning. 4. *Data Security and Backup*: Knowledge of data security best practices, backup and recovery procedures, and disaster recovery planning. 5. *Problem-Solving and Troubleshooting*: Excellent problem-solving and troubleshooting skills, with the ability to analyze complex database issues. 6. *Communication and Collaboration*: Effective communication and collaboration skills, with the ability to work with technical and non-technical stakeholders. Nice to Have 1. *Certifications*: Database certifications such as Oracle Certified Professional (OCP), Microsoft Certified Database Administrator (MCDA), or Certified Data Administrator (CDA). 2. *Cloud Experience*: Experience with cloud-based databases such as Amazon RDS, Google Cloud SQL, or Microsoft Azure Database Services. 3. *Data Warehousing and Business Intelligence*: Knowledge of data warehousing and business intelligence concepts, including data modeling, ETL, and data visualization.

job Role Database administrator Job Description: As a Database Administrator , you will be responsible for managing, maintaining, and optimizing our database systems to ensure high availability and performance. You will play a key role in supporting our mission-critical applications and collaborating with stakeholders across the organization. Key Responsibilities: Design, implement, and maintain PostgreSQL/EDB databases, ensuring high availability using tools like pgbouncer and BART. Manage Oracle Database 19c environments, including RAC and Data Guard configurations. Monitor and optimize database performance, ensuring efficient data storage and retrieval. Collaborate with IT and development teams to support database needs and resolve issues. Implement backup and recovery strategies to ensure data integrity and security. Provide technical expertise and guidance on database architecture and best practices. Participate in capacity planning and performance tuning activities. Communicate effectively with stakeholders, providing updates and insights on database status and improvements. Must-Have Qualifications: At least 10 years of relevant industry experience as a Database Administrator. Hands-on experience with PostgreSQL/EDB databases, including high availability tools like pgbouncer and BART. Expertise in Oracle Database 19c, including RAC and Data Guard. Strong communication skills and the ability to manage stakeholder relationships effectively. Proven problem-solving skills with the ability to work independently and as part of a team. Flexibility to work in different time zones as needed to support global operations. Telecom industry exposure and understanding of its unique database requirements. Good-to-Have skill : Experience with Oracle GoldenGate for data integration and replication. Exposure to at least one NoSQL database, such as Cassandra or MongoDB.