Postgre-SQL database Administration

Job Description

Role Purpose The purpose of this role is to provide significant technical expertise in architecture planning and design of the concerned tower (platform, database, middleware, backup etc) as well as managing its day-to-day operations 5+ years of experience in PostgreSQL Database Administration Design, configure, test, and support high-availability clustering utilizing PostgreSQL technologies Responsible for understanding operational requirements including Hardware, Architecture, configuration, Integration and maintaining mission-critical Production PostgreSQL databases. Responsible for allLogical and Physical backup & recovery even PITR recovery. Deep understanding about streaming replication and barman backups\recovery. Should poses knowledge on authentication and privilege management. Manage Clusters andupgrading/migrating various PostgreSQL database version. Performance Tuning, Replication, and develop database automation scripts and maintenance. Proficiency logical and physical design of database, monitoring and troubleshooting. Knowledge in DB2 LUW and Mongodb administration is added advantage Provide technical guidance forintegration, testing, design, development, planning of new production systems/databases. Team Management Resourcing Forecast talent requirements as per the current and future business needs Hire adequate and right resources for the team Train direct reportees to make right recruitment and selection decisions Talent Management Ensure 100% compliance to Wipros standards of adequate onboarding and training for team members to enhance capability & effectiveness Build an internal talent pool of HiPos and ensure their career progression within the organization Promote diversity in leadership positions Performance Management Set goals for direct reportees, conduct timely performance reviews and appraisals, and give constructive feedback to direct reports. Ensure that organizational programs like Performance Nxt are well understood and that the team is taking the opportunities presented by such programs to their and their levels below Employee Satisfaction and Engagement Lead and drive engagement initiatives for the team Track team satisfaction scores and identify initiatives to build engagement within the team Proactively challenge the team with larger and enriching projects/ initiatives for the organization or team Exercise employee recognition and appreciation Deliver NoPerformance ParameterMeasure1Operations of the towerSLA adherence Knowledge management CSAT/ Customer Experience Identification of risk issues and mitigation plans Knowledge management2New projectsTimely delivery Avoid unauthorised changes No formal escalations Mandatory Skills: PostgreSQL Database Admin. Experience5-8 Years.