Senior SQL DBA & Reporting Analyst

Key Responsibilities

Enterprise Database Administration

-Administer and support enterprise SQL Server environments (SQL Server 2016-2022).

-Manage installation, configuration, patching, upgrades, migrations, and capacity planning.

-Implement High Availability (Always On AG, Clustering, Replication, Log Shipping) and Disaster Recovery solutions.

-Perform database performance tuning, optimization, monitoring, and health assessments.

-Ensure database security, backup, recovery, and compliance with enterprise standards.

ETL & Data Integration

-Design, develop, and support ETL solutions using Informatica PowerCenter, Informatica IICS, and SSIS.

-Develop scalable data pipelines, source-to-target mappings, and data quality processes.

-Support enterprise data warehouse and ERP integration initiatives.

Reporting & Business Intelligence

-Develop and optimize enterprise reports, dashboards, and analytics using:

oSSRS

oPower BI

oCognos

oTableau

oOracle BI Publisher

oArgos Reporting

-Optimize complex SQL queries and reporting databases for high-performance analytics.

ERP & Application Support

-Support SQL databases for Ellucian Colleague, Jenzabar.

-Troubleshoot database, integration, ETL, and reporting issues in production environments.

-Support ERP upgrades, migrations, and data conversion projects.

Cloud & Automation

-Support Azure SQL, AWS RDS, and hybrid database environments.

-Automate administrative tasks using T-SQL, PowerShell, Python, and SQL Agent.

-Participate in database modernization and cloud migration initiatives.

Leadership

-Provide L3/L4 production support and technical leadership.

-Mentor junior DBAs and conduct technical reviews.

-Develop database standards, SOPs, and operational best practices.

-Collaborate with Infrastructure, Cloud, Security, Development, and Product teams.

Required Technical Skills

Database

-Microsoft SQL Server (2016-2022)

-T-SQL, Query Optimization

-Always On Availability Groups

-Clustering

-Replication

-Log Shipping

-Backup & Recovery

-Performance Tuning

ETL & Data Integration

-Informatica PowerCenter

-Informatica Intelligent Cloud Services (IICS)

-SQL Server Integration Services (SSIS)

-Azure Data Factory (Preferred)

Reporting & BI

-SSRS

-Power BI

-Cognos Analytics

-Tableau

-Oracle BI Publisher

-Argos Reporting

Cloud & Automation

-Azure SQL

-AWS RDS

-PowerShell

-Python

-Git / Azure DevOps

Monitoring Tools

-SQL Profiler

-Extended Events

-Query Store

-Redgate SQL Monitor

-SolarWinds DPA

Experience

-10-15 years of SQL Server Database Administration.

-5+ years supporting enterprise production environments.

-3+ years of Informatica PowerCenter/IICS experience.

-Strong experience with enterprise reporting and BI platforms.

-Experience supporting Higher Education ERP systems is highly preferred.

Disclaimer: This job description has been sourced from a public domain and may have been modified by Naukri.com to improve clarity for our users. We encourage job seekers to verify all details directly with the employer via their official channels before applying.