Database Administrator - DMI Housing Finance

Job Description

JOB DESCRIPTION

Role TitleDatabase Administrator

LocationNoida

Company DMI Finance Private Limited

Function/ DepartmentIT -Technology

1. JOB PURPOSE

(Summarize in one statement why the job exists; and how it contributes to the overall objective of the company)

We are looking for Database Administrator (DBA) specializing in MySQL and PostgreSQL who is responsible for the health, security, and performance of an organization’s open-source database systems. This role blends high-level architectural planning with day-to-day maintenance to ensure data remains accessible and protected.

2.PRINCIPAL ACCOUNTABILITIES

(Accountabilities associated with the job)

Administration & Maintenance: Installing, configuring, and upgrading database instances on Linux or cloud platforms like AWS RDS or Google Cloud SQL.

Performance Tuning: Monitoring database health and optimizing queries, indexing, and configurations using tools like EXPLAIN and slow query logs.

Data Security: Implementing user access controls, authentication, and encryption to protect sensitive data.

High Availability & Disaster Recovery: Designing and testing backup/restore procedures and managing replication or clustering to ensure maximum uptime.

Capacity Planning: Forecasting storage and resource needs to ensure the database can scale as data volumes grow.

3.MAJOR CHALLENGES

(Challenges faced on an on-going basis in carrying out the job)

• Performance Bottlenecks: Fixing poorly written queries and managing complex schema updates on live production systems without causing downtime is a daily hurdle.
• Massive Scaling: Handling rapid data growth requires constantly managing complex sharding, partitioning, and resource allocation.
• Balancing the distinct internal behaviors of both MySQL and PostgreSQL requiring deep, specialized knowledge for each system.
• Data Loss Risks: The role carries extreme accountability for protecting data security and ensuring multi-terabyte backups actually work.

4. DECISIONS

(Key decisions which the role needs to escalate to superior)

• Architecture Modifications: Proposing major architectural shifts.
• High-Cost Investments: Approvals for significant budget increases for new enterprise tooling, storage expansion, or cloud infrastructure.
• Extended Maintenance Windows: Scheduling critical database upgrades or migrations that require intentional, long-term application downtime.
• Active Data Breaches: Escalating immediate security compromises, data leaks, or unresolvable ransomware attacks directly to leadership.
• Data Retention Policies: Changing corporate data compliance rules, purging historical records, or modifying legal archival periods.