Parsons Corporation Senior IT Specialist - Database Development in Markham, Ontario
Duties & Responsibilities
Purpose of the Job :
Work as a specialist responsible for complex on-line database management in our cloud and on-prem environments. Activities include the involvement in all aspects of a project - analysis, design, data modeling, coding, and testing as it relates to the database environment. Provide support and guidance to other teams in their interface with the database. Provide ongoing support for data integrity and database wellbeing.
Job Duties & Responsibilities
Analysis, design, and implementation of the database components for a wide variety of internally developed applications.
Provide technical service in evaluating the design and coordinating the initiatives with front-end application developers to understand and tune use of the database structures.
Participate as a team member in evaluating system resource utilization and storage usage/capacity, and makes recommendations to improve application performance to meet business and financial requirements.
Responsible for the migration of databases between software versions and synchronizing data between different databases residing in different platforms.
Provides input to the management on specific technology/platform changes to be used in setting new direction for the department.
Depending on the project's scope some dealings with third party vendors may be required.
Other duties as assigned.
Skills, Knowledge & Experience
Hands-on experience in Amazon RDS/Aurora. At least delivered two projects in AWS.
5+ years of experience on database development, including MySql and Oracle. Experiencing in other databases an asset.
Knowledge of Subversion, Git or other source code version control and repository tools.
In depth knowledge of system analysis and design procedures in a database environment.
Solid knowledge in schema design principles with demonstrated aptitude to apply best practices for scalable designs and influence peer developers
In-depth understanding of data management (e.g. tables, views, packages, procedures, functions, triggers, permissions, performance monitoring, etc.)
In depth knowledge and hands-on experience with SQL query and performance tuning
Experience in design/development of data warehouse, including the ETL process.
Experience with 'on-premise to cloud' migrations or IT transformations
Ability to juggle conflicting priorities while completing projects successfully.
Excellent communications skills both written and verbal, planning and organizational skills
Good interpersonal skills
Willing to learn from mistakes and from others, willing to share your findings and knowledge
Demonstrated ability to adapt to new technologies and learn quickly
Education & Certification
University Degree or Community College Diploma in a relevant area of study.
Ready for action? We're looking for the kind of people who see this opportunity and don't hesitate to act. Parsons is a leader in the world of Technical Services and Engineering. We hire people with a broad set of technical skills who have proven experience tackling some of the greatest challenges. Take your next step and apply today.
Parsons is an equal opportunity, drug-free employer committed to diversity in the workplace. Minority/Female/Disabled/Protected Veteran/LGBT.