Job Title: Database Analyst
Location: Toronto, ON (Hybrid)
Estimated Duration: 12 Months
About the Role:
Reporting to the Manager, Corporate IT Database. This individual will be accountable for designing, implementing and maintaining Databases; support and maintenance of enterprise applications; provide data service to various business units
Responsibilities:
- Database Design and Implementation: Design, implement, and maintain database structures that meet the organization's requirements for scalability, performance, and reliability.
- Data Migration and Integration: Design and implement effective solutions to move data between difference systems by utilizing the modernized tools and methods.
- Data Modeling and Querying: Design and implement database queries and data models to extract relevant information for reporting purposes. Optimize queries for performance and efficiency.
- Report Development: Develop and maintain a variety of reports using reporting tools such as SQL Server Reporting Services (SSRS), Power BI, or similar tools. Design report layouts, formats, and visualizations to effectively communicate data insights.
- Data Validation and Testing: Ensure the accuracy and reliability of report data by performing data validation and testing procedures. Troubleshoot and resolve any discrepancies or errors in report output.
- Data Security and Integrity: Implement and enforce security measures to protect sensitive data from unauthorized access. Ensure data integrity through proper data validation and verification procedures.
- Backup and Recovery: Develop and maintain backup and recovery plans to ensure data availability in the event of system failures or disasters. Test backup and recovery procedures regularly to verify their effectiveness.
- Database Maintenance: Perform routine database maintenance tasks such as software updates, patches, and database reorganizations to keep systems running smoothly.
- Database Monitoring and Troubleshooting: Monitor database systems for errors, anomalies, and performance issues. Investigate and resolve database-related problems in a timely manner.
- Capacity Planning: Forecast future database storage and performance requirements based on business needs. Plan and implement database capacity upgrades as necessary.
- Documentation and Training: Document database configurations, procedures, and best practices. Provide training and support to other IT staff and end-users on database-related topics.
- Report Requirements Gathering: Collaborate with business stakeholders to gather and understand reporting requirements. Translate business needs into technical specifications for report development.
- Database Performance Tuning: Monitor database performance and proactively optimize database systems for maximum efficiency. Identify and resolve performance bottlenecks.
- Automation and Schedule Management: Implement automated report generation and distribution processes to ensure timely delivery of reports to stakeholders. Manage report schedules and subscriptions as per business requirements.
- Performance Monitoring: Monitor report performance and identify opportunities for optimization. Tune reports and queries to improve performance and reduce response times.
- Ticket Triage: Receive and triage incoming tickets related to production database issues, ensuring accurate categorization and prioritization based on severity and impact on business operations.
- Incident Investigation: Investigate reported database issues to identify root causes, using diagnostic tools, log analysis, and collaboration with relevant stakeholders. Determine appropriate actions and escalation paths based on the nature and severity of the incident.
- Change Implementation: Oversee the execution of approved database changes according to the established change management processes. Ensure that changes are implemented accurately and efficiently, following best practices and standards.
About You
What We Need from You:
- Minimum?3 years of SQL Server database administration and programming experience
- In depth SQL knowledge, database objects such as stored procedures/views/triggers
- Experience with building and maintaining SQL scripts, indexes, complex queries for data analysis and extraction
- Database experience with Microsoft DTS, SSIS, SSRS, OLAP Services, Python and Data Mining
- Work experience with PowerShell script, Power BI report and Change Management
- Programming experience with SQL store procedure, functions, ETL, Power Shell, Microsoft VB and C#
- Knowledge on Citrix Admin, Active Directory and cloud technology is an asset
- Collaborative, strong interpersonal skills and an exceptional team player
- Self-motivated with the ability to identify tasks and take the initiative to take action
- Understanding of the Broadcast and new media industry would be an asset
- Proven problem-solver with strong ability to multi-task and handle projects and deadlines
- Excellent written and verbal communication skills
- Maintain a positive and collaborative working relationship with the team
- A university or college degree in computer science or related experience
The pay range that the employer reasonably expects to pay for this position is between CA$30.00 and CA$50.00
Our voluntary benefits offering includes medical, dental, vision and retirement benefits.
Applications will be accepted on an ongoing basis.
Tundra Technical Solutions would like to thank you for the interest you have demonstrated in this opportunity. However, only candidates with the required skills will be contacted.
Tundra Technical Solutions is an Equal Opportunity/Affirmative Action Employer. We welcome and encourage diversity in our workplace.
Not interested in this position, but know somebody who might be? Check out our Referral Reward Program, referrals are a big secret behind our success. As always, we’re on the lookout for great people. And we know that you know great people!
Tundra Technical Solutions is among North America’s leading providers of Information Technology and Engineering staffing and consulting services. Our success and our clients’ success are built on a foundation of service excellence. Rather than continually trying to sell to new clients and companies and simply filling databases with candidates, we focus on developing stronger relationships and deeper knowledge of our existing clients’ challenges and opportunities.
Open ears. Open minds. Open futures