SQL DBA & Reporting Analyst
Gurugram, India · Full-time
- Posted 5d ago
- From OculusIT’s careers page
- Location
- Gurugram, India
- Type
- Full-time
- Level
- Senior
- Experience
- 10+ years
- Department
- Information Technology
Apply on OculusIT’s site
Opens the listing on oculusit.keka.com
Let the right jobs find you
In your inbox every Wednesday and SaturdayPersonalised suggestions from verified career pages, matched to your role, location, level and skills.
About the role
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 SSRS, Power BI, Cognos, Tableau, Oracle BI Publisher, and Argos 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
- Microsoft SQL Server (2016–2022)
- T-SQL, Query Optimization
- Always On Availability Groups
- Clustering
- Replication
- Log Shipping
- Backup & Recovery
- Performance Tuning
- Informatica PowerCenter
- Informatica Intelligent Cloud Services (IICS)
- SQL Server Integration Services (SSIS)
- Azure Data Factory (Preferred)
- SSRS
- Power BI
- Cognos Analytics
- Tableau
- Oracle BI Publisher
- Argos Reporting
- Azure SQL
- AWS RDS
- PowerShell
- Python
- Git / Azure DevOps
- 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.
Skills they ask for
Pick one to see other roles that ask for it.
About OculusIT
Higher education IT managed servicesOculusIT provides IT outsourcing and managed services to colleges and universities.
See all 18 roles at OculusITMore roles at OculusIT
See all 18- Network EngineerGurugram · PrincipalInformation Technology · PrincipalGurugram, India4d
- Penetration TesterGurugram · Entry Level · HybridInformation Technology · Entry Level · HybridGurugram, India5d
- Penetration TesterGurugram · Senior · RemoteInformation Technology · Senior · RemoteGurugram, India5d
- Marketing Content & Multimedia ExecutiveGurugram · RemoteMarketing · RemoteGurugram, India5d
Share this role
Let the right jobs find you
In your inbox every Wednesday and SaturdayPersonalised suggestions from verified career pages, matched to your role, location, level and skills.