Strategic Data Systems, Inc.
Overview
The Senior Database Engineer will play a key role in architecting, developing, and optimizing robust database solutions that power enterprise-grade applications. This role focuses on designing scalable data models, fine-tuning PostgreSQL performance, and integrating efficient APIs within a modern Ruby on Rails framework. The ideal candidate brings deep experience with relational database performance, API design, and agile software development, enabling seamless collaboration across teams to deliver reliable, secure, and high-performing systems.
Top Skills
API Design and Integration Database Engineering and Optimization PostgreSQL (Performance Tuning, Query Optimization, Replication, and Monitoring) Ruby on Rails Framework Application Performance and Scalability
Nice To Have
Cloud platform experience (AWS, Azure, or GCP) Familiarity with GraphQL and modern API design principles Experience with CI/CD pipelines and DevOps integration Exposure to containerized environments (Docker, Kubernetes)
Key Responsibilities
Design, implement, and maintain high-performing PostgreSQL databases supporting large-scale transactional systems. Develop and optimize RESTful and GraphQL APIs within Ruby on Rails applications. Collaborate with software engineers, architects, and DevOps teams to ensure database reliability, scalability, and observability. Conduct advanced query optimization, indexing, and partitioning to achieve sub-second response times. Implement database security, replication, and disaster recovery strategies. Support continuous integration and deployment workflows with database migration best practices. Analyze performance bottlenecks, provide solutions, and proactively tune database systems. Participate in Agile ceremonies, code reviews, and architecture discussions to drive continuous improvement. Maintain comprehensive documentation for schema design, queries, and stored procedures.
Qualifications
Required
Bachelor’s in Computer Science, Engineering, or related field (or equivalent experience). 5+ years of professional experience in database design and software engineering. Advanced expertise in PostgreSQL, including performance tuning, indexing, and query optimization. Strong proficiency with Ruby on Rails application architecture. Hands-on experience designing APIs (REST or GraphQL) for high-volume applications. Experience using version control tools (Git, GitHub). Understanding of Agile methodologies, CI/CD pipelines, and test-driven development. Preferred
Cloud platform expertise (AWS RDS, Aurora, or Azure Database for PostgreSQL). Familiarity with caching mechanisms (Redis, Memcached). Experience with observability and monitoring tools (Prometheus, Datadog, New Relic). Knowledge of database migration, backup, and restore strategies. Security-first mindset for data protection and compliance (encryption, auditing, access control).
What You’ll Get
Competitive base salary Medical, dental, and vision insurance coverage Optional life and disability insurance provided 401(k) with a company match and optional profit sharing Paid vacation time Paid Bench time Training allowance offering Eligibility for referral bonuses
Apply For Job
#J-18808-Ljbffr
The Senior Database Engineer will play a key role in architecting, developing, and optimizing robust database solutions that power enterprise-grade applications. This role focuses on designing scalable data models, fine-tuning PostgreSQL performance, and integrating efficient APIs within a modern Ruby on Rails framework. The ideal candidate brings deep experience with relational database performance, API design, and agile software development, enabling seamless collaboration across teams to deliver reliable, secure, and high-performing systems.
Top Skills
API Design and Integration Database Engineering and Optimization PostgreSQL (Performance Tuning, Query Optimization, Replication, and Monitoring) Ruby on Rails Framework Application Performance and Scalability
Nice To Have
Cloud platform experience (AWS, Azure, or GCP) Familiarity with GraphQL and modern API design principles Experience with CI/CD pipelines and DevOps integration Exposure to containerized environments (Docker, Kubernetes)
Key Responsibilities
Design, implement, and maintain high-performing PostgreSQL databases supporting large-scale transactional systems. Develop and optimize RESTful and GraphQL APIs within Ruby on Rails applications. Collaborate with software engineers, architects, and DevOps teams to ensure database reliability, scalability, and observability. Conduct advanced query optimization, indexing, and partitioning to achieve sub-second response times. Implement database security, replication, and disaster recovery strategies. Support continuous integration and deployment workflows with database migration best practices. Analyze performance bottlenecks, provide solutions, and proactively tune database systems. Participate in Agile ceremonies, code reviews, and architecture discussions to drive continuous improvement. Maintain comprehensive documentation for schema design, queries, and stored procedures.
Qualifications
Required
Bachelor’s in Computer Science, Engineering, or related field (or equivalent experience). 5+ years of professional experience in database design and software engineering. Advanced expertise in PostgreSQL, including performance tuning, indexing, and query optimization. Strong proficiency with Ruby on Rails application architecture. Hands-on experience designing APIs (REST or GraphQL) for high-volume applications. Experience using version control tools (Git, GitHub). Understanding of Agile methodologies, CI/CD pipelines, and test-driven development. Preferred
Cloud platform expertise (AWS RDS, Aurora, or Azure Database for PostgreSQL). Familiarity with caching mechanisms (Redis, Memcached). Experience with observability and monitoring tools (Prometheus, Datadog, New Relic). Knowledge of database migration, backup, and restore strategies. Security-first mindset for data protection and compliance (encryption, auditing, access control).
What You’ll Get
Competitive base salary Medical, dental, and vision insurance coverage Optional life and disability insurance provided 401(k) with a company match and optional profit sharing Paid vacation time Paid Bench time Training allowance offering Eligibility for referral bonuses
Apply For Job
#J-18808-Ljbffr