Lynker Corporation is seeking a Database Administrator with PostgreSQL specialization to manage, maintain, and optimize PostgreSQL databases to ensure high performance, reliability, and scalability of applications and systems for upcoming contract bid.
Requirements
- 6+ years of hands-on experience managing PostgreSQL databases in production environments.
- Expertise in database design, optimization, and performance tuning in PostgreSQL.
- Solid understanding of SQL and experience with writing complex queries, stored procedures, and triggers.
- Proficiency with PostgreSQL administration tools and utilities such as pgAdmin, psql, and others.
- Experience with database backup and recovery strategies, including Point-in-Time Recovery (PITR).
- Strong knowledge of replication (e.g., streaming replication, logical replication) and clustering.
- Familiarity with cloud-based database solutions (AWS RDS, Azure, Google Cloud, etc.).
Responsibilities
- Administer, configure, and maintain PostgreSQL databases across multiple environments, ensuring high availability and security.
- Perform regular database backups, recovery, and disaster recovery planning.
- Monitor and tune database performance, including query optimization, index management, and resource utilization.
- Troubleshoot database-related issues, including performance degradation, connectivity issues, and data integrity problems.
- Work closely with application developers to design and implement efficient database schemas, queries, and indexing strategies.
- Implement security policies and ensure compliance with internal and external regulations regarding data storage and access.
- Perform routine database upgrades and patch management to ensure systems are up-to-date and secure.
Other
- Bachelor's degree in Computer Science, Information Technology, or a related field, or equivalent work experience.
- Strong analytical and troubleshooting skills with the ability to work under pressure.
- Excellent communication skills and the ability to collaborate with both technical and non-technical teams.
- Certifications related to PostgreSQL or database management (e.g., PostgreSQL Certified Professional).
- Familiarity with other relational databases such as MySQL or Oracle.
