SQL Database Developer

SQL Database Developer

SQL Database Developer

Accentuate Staffing is currently recruiting for a SQL Database Developer to join a growing insurance company located in Raleigh, NC. The ideal candidate will develop, manage, and model enterprise data architecture, including the enterprise data warehouse and other production database environments. If you are looking to gain experience with a fast-growing team and be a part of a collaborative work environment, this is the position for you!

Responsibilities:

Database Management and Maintenance

  • Create T-SQL stored procedures, user-defined functions, triggers, and other objects that assist in the implementation of business rules/logic
  • Create and maintain:
    • SSIS packages
    • SSRS reporting
    • SQL Agent jobs
    • OLAP cubes
  • Design and develop relational database models/schemas
  • Develop ETL processes
  • Design and make recommendations to improve current processes and overall platform
  • Perform DBA related activities such as optimization, index rebuilds, clustering, etc…
  • Query performance tuning
  • Generate ad-hoc queries

Database Compliance and Disaster Recovery

  • Collaborate with stakeholders on requirements gathering, testing, and implementation
  • Create and maintain documentation as well as source control
  • Perform DBA related activities such as database security and backups
  • Improve/optimize Disaster Recovery data model
  • Follow IT guidelines according to best practices

Development and Support

  • Provide other IT support when needed
  • Provide knowledge transfer to other IT members

Requirements:

  • 5+ years of Microsoft BI Technology (SSRS, SSAS, and SSIS)
  • 5+ years developing with Microsoft SQL Server and T-SQL
  • An equivalent combination of education and experience may be substituted.
  • In depth understanding of Data Warehousing concepts, methodology and data architecture
  • Excellent problem solving abilities
  • Familiarity with Agile Development methodology
  • Organize and prioritize individual workload in order to meet required deadlines
  • Communicate effectively with team members, team leads, and management
  • Work as a member of a team, accept ownership of work and actively contribute in team discussions