SS&C Technologies
Oracle / Postgres Database Administrator
SS&C Technologies, Raleigh, North Carolina, United States
Job Description
We are a leading financial services and healthcare technology company headquartered in Windsor, Connecticut, with 27,000+ employees in 35 countries. SS&C Health, a business unit of SS&C Technologies, delivers technology-driven solutions for healthcare organizations, focusing on administration, compliance, data management, analytics, and operational efficiency.
Position Overview Job Title:
Oracle/Postgres Database Administrator Location:
Hybrid / Kansas City, MO Employment Type:
Full-time Seniority Level:
Mid-Senior Level
Responsibilities
Install, configure, upgrade, and patch Oracle and PostgreSQL database software.
Monitor database performance, identify bottlenecks, and 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.
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).
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, able to work independently and as part of a team.
Ability to manage multiple priorities in a fast‑paced environment.
Benefits
Hybrid work model and business casual dress code.
401(k) matching program and professional development reimbursement.
Flexible personal/vacation time off, sick leave, and paid holidays.
Medical, dental, vision, employee assistance program, and parental leave.
Commitment to celebrating diversity and inclusion.
Hands‑on training and team‑customized learning opportunities through SS&C University.
Discounts on fitness clubs, travel, and more.
Equal Employment Opportunity SS&C Technologies is an Equal Employment Opportunity employer and does not discriminate against any applicant for employment or employee on the basis of race, color, religious creed, gender, age, marital status, sexual orientation, national origin, disability, veteran status, or any other classification protected by applicable discrimination laws.
#J-18808-Ljbffr
Position Overview Job Title:
Oracle/Postgres Database Administrator Location:
Hybrid / Kansas City, MO Employment Type:
Full-time Seniority Level:
Mid-Senior Level
Responsibilities
Install, configure, upgrade, and patch Oracle and PostgreSQL database software.
Monitor database performance, identify bottlenecks, and 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.
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).
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, able to work independently and as part of a team.
Ability to manage multiple priorities in a fast‑paced environment.
Benefits
Hybrid work model and business casual dress code.
401(k) matching program and professional development reimbursement.
Flexible personal/vacation time off, sick leave, and paid holidays.
Medical, dental, vision, employee assistance program, and parental leave.
Commitment to celebrating diversity and inclusion.
Hands‑on training and team‑customized learning opportunities through SS&C University.
Discounts on fitness clubs, travel, and more.
Equal Employment Opportunity SS&C Technologies is an Equal Employment Opportunity employer and does not discriminate against any applicant for employment or employee on the basis of race, color, religious creed, gender, age, marital status, sexual orientation, national origin, disability, veteran status, or any other classification protected by applicable discrimination laws.
#J-18808-Ljbffr