Database Developer

Profile

JOB SUMMARY
The Judge Group is looking for a Senior Database Developer is responsible for SQL database development in support the OLTP databases and business applications. This individual will support application projects from a database development perspective including new initiatives as well as existing efforts. This person will be responsible for understanding complex business processes and will support them with development of complex queries. This person is responsible for adherence to coding standards, change control and SQL best practices.
Daily Functions
Design and develop complex SQL queries and appropriate database code such as stored procedures, triggers, functions to support complex business processes.
Develop and deliver extensible/sustainable/quality database solutions based on defined business needs.
Develop ad-hoc scripts, including cleanup scripts as needed.
Review and update stored procedures for optimal performance. Identify and correct performance bottlenecks related to SQL code.
Recommend changes to the relational data model to solve performance issues with SQL code. Requires a solid understanding of relational database design and concepts.
Monitor and troubleshoot SQL jobs using available tools such as SQL Profiler; review logs and triage issues.
Participate in the resolution of production data issues.
Perform code reviews, providing feedback in a timely manner. Incorporate feedback from code reviews as appropriate.
Partner with BSA staff on development/review of business requirements for database related projects.
Work with QA staff to resolve defects and issues.
Participate in the review of all database schema projects; provide feedback and identify impacts to existing environment.
Monitor business data stored in production OLTP databases, ensuring integrity of the data is maintained.
Responsible for developing, maintaining and deploying SSIS packages.
Participate in release of all stored procedure projects; including release documentation.
Maintain knowledge as new versions of SQL Server are released and leverage new functionality as appropriate.
Proactively identify and act on opportunities to improve database systems and processes.
Contribute to standards documentation for database coding practices.
Prioritize multiple tasks so that aggressive deadlines are met.
ADDITIONAL DUTIES AND RESPONSIBILITIES:
Provide ongoing suggestions for improvement and innovation within the department.
Exhibit sound, methodical engineering judgment, and effectively manage trade-offs in a business environment.
EDUCATION AND EXPERIENCE:
BS degree in Computer Science preferred or equivalent work experience.
5 years of experience in a Microsoft SQL Server environment (with recent experience using SQL Server 2008 R2).
3-5 years of experience in a database development role.
8 years of professional IT experience required.
2 years of experience with MS SQL Server Integration Services (SSIS).
Experience with Data Warehousing/Business Intelligence projects a plus.
QUALIFICATIONS:
Highly proficient with SQL Server and strong programming skills with SQL including complex SQL programming, stored procedures and performance tuning. Extensive knowledge of T-SQL.
Solid understanding of principles of database design and modeling as well as data quality best practices.
Expert knowledge of stored procedure writing and best practices.
Strong technical design and data analysis skills.
Solid experience with SQL tuning to improve query performance.
Ability to reverse engineer and understand code in support of development and troubleshooting efforts.
Ability to learn new technical skills easily and troubleshoot data-related issues and errors.
Proven experience writing stored procedures for maintaining data.
Ability to develop work estimates and deliver on time with a high degree of quality.
Ability to work collaboratively within the team, providing and incorporating feedback as appropriate.
Experience with code management systems and team collaboration tools.
Excellent written and verbal communication skills, including solid documentation skills.
Self-starter, willing to take on challenges and responsibility with minimal direction.
Strong problem solving skills and the desire to learn from and contribute to the project team.
Experience with Scrum/Agile methodologies a plus.
Herbert Kent
The Judge Group, Inc.
Web: ****

Company info

Sign Up Now - MiamiCrossing.com