ABOUT THE COMPANY: Although well established, this global product company has all the hallmarks of a high growth start-up, with a unique business model. They have a team who love a challenge, are humble self- starters and who have exceptional skills in their field.
ABOUT THE ROLE: Playing a key role within the Cloud Services team, you will have a deep understanding of PostgreSQL and PL/SQL programming, along with experience in database design, development, and optimization. You will be responsible for building and maintaining robust database solutions that support their applications and enhance the data management capabilities.
RESPONSIBILITIES:
Design, develop, and maintain PostgreSQL databases and PL/SQL stored procedures, functions, and triggers.
Collaborate with software developers to integrate database solutions with application code.
Optimize queries and database performance, ensuring high availability and reliability.
Implement data modelling techniques and design schemas that meet business requirements.
Apply expertise in data modelling, SQL/NoSQL databases, data structures, and ETL processes to improve database setups and operations.
Handle large-scale data sets, both structured and unstructured, and develop an understanding of how to manage and utilize these resources effectively.
Manage and fine-tune PostgreSQL databases, focusing on performance, maintenance, and robust implementation across development and production environments.
Utilize CI/CD principles and DevOps methodologies within the database management lifecycle to enhance data delivery and operational efficiency.
Deliver robust data solutions and pipelines on the AWS Cloud Platform, optimizing database performance across various environments.
Conduct database migrations and upgrades as necessary.
Monitor and troubleshoot database issues, providing timely resolutions.
Experience with data integration tools, ETL frameworks, and data pipeline orchestration tools such as AWS Glue
Write and maintain technical documentation for database designs and processes.
Independently lead working sessions with technical and non-technical stakeholders to align database strategies with business objectives.
ABOUT YOU:
Bachelor’s degree in computer science, Information Technology, or related field.
8+ years of experience working in data Engineering and administrator role.
Minimum 2+ years of experience with snowflake as a cloud Datawarehouse and data lake service.
Proven experience as a Database Engine, with extensive knowledge of database technologies including PostgreSQL, SQL Server and particularly AWS database services.
Experience of Analyzing, integrating and interpreting large complex data from multiple sources.
Deep understanding of database security, backup and recovery, and cost optimization strategies.
Experience of implementing and delivering data solutions and pipelines on AWS Cloud Platform.
Strong hands-on experience with relational SQL and NoSQL databases, such as PostgreSQL, and cloud database services.
Knowledge of version control systems (e.g., Git) and Agile methodologies.
Hands on engineering of solutions and data pipelines utilizing CI/CD and automation.
Design and maintain testing processes and automation workflows for data feature changes, upgrades, and releases.
Build processes supporting data transformation, data structures, metadata, dependency and workload management.
WHAT’S IN IT FOR YOU:
Hybrid working – 2 days from home
Career development opportunities
Work for a global brand with awesome
WHAT'S NEXT? Don't miss out on this exciting opportunity. Please apply ASAP if you are based in NZ. Or, for more information, please contact Lisa Cooley on 021 029 81422 or lcooley@brightspark.io
