enGen Global logo

Sr Analyst - SQL Administrator

enGen Global

4 - 9 years

Chennai

Posted:7 hours ago

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.

Skills Required

Data migration Database Tuning Data Operations SQL Database Security System Operations Database Backup

Learn the skills this job asks for

Free courses, interview questions and practice for each skill.

Work Mode

Work from Office

Job Type

Full Time

Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific Interview
cta

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

coding practice

Enhance Your Skills

Practice coding challenges to boost your skills

Start Practicing Now
enGen Global logo
enGen Global

RecommendedJobs for You

enGen Global logo
enGen Global logo