Senior Consultant
- Winfo Consulting
- 2 - 7 years
- Hyderabad
- 2 months ago
- Email to a friend
- Report this job
Job Description
We are seeking a highly skilled Data Engineer with deep expertise in designing, maintaining, and optimizing multi-tenant PostgreSQL architectures. This role owns the platform s data backbone and ensures integrity, scalability, security, and high performance. You will also handle external data integrations, data pipelines, and PSA domain-specific models.
Design, implement, and maintain the multi-tenant PostgreSQL architecture , including schema-per-tenant and RLS.
Define logical and physical data models that scale with product growth.
Establish standards for normalization, denormalization, partitioning, indexing , and materialized views.
Optimize application-level data interactions by improving schema design and query paths.
2. Data Integrity, Security Performance Ensure data integrity, consistency, and reliability across all modules.
Continuously monitor and identify performance bottlenecks across queries, storage, indexing, and schema design.
Recommend and implement database design improvements , execution plan optimizations, and schema refactoring.
Manage connection pooling using tools such as PgBouncer or PgPool, ensuring efficient connection management, pooling strategies, and stability under load.
Tune vacuuming, autovacuum settings, and memory configurations for sustained performance.
Implement enterprise-grade database security , encryption, RBAC, and auditing.
3. Backup, Restore Disaster Recovery Manage and maintain multiple schemas with complete tenant isolation.
Design, automate, and manage full, incremental, and differential backup strategies .
Enable point-in-time recovery , schema-level restoration, and tenant-specific rollback workflows.
Execute backup integrity checks, periodic restoration drills, and disaster recovery validations.
Maintain WAL archiving, replication, and failover setups.
4. External Integrations Data Pipelines Build and maintain ETL/ELT pipelines from PSA/ERP/CRM and other external systems.
Implement ingestion workflows that ensure deduplication, normalization , mapping, and validation.
Manage integration challenges such as authentication, throttling, retries, scheduling, and reconciliation.
Ensure synchronized and reliable data exchange aligned with internal models.
5. Collaboration Product Support Work closely with backend engineers to refine ORM patterns, reduce query load, and optimize data access.
Support analytics/reporting needs by enabling efficient query models and derived datasets.
Translate product requirements into scalable database structures .
Document schemas, data flows, backups, performance guidelines, and integration logic.
6. DevOps Operational Responsibilities Manage database migrations , environment alignment, and safe deployment rollouts.
Implement monitoring and observability for slow queries, replication lag, connection saturation , and storage growth.
Contribute to CI/CD pipelines for data and database lifecycle processes.
Handle capacity planning, HA setups, and infrastructure tuning.
PostgreSQL (Expert):
Schema design, multi-tenancy, advanced SQL, indexing, partitioning, query optimization, execution planning, RLS.
Performance Optimization:
Ability to identify bottlenecks, analyze slow queries, recommend schema/query improvements, and tune workloads.
Connection Pooling:
Experience with PgBouncer/PgPool, pool configuration, load handling, transaction pooling, session management.
Backup Recovery:
PITR, WAL archiving, incremental backups, tenant-level restore, HA and DR strategies.
Data Engineering:
ETL/ELT pipelines, ingestion frameworks, transformation logic, CDC pipelines.
Integrations:
Experience working with PSA/ERP/CRM platforms and external APIs.
Scripting:
Strong Python skills for automation, ETL, tooling, and data workflows.
Cloud DevOps:
Managed PostgreSQL services, CI/CD for database changes, containerized workflows.
Domain Expertise Practical experience in the Professional Services Automation (PSA) domain.
Understanding of projects, timesheets, billing, utilization, and financial data models.
Knowledge of FastAPI or backend microservices patterns.
Familiarity with workflow/BPMN engines.
Experience with Azure PostgreSQL Flexible Server, Data Factory, or AKS.
Exposure to event-driven data architectures.
This is an opportunity to be a foundational member of a fast-paced, high-growth product team. You will be empowered to make significant technical decisions and see your contributions directly impact the business. We offer a challenging yet rewarding environment where technical innovation and ownership are highly valued. If you are a seasoned technologist ready to take on a Senior role and build a world-class product, we encourage you to apply.
Apply Now and let us redefine the future of Services Management.
Job Classification
Industry: IT Services & ConsultingFunctional Area / Department: Engineering - Software & QARole Category: Software DevelopmentRole: Technical LeadEmployement Type: Full timeContact Details:
Company: Winfo ConsultingLocation(s): Hyderabad+ View Contact
Keyskills: ERP Automation Data modeling Database design Postgresql Billing Workflow SQL CRM Python
Fraud Alert to job seekers!
₹ Not Disclosed
Similar positions
Winfo Consulting
ManageServe is SAP certified hosting service provider. ManageServe Inc. is founded in 2005 with focus on providing quality and cost-effective service in the area of ERP application (SAP) technical support, hosting and implementation/upgrade/migration proj
Job Listings
We are in open beta version of website, please let us know if any issues, at: info(at)indigojobs.in