SQL Server DBA
Company: kyyba
Location: Malden
Posted on: May 11, 2022
|
|
|
Job Description:
Job Title- SQL Server DBALocation - Malden, MA 02148Duration -
6+ months Extended ResponsibilitiesData warehouse: Design, build,
and implement data warehouse environmentPerformance Tuning: Review
monitoring tools and query execution plans to maintain or increase
query efficiency. Also perform root cause analysis on query
performance issuesLogical database design: Leverage knowledge of
database architecture to develop normalized database
solutionsDatabase development: Work with application developers to
deliver data through the design of stored procedures, functions,
and viewsWork with advanced features of SQL Server 2019Upgrading
older version to supported versions of SQL ServerCreate database
queries, indexes, and stored procedures, some with high level
complexityDesign complex physical and logical data modelsMonitoring
and troubleshooting SQL jobs, and integration service
packagesWriting and creating data load scripts and stored
procedures; ensuring that data is loaded in a timely mannerWorking
with application developers in the design, tuning, and indexing of
tables Requirements4-7 years of experience with SQL server 2008,
2012, 2014 and 2016, 2017, and 2019Experience with SSRS, SSIS, and
T-SQLExperience working in a VMware environmentSound knowledge of
the firewall, networks and ServersMust demonstrate experience
managing the set up and upgrades of complex databases, including
interfacing with source control in order to generate creation,
upgrade, and maintenance scriptsExperience creating and optimizing
database queries, indexes, stored procedures, functions, triggers,
and reportsExperience with database planning and design, set-up,
maintenance, performance tuning, and partitioningProficient
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!
|
