Database administrator

Lead Database AdministratorISO New England Inc., One Sullivan Road, Holyoke, Massachusetts, United States of America Req #951Tuesday, July 16, 2024ISO New England is the not-for-profit, independent system operator responsible for ensuring the safe and reliable flow of electricity in our region and planning for the future of the electric grid.We are at the forefront of New England's ongoing transition to clean energy.Manage physical database design and implementation, database security and monitoring including : install / upgrade / patch Oracle and PostgreSQL databases;deploy data models; administer database security as per company policy.Database performance tuning including : resolve complex performance issues using available tools; developing alternatives to solve tuning challenges;evaluate complex tuning challenges in databases and queries.• Evaluate new features / products including : evaluating new features in Oracle database technology to improve the productivity of development teams and document and educate team members about new features and products.• Lead setup and development of test environments for Enterprise projects and releases and improve and automate the scripts to setup these environments.• Assist and support application teams in database production migration activities and resolve database issues during the cutover / migration.• Monitor database backups, resolve backup issues and implement best practices, recover databases as needed to retrieve historical data, develop shell / perl scripts to automate database.Requirements :• Must have Bachelor's in Computer Science, Engineering or Mathematics with a focus in Computer Science.• Must have 8 years of experience in database administration working with Oracle releases and PL / SQL.• The stated experience must also include the following : (1) 3 years of programming or software development using SQL, PL / SQL, Unix, and Shell Scripting;2) 1 year of experience preparing development and test database environments.ISO New England oversees the 24 / 7 operation of the power grid that covers the six-states of New England and administers the region's multi-billion dollar "stock exchange" for the buying and selling of wholesale electricity.The power system is constantly evolving as new technologies emerge and energy policies evolve. There is a lot happening at our organization behind the scenes to make sure the grid continuously yields reliable electricity at competitive prices while addressing the clean energy transition here in New England.COME JOIN US in making an impact on the region!Equal Opportunity : We are proud to be an EEO / AA employer. Applicants for employment are considered without regard to race, color, religion, creed, sex (including pregnancy, childbirth, and related medical conditions), gender identity or expression, sexual orientation, citizenship, national origin, age, ancestry, marital status, disability (including learning, mental, intellectual, and physical), service in the uniformed services, genetic information, or any other status protected by applicable law.Drug Free Environment : We maintain a drug-free workplace and perform pre-employment substance abuse testing.Other details• Pay Type Salary• Telecommute % 60Apply Now• context" : "https : / / schema.org / ","@type" : "JobPosting","title" : "Lead Database Administrator","datePosted" : "2024-07-16T00 : 00 : 00","validThrough" : null,"description" : "Job duties include the following : n nManage physical database design and implementation, database security and monitoring including : install / upgrade / patch Oracle and PostgreSQL databases;• deploy data models; administer database security as per company policy. nDatabase performance tuning including : resolve complex performance issues using available tools;developing alternatives to solve tuning challenges; evaluate complex tuning challenges in databases and queries. nEvaluate new features / products including : evaluating new features in Oracle database technology to improve the productivity of development teams and document and educate team members about new features and products.nLead setup and development of test environments for Enterprise projects and releases and improve and automate the scripts to setup these environments.nAssist and support application teams in database production migration activities and resolve database issues during the cutover / migration.nMonitor database backups, resolve backup issues and implement best practices, recover databases as needed to retrieve historical data, develop shell / perl scripts to automate database.n n nRequirements : n nMust have Bachelor's in Computer Science, Engineering or Mathematics with a focus in Computer Science.nMust have 8 years of experience in database administration working with Oracle releases and PL / SQL. nThe stated experience must also include the following : (1) 3 years of programming or software development using SQL, PL / SQL, Unix, and Shell Scripting;2) 1 year of experience preparing development and test database environments. n","employmentType" : "FULL TIME","hiringOrganization" : "@type" : "Organization","name" : "ISO New England Inc.logo" : "https : / / us241.dayforcehcm.com / CandidatePortal / en-US / isone / Go?item e0f9d2fe-3f6c-4bc3-bba5-19e9d4c9aed3" ,"jobLocation" : "@type" : "Place","address" : "@type" : "PostalAddress","streetAddress" : "One Sullivan Road","addressLocality" : "Holyoke","addressRegion" : "Massachusetts","postalCode" : "01040","addressCountry" : "USA" ,"jobLocationType" : null,"baseSalary" : "@type" : "MonetaryAmount","value" : "@type" : "QuantitativeValue","value" : null,"minValue" : null,"maxValue" : null,"unitText" : "YEAR"ISO New England Inc., One Sullivan Road, Holyoke, Massachusetts, United States of AmericaShare this job :Last updated : 2024-09-08