Scheduled Maintenance: sisystems.com will be Unavailable from Friday, Dec 9th @ 8:00 PM MST - Saturday, Dec 10th @ 8:30 AM MST for regularly scheduled maintenance.
Login | Register

Senior Database Administrator to support and maintain Oracle Database and Microsoft SQL Server (DBMS) software for a financial enterprise client's High Availability (HA) environment!

Job Type: Contract
Positions to fill: 1
Start Date: Dec 05, 2023
Job End Date: Dec 05, 2024
Pay Rate: Hourly: Negotiable
Job ID: 125380
Location: Ottawa
Apply
Our valued financial client is seeking a Senior Database Administrator to install, configure and maintain all supported Oracle Database and Microsoft SQL Server (DBMS) software for a High Availability (HA) environment!

Initial 1-year contract (with a strong chance of extension up to a maximum term of 3 years) in Ottawa, ON! (Hybrid - Minimum of 5 days/month on-site)

As the successful candidate you will install, configure and maintain all supported DBMS software (Oracle Database and Microsoft SQL Server) and oversee resolution of various database-related technical issues within a High Availability environment.

Responsibilities:
  • Install, configure and maintain all supported Oracle Database and Microsoft SQL Server (DBMS) software for a High Availability (HA) environment
  • Upgrade existing databases and prepare patch management strategy database based on software vendor's recommendations as approved by the Bank
  • Oversee resolution of database-related technical issues
  • Implement and review backup and recovery strategy to ensure that business service-level agreements are met
  • Conduct database security administration to ensure that data is only available to authorized users
  • Ensure data consistency by adhering to data model standards and best practices
  • Oversee schema objects and perform production migrations
  • Carry out database performance tuning and analysis
  • Analyze and monitor system performance to identify major performance bottlenecks in the system and identify the impact of administration tasks on core business scenarios
  • Collaborate with development Database Administrators to coordinate database migration activities and disaster recovery testing, and enhance disaster recovery procedures
  • Provide operational support for the middle tier environment
Must-have Skills
  • 5+ years’ experience as a Database Administrator
  • Demonstrated experience working with Oracle version 11g or higher
  • 3+ years of demonstrated Database Recovery Manager (RMAN) experience with backup/restore and point in time recovery
  • 3+ years of demonstrated experience with datapump tool for database/data migration
  • Demonstrated understanding of the concept of Oracle Advanced Security Transparent Data Encryption (TDE)
Nice-to-have Skills
  • Oracle Certified Professional (OCP) designation
  • Demonstrated experience working with Oracle DB version 19c
  • Demonstrated experience working with SQL Server 2008 or higher
  • MS Certified Solutions Associate
  • Microsoft Certified Azure Database Administrator
  • Demonstrated knowledge of Oracle Exadata
  • Demonstrated knowledge of DataGuard, RAC
  • Demonstrated knowledge of GoldenGate
  • Demonstrated MySQL Database Administrator experience