Job Title:  T&T | EAID | Engineering | Manager | SQL | Bangalore

The Team

Deloitte’s Technology & Transformation practice can help you uncover and unlock the value buried deep inside vast amounts of data. Our global network provides strategic guidance and implementation services to help companies manage data from disparate sources and convert it into accurate, actionable information that can support fact-driven decision-making and generate an insight-driven advantage. Our practice addresses the continuum of opportunities in business intelligence & visualization, data management, performance management and next-generation analytics and technologies, including big data, cloud, cognitive and machine learning.     

Our Work Profile

We are seeking a PostgreSQL Database Engineer / Architect with deep expertise in designing, optimizing, and operating high-performance databases for industrial telemetry, machine data, and large-scale event-driven systems across mining and manufacturing domains.

The role involves architecting scalable PostgreSQL solutions for time-series, document-style, and normalized workloads, ensuring high ingest performance, strong data integrity, and enterprise-grade availability across on-prem and AWS RDS environments.

The ideal candidate will work closely with platform engineers, SREs, and application developers to build resilient, secure, and high-performing data systems that support real-time analytics, predictive maintenance, and operational intelligence.

This role sits at the intersection of database engineering, performance optimization, and platform reliability, ensuring databases are engineered for scale, observability, and operational excellence.

Your Work Profile

The PostgreSQL Developer / Database Architect is responsible for designing, optimizing, and operating large-scale PostgreSQL environments supporting high-volume industrial telemetry systems.

This role serves as the database authority and performance owner, ensuring that schemas, queries, and infrastructure are optimized for throughput, reliability, and scalability while enabling seamless integration with application and platform teams.

The role also includes ownership of data modeling decisions, performance tuning, high availability design, and automation of database operations across hybrid cloud environments.

Key Responsibilities

Database Architecture & Design

• Design scalable database schemas for machine telemetry, logs, events, and sensor data.
• Architect time-series, normalized, and denormalized models based on workload patterns.
• Implement advanced PostgreSQL features such as JSON/JSONB, partitioning, window functions, and extensions.
• Design ingestion-optimized data pipelines for high-volume streaming data.

Performance Engineering & Query Optimization

• Tune PostgreSQL for high ingest workloads (WAL, checkpoints, memory, I/O, vacuum).
• Analyze query plans using EXPLAIN / EXPLAIN ANALYZE and optimize execution paths.
• Write and optimize high-performance SQL and PL/pgSQL procedures.
• Review ORM-generated queries for performance improvements.

Indexing & Data Access Optimization

• Design indexing strategies using B-tree, GIN, GiST, BRIN, Hash indexes.
• Implement covering, partial, and expression indexes.
• Monitor and manage table/index bloat and reindexing strategies.

Partitioning & Large Dataset Management

• Implement range, list, and hash partitioning strategies.
• Design partition pruning-aware query patterns.
• Define data retention and archival strategies for large-scale datasets.

Advanced PostgreSQL Capabilities

• Implement Full Text Search (FTS) for logs and unstructured data.
• Use PostGIS for spatial analytics, asset tracking, and geofencing.
• Leverage pgvector for anomaly detection and predictive maintenance use cases.

High Availability, Backup & Recovery

• Manage backup and restore strategies (PITR, pg_dump, physical backups).
• Design and test disaster recovery and failover mechanisms.
• Implement replication strategies and high availability architectures.
• Manage connection pooling using PgBouncer / RDS Proxy.

Observability & Performance Monitoring

• Establish database observability using:
  • pg_stat_statements
  • auto_explain
  • Prometheus / Grafana
  • AWS RDS Performance Insights
• Define and monitor SLOs for latency, throughput, replication lag, and bloat.

Automation & DevOps Integration

• Automate database operations using Ansible, Terraform, pg_cron.
• Enable CI/CD for schema changes using Flyway / Liquibase.
• Support zero-downtime schema migrations and deployment strategies.

Security & Compliance

• Implement role-based access control and least privilege principles.
• Enforce encryption, auditing (pgAudit), and compliance standards.
• Manage user access, permissions, and audit trails.

Collaboration & Support

• Work closely with SRE, platform engineering, and application teams.
• Participate in architecture reviews and capacity planning.
• Support production troubleshooting and incident resolution.
• Provide guidance on PostgreSQL best practices.

Database Design & Engineering

• Build scalable relational models aligned with application and business needs.
• Use advanced PostgreSQL features including:
  • Partitioning
  • Materialized views
  • Triggers and stored procedures
• Ensure schema designs support high concurrency and ingestion rates.

Maintenance & Lifecycle Management

• Automate routine maintenance tasks: vacuuming, indexing, backups.
• Manage version upgrades, patching, and performance tuning cycles.
• Ensure long-term database health and stability.

Troubleshooting & Production Support

• Diagnose and resolve database performance and reliability issues.
• Investigate query slowdowns, locking, and resource bottlenecks.
• Document incidents, resolutions, and preventive measures.

Required Experience

• Bachelor’s or Master’s degree in Computer Science, IT, or related field.
• 5+ years of database engineering/administration experience
• Minimum 3+ years in PostgreSQL enterprise environments
• Experience with large-scale, high-availability systems
• Strong exposure to cloud (AWS RDS / Azure PostgreSQL) and on-prem deployments
• Deep understanding of PostgreSQL internals: MVCC, WAL, vacuum, planner

Essential Skills

Technical Skills

• Expert-level PostgreSQL knowledge (performance tuning, internals)
• Strong SQL development and optimization skills
• Experience with partitioning and advanced indexing strategies
• Knowledge of FTS, PostGIS, pgvector
• Experience with replication, backups, PITR, DR strategies
• Cloud database experience (AWS RDS / Azure Database for PostgreSQL)
• Linux fundamentals and scripting (Python / Bash / Go)
• Experience with automation tools (Ansible, Terraform, pg_cron)

Operational Skills

• Database monitoring and profiling tools (pgAdmin, Datadog, New Relic)
• Performance tuning and capacity planning
• Backup/restore and disaster recovery management
• Security and access control management

Soft Skills

• Strong analytical and problem-solving ability
• Excellent communication and documentation skills
• Ability to work in cross-functional teams (SRE, platform, dev teams)
• High attention to detail and data integrity mindset
• Continuous learning and adaptability

Preferred / Bonus Skills

• PostgreSQL advanced features (logical replication, PostGIS, partitioning)
• CI/CD pipeline experience for database deployments
• Kubernetes / Docker exposure in data platforms
• Kafka / CDC tools (Debezium, logical replication streaming)
• Certifications in PostgreSQL or cloud platforms

Educational Qualifications

• Graduate degree (Computer Science / IT or equivalent)

Location and Way of Working

• Base location: Chennai