[Hiring] PostgreSQL Developer @System Soft Technologies

Role Description

We're seeking a Senior Database Developer with deep PostgreSQL expertise and strong AWS experience to help shape the future of our enterprise data architecture. This is an opportunity to lead critical database initiatives, build cloud-native solutions, and collaborate with engineering teams to deliver high-performance applications and analytics platforms.

Please Note: This is a database development role, not a Database Administrator (DBA) position. Candidates whose experience is primarily DBA-focused will not be considered.

Location Requirements: Candidates must currently reside in one of the following states:

• Ohio
• Michigan
• Indiana
• Illinois
• Tennessee
• Texas
• Colorado
• Montana
• Rhode Island
• Florida
• Massachusetts
• Nevada

Work Authorization Required: U.S. Citizen or Green Card Holder

What You'll Do

• Design, develop, optimize, and modernize enterprise database solutions that support mission-critical products, analytics, and operational systems.

Database Development & Performance

• Architect and develop scalable, high-performance PostgreSQL database solutions
• Write and optimize complex SQL and PL/pgSQL stored procedures, functions, and triggers
• Analyze query execution plans and implement performance tuning strategies
• Improve database reliability, scalability, and availability
• Lead PostgreSQL, Aurora, and Redshift version upgrades and modernization efforts

Cloud & Data Engineering

• Manage and optimize AWS database environments, including Aurora PostgreSQL and Redshift
• Design and maintain data pipelines supporting operational and analytical workloads
• Build Infrastructure as Code (IaC) solutions using Terraform
• Contribute to data lake, data mesh, and cloud-native architecture initiatives
• Support event-driven data solutions leveraging AWS services

Collaboration & Technical Leadership

• Partner with software engineers to improve data access patterns and application performance
• Translate business requirements into scalable database solutions
• Establish database engineering best practices and governance standards
• Support data security, auditing, compliance, and access controls
• Mentor teams and provide technical guidance across the organization

Qualifications

• 10+ years of database development experience
• 5+ years of hands-on PostgreSQL development experience
• Advanced expertise in SQL, PL/pgSQL, query tuning, and database optimization
• Experience with Amazon Aurora (PostgreSQL-compatible)
• Experience with Amazon Redshift and analytical data platforms
• Strong understanding of database architecture and performance engineering
• Experience building and maintaining data pipelines
• Infrastructure as Code experience using Terraform

Preferred Technical Skills

• AWS Lambda, Step Functions, and event-driven architectures
• NoSQL technologies such as DynamoDB or MongoDB
• Data lake and data mesh architectures
• Microservices and distributed systems design
• Git-based development and database change management
• .NET, Java/JDBC, or Node.js integration experience
• Agile/Scrum methodologies, JIRA, and Confluence
• Data governance, cataloging, and security best practices
• AI-assisted development tools such as Claude

Professional Qualities

• Strong analytical and problem-solving abilities
• Excellent communication and collaboration skills
• Ability to work effectively across technical and business teams
• Highly organized with exceptional attention to detail
• Passion for continuous improvement and modern data engineering practices

Education

• Bachelor's or Master's degree in Computer Science, Software Engineering, or a related technical discipline preferred.