SQL Developer

SQL Server Development, Data Modeling, Indexing and Performance Tuning
Full Time
Depends on Experience
Travel required to 25%.

Job Description

Title: SQL Developer 
Department: Systems Engineering (Data Systems)

Complete our quick application to be considered for this opportunity:  https://energyworldnet.bamboohr.com/jobs/view.php?id=92 

General Description
The SQL Developer is part of the Data Systems Team and reports to the Data Systems Manager. The SQL Developer is responsible for creating reliable, scalable, and performant stored procedures and functions within Energy Worldnet, Inc. (EWN) databases supporting EWN’s application platform.

Additionally, the SQL Developer is responsible for designing and creating data structures to support business processes and ensuring database stability, reliability, and performance to support the goals and vision of EWN using the latest development products and procedures. This position will coordinate with other members of the Data Systems Team to maintain and optimize in-application SQL statements and act as a resource to assist in solving all database usage issues, so excellent communication skills and computer abilities are essential. The SQL Developer must have a strong passion for excellence, focusing on execution and influencing innovation, quality, and predictability for continuous improvement.

Essential Job Functions and Responsibilities
• Work with Software Engineering to create and update stored procedures and user-defined functions
• Design and implement data structures to efficiently model business processes
• Complete ad hoc requests for research into and/or updating of data directly within SQL Server
• Analyze and complete development tasks as assigned
• Perform other work as assigned

Minimum Qualifications
• Associates degree or certificate in related field or Microsoft certifications relating to database development for SQL Server 2016 or later or a minimum of three (3) years of professional experience with Microsoft SQL Server; with most recent experience using 2016 or later
• Three (3) years of experience using software development methodologies

Knowledge, Skills, and Abilities Knowledge of:
• T-SQL development of stored procedures and user-defined functions
• Appropriate use of error handling, transactions, and windowing functions
• Efficient data modeling strategies
• Indexing and performance tuning
• Reading and understanding query execution plans
• Best practices when dealing with relational databases
• The principles, methods, and techniques of computer programming and systems analysis

Skilled in:
• Creating and modifying complex stored procedures and user-defined functions
• Creating efficient and scalable physical data models using tables, keys, and constraints
• Designing and implementing effective, efficient indexing strategies
• Analyzing query plans to identify and correct common performance problems
• Working with temporary objects, control-of-flow statements, transactions, error handling, variables, and user-defined data types
• Critical thinking and problem solving

Ability to:
• Communicate effectively
• Plan resource requirements from high-level specifications
• Troubleshoot common database issues
• Prepare program specifications; to code, test, and debug computer programs
• Interpret technical information related to computer programming and other areas of data processing

Preferred Qualifications and KSAs
• Agile development model (SCRUM, work assignments, timelines, and team structure)
• Oil, Gas, or Energy Industry experience

Job Specifications
FLSA Classification (Exempt, Non-exempt): Exempt
Full Time, Part Time, Temporary: Full Time
Travel Requirement (% of 40-hour workweek): Up to 30% Quarterly meetings; Events
Telecommute eligible (yes, no): Yes
Shift (note time and days): 8 hr shifts between 7 am–5 pm, M-F
Environment: Home Office, with some fieldwork

Dice Id : RTX1e83a5
Position Id : SQLDev_01-14
Originally Posted : 2 weeks ago
Have a Job? Post it

Similar Positions

IT SQL DBA
  • Vertical Screen, Inc.
  • Mount Laurel Township, NJ, USA
SQL Developer Job in Rochester, NY:
  • Modis
  • Rochester, NY, USA
Senior SQL Developer
  • Precision System Design Inc.
  • Twinsburg, OH, USA
SQL Developer
  • Apex Systems
  • Columbia, MD, USA
SQL Developer
  • IT-SCIENT
  • Dallas, TX, USA
Database Developer - TS/SCI Required
  • CGI Group, Inc.
  • Chantilly, VA, USA
Oracle PL/SQL Developer with Loan IQ
  • Synechron
  • Charlotte, NC, USA
Sr. SQL Developer
  • Systems Technology Group Inc. (STG)
  • Dearborn, MI, USA