SQL Developer in Allen, TX at HumCap Recruiting

Date Posted: 1/6/2020

Job Snapshot

Job Description

Description:
The SQL Developer will be an integral part of our client’s development team designing strategies for database systems and setting standards for operations, programming and security.
Duties & Responsibilities
• Design, create, and implement stable & reliable database systems based on end user requirements
• Design and create large relational databases and database tables to store applicant data
• Investigate exceptions with application, refine system performance and functionality
• Prepare documentation for database applications
• Develop database schemas, tables and dictionaries
• Ensure the data quality and integrity in databases
• Fix any issues related to database performance and provide corrective measures
• Create complex functions, scripts, stored procedures and triggers to support application development
• Review and analyze existing SQL queries for performance improvement, optimize code and suggest new queries
• Write queries used by applications and work with application developers to create optimized queries
• Perform data modeling to visualize database structure
• Integrate new systems with existing in-house structure
• Program views, stored procedures, and functions
• Develop, implement and optimize stored procedures and functions using T-SQL
• Review and interpret ongoing business report requirements, build appropriate and useful reporting deliverables and provide scheduled reports to management
• Develop procedures and scripts for data migration
• Perform security assessment for potential risks
• Provide architecture guidance and support to technical leads
• Develop best practices for database design and development activities
• Research new technologies and develop proofs of concept
Experience Needed
• BS/MS degree in Computer Science, Engineering or a closely related subject
• 3+ years of experience as a SQL Developer with understanding of T-SQL programming, SQL Server Reporting Services, SQL Server Integration Services, and Microsoft SQL Server
• Strong knowledge of HTML and C#, .Net, Visual Studio
• SSIS, SSRS
• Sense of ownership and pride in your performance and its impact on company’s success
• Team player with strong interpersonal and communication skills