Skip to content

Careers

Transcend the day-to-day work experience. Work inspired.

SQL Server DBA

Location:

Lowell - Massachusetts - USA

Function:

Engineering

Ref #:

20190004104
Apply >

Description

Installs, configures and maintains Databases as per product requirement and industry best practice. Ensures Database is available, secure, healthy, efficient and recoverable as per expectations. Performs regular system reviews and identify, plan and implement solutions for current and future need of product and organization. Evaluates and implements high availability solution as per business requirement. Reviews current and new code/scripts against best practices and expected result. Designs and implements automation for recurring tasks. Formulates and monitor policies, procedures and standards relating to database management. Proposes and implements enhancements that will improve the performance and reliability of the system. Able to correlates database related activities/troubleshooting/planning with infrastructure components like data center layout, OS/hardware, network, SAN, virtualization/Cloud etc. Able to independently analyze, solve, and correct issues in real time on Live Production environment, providing end-to-end problem resolution with no or minimum handholding. Provides technical mentorship and cross-training to peers and team members in area of respective expertise.


• Develop alerting and monitoring solutions (using DMVs, Perform, 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

Qualifications

• CR and code review for best practices and standards
• Change Request creation and deployment
• Monitor tickets/cases and resolve incidents as per OLA/SLA
• Guide L1 and L2 DBAs in analysis and troubleshooting
• Develop alerting and monitoring solutions (using DMVs, Perform, 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 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
Education/Experience
• BS/BA degree in Computer Science or related discipline or equivalent experience and a minimum of 5 years related work experience.
#LI-POST

Corporate overview

You’re empowered when you’re a Kronite. 

Want to be part of an elite group of highly skilled professionals? We think our employees are a special group of talented, energetic, and innovative people. And for that reason, we refer to ourselves as Kronites. Kronites care about more than just work. We recognize the need to maintain a healthy work-life balance – to live inspired. In fact, it’s expected! You’ll soon learn that we take work and fun seriously. No matter what position you hold at Kronos, you’re a Kronite. And we want you to feel like you have the power to make a difference in your life and the lives of others, at work and beyond. Want to learn more about our culture? Follow us on Twitter @work4kronos. #MyWorkInspired

Kronos is a global provider of workforce management and human capital management cloud solutions. Kronos’ industry-specific workforce applications are purpose built for businesses, healthcare providers, educational institutions and government agencies of all sizes. Tens of thousands of organizations – including half of the Fortune 1000® - and more than 40 million people in over 100 countries use Kronos every day. 

EEO Statement

Equal Opportunity Employer

Kronos is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, gender identity, sexual orientation, age, national origin, protected veteran status, disability or any other basis protected by federal, state or local law.


View The EEO is the Law poster and its supplement. 

View the Pay Transparency Nondiscrimination Provision

Kronos 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 KronosCareers@kronos.com or please call 1 (978) 250 9800.