Senior Database Administrator - Oracle
Date: Dec 1, 2023
Location: Bethpage, NY, US
Company: PSEG
Requisition: 75924
PSEG Company: PSEG Long Island
Salary Range: $ 90,800 - $ 149,800
Incentive: PIP 15%
Work Location Category: Remote Local
PSEG operates under a Flexible Work Model where flexible work is offered when job requirements allow. In support of this model, roles have been categorized into one of four work location categories: onsite roles, hybrid roles that are a blend of onsite and remote work, remote local roles that are primarily home-based but require some level of purpose-driven in-person interaction and living within a commutable distance, and remote non-local roles that can be effectively performed remotely with the ability to work in approved states.
PSEG offers a unique experience to our more than 12,000 employees – we provide the resources and opportunities for career development that come with being a Fortune 500 company, as well as the attention, camaraderie and care for one another you might typically associate with a small business. Our focus on combatting climate change through clean energy technology, our new net zero climate vision for 2030 and enhanced commitment to diversity, equity and inclusion; and supporting the communities we serve make this a particularly exciting time to join PSEG.
Job Summary
Responsible for the day-to-day administration, technical support, troubleshooting, maintenance, upgrades, patching, performance and overall health of an Oracle and Microsoft SQL database infrastructure within a UNIX, Linux, and Microsoft Windows Server clustered server environment. Ensure high levels of data availability and reliability of the systems. Respond effectively to the continuing demands for information 24/7 by business clients, contractors, and other areas of IT.
Job Responsibilities
Primary Responsibilities include:
• Work closely with business clients in understanding data access requirements and ensuring proper performance of transactions within the database in support of complex business application development requirements and processes
• Work closely with Product Managers and vendors on new systems, enhancements, and upgrades to the database environment
• Monitor and deploy security patches as required to maintain a secure system; provide support for database security to ensure database integrity and user access
• Proactively seek out ways to improve performance and streamline database environments
• Performs database version upgrades and ensure high levels of data availability and reliability of the systems
• Develops and implements processes and queries for data extraction, transformation, and loading data into databases.
• Monitors databases for performance issues and implements solutions for on-going database maintenance
Assists in troubleshooting databases issues affecting databases reliability and uptime availability.
• Designs policies and procedures for the administration of the databases, maintenance and upgrades of database software, and oversight of backups and standby databases. Establish and maintain databases for user tests and production purposes
• Designs policies and procedures related to database security that adhere to Corporate Security Standards, eliminates potential security weaknesses, and reduces risks
• Manages Disaster Recovery planning, testing and execution
Job Specific Qualifications
Required Education and Experience:
• Bachelor's degree in Computer Science or Science, Technology, Engineering or Math (STEM)
• A minimum of 6 years of DBA experience in design and administration of logical and relational databases in diverse technological environments
• Experience in configuring and managing Oracle RAC, Clusterware, Grid infrastructure, Oracle ASM, OEM, GoldenGate, Partitioning, Advanced Tuning
• Develop and maintain system documentation related to your Oracle Exadata and software configuration
• Experience with Oracle engineered systems (Exadata) including tuning, patching, maintenance, backup/recovery and troubleshooting
• Apply process and architectural improvements to continually improve the availability, capacity, and performance of database systems
• Understanding of the systems development lifecycle
• Solid understanding of business processes
• Strong analytical skills
• Demonstrated strong communication skills
• Ability to exercise strong judgment and the ability to work effectively with clients and IT management and staff
Desired:
• ITIL Foundation certificate
• Oracle certifications
• Oracle Cloud Infrastructure (OCI), Oracle Autonomous Databases
• Experience with Oracle ExaCC
• Familiar with Oracle database resource manager, Ansible/automation/scripting
• Experience with patching grid infrastructure software
• Strong Unix/Linux scripting and automation skills
Minimum Years of Experience
Education
Certifications
Disclaimer
Certain positions at the Company may require you to have access to Part 810-Controlled Information. Under the law, the Company is limited in who it can share this information with and in certain circumstances it is necessary to obtain specific authorization before the Company can share this information. Accordingly, if the position does require access to this information, you must complete a 10 CFR Part 810 Export Control Compliance Nationality Request Form, a copy of which will be provided to you by Talent Acquisition if an offer is made. If there is a need for specific authorization, due to the time it takes to obtain authorization from the government, we will likely not be able to further proceed with an offer.
PSEG is an equal opportunity employer, dedicated to a policy of non-discrimination in employment, including the hiring process, based on any legally protected characteristic. Legally protected characteristics include race, color, religion, national origin, sex, age, marital status, sexual orientation, disability or veteran status or any other characteristic protected by federal, state, or local law in locations where PSEG employs individuals.
As an employee of PSEG you should be aware that during storm restoration efforts, you may be required to perform functions outside of your routine duties and on a schedule that may be different from normal operations.
PSEG’s drug and alcohol testing program includes pre-employment testing, testing for cause, and post-incident/accident testing. For employees in federally regulated roles (including positions covered by USDOT, PHMSA, or NRC regulations), this also includes random testing. All drug and alcohol testing for federally regulated roles is inclusive of marijuana. Employees who transfer into a federally regulated role are subject to drug and alcohol testing, inclusive of marijuana.
PSEG employees must apply for jobs internally through emPower which can be accessed through sharepoint.pseg.com by clicking on the emPower icon, then selecting careers. This site (https://jobs.pseg.com/) is strictly for candidates who are not currently PSEG employees, with the exception of PSEG employees who do not have company email addresses.
PSEG is committed to providing reasonable accommodations to individuals with disabilities. If you have a disability and need assistance applying for a position, please call 973-430-3845 or email accommodations@pseg.com.
If you need to request a reasonable accommodation to perform the essential functions of the job, email accommodations@pseg.com. Any information provided regarding a disability will be kept strictly confidential and will not be shared with anyone involved in making a hiring decision.
ADDITIONAL EEO/AA INFORMATION (Click link below)
Nearest Major Market: New York City
Job Segment:
Database, System Administrator, Cloud, Testing, Recruiting, Technology, Human Resources