Database Engineer

Position: Database Engineer

Department: Digital Transformation (DX)

Technology Environment: Microsoft .NET ecosystem, SQL, APIs, Cloud/On-Premises/Offline Systems

Role Purpose

We are looking for a Database Engineer responsible for designing and maintaining the data foundation supporting XRD and our wider enterprise digital ecosystem. The engineer will ensure that data generated across these systems is structured, secure, scalable and analytics ready.

Key Responsibilities

1. Design enterprise relational database architecture.
2. Develop database schemas, tables, views, stored procedures and functions.
3. Design normalized transactional databases and analytics-oriented data structures.
4. Optimize SQL queries and application database performance.
5. Design indexing and partitioning strategies.
6. Monitor query performance and database health.
7. Implement backup, recovery and disaster-recovery mechanisms.
8. Design data archival and retention strategies.
9. Implement database security, access controls and encryption.
10. Support Role-Based Access Control (RBAC) requirements.
11. Work with backend developers on ORM/database interaction optimization.
12. Support APIs and integration services.
13. Design master-data structures for employees, organizations, roles, skills, competencies, training and assessments.
14. Build ETL/ELT pipelines for analytics.
15. Maintain data dictionaries and metadata.
16. Ensure data quality and referential integrity.
17. Support migration of customer data from existing systems.
18. Support multi-tenant SaaS architecture as well as customer-specific deployments.
19. Support cloud, on-premises and offline deployment architectures where required.

Data Architecture Responsibilities

The candidate should help establish a common data modelling connecting varied industry requirements for CHRP-INDIA's products. The architecture should enable historical analysis and future AI/ML applications.

Required Skills

• 3–5 years of database engineering experience.
• Strong Microsoft SQL Server experience.
• Advanced T-SQL.
• Database design and normalization.
• Query optimization and performance tuning.
• Indexing and partitioning.
• ETL/ELT concepts.
• Data warehousing fundamentals.
• Backup/recovery and high availability.
• Data security and access-control principles.
• Experience supporting .NET enterprise applications.

Preferred Skills

PostgreSQL, Azure SQL, Data Lakes, Redis, NoSQL, Microsoft Fabric/Azure Data Factory or equivalent, Power BI data models, Cloud databases, Data warehouse/lakehouse architecture.

Key Deliverables

Enterprise Data Model, Database Architecture, Data Dictionary, Optimized Schemas, ETL/ELT Pipelines, Data Warehouse Structures, Backup/DR Strategy, Data Quality Framework, Database Performance Monitoring