What are the responsibilities and job description for the Data Engineer (Database Administrator) 2, 3 or Sr position at Berkshire Hathaway Energy?
Job Description
This is a multi-level posting. Candidates may be considered for any of the posted levels, depending on their level of experience and depth of expertise.
Responsible for the design, implementation, maintenance and monitoring of database technologies and related software. Conducts analysis, creates system specifications, develops, tests and implements engineering, scientific and business applications, operating systems, and file / database servers. Utilizes existing or new technology in the automation of processes. Evaluates software packages and provides recommendations to management. Provides actionable recommendations for improvements in application performance after analyzing underlying database-related infrastructure components.
Responsibilities of this position include the following :
Designs, codes, tests documents, implements and maintains database utilities. (25%) Performs top expert-level database analysis and design reviews. (20%) Research and fact-finding to develop or modify database structures. (10%) Works with vendors to review quality, adaptability and compatibility of their products. (10%) Provides support for vendor-developed database implementation and periodic maintenance releases as required. (10%) Provides technical input to assist in development of project planning. (10%) Performs additional responsibilities as requested or assigned. (5%) Maintains RDBMS software at appropriate vendor-supported levels. (10%)
Responsibilities
Designs, codes, tests documents, implements and maintains database utilities.
Performs top expert-level database analysis and design reviews.
Research and fact-finding to develop or modify database structures.
Works with vendors to review quality, adaptability and compatibility of their products.
Provides support for vendor-developed database implementation and periodic maintenance releases as required.
Provides technical input to assist in development of project planning.
Performs additional responsibilities as requested or assigned.
Maintains RDBMS software at appropriate vendor-supported levels.
A strong understanding of database fundamentals.
Experience on Maximum Availability Architecture components like Oracle RAC, Oracle ASM, Oracle Grid Control, Oracle Data Guard & Oracle Goldengate.
Hand on experience with Database Upgrade / Migration
Preferred experience with CDB / PDB multitenant architecture (create, cloning, dropping, CDBs and PDBs).
Preferred experience with Database migration from conventional database to CDB / PDB multitenant architecture.
Preferred experience multiple Unix Flavors like AIX / SOLARIS / LINUX.
A knowledge of RMAN backup and recovery processes.
Qualifications
Bachelor's degree in information systems, computer science or related technical field or equivalent work experience. (Typically, four years of additional related, progressive work experience would be needed for candidates applying for this position who do not possess a bachelor's degree.) A minimum of two years additional direct related technical experience is required.
A minimum of two years related technical experience is required for the data engineer 2 level.
A minimum of four or more years related technical experience is required for the data engineer 3 level.
Seven or more years IT operation experience with strong understanding of database structures, theories, principles, and practices is required for the Sr data engineer level.
A strong understanding of database fundamentals
Experience on Maximum Availability Architecture components like Oracle RAC, Oracle ASM, Oracle Grid Control, Oracle Data Guard & Oracle Goldengate
Hand on experience with Database Upgrade / Migration
Preferred hands-on experience with CDB / PDB multitenant architecture (create, cloning, dropping, CDBs and PDBs),
Preferred hands-on experience with Database migration from conventional database to CDB / PDB multitenant architecture
Preferred Experience multiple Unix Flavors like AIX / SOLARIS / LINUX
A knowledge of RMAN backup and recovery processes
Proficiency in using SRVCTL and CRSCTL for listeners, adding databases, shutdown / startus
Experience using Oracle Enterprise Manager
Oracle Fleet Maintenance experience a plus
Experience on Exadata a plus
Position requires 24 / 7 production on call in a group rotation.
Night / weekend work required periodically for patching activities or similar.
Employees must be able to perform the essential functions of the position, with or without an accommodation.
We celebrate diversity, equity and inclusion, and we are proud to be an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion or religious creed, age, national origin, ancestry, citizenship status (except as required by law), gender (including gender identity and expression), sex (including pregnancy), sexual orientation, genetic information, physical or mental disability, veteran or military status, familial or parental status, marital status or any other category protected by applicable local, state or U.S. federal law.
About Us
MidAmerican Energy Company, a Midwest utility, provides regulated electric and natural gas service to more than 1.6 million customers in Illinois, Iowa, Nebraska and South Dakota. The company owns and operates a portfolio of power-generating assets, approximately 61% of which is wind generation.
About the Team
At MidAmerican Energy Company, we celebrate diversity, equity and inclusion. MidAmerican Energy Company is proud to be an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion or religious creed, age, national origin, ancestry, citizenship status (except as required by law), gender (including gender identity and expression), sex (including pregnancy), sexual orientation, genetic information, physical or mental disability, veteran or military status, familial or parental status, marital status or any other category protected by applicable local, state or U.S. federal law.
