Malden - Senior SQL Server DBA
Experfy Inc Malden
The Database Administrator / Developer who will be responsible for the coordination and implementation of data analysis needs and activities relating to the design, implementation and maintenance of SQL server databases
Requirements
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
- 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
BayMark Health ServicesChelsea (MA), 3 mi from Malden (MA)
Part Time Medical Director Opportunity - Chelsea & Woburn, MA
Schedule: 2 days per week (7am - 2pm) - Tuesday in Chelsea and Wednesday in Woburn
HCRC(Health Care Resource Centers) services is dedicated to providing individualized treatment...
Winchester Country ClubWinchester (MA), 4 mi from Malden (MA)
Winchester Country Club is looking for a part-time Craftsman/Handyman.
The ideal person is flexible, knowledgeable, and always up to a challenge with proven skills to provide quality repairs in a beautiful clubhouse boasting character and charm....
Extra Space StorageMalden (MA)
As a **Store Manager** , you will have the opportunity to be part of a diverse team with an excellent company culture. We offer **competitive wages** , a **great work/life balance** , and **career and development opportunities** .
Extra...