Sr PostgreSQL Developer
Posted 2 days ago by 1762334921
Negotiable
Outside
Remote
USA
Summary: The role of Senior PostgreSQL Developer involves designing and implementing scalable databases, enhancing performance, and modernizing data infrastructure within AWS environments. The position requires collaboration with Business Intelligence teams to drive analytics and reporting capabilities while ensuring data integrity and security. Candidates should possess extensive experience with PostgreSQL and AWS Redshift, along with a strong understanding of data management and microservices architecture. This is a remote position with a tentative duration of 6 to 12 months.
Key Responsibilities:
- Design and implement scalable, high-performance databases
- Continuously improve database performance
- Modernize Data Infrastructure (AWS Cloud native, Microservices, event-driven architecture)
- Drive analytics and reporting capabilities, working along with Business Intelligence teams
- Accelerate development with AI & automation
- Enable data microservices architecture
- Ensure data integrity and security (Data Governance)
- Gather user requirements and identify new features
- Liaise with developers to improve applications and implement best practices
- Develop technical and training manuals
- Provide data management support to users
- Research and suggest new database products, services and protocols
Key Skills:
- Proven work experience as a senior PostgreSQL Database Developer, including pgplsql.
- Demonstrated expertise in diagnosing and resolving operational database challenges.
- Proven experience in implementing continuous improvement initiatives to drive optimization.
- Writing complex SQL statements and performance tuning.
- Knowledge of AWS Redshift, Lambda, step functions, and Infrastructure as Code using Terraform, is highly desirable.
- Knowledge of Amazon Aurora and no-SQL databases is a plus.
- Experience working with data pipelines.
- In-depth understanding of data management (e.g. permissions, recovery, security and monitoring).
- Experience using AWS RDS to manage and monitor cloud-based database hosts.
- System architecture thinking.
- Proficient with git.
- Experience with data mesh, domain-driven design, and/or data lake architecture.
- Strong problem solving and troubleshooting ability under tight deadlines.
- Excellent communication skills.
- Knowledge of software development and user interface web applications.
- Familiarity working with .Net Framework, Java/JDBC, and Node.js.
- Excellent analytical and organizational skills.
- Attention to detail.
- An ability to understand front-end user requirements and a problem-solving attitude.
- Excellent verbal and written communication skills, interpersonal skills.
- Experience working in Agile/Scrum Methodology.
- Experience with JIRA, Confluence, Visio, and Microsoft Office applications.
- Proficiency using AI-powered tools (e.g., GitHub Copilot, ChatGPT).
Salary (Rate): undetermined
City: undetermined
Country: USA
Working Arrangements: remote
IR35 Status: outside IR35
Seniority Level: undetermined
Industry: IT
Remote - EST hours
Tentative Duration - 6 - 12 months
Also mentioned Jira and Terraform as important and if they have Aurora PostgreSQL that is a huge plus.
They are currently seeking a Senior Database Developer with AWS Redshift and PostgreSQL experience.
Primary Duties and Responsibilities
- Design and implement scalable, high-performance databases
- Continuously improve database performance
- Modernize Data Infrastructure (AWS Cloud native, Microservices, event-driven architecture)
- Drive analytics and reporting capabilities, working along with Business Intelligence teams
- Accelerate development with AI & automation
- Enable data microservices architecture
- Ensure data integrity and security (Data Governance)
- Gather user requirements and identify new features
- Liaise with developers to improve applications and implement best practices
- Develop technical and training manuals
- Provide data management support to users
- Research and suggest new database products, services and protocols
Skills
- Proven work experience as a senior PostgreSQL Database Developer, including pgplsql.
- Demonstrated expertise in diagnosing and resolving operational database challenges.
- Proven experience in implementing continuous improvement initiatives to drive optimization.
- Writing complex SQL statements and performance tuning.
- Knowledge of AWS Redshift, Lambda, step functions, and Infrastructure as Code using Terraform, is highly desirable.
- Knowledge of Amazon Aurora and no-SQL databases is a plus.
- Experience working with data pipelines.
- In-depth understanding of data management (e.g. permissions, recovery, security and monitoring).
- Experience using AWS RDS to manage and monitor cloud-based database hosts.
- System architecture thinking.
- Proficient with git.
- Experience with data mesh, domain-driven design, and/or data lake architecture.
- Strong problem solving and troubleshooting ability under tight deadlines.
- Excellent communication skills.
- Knowledge of software development and user interface web applications.
- Familiarity working with .Net Framework, Java/JDBC, and Node.js.
- Excellent analytical and organizational skills..
- Attention to detail.
- An ability to understand front-end user requirements and a problem-solving attitude.
- Excellent verbal and written communication skills, interpersonal skills.
- Experience working in Agile/Scrum Methodology.
- Experience with JIRA, Confluence, Visio, and Microsoft Office applications.
- Proficiency using AI-powered tools (e.g., GitHub Copilot, ChatGPT).
Preferred Education Requirements
- B.S., M.S., in software engineering, computer science, or related area or equivalent experience.
Preferred Experience
- Minimum 10+ years of database development, mostly in Postgres environments, highly preferred.
Physical Requirements / Work Environment
The work environment characteristics and physical demands described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
- Ability to regularly sit for extended periods of time.
- Physically able to attend meetings, presentations, and training sessions.
- Perform repetitive motion type tasks.
- Ability to work on-site as requested in a team environment.