CasewareDatabase Administrator - MS-SQL
Caseware is one of Canada's original Fintech companies, having led the global audit and accounting software industry for over 30 years, with more than 500,000 users across 130 countries and available in 16 different languages. While you might not have heard of us (yet) over 36,000 accounting and audit professionals list Caseware as a skill on their LinkedIn profiles!
The MS-SQL DBA will be responsible for managing, maintaining, and optimizing Microsoft SQL Server databases hosted on AWS infrastructure. This role combines traditional DBA responsibilities with cloud engineering skills to ensure high availability, security, and performance of database systems in a hybrid or fully cloud-based environment.
❗ Please note: this role is NOT a B2B contract. This is a Full-Time permanent role.
📍 Location: This is a full remote role.
Contact: Dana Liulica - Talent Acquisition Partner
What you will do:
- Database Administration:
o Install, configure, and upgrade Microsoft SQL Server instances on AWS(EC2, RDS, RDS Custom).
o Perform proactive performance tuning, indexing, and query optimization.
o Manage database backups, restores, and disaster recovery strategies.
o Implement high availability solutions (Always On Availability Groups,replication).
o Lead migration efforts from on-premises SQL environments to AWS RDS.
- AWS Integration:
o Deploy and manage SQL databases using AWS services such as RDS,Aurora, and EC2.
o Utilize AWS tools like CloudWatch, CloudTrail, and IAM for monitoring and security.
o Implement Infrastructure as Code using AWS CDK with TypeScript for database provisioning.
- Security and Compliance:
o Enforce database security policies, encryption, and access controls.
o Ensure compliance with industry standards (GDPR, ISO 27001, SOC 2) and internal governance.
- Operational Excellence:
o Monitor system health and performance metrics.
o Troubleshoot database and AWS-related issues promptly.
o Maintain detailed documentation of configurations and operational procedures.
- Collaboration:
o Work closely with Cloud Operations and Application teams for migrations and integrations.
o Participate in planning and execution of database modernization initiatives.
- Participate in a 24/7 on-call rotation to support critical infrastructure, respond to operational incidents, and ensure high availability.
What you will bring:
- Strong expertise in Microsoft SQL Server administration (installation, tuning, HA/DR).
- Hands-on experience with AWS services (RDS, EC2, IAM, VPC).
- Proficiency in scripting and automation (PowerShell, Python, or similar).
- Familiarity with Infrastructure as Code (AWS CDK with TypeScript).
- Knowledge of networking concepts and AWS security best practices.
- At least 10 years as a DBA, including 3 years with AWS.
- Nice-to-Have:
• Experience with AWS Database Migration Service (DMS).
• AWS Certified Data Engineer – Associate certified
• Exposure to observability tools (New Relic, CloudWatch, Datadog).
• Familiarity with cost optimization strategies in AWS.
What's in it for you:
▪️Innovation is at our core. We work with cutting-edge technology in accounting and financial reporting, constantly pushing the boundaries to create impactful software solutions.
▪️We are committed to a collaborative culture, where your ideas are valued, and knowledge sharing is encouraged within a supportive, inclusive team.
▪️Work-life balance is important to us. We offer flexible work options, remote opportunities, and generous time-off policies to ensure a healthy work-life balance.
▪️We offer competitive compensation, including a competitive salary and comprehensive benefits such as health insurance and retirement plans.
▪️We are driven by impactful work. Your contributions directly affect how our clients manage financial processes and drive their success.
▪️Recognition and rewards matter to us. We celebrate hard work through recognition programs, performance bonuses, and opportunities for career growth.
▪️We embrace global opportunities. Work on international projects and collaborate with a diverse, global team.
About Caseware:
Caseware's cutting-edge software products are meticulously designed for accounting firms, corporations, and governments. Our teams are continually collaborating, innovating, and building upon our existing suite of products. With a customer-focused mindset, we are building technology that is shaping what the future of audits, financial reporting, and financial data analytics will look like.
With a recent strategic investment from Hg Capital in 2020, Caseware is now in its next major growth phase as we double down on the people and products that have made Caseware so successful to date.
One of Caseware's core values is Many Voices, One Team and with that in mind, we're dedicated to building teams as diverse as our customers in an equitable and inclusive way. We welcome and encourage candidates of all backgrounds to apply. Should you require accommodations or have any questions at any point during the application or interview process, please e-mail our People Operations team at talent@caseware.com.
Background Check:
Any candidates successful in obtaining an offer for a position will need to successfully complete a background check through Certn.co which typically includes an Identity Verification and Criminal Record Check. Executives and Senior Managers will undergo a Soft Credit Check as well. Candidates residing in the Netherlands and Germany are excluded from undergoing background checks via Certn.co
Security and Fraud:
Caseware takes the security of candidates seriously. All legitimate communication from us will come from email addresses ending in @caseware.com and our open positions are always listed on reputable job boards and on our website https://jobs.lever.co/caseware. We will NEVER ask for payment or financial information from you. If you receive an unsolicited job offer, proceed with extreme caution.