Analyze, optimize, and tune SQL Server stored procedures, queries, and overall database performance
Collaborate with stakeholders to identify performance bottlenecks and implement efficient solutions
Fine-tune large, complex SQL queries to improve efficiency and reduce execution time
Ensure the data warehouse architecture supports scalability, reliability, and maintainability
Design, develop, and modify SSIS packages to meet business requirements and improve ETL processes
Perform debugging, testing, and troubleshooting of database issues and SSIS workflows
Implement best practices in database design, indexing, and query optimization
Monitor databases and ETL workflows to ensure consistent and reliable performance
Document technical processes, workflows, and design specifications
Develop and maintain automated solutions for data validation, cleansing, and integration processes
Assist in designing and maintaining data warehouse models, including star and snowflake schemas
Participate in code reviews to ensure high-quality database solutions and adherence to best practices

Requirements

3+ years of experience in data integration roles
Residence in Ukraine (remote work eligible only for candidates based in Ukraine)
Proven experience with SQL Server (2019 or later preferred), including advanced performance tuning and optimization skills
Proficiency in SSIS (SQL Server Integration Services) for ETL development and maintenance
Strong understanding of relational database concepts and RDBMS architecture
Familiarity with data warehouse design concepts such as star schema and snowflake schema
Knowledge of indexing strategies, query execution plans, and optimization techniques
Strong analytical and problem-solving skills with attention to detail
Excellent communication and collaboration skills to work with cross-functional teams

Nice to have

We offer/Benefits

With us you can:

Work on a flexible schedule remotely or from any of our comfortable offices or coworking spaces in Ukraine
Receive the necessary equipment to perform your work tasks
Change projects and technology stacks within EPAM
Gain experience in various business domains (Insurance, E-commerce, Healthcare, Finance, Travelling, Media, Artificial Intelligence, and more)
Relocation opportunities may be available for eligible candidates, depending on the role and openings at other EPAM locations
Participate in volunteer, charity programs and communities (both technical and interest-based)

We focus on your professional growth:

You can plan your individual career path together with your manager
Receive regular feedback from colleagues
Improve your English for free with certified teachers (Speaking Clubs, client interview preparation courses, etc.)
Get the opportunity to undergo free training and certification in AWS, GCP, or Azure Clouds
Use the internal E-learn training program (18,200+ specialized training and mentoring programs)
Access corporate accounts on LinkedIn Learning, Get Abstract and other partner resources
Study at EPAM Solution Architecture School with the instructors who are practicing architects
Develop as a leader, join Delivery Management, Resource Management, Leadership Essentials school and more
Participate in internal communities (500+ meetups, technical discussions, brainstorming sessions, online events and conferences annually)

What we offer:

Vacation and sick leave (including a sick leave without a medical certificate)
A wide range of Voluntary Medical Insurance programs providing both medical treatment and various preventive options (including sports activities)
Medical insurance for family members at corporate rates
Company support during significant life events (childbirth or adoption, marriage, etc.)
Support for psychological comfort: discounts on services from mental health specialists or coaches, thematic training
E-kids program - a free programming language training program for EPAMers' children

Data Integration & 3 others