hero

Accelerate your career.

Explore opportunities across TA's portfolio

Senior Database Administrator

InsightSoftware

InsightSoftware

Software Engineering, IT
Toronto, ON, Canada
Posted on Sep 26, 2024

Company Description

insightsoftware is a global provider of comprehensive solutions for the Office of the CFO. We believe an actionable business strategy begins and ends with accessible financial data. With solutions across financial planning and analysis (FP&A), accounting, and operations, we transform how teams operate, empowering leaders to make timely and informed decisions. With data at the heart of everything we do, insightsoftware enables automated processes, delivers trusted insights, boosts predictability, and increases productivity. Learn more at insightsoftware.com

Job Description

Senior Database Administrator role requires 7+ years of hands-on experience as MS SQL Administrator and 3+ years of experience with Oracle and PostgreSQL to maintain reliable, fault tolerant DB infrastructure for our growing customer base. Successful candidates will be responsible for managing an array of mission critical production and non-production 7/24/365 environments deployed to various physical and public cloud datacenters around the globe.

Key Responsibilities:

  • Install, patch and maintain all Microsoft SQL Server, Oracle and PostgreSQL databases
  • Provide DBA services to application development, professional services and support teams, including day to day operation, query validation and execution, database design, database generation, coding, and performance related issues
  • Be instrumental in researching, evaluating, designing, testing, recommending, and planning implementation of new versions or database software and database related tools
  • Manage regularly scheduled backups and refreshes
  • Manage database backup and recovery
  • Tunedatabase components
  • Create necessary automation for DB operations using Bash and PowerShell
  • Manage the implementation of technical controls to support and enforce defined security policies
  • Assume responsibility for documenting and maintaining disaster recovery plans for each supported system/application
  • Actively participate in SOC2/ISO27001 audits and ensure all audited controls are adhered to
  • Provide 24/7 on-call rotational duty and some week-ends

Qualifications

Qualifications

  • Strong hands-on experience with Microsoft SQL 2012+ and Oracle 12+ is required
  • Knowledge of PostgreSQL is strongly preferred
  • Practical experience in coding, debugging and tuning Oracle PL/SQL and SQL is required
  • Knowledge database management, performance monitoring and performance tuning tools is required
  • Knowledge of Linux system administration and bash scripting is required
  • Experience with MS Azure Cloud, PowerShell scripting, Azure SQL is strongly preferred
  • Experience with managing multi-tenant SaaS applications is strongly preferred
  • Relevant professional certifications are preferred, but not required
  • Ability to work in a rapidly evolving environment, effectively multi-task and balance multiple priorities while maintaining a high level of customer satisfaction is required

Additional Information

All your information will be kept confidential according to EEO guidelines.

** At this time insightsoftware is not able to offer sponsorship to candidates who are not eligible to work in the country where the position is located. **

Learn more about our high-energy, high-performance global team. Work With Us »

insightsoftware About Us: Hear From Our Team - InsightSoftware (wistia.com)

Background checks are required for employment with insightsoftware, where permitted by country, state/province.

At insightsoftware, we are committed to equal employment opportunity regardless of race, color, ethnicity, ancestry, religion, national origin, gender, sex, gender identity or expression, sexual orientation, age, citizenship, marital or parental status, disability, veteran status, or other class protected by applicable law. We are proud to be an equal opportunity workplace.

** At this time insightsoftware is not able to offer sponsorship to candidates who are not eligible to work in the country where the position is located. **

insightsoftware About Us: Hear From Our Team - InsightSoftware (wistia.com)

Background checks are required for employment with insightsoftware, where permitted by country, state/province.

At insightsoftware, we are committed to equal employment opportunity regardless of race, color, ethnicity, ancestry, religion, national origin, gender, sex, gender identity or expression, sexual orientation, age, citizenship, marital or parental status, disability, veteran status, or other class protected by applicable law. We are proud to be an equal opportunity workplace.