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