Lead Database Architect

SS&C Technologies; Michigan; Remote; USD 160,000 - 200,000; Full time

Job summary

A leading financial services and healthcare technology company seeks a Lead Database Architect to design and manage scalable database infrastructures. The role involves working with Postgres and Citus technologies, ensuring high availability and security. The ideal candidate will have extensive experience in database management and architecture, contributing to innovative solutions in a hybrid work environment.

Benefits

401k Matching Program

Professional Development Reimbursement

Flexible Personal / Vacation Time Off

Medical, Dental, Vision

Employee Assistance Program

Parental Leave

Discounts on fitness clubs

Qualifications

• 6 years of related experience required.
• 5 years of experience with Postgres Relational Databases.
• 3-5 years on Data Warehouse Projects.

Responsibilities

• Design and develop Database Architecture for business problems.
• Lead complex database infrastructure projects.
• Develop disaster recovery architecture.

Skills

Database Management

Data Warehousing

Database Architecture

Sharding

Education

Bachelor's Degree

High School Degree

Tools

Postgres

Citus

Job description

As a leading financial services and healthcare technology company based on revenue, SS&C is headquartered in Windsor, Connecticut, and has 27,000+ employees in 35 countries. Some 20,000 financial services and healthcare organizations, from the world's largest companies to small and mid-market firms, rely on SS&C for expertise, scale, and technology.

Job Description

Job Title : Lead Database Architect

Locations : Remote

Get To Know The Team :

DomaniRx is a newly formed organization focused on shaping the future of Pharmacy Benefit Management by delivering a cloud-native, API-driven claims adjudication platform.

Our team is made up of engineers with varying levels of professional experience and backgrounds, from new graduates to 20-year veterans of the healthcare industry. We are looking for creative engineers and technologists : relevant industry experience is important, but less so than your demonstrated abilities, passion and attitude. We're always improving and looking for individuals that enjoy being challenged and have a strong desire to make the engineering experience better for our users.

Why You Will Love It Here!

Flexibility : Hybrid Work Model & a Business Casual Dress Code, including jeans

Your Future : 401k Matching Program, Professional Development Reimbursement

Work / Life Balance : Flexible Personal / Vacation Time Off, Sick Leave, Paid Holidays

Your Wellbeing : Medical, Dental, Vision, Employee Assistance Program, Parental Leave

Diversity & Inclusion : Committed to Welcoming, Celebrating and Thriving on Diversity

Training : Hands-On, Team-Customized, including SS&C University

Extra Perks : Discounts on fitness clubs, travel and more! What You Will Get To Do :

• Please do not apply unless you have experience with the following : Databases , Including sharding and shard management
• Relational Databases
• Data Warehousing
• Design and develop Database Architecture to solve business and business intelligence problems in alignment with the enterprise scalability requirements.
• Architect a strategy for sharding and partitioning Postgres Databases to meet the performance and high availability requirements of constantly growing databases that may reach over 100TB levels.
• Drive the build out of high availability and sharded database infrastructures such as Citus-driven (or similar custom sharding and cluster driven technologies) infrastructures using Postgres as DBMS.
• Develop disaster recovery architecture that will enable a complete failover to a data center in a different region.
• Analyze infrastructures and develop strategies to harden DBMS infrastructure security posture.
• You will perform technical planning, architecture development, and specification modification.

You will develop strategies and specifications for new products / services, applications, and service offerings.

You will assess the compatibility and integration of products / services proposed to ensure an integrated architecture across interdependent technologies is within standards.

• Lead complex database infrastructure projects that require a broad perspective, conceptual thinking, and in-depth analysis to identify solutions.
• May also lead a process or function without direct reports.
• Demonstrates a depth and breadth of expertise within a discipline and has a deep understanding of the business, financials, products / services, or market.
• Develop policies and procedures and recommend best practices.
• Advise and provide direction to other data and dba engineers.

What you will bring :

• Minimally requires a bachelor's degree and 6 years of related experience, or a high school degree and 8 years of related experience.
• 5 Years of experience working with Postgres Relational Databases
• 3-5 Years of experience working on Data Warehouse Projects
• 5 Years Database Design and Architecture
• Must have Citrus or related Postgres database sharding and scaling experience.

Digital Worker Enabled# # Initials : &DWRK # # Keywords : Sharding Citus Postgres Database Architecture Relational Databases Data Warehouse #

Unless explicitly requested or approached by SS&C Technologies, Inc. or any of its affiliated companies, the company will not accept unsolicited resumes from headhunters, recruitment agencies, or fee-based recruitment services.

SS&C offers excellent benefits including health, dental, 401k plan, tuition and professional development reimbursement plan.

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.

Salary is determined by various factors including, but not limited to, relevant work experience, job related knowledge, skills, abilities, business needs, and geographic regions.

Maryland : Salary range for the position : 160000 USD to 199999 USD.