CES has 26+ years of experience in delivering Software Product Development, Quality Engineering, and Digital Transformation Consulting Services to Global SMEs & Large Enterprises. CES has been delivering services to some of the leading Fortune 500 Companies including Automotive, AgTech, Bio Science, EdTech, FinTech, Manufacturing, Online Retailers, and Investment Banks. These are long-term relationships of more than 10 years and are nurtured by not only our commitment to timely delivery of quality services but also due to our investments and innovations in their technology roadmap. As an organization, we are in an exponential growth phase with a consistent focus on continuous improvement, process-oriented culture, and a true partnership mindset with our customers. We are looking for the right qualified and committed individuals to play an exceptional role as well as to support our accelerated growth. You can learn more about us at: http://www.cesltd.com/
Job Role:
We are seeking an experienced Lead Postgres DBA to join our dynamic team.
Roles & Responsibilities:
- The ideal candidate should have a strong background in optimizing existing application SQL Code, procedures, design review, proactive monitoring check.
- This role is demands 80% of performance tuning and monitoring and 20% on DBA Activities.
- Team Management: Ability to lead, mentor, and motivate a team of SQL support analysts, fostering a collaborative and productive work environment. •
- Delegation: Skill in assigning tasks based on team members' strengths and providing clear instructions to ensure effective task completion.
- • Communication: Excellent communication skills, both written and verbal, to explain technical concepts to both technical and non-technical stakeholders.
- Active Listening: Ability to listen attentively to team members, colleagues, and end-users to understand their concerns and needs. •
- Prioritization: Capacity to prioritize tasks based on urgency and impact, ensuring that critical issues are addressed promptly.
- Conflict Management: Skill in handling conflicts and disagreements within the team or between teams in a constructive and diplomatic manner.
- End-User Support: Patience and empathy when dealing with end-users who may be facing database-related challenges.
- Knowledge Sharing: Willingness to share knowledge and experiences with team members to enhance the overall skill level of the team.
Ideal Candidate:
- Collaborate with cross-functional teams to understand database requirements, optimize performance, and implement best practices.
- Monitor and maintain the health, security, and availability of databases, proactively addressing potential issues and recommending improvements.
- Troubleshoot and resolve complex SQL-related problems, working closely with developers, system administrators, and other stakeholders.
- Develop and maintain documentation on database configurations, standard operating procedures, and troubleshooting guides.
- Build KB’s and maintain all the troubleshooting information with latest learnings.
Skills and Qualifications Must to Have :
- Proven experience (8+ years) in SQL Performance Optimization at (SQL Script, Index, Design and Infra)
- Strong proficiency in SQL querying, indexing, performance tuning, and optimization.
- Leadership experience, with the ability to lead and motivate a team.
- In-depth knowledge of database management systems (DBMS), with a focus on PostgreSql , other DBMS like (MSSQL, Oracle and MySQL) is a big plus.
- Excellent problem-solving skills and the ability to diagnose and resolve complex technical issues.
- Strong communication and interpersonal skills to collaborate effectively with technical and non-technical stakeholders.
- Good to Have • Experience with cloud-based databases and technologies is a plus. • Relevant certifications are a plus.