Job Description

Job Types: Full Time
Job Locations: Bangalore Remote
Job Synopsis:

The successful candidate will be responsible for the administration, maintenance, performance tuning, and security of our PostgreSQL database environment. The ideal candidate will have 5-8 years of experience working with PostgreSQL databases in a production environment, with a good understanding of database architecture and best practices.


Responsibilities:


• Install, configure, and upgrade PostgreSQL database software.
• Design, implement, and maintain database schemas, tables, indexes, and views.
• Monitor and optimize database performance, including query tuning, indexing, and caching strategies.
• Implement and maintain database security policies, including user access control and data encryption.
• Perform regular backups and disaster recovery planning and testing.
• Troubleshoot and resolve database-related issues, including system outages and performance bottlenecks.
• Collaborate with development teams to design and implement database solutions that meet business requirements.
• Automate repetitive tasks and develop scripts for database administration and maintenance.
• Stay up-to-date with the latest trends and technologies in database administration and recommend best practices for database management.





Qualifications:


• Proficiency in SQL programming and database query optimization.
• Good Experience in MySQL or Oracle
• Knowledge in GCP/AWS and Scripting
• Good understanding of database security principles and best practices.
• Experience with availability and disaster recovery solutions for PostgreSQL databases.
• Knowledge of PostgreSQL replication, clustering, and partitioning techniques.
• Familiarity with database backup and recovery procedures.
• Excellent problem-solving skills and attention to detail.
• Strong communication and collaboration skills, with the ability to work effectively in a team environment.
• Ability to work from home and be self-motivated
• Ability to work a flexible Schedule and manage your time effectively to deliver your work on time
• Be a team player and know that you are part of a highly motivated team





Benefits:


• Competitive salary and benefits package.
• Opportunities for professional development and training.
• Collaborative and innovative work environment.
• Health and wellness programs.