About the role
TekStaff's Client has a current vacancy for "SQL Database Administrator"
Job Description Typical Day in Role: • Configuration planning & deploying MSSQL servers on public cloud and on-premise • servers. • Performance tunning, capacity planning and monitoring. • Database maintenance/housekeeping including database rebuilds/re-indexing/expansion and • archiving. • Trouble-shoot MSSQL server problems and assist in the resolution of application problems. • MSSQL Server Software currency resolution including Patching/Upgrades/Migrations. • Assist in database code promotions & data fixes following internal change control process. • Disaster Recovery/High Availability (DR/HA) support with backup, recovery and • failover/failback of local and remote replicated databases. • Provide DBA support to development/implementation projects as assigned, doing • installations, database loading, migrations, testing, and go live support etc. • Follow Database best practices, security and change control process of the bank.
Candidate Requirements/Must-Have skills:
- 8-10+ years of progressive technical working experience as a Database Administrator.
- 5+ years of experience with Public Cloud including GCP Cloud SQL (MSSQL) and Azure MI/DBaaS/IaaS database administration.
- Hands on experience with MSSQL Services (SSRS/SSAS/SSIS/PolyBase, R Service, Power BI etc.) and MSSQL Instance/Database Installation/Configuration/Hardening.
- Hands on experience with MSSQL Servers 2022/2019/2017, Database Security, HA/DR, Performance & Tuning, Database Backup, and prior versions DB Administration.
- 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.
TekStaff may use artificial intelligence (AI) tools as part of the applicant screening process. However, applications will also be reviewed by a member of our Recruitment team to ensure a fair and thorough assessment.