Database Administrator
Full Time
2+ Years
Canada
Job Description
We are seeking a skilled and detail-oriented Database Administrator (DBA) to join our IT team. As a Database Administrator, you will be responsible for the design, implementation, maintenance, and optimization of our database systems. This role presents an exciting opportunity for a professional with a strong understanding of database management to contribute to the efficiency and reliability of our data infrastructure.
Responsibilities
- Database Design and Implementation: Design and implement database structures that meet the organization's requirements, ensuring optimal performance and data integrity.
- Performance Tuning: Monitor and optimize database performance by identifying and addressing bottlenecks, improving query efficiency, and optimizing indexing.
- Data Security: Implement and maintain data security measures, including access controls, encryption, and regular security audits, to safeguard sensitive information.
- Backup and Recovery: Develop and implement backup and recovery strategies to ensure data availability and minimize downtime in the event of system failures.
- Database Maintenance: Perform routine database maintenance tasks, such as updates, patches, and data purges, to keep systems running smoothly.
- Database Documentation: Create and maintain comprehensive documentation of database configurations, processes, and procedures.
- Collaboration: Collaborate with developers, system administrators, and other IT professionals to ensure seamless integration of database systems with other components.
- Troubleshooting: Identify and resolve database-related issues, conduct root cause analysis, and implement preventive measures to avoid future problems.
Skills Required
- Education: Bachelor's degree in Computer Science, Information Technology, or a related field. Relevant certifications such as Oracle Certified Professional (OCP) or Microsoft Certified: Azure Database Administrator Associate are highly desirable.
- Experience: Minimum of 3-5 years of professional experience in database administration, with a proven track record of managing and optimizing diverse database environments.
- Technical Skills: Proficient in database management systems such as MySQL, PostgreSQL, Oracle, or Microsoft SQL Server. Experience with database design, implementation, and optimization. Strong knowledge of database security best practices. Familiarity with cloud database services (e.g., AWS RDS, Azure SQL Database).
- Scripting and Automation: Proficient in scripting languages (e.g., SQL, PowerShell) to automate routine tasks and improve operational efficiency.
- Problem-Solving Skills: Strong analytical and problem-solving skills to troubleshoot database issues and optimize performance.
- Communication Skills: Excellent communication skills to convey complex technical concepts to both technical and non-technical stakeholders.
- Collaboration: Ability to work effectively within a team and across departments to ensure the optimal performance of database systems.
- Adaptability: Capability to adapt to evolving technologies, industry best practices, and organizational needs.
We have cool benefits support you
- Competitive Compensation: We offer a competitive salary and benefits package to recognize and reward your expertise and contributions to our data infrastructure.
- Health and Wellness: Comprehensive health and wellness benefits, including medical, dental, and vision coverage.
- Professional Development: Opportunities for ongoing professional development, including attending database conferences, workshops, and obtaining certifications.
- Flexible Work Arrangements: We understand the importance of work-life balance and offer flexible work arrangements to support your well-being.
- Cutting-Edge Projects: Work on projects that challenge and inspire you, allowing you to showcase your database administration skills.
- Collaborative Environment: Join a collaborative and inclusive work environment where your database expertise contributes to the success of our IT initiatives.
- Career Growth: A supportive environment that encourages career growth and provides opportunities for advancement within the organization.
- Innovation: Be part of a team that values innovation, encourages new ideas, and embraces the latest technologies to optimize our data infrastructure.