Insightsoftware, the leader in equity administration software and disclosure management, is looking for an experienced Database Administrator to join our team. This is a fast paced position requiring daily interaction with internal business partners as well as providing end to end technical guidance and support.

This position requires having 5+ years with hands-on experience as an Oracle Database Administrator supporting both Production and Non-production environments. DBA experience working directly with Oracle versions 12 and above and 3+ years hands on experience with Microsoft SQL Server Database Administration versions 2012 and above is highly desirable.

Key Responsibilities and Attributes:

Production Database Support and related attributes are described below all requiring hands-on working experience in production support of Oracle/SQL server databases in a 7/24/365 environment:

• Install, patch and maintain all Oracle and SQL Server databases.
• Manage regularly scheduled backups and refreshes.
• Manage Oracle and Sql Server disaster backup and recovery using tools such as RMAN and SSRS.
• Tune all Oracle instance components including SQL and PL/SQL.
• Able to quickly digest and resolve production related performance issues.
• Tune all SQL Server instance components using tools such as Database Tuning Profiler.
• Manage the implementation of technical controls to support and enforce defined security policies.
• Database tool experience in TOAD, DBVisit Standby, Zoho’s Manage Engine Application Manager and Solar Winds DPA or equivalents.
• Responsible for documenting and maintaining a Disaster Recovery plan for each supported system/application.
• Linux bash scripting.
• Able to provide 24/7 on-call rotational duty and some week-ends.
• Highly desirable experience in:
  • Linux System Administration.
  • Installation, setup and tuning of Linux running Oracle.
  • PowerShell scripting
  • Dell Servers (Hardware)
  • Azure Cloud (Saas)
  • Azure Azcopy (upload/download)
  • Oracle Cloud

Non-Production Database Support and related attributes are described below. These Database environments include Development, Quality Assurance, Customer Support, Data Conversion and various other internal groups.

• Support multiple application and support teams with numerous on-going projects.
• Provide DBA services to application development teams, including database design, database generation, coding, and performance related issues.
• Be instrumental in researching, evaluating, designing, testing, recommending, and planning implementation of new versions of Oracle/SQL server database and database related tools.
• Performs assessments and listens to internal customers to understand and anticipate their needs and determine their priorities in the context of the overall enterprise.
•  Must have strong hands-on experience in coding, debugging and tuning Oracle PL/SQL and SQL.
• Desired experience in these areas:
  • Oracle Streams or Advanced Queuing
  • Oracle Application Express coding
  • MS SQL Server Databases

Candidate Profile:

The successful candidate must have the following professional attributes which include the following:

• Education:  Bachelor’s degree, Master’s degree or foreign equivalent degree in Computer Science, Computer Engineering, Computer Applications or closely-related discipline.
• Ability to balance multi-task and multiple priorities while maintaining a high level of customer satisfaction.
• Must be a team player willing to make every effort to make the team a success.
• Strong and effective written, verbal and presentation skills with the ability to collaborate with team members at all levels of the organization.
• Must have strong diagnostic and problem solving abilities
• Self-starter, proactive, positive, creative, and flexible.
• Stays current with emerging technologies, industry best practices for Oracle and SQL server.
• Must be authorized to work in Canada

** At this time insightsoftware is not able to offer sponsorship to candidates who are not eligible to work in the stated work location. **