Sr Analyst - SQL Administrator (Chennai)

Sr Analyst - SQL Administrator (Chennai)

20 Nov
|
enGen Global
|
Chennai

20 Nov

enGen Global

Chennai

SQL Admin Job Summary:

- We are seeking a skilled and proactive SQL Administrator with 4+ years of hands-on experience to manage, optimize, and support our critical database environments. In this role, you will be responsible for day-to-day database administration, developing and maintaining SSIS packages, SSRS reports, and Power BI applications, and resolving production support issues. The candidate should be a strong problem-solver who thrives in a fast-paced environment and ensures high availability and performance of our data systems.

Key Responsibilities:

- Database Administration & Performance:
- Manage, monitor, and maintain Microsoft SQL Server instances.
- Stored procedure development, maintece, and optimization to ensure high-performing data operations.
- Proactively identify bottlenecks, query inefficiencies, blocking, and deadlocking issues, implementing timely fixes and indexing strategies.
- Perform database performance tuning, index optimization, query tuning, and troubleshoot blocking/deadlocking issues.
- Implement and test backup, restore, and disaster recovery strategies.
- Manage database security, user permissions, and access controls.
- Database Management & Protection: Implement automated database maintece plansincluding daily full, differential, and transaction log backupswhile monitoring slow-running queries, building efficient indexes, and tuning server memory parameters to guarantee data integrity, recovery, and peak performance.
- Secure Infrastructure Integration: Establish secure cross-platform communications by configuring IIS Application Pools to use Windows Authentication over hardcoded SQL logins,



while managing multi-tier system architectures (single-server constraints or dual-server DMZ/firewall setups) to protect data assets.
- ETL & Reporting (SSIS & SSRS):
- Design, develop, deploy, and troubleshoot complex SSIS packages for data migration and ETL processes.
- Create, maintain, and optimize SSRS reports to meet business reporting requirements.
- Business Intelligence (Power BI):
- Support and administer the Power BI environment, including managing data gateways, scheduled refreshes, and workspace security.
- Collaborate with stakeholders to troubleshoot Power BI report performance and dataset issues.
- Produaction Support:
- Act as the primary point of contact for database-related incidents, triage alerts, and resolve production support issues in a timely manner.
- Perform root cause analysis (RCA) for recurring production bugs and implement preventive measures.

Required Qualifications & Skills:

- Bachelors degree in Computer Science, Information Technology, or a related field.
- 4+ years of professional experience as a SQL Server DBA / SQL Administrator.
- Strong expertise in T-SQL, writing complex stored procedures, triggers, functions, and views.
- Hands-on experience with SSIS (Integration Services) and SSRS (Reporting Services) development and deployment.
- Working knowledge of Power BI (publishing, gateways, dataset management, and basic troubleshooting).
- Proven experience in Production Support, incident management, and handling high-pressure outage situations.
- Solid understanding of database backup/recovery models, high availability (AlwaysOn, Clustering, Replication).

Soft Skills:

- Strong analytical and troubleshooting skills.
- Excellent verbal and written communication skills.
- Ability to work independently as well as collaboratively in a team setting.

📌 Sr Analyst - SQL Administrator (Chennai)
🏢 enGen Global
📍 Chennai

Reply to this offer

Impress this employer describing Your skills and abilities, fill out the form below and leave Your personal touch in the presentation letter.

Subscribe to this job alert:

Get the latest job offers by email for: sr analyst - sql administrator (chennai) / chennai