SQL Developer in Allen, TX at HumCap Recruiting

Date Posted: 1/6/2020

Job Snapshot

Job 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
• Sense of ownership and pride in your performance and its impact on company’s success
• Team player with strong interpersonal and communication skills