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. Description: Senior PostgreSQL/Enterprise DB PPAS 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 PostgreSQL/Enterprise DB PPAS database supporting our Cloud application. This role will work closely with the DBAs, development, architecture and infrastructure teams to design and administer databases to provide and enforce contractual SLAs. Must to have- - Expert in Installation / configuration/ maintenance and Administration of PostgreSQL with an emphasis on EnterpriseDB versions. - Disaster Recovery Planning and Implementation - Expert in developing scripts for a range of maintenance activities - Experience with Enterprise Failover Manager for HA is required - Must be able to patch/upgrade PostgreSQL in a HA architecture - Experience with EDB Replication preferred - Knowledge of connection poolers like pgPool and pgBouncer ideal - Thorough knowledge of database security best practices - Communicates effectively to both technical and non-technical individuals at various levels of customer and internal organizations. - Working knowledge on EFM - Experience with Implementation in a Cloud Environment ideal - Expert in performance analysis and resolution - Works as a member of a 24 x 7 team. - Knowledge of Planning and Implementing (scripting) backup strategies. Good To have- - Cloud SaaS (multi-tenant) environment experience preferred - Linux Administration (RHEL) experience preferred - Knowledge of Integration with 3rd party Monitoring Systems - Familiarity with Virtual Machine (or Docker) technology a plus - Excellent written and verbal skills - Expert in problem solving, planning, organization, and documentation - Ability to excel in a cohesive team environment - Experience with JDBC connection pools preferred - Uses consultative techniques and skills in their services delivery. - Exposure to Cassandra or Astra will be an added advantage. - Familiarity with Virtual Machine (or Docker) technology a plus - Configure and modify alert at SPLUNK - Create dashboards at Grafana 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. BE/ B.Tech/ MCA or equivalent experience in Computer Science. PPAS Database, Enterprise DB Database Administrator Certified Associate or Professional Preferred Above 3-5 years of experience working as an PostgreSQL/EDB PPAS DBA 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! UKG is proud to be an equal opportunity employer and is committed to promoting diversity and inclusion in the workplace, including the recruitment process. Disability Accommodation in the Application and Interview Process For individuals with disabilities that need additional assistance at any point in the application and interview process, please email UKGCareers@ukg.com 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.