Sr. Oracle DBA / Lead Analyst for Service Now/Sail Point

---

Job description

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 Vestal, NY 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

<!– job description page –>