Previous Job
Previous
Senior SQL Developer
Ref No.: 17-03112
Location: The Woodlands, Texas
Job Title: Senior SQL Developer
Job Location: The Woodlands, TX
Position Type: Contract  
Pay Rate:  DOE
 
US Citizen, Green Card, GC EAD and H4 EAD only.
No sponsorship available for this job, NO C2C
 



Job Description: 
Large Oil and Gas Company in Houston is seeking to hire a Senior SQL Developer (ETL) for a 1+ year contract position.  This position will be located in the Northwest Houston area but the training for this role will be in Fort Worth.  Training in Fort Worth will last 4-6 weeks, then this SQL Developer will work full-time in Houston.
Responsibilities:
  • Writes / Troubleshoots Data Services ETL jobs, SSIS packages and SQL server stored procedures, functions, etc.
  • Gathers requirements from users for data manipulation and loading of data into data warehouse and other SQL server, Oracle and other types of files / databases. 
  • Determines ways and security needs to obtain data from outside company sources.
  • Performs system maintenance as required based on performance testing.
  • Determines required database objects (i.e. indexes, functions, views, etc.) for SQL query performance.
  • Uses standard change management processes, promotes changes through all environments (dev / test / prod).
  • Creates and maintains documentation and team programming standards.
  • Maintains and adheres to any required controls for risk management as documented in the application risk assessments.
  • Adheres to all company polices, department standards and procedures.
  • Participates in on call rotation for SQL jobs
Required skills:
  • Senior level T-SQL.
  • SAP data services ETL (or similar ETL tool).
  • SSIS.
  • Database Design.
  • ETL Administration experience.
  • Lotus Notes, Outlook, MS Office, General IT skills.
  • Knowledge of the Oil & Gas business is a plus.