Job
Description
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 SQL Server installation, configuration, and maintenance. Backup/restore strategies, log shipping, and disaster recovery. Automating data loads (SSIS, PowerShell, or T-SQL scripting).  Strong problem-solving skills for troubleshooting database issues. Responsibilities  SQL Server Management & Maintenance Administer, monitor, and optimize on-premises Microsoft SQL Server Perform installations, upgrades, patches, and security hardening. Troubleshoot and resolve database performance issues (blocking, deadlocks, slow queries). Manage database backups, restores, and disaster recovery plans.  Automation & Data Integration Automate daily data loads into SQL Server (via T-SQL, PowerShell, or SSIS). Schedule and maintain SQL Agent Jobs for ETL processes. Optimize stored procedures, functions, and triggers for efficient Power BI data retrieval. (Bonus) Experience with Power Automate for workflow automation. 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. Security & Compliance  Manage user permissions, roles, and security for SQL databases.  Ensure compliance with data governance policies (access control, auditing). 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 . Show more Show less
