What are the responsibilities and job description for the Database Administrator position at Chugach Electric Association?
DATABASE ADMINISTRATOR
Objectives
Provides database design, construction and support to computer users within Chugach Electric.
Installs, upgrades, and maintains databases software.
Monitors the database performance and capacities and optimizes for efficient performance.
Develops naming standards, in-house educational material, recovery and backup procedures, standards, and language interfaces as necessary.
Research computer and database technologies that may benefit the Association's database operations, including investigating alternatives, planning configuration changes, making recommendations, and implementing any changes deemed necessary.
Serves as primary database coordinator and member of project teams for application development, upgrades and changes.
Reporting Relationship
Reports to: Manager, Networkand Technical Services, Information Services
Directs: None
Responsibilities and Authorities
Performs Personally
Controls and monitors system-level and database owner access to enterprise production databases.
Creates and maintains a high-level data model for all networked databases.
Directs, coordinates, creates and maintains database elements in all production networked databases.
Performs SQL database programming to provide data to front-end applications.
Responsible for database backup and recovery, scheduling, and disaster prevention.
Responsible for adequate data retention on the databases.
Monitors database performance and capacities and optimizes them for efficiency. Coordinates with Systems Programmers, Analyst Programmers and Network Administrators when necessary.
Provides in-depth technical support for resolving database-related problems.
Develops and maintains naming standards, in-house educational material and language interfaces to database as necessary.
Plans and implements installation and updates to the database software.
Acts as primary contact between Chugach and database software vendors for problem resolution, support and maintenance issues.
Maintains operations-run documentation.
Provides cost and benefit analysis for proposed database-related upgrades, projects and support tasks, as required.
Provides application and platform-based impact assessment for proposed upgrade projects and support tasks, as required.
Relationships
Internal
Manager, Networkand Technical Services, Information Services
Reports to and receives direction and decisions from. Keeps manager fully informed of progress and problems.
Under the direction of the manager, allocates and manages database resources.
Analyst & System Programmers
Advises in technical areas with respect to database software and connectivity issues.
Works directly with, to ensure smooth and efficient database communications.
Cooperates and shares expertise in determining methods and procedures to improve cross-platform connectivity and multi-platform database issues.
Network Administrator
Advises in technical areas with respect to database software and connectivity issues.
Works directly with, to ensure smooth and efficient database communications.
Cooperates and shares expertise in determining methods and procedures to improve cross-platform connectivity and multi-platform database issues.
Other Information Services Department personnel: Coordinate with, to improve database procedures and practices.
User Community: Assists in answering database-related software questions. Recommends database-related software.
Chugach management staff in other departments: Assists in answering database-related software questions. Recommends database configurations.
External
Database software vendors: Obtains information, support and repair of database software.
Minimum Qualifications
Three years of experience as a Database Administrator beyond the degree requirement, of which two years must have been in Oracle version 7.3 or higher, and two years must have been in database design or database programming and development.
AND
Bachelor's degree in Computer Science, Management Information Science, or an applicable business field.
OR
Four years of equivalent experience may be substituted for the required degree.
Knowledge, Abilities And Skills
Three years of experience, beyond the programming and analysis requirement, directly supporting a relational database management system using Structured Query Language (SOL) and fourth-generation languages.
Proficiency with data analysis theory and techniques, including logical and physical database design, data flow, and data structure diagramming.
Experience with Windows applications development software, (e.g., Microsoft Access or Visual Basic, Approach for Windows, Progress or Powerbuilder).
Proficiency with desktop computers utilizing the DOS/Windows operating systems.
Unix and DOS scripting skills in Korn shell, Perl, AWK or other appropriate scripting or shell language.
Applications Development Experience In Client/server Computer Environment Preferred.
Proficiency with UNIX. Exposure to Windows NT network operating system.
The ability to perform cost and benefit analysis for proposed projects.
Proven proficiency with creating quality project proposal.
Proficiency with effective conceptual and technical presentations preferred.
Working Conditions
Standard office environment.
This position is subject to call-out outside of normal working hours with some weekend work.
Chugach Electric Association is a member-owned cooperative, headquartered in Anchorage, Alaska's largest city. Anchorage itself sits at the base of the Chugach Mountains. Chugach is pleased to provide reliable, affordable power to more than 92,000 members from Anchorage to the northern Kenai Peninsula, and from Whittier on Prince William Sound to Tyonek on the west side of Cook Inlet. We service over 113,000 locations with 3,782 miles of transmission and distribution lines. We have many services that make it easy to power homes and businesses with Chugach.
A little more about us: Chugach has been around for a long time, recently celebrating 75 years! We are a stable company, in a stable industry. And while we may have stability, we are modern, sustainable and forward-thinking to ensure that we provide reliable services for generations to come. We also pride ourselves on the longevity of our employees. We have several 20, 30 and 40 year tenured employees who continue foster an inclusive, innovative corporate environment. Find your spark!
Chugach's Corporate Vision
Responsibly developing energy to build a clean, sustainable future for Alaska.
Chugach's Corporate Mission
We provide safe, reliable, and affordable electricity through superior service and sustainable practices, powering the lives of our members.
Chugach's Corporate Values
Guided by our values of safety, accountability, and sustainability, we are committed to serving our members, the community, and the Chugach team.
Equal Employment Opportunity
It is a policy of Chugach Electric Association, Inc., to recruit, hire, train, promote, and compensate persons without regard to race, color, religion, national origin, sex, marital status, pregnancy, parenthood, physical or mental disability, veteran's status, age, or any other classification protected by applicable, federal, state, or local law.
Chugach is also an affirmative action employer.
<
Objectives
Provides database design, construction and support to computer users within Chugach Electric.
Installs, upgrades, and maintains databases software.
Monitors the database performance and capacities and optimizes for efficient performance.
Develops naming standards, in-house educational material, recovery and backup procedures, standards, and language interfaces as necessary.
Research computer and database technologies that may benefit the Association's database operations, including investigating alternatives, planning configuration changes, making recommendations, and implementing any changes deemed necessary.
Serves as primary database coordinator and member of project teams for application development, upgrades and changes.
Reporting Relationship
Reports to: Manager, Networkand Technical Services, Information Services
Directs: None
Responsibilities and Authorities
Performs Personally
Controls and monitors system-level and database owner access to enterprise production databases.
Creates and maintains a high-level data model for all networked databases.
Directs, coordinates, creates and maintains database elements in all production networked databases.
Performs SQL database programming to provide data to front-end applications.
Responsible for database backup and recovery, scheduling, and disaster prevention.
Responsible for adequate data retention on the databases.
Monitors database performance and capacities and optimizes them for efficiency. Coordinates with Systems Programmers, Analyst Programmers and Network Administrators when necessary.
Provides in-depth technical support for resolving database-related problems.
Develops and maintains naming standards, in-house educational material and language interfaces to database as necessary.
Plans and implements installation and updates to the database software.
Acts as primary contact between Chugach and database software vendors for problem resolution, support and maintenance issues.
Maintains operations-run documentation.
Provides cost and benefit analysis for proposed database-related upgrades, projects and support tasks, as required.
Provides application and platform-based impact assessment for proposed upgrade projects and support tasks, as required.
Relationships
Internal
Manager, Networkand Technical Services, Information Services
Reports to and receives direction and decisions from. Keeps manager fully informed of progress and problems.
Under the direction of the manager, allocates and manages database resources.
Analyst & System Programmers
Advises in technical areas with respect to database software and connectivity issues.
Works directly with, to ensure smooth and efficient database communications.
Cooperates and shares expertise in determining methods and procedures to improve cross-platform connectivity and multi-platform database issues.
Network Administrator
Advises in technical areas with respect to database software and connectivity issues.
Works directly with, to ensure smooth and efficient database communications.
Cooperates and shares expertise in determining methods and procedures to improve cross-platform connectivity and multi-platform database issues.
Other Information Services Department personnel: Coordinate with, to improve database procedures and practices.
User Community: Assists in answering database-related software questions. Recommends database-related software.
Chugach management staff in other departments: Assists in answering database-related software questions. Recommends database configurations.
External
Database software vendors: Obtains information, support and repair of database software.
Minimum Qualifications
Three years of experience as a Database Administrator beyond the degree requirement, of which two years must have been in Oracle version 7.3 or higher, and two years must have been in database design or database programming and development.
AND
Bachelor's degree in Computer Science, Management Information Science, or an applicable business field.
OR
Four years of equivalent experience may be substituted for the required degree.
Knowledge, Abilities And Skills
Three years of experience, beyond the programming and analysis requirement, directly supporting a relational database management system using Structured Query Language (SOL) and fourth-generation languages.
Proficiency with data analysis theory and techniques, including logical and physical database design, data flow, and data structure diagramming.
Experience with Windows applications development software, (e.g., Microsoft Access or Visual Basic, Approach for Windows, Progress or Powerbuilder).
Proficiency with desktop computers utilizing the DOS/Windows operating systems.
Unix and DOS scripting skills in Korn shell, Perl, AWK or other appropriate scripting or shell language.
Applications Development Experience In Client/server Computer Environment Preferred.
Proficiency with UNIX. Exposure to Windows NT network operating system.
The ability to perform cost and benefit analysis for proposed projects.
Proven proficiency with creating quality project proposal.
Proficiency with effective conceptual and technical presentations preferred.
Working Conditions
Standard office environment.
This position is subject to call-out outside of normal working hours with some weekend work.
Chugach Electric Association is a member-owned cooperative, headquartered in Anchorage, Alaska's largest city. Anchorage itself sits at the base of the Chugach Mountains. Chugach is pleased to provide reliable, affordable power to more than 92,000 members from Anchorage to the northern Kenai Peninsula, and from Whittier on Prince William Sound to Tyonek on the west side of Cook Inlet. We service over 113,000 locations with 3,782 miles of transmission and distribution lines. We have many services that make it easy to power homes and businesses with Chugach.
A little more about us: Chugach has been around for a long time, recently celebrating 75 years! We are a stable company, in a stable industry. And while we may have stability, we are modern, sustainable and forward-thinking to ensure that we provide reliable services for generations to come. We also pride ourselves on the longevity of our employees. We have several 20, 30 and 40 year tenured employees who continue foster an inclusive, innovative corporate environment. Find your spark!
Chugach's Corporate Vision
Responsibly developing energy to build a clean, sustainable future for Alaska.
Chugach's Corporate Mission
We provide safe, reliable, and affordable electricity through superior service and sustainable practices, powering the lives of our members.
Chugach's Corporate Values
Guided by our values of safety, accountability, and sustainability, we are committed to serving our members, the community, and the Chugach team.
Equal Employment Opportunity
It is a policy of Chugach Electric Association, Inc., to recruit, hire, train, promote, and compensate persons without regard to race, color, religion, national origin, sex, marital status, pregnancy, parenthood, physical or mental disability, veteran's status, age, or any other classification protected by applicable, federal, state, or local law.
Chugach is also an affirmative action employer.
<
