Opening for Database Engineer in BFSI company for the Malad location

Job Description:

Job Description: Database Engineer (2–5 Years Experience)

Position: Database Engineer
Experience: 2–5 Years
Location: Malad HO
Department: IT

Role Overview

We are seeking a skilled Database Engineer with 2–5 years of hands-on experience in managing databases, writing complex queries, creating shell scripts for automation, and developing basic reporting interfaces using PHP and HTML. The role involves monitoring database performance, ensuring data integrity, creating MIS reports, and supporting business teams with timely analytics.

Key Responsibilities

Database Management

• Perform routine database maintenance tasks (backups, restores, monitoring, tuning) if needed.
• Manage database security, user access, and data integrity controls if needed
• Troubleshoot performance issues and improve query efficiency.

Scripting & Automation

• Develop and maintain Shell scripts for automation of backups, monitoring, data loads, and system tasks.
• Implement scheduling using cron jobs and automate repeatable data processing tasks.

Reporting & Application Support

• Design and maintain MIS reports for business, operations, and compliance teams.
• Develop data extraction logic based on business requirements.
• Build and maintain lightweight PHP & HTML pages for internal dashboards or reporting portals.

Data Analysis & Support

• Perform data audits, validations, and reconciliation activities.
• Provide data extracts for internal audits, regulatory reporting, and business analysis.
• Collaborate with cross-functional teams to understand requirements and convert them into technical outputs.

Maintenance & Documentation

• Maintain technical documentation, data dictionaries, SOPs, and change logs.
• Support UAT, migration activities, and production deployments.
• Ensure adherence to security protocols, IT policies, and data governance standards.

Required Technical Skills

Database Skills

• Strong experience with PostgreSQL (queries, indexing, joins, triggers, views, functions).
• Knowledge of database performance tuning and query optimisation.
• Understanding of database replication, backup/restore strategies.

Scripting & Development

• Proficiency in Shell Scripting for automation and system-level tasks.
• Working knowledge of PHP (basic coding, form handling, report generation).
• Ability to create simple HTML/CSS pages for dashboards and internal tools.

Reporting & Analytics

• Experience in MIS report creation, data extraction, and validation.
• Ability to write complex SQL queries for reporting and analytics.
• Understanding of business workflows and data relationships.

Qualifications

• Bachelor’s degree in Engineering, Computer Science, IT, or related field.
• 2–5 years of experience as a Database Engineer / SQL Developer / Data Analyst.
• Experience working in the banking/fintech domain is an added advantage.

 Soft Skills

• Strong analytical and problem-solving skills.
• Ability to work independently with minimal supervision.
• Good communication and documentation skills.
• Collaborative mindset and ability to work with cross-functional teams.