Principal Production Database Administrator - PostreSQL - UKG (Ultimate Kronos Group)
Atlanta, GA
About the Job
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.
About the Team:
We are seeking a highly experienced Principal Database Administrator/Reliability Engineer to join our dynamic team. This role will provide you with the opportunity to work on cutting-edge SaaS technologies and impactful projects that are used by enterprises and users worldwide. You will drive technical strategy, lead large-scale projects, and mentor engineers across the organization.
About the Role:
Key Responsibilities:
+ Architect, design and building of PostgresSQL ,MySQL Server Infrastructure Onprem and public Cloud (AWS or GCP or Azure) ensuring high standards of performance, scalability, and reliability.
+ Develop alerting and monitoring solutions using Internal Views, Extensions, and other tools.
+ Implement monitors and alerts using modern observability approaches, including SLI/SLOs and Error Budget.
+ Troubleshoot and resolve performance-related issues for EDB & Community PostgreSQL servers, reporting, ETL, and data warehouse-related issues.
+ Create, develop, and maintain database maintenance solutions, DB setup, and configuration PL/SQL scripts.
+ Implement and maintain EFM, replication solutions, and standby servers.
+ Review problematic code and suggest improvements.
+ Develop team policies, procedures, and techniques.
+ Ensure the health and quality of services and incidents, proactively identifying and addressing issues.
+ Provide technical mentorship and guidance, fostering a culture of learning and continuous improvement.
+ Develop and maintain comprehensive technical documentation for database systems. Continuously review and update existing best practices/SOPs.
+ Stay current with emerging technologies and industry trends.
+ Participate in the on-call rotations and provide critical support for production systems.
Knowledge, Skills, and Abilities:
+ Support production and other environments consisting of EDB & Community PostgreSQL, EFM, PGBouncer and Linux.
+ Installation, configuration, maintenance, and administration of PostgreSQL.
+ Disaster Recovery Planning and Implementation (Replication of different types).
+ Strong knowledge of PL/SQL, Stored Procedures, Monitoring tools, and Performance monitoring.
+ Experience in planning and implementing backup policies.
+ Practical experience in managing internal and external database security.
+ Knowledge of hosting/SaaS environments and focusing on systems performance and high availability.
+ Knowledge of server hardware systems and operating systems.
+ Hands-on experience with scripting and automation using Python, Go, and Google Cloud Scripting.
+ Familiarity with various database technologies, including SQL (MySQL, SQL Server, Oracle), NoSQL (Cassandra, Astra), and SaaS DB instances (Cloud SQL, ASTRA).
About You:
Minimum Qualifications:
+ Bachelor's or master's degree in computer science, Engineering, or a related technical field.
+ 9+ years of professional experience as a PostgreSQL Server DBA or Similar roles
+ Advanced skills with scripting and automation using Python, Go, PowerShell, Google Cloud Scripting and Infrastructure Code (IaC)
+ Proficiency with cloud technologies like Azure, AWS, GCP (Preferable)
+ Strong problem-solving skills and attention to detail, with a commitment to delivering high-quality software solutions.
+ Proficiency in building telemetry or observability implementation of SLI’/SLO for database operations meeting high Standards.
+ Strong leadership, communication, and interpersonal skills.
+ PostgreSQL (or)MySQL Certification is Must and preferable to have other Cloud certifications in AWS, GCP.
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!
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 (https:www.eeoc.gov/sites/default/files/2022-10/EEOC_KnowYourRights_screen_reader_10_20.pdf) and its supplement .
View the Pay Transparency Nondiscrimination Provision (https:www.dol.gov/sites/dolgov/files/ofccp/pdf/pay-transp_%20English_formattedESQA508c.pdf)
UKG participates in E-Verify. View the E-Verify posters here (https:www.e-verify.gov/sites/default/files/everify/posters/EVerifyParticipationPoster.pdf) .
Disability Accommodation
For individuals with disabilities that need additional assistance at any point in the application and interview process, please email UKGCareers@ukg.com .
The pay range for this position is $109,000 to $156,700, however, base pay offered may vary depending on skills, experience, job-related knowledge and location. This position is also eligible for a short-term incentive and a long-term incentive as part of total compensation. Information about UKG’s comprehensive benefits can be reviewed on our careers site at https:www.ukg.com/careers (https:www.ukg.com/careers)
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.
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.
About the Team:
We are seeking a highly experienced Principal Database Administrator/Reliability Engineer to join our dynamic team. This role will provide you with the opportunity to work on cutting-edge SaaS technologies and impactful projects that are used by enterprises and users worldwide. You will drive technical strategy, lead large-scale projects, and mentor engineers across the organization.
About the Role:
Key Responsibilities:
+ Architect, design and building of PostgresSQL ,MySQL Server Infrastructure Onprem and public Cloud (AWS or GCP or Azure) ensuring high standards of performance, scalability, and reliability.
+ Develop alerting and monitoring solutions using Internal Views, Extensions, and other tools.
+ Implement monitors and alerts using modern observability approaches, including SLI/SLOs and Error Budget.
+ Troubleshoot and resolve performance-related issues for EDB & Community PostgreSQL servers, reporting, ETL, and data warehouse-related issues.
+ Create, develop, and maintain database maintenance solutions, DB setup, and configuration PL/SQL scripts.
+ Implement and maintain EFM, replication solutions, and standby servers.
+ Review problematic code and suggest improvements.
+ Develop team policies, procedures, and techniques.
+ Ensure the health and quality of services and incidents, proactively identifying and addressing issues.
+ Provide technical mentorship and guidance, fostering a culture of learning and continuous improvement.
+ Develop and maintain comprehensive technical documentation for database systems. Continuously review and update existing best practices/SOPs.
+ Stay current with emerging technologies and industry trends.
+ Participate in the on-call rotations and provide critical support for production systems.
Knowledge, Skills, and Abilities:
+ Support production and other environments consisting of EDB & Community PostgreSQL, EFM, PGBouncer and Linux.
+ Installation, configuration, maintenance, and administration of PostgreSQL.
+ Disaster Recovery Planning and Implementation (Replication of different types).
+ Strong knowledge of PL/SQL, Stored Procedures, Monitoring tools, and Performance monitoring.
+ Experience in planning and implementing backup policies.
+ Practical experience in managing internal and external database security.
+ Knowledge of hosting/SaaS environments and focusing on systems performance and high availability.
+ Knowledge of server hardware systems and operating systems.
+ Hands-on experience with scripting and automation using Python, Go, and Google Cloud Scripting.
+ Familiarity with various database technologies, including SQL (MySQL, SQL Server, Oracle), NoSQL (Cassandra, Astra), and SaaS DB instances (Cloud SQL, ASTRA).
About You:
Minimum Qualifications:
+ Bachelor's or master's degree in computer science, Engineering, or a related technical field.
+ 9+ years of professional experience as a PostgreSQL Server DBA or Similar roles
+ Advanced skills with scripting and automation using Python, Go, PowerShell, Google Cloud Scripting and Infrastructure Code (IaC)
+ Proficiency with cloud technologies like Azure, AWS, GCP (Preferable)
+ Strong problem-solving skills and attention to detail, with a commitment to delivering high-quality software solutions.
+ Proficiency in building telemetry or observability implementation of SLI’/SLO for database operations meeting high Standards.
+ Strong leadership, communication, and interpersonal skills.
+ PostgreSQL (or)MySQL Certification is Must and preferable to have other Cloud certifications in AWS, GCP.
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!
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 (https:www.eeoc.gov/sites/default/files/2022-10/EEOC_KnowYourRights_screen_reader_10_20.pdf) and its supplement .
View the Pay Transparency Nondiscrimination Provision (https:www.dol.gov/sites/dolgov/files/ofccp/pdf/pay-transp_%20English_formattedESQA508c.pdf)
UKG participates in E-Verify. View the E-Verify posters here (https:www.e-verify.gov/sites/default/files/everify/posters/EVerifyParticipationPoster.pdf) .
Disability Accommodation
For individuals with disabilities that need additional assistance at any point in the application and interview process, please email UKGCareers@ukg.com .
The pay range for this position is $109,000 to $156,700, however, base pay offered may vary depending on skills, experience, job-related knowledge and location. This position is also eligible for a short-term incentive and a long-term incentive as part of total compensation. Information about UKG’s comprehensive benefits can be reviewed on our careers site at https:www.ukg.com/careers (https:www.ukg.com/careers)
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.
Source : UKG (Ultimate Kronos Group)
