Database Administrator - SQL Server
Date: Oct 18, 2024
Location: Newark, NJ, US
Company: PSEG
Requisition: 78499
PSEG Company: PSEG Services Corp.
Salary Range: $ 88,400 - $ 140,000
Incentive: PIP 10%
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
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.
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. For external hires, this is a multi-level position, the title, grade level and incentive target assigned to the successful candidate will be determined by assessing skills, knowledge, competencies and related experience, learned through the interview process.
Responsibilities include but not limited to:
•Comply with 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.
•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 and SOX audits to ensure database integrity and user access
•Proactively seek out ways to improve performance and streamline database environments
•Ensure high levels of data availability and reliability of the systems
•Participate in Disaster Recovery planning, testing and execution
•Develops and implements processes and queries for data extraction, transformation, and loading data into databases.
•Installs, modifies, maintains, and configures database high availability (HA) options (i.e. clusters, Oracle RAC, SQL Server Always On)
•Works closely with Product Owners and vendors on new systems, enhancements, and upgrades to the database environment
•Monitors databases for performance issues and implements solutions for on-going database maintenance
•Assists in troubleshooting databases issues affecting databases reliability and uptime availability.
•Performs database version upgrades
Required:
•Bachelor's degree in Computer Science or Science, Technology, Engineering or Math
•4 or more years of DBA experience in design and administration of logical and relational databases in diverse technological environments
•Without a bachelor’s degree, minimum of 6 years of DBA experience in design and administration of logical and relational databases in diverse technological environments
•Experience in file structures, design, retrieval and access methods, database query and retrieval of data; Understanding of the systems development lifecycle; Solid understanding of business processes; Analytical ability, good communication skills, strong judgment and the ability to work effectively with clients and IT management and staff.
Desired:
•ITIL Foundation certificate
•Oracle and/or Microsoft SQL certifications
•Understanding of other common RDMS database systems
•Experience working with databases that are clustered and attached to a SAN infrastructure
•Experience with Oracle ASM, RAC, and Partitioning
•PostgreSQL, MySQL, RedShift, and AWS RDS Experience
•Database Automation Experience (Ansible, Python, PowerShell, Scripting)
No
Job Responsibilities
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.
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. For external hires, this is a multi-level position, the title, grade level and incentive target assigned to the successful candidate will be determined by assessing skills, knowledge, competencies and related experience, learned through the interview process.
Responsibilities include but not limited to:
•Comply with 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.
•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 and SOX audits to ensure database integrity and user access
•Proactively seek out ways to improve performance and streamline database environments
•Ensure high levels of data availability and reliability of the systems
•Participate in Disaster Recovery planning, testing and execution
•Develops and implements processes and queries for data extraction, transformation, and loading data into databases.
•Installs, modifies, maintains, and configures database high availability (HA) options (i.e. clusters, Oracle RAC, SQL Server Always On)
•Works closely with Product Owners and vendors on new systems, enhancements, and upgrades to the database environment
•Monitors databases for performance issues and implements solutions for on-going database maintenance
•Assists in troubleshooting databases issues affecting databases reliability and uptime availability.
•Performs database version upgrades
Required:
•Bachelor's degree in Computer Science or Science, Technology, Engineering or Math
•4 or more years of DBA experience in design and administration of logical and relational databases in diverse technological environments
•Without a bachelor’s degree, minimum of 6 years of DBA experience in design and administration of logical and relational databases in diverse technological environments
•Experience in file structures, design, retrieval and access methods, database query and retrieval of data; Understanding of the systems development lifecycle; Solid understanding of business processes; Analytical ability, good communication skills, strong judgment and the ability to work effectively with clients and IT management and staff.
Desired:
•ITIL Foundation certificate
•Oracle and/or Microsoft SQL certifications
•Understanding of other common RDMS database systems
•Experience working with databases that are clustered and attached to a SAN infrastructure
•Experience with Oracle ASM, RAC, and Partitioning
•PostgreSQL, MySQL, RedShift, and AWS RDS Experience
•Database Automation Experience (Ansible, Python, PowerShell, Scripting)
No
Job Specific Qualifications
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.
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. For external hires, this is a multi-level position, the title, grade level and incentive target assigned to the successful candidate will be determined by assessing skills, knowledge, competencies and related experience, learned through the interview process.
Responsibilities include but not limited to:
•Comply with 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.
•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 and SOX audits to ensure database integrity and user access
•Proactively seek out ways to improve performance and streamline database environments
•Ensure high levels of data availability and reliability of the systems
•Participate in Disaster Recovery planning, testing and execution
•Develops and implements processes and queries for data extraction, transformation, and loading data into databases.
•Installs, modifies, maintains, and configures database high availability (HA) options (i.e. clusters, Oracle RAC, SQL Server Always On)
•Works closely with Product Owners and vendors on new systems, enhancements, and upgrades to the database environment
•Monitors databases for performance issues and implements solutions for on-going database maintenance
•Assists in troubleshooting databases issues affecting databases reliability and uptime availability.
•Performs database version upgrades
Required:
•Bachelor's degree in Computer Science or Science, Technology, Engineering or Math
•4 or more years of DBA experience in design and administration of logical and relational databases in diverse technological environments
•Without a bachelor’s degree, minimum of 6 years of DBA experience in design and administration of logical and relational databases in diverse technological environments
•Experience in file structures, design, retrieval and access methods, database query and retrieval of data; Understanding of the systems development lifecycle; Solid understanding of business processes; Analytical ability, good communication skills, strong judgment and the ability to work effectively with clients and IT management and staff.
Desired:
•ITIL Foundation certificate
•Oracle and/or Microsoft SQL certifications
•Understanding of other common RDMS database systems
•Experience working with databases that are clustered and attached to a SAN infrastructure
•Experience with Oracle ASM, RAC, and Partitioning
•PostgreSQL, MySQL, RedShift, and AWS RDS Experience
•Database Automation Experience (Ansible, Python, PowerShell, Scripting)
No
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.
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. For external hires, this is a multi-level position, the title, grade level and incentive target assigned to the successful candidate will be determined by assessing skills, knowledge, competencies and related experience, learned through the interview process.
Responsibilities include but not limited to:
•Comply with 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.
•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 and SOX audits to ensure database integrity and user access
•Proactively seek out ways to improve performance and streamline database environments
•Ensure high levels of data availability and reliability of the systems
•Participate in Disaster Recovery planning, testing and execution
•Develops and implements processes and queries for data extraction, transformation, and loading data into databases.
•Installs, modifies, maintains, and configures database high availability (HA) options (i.e. clusters, Oracle RAC, SQL Server Always On)
•Works closely with Product Owners and vendors on new systems, enhancements, and upgrades to the database environment
•Monitors databases for performance issues and implements solutions for on-going database maintenance
•Assists in troubleshooting databases issues affecting databases reliability and uptime availability.
•Performs database version upgrades
Required:
•Bachelor's degree in Computer Science or Science, Technology, Engineering or Math
•4 or more years of DBA experience in design and administration of logical and relational databases in diverse technological environments
•Without a bachelor’s degree, minimum of 6 years of DBA experience in design and administration of logical and relational databases in diverse technological environments
•Experience in file structures, design, retrieval and access methods, database query and retrieval of data; Understanding of the systems development lifecycle; Solid understanding of business processes; Analytical ability, good communication skills, strong judgment and the ability to work effectively with clients and IT management and staff.
Desired:
•ITIL Foundation certificate
•Oracle and/or Microsoft SQL certifications
•Understanding of other common RDMS database systems
•Experience working with databases that are clustered and attached to a SAN infrastructure
•Experience with Oracle ASM, RAC, and Partitioning
•PostgreSQL, MySQL, RedShift, and AWS RDS Experience
•Database Automation Experience (Ansible, Python, PowerShell, Scripting)
No
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.
For all roles, 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. Although numerous states throughout the country have legalized marijuana/cannabis products recreationally and/or medically, it is prohibited for employees in federally regulated roles. Employees who are hired or transfer into a federally regulated role are subject to drug and alcohol testing, inclusive of marijuana. Please note that the use of CBD products may result in a positive drug test for THC/Marijuana and such use is not a legitimate medical explanation for such a positive result.
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 (PSEG Careers and Job Openings) 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: Newark
Nearest Secondary Market: New York City
Job Segment:
Database, SQL, Testing, System Administrator, DBA, Technology