Skip to content

Lead SQL Server DBA Database Administrator

General Information

Ref #:

20220023503

Travel Amount Required:

None

Job Type:

Regular-Full Time

Location:

Noida - India - India

Description & Qualifications

Description

Lead SQL Server Database Administrator is responsible for overseeing the database administration functions of the Cloud services department. This position is responsible for database planning, design, and implementation, as well as the maintenance and optimization of SQL Server DB PPAS database supporting our Cloud application.

- 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 2000-2008 , Windows Server 2000-2014.
- Install, administer, and update Windows and SQL 2000-2014 servers.
- Trouble shoot and resolve performance related issues for SQL 2000-2014 servers.
- Configure and maintain replication, log shipping 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 2000, 2008, 2014.
- 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.

Good to Have:
- Scripting knowledge (WS script, power shell, Dos and Batch scripts).
- Exposure to ORACLE RDBMS.
- Backup and recovery tools.
- Exposure to ITIL tools.

Qualifications

BE/ B.Tech/ MCA regular (full time) from computer science/ IT discipline.

Company Overview

Here at UKG, Our Purpose Is People. UKG combines the strength and innovation of Ultimate Software and Kronos, uniting two award-winning, employee-centered cultures. Our employees are an extraordinary group of talented, energetic, and innovative people who care about more than just work. We strive to create a culture of belonging and an employee experience that empowers our people. UKG has more than 13,000 employees around the globe and is known for its inclusive workplace culture. Ready to be inspired? Learn more at www.ukg.com/careers

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 is the Law 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 or please call 1 (978) 250 9800.

Apply