Skip to content

Lead Production Database Administrator

General Information

Ref #:

20240038257

Travel Amount Required:

None

Job Type:

Regular-Full Time

Location:

Noida - India - India

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? Learn more at www.ukg.com/careers  #WeAreUKG 

Description & Qualifications

Description

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.

Qualifications

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

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. 

View The EEO Know Your Rights poster and its supplement. 

View the Pay Transparency Nondiscrimination Provision

UKG participates in E-Verify. View the E-Verify posters here.


Disability Accommodation

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

Apply