Database Administrator

Required Skills & Experience

• 5-10 years of experience in a related field or as a Database Administrator (DBA) - Hands-on experience with SQL Server and PostgreSQL - Experience with Amazon Redshift and Amazon DynamoDB - Proven experience working in an AWS environment - Strong proficiency in SQL and Python

Nice to Have Skills & Experience

Job Description

Insight Global is looking for a Database Administrator to join a leading Courier and Logistics customer in Mississauga. This is a hybrid role and requires a commitment of 3x / week on site Mississauga. The ideal candidate will be responsible to assist with design, development, implementation, and maintenance of multi-platform database solutions. Working closely with cross-functional teams to ensure optimal database performance, security, scalability, and reliability to support our organization's ever evolving, complex data needs. Roles / Responsibilities : 1. Database Development and Design : - Design, implement, and optimize database systems in a multi-technology environment - Develop efficient database schemas, structures, and indexing strategies to support business applications 2. Performance Optimization : - Monitor and enhance database performance, scalability, and availability - Identify bottlenecks and implement strategies for efficient query optimization and tuning 3. Cloud Integration : - Collaborate with DevOps and cloud infrastructure teams to deploy and manage database solutions - Utilize cloud-native tools for monitoring, automation, and cost optimization 4. Data Security and Compliance : - Implement security measures to safeguard sensitive data - Ensure databases comply with regulatory and organizational standards Additional Responsibilities 5. Collaboration and Support : - Work with application developers to integrate databases with front-end and back-end applications - Provide support for database-related issues, troubleshooting, and incident resolution - Monitor Incident and request queue and support change management processes 6. Automation and CI / CD : - Build and maintain database CI / CD pipelines to streamline development and deployment processes - Leverage Infrastructure as Code (IaC) tools like Terraform or CloudFormation for database provisioning 7. Documentation and Reporting : - Maintain up-to-date documentation for database structures, configurations, and processes - Generate reports and dashboards for stakeholders as required