Oracle / Postgres Database Administrator

Position Overview

SS&C, a leading financial services and healthcare technology company with 27,000+ employees across 35 countries, is headquartered in Windsor, Connecticut. Through SS&C Health, a business unit of SS&C Technologies, we deliver technology-driven solutions for healthcare organizations. We are seeking an experienced Oracle/Postgres DBA to manage, maintain, and optimize critical Oracle and PostgreSQL database systems, ensuring performance, integrity, and security for core operations at DST Health Solutions. The position is based in a Hybrid model in Kansas City, MO.

Key Responsibilities

• Install, configure, upgrade, and patch Oracle and PostgreSQL database software.
• Monitor database performance, identify bottlenecks, and implement solutions to optimize queries, indexes, and overall system efficiency.
• Perform routine database maintenance tasks, including backups, restores, and recovery procedures.
• Manage database security, including user access, roles, and permissions in compliance with company policies and industry best practices.
• Troubleshoot and resolve database-related issues, including connectivity, performance, and data integrity problems.
• Develop and implement database-level replication, high availability, and disaster recovery solutions.
• Collaborate with development teams to design and implement efficient database schemas and assist with query optimization.
• Document database configurations, procedures, and troubleshooting guides.
• Participate in on-call rotation for critical database support.
• Stay up-to-date with the latest database technologies, trends, and best practices for Oracle and PostgreSQL.

Required Qualifications

• Bachelor's degree in Computer Science, Information Technology, or a related field, or equivalent practical experience.
• 5+ years of experience as a Database Administrator with a strong focus on Oracle and PostgreSQL databases.
• Proven expertise in Oracle database administration, including RAC, Data Guard, ASM, and performance tuning.
• Demonstrable experience with PostgreSQL administration, including replication (e.g., streaming replication), partitioning, and performance tuning.
• Solid understanding of SQL, PL/SQL, and database scripting (e.g., Bash, Python).
• Experience with database backup and recovery strategies and tools (e.g., RMAN for Oracle, pg_dump/pg_restore for Postgres).
• Strong analytical and problem-solving skills with meticulous attention to detail.
• Excellent communication and interpersonal skills, with the ability to work effectively both independently and as part of a team.
• Ability to manage multiple priorities in a fast-paced environment.

Preferred Qualifications

• Familiarity with cloud database services (e.g., AWS RDS, Azure SQL Database).

Benefits & Perks

• Flexibility: Hybrid Work Model & Business Casual Dress Code (including jeans).
• Your Future: 401k Matching Program and Professional Development Reimbursement.
• Work/Life Balance: Flexible Personal/Vacation Time Off, Sick Leave, and Paid Holidays.
• Your Wellbeing: Medical, Dental, Vision coverage, Employee Assistance Program, and Parental Leave.
• Wide-Ranging Perspectives: Celebration of diverse backgrounds, talents, and experiences.
• Training: Hands-on, team-customized training including SS&C University.
• Extra Perks: Discounts on fitness clubs, travel, and more.
• Additionally, SS&C offers excellent health, dental, 401k plan, tuition, and professional development reimbursement plan.