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

-Replic

📌 Senior SQL DBA (Gurugram)
🏢 OculusIT
📍 Gurugram