Information Technology Support Engineer

Description:

We are looking for a reliable, technically skilled, and dedicated Data Engineer who can take ownership of their responsibilities, work independently, and contribute consistently to ongoing projects. The candidiate should have strong expertise in Microsoft SQL Server, T-SQL, MSBI, Git, DevOps, and CI/CD-based database deployments.

The role involves production OLTP support, SQL performance tuning, application database modernization, ETL development, automated database deployments, and AI-assisted development using Claude Code.

Required Technical Skills

1. SQL Server & Application Integration (Mandatory)

• Strong T-SQL skills, including stored procedures, functions, triggers, views, and complex queries.
• Experience with SQL performance tuning, indexing, execution plans, blocking, and deadlock troubleshooting.
• Ability to debug and optimize SQL queries interacting with C#/.NET Core applications, REST APIs, and Elasticsearch.
• Understanding of OLTP systems, database design, and production troubleshooting.

2. Database DevOps, Git & CI/CD (Mandatory)

• Strong understanding of Git, branching, pull requests, merging, and version control.
• Experience with CI/CD pipelines for SQL Server database deployments.
• Familiarity with Azure DevOps, GitHub Actions, SSDT/DACPAC, or database migration scripts.
• Understanding of schema versioning, automated deployments, release validation, and rollback procedures across Dev, QA, and Production environments.

3. Microsoft BI & ETL

• Hands-on experience with SSIS for ETL development and troubleshooting.
• Familiarity with SSRS, SSAS, data warehousing, and data integration.
• Ability to troubleshoot existing ETL packages and production data pipelines.

4. AI-Assisted Development (Claude Ecosystem)

• Familiarity with Claude Code for SQL development, debugging, code reviews, and automation.
• Understanding of Claude Skills and reusable skill templates for development and DevOps workflows.
• Ability to validate and test AI-generated code.

5. Good to Have

• Basic understanding of cloud technologies.
• Familiarity with Python, GCP (BigQuery/GCS), dbt, or Airflow.
• Experience supporting US-based clients or teams.

Key Responsibilities

• Develop, maintain, troubleshoot, and optimize SQL Server databases and stored procedures.
• Support production OLTP applications and resolve database-related issues involving .NET Core and Elasticsearch.
• Manage database source code using Git and implement CI/CD-based automated deployments.
• Maintain SSIS packages, ETL processes, and existing MSBI solutions.
• Support database modernization, bug fixes, and performance improvements.
• Leverage Claude Code and Claude Skills for development and automation.
• Collaborate with US-based teams and provide regular progress updates and take ownership of their responsibilities, work independently, and contribute consistently to ongoing projects.

Eligibility & Remote Work Requirements

• CS, Software Engineering, IT graduate, or final-year student only with supporting degree certificate or academic transcript.
• Minimum 1 year or plus relevant experience OR substantial hands-on internship/project experience.
• Must reside in Pakistan (Karachi preferred).
• Must be available full-time during 8:00 AM – 6:00 PM US Eastern Time (EST/EDT), which is between 6PM - 4AM Pakistan Standard Time.
• Must have a reliable internet connection of at least 30 Mbps and a suitable remote workspace.
• Must commit exclusively to this long-term contract, without concurrent employment, freelance, or consulting engagements.
• Strong communication, problem-solving, accountability, and independent working skills.