The SQL Server Database Administrator manages and supports SQL Server databases, ensures data security, performance, and compliance with standards. Responsibilities include troubleshooting issues, implementing backups, and collaborating with other IT teams.
Bounteous is a premier end-to-end digital transformation consultancy dedicated to partnering with ambitious brands to create digital solutions for today’s complex challenges and tomorrow’s opportunities. With uncompromising standards for technical and domain expertise, we deliver innovative and strategic solutions in Strategy, Analytics, Digital Engineering, Cloud, Data & AI, Experience Design, and Marketing.
Our Co-Innovation methodology is a unique engagement model designed to align interests and accelerate value creation. Our clients worldwide benefit from the skills and expertise of over 4,000+ expert team members across the Americas, APAC, and EMEA. By partnering with leading technology providers, we craft transformative digital experiences that enhance customer engagement and drive business success.
Bounteous is looking for an SQL Server Database Administrator to join our fast-growing Technology practice.
Information Security Responsibilities
- Promote and enforce awareness of key information security practices, including acceptable use of information assets, malware protection, and password security protocols
- Identify, assess, and report security risks, focusing on how these risks impact the confidentiality, integrity, and availability of information assets
- Understand and evaluate how data is stored, processed, or transmitted, ensuring compliance with data privacy and protection standards (GDPR, CCPA, etc.)
- Ensure data protection measures are integrated throughout the information lifecycle to safeguard sensitive information
Role and Responsibilities
- Be a hands-on Database Administrator responsible for the design, maintenance, integration and operational support for the MSSQL environment SQL Server 2016/2019/2022
- SQL Server DBA with strong azure cloud knowledge
- Continuously monitor performance of SQL server, application and scheduled job performance and work to improve performance as well as establish performance baselines.
- Provide high-level database support and guidance to both the Development and Infrastructure teams.
- Troubleshoot and provide advice on SQL Server performance issues and be able to work with application developers and provide recommendations.
- Ability to work in shifts to provide operations support.
- Maintains quality of service by establishing and enforcing organization standards.
- Own, resolve, and track all database incidents and requests across production, UAT, and development environments.
- Be responsible for ensuring data consistency and integrity across all database systems.
- Work closely with other IT resources (e.g. Windows Engineering team, Network Administrators) to create and implement new applications and technologies
- Implement and support production changes adherent to the change management/ release process
- Manage, design and implement backup, recovery, and high-availability processes for all database systems
Preferred Qualifications
- 8 - 10 years of Database Administration experience, preferably in financial services
- A demonstrated proficiency in supporting the database platform of a large organization.
- Flexibility to support the operations of our businesses 24/7
- A bachelor’s degree in computer science / Information Technology or equivalent experience
- Experience in SQL 2016/2019/2022 database management and related products from Microsoft including PowerShell, Windows 2016/2019/2022 Server and desktop operating systems.
- Prior experience with SQL Clustering, Strong Transact-SQL & SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS) knowledge, Replication, Performance Tuning, Backup and recovery methods, Log shipping, Database Mirroring, Database capacity planning, and Users and Role creation and monitoring.
- Ability to quickly troubleshoot and resolve complex problems in a live environment.
- Excellent interpersonal skills and ability to articulate complex ideas and solutions to users.
- Expert knowledge and in-depth experience with the Microsoft platform and the following technologies:
- Self-motivation with the ability to work independently and as a strong team player.
We invite you to stay connected with us by subscribing to our monthly job openings alert here.
Bounteous is proud to be an equal opportunity employer. Bounteous does not discriminate on the basis of race, religion, color, sex, gender identity, sexual orientation, age, physical or mental disability, national origin, veteran status, or any other status protected under federal, state, or local law. Bounteous is willing to sponsor eligible candidates for employment visas.
For employment opportunities based in Canada:
Bounteous is an equal opportunity employer. In accordance with the Ontario Human Rights Code and Accessibility for Ontarians with Disabilities Act, 2005, accommodation will be provided at any point throughout the hiring process, provided the candidate makes their accommodation needs known to Bounteous. We welcome applications from all qualified candidates.
*Must be legally eligible to work in Canada.
Top Skills
Azure Cloud
Powershell
Sql Server 2016
Sql Server 2019
Sql Server 2022
Ssis
Ssrs
Windows Server 2016
Windows Server 2019
Windows Server 2022
Similar Jobs at Bounteous
Agency • Digital Media • eCommerce • Professional Services • Software • Analytics • Consulting
The Python Developer will design and implement high-performance REST APIs, ensure data protection, and mentor junior developers while fostering robust security practices.
Top Skills:
DockerFastapiKafkaKubernetesOpenshiftOpentelemetryPostgresPrometheusPythonRedisSqlmodel
Agency • Digital Media • eCommerce • Professional Services • Software • Analytics • Consulting
The role involves maintaining Identity & Access Management systems, optimizing SDLC processes, and ensuring cybersecurity measures, while collaborating with teams on solution development.
Top Skills:
Cloud TechnologiesCybersecurity FrameworksJavaPythonSQL
Agency • Digital Media • eCommerce • Professional Services • Software • Analytics • Consulting
The IAM Reliability Engineer will support authentication and identity management solutions, debug issues, implement improvements, and create operational tools while participating in an on-call rotation.
Top Skills:
AnsibleC/C++GroovyIdentity And Access ManagementJavaPowershellPythonUnix Shells
What you need to know about the Vancouver Tech Scene
Raincouver, Vancity, The Big Smoke — Vancouver is known by many names, and in recent years, it has gained a reputation as a growing hub for both tech and sustainability. Renowned for its natural beauty, the city has become a magnet for professionals eager to create environmental solutions, and with an emphasis on clean technology, renewable energy and environmental innovation, it's attracted companies across various industries, all working toward a shared goal: advancing clean technology.