Intermediate SQL Server DBA - (12 month contract)

Job Description

For more than 20 years, PointClickCare has been the backbone of senior care. We’ve amassed the richest senior care dataset making our market density untouchable and our connections to the healthcare ecosystem exponentially more powerful than those of any other platform. With Collective Medical & Audacious Inquiry, we’ve become the most expansive, full-continuum care collaboration network, offering care teams immediate, point-of-care access to deep, real-time insights at every stage of a patient’s journey. For more information on PointClickCare, please connect with us on Glassdoor and LinkedIn . Position Summary: The Intermediate SQL Server DBA plays an important role as part of a growing team that is responsible for managing, building, maintaining, monitoring and troubleshooting the database infrastructure of our mission critical corporate workloads. This includes collaborating on the planning, designing, implementation and maintenance with other groups within the Office of the CIO (“OCIO”). Responsibilities and Duties: · Manage and operate medium and large-sized production corporate IT database systems/services (hybrid environment) – including MS SQL servers on Windows platform and Azure SQL · Provide direct operational support across all areas of the corporate IT database infrastructure including database clusters, database replication, release management and disaster planning · Perform capacity planning, performance, tuning, monitoring (server/service, database), troubleshooting and optimization of the databases · Ensure that all databases have resilient data protection and are recoverable within business service level agreements · Implement best practices for database design, architecture, integrations and security · Managing role-based access controls · Reporting on metrics regarding usage and performance, recommend continuous improvements to the extended SQL services · Develop and support automation of database processes, tasks and procedures · Maintain documentation on systems management and operational procedures · Following operational policies and processes that are compliant with ITIL/ITSM standards · Contribute to the impact assessment, business case preparation and selection of tools/devices that will improve our ability to effectively maintain, monitor and troubleshoot infrastructure Qualifications: · Relevant IT Certifications, Microsoft MCSE (SQL server discipline) · Computer Science or Engineering degree or equivalent experience · Install and configure database servers (MS SQL) both standalone and clustered · Provide day-to-day database support and maintenance · Monitor SQL environments and proactively optimize database performance and security · Design and write T-SQL and scripts to automate database management tasks · Maintain operational procedure and processes documentation · Provide after-hours on-call support as required · Experience with database development (SSIS, SQL, Stored Procedures, Functions, ETL, SQL Jobs, Database Replication, Log Shipping) · Experience with data integration: REST, API, SOAP API · Demonstrate organizational, time management and multi-tasking skills Work Hours: · Monday to Friday, normal regional working hours · After hours maintenance and change management (including evenings and weekends) · Rotational on-call for severity one (1) corporate service issues #LI-Hybrid #LI-JP1 It is the policy of PointClickCare to ensure equal employment opportunity without discrimination or harassment on the basis of race, religion, national origin, status, age, sex, sexual orientation, gender identity or expression, marital or domestic/civil partnership status, disability, veteran status, genetic information, or any other basis protected by law. PointClickCare welcomes and encourages applications from people with disabilities. Accommodations are available upon request for candidates taking part in all aspects of the selection process. Please contact [email protected] should you require any accommodations. When you apply for a position, your information is processed and stored with Lever, in accordance with Lever’s Privacy Policy . We use this information to evaluate your candidacy for the posted position. We also store this information, and may use it in relation to future positions to which you apply, or which we believe may be relevant to you given your background. When we have no ongoing legitimate business need to process your information, we will either delete or anonymize it. If you have any questions about how PointClickCare uses or processes your information, or if you would like to ask to access, correct, or delete your information, please contact PointClickCare’s human resources team: [email protected] PointClickCare is committed to Information Security. By applying to this position, if hired, you commit to following our information security policies and procedures and making every effort to secure confidential and/or sensitive information. Apply for this job