Database Administrator – MSSQL

Database Administrator – MSSQL

ProViso Consulting

Story Behind the Need:

• Business Group: Client’s Global Technology and Enterprise Platform (GTEP) Database operations (MSSQL) team takes care of end-to-end support for Microsoft data platform products across the globe where client is present. Physical & logical database services, from deployment, project support and after go live steady state support is the essence of what we do.
• Project: 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. The Database Administrator must be prepared to provide remote dial-in support, or occasionally on-site support in response to routine monitoring alerts and scheduled & unscheduled maintenance tasks occurring after hours and on weekends.
• Candidate Value Proposition: The successful candidate will have the opportunity to work within client. We are technology partners who help the business transform how our employees around the world work. You will get to work with and learn from diverse industry leaders, who have hailed from top technology.

Typical Day in the Role:

• Collaborate with stakeholders across the Bank – technology, application security product, security advisory, fraud, compliance and business channel teams – to drive the product features and roadmap in application security domains like SAST, MAST, SCA, DAST etc across the Bank.
• Policies for SCA – Security Policies, Licensing Policies and Operational Policies
• Mobile App Publishing – coordinate with stakeholders to define the minimum-security requirements for publishing a Mobile app to the App Store (Google Play store, Apple etc)
• Continuously evolve app sec product features based on industry best practices and emerging security threats
• Govern and define DevOps pipeline and developer tooling use cases to integrate with enterprise app sec products
• Will work closely with multiple cross enterprise teams to gather requirements and the adoption of new security products.
• Implementation and operations governance based on the defined enterprise standard solution architecture and design patterns
• Co-ordinate efforts from business and technology teams.
• Communicate regularly with various business channels on the progress made for various projects in the pipeline

Candidate Requirements/Must-Have skills:

• 8-10+ years of progressive technical working experience as a Database Administrator.
• 5+ years of experience working with MSSQL Server 2022/2019/2017 and prior versions DB Administration
• GCP Cloud SQL(MSSQL) and Azure MI/DBaaS/IaaS database administration
• AD, Firewall IP/Port, domain trust/authentication methods related to MSSQL/Windows database connectivity
• Logical & Physical Backup/Recovery/Compression techniques
• MSSQL Services (SSRS/SSAS/SSIS/PolyBase, R Service, Power BI etc.)

Nice-To-Have Skills:

• Microsoft and/or Google Data Platform certification.
• Windows Servers 2019/2016 and prior versions.
• Application side tuning vs. server-side tuning.
• Setup MSSQL Always-On, Availability groups & Database Replication.

Soft Skills:

• You have good analytical, problem solving, trouble shooting and automation skills.
• You are a quick learner, with good interpersonal and communication (verbal/written) skills.

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 & team member (1 hour):
o 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.

Job Details

12088

Contract

4 months

Toronto

 





Latest Blogs

© 2020 ProViso Consulting - Toronto Recruitment and Staffing Agency

× Chat

Send this to a friend