Senior Database Engineer/Architect jobs in United States
cer-icon
Apply on Employer Site
company-logo

SmartFinancial · 6 hours ago

Senior Database Engineer/Architect

SmartFinancial is a leading insurance marketplace dedicated to helping insurance agencies grow faster with innovative technology. They are seeking a seasoned Senior Database Engineer/Architect to design and optimize robust database solutions on AWS, focusing on PostgreSQL and Amazon Redshift, while ensuring data integrity and enhancing performance across systems.

E-CommerceInsuranceInsurTechPrice Comparison

Responsibilities

Architect, design, implement, and maintain highly scalable and reliable database systems, primarily utilizing PostgreSQL and Amazon Redshift
Develop and optimize complex SQL queries, stored procedures, and database functions to ensure peak performance
Design, build, and manage efficient data pipelines for data ingestion, transformation, and loading, leveraging AWS services
Monitor database performance, troubleshoot issues, and implement proactive measures for optimization and disaster recovery
Ensure data security, integrity, and compliance with best practices and organizational policies
Collaborate with engineering teams to integrate database solutions into applications and services
Provide technical leadership and mentorship to junior engineers on database best practices and architecture
Manage and optimize AWS Relational Database Service (RDS) instances and other relevant AWS data services

Qualification

PostgreSQLAmazon RedshiftAWS servicesSQL optimizationData modelingDatabase securityMySQLInfrastructure as CodeContainerizationAWS certifications

Required

Bachelor's degree in Computer Science, Engineering, or a related field, or equivalent practical experience
7+ years of professional experience as a Database Engineer or Architect
Deep expertise in PostgreSQL, including advanced features, replication, and performance tuning
Extensive hands-on experience with Amazon Redshift, including schema design, query optimization, and cluster management
Proven track record of designing and implementing data pipelines using AWS services (e.g., DMS, S3, Lambda, Glue, Kinesis)
Strong proficiency with various AWS cloud services, particularly RDS, EC2, S3, and IAM
Solid understanding of data modeling principles, database design, and normalization techniques
Experience with database security, backup, and recovery strategies
Excellent problem-solving skills and ability to work independently or as part of a team

Preferred

Experience with MySQL databases
Familiarity with other data warehousing technologies
Knowledge of Infrastructure as Code (IaC) tools like AWS CloudFormation or Terraform
Experience with containerization technologies (Docker, Kubernetes) in a database context
AWS certifications (e.g., AWS Certified Database - Specialty, AWS Certified Solutions Architect - Associate/Professional)

Benefits

Comprehensive Health Coverage: Health, dental, and vision insurance for you and your dependents
Retirement Plans: 401(k) with company matching contributions
Paid Time Off: Generous PTO, holidays, and extensive paid product training
Professional Development: Opportunities for career growth and advancement in a supportive environment

Company

SmartFinancial

twittertwittertwitter
company-logo
SmartFinancial is a digital insurance marketplace that connects consumers with multiple insurers and guides agents.

Funding

Current Stage
Growth Stage

Leadership Team

leader-logo
Nathan Kropp
Co-Founder
linkedin
leader-logo
Brad Cooper
Chief Operating Officer
linkedin
Company data provided by crunchbase