Database Administrator MS-SQL
Share
Job Location:
Monthly Salary:
Posted on:
15 hours ago
Vacancies:
1 Vacancy
Job Summary
Caseware is one of Canadas original Fintech companies having led the global audit and accounting software industry for over 30 years with more than 500000 users across 130 countries and available in 16 different languages. While you might not have heard of us (yet) over 36000 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 afull remote role.
What you will do:
- Database Administration:
- AWS Integration:
- Security and Compliance:
- Operational Excellence:
- Collaboration:
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 Groupsreplication).
o Lead migration efforts from on-premises SQL environments to AWS RDS.
o Deploy and manage SQL databases using AWS services such as RDSAurora 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.
o Enforce database security policies encryption and access controls.
o Ensure compliance with industry standards (GDPR ISO 27001 SOC 2) and internal governance.
o Monitor system health and performance metrics.
o Troubleshoot database and AWS-related issues promptly.
o Maintain detailed documentation of configurations and operational procedures.
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.
Whats 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:
Casewares cutting-edge software products are meticulously designed for accounting firms corporations and 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 Casewares core values is Many Voices One Team and with that in mind were 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 emailprotected.
Background Check:
Any candidates successful in obtaining an offer for a position will need to successfully complete a background check through which typically includes an Identity Verification and Criminal Record Check. Executives and Senior Managers will undergo a Soft Credit Check as well. Candidates residingin the Netherlands and Germany are excluded from undergoing background checks via
Security and Fraud:
Caseware takes the security of candidates seriously. All legitimate communication from us will come from email addresses ending in @ and our open positions are always listed on reputable job boards and on our website We will NEVER ask for payment or financial information from you. If you receive an unsolicited job offer proceed with extreme caution.
We may use artificial intelligence (AI) tools to support parts of the hiring process such as reviewing applications analyzing resumes or assessing responses. These tools assist our recruitment team but do not replace human judgment. Final hiring decisions are ultimately made by humans. If you would like more information about how your data is processed please contact us.
Required Experience:
Unclear Seniority
Key Skills
- Accomodation
- Database
- Information Technology Sales
- Insurance Paralegal
About Company
Accounting, audit, analytics and compliance software built by seasoned accountants. Manage your audit and financial reporting more efficiently with less risk.
