Aurora PostgreSQL Database Specialist

3 weeks ago


East York, Canada Maarut Inc Full time
Resource Profile
  • The AWS Aurora/Postgres Database Specialist with expertise will set up, maintain and monitor Aurora/Postgres database or other database systems, as required.


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, recommeWSnding 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.




RequirementsKnowledge & 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

Skillset
  • 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 and/or Azure Synapse database administration
  • Hands-on experience with database troubleshooting
  • Excellent communication and interpersonal skills




  • North York, 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...

  • Advocacy Specialist

    4 weeks ago


    East York, Canada March of Dimes Canada Full time

    Would you like to work for a not-for-profit organization that is dedicated to maximizing the independence and community participation of people with disabilities across Canada? Would you like to play a role in advocating for inclusion and equity for all people living with disabilities? March of Dimes Canada (MODC) is a federally registered national charity...


  • North York, Canada Molisana Imports Full time

    **About us** We are professional, agile and innovative. Our work environment includes: - Modern office setting - Growth opportunities We are a leading company in the importing and food distribution industry We are hiring an experienced Accounting Specialist. If you're dedicated and ambitious, we offer an excellent place to grow your career. Don't...

  • QA Specialist

    5 days ago


    North York, Canada ydc pro Inc Full time

    Hi All, We are Hiring for **QA Specialist ** position for **Toronto** Location Work type: Contact and Hybrid **Preferred Ministry Exp** Exp: 5+ Years MUST HAVES: - MANUAL TESTER At least 3+ years of experience as a **Functional tester for large scale enterprise systems **undergoing transformation or being built from scratch. - Knowledge and experience...


  • North York, Canada Rogers Communications Full time

    At Rogers, we are committed to helping Canadians bridge the digital divide and ensure that no one is left behind in accessing reliable connectivity. Through our Service Expansion projects, we are proud to bring our wireless and internet service to homes and businesses across the country to connect them to the people and things that matter most. Our rapidly...


  • North York, Canada TFS-Canada's International School TFS-l'École internationale du Canada Full time

    **Position**: Advancement Services Specialist **Position Type**: Permanent contract, full time, Monday to Friday **Location**: Toronto campus - 306 Lawrence Avenue East, Toronto, Ontario, M4N 1T7 **Branch**: TFS Fondation **Start Date**: Immediately **About the Position**: The Advancement Services Specialist oversees the information management and...

  • Payroll Specialist

    4 weeks ago


    North York, Canada Toronto Wildlife Centre Full time

    **Payroll Specialist** **Work Status**:Part-time/Flexible hours, 1 Year Contract with possibility of permanent **Reports to**:Finance Manager **Location**:Currently located in Downsview Park with plans to move to the Rouge National Urban Park - with possibility of some remote work **Start Date**:Immediately **Compensation**:Commensurate with...

  • Etl Manager

    4 weeks ago


    North York, Canada RPS Real Property Solutions Inc. Full time

    **ETL Manager** **About this role**: This role will bring value by helping to architect, build and maintain large data pipelines that transform data into RPS standard format. From input, consumption, and output, you will be a key contributor to the end-to-end design and implementation of RPS data requirements **Accountabilities**: - Help scale IT...


  • North York, Canada Flemingdon Health Centre Full time

    **Job Posting** **Title**: Decision Support Specialist **Employment Terms**: Regular full-time (35 hours/week) evening and weekend hours can be expected **Salary Range**: $65,104 - $76,905 per year along with extended health benefits and HOOPP pension plan **Expected Start Date**: Immediately **Reporting To**: Manager, integrated services and care...


  • North York, Canada Ministry of Health Full time

    The Corporate I+IT Solutions & Integration Management division is looking for a Data Integration Specialist with a track record delivering system and data interfacing strategies, standards and technology deployments. We are looking for someone who is business-focused and who has experience working with stakeholders in complex on-premise and on-cloud...


  • North York, Canada TLN Media Group Full time

    If you are excited by the prospect of supporting a dynamic team in television media, in addition to playing a pivotal role in representing Canada’s most influential multicultural media organization, then this is the job for you! **About the Role** The Marketing & Communications Specialist will be responsible for implementing and coordinating all...


  • North York, Canada Dawn InfoTek Inc. Full time

    Dawn InfoTek Inc. is a professional IT consulting team that partners with major financial institutions, investment firms and government sectors. We have been dedicated to delivering cutting-edge consulting services and recruiting all levels of IT positions for our clients. We are currently seeking competent individuals to fulfill the role of **Business...


  • North York, Canada Teknion Limited Full time

    **Elevator Speech**: This role has an exciting ‘start-up’ feel within a secure, long tenure environment. The Graphical Asset Specialist will collaborate with other team members and with key Teknion personnel to ensure all the data is complete, accurate and help to resolve issues. The Specialist will build new and improve existing CAD symbols (digital...


  • Caledon East, Canada UNITED PARCEL SERVICE Full time

    **Primary Job Posting Location**: Caledon, Ontario Canada Explore your next opportunity at a Fortune Global 500 organization. Envision innovative possibilities, experience our rewarding culture, and work with talented teams that help you become better every day. We know what it takes to lead UPS into tomorrow—people with a unique combination of skill +...

  • EHS Manager

    4 weeks ago


    North York, Canada Estee Lauder Full time

    *** Responsible for collaborating on the strategic direction & standards for the facility's and Company's EHS programs. Provides technical EHS expertise to the facility. Ensures compliance with all regulatory and Company Environmental and Safety Management System requirements. **KEY ROLES AND RESPONSIBILITIES** - 25% - Accident/Injury Prevention:...


  • North York, Canada One Team Health Inc Full time

    One Team Health, a subsidiary of Argus Group Holdings Limited, is currently seeking a Business Application Specialist. This role will assist the Business Solutions Team lead with overseeing the operations by managing the implementation of business technology solutions to facilitate effective change management and business transformation. An approachable...


  • North York, Canada Seneca College of Applied Arts and Technology Full time

    External Posting Date: **March 24, 2023** - External Closing Date: **April 6, 2023** - Pay Range: **Payband J - $39.15 - $45.38 (Start rate: $39.15)** - Hours: **35 hours per week (overtime as required)** - Work Type: **Hybrid** - Type: **Permanent** - Shift: **Monday to Friday, 9:00AM to 5:00PM** - Ideal Start Date: **4/17/23** - End Date: **Position...

  • EHS Manager

    6 days ago


    North York, Canada The Estée Lauder Companies Full time

    **WHO WE ARE** **Our Brands**:The Estée Lauder Companies Inc. is one of the world’s leading manufacturers and marketers of quality skin care, makeup, fragrance and hair care products. The company’s products are sold in approximately 150 countries and territories under brand names including: Estée Lauder, Aramis, Clinique, Prescriptives, Lab Series,...


  • North York, Canada The Estée Lauder Companies Full time

    **WHO WE ARE** **Our Brands**:The Estée Lauder Companies Inc. is one of the world’s leading manufacturers and marketers of quality skin care, makeup, fragrance and hair care products. The company’s products are sold in approximately 150 countries and territories under brand names including: Estée Lauder, Aramis, Clinique, Prescriptives, Lab Series,...


  • North York, Canada Estée Lauder Full time

    WHO WE ARE **Our Brands**: The Estée Lauder Companies Inc. is one of the world’s leading manufacturers and marketers of quality skin care, makeup, fragrance and hair care products. The company’s products are sold in approximately 150 countries and territories under brand names including: Estée Lauder, Aramis, Clinique, Prescriptives, Lab Series,...