Aurora PostgreSQL Database Specialist

4 weeks ago


Toronto ON, Canada Maarut Inc Full time

Resource Responsibilities

Ensure smooth and continuous operation of new and existing database performance and availability of the client’s database systems through:

  • Manage and maintain Aurora/Postgres databases on AWS.
  • Optimize database performance through configuration tuning, index optimization, and query optimization.
  • Implement and manage database backups, replication, and disaster recovery strategies.
  • Monitor database health and performance metrics, proactively identifying and resolving issues.
  • Collaborate with development and operations teams to design and implement database solutions that meet performance and scalability requirements.
  • Stay updated on AWS database technologies and best practices, recommending and implementing improvements as necessary.
  • Automate repetitive tasks and processes to improve efficiency and reliability.
  • Provide technical guidance and support junior members of the team.

Identify opportunities for improving service delivery methods and procedures; review with appropriate management staff and implement improvements; work with ITC and business users to maintain, revise or improve the overall reliability, availability and serviceability of the database systems and IT operations by:

  • Monitoring, considering risk and tuning databases to ensure optimal function in order to maintain the highest degree of database performance.
  • Reviewing, analyzing, and documenting logs, charts, diagrams and data to advise on and recommend application or system improvements.
  • Investigating cost saving opportunities, conducting research to refine, tune, modify and adjust different database technology products.
  • ​Assessing current database architecture setup and developing strategies to optimize database capacity and performance.

3. Create and maintain libraries of all database documentation for past and current projects. This includes database standards, policies and Problem Log Knowledge base with detailed problem description, resolution and root cause for incident tickets and service requests, user procedures manuals, technical references, standards, and guides.

4. Perform other related duties as assigned or required.

Requirements

