SQL Server Database Analyst

TekWissen; United States; Remote; USD 110,000 - 150,000; Full time

Job summary

TekWissen is seeking a Senior SQL Server Database Analyst to join a client engaged in IT and business services. The role involves collaborating with application teams to optimize performance, analyze query issues, and provide tuning recommendations across on-prem and Azure SQL environments.

The ideal candidate has 8+ years in enterprise SQL Server environments, strong T-SQL skills, and experience with SSIS/SSAS/SSRS and Power BI. Remote work is supported for this full-time opportunity.

Qualifications

• 8+ years of experience in enterprise SQL Server environments.
• Expertise in T-SQL development, stored procedures, and query tuning.
• Experience with SSIS/SSAS/SSRS and Power BI.

Responsibilities

• Collaborate with application teams to optimize SQL Server performance.
• Develop and optimize T-SQL, stored procedures and queries.
• Coordinate with managed service teams for patching and monitoring.
• Support both on-prem and Azure SQL; contribute to DR planning.
• Write automation scripts for health monitoring and diagnostics.

Skills

T-SQL development

Query optimization

Performance tuning

Data partitioning

Automation scripting

Tools

SSIS

SSAS

SSRS

PowerShell

Python

Azure SQL

AWS

Always On

Job description

Overview:

TekWissen is a global workforce management provider throughout India and many other countries in the world.The below job opportunity is to one of our clients who is a part of a trusted global innovator of IT and business services headquartered in Tokyo. We help clients transform through consulting, industry solutions, business process services, IT modernization and managed services. This client enables us to move confidently into the digital future. This client committed to Long Term success and combine global reach with local client attention to serve them in over 50 Countries.

Position: SQL Server Database Analyst

Location: Bangalore/ Chennai/ Noida/ Gurgaon/ Pune

Work Type: Remote

Job Type: Full Time

Job Description:

• Senior-level SQL Server Database Analyst with 8+ years of experience in enterprise environments
• Primary focus on collaborating with application teams to enhance performance, analyze query issues, and provide tuning recommendations
• Skilled in T-SQL development, including writing and optimizing stored procedures, queries, and interpreting execution plans
• Works in tandem with managed service teams for patching, monitoring, and operational execution, while owning advanced troubleshooting and escalation
• Familiar with SQL Server administration fundamentals including backups, patching, restores.
• Business Intelligence and ETL technologies - SSIS, SSAS, SSRS, PBI.
• Comfortable supporting both on-prem and Azure SQL environments (IaaS/PaaS), with growing exposure to cloud-based DR models
• Proficient in Azure SQL, AWS, Cloud PaaS operations, including deployment, scaling, monitoring, and diagnostics in a cloud-native architecture.
• Able to write basic automation scripts using PowerShell, Python and support database health monitoring
• Awareness of security and compliance practices, including role-based access, encryption, and audit trails
• Effective communicator, team-oriented, and comfortable partnering across development and infrastructure teams
• Aligned with the U.S. Eastern Time Zone and available during standard business hour
• SQL Server technologies for HA/BCP - Microsoft SQL Server, High Availability (HA), Disaster Recovery (DR)/Business Continuity Planning (BCP), Always On Availability Groups (AG), and Database Availability Groups (DAG).
• Large dataset management - Design and implement table partitioning strategies to improve performance, maintainability, and data lifecycle management. Develop data archival, retention, purging, and partition-switching solutions for large-volume databases.

TekWissen Group is an equal opportunity employer supporting workforce diversity