Job description 

Project Role Description : Provide ongoing technical support and maintenance of production and development systems and software products (both remote and onsite) and for configured services running on various platforms (operating within a defined operating model and processes). Provide hardware/software support and implement technology at the operating system-level across all server and network areas, and for particular software solutions/vendors/brands. Work includes L1 and L2/ basic and intermediate level troubleshooting. 
Must have skills : PostgreSQL Administration
Good to have skills : Database Management
Minimum 2 year(s) of experience is required
Educational Qualification : Graduate

Summary: As a PostgreSQL and MYSQL Database Administrator with 3+ years of experience, you will be responsible for managing and optimizing our PostgreSQL/MYSQL databases to ensure high availability, performance, and security. You will play a critical role in the design, implementation, and maintenance of complex database solutions. Roles & Responsibilities: 1 Database Design and Optimization: - Design and implement PostgreSQL database solutions to meet application requirements, considering scalability, performance, and reliability. - Optimize queries and database performance through indexing, query tuning, and appropriate database configuration settings. 2 High Availability and Disaster Recovery: - Implement and manage replication, clustering, and failover solutions to ensure high availability and disaster recovery capabilities. - Establish and maintain backup and recovery strategies to minimize data loss and downtime. 3 Security and Compliance: - Implement and enforce security policies, access controls, and encryption mechanisms to maintain data integrity and comply with industry standards and regulations. - Conduct periodic security audits and vulnerability assessments. 4 Monitoring and Performance Tuning: - Set up monitoring systems to track database performance, identify bottlenecks, and proactively address issues. - Analyze query plans and database performance metrics to optimize and fine-tune the database environment. 5 Documentation and Training: - Document database architecture, configurations, procedures, and best practices. - Provide training and mentorship to junior team members, sharing knowledge and expertise in PostgreSQL database administration. Professional & Technical Skills: • Proficiency in SQL and PL/pgSQL. • Experience with PostgreSQL/MYSQL performance tuning, replication, clustering, and disaster recovery solutions. • Familiarity with PostgreSQL/MYSQL extensions and ecosystem. • Strong problem-solving and troubleshooting skills. • Excellent communication and collaboration skills. Additional Information: MYSQL, Snow and ITIL knowledge.