Performance Tuning Lead with SQL

" Key Skills Required

Performance Tuning Lead with SQL, Databricks, Azure Cloud.

Experience tuning queries for both master data hubs and transactional data hubs on cloud infrastructure.

Strong troubleshooting and root cause analysis skills. Ability to work independently under pressure to support a Tier 1 platform.

Experience leading and mentoring junior engineers and developers on best practices for database and application performance.

Primary Activities

Data Platform Support for multiple data sources and destinations.

Monitoring via tools like Datadog and Splunk.

Testing of SQL queries for various applications consuming data from data hubs.

L3 support - TechOps, 3rd party coordination.

Maintaining production systems, deploying code in Production, resolving issues, and leading production troubleshooting calls.

Production monitoring, creating monitoring dashboards, setting up alerts, triaging alerts.

Working with Product Owners and other developers to implement scalable solutions.

Qualification

Bachelor’s degree in Information Technology, Computer Science, or a related field (or equivalent work experience).

Previous experience in a managed services role or IT support (typically 5+ years).

5+ years of software and DevOps development engineering in a Linux environment.

Experience with Azure Cloud, Azure DevOps, AKS.

Experience building and operating high-performance mission critical systems.

Experience using Datadog, Splunk, or other monitoring tools.

Application Services

Provide technical support for business-critical software applications, diagnosing and resolving user issues in a timely manner.

Monitor application performance, resolve technical issues, and perform root cause analysis for recurring problems.

Serve as the primary point of contact for application-related inquiries, working with users to address their needs.

Release & Deployment

Participate in the testing of new or updated applications, ensuring they meet functional requirements and quality standards.

Assist with the release & deployment and rollout of new software versions or updates to users.

Ensure smooth transition and minimal disruption during application changes, including user training and documentation.

Perform enhancements as per requirements and ability to deploy.

Reporting & Management

Collect and analyze data from the applications to generate reports and provide insights to stakeholders.

Monitor application usage and performance metrics to identify trends and potential issues.

Provide recommendations for improving workflows or streamlining processes through better application use.

Work with project managers and customers to ensure the applications meet evolving business requirements.

Update application and architecture documentation as needed.

Soft Skills

Excellent problem-solving and troubleshooting skills.

Strong communication skills, with the ability to explain complex technical concepts to non-technical users.

Customer-oriented, with the ability to work both independently and as part of a team.

Preferred

Experience with IT service management frameworks preferred (e.g., ITIL).

Knowledge of application performance monitoring tools.

Experience with Kafka or another message broker.

Experience creating and running Databricks notebooks.

Experience developing Java based microservices.

Experience developing Python scripts.

Experience with MongoDB.

Experience with PostgreSQL.

Familiarity with Cassandra and/or Cosmos DB.

Familiarity with Jenkins, Terraform, Ansible.