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 PythonNice to Have Skills & Experience- Experience using Bash for scripting - Knowledge of database modeling (both relational and non- relational)Job DescriptionInsight 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
Job Title
Database Administrator