Database Analyst/DBA – Senior
- Pay Rate: (flexible)
- Location: 1 York Street Toronto -Ontario, CAN
- Contract Length: 7 Months
Work Type: Hybrid
We at Raise are hiring right now for one of our Ontario Public Sector Clients. If you’re interested, apply below for your chance to join a great place to work.
Responsibilities:
- Administrative support of Oracle 12c and 19c and PostgreSQL, and AWS RDS database instances including many of the sub-components.
- Advanced performance tuning expertise, including specifics related to partitioning, indexing , storage optimization, and memory management.
- Maintain up-to-date documentation and procedures for all supported database related platforms.
- Infrastructure support of Oracle including server/instance installs (stand-alone and clustered), service-pack upgrades, hot fixes, client tool installs, readiness programs, new feature exploitation, research, and development (as needed by Infrastructure manager).
- Work with other Database Administrators or Developers in defining requirements.
- Working on ways to automate and improve infrastructure as code release processes.
- Support Oracle Advanced Security features such as TDE.
- Performance analysis, monitoring, troubleshooting and resolution of issues.
- Support project development following documented standards, policies, and procedures (Change Management Process).
- Manage regular reviews of database vulnerability scan and remediation of open vulnerabilities.
- Working closely with other team members, technical/team leads, management, specialized IT areas and application support teams to ensure consistent delivery and quality of database services.
- Define, document, and implement consistent standards and procedures.
- Contribute ideas for best practice improvements, process improvement, and innovative solutions.
Qualifications:
- 10+ Years of Technical experience working with Oracle 12c and 19c hosted on Unix and Linux platforms.
- 5+ years of Technical experience working with PostgreSQL version 9+ and above hosted on Linux or AWS cloud-based platforms.
- Strong PLSQL skills that including a strong understanding of system tables, stored procedures, functions, triggers, and SQL tuning.
- Participation in database upgrade, cloning, platform migration, installations, and patching.
- Experience with Oracle database monitoring and tuning using native Oracle or other third-party tools.
- Involvement with Embarcadero DBArtisan and native Oracle as well as other third-party tools.
- Knowledge with Oracle Key Vault, Veritas clustering software and AIX and Linux operating systems.
- Knowledge of Oracle Enterprise Manager or GRID Control, RMAN backup and recovery strategies, Oracle replication, mirroring, log shipping, maintenance plans and DR recovery strategies.
- Excellent interpersonal and communication skills and the ability to handle several tasks efficiently.
- Willingness to partake in ideas, contribute solutions and take initiative.
Looking for meaningful work? We can help
Raise is an established hiring firm with over 65 years of experience. We believe strongly in making the world a better place through work, which is why we’re a certified B Corporation and donate 10% of our profits to charity.
We strive to build teams that reflect the diversity of the communities we work in. We encourage all qualified applicants to apply, including people from traditionally underrepresented groups such as women, visible minorities, Indigenous peoples, people identifying as LGBTQ2SI, veterans, and people with visible/nonvisible disabilities.
We have a dedicated webpage for accommodations where you can learn more about what we offer, and request accommodation: https://raise.jobs/accommodations/
In order to submit candidates for roles, our clients will sometimes require personal information to confirm the identity of applicants and their legal status to work. Raise will never ask you for personal or banking information unless you have been selected for a job. If you are ever unsure about the legitimacy of this or another job posting by Raise (or have any other questions), please contact us at +1 800-567-9675 or hello@raiserecruiting.com
