Job Description

Job Role: DBA lead

Job Summary:

We are seeking a highly skilled and experienced DBA Lead to join our team. In this role, you will be responsible for Migrating and assisting SQL instances and streamlining the entire migration process and be a continuous contributor for improvement of overall Migration activities

In this role, you will

Migrating many SQL instances to new data center, Several migrations may include new server builds and new (upgraded) versions of SQL installations. Servers will be built by a different team SQL Installation/upgrades and configuration across SQL Server 2012, 2014, 2016, 2017, 2019 Assisting with testing and verifying migrated / upgraded SQL Instances Identify potential risk and make recommendations Testing and remediation of impact on DBA maintenance scripts, SQL agent jobs, audits, triggers, credentials, policy management, ODBC driver configurations Streamlining the entire migration process to minimize downtime Participate in migrating production servers (non?business hours) Provide regular status updates and attend project meetings Document new / upgraded server configurations and share knowledge Contribute to database operations and continuous improvement activities, including on call rotation as assigned

What

you'll

need to succeed (required

skills)

Strong experience in Managing Team from DB technologies from SQL server, Oracle, and/or Sybase domains Hands-on experience with RDBMS Server Design, build and migrations. Very good experience with configuration of HA solutions like Failover cluster and Always solutions Migration experience to On promise SQL Server databases to Cloud like Azure/AWS Must have strong experience with SQL server security hardening and implementing best practices Expertise in managing multiple SQL Server 2005, 2008, 2012, 2014, 2016 and 2017 instances on medium to large systems Strong experience in handling very large databases Very good knowledge of Windows OS and its related commands Good knowledge of T-SQL and query tuning Performing tasks related to installation Enough expertise to identify and recommend changes/improvements to the build process Knowledge of SQL Server from architecture to administration including design, development, and optimization of SQL Server databases Proficient in performance tuning, backup, recovery, security, patching, upgrades, and high availability. Strong expertise in designing and High Availability (HA) deep skills in Windows Clustering, SQL Always on Availability Groups ,Clustering, log shipping, mirroring and Storage replication. Analyse, solve, and correct issues in real time, providing problem resolution end-to-end. scripting languages like PowerShell, or other shell scripting and Python, Ansible playbooks Working experience in working on Azure SQL Server and Database

What

will help you stand out (preferred

skills)

SQL DBA, Azure SQL with a minimum of 5 years of exp at expert level knowledge Project Management/Lead Experience with a minimum of 3 years of experience at expert level knowledge Oracle/Sybase DBA with a minimum of of 3 years of experience at intermediate level of knowledge

Working arrangements

We strive to provide flexibility wherever possible. Based on this role's business requirements, this is a remote position open to qualified applicants in Ontario and/or Nova Scotia, where our hubs are located. Regardless of your working arrangement, we are here to support a healthy work-life balance though our various wellbeing programs.


Note: The working arrangements for this role are accurate as of the date of posting. This may change based on the project you're engaged in, as well as business and client requirements. Rest assured; we will always be clear about role expectations.