15h Left Database Administrator

About the Company

CASHPOR Micro Credit is a Not-for-Profit Company incorporated under Section 25 of the Companies Act, 1+56 and also registered with the Reserve Bank of India as NBFC-MFI.

Our organization has been consistently providing microfinance services along with health and education services to its rural BPL women members in Eastern Uttar Pradesh, Madhya Pradesh/Bundelkhand, Chhattisgarh, Jharkhand, Odisha, and Bihar through its 780 branches.

We form Joint Liability Groups (JLGs) and provide microfinance loans out of our owned funds and under Business Correspondent (BC) arrangements with IndusInd Bank, IDBI Bank, ICICI Bank, Kotak Mahindra Bank, and under partnership with SIDBI as implementing partner under PRAYAS Scheme.
About the Role

The Database Administrator will be responsible for managing MongoDB and RDBMS environments, ensuring high availability, performance optimization, and disaster recovery.
Job Description:
• Database Management:
• Install, configure, and maintain MongoDB environments (standalone, replica sets, and sharded clusters).
• Monitor database performance, implement tuning strategies, and manage storage systems to optimize resource utilization.
• Use Replication, Mirroring, and Log-shipping to migrate data across servers.
• Manage database backup, transactional log backups, and recovery, as well as disaster recovery planning, in coordination with other IT officers.
• Plan and execute database backups, restores, and disaster recovery strategies.
• Design and Optimization:
• Collaborate with development teams to design and implement efficient and scalable database solutions.
• Optimize MongoDB queries and indexing to improve performance.
• Perform schema design and data modeling to meet application requirements.
• Design and development of databases, tables, and views in RDBMS like MS SQL Server as per RDBMS ACID rules, read/write operations, and NoSQL database MongoDB.
• Monitoring and Troubleshooting:
• Use monitoring tools to track database health, performance, and availability.
• Investigate and resolve database issues, including slow queries, connection problems, and replication delays.
• Monitor the performance of database queries, jobs, and database server performance. Report, fix, and optimize any issues in security, and performance of database objects as and when required.
• Proactively monitor SQL Server health i.e. maintenance tasks, troubleshoot failed processes, and address issues as soon as possible.

Qualifications:

Bachelor's or Master's degree in Computer Science or related fields with a minimum of 8 years of experience in DBA profile.
Pay Range and Compensation Package:

Salary negotiable based on experience.