MSSQL Database BAU SupportUnited IT Solutions • Buffalo, NY, United States

MSSQL Database BAU Support

United IT Solutions • Buffalo, NY, United States

1 day ago

Job type

Full-time

Job description

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. OFSAA_STG_RO, OFSAA_STG_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 filesystem 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, sp_blitz, 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)

Create a job alert for this search

Database • Buffalo, NY, United States

Similar jobs

Database Engineer

VirtualVocations • Buffalo, New York, United States

Full-time

A company is looking for a Database Engineer responsible for optimizing data architecture and supporting data initiatives. Key Responsibilities Create and maintain optimal data pipeline architectu...Show more

Last updated: 8 days ago • Promoted

EPIC Proficient BI Developer

VirtualVocations • Buffalo, New York, United States

Full-time

A company is looking for a Revenue Cycle BI Developer.Key Responsibilities Understand database structures and business intelligence tools to create analytical solutions Serve as the first point ...Show more

Last updated: 1 day ago • Promoted

Top Secret GCP Database Administrator

VirtualVocations • Buffalo, New York, United States

Full-time

A company is looking for a Top Secret Cleared GCP Database Administrator to support a long-term program on a fully remote basis. Key Responsibilities Conduct quality control / audits of client / serve...Show more

Last updated: 1 day ago • Promoted

Data Integration Lead

VirtualVocations • Buffalo, New York, United States

Full-time

A company is looking for a Data Integration Lead - Healthcare Data Infrastructure.Key Responsibilities : Manage the complete data integration lifecycle from initial data request validation through...Show more

Last updated: 15 days ago • Promoted

Azure SQL Database Engineer

Syntricate Technologies • Buffalo, NY, United States

Temporary

Buffalo, NY (3 days onsite / 2 days remote).NOTES FROM MANAGER / REQUIRED SKILLS & EXP.We are seeking a highly skilled and experienced Azure SQL Database Engineer to manage, optimize, and secure our SQ...Show more

Last updated: 1 day ago • Promoted

Travel Board Certified Behavioral Analyst - School (BCBA) - $3,204 per week in Oneonta, NY

AlliedTravelCareers • Buffalo, New York, US

Full-time

Board Certified Behavioral Analyst - School.AlliedTravelCareers is working with Centra Healthcare Solutions to find a qualified BCBA - School in Oneonta, New York, 13820!.Centra Healthcare Solution...Show more

Last updated: 30+ days ago • Promoted

Senior SQL and ETL Engineer

VirtualVocations • Buffalo, New York, United States

Full-time

A company is looking for a Senior SQL and ETL Engineer.Key Responsibilities Design and implement scalable ETL / ELT workflows and data models for data warehouses Optimize SQL queries and ETL proce...Show more

Last updated: 1 day ago • Promoted

SAP Data Migration Specialist

VirtualVocations • Buffalo, New York, United States

Full-time

A company is looking for an SAP Data Conversion Support professional to lead SAP ECC to SAP S / 4HANA data migration initiatives. Key Responsibilities Support the rationalization and migration of ma...Show more

Last updated: 2 hours ago • Promoted • New!

Senior Database Engineer

VirtualVocations • Buffalo, New York, United States

Full-time

A company is looking for a Senior Database Engineer III.Key Responsibilities Provide all activities related to database administration, ensuring accessibility, security, and performance Communic...Show more

Last updated: 30+ days ago • Promoted

BI Analyst

VirtualVocations • Buffalo, New York, United States

Full-time

A company is looking for a BI Analyst to mine data and provide insights for business decisions.Key Responsibilities Set up and execute ETL functions to build data pipelines Create and manage rep...Show more

Last updated: 7 days ago • Promoted

Software Engineer II - Azure SQL Database Engineer

Syntricate Technologies • Buffalo, NY, United States

Temporary

Software Engineer II - Azure SQL Database Engineer.Buffalo, NY (Hybrid 3 days onsite / 2 days remote).NOTES FROM MANAGER / REQUIRED SKILLS & EXP. We are seeking a highly skilled and experienced Azure SQ...Show more

Last updated: 1 day ago • Promoted

Oracle Cloud Consultant

VirtualVocations • Buffalo, New York, United States

Full-time

A company is looking for an Oracle PPM and AP Cloud Techno-functional Consultant.Key Responsibilities Lead and support end-to-end Oracle PPM and AP Cloud implementations Conduct business process...Show more

Last updated: 4 days ago • Promoted

Senior Database Architect

VirtualVocations • Buffalo, New York, United States

Full-time

A company is looking for a Senior Database Architect responsible for designing and implementing database structures aligned with business requirements. Key Responsibilities Design and create datab...Show more

Last updated: 4 days ago • Promoted

Postgres SME with Secret Clearance

VirtualVocations • Buffalo, New York, United States

Full-time

A company is looking for a Postgres Subject Matter Expert (SME) with Secret Clearance.Key Responsibilities Design, implement, and maintain high-performance Postgres database environments Trouble...Show more

Last updated: 1 day ago • Promoted

Database Support Analyst

VirtualVocations • Buffalo, New York, United States

Full-time

A company is looking for a Database Support Analyst 2 to collect and maintain healthcare provider data while ensuring data accuracy and quality. Key Responsibilities Collect and maintain data from...Show more

Last updated: 6 days ago • Promoted

Database Specialist

TradeJobsWorkForce • 14213 Buffalo, NY, US

Full-time

Database Specialist Job Duties : Plans database upgrades by maintaining , evaluating, and improving a...Show more

Last updated: 30+ days ago • Promoted

Azure SQL Database Administrator

VirtualVocations • Buffalo, New York, United States

Full-time

A company is looking for a SQL Server Database Administrator.Key Responsibilities Design, deploy, and manage SQL Server environments in Azure Automate SQL deployments and manage performance moni...Show more

Last updated: 8 hours ago • Promoted • New!

Travel Board Certified Behavioral Analyst - School (BCBA) - $2,634 per week in Yonkers, NY

AlliedTravelCareers • Buffalo, New York, US

Full-time

Board Certified Behavioral Analyst - School.AlliedTravelCareers is working with Centra Healthcare Solutions to find a qualified BCBA - School in Yonkers, New York, 10704!.Centra Healthcare Solution...Show more

Last updated: 30+ days ago • Promoted