Company Overview

With 80,000 customers across 150 countries, UKG is the largest U.S.-based private software company in the world. And we’re only getting started. Ready to bring your bold ideas and collaborative mindset to an organization that still has so much more to build and achieve? Read on.

At UKG, you get more than just a job. You get to work with purpose. Our team of U Krewers are on a mission to inspire every organization to become a great place to work through our award-winning HR technology built for all.

Here, we know that you’re more than your work. That’s why our benefits help you thrive personally and professionally, from wellness programs and tuition reimbursement to U Choose — a customizable expense reimbursement program that can be used for more than 200+ needs that best suit you and your family, from student loan repayment, to childcare, to pet insurance. Our inclusive culture, active and engaged employee resource groups, and caring leaders value every voice and support you in doing the best work of your career. If you’re passionate about our purpose — people —then we can’t wait to support whatever gives you purpose. We’re united by purpose, inspired by you.

Responsibilities:

• CR and code review for best practices and standards

• Guide L1 and L2 DBAs in analysis and troubleshooting

• Develop alerting and monitoring solutions (using DMVs, Perfmon, Profiler and other tools)

• Develop database maintenance solutions

• Troubleshoot SSIS, reporting, ETL and data warehouse related issues

• Analyze performance related issues from all aspects - Create build templates

• Create and maintain DB setup and configuration PL/SQL scripts

• Review windows and infrastructure resources for bottlenecks and suggest options for improvement

• Implement and maintain clustering, log shipping, always-on and replication solutions

• Review problematic code and suggest options for improvement

• Continuous review of existing best practices/SOPs and update if there is any scope of improvement

Essential Functions:

• Monitor production systems, resolve issues proactively, escalating to senior engineers, if needed.

• Support production and other environments consisting of SQL 2012-2022 , Windows Server 2014-2022.

• Install, administer, and update Windows and SQL 2012-2022 servers.

• Trouble shoot and resolve performance related issues for SQL 2012-2022 servers.

• Configure and maintain replication, log shipping, AlwaysOn, and MS cluster.

Secondary Functions:

• Continuous learning of system administration topics.

• Function as a liaison between Hosting Operations and other teams within the company, which may include direct or indirect contact with our customers.

• Any and all additional job duties as defined by Hosting management.

Knowledge, Skills, and Abilities:

• Installation / configuration/ maintenance and Administration of SQL SERVR 2012-2022.

• Disaster Recovery Planning and Implementation (Mirroring, Replication, log shipping, MS Cluster…)

• Good knowledge of Transactional SQL, Stored Procedures, SQL Monitoring tools and Performance monitoring.

• Knowledge of Planning and implementing backup policies.

• Practical experience in managing the internal and external MS SQL database security.

• Knowledge of hosting/SaaS environments, Network Operations Center protocol, focusing on systems performance and high availability.

• Knowledge of server hardware systems and Operating system.

• Knowledge and experience in qualifying, staging and deploying of specialized software pieces into a complex production hosting center.

• Knowledge of the following technology areas: Installation, Administration and configuration of Windows servers. - Knowledge of Active Directory (user, Groups, computer management and Group Policy). - Disaster Recovery Planning.

Graduate in Computer Science, MCA/ Regular PG course in Computers added advantage

•Minimum 5 years related work experience, 3+ years in Microsoft SQL SERVER administration

•Scripting knowledge (WS script, power shell, Dos and Batch scripts)

•Exposure to ORACLE \ PPAS \ Cassandra would be a plus

•Backup and recovery tools

•Exposure to ITIL tools

Where we’re going

UKG is on the cusp of something truly special. Worldwide, we already hold the #1 market share position for workforce management and the #2 position for human capital management. Tens of millions of frontline workers start and end their days with our software, with billions of shifts managed annually through UKG solutions today. Yet it’s our AI-powered product portfolio designed to support customers of all sizes, industries, and geographies that will propel us into an even brighter tomorrow!

UKG is proud to be an equal opportunity employer and is committed to promoting diversity and inclusion in the workplace, including the recruitment process.     

Disability Accommodation 

For individuals with disabilities that need additional assistance at any point in the application and interview process, please email UKGCareers@ukg.com

It is the policy of Ultimate Software to promote and assure equal employment opportunity for all current and prospective Peeps 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 entitled to protection under federal, state, or local anti-discrimination laws. This policy governs all matters related to recruitment, advertising, and initial selection of employment. It shall also apply to all other aspects of employment, including, but not limited to, compensation, promotion, demotion, transfer, lay-offs, terminations, leave of absence, and training opportunities.