Database Admin I or II

POSTING DEADLINE

This position is posted until filled.

PREFERENCES

ESSENTIAL DUTIES AND RESPONSIBILITIES OR PREFERENCES

Under general supervision, the Database Administrator is responsible for the following:

Maintain and enhance holistic asset management databases to support accurate tracking of substation equipment, design packages, and specification reviews.

Collaborate with engineering teams to develop and validate substation equipment testing procedures and integrate test results into centralized data systems for analysis and decision-making.

Support resolution of emergent issues by providing timely access to historical and real-time data on substation construction projects and equipment performance.

Research and implement data-driven solutions for asset health monitoring, enabling condition-based maintenance strategies through integration of sensor data and analytics platforms.

Forecast and schedule maintenance activities by leveraging database insights for both time-based and condition-based maintenance across transmission and distribution systems.

Ensure data accuracy and completeness for equipment records, including large power transformers, switchgear, and high-voltage breakers, and assist in reviewing equipment lists for project planning.

Coordinate with OEMs and vendors to integrate product data and specifications into internal systems, aligning offerings with project requirements and engineering standards.

Manage technical documentation repositories, ensuring manufacturer manuals and procedures are accessible and aligned with operational and maintenance protocols.

Support field inspections and equipment verification by maintaining mobile-accessible databases that reflect current design standards and equipment specifications.

Ensure compliance with regulatory and safety standards (e.g., IEEE, NESC, NERC) by maintaining audit-ready records and supporting engineering teams with data for compliance reporting.

Provide technical support and training to field personnel and junior staff on database tools, data entry standards, and reporting functionalities.

Communicate data insights and recommendations effectively to engineering, operations, and external stakeholders to support informed decision-making.

Contribute to the development of new standards and tools by applying database expertise to improve data workflows, reporting capabilities, and system integrations.

Uphold safety and data integrity standards in all database management activities, ensuring timely and secure access to critical operational data.

COMPETENCIES:

Technical Expertise

¿ Database Management: Proficient in administering, maintaining, and optimizing relational and non-relational databases (e.g., SQL Server, Cascade, Powerbase).

¿ Windows Server Management: including knowledge of Active Directory, PowerShell automation, and secure data services, to support the reliable operation and integration of asset management systems in electric utility environments.

¿ Data Integration: Skilled in integrating data from engineering systems, asset management tools, and vendor platforms.

¿ Data Quality & Governance: Ensures accuracy, consistency, and integrity of data across systems.

¿ Scripting & Automation: Ability to write scripts (e.g., SQL, Python) to automate data workflows and reporting.

¿ System Security: Knowledge of database security best practices, access controls, and compliance requirements.

Engineering Collaboration

¿ Technical Communication: Effectively translates engineering requirements into data solutions and communicates database insights to technical and non-technical stakeholders.

¿ Asset Management Support: Understands utility asset lifecycles and supports engineering teams with data for design, maintenance, and reliability planning.

¿ Equipment Familiarity: Basic understanding of substation equipment (e.g., transformers, breakers, switchgear) and ability to manage related data.

Analytical & Problem-Solving

¿ Root Cause Analysis: Uses data to support troubleshooting of equipment failures or project issues.

¿ Data-Driven Decision Making: Provides actionable insights through data analysis and visualization.

¿ Attention to Detail: Maintains high standards for data accuracy and documentation.

Project & Process Management

¿ Documentation & Standards: Maintains clear documentation and adheres to internal standards and regulatory requirements (e.g., IEEE, NERC).

¿ Process Improvement: Identifies opportunities to streamline data workflows and improve system performance.

¿ Time Management: Manages multiple priorities and deadlines in a fast-paced, cross-functional environment.

Collaboration & Support

¿ Cross-Functional Teamwork: Works effectively with engineers, field personnel, IT, and vendors.

¿ Training & Mentorship: Provides guidance and training on database tools and best practices to less experienced staff.

¿ Customer Service Orientation: Responsive to internal stakeholders¿ data needs and committed to delivering high-quality support.

JOB DESCRIPTION

Database Admin I

Salary Grade: G06 Minimum Midpoint Maximum $78,537 - $106,024 - $133,511

Personnel in this job title may be covered by NERC CIP cyber security standards. If the position is covered, prior to being hired, promoted, or transferred into the position, the candidate must successfully pass a Personnel Risk Assessment, which includes identity verification and a criminal background check. Prior to being granted unescorted access to cyber secure areas, the candidate must attend cyber security training. Annual cyber security training is also required.

SUMMARY:

Under general supervision, coordinates physical changes to computer databases; and codes, tests, and implements physical databases.

ESSENTIAL DUTIES AND RESPONSIBILITIES:

Designs logical and physical databases or reviews description of changes to the database design to understand how changes to be made will affect the physical database.

Establishes physical database parameters.

Codes database descriptions and specifies identifiers of database-to-database management system or directs others in coding database descriptions.

Calculates optimum values for database parameters such as amount of computer memory to be used by database.

Specifies user access level for each segment of one or more data items such as insert, replace, retrieve, or delete data.

Specifies which users can access databases and what data users can access.

Tests and corrects errors, and refines changes to database.

Enters codes to create production database.

Selects and enters codes of utility program to monitor database performance such as distribution of records and amount of available memory.

