SQL Server Administrator and Developer
Company: Trillium Staffing Solutions
Location: Malden
Posted on: March 12, 2023
|
|
Job Description:
Now hiring a SQL Server Administrator and Developer in
Malden!Trillium Technical is now seeking a SQL Server
Administrator/Developer for work in Malden, MA!
Now seeking a 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.
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 2014
--- Upgrading older version to SQL Server 2016
--- 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
Apply now!--- 4-7 years of experience with SQL server 2008, 2012,
2014 and 2016
--- 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.
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 databasesBy applying
to this job, I agree to receive electronic communications including
SMS text and email regarding future opportunities, referral bonus
incentives, and other promotions from Trillium. You may opt out at
any time from future communications by responding STOP to any
electronic communication.
You may view our full privacy policy at . #CBPRO
Keywords: Trillium Staffing Solutions, Malden , SQL Server Administrator and Developer, IT / Software / Systems , Malden, Massachusetts
Click
here to apply!
|