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.
- Solid experience with enterprise reporting and BI platforms.
- Experience supporting Higher Education ERP systems is highly preferred.

📌 Lead SQL DBA– Enterprise Data Platforms & Reporting (India)
🏢 OcIT
📍 India