In a world of possibilities, pursue one with endless opportunities. Imagine Next!

When it comes to what you want in your career, if you can imagine it, you can do it at Parsons.  Imagine a career working with intelligent, diverse people sharing a common quest. Imagine a workplace where you can be yourself. Where you can thrive. Where you can find your next, right now. We’ve got what you’re looking for.

Job Description:

Are you an experienced database developer ready to take on new challenges? We’re looking for a skilled professional to join our team, where you’ll be responsible for designing, implementing, and optimizing database components for a variety of internally developed applications. This role involves collaborating with front-end developers, evaluating system resources, and tuning database structures to improve application performance. You'll also play a key part in managing database migrations, coordinating with third-party vendors, and providing valuable input on technology decisions that shape the future direction of the department.

If you have over 5 years of experience with MySQL, Oracle, and database development, and are passionate about data management, performance tuning, and driving innovation, we want to hear from you! Join us and help optimize systems that power our business.

What You'll Be Doing:

• 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.

What Required Skills You'll Bring:

• 5+  years of experience on database development, including MySql and Oracle. Experiencing in other databases an asset.
• 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 and modelling (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.

What Desired Skills You'll Bring:

• Hands-on experience in Amazon RDS/Aurora. At least delivered two projects in AWS.
• Full stack development experiences an asset.
• Knowledge of Subversion, Git or other source code version control and repository tools.
• Strong problem solving and reasoning skills

Minimum Clearance Required to Start:

Not Applicable/None

This position is part of our Critical Infrastructure team.

For more than 80 years, our experts have designed and delivered the critical infrastructure that connects and protects communities around the world. We work in collaborative teams, both within the company and with our partners and customers, to plan, design, build, and modernize infrastructure. We take special pride in projects and solutions that improve communities as well as people’s quality of life by promoting economic growth, enhancing mobility, and increasing sustainability and resiliency. Powered by our people, we provide the imagination necessary to support our customers’ visions—and to help them see what's next!

We value our employees and want our employees to take care of their overall wellbeing, which is why we offer best-in-class benefits such as health, vision, dental, employer paid provincial care premiums, Defined Contribution Pension Plan (DCPP), Tax-Free Savings Account (TFSA), Registered Retirement Savings Plan (RRSP), life insurance, paid time off, sick leave, all province observed holidays off, and gym membership discounts to fit your busy lifestyle!

Parsons is an equal opportunity employer committed to diversity, equity, inclusion, and accessibility in the workplace. Parsons equally employs representation at all job levels for indigenous peoples, women, individuals with disabilities, and visible minorities.

We truly invest and care about our employee’s wellbeing and provide endless growth opportunities as the sky is the limit, so aim for the stars! Imagine next and join the Parsons quest—APPLY TODAY!

Parsons is aware of fraudulent recruitment practices. To learn more about recruitment fraud and how to report it, please refer to https://www.parsons.com/fraudulent-recruitment/.