sql dba

Position:

SQL DBA

Location:

Boston, MA

Duration: 6+ Months

Experience: 6+ Years

Job Responsibilities:

• Perform all database administration duties including but not limited to: replication management, backups/disaster recovery, server configuration, security/permissions management, index maintenance, query tuning, performance tracking, reviews/approves database changes, resolves outages/locking, and data warehousing.
• 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

• 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

Job Requirements:

• SQL Server DBA on a production system: 7+ Years' Experience with SSRS, SSIS, and T-SQL will be a plus
• 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
• Experience and Knowledge of power shell is a plus
• 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