PostgreSQL Database Administrator

**Company Description**
Headquartered in Princeton New Jersey, AH Infotech is an IT consulting and services company committed to offering customized technology solutions for businesses. Founded in 2015, the company employs over 200 people with global operations and provides impactful results to its customers across North America, Europe, and Asia -Pacific. AH Infotech provides services in cloud migration, cloud operations, enterprise services, and cloud enablement. AH Infotech is an organization focused on delivering high-quality technology solutions for business; we help our clients in digital transformation in ways that meets security, affordability, and scalability concerns.

Key Responsibilities:
1. Database Administration:

- Administer and maintain PostgreSQL databases across development, staging, and production environments.
- Implement database management policies, procedures, and standards.
- Monitor database performance, optimize SQL queries, and resolve performance issues.

2. Database Migration:

- Plan and execute migrations of databases from legacy systems (e.g., Oracle, MySQL, SQL Server) to PostgreSQL.
- Develop and implement data migration strategies, scripts, and procedures.
- Conduct pre
- and post-migration performance and compatibility testing.
- Troubleshoot migration-related issues, ensuring data integrity and accuracy.

3. Backup & Recovery:

- Design and implement robust backup, recovery, and archiving strategies.
- Perform regular database backups and conduct periodic disaster recovery tests.

4. Security & Compliance:

- Manage database security, including roles, permissions, and encryption.
- Ensure compliance with organizational policies, regulatory requirements, and best practices.

5. Performance Tuning & Optimization:

- Proactively monitor and tune the database for optimal performance.
- Analyze and troubleshoot slow-running queries and optimize database indexes.
- Implement database monitoring and alerting to ensure performance SLAs.

6. High Availability & Replication:

- Configure and maintain high-availability solutions such as replication and clustering.
- Set up and manage replication for both high availability and scaling purposes.

7. Documentation & Training:

- Document migration plans, database architectures, and configurations.
- Provide training and support to development teams on PostgreSQL best practices.

Required Skills & Qualifications:

- Bachelor’s degree in Computer Science, Information Technology, or a related field.
- 5+ years of experience as a PostgreSQL DBA, with at least 2 years focused on database migration.
- Proven experience migrating from Oracle, MySQL, SQL Server, or other RDBMS to PostgreSQL.
- Strong knowledge of PostgreSQL architecture, replication, clustering, and tuning.
- Expertise in SQL query optimization, indexing strategies, and performance tuning.
- Experience with backup, restore, and recovery models.
- Familiarity with tools for database migration (e.g., pg_dump, pg_restore, AWS DMS, Oracle GoldenGate).
- Proficiency with Linux operating systems and shell scripting.
- Knowledge of database security practices and data encryption.
- Familiarity with cloud database management on AWS, GCP, or Azure is a plus.

**Qualifications**

Preferred Qualifications:

- Certification in PostgreSQL or related database technologies.
- Experience with DevOps practices and automation tools (e.g., Ansible, Terraform).
- Knowledge of additional databases (e.g., MongoDB, Redis) is a plus.
- Experience in agile project management environments.

**Additional Information**
Employee Benefits - Health Insurance

All your information will be kept confidential according to EEO guidelines.

Within our workplace, we prioritize open communication, mutual respect, and continuous learning to foster a dynamic team atmosphere. We're committed to the professional development and well-being of our employees, providing opportunities for growth and advancement.

Join us in shaping the future of technology - where innovation and collaboration intersect at AH Infotech