Job Title: PostgreSQL PL/pgSQL Developer
Company: MetaDesign Solutions
Location: Gurugram, Haryana, India (On-site)
MetaDesign Solutions is a technology solutions firm that delivers custom software, data-driven platforms, and cloud-native systems for enterprise and mid-market customers. We design and build high-performance web and mobile applications, analytics platforms, and integration solutions that support business-critical workflows across sectors. We are seeking an experienced PostgreSQL PL/pgSQL Developer to join our engineering team and lead the design, optimization, and maintenance of complex PostgreSQL databases that power our SaaS products and client solutions. The successful candidate will deliver robust PL/pgSQL procedures, optimize large-scale queries, and implement scalable architectures that meet demanding availability and performance SLAs.
- Design, implement, and maintain normalized and denormalized PostgreSQL schemas optimized for performance, scalability, and maintainability in production systems.
- Develop, test, and maintain advanced PL/pgSQL stored procedures, functions, triggers, and custom types to encapsulate business logic and ensure data integrity.
- Author and maintain DDL and DML scripts for schema migrations, version-controlled database changes, and repeatable deployments.
- Analyze query performance with EXPLAIN/ANALYZE and execution plans; implement indexing strategies, partitioning, materialized views, and query rewrites to reduce latency and resource usage.
- Design and build ETL/ELT pipelines to ingest, transform, and consolidate data from multiple sources using SQL, Python, Talend, or Apache Airflow; ensure data quality and lineage.
- Implement data security and governance controls including role-based access, encryption-at-rest/in-transit, row-level security, and auditing to meet compliance requirements.
- Automate routine database operations (backups, vacuum, reindexing, statistics collection) and monitoring tasks using scripting, cron, or orchestration tools.
- Monitor production database health and availability using pg_stat_activity, pgAdmin, Grafana, Zabbix, or other monitoring solutions; rapidly troubleshoot and resolve incidents and performance bottlenecks.
- Collaborate with backend engineers, DevOps, and product teams to design efficient queries and data models; provide technical guidance and mentorship to junior database developers.
- Bachelor’s degree in Computer Science, Information Technology, Engineering, or equivalent practical experience.
- Minimum 5 years of hands-on experience designing, developing, and managing PostgreSQL databases in production environments.
- Advanced proficiency in PL/pgSQL with a proven track record of developing complex stored procedures, functions, and triggers.
- Deep understanding of SQL performance tuning techniques and experience using EXPLAIN, ANALYZE, and execution plan analysis.
- Experience implementing indexing strategies, partitioning schemes, materialized views, and query optimization for large datasets.
- Solid experience with backup and recovery tools (pg_dump, pg_restore, base backups) and knowledge of replication and high-availability approaches (streaming replication, Patroni, PgBouncer).
- Practical experience building ETL pipelines and integrating multiple data sources using SQL, Python (Pandas, SQLAlchemy), Talend, or Airflow.
- Proficiency in scripting (Python, Bash, or similar) for automation and job scheduling (cron, Airflow).
- Familiarity with monitoring tooling and metrics for PostgreSQL (pg_stat_activity, pg_stat_statements, Grafana, Zabbix) and strong troubleshooting skills.
- Excellent communication skills, ability to work on-site with cross-functional teams in Gurugram, and a collaborative mindset.
- Experience with cloud-hosted PostgreSQL services (AWS RDS/Aurora, Google Cloud SQL) and containerized deployments (Docker, Kubernetes).
- Knowledge of advanced high-availability and clustering solutions and experience operating Patroni, PgBouncer, or connection pooling at scale.
- Familiarity with data modeling for analytics/BI, columnar extensions (cstore_fdw or similar), and time-series optimizations.
- Exposure to observability platforms and distributed tracing for database-backed services (New Relic, Datadog, Grafana Loki).
- Contributions to open-source PostgreSQL extensions or community participation in database forums are a plus.
- Experience in domains such as fintech, e-commerce, healthcare, or SaaS where data integrity, performance, and compliance are critical.
- Competitive salary commensurate with experience and a performance-linked compensation structure.
- Comprehensive health insurance and wellness benefits for employees (and dependents where applicable).
- Opportunities for technical growth, including access to training, certifications, and conferences focused on databases and cloud-native engineering.
- Challenging, high-impact projects working with cross-functional product and engineering teams to build enterprise-grade solutions.
- Structured career progression, mentorship from senior engineers, and the chance to lead database design and best practices across products.
- Modern on-site engineering environment in Gurugram with collaboration-focused culture and regular knowledge-sharing sessions.
- Paid time off, sick leave, and other standard company benefits.
