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 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

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

Pay: Up to ₹1,220,000.00 per year

Work Location: Remote

📌 PostgreSQL DBA & Developer (India)
🏢 smartdata enterprises
📍 India