PostgreSQL Database Developer-W2

PostgreSQL Database Developer-W2

Posted 1 day ago by 1761837083

Apply
Negotiable
Outside
Remote
USA
Apply
.NET Framework Amazon Aurora Amazon Web Services (AWS) Artificial Intelligence Atlassian Confluence Automation AWS Lambda Business Intelligence Cloud Computing Cloud Database Cloud Technology Data Governance Data Infrastructure Data Integrity Data Management Domain Driven Design Front End (Software Engineering) Git (Version Control System) Github Infrastructure as Code (IaC) JIRA Management Microservices Microsoft 365 Microsoft Office Microsoft Visio Node.js Nodes (Networking) Operational Databases Performance Tuning PostgreSQL Software Development SQL (Programming Language) Terraform User Interface Web Applications

Summary: The PostgreSQL Database Developer role focuses on designing and implementing scalable databases while enhancing performance and modernizing data infrastructure using AWS and microservices. The position requires collaboration with Business Intelligence teams to drive analytics and reporting capabilities, as well as ensuring data integrity and security. The developer will also be responsible for gathering user requirements and providing data management support. This role emphasizes continuous improvement and the integration of AI and automation in database development.

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

Primary Duties and Responsibilities

  1. Design and implement scalable, high-performance databases
  2. Continuously improve database performance
  3. Modernize Data Infrastructure (AWS Cloud native, Microservices, event-driven architecture)
  4. Drive analytics and reporting capabilities, working along with Business Intelligence teams
  5. Accelerate development with AI & automation
  6. Enable data microservices architecture
  7. Ensure data integrity and security (Data Governance)
  8. Gather user requirements and identify new features
  9. Liaise with developers to improve applications and implement best practices
  10. Develop technical and training manuals
  11. Provide data management support to users
  12. 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).
Apply
Similar Jobs
Loading data...