Directs programmers and analysts to make changes to database management system.

Reviews and corrects programs, trains users, and answers user questions.

Confers with co-workers to determine impact of database changes on other systems and staff cost for making changes to database.

Modifies database programs to increase processing performance, referred to as performance tuning.

COMPETENCIES:

Ability to synthesize complex or diverse information, collect and research data, and design workflows and procedures.

Ability to identify and resolve problems in a timely manner, gather and analyze information skillfully, develop alternative solutions, and work well in-group problem solving situations.

Demonstrates attention to detail.

QUALIFICATIONS MINIMUM EDUCATION AND/OR EXPERIENCE:

Bachelor's degree from four-year college or university with five to six years related experience, or equivalent combination of education and/or experience related to the discipline.

COMMUNICATION SKILLS:

Ability to read and interpret documents such as safety rules, operating and maintenance instructions, and procedure manuals.

Ability to write routine reports and correspondence.

Ability to speak effectively before groups of customers or employees of organization.

ANALYSIS AND PROBLEM-SOLVING ABILITY:

Ability to apply common sense understanding to carry out instructions furnished in written, oral, or diagram form. Ability to deal with problems involving several concrete variables in standardized situations.

COMPUTER SKILLS:

Working knowledge of MS Access database software.

PHYSICAL DEMANDS:

While performing the duties of this job, the employee is occasionally required to stand and walk up to 1/3 of the time and regularly required to sit up to 2/3 of the time and talk and listen for long periods of time. Manual dexterity and the ability to reach is required to perform computer applications and good vision is required to perform all aspects of the job. The employee must occasionally lift and/or move up to 10 pounds.

May require some travel.

WORK ENVIRONMENT:

Office environment.

JOB DESCRIPTION

Database Admin II

Salary Grade: G05

Minimum Midpoint Maximum $90,316 - $121,926 - $153,536

Personnel in this job title may be covered by NERC CIP cyber security standards. If the position is covered, prior to being hired, promoted, or transferred into the position, the candidate must successfully pass a Personnel Risk Assessment, which includes identity verification and a criminal background check. Prior to being granted unescorted access to cyber secure areas, the candidate must attend cyber security training. Annual cyber security training is also required.

SUMMARY:

Under general supervision, coordinates physical changes to computer databases; and codes, tests, and implements physical database.

ESSENTIAL DUTIES AND RESPONSIBILITIES:

Oversees database security

Evaluates and tests new software and hardware

Monitors and manages database backups, logs, and journals

Installs, maintains, and upgrades database software and recovers or restores data

Writes and maintains technical documents such as manuals and programmer handbooks

Designs logical and physical databases or reviews description of changes to the database design to understand how changes to be made will affect the physical database

Establishes physical database parameters

Codes database descriptions and specifies identifiers of database-to-database management system or directs others in coding database descriptions

Calculates optimum values for database parameters such as amount of computer memory to be used by database

Specifies user access level for each segment of one or more data items such as insert, replace, retrieve, or delete data

Specifies which users can access databases and what data users can access

Tests and corrects errors, and refines changes to database

Enters codes to create production database

Selects and enters codes of utility program to monitor database performance such as distribution of records and amount of available memory

Directs programmers and analysts to make changes to database management system

Reviews and corrects programs, trains users, and answers user questions

Confers with co-workers to determine impact of database changes on other systems and staff cost for making changes to database

Modifies database programs to increase processing performance, referred to as performance tuning

COMPETENCIES:

Ability to synthesize complex or diverse information, collect and research data, and design workflows and procedures

Ability to identify and resolve problems in a timely manner, gather and analyze information skillfully, develop alternative solutions, and work well in-group problem solving situations

Demonstrates attention to detail

QUALIFICATIONS MINIMUM EDUCATION AND/OR EXPERIENCE:

Bachelor's degree from four-year college or university with six to seven years related experience, or equivalent combination of education and/or experience related to the discipline.

COMMUNICATION SKILLS:

Ability to read and interpret documents such as safety rules, operating and maintenance instructions, and procedure manuals

Ability to write technical documents such as manuals and programmer handbooks

Ability to speak effectively before groups of customers or employees of organization

ANALYSIS AND PROBLEM-SOLVING ABILITY:

Ability to apply common sense understanding to carry out instructions furnished in written, oral, or diagram form. Ability to deal with problems involving several concrete variables in standardized situations.

COMPUTER SKILLS:

Working knowledge of database software.

PHYSICAL DEMANDS:

While performing the duties of this job, the employee is occasionally required to stand and walk up to 1/3 of the time and regularly required to sit up to 2/3 of the time and talk and listen for long periods of time. Manual dexterity is required to perform computer applications and good vision is required to perform all aspects of the job. The employee must occasionally lift and/or move up to 10 pounds.

May require some travel.

WORK ENVIRONMENT:

Office environment.

SAFETY AND ADA STATEMENT

Safety Statement:

Safety is a core value at (TXNM Energy/PNM/TNMP) and our vision, "everyone goes home safe", reflects our commitment to promoting an environment conducive to learning, improving and building safety practices. Our safety value is built upon the belief that every employee deserves to work in an environment free from harm.

Americans with Disabilities Act (ADA) Statement:

If you require assistance with the job application process due to a disability, please contact HR ADA Analyst, at 505-241-4627.