Summary
Under the direction of the IS Operations & Support Assistant Manager this position develops, programs, implements, maintains, supports and troubleshoots NCPA’s Headquarters and Disaster Recovery database environments. Ensures a reliable backend database infrastructure that is used with many custom in-house applications, including support for a real-time 24 x 7 wholesale electric utility operations. The Database Administrator is responsible for creating and maintaining databases, schemas, queries, users/groups and SQL scripts. Additionally, this position ensures system availability by monitoring system performance, patching, securing, backing up/restoring, and keeping documentation current.
Classification Levels Duties and Responsibilities
- Level II: This classification has abilities to perform all the responsibilities of a Level I and has an advanced knowledge of database system concepts and integration with 3rd party systems. Installs, configures, upgrades, and troubleshoots Database server software. Helps design, script and automate SQL tasks to maintain a high availability environment. Performs advanced troubleshooting to identify and correct technical problems. Provides support to customers to enhance custom SQL queries. Responsible for performing backup/restoration of databases on a routine basis.
- Level III: This classification supports and maintains the Agency’s database infrastructure and related applications. Administers all database objects, including but not limited to schemas, tables, clusters, indexes, and views. Performs database re-organizations as needed to improve performance. Performs impact analysis of changes to be made to database objects before implementing significant schema changes. Ensures security for all databases by creating roles and associated privileges. Controls and monitors user access to databases. This is the journey level position and is given minimal direction in job duties and responsibilities.
Essential Duties and Responsibilities
- Project management for Agency-wide or critical system implementations, including user requirements gathering, product evaluations, user acceptance testing, and rollout.
- Conducts independent communications with user departments in a cooperative and professional manner
- Provides after-hours emergency system support as necessary.
- Travels to NCPA remote field sites, power plants, members and customers to provide support.
- Other duties may be assigned.
Competencies
To perform the job successfully, an individual should demonstrate the following competencies:
Analytical - Synthesizes complex or diverse information; Collects and researches data; Uses intuition and experience to complement data; Designs work flows and procedures.
Design - Generates creative solutions; Translates concepts and information into images; Uses feedback to modify designs; Applies design principles; Demonstrates attention to detail.
Problem Solving - Identifies and resolves problems in a timely manner; Gathers and analyzes information skillfully; Develops alternative solutions; Works well in group problem solving situations; Uses reason even when dealing with emotional topics.
Project Management - Develops project plans; Coordinates projects; Communicates changes and progress; Completes projects on time and budget; Manages project team activities.
Technical Skills - Assesses own strengths and weaknesses; Pursues training and development opportunities; Strives to continuously build knowledge and skills; Shares expertise with others.
Customer Service - Manages difficult or emotional customer situations; Responds promptly to customer needs; Solicits customer feedback to improve service; Responds to requests for service and assistance; Meets commitments.
Interpersonal Skills - Focuses on solving conflict, not blaming; Maintains confidentiality; Listens to others without interrupting; Keeps emotions under control; Remains open to others' ideas and tries new things.
Oral Communication - Speaks clearly and persuasively in positive or negative situations; Listens and gets clarification; Responds well to questions; Demonstrates group presentation skills; Participates in meetings.
Written Communication - Writes clearly and informatively; Edits work for spelling and grammar; Varies writing style to meet needs; Presents numerical data effectively; Is able to read and interpret written information.
Teamwork - Balances team and individual responsibilities; Exhibits objectivity and openness to others' views; Gives and welcomes feedback; Contributes to building a positive team spirit; Puts success of team above own interests; Is able to build morale and group commitments to goals and objectives; Supports everyone's efforts to succeed.
Change Management - Develops workable implementation plans; Communicates changes effectively; Builds commitment and overcomes resistance; Prepares and supports those affected by change; Monitors transition and evaluates results.
Quality Management - Looks for ways to improve and promote quality; Demonstrates accuracy and thoroughness.
Business Acumen - Understands business implications of decisions; Displays orientation to profitability; Demonstrates knowledge of market and competition; Aligns work with strategic goals.
Cost Consciousness - Works within approved budget; Develops and implements cost saving measures; Contributes to profits and revenue; Conserves organizational resources.
Ethics - Treats people with respect; Keeps commitments; Inspires the trust of others; Works with integrity and ethically; Upholds organizational values.
Organizational Support - Follows policies and procedures; Completes administrative tasks correctly and on time; Supports organization's goals and values; Benefits organization through outside activities.
Strategic Thinking - Develops strategies to achieve organizational goals; Understands organization's strengths & weaknesses; Analyzes market and competition; Identifies external threats and opportunities; Adapts strategy to changing conditions.
Judgment - Displays willingness to make decisions; Exhibits sound and accurate judgment; Supports and explains reasoning for decisions; Includes appropriate people in decision-making process; Makes timely decisions.
Motivation - Sets and achieves challenging goals; Demonstrates persistence and overcomes obstacles; Measures self against standard of excellence; Takes calculated risks to accomplish goals.
Planning/Organizing - Prioritizes and plans work activities; Uses time efficiently; Plans for additional resources; Sets goals and objectives; Organizes or schedules other people and their tasks; Develops realistic action plans.
Professionalism - Approaches others in a tactful manner; Reacts well under pressure; Treats others with respect and consideration regardless of their status or position; Accepts responsibility for own actions; Follows through on commitments.
Quality - Demonstrates accuracy and thoroughness; Looks for ways to improve and promote quality; Applies feedback to improve performance; Monitors own work to ensure quality.
Quantity - Meets productivity standards; Completes work in timely manner; Strives to increase productivity; Works quickly.
Safety and Security - Observes safety and security procedures; Determines appropriate action beyond guidelines; Reports potentially unsafe conditions; Uses equipment and materials properly.
Adaptability - Adapts to changes in the work environment; Manages competing demands; Changes approach or method to best fit the situation; Is able to deal with frequent change, delays, or unexpected events.
Attendance/Punctuality - Is consistently at work and on time; Ensures work responsibilities are covered when absent; Arrives at meetings and appointments on time.
Dependability - Follows instructions and responds to management direction; Takes responsibility for own actions; Keeps commitments; Commits to long hours of work when necessary to reach goals; Completes tasks on time or notifies appropriate person with an alternate plan.
Initiative - Volunteers readily; Undertakes self-development activities; Seeks increased responsibilities; Takes independent actions and calculated risks; Looks for and takes advantage of opportunities; Asks for and offers help when needed.
Innovation - Displays original thinking and creativity; Meets challenges with resourcefulness; Generates suggestions for improving work; Develops innovative approaches and ideas; Presents ideas and information in a manner that gets others' attention.
Qualifications
To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
Education and/or Experience
- Level II: Bachelor Degree in Computer Science, Management Information Systems, Engineering or related field from an accredited institution; minimum three years related experience and/or training; or equivalent combination of education and experience.
- Level III: Bachelor Degree in Computer Science, Management Information Systems, Engineering or related field from an accredited institution; five years related experience and/or training; or equivalent combination of education and experience.
Language Skills
Ability to read, analyze, and interpret general business periodicals, professional journals, technical procedures, or governmental regulations. Ability to write reports, business correspondence, and procedure manuals. Ability to effectively present information effectively and respond to questions from groups of managers, clients, customers, and the general public.
Mathematical Skills
Ability to work with mathematical concepts such as probability and statistical inference, and fundamentals of plane and solid geometry and trigonometry. Ability to apply concepts such as fractions, percentages, ratios and proportions to practical situations.
Reasoning Ability
Ability to solve practical problems and deal with a variety of concrete variables in situations where only limited standardization exists. Ability to interpret a variety of instructions furnished in written, oral, diagram, or schedule form.
Computer Skills
- Experienced in the principles and technical methodologies related to the development, design, implementation, analysis and maintenance of computer applications related to database systems in a utility environment. Proficient in Microsoft Windows, Oracle Database, Microsoft SQL Server, SQL, PL/SQL, T-SQL, Oracle Enterprise Manager, SQL Developer, Toad, PowerShell, Batch/cmd scripting, SQL*Plus, RMAN, ASM, Oracle RAC, Clusterware and the Oracle Cluster Registry. Knowledge of Veeam, VMware, and Linux a plus.
- Knowledge of Disaster recovery, back-up and recovery, relational database theory, Windows system administration, Oracle standby databases, the Oracle optimizer and execution plans, troubleshooting and debugging, networking (TCP/IP), database security.
Certificates, Licenses, Registrations
California driver's license and insurance.
Other Skills and Abilities
Ability to write complex programs and develop detailed program specifications; analyze data and situations, reason logically and creatively, identify problems, draw valid conclusions, and develop effective solutions; apply creative thinking in the design and development of methods of processing data with electronic computers; establish and maintain cooperative working relationships with those contacted in the course of the work; communicate effectively verbally and in writing, and prepare effective reports.
Physical Demands
The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
While performing the duties of this Job, the employee is regularly required to sit at a desk for long periods of time, and talk or hear. Occasionally, the employee may be required to perform simple grasping and fine manipulation, use telephone, write or use a keyboard to communicate, crouch, crawl, reach and lift equipment up to 40 lbs.
Work Environment
The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
While performing the duties of this Job, the employee is occasionally exposed to moving mechanical parts and outside weather and must be able to walk on possibly uneven ground. The noise level in the work environment is usually moderate.
EOE