UGI Utilities, Inc.

SQL Server Database Administrator

LocationDenver, PA
Job TypeFull-time

About This Job


Requisition Number: 26175

At UGI Utilities, Inc. we believe in providing a superior range of energy products and services to our customers in a safe, affordable manner. As our energy needs evolve, UGI will be there providing safe and reliable service that brings warmth and comfort to our 750,000 customers in 45 counties in Pennsylvania and 1 county in Maryland.

We strive to reflect the communities we serve by attracting and retaining top talent, while maintaining a diverse workforce that embraces our culture of safety, service, and integrity. As an employee of UGI Utilities, you can expect a competitive total compensation plan and comprehensive benefits. Employees work in a collaborative environment, have upward mobility opportunities, and the ability to enjoy a true work life balance.

UGI is committed to acting in a sustainable and socially responsible manner to minimize our impact on the environment and to enrich the lives of our customers, communities, and employees. To learn more about UGI's workplace culture, sustainability efforts, and commitment to diversity, equity and inclusion (DE&I), we invite you to visit our UGI Corporate sustainability page .

Apply to UGI Utilities today to share in our mission and support countless neighbors, friends, and families in providing best-in-class products and services!


Job Summary:

Supports all aspects of database administration including installation, configuration, upgrades, performance tuning, backup and recovery, problem solving, adherence to security policies and all other aspects of managing the databases. In addition, they would plan, develop and optimize database systems, troubleshoot issues submitted via Incident tickets, and provide both end user and developer support. The ideal candidate should have strong technical skills, excellent problem-solving abilities and experience with high-availability solutions.


Duties and Responsibilities:


Production Implementation and Configuration/On going Support (15%)

Installation and configuration of Microsoft SQL Server Database, Oracle Databases and other databases as needed (PostGres, Mongo, MySQL are nice to have).
Support Hypercare for Production implementations in addition to additional configurations and tuning that may be required as part of initial rollout.
Responsibilities extend to App Server environments (Oracle Application Server/Weblogic/Tomcat)
Strategic long and short-term patching and upgrades of databases.
Refine and automate processes for day to day activities.
Identify and troubleshoot software problems at the database and Application Server Level.


Strategic Business Interaction (15%):

Interact with Business colleagues, vendors, and IT colleagues to support IT Projects and KTLO (Keep the Lights On) initiatives.
Educate other IT and Business personnel regarding IT standards, policies and procedures.
Assist developers/contractors with complex SQL tuning and make recommendations for schema refinement.

Work closely with Business Units and other technical resources to understand new systems, 3rd Party products, and business requirements.


Keep the Lights On (50%)

Maintain and Configure databases and their processes.
Monitoring of System Health and Performance
Ensure a high level of security, performance and availability for the databases supported.
Document database configuration processes and standards associated with setup.
Assure Backup and Recovery capabilities for all database systems supported.

Perform scheduled maintenance and support release deployment after hours, if required.


Support New Projects (20%):

Participate in the organizational change management activities for UGI technology projects as a team member.
Contribute to various infrastructure activities related to the project including Technical Team meetings and planning sessions.
Support project cutover planning activities as it related to the database environment. This should include backout and recovery procedures.
Keep actively involved in Hypercare activities after project implementation.
Advise Team leads on issues related to the database and frontend application servers that are related.


Knowledge, Skills and Abilities:

Strong knowledge of business software applications and hardware technologies as they apply to the databases supported. Stays current with all IT industry trends, emerging technologies, and database security.
Working knowledge of COBIT5 based IT Governance and Management framework or other structured industry standard methodologies.
Strong verbal, written, analytical, and interpersonal skills. Frequently presents information to their team, department, and business areas.
Understands project plans and can clearly articulate their role, project goals, and timelines. Develops project plans for small projects; partners with Project Managers to develop project plans for large projects and assists Manager with resource management.
Authors technical design specifications for smaller projects. Mentor other team members regarding technical information. Must continuously develop and maintain necessary technical skillsets to enhance business solutions within the UGI architecture.
Continuous improvement of Monitoring performance, enhanced procedures, and tuning of the database.
Experience with Cloud Based Database Platforms (Azure, AWS, etc.)
Knowledge of replication methods, clustering, failover strategies.


