Aurora PostgreSQL Database Specialist
3 weeks ago
- 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.
- 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
- 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
-
Senior Database Java Developer
3 weeks ago
North York, Canada Alert Driving Full timeBackend 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 timeWould 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...
-
Accounting Specialist
7 days ago
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 timeHi 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...
-
Implementation Specialist
4 weeks ago
North York, Canada Rogers Communications Full timeAt 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...
-
Advancement Services Specialist
4 weeks ago
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...
-
Decision Support Specialist
4 weeks ago
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...
-
Data Integration Specialist
1 week ago
North York, Canada Ministry of Health Full timeThe 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...
-
Marketing & Communications Specialist
4 weeks ago
North York, Canada TLN Media Group Full timeIf 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...
-
Business Intelligence Specialist
5 days ago
North York, Canada Dawn InfoTek Inc. Full timeDawn 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...
-
Graphical Asset Specialist
4 weeks ago
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...
-
Human Resources Contract Specialist
4 weeks ago
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:...
-
Business Application Specialist
4 weeks ago
North York, Canada One Team Health Inc Full timeOne 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...
-
International Student Immigration Specialist
4 weeks ago
North York, Canada Seneca College of Applied Arts and Technology Full timeExternal 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,...
-
Environmental Health and Safety Manager
4 weeks 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,...
-
Environmental Health and Safety Manager
4 weeks ago
North York, Canada Estée Lauder Full timeWHO 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,...