DATABASE ADMINISTRATOR / SENIOR DATABASE ADMINISTR

In this role we are looking for a person with the following abilities:  

• Be creative and a technical problem-solver. i.e.: capable of isolating and resolving database issues in real-time to maintain access and data integrity.  

• Respond to issues in timely manner, clearly elaborate problem and propose solutions.  

• Collaborate and communicate with co-workers, listen, and respond to their queries and concerns.  

• Willingness to learn multiple database software and take advantage of ongoing upskilling programs. (ie. Oracle, MS SQL, PostgreSQL, Snowflake) 

• Be available for on-call support as needed.  
   

Required technical skills  

• Installation and maintenance of the performance of database servers.  

• Develop processes for optimizing database security.  

• Set and maintain database standards.  

• Manage database access.  

• Performance tuning of database systems.  

• Install, upgrade, and manage database applications.  

• Diagnose and troubleshoot database errors.  

• Create automation for repeating database tasks.  

Preferred experience 

• AWS, Azure, or Oracle Cloud Infrastructure (OCI).  

• Building and supporting PostgreSQL and Snowflake that balance the need for speed, flexibility, and security of database and supporting infrastructure.  

• Prefer experience with Microservices.  

• Oracle Golden Gate replication. For example, be able to configure and maintain Golden Gate replication without any data loss.  

• Oracle Enterprise Manager (OEM).  

• Microsoft SQL Always-On. 
   

Job Function  

Database Design and Administration Administers database utilities, manages the security of the databases, and maintains the organization's databases across multiple platforms and computing environments. Applies understanding of relational database concepts and query languages to design required summary or aggregation tables to support analyses. Collaborates with technology/infrastructure staff to identify data relationships and functional requirements; analyzes and resolves issues related to information flow and content. Maintains database support tools, database tables and dictionaries and recovery and back-up procedures. 
 

Database Administrator Level 

Key Job Information  

Career Professional Requires in-depth knowledge and experience. Uses best practices and knowledge of internal or external business issues to improve products or services. Solves complex problems; takes a new perspective using existing solutions. Works independently, receives minimal guidance. Acts as a resource for colleagues with less experience. 

 
Key Responsibilities  

• Database Administration (DBAD) Uses database management system software and tools and knowledge of logical database schemata to investigate problems and collect performance statistics and create reports. Carries out routine configuration/installation and reconfiguration of database and related products.  

• Database Management (DATM) Takes responsibility for the accessibility, retrievability and security of specific subsets of data. Assesses the integrity of data from multiple sources (including, for example, from sensors’ measurement systems). Provides advice on the transformation of data/information from one format/medium to another where appropriate. Maintains and implements information-handling procedures. Enables the availability, integrity and searchability of information through the application of formal data structures and protection measures. Manipulates specific data from information services to satisfy local or specific information needs.  

• Methods and Tools (METL) Provides expertise and support on use of methods and tools.  

• Database Design (DBDS) Develops and maintains specialist knowledge of database concepts, object and data modelling techniques and design principles and a detailed knowledge of database architectures, software, and facilities. Analyzes data requirements to establish, modify or maintain object/data models. Evaluates potential solutions, demonstrating, installing, and commissioning selected products.  

• Emerging Technologies (EMRG) Maintains awareness of opportunities provided by new technology to address challenges or to enable new ways of working. Within own sphere of influence, works to further organizational goals by the study and use of emerging technologies and products. Contributes to briefings and presentations about their relevance and potential value to the organization. 
   

Education/Experience/Certifications  

• Requires a bachelor’s degree in science, technology, engineering, mathematics or other related field or equivalent experience.  

• Typically, five or more years in related field.  

• Microsoft SQL Server Database certification and/or Oracle Database Administrator certification. 
   

Competencies (Knowledge, Skills, Abilities)  

Functional Competencies  

• Intermediate knowledge of data management practices and processes.  

• Intermediate knowledge of database administration processes.  

• Intermediate knowledge of database design frameworks.  

• Advanced knowledge of relational database technology and ability to accurately communicate database technology to others.  

• Intermediate knowledge of database backup and recovery strategy.  

• Intermediate knowledge of database performance management and tuning.  

• Working knowledge of Windows and UNIX operating systems.  

• Intermediate knowledge of storage, network, and security systems management.  

General Competencies  

• Advanced analytical thinking skills.  

• Advanced customer focus skills.  

• Advanced accuracy skills.  

• Advanced risk management skills.  

• Advanced oral and written communication skills.  

• Advanced decision-making skills. 
   

Physical and Cognitive Demands  

Cognitive Level Substantial: Consistent use of logic or scientific thinking to define problems, collect information, establish facts, and draw valid conclusions (for example, engineer, HR director, plant manager, etc.).  

• Ability to adhere to set response times, deadlines, and time-sensitive tasks.  

• Ability to follow accuracy standards.  

• Ability to follow through on decision-making tasks.  

• Ability to interact effectively and collaboratively within a team environment.  

• Ability to communicate and problem solve when under stress.  

• Ability to respond and adapt to frequent change.  