Education and Experience:

Required: Bachelor’s degree in Information/Computer Science, Business Administration, Engineering, Mathematics, Information Systems or equivalent discipline.
Three to Four years of MS SQL Server Experience performing the duties of Data Base Administrator. Strong knowledge of Microsoft SQL Server (2016/2019/2022). Experience with High Availability Solutions (AlwaysOn Groups, Failover Cluster Instances). Familiarity with monitoring tools such as Solar Winds DPA. Working knowledge of SQL Server security best practices and procedures. Ability to automate database tasks using Power Shell scripts. Additional experience with Oracle, DB2, PostGres, Mongo DB is a plus.
ITIL (IT Infrastructure Library) Foundation certification (at hire or within 12 months in position).
Proficiency in MS-Office products

UGI Utilities, Inc is an Equal Opportunity Employer. The Company does not discriminate on the basis of race, color, sex, national origin, disability, age, gender identity, sexual orientation, veteran status, or any other legally protected class in its practices.

Successful applicants shall be required to pass a pre-employment drug screen as a condition of employment, and if hired, shall be subject to substance abuse testing in accordance with UGI policies.

As a federal contractor that engages in safety-sensitive work, UGI cannot permit employees in certain positions to use medical marijuana, even if prescribed by an authorized physician. Similarly, applicants for such positions who are actively using medical marijuana may be denied hire on that basis.

Similar Jobs

Trending Jobs

company-logo

Nuclear Technical Intern - Mid Atlantic

Constellation
Job TypeInternship
 
Lusby, MD
24 days ago
company-logo

Apprentice Lineman

Brink Constructors, Inc.
Job TypeFull-time
 
Rapid City, SD
23 days ago
company-logo

Deckhand (Houston)

John W. Stone Oil Distributor, LLC
 
Houston, TX
24 days ago
company-logo

Electrical Engineer

Dudley Staffing
Job TypeFull-time
Salary
$55 - $75
Canonsburg, Pennsylvania
3 months ago
company-logo

Director, Financial Planning & Analysis - Energy (Enterprise)

Pilot Thomas Logistics
Job TypeFull-time
 
Grapevine, TX
24 days ago
company-logo

Quality Engineer

Jedco Inc.
Job TypeFull-time
 
Grand Rapids, MI
18 days ago
company-logo

Solar Electrician

MN8 Energy
Job TypeFull-time
 
California, United States
22 days ago
company-logo

Sr. Polymer Scientist

ExxonMobil
Job TypeFull-time
 
Baytown, TX
22 days ago
company-logo

Gas Foreman

Peak Utility Services Group
Job TypeFull-time
 
Lawton, OK
23 days ago
company-logo

Apprentice Lineman I

San Patricio Electric Cooperative, Inc.
Job TypeFull-time
 
Sinton, TX
8 days ago
company-logo

Apprentice Line Worker I

Tampa Electric
Job TypeFull-time
 
Ruskin, FL
about 1 month ago
company-logo

Finishing Helper Entry Level- Dayshift

Bonnell Aluminum
Salary
$41600 - $41600
Carthage, TN
18 days ago
company-logo

contract landman

HPS Oil & Gas Properties
Job TypeFull-time
 
Lafayette, Louisiana
about 2 months ago
SD

Service Manager

Supertech Diesel Truck Specialists
Job TypeFull-time
 
Langley, BC
21 days ago
company-logo

Meter Technician

ONEOK
Job TypeFull-time
 
Odessa, TX
24 days ago
company-logo

Apprentice Power Lineman

Proline Power Corp.
Job TypeFull-time, Apprenticeship
 
Red Deer, AB
28 days ago
SD

Service Manager

Supertech Diesel Truck Specialists
Job TypeFull-time
 
Nanaimo, BC
21 days ago
company-logo

Senior Landman

Greenlake Energy
Job TypeFull-time
 
Austin, Texas
15 days ago
company-logo

Senior Investigator

Dominion Energy
Job TypeFull-time
 
Norfolk, VA
24 days ago
company-logo

Assembler/Production

Uptalent
Job TypeContract
Salary
$37440 - $49920
Oklahoma City, OK
17 days ago