SQL Server Developer

SQL Server Developer

Work Location: Fort Mill, SC (ONSITE)

Job Description:

*****Must go ONSITE from Day One (NO REMOTE)*****

Requirements:

• 10 years of experience in IT database administration and architecture
• Demonstrated practical knowledge of database design, programming, installation and configuration, optimization, and troubleshooting
• Experience with SQL Server 2012 and above, T-SQL, Integration Services (SSIS)
• Experience with SQL Reporting Services (SSRS)
• Familiarity with C#, ASP.net, and the .Net Framework
• Familiarity with Microsoft Azure a plus
• Ability to interpret, adapt, communicate, and apply guidelines and procedures
• Ability to develop and implement short- and long-range computer systems, capacity, and operational plans
• Knowledge of business practices and procedures

Position Responsibilities:

• Create and modify database structures based on DDL generated from methodology tool or database package
• Application development: design, code, optimize databases for internal Client applications - this includes table structure design and stored procedures, as well as security aspects, to be used by the software engineering team
• Install new software, upgrades and fixes in coordination with server administrators
• Backup and recovery: plan, prepare, and test backup and recovery procedures for production databases
• Maintain documentation describing the database systems infrastructure and major processes
• Task scheduling, coordinate backups, batch processing, and maintenance schedules with network administrators to ensure optimal performance and system uptime
• Assist developers as needed with guidance in efficient query design
• Tune and monitor databases for efficiency – periodically reorganizing databases for optimal performance during scheduled down time
• Create indices and manipulate tuning parameters where needed to enhance performance; identify processing bottlenecks and inefficiencies in query & process design
• Capacity Planning: calculate volumetric equations to estimate new database sizes and plan appropriately for growth and communicate plans to server administrators
• Participate in application development processes to facilitate good database design and access techniques
• Support application teams and resolve database problems
• Ensure a consistent and high level of service is delivered to end users in accordance with the departmental Service Level Agreement (SLA)
• Participate in the development, implementation, and maintenance of policies, objectives, short- and long-range planning of data systems
• Maintain a broad knowledge of state-of-the-art technology, equipment, and systems