SQL SERVER DBA

Description

Responsibilities Confirm development\preproduction database servers are backed up and meeting engineering recovery needs.
Keep Confluence and Database Documents up to date the all TCM environments.
Deploy database changes to development\preproduction\production database environments.
Identify and troubleshoot resource intensive operations on SQL Server.
Collaborate with engineering, developers, SMEs and others, provide suggestions on how to improve database design on database objects.
Review all SQL scripts, stored procedures, functions, etc. And make sure SQL coding standards used by other developers.
Performs complex bug verification, release testing and beta support for assigned products, researching problems discovered by QA or product support.
Ability to translate TCM business needs into technical solutions for application and reporting requirements and identify the data sources to fulfill any given requirements and provide level of effort estimates
Ability to communicate effectively both verbally and in writing
Create and maintain SSIS, replication, and SQL Agent jobs and other database processes.
Microsoft SQL Server Administration skills for SQL 2008 R2, 2012, 2014, 2016, and 2017
Education / Experience A completed college degree is preferred.
Experience with the Microsoft SQL Server software stack SQL Server databases, SQL Server Integration Services, and SQL Server Reporting Services.
3 + years of related experience at a professional level.
Qualifications and requirements Strong communication skills
Develops solutions to the problems.
Ability to determine root cause of given database problem and offer solutions to minimize future application impact
Experience with scalability, slow query optimization
Review, evaluate, design, implement, and maintain the database environments
Eagerness to work collaboratively with a the engineering team in an agilescrum process
Experience installing, administering, and maintaining SQL Server Expertise in crafting a performance tuning of complex SQL Server database objects.
Oncall troubleshooting experience for SQL Server.
Ability to perform database maintenance tasks such as performancetuning, partitioning, backups, indexing, job maintenance, and SQL Server version upgrades.
Experience with Reporting Services, and/or Integration Services.
Preferences Familiarity with troubleshooting application and database logic.
Knowledge of Entity Framework is a plus.
Prior experience with IOT or Telecom is a plus.