LaBella Associates
Sr. Oracle DBA / Lead Analyst for Service Now/Sail Point
LaBella Associates, Rochester, NY
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 Rochester 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: $110,000.00 - $125,000.00
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)
o Bachelor's Degree with 5+ years in RDBMS experience
o Associate Degree with 7+ years in RDBMS experience
o 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
We are currently hiring a Sr. Oracle DBA - Lead Analyst - Database Support in our Program Management Services division at our client's Rochester 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: $110,000.00 - $125,000.00
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)
o Bachelor's Degree with 5+ years in RDBMS experience
o Associate Degree with 7+ years in RDBMS experience
o 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