We are seeking a PostgreSQL Database Administrator (DBA) to join our team. The right person for this position will be a self-starter who has at least 5 years of experience as a PostgreSQL Database Administrator. As a PostgreSQL DBA you will be responsible for managing, maintaining, and optimizing our PostgreSQL database environments. You will play a critical role in ensuring the security, reliability, and performance of our database infrastructure.
Manage and maintain the PostgreSQL database environment, including installation, configuration, and ongoing administration. Troubleshoot and resolve database-related issues, including performance bottlenecks, connectivity problems, and data corruption. Collaborate with software development teams to optimize database schema, queries, and overall application performance. Create and maintain documentation on database configurations, procedures, and troubleshooting steps. Monitor and optimize database performance, including query optimization, index tuning, and resource utilization. Implement and maintain database replication and high availability solutions. Develop and enforce database security policies and best practices, including user/role management, encryption, and auditing. Stay up to date with the latest PostgreSQL features, tools, and best practices.
Bachelor's degree in Computer Science, Information Technology, or a related field. 5 years of hands-on experience as a PostgreSQL (or similar) Database Administrator. Strong knowledge of SQL database administration, including backup, recovery, replication, and performance tuning. Experience working with enterprise or application implementations of a data warehouse, data lake, and data marts. Proficiency in SQL and PL/pgSQL languages. Working knowledge of AWS Excellent problem-solving skills and the ability to work independently and as part of a team. Strong communication and interpersonal skills. Thank you &