Transform your resume with AI
Leverage AI rewrites and personalized suggestions to create a compelling resume
Start your free trial now →
NOTE: This is NOT a BI or ETL developer position. This is a T-SQL development role in support of application development.
GENERAL DESCRIPTION
The SQL Developer is part of the Data Systems Team and reports to the Manager of Data Systems.
The SQL Developer is responsible for creating reliable, scalable, and performant stored procedures and functions within Energy Worldnet, Inc. (EWN) databases in support of 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
Three (3) years of experience with Microsoft SQL Server; with most recent experience using 2016 or later
Three (3) years of experience using software development methodologies
Three (3) years of experience using Microsoft Excel and Word
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
Understanding of efficient data modeling strategies
Fundamentals of indexing and performance tuning
Best practices when dealing with relational databases
The principles, practices, and techniques of computer programming and systems analysis
Skilled in:
Fundamentals of reading and understanding query execution plans
Critical thinking and problem solving
Documentation (Word, Excel, Markdown, etc.)
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 KSA’s
Agile development model (SCRUM, work assignments, timelines, and team structure)
Experience with Atlassian JIRA ticketing system
Microsoft certifications relating to database development for SQL Server 2016 or later
Oil, Gas, or Energy Industry experience
JOB SPECIFICATIONS
FLSA Classification (Exempt, Non-exempt): Exempt
Must be US citizen or green card holder
Must NOT reside in California, New York, New Jersey or Massachusetts
Travel Requirement (% of 40-hour work week): Quarterly meetings **
Remote work eligible: Yes
Shift: 7am - 4pm, 8am - 5pm or 9am - 6pm M-F
Environment: Although this position is remotely located, the person hired for this position will have to travel monthly to work out of our main office in Decatur, TX. They will physically work in Texas 8 a.m. to 5 p.m. one (1) week per month during their probationary period (first 90 days of employment). At the end of the 90 day probationary period, the candidate will have the opportunity to apply for 100% telecommute. NOTE: With the current COVID restrictions, travel is TBD.