Database Developer II
Carrollton, TX

Job Description

The Database Developer II is responsible for working with business analysts and business users to gather and interpret business requirements for multiple financial and healthcare systems including large data warehouses. The successful candidate will create technical designs within the existing architecture and develop complex SQL query logic to accomplish the task.

The candidate should be competent to complete most development tasks independently but may require instruction and guidance on complex tasks.

* Design and develops database applications using SQL Server Integration Services TSQL and Stored Procedures.
* Consult with the business to determine logical design for new business solutions according to existing data architecture
* Perform code reviews analyze execution plans and re-factor inefficient code
* Follows data standards resolves data issues completes unit testing and completes system documentation for ETL processes
* Collaborate with business analysts source system experts and other team members to determine data extraction and transformation requirements
* Collaborate with IT operations and testing organizations to ensure timely releases of projects and database environments are sustainable
* Collaborate with IT operations for support in problem resolution and root cause analysis.
* Support IT staff and business users in the development usage and troubleshooting of database-driven applications
* Participate in special projects as needed and performs other duties as assigned.
* Provides on-call assistance as needed
* Ensure development follows the IQA process
* BS or BA or equivalent experience required.
* 4 years of SQL Server programming experience.
* Knowledge of physical database administration with SQL Server a plus.
* Excellent written and verbal communications skills required.
* Must be able to work in a fast paced team environment.
* SQL Server Database Architecture and Design (OLTP/OLAP) and SQL Server Database Programming and Development. SQL Server 2016 and SQL Server 2017
* Strong knowledge of T-SQL Stored Procedures Triggers and DTS development