MaldenRecruiter Since 2001
the smart solution for Malden jobs

SQL Server DBA

Company: RIT Solutions, Inc.
Location: Malden
Posted on: January 11, 2022

Job Description:

Job DescriptionDuration: 12 monthInterview: VideoVisa: GC/USC/H4EAD/TNRemote till Covid19. Must have LinkedIn profile!! 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 2014Upgrading older version to SQL Server 2016Create 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 tablesRequirements4-7 years of experience with SQL server 2008, 2012, 2014 and 2016Experience 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. Nice to have: --- Familiarity with other relational database platforms such as Postgres, Oracle --- Familiarity with AWS Cloud data related services such as S3, RDS (Aurora, SQL Server), Glue --- Interest in cloud data management and data warehouse technologies e.g. Snowflake, DynamoDB, NoSQL databases

Keywords: RIT Solutions, Inc., Malden , SQL Server DBA, IT / Software / Systems , Malden, Massachusetts

Click here to apply!

Didn't find what you're looking for? Search again!

I'm looking for
in category

Log In or Create An Account

Get the latest Massachusetts jobs by following @recnetMA on Twitter!

Malden RSS job feeds