PostgreSQL Database Engineer/Postgresql DBA( On W2 /1099)

Droisys is an innovation technology company focused on helping companies accelerate their digital initiatives. They are seeking a PostgreSQL Database Engineer/DBA responsible for managing, maintaining, and optimizing PostgreSQL database environments, ensuring database availability, and supporting performance tuning and automation initiatives.

Responsibilities:

• Install configure and upgrade PostgreSQL databases across environments
• Manage database objects schemas tables indexes triggers and maintain database schema integrity
• Perform performance tuning query optimisation and capacity planning
• Act as L2 escalation for database related incidents and service requests
• Troubleshoot and resolve issues related to replication backup failures and performance bottlenecks
• Implement and monitor backup strategies using native tools pgdump pgbasebackup
• Perform disaster recovery drills and ensure compliance with RPORTO objectives
• Configure and maintain HADR setups streaming replication logical replication
• Monitor replication lag and ensure failover readiness
• Manage user roles permissions and database security policies
• Ensure compliance with internal and regulatory standards
• Develop automation scripts Shell / Python for routine DBA tasks
• Implement proactive monitoring and ing for database health
• Work with developers DevOps and application teams on schema design migrations and CICD pipelines
• Provide best practice guidance for database usage and performance

Requirements:

• Strong knowledge of PostgreSQL architecture configuration and internals
• Hands-on experience with PostgreSQL upgrades patching and migrations from Oracle or other RDBMS
• Familiarity with VACUUM ANALYZE AutoVacuum tuning and tablespace management
• Proficiency in pgAdmin psql and monitoring tools eg pgstatstatements Prometheus Grafana
• Scripting skills in Shell Python for automation
• Strong analytical and troubleshooting skills
• Ability to work in 24x7 rotational shifts and handle on-call support
• Good communication and documentation skills