Oracle / Postgres Database Administrator

Position Overview

Job Title: Oracle/ Postgres DBA

Location:

SS&C Health, a business unit within SS&C Technologies, delivers technology-driven solutions for healthcare organizations focused on administration, compliance, data management, analytics, and operational efficiency. With extensive expertise in both financial services and healthcare, the organization supports a range of clients from large enterprises to mid-market firms.

Key Responsibilities

• Install, configure, upgrade, and patch Oracle and PostgreSQL database software.
• Monitor database performance, identify bottlenecks, and implement solutions to optimize queries 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 focusing 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).
• Familiarity with cloud database services (e.g., AWS RDS, Azure SQL Database) is a plus.
• Strong analytical and problem-solving skills with meticulous attention to detail.
• Excellent communication and interpersonal skills, with the ability to work independently and as part of a team.
• Ability to manage multiple priorities in a fast-paced environment.

Benefits & Perks

• Flexibility: Hybrid Work Model & a 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, Employee Assistance Program, and Parental Leave.
• Extra Perks: Discounts on fitness clubs, travel, and more.
• Compensation: Salary range of 145000 USD to 160000 USD, depending on location (Jersey City, NJ; New York; Washington; California; Colorado; Maryland).