Database Developer

Atria Group LLC; Minneapolis (MN); On-site; USD 90,000 - 110,000; Full time

Job summary

A leading consulting firm is looking for an experienced Database Developer in Minneapolis, MN. The role involves creating and optimizing database queries and performance tuning. Candidates should have significant experience with SQL Server and must possess strong communication skills. This position includes responsibilities such as designing complex data models and working closely with application developers. This is a long-term contract position with potential for extension.

Qualifications

• Multiple years of experience in database design and development.
• Extensive experience with SSRS, SSIS, and T-SQL.
• Proven experience in designing complex physical and logical data models.

Responsibilities

• Work with application developers to deliver data through the design of stored procedures, functions, and views.
• Design complex physical and logical data models.
• Create database queries, indexes and stored procedures.
• Perform root cause analysis on query performance issues.

Skills

Database design and development

SQL Server 2008+

SQL Server Management Studio

SSRS

SSIS

T-SQL

Performance tuning

Database set-up and maintenance

Job description

We specialize in Staffing, Consulting, Software Development, and Training along with IT services to small to medium size companies. AG's primary objective is to help companies maximize their IT resources and meet the ever-changing IT needs and challenges.

In addition, AG offers enterprise resource planning and enterprise application integration, supply-chain management, e-commerce solutions, and B2B public exchanges and B2B process integration solutions. Our company provides application analysis, design, development and programming, software engineering, systems development, testing, integration, and implementation, and management consulting services to various clients – including governmental agencies and private companies – throughout the United States and India.

We provide these services in multiple computing environments and use technologies such as client/server architecture, object-oriented programming languages and tools, distributed database management systems, state-of-the-art networking, and communications infrastructures. Our honest and realistic approach to recruiting dictates that AG does not entice or lure engineers from their employers. We represent only high caliber technical professionals who have committed to making a change required by career.

Job Description

Our client, a national financial leader, is looking for an experienced Database Developer to create and optimize database queries, indexes, stored procedures, triggers, and reports.

MUST HAVE SKILLS/EXPERIENCE

• Multiple years of experience in database design and development
• Experience with SQL Server 2008+, SQL Server Management Studio and other data management tools
• Extensive experience with SSRS, SSIS, and T-SQL
• Proven experience in designing complex physical and logical data models
• Significant experience in database set-up, maintenance, performance tuning, and partitioning

FINANCIAL INDUSTRY EXPERIENCE

• Self-directed, self-motivated and able to take a concept-to-implementation with a high degree of robustness
• Great communication skills. and a collaborator that performs well in a team-oriented environment
• Ability to make progress in a fast paced, ever changing environment

RESPONSIBILITIES

• Work with application developers to deliver data through the design of stored procedures, functions, and views.
• Design complex physical and logical data models.
• Create database queries, indexes and stored procedures, some with high levels of complexity.
• Review monitoring tools and query execution plans to maintain or increase query efficiency.
• Perform root cause analysis on query performance issues and other database issues.
• Write and create data load scripts and stored procedures.
• Work with application developers in the design, tuning, and indexing of tables.

Additional Information

GOOD COMMUNICATION SKILLS

DURATION: 12+ MONTHS

Target Start Date: 11/23/2015

Target End Date: 5/22/2016 with potential for extension