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.
