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 well being.
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 increase 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.
University Degree or Community College Diploma in a relevant area of study.
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 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
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 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 Referral Plan Maybe this opportunity isn’t the right fit for you, but you know someone who is?
Why not join our Parsons external referral program? When you refer other top professionals and they are hired, you are rewarded with an incredible financial incentive. Help us find top talent!