• Ability to accept and demonstrate self-awareness when provided constructive feedback.  

• Ability to discern feedback and acknowledge ownership of areas of improvement.  

• Ability to avoid future mistakes by applying reasonable skills to new but similar work situations or tasks.  

• Ability to successfully collaborate with peers, managers, and others within the organization.  

• Demonstrates sound memory.  

• Ability to process new information to be applied consistently to work tasks. 
   

Senior Database Administrator 

Key Job Information  

Career Level: Specialist Professional Requires specialized depth and/or breadth of expertise. Interprets internal or external business issues and recommends best practices. Solves complex problems; takes a broad perspective to identify innovative solutions. Works independently, with guidance in only the most complex situations. May lead functional teams or projects. 

  
Key Responsibilities  

• Database Administration (DBAD) Drafts and maintains procedures and documentation for databases. Manages database configuration, including installing and upgrading software and maintaining relevant documentation. Contributes to the setting of standards for definition, security and integrity of database objects and ensures conformance to these standards. Monitors database activity and resource usage. Optimizes database performance and plans for forecast resource needs.  

• Database Management (DATM) Plans effective data storage, sharing and publishing within the organization. Independently validates external information from multiple sources. Assesses issues which might prevent the organization from making maximum use of its information assets. Where possible, derives data-management structures to support consistency of information retrieval, combination, analysis, pattern recognition and interpretation throughout the organization. Devises and implements data-management processes, including classification, security, retrieval, and retention processes.  

• Methods and Tools (METL) Promotes and ensures use of appropriate techniques, methodologies, and tools.  

• Database Design (DBDS) Maintains and applies up-to-date specialist knowledge of database concepts, object and data modelling techniques and design principles and a detailed knowledge of the full range of database architectures, software, and facilities available. Analyzes data requirements to establish, modify or maintain a data model. Takes account of specialist requirements (e.g., geocoding for geographic information systems). Interprets the model into an appropriate database schema within set policies. Demonstrates, installs and commissions selected products.  

• Emerging Technologies (EMRG) Monitors the market to gain knowledge and understanding of currently emerging technologies. Identifies new and emerging hardware and software technologies and products based on own area of expertise, assesses their relevance and potential value to the organization and contributes to briefings of staff and management.  
   

Education/Experience/Certifications  

• Requires a bachelor’s degree in science, technology, engineering, mathematics or other related field or equivalent experience.  

• Typically, eight or more years in related field.  

• Preferred Microsoft SQL Server Database certification and/or Oracle Database Administrator certification.  

• Advanced oral and written communication skills.  

• Advanced decision-making skills. 

Competencies (Knowledge, Skills, Abilities)  

Functional Competencies  

• Advanced knowledge of data management practices and processes.  

• Advanced knowledge of database administration processes.  

• Advanced knowledge of database design frameworks.  

• Expert knowledge of relational database technology and ability to accurately communicate database technology to others.  

• Advanced knowledge of database backup and recovery strategy.  

• Advanced knowledge of database performance management and tuning.  

• Working knowledge of Windows and UNIX operating systems.  

• Advanced knowledge of storage, network, and security systems management.  

General Competencies  

• Advanced analytical thinking skills.  

• Advanced customer focus skills.  

• Advanced accuracy skills.  

• Advanced risk management skills. 

  
Physical and Cognitive Demands  

Cognitive Level Substantial: Consistent use of logic or scientific thinking to define problems, collect information, establish facts, and draw valid conclusions (for example, engineer, HR director, plant manager, etc.).  

• Ability to adhere to set response times, deadlines, and time-sensitive tasks.  

• Ability to follow accuracy standards.  

• Ability to follow through on decision-making tasks.  

• Ability to interact effectively and collaboratively within a team environment.  

• Ability to communicate and problem solve when under stress.  

• Ability to respond and adapt to frequent change.  

• Ability to accept and demonstrate self-awareness when provided constructive feedback.  

• Ability to discern feedback and acknowledge ownership of areas of improvement.  

• Ability to avoid future mistakes by applying reasonable skills to new but similar work situations or tasks.  

• Ability to successfully collaborate with peers, managers, and others within the organization.  

• Demonstrates sound memory.  

• Ability to process new information to be applied consistently to work tasks. 

Required for both levels 

Schedule/Attendance  

• Ability to adhere to pre-established schedule, including start/stop time and break/lunch schedule.  

• Ability to work long hours. 

• Ability to work a variable schedule.  

• Ability to report to work and perform work during periods of severe inclement weather.  

• Ability to consistently meet attendance standards for regular, reliable, predictable, full-time attendance. 

• Ability to work shift schedule.  

• Ability to work on-call schedule. 

Physical Capabilities 

• Computer use (use computer regularly for entire work shift) 

Environment - Indoor/Outdoor 

• Office 

PGE supports hybrid flexible work arrangements; and will have a combination of in-the-office and working offsite. This individual will need to be located within 75 miles from job location and will need to work in-the-office at least one day a week. However, these arrangements may change due to business needs or changes in responsibility. 

#LI-CU1 

#Hybrid