Share this Job
Apply now »

Senior Database Administrator (REN 10103)

Company:  AVANGRID RENEWABLES, LLC
Location: 

Portland, OR, US


 

Overview

The Database Administrator administers, maintains, develops and implements policies and procedures for ensuring the security and integrity of Avangrid’s Oracle and PostgreSQL databases. Implements changes to production database objects and data as well as adhere to required best practices change management procedures. This person resolves Oracle database performance issues, database capacity issues, replication, Disaster Recovery, and other database issues.  This person must be an experienced self-starter looking for ways to make improvements that will increase efficiency and maintainability of the database management systems to support a tightly integrated team of developers, system analysts, project managers and system owners. Given the unique nature of this team, this position presents a unique opportunity to participate in and contribute towards the data analytical functions pertaining to project work and support including data modelling and design.

Key Responsibilities
  • Administer Oracle databases in Linux and AIX environments
  • Administer PostgreSQL databases in Linux environment
  • Ability to work effectively under pressure, meet deadlines and adjust to changing priorities
  • Monitor database performance, space usage and availability
  • Monitor database backup and export jobs to ensure proper recovery avenues are in place
  • Assist with application upgrade or maintenance projects as needed
  • Participate in monthly DR testing activities
  • Monitor Oracle replication environment and resolve issues
  • Monitor database account usage
  • Ensure compliance with established IT controls and audit requirements
  • Perform a variety of tasks and have a proven ability to work with minimal supervision
  • Assist with desktop client software installs and connection issues as needed
  • With Application support staff, assist with troubleshooting End-of-Day process issues
  • Refresh test databases with clones of production when requested
  • Participate in all upgrades and changes to Energy Trade and Risk Management applications
  • Perform data analysis and reporting
  • Maintain documentation
  • Ensure all changes have appropriate approvals and follow Avangrid Renewables change management policies
Required Qualifications
  • Bachelor’s degree in computer science, information systems, business, or an equivalent combination of education and experience
  • 5+ years of Oracle DBA experience
  • 2+ years of PostgreSQL experience
  • 2+ years of Linux/UNIX experience
  • Strong customer service attitude and ability to juggle multiple priorities
  • Strong written and verbal communication skills with the ability to effectively communicate with both business and technical personnel
  • Self-starter able to perform a variety of tasks and has a proven ability to work with minimal supervision, as well as in a team environment
  • Occasional weekend and after-hours work
  • Back-end (tier 3), on-call support for emergencies
  • Basic knowledge of shell scripting
Preferred Qualifications
  • Self-motivated with a desire to stay abreast of latest technologies
  • Willingness to perform non dba functions such as data analysis and project work
  • Experience with Oracle BI, Weblogic
  • Experience with using data visualization platforms such as Tableau and MicroStrategy
  • Experience with Oracle Replication
  • Experience with working in IT for an energy company
  • Experience with FIS’s suite of Energy Management applications
  • Experience with large databases

All offers of employment are contingent upon the successful completion of a medical Fit for Duty exam, background check, references, drug screen, verification of legal right to work in the U.S., and in some cases, a credit check. A credit check will be administered when a prospective employee will be working in Finance, Accounting, Treasury or where duties may involve handling of funds, accounts or cash. A Motor Vehicle (MVR) check will be administered when a prospective employee will be regularly using a company vehicle.


Avangrid Renewables is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, protected veteran status, status as an individual with a disability, or any other status or class protected by federal or state law.
 

 

 

AVANGRID’s employment practices and policies are geared to hiring a diverse workforce and sustaining an inclusive culture. At AVANGRID we provide fair and equal employment and advancement opportunities for all employees and candidates regardless of race, color, religion, national origin, gender, sexual orientation, age, marital status, disability, protected veteran status or any other status protected by federal, state, or local law. Learn more about equal employment by following this link

If you are an individual with a disability or a disabled veteran who is unable to use our online tool to search for or to apply for jobs, you may request a reasonable accommodation by contacting our Human Resources department at 203-499-2777 or careers@avangrid.com


Nearest Major Market: Portland Oregon

Apply now »