Senior Postgres Developer
- Employer
- Trinity Consulting Services, EA Licence No: 15C7547
- Location
- Singapore, Singapore
- Salary
- 10000
- Closing date
- Jul 27, 2022
View more
- Job Function
- Other
- Industry Sector
- Finance - General
- Employment Type
- Full Time
- Education
- Bachelors
You need to sign in or create an account to save a job.
Responsibilities
Must possess a strong background on the following technologies/skills :
- 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.
You need to sign in or create an account to save a job.
Sign in to create job alerts
Sign in or create an account to start creating job alerts and receive personalised job recommendations straight to your inbox.
Create alert