Database Administrator - Security - ( 2400036L )
Description
Grow with the best. Join a smart, creative, and inspired team that accomplishes operational excellence. Bringing together individuals with diverse backgrounds, talents, and expertise, our 31,000 team members in over 450 locations worldwide are vital to making our Company stronger.
Your Opportunity
Security has become an aspect of everyone's daily lives, Stantec has user awareness training to minimize security incidents by having employees more engaged and aware. This role embodies reviewing the security of the database and the applications that the database administration team supports. Working with the teams to implement database base and application (E-Business Suite) hardening principles. Under the direction of Advanced Technology leadership, the role requires you to work independently to audit functions within the Database and related Applications, sometimes coordinating with other teams, to evaluate issues and recommend solutions from a security standpoint.
Your Key Responsibilities
Apply strong concepts of database security, auditing, and application security with Enterprise Applications to achieve sufficient hardening
Utilize Audit Vault and Database Firewall to effectively monitor databases.
Implement Transparent Data Encryption (TDE)
Security understanding and implementing best security practices.
Supporting and enhancing Stantec's High Availability Architecture and disaster recovery operations.
Database Backup and Recovery.
Planning, Testing, and Performing software upgrades.
Assisting with database loads and data conversion activities.
Cloning and supporting different application environments.
Resolving assigned security-specific Service requests
Applying Data masking concepts
Qualifications
Your Capabilities and Credentials
Minimum of 7 years experience providing Oracle DBA support in a LINUX/UNIX environment, of which 2 years must have been working with Oracle 19C.
Minimum of 3 years providing Oracle E-Business Suite support in a UNIX environment of which 2 years must have been working with Oracle E-Business Suite versions 12.2, OIDM12c, SQL
Server 19.
Extensive Oracle and Oracle E-Business Suite application experience.
SQL
Server experience will be an asset.
Experience with RHEL Linux is mandatory.
Experience in shell scripting in a UNIX or Linux environment.
Effective understanding of Data at rest and data in transit.
Experience in Perl or Python programming will be considered an asset.
Experience in using Oracle Enterprise Manager 13c for managing environments will be considered an asset.
Excellent verbal and written communication skills; this position requires a high degree of involvement leading meetings and regularly communicating to various stakeholders.
Please note that this position will require after-hours.
We are looking for team players that can work in a very dynamic and challenging environment.
Experience with Azure will be an asset.
Education and Experience
Minimum 7 years of relevant experience
Related degree. OCP Database Security, CISSP, CCSP, and GIAC certifications will be an asset.
This description is not a comprehensive listing of activities, duties or responsibilities that may be required of the employee and other duties, responsibilities and activities may be assigned or may be changed at any time with or without notice.
Stantec is a place where the best and brightest come to build on each other’s talents, do exciting work, and make an impact on the world around us. Join us and redefine your personal best.
Pay transparency laws require employers to provide the following information for positions that may be in the following jurisdiction(s):
Salary Range(s):
The final agreed upon compensation is based on individual education, qualifications, experience, and work location. At Stantec certain roles are bonus eligible.
Benefits Summary: Regular full-time and part-time employees will have access to health, dental, and vision plans, a well-being program, health care spending account, wellness spending accounts, group registered retirement savings plan, employee stock purchase program, group tax-free savings account, life and accidental death & dismemberment (AD&D) insurance, short-term/long-term disability plans, emergency travel benefits, tuition reimbursement, professional membership fee coverage, and paid time off.
Temporary/casual employees will have access to group registered retirement savings plan, employee stock purchase program, and group tax-free savings account.
The benefits information listed above may not apply to union positions because benefits for such positions are governed by applicable collective bargaining agreements.
Primary Location : Canada-Alberta-Edmonton
Other Locations : Canada-New Brunswick-Saint John, Canada-Alberta-Calgary, Canada-Manitoba-Winnipeg, Canada-British Columbia-Vancouver, Canada-Nova Scotia-Dartmouth, Canada-Ontario-Toronto, Canada-Nova Scotia-Halifax, Canada-Ontario, Canada-Ontario-Waterloo, Canada-British Columbia-Victoria, Canada-Ontario-Markham
Organization : BC-1374 IT Services-CA Corporate
Employee Status : Regular
Job Level : Individual Contributor
Travel : No
Schedule : Full-time
Job Posting : Jan 6, 2025, 11:11:54 AM
Req ID: 2400036L
Stantec provides equal employment opportunities to all qualified employees and applicants for future and current employment and prohibit discrimination on the grounds of race, color, religion, sex, national origin, age, marital status, genetic information, disability, protected veteran status, sexual orientation, gender identity or gender expression. We prohibit discrimination in decisions concerning recruitment, hiring, referral, promotion, compensation, fringe benefits, job training, terminations or any other condition of employment. Stantec is in compliance with local, state and federal laws and regulations and ensures equitable opportunities in all aspects of employment. EEO including Disability/Protected Veterans
We are committed to hiring military and Veteran spouses and encourage you to identify your connection with the MSEN when reaching out to us or applying to any of our open roles.
Have questions or want to learn more about us? We would love to hear from you!
Jason Cain
Communities are fundamental. Whether around the corner or across the globe, they provide a foundation, a sense of place and of belonging. That's why at Stantec, we always design with community in mind.
We care about the communities we serve—because they're our communities too. This allows us to assess what's needed and connect our expertise, to appreciate nuances and envision what's never been considered, to bring together diverse perspectives so we can collaborate toward a shared success.
At Stantec, we pride ourselves on our commitment to building communities. As an extension of that commitment, we believe that our nation is our community—and Veterans and their families are an important part of that community. We are committed to welcoming members of the Veteran’s and military communities into our workforce, and we are dedicated to growing our work for defense communities in Canada, the US, and abroad.
We're designers, engineers, scientists, and project managers, innovating together at the intersection of community, creativity, and client relationships. Balancing these priorities results in projects that advance the quality of life in communities across the globe.
We believe in the long-term success of military-connected individuals, and we hope you will join us in your next career move.