Previous Job
SQL BI Developer
Ref No.: 18-00193
Location: Houston, Texas
Position Type:Contract to Hire
Start Date: 03/13/2017
Position Summary: The SQL Developer is responsible for ensuring the design, development and maintenance of the enterprise data warehouse. This includes designing integration solutions, reporting solutions and supporting Net Developers. This position will also be responsible for the maintenance, tuning, and backup of each database and/or server.

Essential Duties and Responsibilities include the following.  Other duties may be assigned.
  • Design, analyze code, optimize and maintain all databases, tables, stored procedures, indexes, triggers, data extraction, transformation, and validation as well as other processes as required.
  • Works closely with application developers and business division to define requirements for advanced database designs.
  • Provide advice and guidance on database good practices.
  • Provide input on systems architecture as required.
  • Follow all security practices and identify areas and processes where performance and security can be improved.
  • Make and justify recommendations for improvement.
  • Continuously tune and optimize SQL Server databases. Ensure that code and other deliverables adhere to company standards.
  • Provide all required additional support to Development, Quality Assurance, and Production Support Teams.
  • On-call status is a requirement of the position.
  • Work on special projects as needed.
  • To perform this job successfully, an individual must be able to perform each essential duty satisfactorily.
  • The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
  • Bachelors degree or equivalent work experience.
    Major field of study: Computer Software Programs preferred.
  • Total years of prior related experience (specify kinds of experience):
    • 2+ years related experience, and/or training or equivalent combination of education and experience. 
    • Preferably, experience in design, development and maintenance of database/server
Special skills/abilities/competencies required:
1.      Knowledge of SQL Server 2012
2.      Knowledge of SQL Server Reporting Services
3.      Knowledge of SQL Server Integration Services
4.      Experience in Relational Database Design, T-SQL and Dynamic SQL
5.      Excellent communication skills (verbal, written, interpersonal and large group)
6.      Excellent interpersonal and listening skills
7.      Strong interpersonal/relationship building skills
8.      Problem solving and decision making ability
9.      Strong analytical skills and a strategic thinker
10.  Strong organizational skills and ability to work with details
11.  Ability to work well independently and with a team
Preferred Skills, Experience and Certifications:
  • Knowledge in MSP and Process Management
  • Familiar with Reflection Attachmate software
  • Expert in .NET, C#, VB.NET, Visual Studio 2005-2013, AJAX, ASP.NET MVC, SQL Server 2005, 2012, T-SQL, Jquery/Javascript, VSS, TFS, WCF, Webservices, Silverlight
  • Familiar with home loan mortgaging and business rules like loan modifications,
  • Short sale, Deed in Lieu, Foreclosure, Bankruptcy etc
  • Microsoft Certification