Company Overview
Here at UKG, our purpose is people. Our HR, payroll, and workforce management solutions help organizations unlock happier outcomes for all. 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.
Description & Qualifications
Description
About the role:
UKG Inc. is seeking a passionate Senior Database Engineer to join our award-winning organization. As the Senior Database Engineer on the Core Payroll Development Team, 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!
Duties and Responsibilities:
- 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
- Perform database tuning and optimization to maximize performance while keeping application downtime to a minimum
- 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
- Work closely with production support and operations personnel to identify and remove bottlenecks in the system while maintaining existing application functionality
- Participate in on-call rotation for production database support for issues related to development
Qualifications
About you:
Basic Qualifications:
- Must have 4+ 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, indexing, and partitioning.
- Must have a proven ability to design and optimize large, complex DB schemas
- Extensive experience in creating and maintaining tables, views, stored procedures, triggers, TSQL, dynamic SQL, indexes, and data constraints
- Expertise in Database Architecture in an environment that handles large volume of data
- Must have expertise in large-scale multi-database SQL Server environments
- Must possess expert troubleshooting and performance tuning skills
- Must have ability to decipher, refactor and simplify complex T-SQL
- Must understand the concept of legacy code restrictions but also be willing to seek the best solutions and workarounds for any situation
- Must be able to dig in and understand the business needs & requirements and translate that into the most efficient approach to solve the problem
- Excellent data modelling skills and 4+ years of experience with large (1000+ table) database systems with > 500GB of data
Preferred Qualifications:
- Strong work ethic with a sense of ownership, 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
- Team player with an ability to handle multiple tasks under tight deadlines
- Experience in quickly identifying and optimizing customer related SQL Server performance issues using built-in DMVs
- Experience using JIRA for Issue Tracking as part of software development lifecycle
- Experience using Git for source control with GitHub or Bitbucket
- HCM / Payroll domain knowledge a big plus
- Application programming experience in languages such as C#, or Java a plus
- Experience with MySQL and/or MongoDB a plus
- Solid understanding of data protection regulations such as GDPR & CCPA and database security best practices
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.
#J-18808-Ljbffr