Sr. Oracle Dba / Lead Analyst For Service Now/Sail Point

LaBella Associates was established in 1978 and is a certified Great Place To Work. We are headquartered in Rochester, NY with offices across New York, Ohio, Pennsylvania, Connecticut, Maine, Virginia, North and South Carolina, and Madrid, Spain. LaBella is a multi-disciplined architectural and engineering firm dedicated to client satisfaction through teamwork, respect, and trust. We provide services that take a project from start to finish—from an initial study to determine a project’s feasibility to construction administration and start up, and everything in between.
We are currently hiring a Sr. Oracle DBA - Lead Analyst – Database Support in our Program Management Services division at our client’s Augusta, ME office (hybrid work week - 3 days in office). The propose of this position will provides the following:
Provides database support for the AVANGRID’s Service Now System, Outage Management System (OMS), Energy Control Systems (ECS) used to operate Electric Transmission &
Distribution Systems and Backoffice applications and other proprietary applications.
Creating RDBMS environments for projects and business requirements.
Proactively monitor and maintain all database and application systems in for an uninterrupted service.
Document all database system designs, maintenance, and enhancement work.
Salary Range:
$(phone number removed) - $(phone number removed)
The specific salary offered may be influenced by a variety of factors including but not limited to the candidate's relevant experience, education, and work location.
Requirements
Strong background in Oracle database administration in Oracle 19c, Oracle 12c and Oracle 11g.
Strong background in administering Oracle Real Application Cluster (RAC), ASM technology and Oracle DataGuard in all above versions of Oracle.
Strong background in the use of database utilities like Oracle Data Pump, RMAN, Oracle Imp/Exp and/or SQL*Loader.
Knowledge of database programming, SQL*Plus and PL/SQL, Materialized views, Triggers, using Database Change Notification.
Experience in database tuning and SQL tuning for applications.
Experience working with RedHat Enterprise Linux and Oracle Solaris UNIX.
Experience working with Exadata Servers and Oracle Linux on Exadata Servers
General knowledge in using/working on virtual environments.
Good Knowledge/Understanding of Network communication and services.
Knowledge of at least one of the following is desirable:
Shell Scripting, Python, C, Java Script
Be on call on an on-call roster for database and systems support activity.
General Knowledge &
Skills
Working with the understanding of relevant Industry Compliance Regulations and Policies. (E.G. NERC-CIP, etc. training will be provided)
The ability to demonstrate good communication skills both written and orally. Experience in making sound decisions while working in a high-pressure environment.
Working during storm or other emergency conditions for 24-hour system support.
Able to work independently and contribute proactively to drive results.
Prior experience in working with Electric Utilities or with any other utilities is an advantage.
Requirements
Education and Experience:
(Must meet at least one of the following)
Bachelor’s Degree with 5+ years in RDBMS experience
Associate Degree with 7+ years in RDBMS experience
7-10+ years’ IT and RDBMS related experience
Benefits
Body, mind, and wallet—LaBella’s benefits support a holistic approach to your health and wellness, creating the foundation for physical, mental, and financial well-being. Our benefit offerings cover the must-haves (healthcare and retirement), the just-in-cases (insurances and employee assistance programs), and the cherry-on-tops (fitness reimbursements, year-end incentive pay, and tuition assistance). Visit our website for more details on benefits listed below.
Flexible Work Schedule
Health/Dental Insurance
401k Plan with Employer Match
Short &
Long Term Disability
Profit Sharing
Paid Time Off
Leadership Development Program
Fitness Reimbursement
Tuition Reimbursement
Referral Bonus Program
Wellness Program
Team Building Events
Community Service Events