Sr Analyst - SQL Administrator

enGen Global

Chennai

On-site

INR 900,000 - 1,700,000

Full time

3 days ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

enGen Global is seeking a skilled SQL Administrator with 4+ years of hands-on experience to manage, optimize, and support our critical database environments. You will handle day-to-day administration, SSIS/SSRS development, and Power BI applications, ensuring high availability and performance in a fast-paced setting.

The role requires strong problem-solving abilities, production support expertise, and collaboration with stakeholders to maintain data integrity and security across systems.

Qualifications

  • 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.
  • Experience in Production Support, incident management, and handling high-pressure outage situations.

Responsibilities

  • 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: automate maintenance with daily full/diff/log backups, monitor slow queries, build indexes, optimize memory.
  • Secure infrastructure integration: configure IIS App Pools to use Windows Authentication and multi-tier architectures.

Skills

T-SQL
Stored procedures
Query optimization
SSIS
SSRS
Power BI
Performance tuning
Production support

Education

Bachelors degree in Computer Science, Information Technology, or a related field

Tools

SSIS
SSRS
Power BI
SQL Server

Job description

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 environment.
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

SQL DBA
SQL DBA

Staples India • Chennai District

On-site
INR 800,000 - 1,200,000
MS SQL Database Administrator
MS SQL Database Administrator

SmartSoft India Solutions Pvt. Ltd. • Hyderabad

On-site
INR 600,000 - 1,200,000
SQL Server Administrator (4-6)
SQL Server Administrator (4-6)

Infosys • Bengaluru

On-site
INR 1,200,000 - 1,800,000
SQL Database Developer
SQL Database Developer

FactEntry • Tamil Nadu

On-site
INR 800,000 - 1,200,000
Senior SQL Database Administrator
Senior SQL Database Administrator

Remote Software Solutions Pvt. Ltd. • Goa

On-site
INR 800,000 - 1,200,000
Senior Sql Engineer
Senior Sql Engineer

Quloi • Pune District

On-site
INR 1,500,000 - 2,100,000
Database Management Administration
Database Management Administration

IQVIA Inc • Bengaluru

Hybrid
INR 3,000,000 - 6,000,000
SQL Database Administrator
SQL Database Administrator

Volto Consulting • Dadri

On-site
INR 700,000 - 1,100,000
Database Administrator (Microsoft SQL Server)
Database Administrator (Microsoft SQL Server)

PepsiCo Inc. • Hyderabad

On-site
INR 2,500,000 - 4,200,000
.NET SQL Database Developer (DBA & ETL)
.NET SQL Database Developer (DBA & ETL)

smartData • India

On-site
INR 1,000,000 - 1,800,000