GURUGRAM · FULLTIME
Senior SQL DBA & Reporting Analyst
Oculusit
Gurugram · onsite · Posted 58d ago
Sourced from
Undisclosed10–15 yrsfulltimeGurugram
About a minute. You'll make an account on the way through.
agent · working
- Read this posting0.8s
- Found the form on Naukri · 8 questions to answer1.8s
- Decided the answers for all of them3.1s
- Tailor your résumé to this role
- Waiting for you
Section · 01
About this 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:
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.
Sourced from naukri
Section · 02
Skills
AutomationAzure DevopsCognoscloud servicesclusteringamazon web servicesAzure SQLAWS RDSAnalyticsApplication SupportcloudCloud MigrationBi PublisherAzure Data FactoryAdministrationcomplianceMicrosoft AzureBusiness Intelligence