UST
Website:
ust.com
Job details:
Role Description
Who we are:
At UST, we help the world’s best organizations grow and succeed through transformation. Bringing together the right talent, tools, and ideas, we work with our client to co-create lasting change. Together, with over 30,000 employees in 30+ countries, we build for boundless impact—touching billions of lives in the process. Visit us at .
Role Overview:
- Design, develop, and maintain SQL Server database objects (stored procedures, functions, views, triggers)
- Individual contributor focused on SP/function development, query optimization, SSIS, and deployment support
Core Development:
- Develop and maintain stored procedures, user-defined functions, views, and triggers in SQL Server 2016/2019/2022
- Write and optimize complex T-SQL queries involving multi-table joins (8-15 tables), CTEs, window functions, and subqueries
- Develop complex SPs involving multi-level CTEs, MERGE, CROSS/OUTER APPLY, and advanced patterns
- Implement data integrity through constraints, transactions, and error handling (TRY/CATCH,XACT_ABORT)
- Experience writing stored procedures with 200+ lines of T-SQL with proper error handling
- Develop and maintain SSIS packages for ETL processes and data migration tasks
- Work with synonyms and cross-database queries
Performance & Optimization:
- Analyze and resolve slow-running queries using execution plans, DMVs, and Extended Events
- Create and maintain database indexes, statistics, and partitioning strategies for tables with 1M-10M+ rows
- Ability to read and interpret execution plans to identify performance issues
- Core skills: T-SQL, execution plans, index design, Git
- Monitor and respond to SQL Agent job failures, blocking s, and performance issues
- Production health and incident resolution
- Advanced skills: Deadlock/blocking analysis, lock internals, tempdb tuning, CI/CD
Deployment Process:
- Write rollout/rollback deployment scripts and validate schema changes across Dev, QA, Staging, and Production
- Write unit and integration tests for database objects
- Experience with transactional (OLTP) databases in a production environment Collaboration & Documentation
- Collaborate with .NET/Angular application developers to design efficient data access patterns
- Participate in and lead PR reviews focusing on correctness, performance, security, concurrency, and deployment safety
Skills:
sql server,stored procedures,functions,views,triggers,
What We Believe:
We’re proud to embrace the same values that have shaped UST since the beginning. Since day one, we’ve been building enduring relationships and a culture of integrity. And today, it's those same values that are inspiring us to encourage innovation from everyone, to champion diversity and inclusion and to place people at the centre of everything we do.
Humility:
We will listen, learn, be empathetic and help selflessly in our interactions with everyone.
Humanity:
Through business, we will better the lives of those less fortunate than ourselves.
Integrity:
We honour our commitments and act with responsibility in all our relationships.
Equal Employment Opportunity Statement
UST is an Equal Opportunity Employer. We believe that no one should be discriminated against because of their differences, such as age, disability, ethnicity, gender, gender identity and expression, religion, or sexual orientation.
All employment decisions shall be made without regard to age, race, creed, colour, religion, sex, national origin, ancestry, disability status, veteran status, sexual orientation, gender identity or expression, genetic information, marital status, citizenship status or any other basis as protected by federal, state, or local law.
UST reserves the right to periodically redefine your roles and responsibilities based on the requirements of the organization and/or your performance.
- To support and promote the values of UST.
- Comply with all Company policies and procedures
Skills
sql server,stored procedures,functions,views,triggers,
Click on Apply to know more.