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):

• Lower Mainland $88,300/ Other BC Areas $83,300 - Lower Mainland $128,000/ Other BC Areas $120,800 Min/Max Pay Range for postings located in BC (Lower Mainland includes Vancouver & Burnaby)

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-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 : Aug 23, 2024, 1:24:40 PM

Req ID: 2400036L

#additional

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