Senior SQL Database Administrator - MA...

Senior SQL Database Administrator

Malden, MA

6months

Phone and face to face

Senior SQL Database Administrator, Malden, MA. 6 months +,

DUTIES AND 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
• 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

REQUIREMENTS

• 4-7 years of experience with SQL server 2008, 2012 and  2014
• Extensive 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

 

 

Regards,

Manju Shree

Sr IT Recruiter
IDC Technologies, Inc. 1851 McCarthy Boulevard, Suite 116,Milpitas, CA, USA, 95035
Phone: 408-418-5779 ext 252 |Fax: 408-608-6088 |

Email: manju@idctechnologies.com| Web: www.idctechnologies.com

 

--
You received this message because you are subscribed to the Google Groups "SureShotJobs" group.
To unsubscribe from this group and stop receiving emails from it, send an email to sureshotjobs+unsubscribe@googlegroups.com.
To post to this group, send email to sureshotjobs@googlegroups.com.
Visit this group at http://groups.google.com/group/sureshotjobs.
For more options, visit https://groups.google.com/d/optout.