Sr Database Engineer at Jonas Software

, , Canada -

Full Time

Start Date

Immediate

Expiry Date

31 Jan, 26

Salary

0.0

Posted On

02 Nov, 25

Experience

10 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

SQL Server, MySQL, PostgreSQL, AWS Cloud, Database Management, Database Administration, Performance Tuning, Database Security, PL/SQL, Database Backup, Troubleshooting, Reporting Services, Capacity Planning, Automation, Technical Leadership, Mentoring

Industry

Software Development

Description

Job Description: Sr Database Engineer Jonas Software - C&R Software Remote Canada COMPANY We are a division of Jonas Software, Inc. which is the valued technology partner of over 80,000 customers worldwide in more than 15 countries. Jonas employs over 2,700 skilled individuals consisting of a cross-section of industry experts and technology professionals. Jonas is headquartered in Canada and operates offices throughout North America, South America, the United Kingdom, Europe, Australia and New Zealand. Jonas is a 100% owned subsidiary of Constellation Software Inc., headquartered in Toronto and traded on the TSX (CSU.TO). C&R Software delivers optimized solutions across the Collection and Recovery lifecycle, empowering organizations to manage their end-to-end collections operation more effectively and compliantly. Collections is an increasingly complex and evolving landscape, but with C&R’s sophisticated systems, it becomes simple for users to drive process automation while having the flexibility to easily adapt to change. Our cloud-native software is fast and easy to deploy and provides unlimited scale to grow with your business. C&R Software has evolved over the last 35 years, with its flagship product, Debt Manager, the industry-leading Collections technology trusted by hundreds of organizations in over 50 countries. Given the highly configurable nature of the solution, it supports businesses across many verticals, including financial institutions, governments, utility and telecoms, collection agencies and debt buyers, and more. C&R Software specializes in Debt Collection and Risk Innovation, Compliance, Placement Optimization, Digital Transformation, and Emerging Technology. Debt Manager deployed in AWS, is the only cloud-native, end-to-end collections and recovery platform in the world. It connects collections, recovery, and communications in one system. It prioritizes the consumer journey, automating operational processes and making consumers happy. More than $3 trillion is managed on Debt Manager as a System of Record, offering extensive capabilities unmatched by any other provider. POSITION Qualified candidates are being considered for openings within the Database Operations group at C&R Software. These candidates will possess a strong background in SQL Server, MySQL and PostgreSQL database management and administration. The individual will partner with product support, and DevOps CSM to keep databases secured, healthy and up to date to meet SLAs. The position is part of the Database Operations group which focuses on managing, maintaining, and securing databases in the AWS Cloud. This position requires an extensive experience with MSSQL, MySQL, and PostgreSQL and experience with AWS Cloud services. The candidate is expected to manage SQL Server, MySQL, and PostgreSQL databases in the cloud. The candidate should be responsible to manage and maintain databases in AWS Cloud. The candidate should have a solid understanding of RDS cluster, taking snapshot of RDS instance, monitor database performance issues and resolve them, and participate in On-Call rotation as needed. Previous experience within Banking and Financial Services is preferred. The position will be based in the C&R Software Canada. This is a remote position. Key Responsibilities • Install, upgrade, and manage database servers and schemas. • Set and maintain enterprise database standards. • Manage database access and Develop processes for optimizing database security. • Performance tuning of database systems particularly RDS/Aurora PostgreSQL and MySQL. • Create database backups and restore database from backups. • Plan capacity for database servers. • Diagnose and troubleshoot database errors. • Create and manage database reports, visualizations, and dashboards. • Write complex PL/SQL, understand complex queries, able to tune complex queries. • Automate repeating database tasks. • Be available for on-call support. • Experience as a DBA with AWS Cloud databases MSSQL, Aurora/RDS PostgreSQL and MySQL. • Monitor database incidents queue and act based on priority. • Implement and deploy database changes in Prod and QA environments. • Monitor MSSQL, MySQL, and PostgreSQL database performance issues and resolve them. • Interact with other DBA team members, product support team, and DevOps CSM and keep them aware of critical issues at hand. • onsite team member to understand project requirements and goals. • Report progress status to team manager various database support tickets and other projects. • Manage, maintain, and secure RDS Aurora PostgreSQL, MySQL and MSSQL databases. • Understand the PL SQL scripts provided in the change and be able to make a call if scripts are not well performant or not correct. • Troubleshoot and resolve SSRS issues. • Proactive and take ownership of highly visible issues and projects. • Establish partnership with other teams and drive projects. • Able to provide database level technical leadership and mentor junior DBAs. • Establish database support standards to help in the areas of database support with minimal interruptions. Job Requirements: • Bachelor’s degree in computer science or related field. • This is Mid-Senior level Database Engineer. • 12+ years of IT industry experience. • 10+ experience in database administration roles in MSSQL, MySQL and Amazon Aurora PostgreSQL. • Experience with Linux and Windows Server environments. • Extensive experience with database technologies (MySQL, MSSQL, PostgreSQL). • Experience with AWS cloud services. • Experience with cloud database infrastructure management and administration. • Extensive experience in HA/DR in major enterprise database systems. • Experience in SQL Server Reporting Services. • Good communication skills including verbal and writing skills • Experience in either the Banking or Financial Industry is preferred • Preferred AWS certified professional who has experience in RDS, IAM, EC2, VPC and Storage • Experience in troubleshooting performance issues from infrastructure and database engine. • Experience working with clients and other department leads within the organization. • Must have AWS and Amazon Aurora PostgreSQL experience. • Expert in writing PL/SQL and PostgreSQL performance tuning and optimization Competencies: Action Oriented, Customer Focus, Technical Skills, Problem Solving, Personal Learning #LI-VL1 Business Unit: Jonas Collection and Recovery - Canada Scheduled Weekly Hours: 37.5 Number of Openings Available: 1 Worker Type: Regular More About Jonas Software: Jonas Software is the leading provider of enterprise management software solutions to the Country and Golf Clubs, Foodservice, Construction, Fitness & Sports, Attractions, Salon & Spa, Education, Radiology/Laboratory Information Systems, and Product Licensing industries. Within these vertical markets, Jonas is made up of over 65 distinct brands, which are respected and leaders within their own domain. Jonas’ vision is to be the branded global leader across the aforementioned vertical markets and to be recognized by customers and respective industry stakeholders as the trusted provider of ‘Software for Life’ and as an ambassador for technology, product innovation, quality, and customer service. Jonas Software is the valued technology partner of over 60,000 customers worldwide in more than 30 countries. Jonas employs over 2,000 skilled individuals consisting of a cross-section of industry experts and technology professionals. Jonas is headquartered in Canada and also operates offices throughout North America, the United Kingdom, Europe, Australia New Zealand and Africa. Jonas is a 100% owned subsidiary of Constellation Software Inc., headquartered in Toronto and traded on the S&P/TSX 60. At Jonas we have long realized that our greatest asset is our employee base. As such we strive to provide our team with a fantastic working environment and an enriching career, which we know will translate into world class service to our valued clients. This allows Jonas Software to maintain and extend our lead as the premier software and services provider in each of our markets. If being part of a growing organization that moves at a fast pace and constantly strives to get better each and every day is what you are looking for, then we want to hear from you. Everyone has heard the sports analogy “to be the best, you have to beat the best”; well at Jonas Software we have tweaked that slightly to fit vertical market software. We believe to be the best you have to hire and retain the best!!! Jonas Software is an Equal Opportunity Employer. If you need accommodation for a disability at any stage of the application process or want more information on our accommodation policies, contact recruitment at jobs@gjonas.com or 905-470-4600 Jonas Softwareis part of a CSI group of companies. << Back to Career Site

Responsibilities

The Sr Database Engineer will manage, maintain, and secure databases in the AWS Cloud, ensuring they are secured, healthy, and up to date. Responsibilities include performance tuning, troubleshooting database errors, and automating database tasks.