Role Overview
We are looking for a PostgreSQL DBA / Parser Developer who can manage PostgreSQL databases and also develop, maintain, and troubleshoot data parsers that process large files and load data into PostgreSQL.
The candidate will work closely with the development and project teams to ensure reliable file processing, accurate data loading, database performance, and production stability.
Key Responsibilities
PostgreSQL DBA

- Manage PostgreSQL databases in development, staging, and production.
- Monitor database performance, CPU, memory, disk I/O, connections, locks, and long-running queries.
- Perform query optimization using EXPLAIN and EXPLAIN ANALYZE.
- Review indexes, execution plans, functions, procedures, and database configuration.
- Manage VACUUM, ANALYZE, autovacuum, database bloat, and statistics.
- Manage database backup, restore, recovery, and maintenance.
- Troubleshoot production database issues and provide RCA.
- Monitor database growth and provide capacity planning recommendations.

Parser Development

- Design and develop parsers for large files and structured/semi-structured data.
- Write parsing logic using Python, C#, or other suitable technologies.
- Process CSV, JSON, XML, HL7, EDI, and other data formats.
- Validate incoming files before processing.
- Identify and handle malformed, missing, duplicate, or invalid records.
- Transform parsed data into the required database structure.
- Develop reliable data-loading processes into PostgreSQL.
- Troubleshoot parser failures and data-processing issues.
- Improve parser performance for large files and high-volume processing.
- Create logging and error-handling mechanisms to identify failed records and processing issues.

Database + Parser Integration

- Work on the complete workflow:





File → Parser → Validation → Transformation → PostgreSQL → Reporting/Application

- Investigate issues where files are processed incorrectly or data is missing from PostgreSQL.
- Optimize database queries and parser logic together to improve overall processing time.
- Review database tables and indexes required for parser workloads.
- Develop scripts for data validation, reconciliation, and cleanup.
- Support production file-processing jobs and resolve failures quickly.

Required Skills

- PostgreSQL administration
- Solid SQL and PL/pgSQL
- Query performance tuning
- Database indexing
- VACUUM / ANALYZE / Autovacuum
- Backup and recovery
- Database monitoring
- Linux
- Python or C#
- File parsing and data transformation
- JSON / XML / CSV processing
- Large-volume data processing
- Production troubleshooting
- Shell scripting

Preferred Experience

- HL7 / FHIR
- EDI 837 / 835
- Healthcare data processing
- AWS RDS PostgreSQL
- PostgreSQL replication
- pgBackRest / Barman
- PgBouncer
- Large PostgreSQL databases
- Long-running data-processing jobs
- Data migration and archival

Candidate Profile
The ideal candidate should be comfortable working as both a PostgreSQL DBA and a hands-on developer. This is not a purely administrative DBA role. The person should be able to investigate a production issue, identify whether the root cause is in the parser, application, query, database, or infrastructure, and work on the required solution.
Key Deliverables

- Stable PostgreSQL environment
- Reliable file parser
- Accurate data processing and database loading
- Improved parser and database performance
- Production issue resolution
- Backup and recovery readiness
- Database monitoring and capacity planning
- Clear technical documentation and RCA Review resume

Please share your updated CV on [email protected] or call on (phone hidden)

Pay: ₹50,000.00 - ₹100,000.00 per month

Work Location: Remote

📌 PostgreSQL DBA (India)
🏢 smartdata enterprises
📍 India