Job Title:  Senior Consultant | Database Administrator | Delhi | Operations, Industry & Domain Solutions | DigiG

Job Description  

Job Title: Database Architect (DBA)

Location: Delhi

Experience Level: 8+ Years

-       Experience in database architecture, design and administration across relational and non-relational systems, ETL pipelines, data governance frameworks and integration with heterogeneous Government and third-party data sources.

-       Demonstrated experience in developing master data management systems, exporter–importer datasets, data validation and enrichment protocols, and building scalable, secure database environments supporting analytics, dashboards and AI/ML-driven matchmaking, scoring and prioritisation workflows.

Education Qualifications: BE/B.Tech/MCA/M.Tech

Job Role

8 years in database design, optimization, backup strategies, security, and administration of databases like MySQL, PostgreSQL, Oracle, or MS SQL Server.

Responsibilities:

Looking for highly skilled Database Architect (DBA) with deep expertise in PostgreSQL to design, manage, and optimize our database infrastructure. The ideal candidate will be responsible for ensuring high availability, performance, and scalability of PostgreSQL databases. This role involves working closely with development teams to design database solutions that meet both application requirements and best practices for data management and security.

Key Responsibilities:

·       Design, implement, and manage high-performance, scalable PostgreSQL database systems.

·       Optimize database performance through indexing, query tuning, and other optimization techniques.

·       Ensure data integrity, security, and disaster recovery through effective backup strategies, replication, and failover mechanisms.

·       Monitor database performance and proactively resolve performance bottlenecks.

·       Implement best practices for database architecture, including partitioning, sharing, and clustering.

·       Perform regular database health checks, patching, and version upgrades.

·       Manage users, roles, and database access permissions to ensure data security.

·       Troubleshoot database issues and provide timely resolution.

·       Stay updated with the latest PostgreSQL features and advancements to improve database performance and scalability

·       Proven experience as a Database Architect or DBA, with expertise in PostgreSQL.

·       Strong proficiency in designing and optimizing PostgreSQL databases.

·       Experience with database replication, partitioning, clustering, and sharding.

·       Proficiency in query tuning, performance optimization, and indexing strategies.

·       Strong knowledge of SQL and PostgreSQL-specific features such as PL/pgSQL, triggers, and stored procedures.

·       Experience with PostgreSQL backup and restore processes, including logical and physical backups.

·       Knowledge of database monitoring tools and techniques

·       Experience with database migration strategies and tools