Database Engineer Ii

**Company Overview**:
Here at UKG, our purpose is people. Our HR, payroll, and workforce management solutions help organizations unlock happier outcomes for all. And our U Krewers, who build those solutions and support our business, are talented, collaborative, and innovative problem-solvers. We strive to create a culture of belonging and an employee experience that empowers our people - both at work and at home. Our benefits show that we care about the whole you, from adoption and surrogacy assistance to tuition reimbursement and wellness programs. Our employee resource groups provide a welcoming place to land, learn, and connect with those who share your passions and interests. What are you waiting for?

**Description & Qualifications**:
Description

About the Team:
UKG Inc. is seeking a passionate Database Engineer to join our award-winning organization. As the Database Engineer, you will be responsible for the design, implementation, optimization, and maintenance of our SQL Server databases. You will be working to proactively make changes to meet the growing needs of the business. If you have a strong understanding of T-SQL development, performance optimization and best practices, you may be a perfect fit for this role
About the Role:

- Design, develop, and implement efficient and scalable T-SQL Code for our cloud delivered enterprise HCM Software Solution
- Build functionality in our software solution as part of a cutting-edge agile software development team
- Collaborate with developers to optimize queries and improve overall system performance
- Conduct regular performance analysis and make recommendations for improvements
- Review latest trends and technologies in database engineering and propose innovative solutions to enhance our systems
- Participate in on-call rotation for production database support for issues related to development

**Qualifications**:
About You:
Basic Qualifications:

- Must have 2+ years T-SQL coding experience on large projects.
- In-depth knowledge of Microsoft SQL Server 2016 & 2019 and its core components, including database design, query optimization, and indexing.
- Experience in creating and maintaining tables, views, stored procedures, triggers, TSQL, dynamic SQL, indexes, and data constraints.
- Experience troubleshooting and performance tuning.
- Must be able to dig in and understand the business needs & requirements and translate that into the most efficient approach to solve the problem.
- Data modelling skills.

Preferred Qualifications:

- Strong work ethic with a sense of ownership, Team, urgency, and drive and an unwavering commitment to do the right thing.
- Proven leadership in facilitating complex discussions to achieve goals and solve problems. Proven analytical and decision-making skills.
- Experience in quickly identifying and optimizing customer related SQL Server performance issues using built-in DMVs.
- Experience using Git for source control with GitHub or Bitbucket a plus
- HCM / Payroll domain knowledge a big plus.

**EEO Statement**:
**Equal Opportunity Employer**

Ultimate Kronos Group is proud to be an equal opportunity employer and is committed to maintaining a diverse and inclusive work environment. All qualified applicants will receive considerations for employment without regard to race, color, religion, sex, age, disability, marital status, familial status, sexual orientation, pregnancy, genetic information, gender identity, gender expression, national origin, ancestry, citizenship status, veteran status, and any other legally protected status under federal, state, or local anti-discrimination laws.