Knowledge & Skills

  • Experience in managing and maintain Aurora/Postgres databases on AWS
  • Experience implementing and managing backups, restoration, replications, and snapshots
  • 10+ years hands of experience with SQL Server database administration
  • Hands-on experience with database troubleshooting
  • Proficient in creating technical documentations and providing knowledge transfer
  • Experience in Agile product development in Scrum or Kanban would be an asset
  • AWS certification(s) such as AWS Certified Database – Specialty would be an asset



  • Toronto, ON, Canada Amazon Full time

    Senior Software Developer, RDS Aurora PostgreSQL - 5+ years of non-internship professional software development experience - 5+ years of programming with at least one software programming language experience - 5+ years of leading design or architecture (design patterns, reliability and scaling) of new and existing systems experience - Experience as a mentor,...


  • Toronto, Ontario, Canada Amazon Full time

    DESCRIPTIONAre you interested in building hyper-scale database services in the cloud? Do you want to revolutionize the way databases are built for the cloud ? Do you want to have direct and immediate impact on hundreds of thousands of users who use AWS database services?Amazon Aurora is an exciting area of innovation for AWS, and the PostgreSQL-compatible...


  • Toronto, Canada AstraNorth Full time

    The AWS Aurora/Postgres Database Specialist with expertise will set up, maintain and monitor Aurora/Postgres database or other database systems, as required. **Knowledge & Skills** - 5+ years of experience in managing and maintain Aurora/Postgres databases on AWS - 5+ years of experience implementing and managing backups, restoration, replications, and...


  • Toronto, Canada Compest Solutions Inc Full time

    **Job title**: Database Administrator **Location**:Toronto, ON (On-site) **Max Rate CAD$39/hr on T4** **Job summary** **Required Skills**: **1.SQL DBA Administration** **2.PostgreSQL DB Administration** **3. Mongo DB Administration** Experience: 10 Years - Experience in Database Administration in **SQL Server (2012,2014, 2016, 2017)**: - Experience in...


  • Toronto, Ontario, Canada Aurora Cannabis Full time

    Master Data Specialist Division: IT Job location: Remote - Alberta, Ontario & Quebec Hours: 40 hours per week, Monday - Friday Employment type: Temporary employment (12-month contract) A little about us Hi, we're Aurora Cannabis, and we're so excited to meet you We're a global cannabis company with operations across Europe and North and South America....

  • Db Administration

    4 weeks ago


    Toronto, Canada Compest Solutions Inc Full time

    **Job title: DB Administration** **Toronto, ON (Hybrid)** **Rate CAD$55/hr on Inc** **Job summary**: **Experience 10+years** **SQL Server DB Administration, PostgreSQL DB, MongoDB** **Regards,** **Compest Solutions Inc** **D: 647-660-7562** **Job Type**: Fixed term contract Contract length: 12 months **Salary**: $50.00-$55.00 per hour Schedule: - 8...


  • Toronto, Canada Hays Full time

    Client: Insurance sector Role: Oracle DBAJob Type: 6 monthsRate: Open *depending on experienceLocation: One York, Waterloo King, Atria locations and even 2 two Quebec locations Your new CompanyOur client is a leading insurance, investment, and asset management companies in Canada. They cater to millions of customers across the world by providing a broad...


  • Toronto, Canada Hays Full time

    Client: Insurance sector Role: Oracle DBAJob Type: 6 monthsRate: Open *depending on experienceLocation: One York, Waterloo King, Atria locations and even 2 two Quebec locations Your new CompanyOur client is a leading insurance, investment, and asset management companies in Canada. They cater to millions of customers across the world by providing a broad...


  • Toronto, Canada Hays Full time

    Client : Insurance sector Role: Oracle DBA Job Type: 6 months Rate: Open *depending on experience Location: One York, Waterloo King, Atria locations and even 2 two Quebec locations Your new Company Our client is a leading insurance, investment, and asset management companies in Canada. They cater to millions of customers across the world by providing...


  • Toronto, Canada CGI Full time

    Insights you can act on While technology is at the heart of our clients’ digital transformation, we understand that people are at the heart of business success. When you join CGI, you become a trusted advisor, collaborating with colleagues and clients to bring forward actionable insights that deliver meaningful and sustainable outcomes. We call our...


  • Toronto, Canada Mevotech Full time

    Take your Career to the next Level with MEVOTECH. Mevotech is a trusted North American aftermarket auto parts leader that specializes in the engineering, design and distribution of driveline, steering and suspension parts (branded and private label). With over 600 Canadian and team members, we can attribute our continued success to the passion, spirit...


  • Toronto, Canada Alert Driving Full time

    Backend Application Developer - Job Description Position SummaryWe are currently looking for an experienced application developer who is well-versed in database-centric application development and will support the ongoing development of the company’s web-based software products and internally developed support systems. You have extensive experience...


  • Toronto, Canada Miller Thomson LLP Full time

    As a recognized national business law firm, we support, grow, and impact our communities through our work. We help entrepreneurs, companies, and professionals shape and build the Canadian economy. When you start a career with Miller Thomson, you join a firm that puts its people first. We provide the opportunity to influence the course of your career,...


  • Toronto, Canada Miller Thomson LLP Full time

    As a recognized national business law firm, we support, grow, and impact our communities through our work. We help entrepreneurs, companies, and professionals shape and build the Canadian economy. When you start a career with Miller Thomson, you join a firm that puts its people first. We provide the opportunity to influence the course of your career,...


  • Toronto, Canada Miller Thomson LLP Full time

    As a recognized national business law firm, we support, grow, and impact our communities through our work. We help entrepreneurs, companies, and professionals shape and build the Canadian economy.When you start a career with Miller Thomson, you join a firm that puts its people first. We provide the opportunity to influence the course of your career,...


  • Toronto, Canada Miller Thomson LLP Full time

    As a recognized national business law firm, we support, grow, and impact our communities through our work. We help entrepreneurs, companies, and professionals shape and build the Canadian economy.When you start a career with Miller Thomson, you join a firm that puts its people first. We provide the opportunity to influence the course of your career,...

  • Data Modeler

    6 days ago


    Toronto, Canada Tata Consultancy Services Full time

    **About TCS** TCS operates on a global scale, with a diverse talent base of more than 600,000 associates representing 153 nationalities across 55 countries. TCS has been recognized as a Global Top Employer by the Top Employers Institute - one of only eight companies worldwide to have achieved this status. Our organizational structure is domain-led and...


  • Toronto, Canada GalaxE.Solutions Full time

    What You Will Do Be responsible for the solution engineering, design, optimization, integration, automation, and maintenance of popular Google Cloud Platform (GCP) and Microsoft Azure (AZ) database PaaS services, such as Microsoft SQL Server, PostgreSQL, No-SQL and Redis. Provide R&D for introducing public cloud PaaS to TD environment, DevOps...


  • Toronto, ON, Canada TheGetch Full time

    Required Skills: Collaborative Development Contribute to the agile team goals by collaborating with other functional teams, actively participating in Scrum ceremonies and expanding the technical capabilities of the team. Lead the design and development of cost-effective and innovative solutions to meet business objectives while also maintaining...


  • Toronto, ON, Canada Eastlink Full time

    Designated office: 6080 Young Street, Halifax, NS This position is: Hybrid, at least 3 days per week in office Eastlink is a family owned, entrepreneurial and innovative company headquartered in Halifax, Nova Scotia. We take great pride in being a leader in delivering creative competitive, customer focused telecommunications solutions, and connecting...