Key Result Areas And Activities
(Received KRAs)
• Administration and management of PostgreSQL databases
• Performance tuning and optimization of databases
• Replication and clustering setup and maintenance, Postgres DBA expertise having at least 3-4 years of relevant work experience.
• Participate & working in restore, patching activities, Backup, and recovery of databases & Backup Reporting.
• Security management, including user management and data encryption.
• Monitor and troubleshoot database issues.
• Plan and implement database upgrades and patches.
• Monitor the event alerts and notify to the concerned team and process the requests from the end users to level 2 and level 3 support engineers.
• Collaborate with developers and other teams to ensure the proper functioning of databases.
• Ensure optimal balance between cost and performance.
• Good programming skills – quick and self-learner and has good experience in Cloud technologies (AWS, IBM), ETL, python etc.
(Revised KRAs)
• Performance Tuning and Optimization: Focus on enhancing database performance through tuning, optimizing queries, and improving overall system efficiency.
• Replication, Clustering, and Expertise: Set up and maintain replication and clustering configurations to ensure high availability and disaster recovery, leveraging 3-4 years of relevant PostgreSQL experience.
• Backup, Recovery and Security Management: Manage backup and recovery procedures, patching, and backup reporting. Implement robust security measures, including user management and data encryption.
• Monitoring, Troubleshooting and Upgrades: Monitor database systems for performance and issues, troubleshoot problems, and plan and execute database upgrades and patches. Handle event alerts and coordinate with support teams as needed.
Essential Skills
Work and Technical Experience:
• Postgres DBA expertise
• Experience on RDBMS SQL, PL/SQL
• Experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools
• Hands-on experience in DB administration tools
Desirable Skills
• AWS Cloud
• Experience using Linux
Qualifications
• 5 to 9 years of IT experience with 3+ years in Postgres DBA
• Bachelor’s degree in computer science, engineering, or related field (Master’s degree is a plus)
• Demonstrated continued learning through one or more technical certifications or related methods
Qualities
• Self-motivated and focused on delivering outcomes for a fast-growing team and firm
• Able to communicate persuasively through speaking, writing, and client presentations
• Work independently based on the mentorship provided by managers
• Able to iterate based on new information, peer reviews, and feedback
• Able to work with teams and clients in different time zones
• Research focused mindset
Location: Pune, MH, IN
Offer Expires: 2024-11-06 16:05:24
Job Posting Language: en
LinkedIn: Apply Here