Jobs

Interviews
Job Alerts
Tools

Upskill and Grow with AI

Mock Interview Practice interviews in realistic simulations

Coding Practice Improve your coding skills with challenges

Certification Earn certifications to validate your skills

AI Learning Get trained with AI expert sessions

Career Path AI insights for smarter career decisions

AI Job Match Score AI-Powered Job Match Against Your Resume and Optimize Your Resume

Career Tools and Resources

Resume Builder Build Professional Resume with Ease

ATS Friendliness Check Check Resume Friendliness for Applicant Tracking Systems

Auto Apply Apply to hundreds of jobs on any platform effortlessly

Co-Pilot (Chrome Extension) Your AI Assistant for Seamless Browsing Efficiency

Interview Questions Streamline interviews with ready-to-use questions

Salaries Discover market-driven salary insights across skillsets and geographies

Companies Explore leading companies actively hiring talent
For Employers

Home
>
Jobs in hyderābād
>
Winfo Solutions
>
Senior Consultant

Senior Consultant

Winfo Solutions

0 years

3 - 8 Lacs

hyderābād

Posted:1 day ago| Platform: GlassDoor logo

Apply

Skills Required

data postgresql integrity scalability security database architecture design logical normalization denormalization query consistency storage indexing management strategies stability encryption backup restore automate restoration rollback checks archiving replication failover etl erp crm deduplication mapping integration authentication scheduling collaboration orm support analytics reporting devops deployment monitoring planning sql optimization analyze configuration logic python automation tooling billing fastapi microservices workflow bpmn azure server

Work Mode

On-site

Job Type

Part Time

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.

Key Responsibilities

1. Database Architecture & Data Modeling

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.

Required Technical Competencies

Core Skills

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.

Good-to-Have Qualifications

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.

Why Join Us?

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.

Mock Interview

Practice Video Interview with JobPe AI

Start DevOps Interview

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

Job Application AI Bot

Apply to 20+ Portals in one click

Download Now

Download the Mobile App

Instantly access job listings, apply easily, and track applications.

Enhance Your Python Skills

Practice Python coding challenges to boost your skills

Start Practicing Python Now

Winfo Solutions

Login to

Please Verify Your Phone or Email

Confirm Action

Senior Consultant