SQL Developer

Profile

SQL Developer
Frisco, TX
SQL Server Developer
Ranger Technology Group is a technical recruiting firm headquartered in DFW, specializing in contract, contract to hire, and direct placement staffing solutions. We place engineering and IT professionals into positions for our clients all over Texas.
Ranger Technology Group currently has a great opportunity available for a SQL Developer with one of our clients located in the Frisco area.
The
SQL Server Developer
is responsible for working with business analysts and business users to gather and interpret business requirements for multiple financial and healthcare systems including large datawarehouses. 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.
Prior work experience implementing financial data analytics on SQL Server platform with SSIS processes pulling from multiple source system databases is a plus.
Responsibilities:
Design, construct, test and implement extraction and transformation programs, processes and cycles for historical and current source data
Creates technical specifications, test plans and test data to support ETL processes
Consult with the business to determine logical design for new business solutions according to existing data architecture
Perform code reviews, analyze execution plans, and refactor inefficient code
Follow 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 SDLC process
Minimum Experience and Education Requirements:
Requires some training in fields such as business administration, accountancy, sales, marketing, computer sciences or similar vocations generally obtained through completion of a four year Bachelor’s Degree program, technical vocational training, or equivalent combination of experience and education. Ideal candidate has between 3 to 5 years experience.
Required skills:
Demonstrated abilities in SQL Server Database Administration, SQL Server Database Architecture and Design (OLTP/OLAP), and SQL Server Database Programming and Development. SQL Server 2005 and SQL Server 2008 R2
Strong SQL skills and experience in database design, schema design, and SQL performance tuning and optimization
Experience and knowledge in designing scalable, high-performance datawarehouse and OLTP systems
Strong knowledge of T-SQL, Stored Procedures, Functions, Triggers and SSIS development Ability to Create and modify Tables
Create and modify Indexes
Create, modify and debug complex Procedures
Create, modify and debug complex Functions
Create, modify and debug Triggers
Create, modify and debug complex Views
Experience with SQL Replication, as well as Backup and Recovery methodologies
Understanding of multi-tiered application technology
Design experience with data warehousing projects, multi-dimensional databases, and financial focused software applications is strongly preferred
Strong analytical and problem solving skills
Ability to establish and build strong relationships across a broad range of personality types
Good oral and written communication skills
Strong attention to detail, process, deadlines, and quality results
Company Overview
find more jobs with this company

Company info

Sign Up Now - MiamiCrossing.com