PostgreSQL Consultant

Position: PostgreSQL Consultant

Location: Folsom CA

Must Have Skills:

• PostgreSQL database servers
• Query optimization
• Managing user access and security permissions

Detailed Job Description:

We are seeking a PostgreSQL Consultant with over 10 years of experience to join our team in Folsom CA working on projects for the client. The ideal candidate will have extensive expertise in PostgreSQL database administration including installation configuration and maintenance of database servers. Strong skills in query optimization and user access management are essential for this role.

Responsibilities:

• Install configure and maintain PostgreSQL database servers to ensure optimal performance and reliability.
• Monitor and optimize database performance including query optimization indexing and caching strategies.
• Implement and manage backup and recovery processes to safeguard data integrity and availability.
• Troubleshoot databaserelated issues diagnosing and resolving performance problems and system errors.
• Collaborate with developers to design and implement database schemas stored procedures and other database objects.
• Manage user access and security permissions within the database environment to ensure data confidentiality and integrity.
• Plan and execute database upgrades and migrations with minimal downtime and risk.
• Document database configurations processes and procedures to maintain a comprehensive knowledge base.
• Stay updated with PostgreSQL releases updates and best practices to ensure compliance and efficiency.
• Participate in oncall rotations for afterhours support and maintenance as needed.

If you are a skilled PostgreSQL Consultant with a strong background in database administration and are looking for an exciting opportunity to work in Folsom CA we encourage you to apply. This role offers competitive compensation and the chance to contribute to impactful projects in a dynamic team environment.