We are seeking an experienced and proactive Database Administrator (DBA) with a strong focus on SQL Server, Azure SQL, Power BI, and SSRS. This role is critical for ensuring the performance, availability, and reliability of enterprise databases and reporting systems. The ideal candidate will have deep expertise in database administration, monitoring, optimization, and supporting business intelligence tools and cloud infrastructure.
Key Responsibilities:
- Install, configure, maintain, and upgrade SQL Server databases in on-prem and Azure environments.
- Manage Azure SQL, Azure Data Factory, and related Azure data services.
- Monitor database health and performance, including tuning queries, indexes, and resource usage.
- Perform regular backups, restorations, disaster recovery planning, and failover testing.
- Manage and administer SSRS environments, deploy reports, and troubleshoot issues.
- Support Power BI by ensuring data connectivity, gateway configurations, and DAX/query optimization.
- Implement and maintain security controls, user roles, and permissions.
- Perform database migrations and automate maintenance tasks.
- Collaborate with developers, analysts, and infrastructure teams to support data needs.
- Ensure compliance with data governance and audit requirements.
Required Skills & Qualifications:
- Bachelor’s degree in Computer Science, Information Systems, or a related field.
- 5+ years of experience as a SQL Server DBA in production environments.
- Strong knowledge of Azure SQL Database, SQL Server 2016+, and T-SQL scripting.
- Proficiency with SSRS and managing report deployment and security.
- Experience supporting Power BI infrastructure (gateways, performance tuning).
- Hands-on experience with Azure data services (e.g., Azure Data Factory, Azure Monitor).
- Expertise in backup/recovery strategies, high availability (HA), and disaster recovery (DR).
- Knowledge of database security, auditing, encryption, and compliance practices.
- Familiarity with tools like SQL Profiler, Extended Events, DMVs, and Performance Monitor