Senior Postgres Developer

Employer
Trinity Consulting Services, EA Licence No: 15C7547
Location
Singapore, Singapore
Salary
10000
Posted
Jun 17, 2022
Closes
Jul 17, 2022
Ref
14962174
Job Function
Other
Industry Sector
Finance - General
Employment Type
Full Time
Education
Bachelors
Responsibilities
  • Design, Develop, Test, Deploy and administer Postgre Database on Cloud infrastructure, with a focus on the performance, high availability and scale.
  • Collaborate with Technical Chapter Lead, architecture, and release teams, providing architectural design recommendations, driving standards for set up of Postgres
  • Administration of PostgreSQL databases throughout the development and production lifecycles.
  • Develop and maintain database monitoring tools and automation systems
  • Implement automated methods and industry best practices for consistent installation and configuration of PostgreSQL for production and non-production environments
  • Efficiently write database code without compromising data quality, privacy or security. Ensure code reviews are conducted.
  • Provide support during SIT, UAT roll-out and post-production whenever needed.
  • Ensure the project timelines are met within budget and with good quality.
  • Ensure the standards per the Wealth management governance are followed at all times.
  • Ensure all aspects of security are respected at all times during the course of work.

Must possess a strong background on the following technologies/skills :
  • Reporting Analytics Database Platform experience creating extracting, transforming, loading, and enhancing objects to ingest structured, semi-structured, and unstructured data sources; implementing, maintaining and optimizing data warehouses; and/or gathering and implementing user requirements.
  • Extensive Experience writing and executing scripts or programs using programming languages (SQL or Python) to manipulate - Store data in PostgreSQL & Oracle.
  • Experience with all complex data models & database script across all database object types - tables, views, procedures, functions, triggers
  • Having a good understanding of Data Warehousing architectural design principles and Data Storage Model approach covering Stage, Raw, Refined, History & Schema Evolution
  • Having a good understanding of Dimensional Modelling design covering optimized, Transformed, Facts & Dimensions
  • Basic Knowledge & Experience in Data Integration tool ETL & ELT - Informatica, Apache Nifi extraction (API, Kafka, Direct) & Spark based transformation
  • Working experience on Agile Methodology & DataOps tools like JIRA, Jenkins, BitBucket, Serena, Autosys
  • Working knowledge of Unix / Linux operating system
  • Experience in collaborating with software engineers/teams to solve complex application problems
  • Good communication and collaboration skills
  • Good understanding of Wealth Management Products is a plus.

Similar jobs

Similar jobs