Sql database administrator Jobs in Denton, TX

ERCOT Electric Power Market Settlement Administrator

This requisition expires on July 6, 2026, but may close earlier if the position is filled prior to the expiration date. Responsible for administering all ERCOT electric power market settlement issues including data collection/validation, billing, disputes and power mismatches. Responsible for administering billing, payment, and settlement for all Power Purchase Agreements and Physical or Financial energy trading activity.

Essential Functions and Other Important Duties

• Determine if power market settlement issues need to be disputed with ERCOT
• Gather, analyze and validate all in-house QSE load, generation, purchased power, ancillary service and financial data by 15-minute intervals on a daily basis for accuracy
• Prepare and submit appropriate dispute documents to ERCOT, with supporting backup information, within the mandated 10-day deadline
• Ensure that ERCOT power market settlement data and documents are correct, accurate, timely and are applied as per market protocols
• Prepares an ERCOT Shadow Settlement daily, continually updating the Excel and Access tools as needed to respond to market and/or DME operational changes
• Prepare monthly reports for Management
• Processes all ERCOT and Counterparty Invoices for payment: Receipt, Storage, Validation, Communication, Confirmation & Documentation
• Conducts analysis and comparisons of utility rates across the ERCOT region
• Perform various generation, transmission, market studies, and/or administrative duties as delegated/required
• Performs historical analyses of price, volume, and cost to report annual metrics and provide operational insight to management
• Verify and process payments for all invoicing concerning DME Power Supply Administration activities
• Assists in negotiation of power supply contracts
• Coordinates with other City departments, outside agencies and consultants as appropriate
• Maintains regular and punctual on-site attendance

Additional Duties: Performs other duties as assigned

Job Requirements

Minimum Qualifications / Acceptable Equivalency:

• A Bachelors degree in Finance, Business Administration, Economics, Accounting or Engineering
• Six (6) years of previous work experience for an electric utility, two (2) years of which should be in wholesale energy supply and/or ERCOT Settlements
• A Master's Degree in Finance, Business Administration, Economics, Accounting or Engineering with
• Four (4) years of previous work experience for an electric utility, two (2) years of which should be in wholesale energy supply and/or ERCOT Settlements
• Any combination of related education, experience, certifications and licenses that will result in a candidate successfully performing the essential functions of the job

Competencies:

• Must possess required knowledge, skills, abilities and experience and be able to explain and demonstrate, with or without reasonable accommodations, that the essential functions of the job can be performed
• Knowledge of wholesale fuel, electric markets and evolving industry and regulatory developments in ERCOT
• Skills built through ERCOT Market Training and familiarity with the ERCOT Nodal Protocols
• General knowledge of electric market and accounting/finance principles terminology
• Considerable knowledge of Microsoft Excel and Microsoft Access
• Familiarity with Microsoft SQL
• Familiarity with writing/debugging Visual Basic Code in Excel
• Considerable knowledge of other Microsoft Office Software
• Proficient knowledge and understanding of ERCOT data collection requirements
• Skill to work in a team environment as a positive influence
• Ability to analyze complex mathematical equations and understand associated terminology
• Ability to implement contractual terminology into mathematical expressions
• Ability to grasp and apply new concepts
• Skill in handling multiple tasks and prioritizing work
• Skill in using computers and related software applications
• Skill in data analysis and problem solving
• Ability to work with frequent interruptions and changes in priorities
• Ability to quickly recognize and analyze irregular events
• Skill in using available software packages and equipment, which may include the following: Personal computer with Windows operating system, Microsoft Office (applications for word processing, spreadsheets, databases, and presentations), and Microsoft Outlook email system
• Ability to prioritize tasks and work efficiently to cope with many deadlines
• Ability to communicate effectively both verbally and in writing

Preferences:

• ERCOT Market settlement experience

Conditions of Employment:

• Must have and maintain a valid Class "C" Driver's License and valid state required minimum automobile liability insurance prior to employment (must obtain Texas Class "C" driver's license and state required minimum automobile liability insurance within 90 days of hire per state law)
• Must pass a drug test, driver's license check, criminal history background check, and social security number verification check

Environmental Factors and Conditions/Physical Requirements

Physical Requirements: Overall Strength Demands: The bold and italicized word describes the overall strength demand of the functions performed by the incumbent during a typical workday.

• Sedentary lifting no more than 10 pounds
• Light lifting no more than 20 pounds; carry up to 10 pounds
• Medium lifting no more than 50 pounds, carry up to 25 pounds
• Heavy lifting no more than 100 pounds, carry up to 50 pounds
• Very Heavy lifting more than 100 pounds, carry more than 50 pounds

Physical Demand Codes: The following describes if the incumbent is expected to exert the following physical demands during a typical workday and the overall frequency. Codes for "how often": Y = Yes N = No E = extensive (100-70%) M = moderate (60-30%) I = infrequent (20-10%) A = almost never (<10%)

• Standing: M
• Sitting: M
• Walking: M
• Lifting: A
• Carrying: I
• Pushing/Pulling: A
• Overhead Work: A
• Fine Dexterity: M
• Kneeling: A
• Crouching: A
• Crawling: A
• Bending: I
• Twisting: I
• Climbing: A
• Balancing: A
• Vision: E
• Hearing: M
• Talking: M
• Video Display: E
• Other:

Machines, Tools, Equipment and Work Aids: The essential functions of this position require the use of a telephone and computer. Environmental Factors: This position is required to work indoors in environmentally controlled areas and occasionally may be required to work outdoors, possibly during inclement weather.

EEO STATEMENT The City of Denton is an equal opportunity employer. It is the City of Denton's policy to prohibit discrimination and harassment of any type and to afford equal employment opportunities to employees and applicants without regard to any protected class, status, characteristic, or activity. All employment decisions, including decisions regarding recruitment, selection, hiring, compensation, benefits, training, advancement, discipline, discharge, and other terms, conditions, and privileges of employment are made without regard to any lawfully protected class, status, characteristic, or activity. ADA/EOE/ADEA This job description is not an employment agreement, contract agreement, or contract. Management has the exclusive right to alter this job description at any time without notice.

E-Verify: The City of Denton participates in the federal E-Verify program in order to verify a new employee's authorization to work in the United States. Applicants must be lawfully authorized to work in the U.S