SQL Server DBA
Company: RIT Solutions, Inc.
Posted on: January 11, 2022
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
Keywords: RIT Solutions, Inc., Malden , SQL Server DBA, IT / Software / Systems , Malden, Massachusetts
Didn't find what you're looking for? Search again!