System Soft TechnologiesLocation: Remote but candidate must be from Ohio, Michigan, Indiana, Illinois, Tennessee, Texas, Colorado, Montana, Rhode Island, Florida, Massachusetts, Nevada.
Duration: Full Time Independent Consultants Only .
Job Summar y:The Senior Database Developer is responsible for the design, development, optimization, and modernization of enterprise database solutions that support critical product, analytics, and operational systems. This role ensures database environments are scalable, secure, and high performing, with a strong focus on PostgreSQL and AWS technologies, including Aurora, Redshift, and RD S.
The position works closely with software developers, infrastructure teams, business intelligence, and other stakeholders to deliver reliable data architecture, improve system performance, and support data-driven decision-making.
Responsibilities include advancing cloud-based data infrastructure, improving automation, establishing engineering best practices, and maintaining the long-term health, integrity, and governance of database syste ms.
This role also translates business and technical requirements into sustainable database solutions, supports performance tuning and continuous improvement efforts, and contributes to data governance, security, documentation, and cross-functional technical execut ion.
The ideal candidate brings deep PostgreSQL expertise, strong AWS experience (Aurora, Redshift, RDS), a systems-thinking mindset, and the communication skills to collaborate effectively across engineering and business t eams.
Primary Duties and Responsibi litiesDatabase Design & Devel opmentArchitect and implement scalable, high-performance relational database solutions in Postg reSQL.Write complex, optimized SQL and PL/pgSQL stored procedures, functions, and tri ggers.Continuously monitor, tune, and improve database performance, availability, and reliab ility.Lead scheduled version upgrades and evaluate emerging PostgreSQL, Aurora, and Redshift features for ado ption.
Cloud & Data Infrast ructureManage and monitor cloud-based database hosts using AWS RDS, Aurora, and Re dshift.Design and maintain data pipelines supporting analytics, reporting, and operational wor kloads.Build and maintain Infrastructure as Code (IaC) using Terraform for database provisioning and configu ration.Contribute to data mesh and data lake architecture initi atives.
Collaboration & Go vernancePartner with developers to improve application data access patterns and enforce best pr actices.Gather and translate user and stakeholder requirements into reliable database designs.Implement and uphold data governance, access controls, auditing, and security st andards.Provide data management support and technical guidance to end users and applicatio n teams.
Documentation &
; ProcessDevelop and maintain comprehensive technical documentation, runbooks, and training m aterials.Research and recommend new database products, services, and architectural patterns.Participate in Agile/Scrum ceremonies and contribute to sprint planning and delive ry.
& SQLExpert-level SQL authoring including writing complex queries, query plan analysis, index optimization, and performan ce tuning.Solid understanding of data management fundamentals including permissions, backup/recovery, security, and m onitoring.Experience with NoSQL databases (e.g., DynamoDB, MongoDB).
AWS & Clou d PlatformsProven experience with Amazon Aurora (PostgreSQL-compatible) and AWS RDSHands-on experience with Amazon Redshift for analytics and data warehousingFamiliarity with AWS Lambda, Step Functions, and event-driven dat a workflowsInfrastructure as Code usin g Terraform
Architecture & Engineeri ng PracticesSystems architecture thinking with experience designing microservices and data-layer i ntegrations.Knowledge of data mesh, domain-driven design, and/or data lake a rchitecture.Experience building and maintaining dat a pipelines.Proficient with Git and version-controlled database change management.Familiarity with .NET Framework, Java/JDBC, and/or Node.js for application integration.Experience working in Agile/Scrum teams using JIRA and
Confluence.Exposure to data governance, cataloging, and security bes t practices.Proficiency with AI-powered development tools (e. g., Claude).
Interested in this role?