Job Description

Role : SQL Server Database Administrator (On-Premises Server)

We are looking for a highly skilled SQL Server Database Administrator (DBA) to manage and optimize our on-premises SQL Server environment, which serves as the backbone for our Power BI reporting and analytics. The ideal candidate will be a SQL expert responsible for database maintenance, performance tuning, automation, and ensuring seamless data flow for our BI team. Experience with Power BI, Power Automate, or Power Apps is a strong plus.

Who are we looking for?

 SQL Server DBA (on-premises) – deep expertise in T-SQL, query tuning, and performance optimization.

 Hands-on experience with:

o SQL Server installation, configuration, and maintenance.

o Backup/restore strategies, log shipping, and disaster recovery.

o Automating data loads (SSIS, PowerShell, or T-SQL scripting).

 Strong problem-solving skills for troubleshooting database issues.

Responsibilities:

 SQL Server Management & Maintenance

o Administer, monitor, and optimize on-premises Microsoft SQL Server 

o Perform installations, upgrades, patches, and security hardening.

o Troubleshoot and resolve database performance issues (blocking, deadlocks, slow queries).

o Manage database backups, restores, and disaster recovery plans.

 Automation & Data Integration

o Automate daily data loads into SQL Server (via T-SQL, PowerShell, or SSIS).

o Schedule and maintain SQL Agent Jobs for ETL processes.

o Optimize stored procedures, functions, and triggers for efficient Power BI data retrieval.

o (Bonus) Experience with Power Automate for workflow automation.

3. Power BI Support & Optimization

 Work closely with the  Power BI team  to ensure  optimal database performance  for reports/dashboards.

 Assist in  data modeling, partitioning, and indexing  for better Power BI performance.

 (Bonus) Knowledge of  Power BI DirectQuery vs. Import modes  and optimization strategies.

4. Security & Compliance

 Manage  user permissions, roles, and security  for SQL databases.

 Ensure compliance with  data governance policies  (access control, auditing).

5. Server & Infrastructure Oversight

 Monitor  server health, storage, and capacity planning .

 Coordinate with IT teams for  hardware/OS-level optimizations .

Behavioral Skills :

 Strong Communication Skills

 Ability to work with team members with 100% co-ordination.

 Ability to adopt change and shape as per technology along with change in project.

 Outstanding organizational and time management skills

 Ability to multitask and prioritize daily workload

 Positive attitude with good communication

 Highly motivated and self-learner

Qualification:

 Graduate from any stream

What’s in for you?

 At Mphasis, we promise you the perfect opportunity of building technical excellence, understand business performance and nuances, be abreast with the latest happenings in technology world and enjoy a satisfying work life balance.

 With the current opportunity, you will get to work with the team that has consistently been setting benchmarks for other deliveries in terms of delivery high CSATs, project completion on time and being one of the best teams to work for in the organization.

 You get an open and transparent culture along with freedom to experimentation and innovation

Who are we?

Mphasis is a leading IT solutions provider, offering Applications, Business Process Outsourcing (BPO) and Infrastructure services globally through a combination of technology knowhow, domain and process expertise. Over the years we have left an indelible impression in the IT solutions domain with an impressive clientele and an extensive global presence. The accolades we have been garnering can be attributed to our undeterred focus in delivering quality solutions across verticals that meet the challenging requirements of our esteemed customers. Our integrated solutions offering is aimed at creating value for our customers, helping them in improving their business processes with minimum hassles and capital outlays .