SQL Developer in Alpharetta, GA at HUNTER Technical Resources

Date Posted: 11/22/2019

Job Snapshot

Job Description

Responsibilities:

  • Provide technical and operational database administration assistance for MS SQL Server in Development, Test and Production environments to the Systems team. Expert resource for the Systems team, who manages the SQL Server environment.
  • Support multiple servers and multiple databases for high complexity with multiple concurrent users, ensuring control, integrity and accessibility of the data.
  • Create and maintain scripts and documentation for all aspects of administration including database design, implementation, data scrubbing, encryption, disaster recovery, and participate in disaster recovery process.
  • Backup and Recovery - Develop/Enhance a backup strategy taking into account recovery times to meet availability requirements.
  • Provide troubleshooting for SQL Server service outages.
  • Monitor production environment and identify performance bottlenecks. Collaborate with development team to improve data structures and underlying processes (SP, Functions etc.) eliminating bottlenecks.
  • Perform system optimization and improvement planning, including, but not limited to, SQL Server database performance monitoring and analysis, capacity planning, system sizing and ongoing maintenance and tuning to ensure maximum performance.
  • Perform code reviews, identify potential issues to reduce technical debt and provide coding best practice recommendations.
  • Provide technical support and share SQL expertise with developers.
  • Work with Dev team to develop, implement, and monitor standards and procedures to ensure optimum performance, scalability and reliability.
  • Data Movement/Warehousing - Develop processes to efficiently move data between systems. Take a lead role in an effort to design and develop a data warehouse environment housing archived data.
  • Develop new and optimize existing SP's, functions, views and scheduled jobs.
  • Provide accurate status updates on project tasks and prioritized assignments.

Requirements:

  • Bachelor's degree and three or more years of experience as a Microsoft SQL Server developer with significant SQL Server 2012/2014/2016 production experience. One year of experience as a DBA.
  • Experience with SSAS and OLAP cube design.
  • Expert working knowledge of the SQL language.
  • Solid experience with Performance Monitor, DMV's, Profiler and other tools to find other areas that need tweaking.
  • Experience with logical and physical database design.
  • Experience with SQL database development and working with developers in web-based environment.
  • Hands on knowledge with Microsoft SQL Server Business Intelligence offering of products - Analysis Services, Reporting Services and Integration Services.
  • Intuitive and analytical approach to problem solving.
  • Excellent communication skills (written and verbal).
  • A highly self-motivated individual with the ability to work effectively in a collaborative, team-first IT environment.