Sql Database Administrator

About Us

SahiBandhu is India's leading gold loan platform backed by The Manipal Group. SahiBandhu offers quick and secure gold loans at affordable interest rates, right at customer's doorstep in collaboration with leading banks in India.

Job Summary

We are seeking a skilled Database Administrator (DBA) to manage our on-premise SQL Server infrastructure . The ideal candidate will ensure database performance, handle capacity planning, support analytics requirements, and maintain seamless integrations between databases and Power BI for business reporting.

Key Responsibilities

1. Database Administration:
• Install, configure, and maintain SQL Server databases in an on-premise environment.
• Perform routine health checks, maintenance, and troubleshooting to ensure database stability.
• Manage database security, including user roles, permissions, and data encryption.
2. Capacity Planning & Performance Tuning:
• Monitor and optimize database performance through query tuning, indexing, and server configuration.
• Plan for future database capacity to accommodate business growth.
3. Backup, Recovery, and High Availability:
• Develop and implement comprehensive backup and recovery strategies.
• Configure and maintain High Availability (HA) and Disaster Recovery (DR) solutions such as Always On, log shipping, and replication.
4. Automation and Scripting:
• Automate routine DBA tasks using T-SQL, PowerShell, or similar scripting tools.
• Streamline Power BI refresh workflows and database integration processes.
5. Monitoring and Troubleshooting:
• Implement monitoring tools to track database and Power BI performance.
• Troubleshoot and resolve issues related to data pipelines, queries, and reporting.
6. Collaboration with Teams:
• Work closely with data analysts, developers, and business stakeholders to understand reporting requirements.
• Support cross-functional teams in designing scalable data architectures for reporting.
7. Documentation and Reporting:
• Maintain comprehensive documentation of database configurations, processes, Power BI workflows, and dashboards.
• Generate periodic reports on database performance, capacity, and Power BI usage metrics.

Required Qualifications

• 10+ years of experience as a Database Administrator managing SQL Server in on-premise environments.
• Strong understanding of database architecture, indexing, and query optimization.
• Hands-on experience with High Availability and Disaster Recovery solutions.
• Proficiency in writing complex T-SQL queries and scripts.
• Knowledge of Power BI integration with SQL Server and other data sources.
• Familiarity with monitoring tools like SolarWinds, Redgate, or similar.
• Ability to automate processes using PowerShell or similar scripting languages.

Preferred Qualifications

• Experience with performance tuning for Power BI reports and SQL queries.
• Familiarity with SQL Server Reporting Services (SSRS) or Integration Services (SSIS).
• Certifications such as Microsoft Certified: Data Analyst Associate or SQL Server DBA.
• Proven expertise in Power BI administration, including dashboard creation and optimization.

Power BI Maintenance and Optimization:

• Design, implement, and maintain Power BI dashboards and reports for business needs.
• Connect Power BI with SQL databases, optimize data models, and ensure efficient query execution.
• Manage and monitor Power BI datasets, gateways, and refresh schedules.