PostgreSQL Database Administrator

1 week 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 Public and Business Service Delivery and Procurement Full time

    **Database Administrator**: **Job ID**: - 232009 **Posting status**: - Open **Organization**: - Ministry of Public and Business Service Delivery and Procurement **Division**: - GovTechON - Health Services I&IT Cluster / Emergency Health I&IT Solutions & Technology Management Branch **City**: - North York **Position(s) language**: - English **Job...

  • Administrator, Database

    2 weeks ago

    North York, Canada Vertex Financial Consulting Inc. Full time

    Education: Bachelor's degree - Experience: 3 years to less than 5 years **Tasks**: - Design and develop database - Design, construct, modify, implement and test data models and database management systems - Operate database management systems to analyze data - Develop and implement data administration policy, standards and models - Research and document...

  • Database / Edw Application Administrator

    7 days ago

    North York, Canada Tangerine Bank Full time

    **Requisition ID**: 151270 Tangerine is Canada’s leading direct bank. We offer flexible and accessible banking options, innovative products, and award-winning Client service. The reason why Tangerine employees come to work each day is to help Canadians live better lives. We focus on making a difference in our communities, and that includes our own...

  • Database Analyst

    2 weeks ago

    North York, Canada Superior Events Group Inc. Full time

    Durée de l'emploi: Permanent - Langue de travail: Anglais - Heures de travail: 30 to 40 hours per week - Education: - Expérience: - **Education**: - Bachelor's degree - Computer engineering, general - ** Asset languages**: - Spanish; Castilian - ** Work setting**: - Private company, corporation or industry - ** Tasks**: - Collect data to identify...

  • Database Manager

    2 weeks 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 Server Database Administrator

    1 week 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...

  • SQL Server Database Administrator

    7 days 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

    2 weeks 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...

  • Database Analyst

    7 days ago

    North York, Canada SunCan Communications Corporation Full time

    Work Term: Permanent - Work Language: English - Hours: 35 hours per week - Education: Bachelor's degree - Experience: 3 years to less than 5 years **Work setting**: - Consulting firm - Information technology (IT) service provider **Tasks**: - Collect data to identify areas for improvement within an organization's IT infrastructure - Develop and maintain...

  • Azure Cloud SQL Database Administrator

    2 weeks ago

    North York, Canada Uncharted Talent Inc. Full time

    **Location**: This is a hybrid position based in **North York, Toronto, Ontario**. **Key Responsibilities**: - **Azure PaaS Database Management**: Manage and support production SQL Server databases hosted on Azure PaaS, ensuring high availability, scalability, and performance. - **Cloud Optimization**: Utilize Azure cloud features (e.g., Azure Monitor,...