SQL DBA

Atria Group LLC; Raleigh (NC); On-site; Full time

Job summary

A leading IT consulting firm is looking for a Database Developer based in Raleigh, NC. The role involves complex SQL Server database development and database administration. Ideal candidates will have an extensive background in SQL, excellent communication skills, and a bachelor’s degree in a related field. Responsibilities include performance tuning, securing SQL servers, and participating in a .NET software development team. Competitive rate based on experience.

Qualifications

• 5+ years of experience in SQL Server database development with large-scale solutions.
• Strong work ethic with excellent database development skills.
• Demonstrated ability to prioritize tasks to meet goals.

Responsibilities

• Perform encryption/decryption in SQL Server.
• Secure SQL Server and enhance performance of complex queries.
• Work closely with developers and project management.

Skills

SQL (Transact-SQL)

Communication skills

SQL Server 2008

Database design patterns

Backup procedures

Data recovery methods

Creating and managing SSRS reports

Writing stored procedures

SSIS packages

Education

Bachelor’s degree in Information Technology, Computer Science, or Computer Engineering

Tools

Visual Studio for .NET Framework 3.5 and 4.0

Sybase

SAS

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

Direct End Client: State of North Carolina

Job Title: Database Developer

Location: Raleigh, NC

Start Date: 12/01/2015

Position Type: Contract

Interview Type: Phone followed by In-Person

Cbiz requirement ID: SNC_SQL558_PS

Primary Skills

• DOT NET Framework 3.5 and 4.0
• Sybase
• SAS

Secondary Skills

• DOT NET Framework 3.5 and 4.0
• Sybase
• SAS

Required Skills

• Successful challenging SQL Server database development experience including work on new, large-scale, complex solutions in an environment with rapidly changing requirements
• Strong communication and interpersonal skills
• Exceptional SQL (Transact-SQL) skills
• Strong Experience with SQL Server 2008 database, Integration Services, and Reporting Services in software development and production environments.
• Awareness of database design patterns and working experience of object-relational mapping.
• Demonstrated ability to prioritize multiple concurrent tasks to best meet overall goals
• Familiar with different Backup procedures
• Experience with Data recovery methods
• Develop create and manage SSRS reports
• Experience in DB Deployment procedures
• Experience in writing stored procedures
• Extensive knowledge with SSIS packages and SSRS reports
• Bachelor’s degree in Information Technology, Computer Science, or Computer Engineering
• Familiarity with SQL Server database administration

Highly Desired

• Experience with Visual Studio for .NET Framework 3.5 and 4.0 development
• Experience with Sybase and SAS

State of North Carolina Assignment

State Of North Carolina: Department of Health and Human Services (NC DHHS)

NC Department of Health and Human Services/Division of Medical Assistance is seeking a Senior Database Administrator resource for the NC-MIPS development project. The selected candidate must be a results-oriented candidate with a strong work ethic possessing excellent database development, communication, and problem-solving skills. This candidate will assume a database lead role for the development and implementation of the Medicaid EHR Incentive Payment System solution. In addition, the candidate will leverage their experience to ensure a successful solution delivery through data modeling, script development, database administration, report development, and ad-hoc queries.

Responsibilities

• Encryption/Decryption in SQL Server
• Securing SQL Server
• Performance tuning complex queries
• Transparent Data Encryption
• Log shipping
• Working closely with other developers, project management, and key stakeholders.
• Participating as key team member in a .NET software development effort.
• Assisting with the establishment of, and adherence to, development standards based on industry accepted methodologies and standards
• Leverage experience to envision solutions to problems and to execute the solutions
• Working on a small development team, (the candidate will be expected to be an expert in database technologies)

Rate: DOE