14 Nov
|
smartdata enterprises
|
India
14 Nov
smartdata enterprises
India
PostgreSQL DBA / Parser Developer
Experience: 5+ Years
Role Overview
Looking for a skilled PostgreSQL DBA / Parser Developer with expertise in database administration, performance tuning, and developing file parsers for large-volume data processing.
Key Responsibilities
- Manage and maintain PostgreSQL databases across production and development environments.
- Perform query optimization, indexing, database monitoring, and performance tuning.
- Handle database backup, recovery, VACUUM, ANALYZE, and maintenance.
- Develop and maintain file parsers using Python or C#.
- Process and validate CSV, JSON, XML, HL7, and EDI files.
- Implement data transformation, error handling, and logging mechanisms.
- Integrate parsers with PostgreSQL for accurate and efficient data loading.
- Troubleshoot production issues and perform Root Cause Analysis (RCA).
Required Skills
- Robust PostgreSQL, SQL, and PL/pgSQL expertise.
- Database administration and performance tuning.
- Python or C# programming.
- File parsing and data processing.
- Linux and Shell Scripting.
- Production troubleshooting and debugging.
Preferred Skills
- HL7, FHIR, EDI 837/835, and healthcare data.
- AWS RDS PostgreSQL, replication, PgBouncer.
- pgBackRest / Barman.
- Experience handling large databases and high-volume data processing.
Pay: ₹600,000.00 - ₹1,200,000.00 per year
Benefits:
- Flexible schedule
Work Location: Remote
📌 PostgreSQL DBA / Parser Developer (India)
🏢 smartdata enterprises
📍 India