Skip to content

Senior / Lead PostgreSQL DBA

General information

Location:

USA - USA - Remote

Function:

Software & Product Development

Ref #:

20210019142

Description & Requirements

Description

Cloud Database (PostgreSQL/EnterpriseDB PPAS) Administrator is responsible for overseeing the database administration functions of Cloud Operations. This position is responsible for database implementation as well as maintenance of PostgreSQL/EnterpriseDB PPAS. This role will work closely with other DBAs, development, architecture, and infrastructure teams to design and administer databases to provide and enforce contractual SLAs.

• Install and Administer PostgreSQL (emphasis on EnterpriseDB versions)
• Disaster Recovery Planning and Implementation
• Design, configure, and automate PostgreSQL database clusters, including Datastax
• Define and establish best practices with PostgreSQL, including configuration, monitoring health and backups of the cluster
• Developing scripts for a range of maintenance activities
• Patch/upgrade PostgreSQL in a HA architecture
• Managing connection poolers (pgPool and pgBouncer)
• Managing failover managers in PostgreSQL (EDB Enterprise Failover Manager/Repmgr)
• Implementation and management of PPAS in a Cloud Environment
• Analyze and resolve performance issues and assist with RCAs
• Expert in problem solving, planning, organization, and documentation

Qualifications

The successful applicant will demonstrate good judgment in selecting methods and techniques for obtaining solutions. They will possess strong consultative abilities and communication skills which they will leverage to tie their technical recommendations to business benefits and process change. After initial training they normally require little instruction on their day-to-day work.

• 5-8 years of experience working as a PostgreSQL/EnterpriseDB PPAS DBA with an experience of supporting Cloud customer facing production environments
• Must have experience in relational SQL and NO SQL databases. Extensive design and development experience on PostgreSQL (with Cassandra a plus) with implementation knowledge on cloud (AWS/GCP)
• Hands-on experience in performance tuning PostgreSQL
• Expert knowledge of PostgreSQL architecture (Cassandra a plus)
• Experience working effectively and collaboratively as a member of a 24x7 production support team (including under pressure). Team player a must
• Must be able to manage time effectively and to deliver on commitments
• Strong interpersonal and communication (written and verbal) skills for both technical and non-technical audiences and customers
• Strong knowledge in UNIX/LINUX platforms (knowledge of Java platforms & middleware is a plus)
• BS/BA in Computer Science or equivalent experience
• PPAS Database, EnterpriseDB Database Administrator Certified Associate or Professional Preferred

Corporate 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