The Electric Reliability Council of Texas (ERCOT)
Database Administrator 2
The Electric Reliability Council of Texas (ERCOT), Taylor, Texas, United States, 76574
At ERCOT, our diverse and dynamic work environment provides a platform on which employees can work together to build the future of the Texas power grid and wholesale market utilizing the latest technologies and resources. We encourage you to join our talented, dedicated workforce to develop world-class solutions for today and tomorrow's energy challenges while learning new skills and growing your career.
ERCOT is committed to fostering diversity and inclusion at all levels of our company. It is the cornerstone of our corporate values of accountability, leadership, innovation, trust, and expertise. We accept and celebrate those that join us and recognize that individuals with a wide variety of talents, ideas, and experiences propel the innovation that drives our success. A diverse and inclusive workforce strengthens us and allows for a collaborative environment to solve the challenges that face our industry today and in the future.
JOB SUMMARY
Administers, tests, and implements computer databases, applying knowledge of database management systems and storage administration. Coordinates changes to computer databases.
JOB DUTIES
Understands the basic principles, theories and concepts related to the profession and learns how to apply them within the ERCOT culture.Follows standard practices and procedures in analyzing situations or data from which answers can be readily obtained.Contributes to specific objectives and outcomes as directed.ADDITIONAL JOB DUTIES
Level 1•Support Databases of Oracle 19C databases in 7/24 production environments•Support development, operations, and business teams with application installations and upgrades and associated database structure changes•Install, upgrade, maintain, monitor, optimize, and troubleshoot production and non-production Oracle databases•Install, upgrade, maintain, monitor, and optimize Oracle GoldenGate to support "near-real-time" data replication•Performs housekeeping on defunct user accounts and historical data•Install and maintain Server database products, including patch application and upgrade of the environments•Develops and executes back-up and recovery procedures•Performs periodic testing of the database backup and recovery plan•Audits user activity to ensure integrity and performance of the database•Develops and maintains proficient database development and design skills
Level 2 - Above +•Communicate clearly and effectively using written and verbal communication methods•Builds and establishes close working relationships with personnel in other ERCOT IT and Business groups•Works closely with development, operations, and testing teams to coordinate activities, resolve development and production issues, and perform application tuning•Performs database monitoring, tuning, and capacity planning•Develops and executes back-up and recovery procedures•Performs periodic testing of the database backup and recovery plan•Installs and maintains database products including patching and upgrading of environments•Creates/Maintains DBA scripts - Ansible/GIT/Python/Shell•Experience managing and maintaining database monitoring systems - Oracle Enterprise Manager•Coordinates with software vendor technical support•Audits user activity to ensure integrity and performance of the database•Coordinates and implements changes to development, test, and production environments•Implements and maintains multiple database environments, including logical/physical design and modeling•Develops and maintains proficient database development and design skills•Performs GoldenGate replication monitoring and trouble shooting•Install, patch, upgrade, and maintain GoldenGate products•Establishes standards, policies, and procedures for GoldenGate replication administration•Participates in On-Call rotation providing after hours support as needed to Production database systems.•Maintain knowledge of NERC CIP and SSAE16 compliance standards and ensure those standards are maintained in database systems
EXPERIENCE
Requires minimum 2 years job related work experience in excess of degree requirementsRequires minimum 2 years of progressively responsible information technology work experience with various database management systems in database design, testing, implementation, maintenance and administration in a multiple platform environmentRequires minimum 2 years in Oracle Data GuardRequires minimum 2 years in Oracle Recovery Manager (RMAN)Requires minimum 1 year with multi-terabyte databases and associated structuresEDUCATION
Bachelor's Degree : Computer Science, MIS or related field (Required)or a combination of education and experience that provides equivalent knowledge to a major in such fields is require
The foregoing description reflects the minimum qualifications and the essential functions of the position that must be performed proficiently with or without reasonable accommodation for individuals with disabilities. It is not an exhaustive list of the duties expected to be performed, and management may, at its discretion, revise or require that other or different tasks be performed as assigned. This job description is not intended to create a contract of employment with ERCOT. Both ERCOT and the employee may exercise their employment-at-will rights at any time. #LI-IV1
ERCOT is firmly committed to equal employment for all qualified persons without regard to race, sex, medical condition, religion, age, creed, national origin, citizenship status, marital status, sexual orientation, physical or mental disability, ancestry, veteran status, genetic information or any other protected category under federal, state or local law.
Expected Salary Range:$90,220 - $153,380
ERCOT is committed to fostering diversity and inclusion at all levels of our company. It is the cornerstone of our corporate values of accountability, leadership, innovation, trust, and expertise. We accept and celebrate those that join us and recognize that individuals with a wide variety of talents, ideas, and experiences propel the innovation that drives our success. A diverse and inclusive workforce strengthens us and allows for a collaborative environment to solve the challenges that face our industry today and in the future.
JOB SUMMARY
Administers, tests, and implements computer databases, applying knowledge of database management systems and storage administration. Coordinates changes to computer databases.
JOB DUTIES
Understands the basic principles, theories and concepts related to the profession and learns how to apply them within the ERCOT culture.Follows standard practices and procedures in analyzing situations or data from which answers can be readily obtained.Contributes to specific objectives and outcomes as directed.ADDITIONAL JOB DUTIES
Level 1•Support Databases of Oracle 19C databases in 7/24 production environments•Support development, operations, and business teams with application installations and upgrades and associated database structure changes•Install, upgrade, maintain, monitor, optimize, and troubleshoot production and non-production Oracle databases•Install, upgrade, maintain, monitor, and optimize Oracle GoldenGate to support "near-real-time" data replication•Performs housekeeping on defunct user accounts and historical data•Install and maintain Server database products, including patch application and upgrade of the environments•Develops and executes back-up and recovery procedures•Performs periodic testing of the database backup and recovery plan•Audits user activity to ensure integrity and performance of the database•Develops and maintains proficient database development and design skills
Level 2 - Above +•Communicate clearly and effectively using written and verbal communication methods•Builds and establishes close working relationships with personnel in other ERCOT IT and Business groups•Works closely with development, operations, and testing teams to coordinate activities, resolve development and production issues, and perform application tuning•Performs database monitoring, tuning, and capacity planning•Develops and executes back-up and recovery procedures•Performs periodic testing of the database backup and recovery plan•Installs and maintains database products including patching and upgrading of environments•Creates/Maintains DBA scripts - Ansible/GIT/Python/Shell•Experience managing and maintaining database monitoring systems - Oracle Enterprise Manager•Coordinates with software vendor technical support•Audits user activity to ensure integrity and performance of the database•Coordinates and implements changes to development, test, and production environments•Implements and maintains multiple database environments, including logical/physical design and modeling•Develops and maintains proficient database development and design skills•Performs GoldenGate replication monitoring and trouble shooting•Install, patch, upgrade, and maintain GoldenGate products•Establishes standards, policies, and procedures for GoldenGate replication administration•Participates in On-Call rotation providing after hours support as needed to Production database systems.•Maintain knowledge of NERC CIP and SSAE16 compliance standards and ensure those standards are maintained in database systems
EXPERIENCE
Requires minimum 2 years job related work experience in excess of degree requirementsRequires minimum 2 years of progressively responsible information technology work experience with various database management systems in database design, testing, implementation, maintenance and administration in a multiple platform environmentRequires minimum 2 years in Oracle Data GuardRequires minimum 2 years in Oracle Recovery Manager (RMAN)Requires minimum 1 year with multi-terabyte databases and associated structuresEDUCATION
Bachelor's Degree : Computer Science, MIS or related field (Required)or a combination of education and experience that provides equivalent knowledge to a major in such fields is require
The foregoing description reflects the minimum qualifications and the essential functions of the position that must be performed proficiently with or without reasonable accommodation for individuals with disabilities. It is not an exhaustive list of the duties expected to be performed, and management may, at its discretion, revise or require that other or different tasks be performed as assigned. This job description is not intended to create a contract of employment with ERCOT. Both ERCOT and the employee may exercise their employment-at-will rights at any time. #LI-IV1
ERCOT is firmly committed to equal employment for all qualified persons without regard to race, sex, medical condition, religion, age, creed, national origin, citizenship status, marital status, sexual orientation, physical or mental disability, ancestry, veteran status, genetic information or any other protected category under federal, state or local law.
Expected Salary Range:$90,220 - $153,380