SS&C Technologies

Database Administrator, Oracle/Postgres

SS&C Technologies

full-time

Posted on:

Location Type: Hybrid

Location: Kansas City • Kansas, Montana, Virginia, Washington, West Virginia, Wisconsin, Wyoming • 🇺🇸 United States

Visit company website
✨ AI Apply
Apply

Salary

💰 $145,000 - $160,000 per year

Job Level

Mid-LevelSenior

Tech Stack

AssemblyAWSAzureCloudOraclePostgresPythonSQL

About the role

  • 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.

Requirements

  • 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 a meticulous attention to detail.
  • Excellent communication and interpersonal skills, with the ability to work effectively independently and as part of a team.
  • Ability to manage multiple priorities in a fast-paced environment.
Benefits
  • 401k Matching Program
  • Professional Development Reimbursement
  • Flexible Personal/Vacation Time Off
  • Sick Leave
  • Paid Holidays
  • Medical
  • Dental
  • Vision
  • Employee Assistance Program
  • Parental Leave
  • Discounts on fitness clubs, travel and more!

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard skills
Oracle database administrationPostgreSQL database administrationRACData GuardASMperformance tuningSQLPL/SQLdatabase scriptingreplication
Soft skills
analytical skillsproblem-solving skillsattention to detailcommunication skillsinterpersonal skillsteamworkindependencetime managementability to manage multiple prioritiesadaptability