PostgreSQL Database Administrator

7 days ago

York street NSW Sydney Australia, Canada Darumatic Full time

Location: Sydney, NSW Remote work available? Hybrid Rate: Great rate on offer for a suitable candidate

About Us   
Darumatic is an IT Consultancy and Recruitment Services Company that focuses on cloud native technologies and software development. Our mission is to help clients to "Build better software".
We are passionate about working with clients to transform their development and infrastructure teams to become cloud-native. Our supportive culture will open up a variety of opportunities for you to develop your knowledge and skills whilst providing opportunities to connect with a range of IT professional networks. We believe in mutually beneficial professional working relationships and your employment with us is no exception.

About the Role Our client is currently seeking a Database Administrator to join our team. The primary role of the Database Administrator is managing Database management of the Clearing applications utilising Postgres and/or MS-SQL DB technologies including performing administration, configuration, installation, maintenance, tuning, and support of the database environments. This position will be within a team of existing DBAs that cover Postgres and SQLServer.

Responsibilities:
  • Responsible for ensuring availability and performance of the Clearing database environment.
  • Manage non-production, production and disaster recovery database environments.
  • Works closely with support team colleagues to ensure that the associated hardware resources for the database environment are configured for optimum performance and availability.
  • Proactively monitors database environment to ensure minimum downtime.
  • Provides regular trend analysis to track database performance and throughput, for capacity planning purposes.
  • Responsible for enhancements, maintenance and upgrades to the database environment.
  • Works with business, architecture, development and technical colleagues to manage and implement changes.
  • Carries out analysis of potential hardware problems prior to contacting third-party support.
  • Ensures all system and application changes are approved via the appropriate Change Control methods.
  • Develop and maintain runbooks for High Availability and Disaster Recovery tests and is responsible for planning and running these tests.
  • Handle the implementation of the bank clearing's business applications running in development, test and production environments.  This will include installation of applications, releases and patch management as well as upgrades.
  • Work with the architecture team to provide technical expertise to define and implement a global infrastructure to support existing and future projects.
  • Provide database expertise to the development team (internal and external) regarding development around database technology, covering deployment best practice and configuration for AAC Clearing applications.

 Skills & Experience:
  • Expert Postgres Enterprise and/or Community knowledge.
  • Red Hat Cluster experience, preferred in use of Postgres Databases.
  • Extensive experience implementing and supporting streaming replication between different sites
  • Strong implementation and support experience of SQL and Postgres (e.g .PGPool, PGBouncer, PEM, DRITA, Failover Manager, Data Adapters, Replication Server, Migration Toolkit).
  • Must have a strong understanding of the architectural and operational complexities of solutions deployed within a Postgres and MS-SQL environments
  • RAC,rman,ASM,DG broker,Performance analysis
  • High level Linux administration skills
  • Experience with OEM
  • Engineered systems experience (Exadata and ODA)
  • PostgresSQL (locted on RHEL)
  • Strong SQL PL/SQL skills
  • Migration from non-cdb to cdb
  • Configuration and support of TDE
  • Bash / Python scripting
  • Capacity management
  • Automation Experience

Essential Requirements:

Expert SQL/Postgres DBA (minimum 8 year's experience)


  • Database Administrator

    2 weeks ago

    North York, Canada Ministry of Health Full time

    The Health Services I&IT Cluster, Emergency Health I&IT Solutions & Technology Management Branch is seeking a Database Administrator to provide strategic data resource management. **OPS Commitment to Diversity, Inclusion, Accessibility, and Anti-Racism**: We are committed to build a workforce that reflects the communities we serve and to promote a diverse,...

  • Database Administrator

    2 weeks ago

    North York, Canada Ministry of Health Full time

    The Health Services I&IT Cluster, Emergency Health I&IT Solutions & Technology Management Branch is seeking a Database Administrator to provide strategic data resource management. **OPS Commitment to Diversity, Inclusion, Accessibility, and Anti-Racism**: We are committed to build a workforce that reflects the communities we serve and to promote a diverse,...

  • Oracle Database Administrator

    1 week ago

    north york, Canada Hays Full time

    Job Posting Title: APPLICATION DEVELOPERContract length: - 8 months (Possible Extension)Location: North York (2 – 3 days Hybrid (3389, Steeles Avenue East, North York, ON)) Description:Install, configure, and upgrade Oracle databases and related tools.Perform database administration tasks including backup, recovery, and disaster recovery planning.Monitor...

  • Oracle Database Administrator

    1 week ago

    North York, Canada Hays Full time

    Job Posting Title: APPLICATION DEVELOPER Contract length: - 8 months (Possible Extension) Location: North York (2 - 3 days Hybrid (3389, Steeles Avenue East, North York, ON Description: Install, configure, and upgrade Oracle databases and related tools. Perform database administration tasks including backup, recovery, and disaster recovery planning. Monitor...

  • Database Manager

    6 days ago

    North York, Canada Ontario Society of Occupational Therapists Full time

    Durée de l'emploi: Permanent - Langue de travail: Anglais - Heures de travail: 35 hours per week - Education: - Expérience: - **Education**: - Bachelor's degree - ** Work setting**: - Associations and non profit organizations - ** Tasks**: - Collect data to identify areas for improvement within an organization's IT infrastructure - Develop and...

  • SQL Database Administrator

    1 week ago

    North York, Canada Uncharted Talent Inc. Full time

    We're seeking an experienced **SQL Server Database Administrator** with strong **Azure PaaS** expertise to manage and optimize our production databases in the cloud. This hybrid role is based in **North York, Toronto**. **What You’ll Do**: - Manage and support SQL Server databases on **Azure PaaS**: - Leverage **Azure Monitor, Automation, and SQL...

  • SQL Server Database Administrator

    18 hours ago

    North York, Canada Uncharted Talent Inc. Full time

    **Key Responsibilities**: - Maintain and support production SQL Server PaaS databases, ensuring high availability and performance. - Implement and manage database partitioning strategies for large tables in live environments. - Optimize and reduce the number of indexes on high I/O tables based on usage analysis. - Perform query plan analysis and maintenance...

  • Database Analyst

    6 days ago

    North York, Canada SunCan Communications Corporation Full time

    Work Term: Permanent - Work Language: English - Hours: 40 hours per week - Education: Bachelor's degree - Experience: 2 years to less than 3 years **Work setting**: - Consulting firm - Server farm **Tasks**: - Collect and document user's requirements - Data Science - Design and develop database - Design, construct, modify, implement and test data models...

  • Administrative Clerk Financial Incentive Program Administrator

    2 weeks ago

    Sydney, Nova Scotia, Canada Sereneaid Full time

    Job Title: Journeyperson Financial Incentive Program AdministratorLocation: Sydney, Nova Scotia (Onsite/Hybrid as required)Client: Government of Nova ScotiaType: ContractHours: Monday–Friday (Standard Business Hours)Project OverviewThe Government of Nova Scotia is implementing the Journeyperson Financial Incentive Program to support and accelerate growth...

  • General Administrator

    2 weeks ago

    Sydney, New South Wales, Canada UNSW Full time

    The OpportunityThe Faculty of Engineering has a continuing (permanent) position for a General Administrator located in the School of Electrical Engineering and Telecommunications. This continuing position supports the school and faculty by delivering efficient day-to-day administrative services. Key responsibilities include acting as the first point of...