SQL Server DBA
Company: kyyba
Location: Malden
Posted on: May 9, 2022
|
|
Job Description:
Job Title- SQL Server DBA
Location - Malden, MA 02148
Duration - 6+ months Extended
Responsibilities
Data warehouse: Design, build, and implement data warehouse
environment
Performance Tuning: Review monitoring tools and query execution
plans to maintain or increase query efficiency. Also perform root
cause analysis on query performance issues
Logical database design: Leverage knowledge of database
architecture to develop normalized database solutions
Database development: Work with application developers to deliver
data through the design of stored procedures, functions, and
views
Work with advanced features of SQL Server 2019
Upgrading older version to supported versions of SQL Server
Create database queries, indexes, and stored procedures, some with
high level complexity
Design complex physical and logical data models
Monitoring and troubleshooting SQL jobs, and integration service
packages
Writing and creating data load scripts and stored procedures;
ensuring that data is loaded in a timely manner
Working with application developers in the design, tuning, and
indexing of tables
Requirements
4-7 years of experience with SQL server 2008, 2012, 2014 and 2016,
2017, and 2019
Experience with SSRS, SSIS, and T-SQL
Experience working in a VMware environment
Sound knowledge of the firewall, networks and Servers
Must demonstrate experience managing the set up and upgrades of
complex databases, including interfacing with source control in
order to generate creation, upgrade, and maintenance scripts
Experience creating and optimizing database queries, indexes,
stored procedures, functions, triggers, and reports
Experience with database planning and design, set-up, maintenance,
performance tuning, and partitioning
Proficient production support skills with the ability to understand
the impact of a problem on overall DB performance.
Strong DB management skills incorporating backup and recovery best
practices in a high-availability environment.
Efficient SQL scripting skills.
Working knowledge of Windows O/S systems administration tasks.
Ability to work well with customers of varying levels of technical
expertise.
Keywords: kyyba, Malden , SQL Server DBA, IT / Software / Systems , Malden, Massachusetts
Click
here to apply!
|