Database Administrator

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.** - **SLA Adjustments: Negotiating lower Recovery Time Objectives (RTO) or Recovery Point Objectives (RPO) due to system limits.** **5. DIMENSIONS** **(Key numerical data which will reflect the scope and scale of activities concerning this job)** **Financial Dimensions (FY 20)** **(These should be quantifiable numerical amounts)** **** **** **Other Dimensions (FY 19)** **(Significant volume dimensions associated with the job)** **Total Team Size:** **Number of Direct Reports:** **Number of Outsourced employees:** **< Other volume dimensions e.g. No. of plants overseen / No. of vendors managed / No. of clients etc. >** **6. SKILLS AND KNOWLEDGE** **(Minimum acceptable proficiency for this job which best indicates the education and/or experience requirements of this job and not the incumbent)** **Educational Qualifications** **a)Qualifications** **Minimum Qualification required: Bachelor’s degree in computer science, Information Technology, or a related field.** **Strong knowledge of cloud computing platforms, such as AWS, OCI, or Google Cloud.** **Database Systems: Mastery of MySQL and PostgreSQL internals including storage and memory management.** **Scripting: Proficiency in Shell (Bash) or Python to automate routine tasks and database deployments.** **Infrastructure: Experience with Linux server administration, networking, and cloud services (e.g., AWS Aurora, Google Cloud SQL Database for PostgreSQL/MySQL).** **Advanced Concepts: Knowledge of replication, sharding, and partitioning for large-scale production database** **Industry certification is plus.** **b)Work Experience** **Overall, 3-5 years** **c)Other soft skills/competencies –** **Efficient troubleshooting and problem-solving skills.** **Ability to work effectively in a team environment and collaborate with cross-functional teams.** **Strong communication skills with the ability to convey technical concepts to non-technical stakeholders.** Updated Date 27-07-2026 Job ID Job\\_441 Department Technology - Infrastructure Location Sector-142, Noida, Noida, Uttar Pradesh, India Employee Type Full Time