Company Description
dynaCERT is an innovative energy sector company based in Toronto, ON, specializing in Carbon Emission Reduction Technologies. The company has developed HydraGEN™ Technology that reduces fuel consumption and emissions while increasing engine performance and efficiency. With proven results and a focus on sustainability, dynaCERT is expanding its presence in various industries globally, including rail, marine, oil/gas, mining, and stationary generators.
Role Description
This is a Database Administrator Co-op/Internship role located on-site in Toronto, ON. The Database Administrator will be responsible for database design, troubleshooting, maintenance, and replication tasks. Day-to-day duties include ensuring database optimization, managing user access, and monitoring database performance to support dynaCERT's technological advancements.
Key Responsibilities
- Database Management: Install, configure, and maintain relational databases.
- Performance Optimization: Monitor and optimize database performance, including indexing, query optimization, and database tuning to ensure peak performance.
- Database Maintenance: Perform routine database maintenance tasks such as updates, patching, and cleanup of unused or obsolete data.
- Troubleshooting & Issue Resolution: Identify, troubleshoot, and resolve database performance issues, corruption, and other system errors.
- Data Recovery: Implement disaster recovery plans and conduct regular tests of backup systems to ensure timely recovery of critical data.
- Collaboration & Support: Work closely with developers, system administrators, and other IT teams to design and deploy new database systems, applications, and features.
- Documentation: Maintain thorough documentation for all database systems, including design, configuration, backups, and performance monitoring.
- Compliance & Auditing: Ensure that database systems comply with regulatory requirements, corporate policies, and best practices.
- Capacity Planning: Forecast future database growth and ensure systems are scalable to handle increased loads.
Skills & Qualifications:
- Technical Skills: Proficiency in SQL, database management tools, and database administration across various platforms.
- Experience: Minimum of 1 year of experience as a Database Administrator or in a related role.
- Database Performance: Knowledge of database optimization, indexing strategies, and query tuning.
- Problem-solving: Strong troubleshooting skills for complex database issues.
- Scripting Languages: Experience with scripting languages (e.g., Python, Bash) for automation and database management tasks is a plus.
- Security: Familiarity with database security best practices, including user roles, permissions, and encryption techniques.
- Communication Skills: Good written and verbal communication skills, with the ability to explain technical issues to non-technical stakeholders.
- Certifications: Database certifications are a plus.
- Educational Background: Bachelor’s degree in Computer Science, Information Technology, or a related field.
