More jobs:
MSSQL Database BAU
Job in
Buffalo, Erie County, New York, 14266, USA
Listed on 2026-01-12
Listing for:
United IT Solutions
Full Time
position Listed on 2026-01-12
Job specializations:
-
IT/Tech
Database Administrator, Data Engineer
Job Description & How to Apply Below
- Must be able to join daily standups virtually or physically (usually 9-10am ET)
- Working with M&T database team to provision new MSSQL instances (includes SSRS, SSIS, SSAS)
- Setup and maintenance of application‑specific database roles (e.g. _RO, _RW) with environment‑specific requirements (R/W in DEV, R/O in PROD). Mapping of AD groups to database roles.
- Maintain automated quarterly recertification report for users, roles, permissions
- Maintain automated CI/CD pipelines for DDL/DML changes (Redgate Flyway)
- Perform code review of developer DDL/DML commits (Gitlab). Request developers to provide pre/post change runtimes of queries to avoid major performance degradation after release to PROD.
- Migration of large datasets between environments either by ourselves or by working with the DB team. Tools (e.g. Redgate) or custom ETL scripts may be required. We may not have access to the local file system for bulk export/import.
- Monitoring space usage in all environments. Proactively implementing purging scripts or identifying & moving objects (e.g. data files) to new drives. Converting non‑partitioned tables to partitioned.
- Troubleshooting of slow ad‑hoc queries or application‑generated queries. Must be experienced going beyond typical analysis (gather stats, check explain plan, check query store, , etc.) the developers are doing themselves today. What can you suggest when all the usual "quick fixes" do not work?
- Knowledge of table lock escalation and mitigation approaches
- Setup and maintain Maintenance Plans (backups, log shipping, gather statistics, etc) based on the application/user needs
- Perform disaster recovery (DR) exercises annually (fairly simple due to Exadata platform setup)
- Migration of databases to MSSQL 2019 from earlier versions
- Monitor and troubleshoot daily/monthly processes that are primarily built/executed within SQL Server (e.g. ETL)
To View & Apply for jobs on this site that accept applications from your location or country, tap the button below to make a Search.
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).
Search for further Jobs Here:
×