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: - 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.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.
