Location Address : fully remote, may change in future
Contract Duration : 6 months
Possibility of extension
Schedule Hours : 8 : 30am-5pm Monday-Friday;standard 37.5 hrs / week
Story Behind the Need :
Reporting to the DBA Manager / Lead, the Database Administrator would be supporting the MS SQL Server on-premises as well as on public cloud. As a member of the database administration group, you will assist in the team effort to maximize the availability, security, and performance of the databases.
Candidate Requirements / Must-Have skills :
1. 8-10+ years of progressive technical working experience as a Database Administrator.
2. 5+ years of experience with Public Cloud including GCP Cloud SQL (MSSQL) and Azure MI / DBaaS / IaaS database administration.
3. Hands on experience with MSSQL Services (SSRS / SSAS / SSIS / PolyBase, R Service, Power BI etc.) and MSSQL Instance / Database Installation / Configuration / Hardening.
4. Hands on experience with MSSQL Servers 2022 / 2019 / 2017, Database Security, HA / DR, Performance & Tuning, Database Backup, and prior versions DB Administration.
5. Hands on experience with Scripting and Automation with Power Shell, C#, VB Scripts, SSIS, TSQL etc.
Nice-To-Have Skills :
- Microsoft and / or Google Data Platform certification.
- Windows Servers 2019 / 2016 and prior versions.
- AD, Firewall IP / Port, domain trust / authentication methods related to MSSQL / Windows database connectivity.
- Application side tuning vs. Server-side tuning.
- Setup MSSQL Always-On, Availability groups & Database Replication.
- Logical & Physical Backup / Recovery / Compression techniques.
Soft Skills :
- You have good analytical, problem solving, trouble shooting and automation skills.
- You are a quick learner, with good communication (verbal / written) skills to be collaborate with other technical teams and business stakeholders. This includes attending meetings and sharing technical documentations.
Best vs. Average Candidate :
- Must meet the must-have requirements.
- Previous experience working in FI with regulatory / compliance environment.
Education :
- Post-secondary education in Computer Science, Math, or related discipline.
Candidate Review & Selection
- One round interview –Hiring manager + manager (1 hour) –Teams -
90% of the interview will be assessing technical skills listed in the must-have requirements such as Public Cloud, Database Security, etc. And 10% will be assessing soft skills / team fit.
- will review any requests for accommodations requested by the Suppliers