LaBella Associates
Sr. Oracle DBA / Lead Analyst for Service Now/Sail Point
LaBella Associates, Vestal, New York, United States, 13850
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: $110,000.00 - $125,000.00The 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.RequirementsStrong 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 ServersGeneral 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 ScriptBe on call on an on-call roster for database and systems support activity.General Knowledge & SkillsWorking 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.RequirementsEducation and Experience: (Must meet at least one of the following)Bachelor’s Degree with 5+ years in RDBMS experienceAssociate Degree with 7+ years in RDBMS experience7-10+ years’ IT and RDBMS related experienceBenefitsBody, 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 ScheduleHealth/Dental Insurance401k Plan with Employer MatchShort & Long Term DisabilityProfit SharingPaid Time OffLeadership Development ProgramFitness ReimbursementTuition ReimbursementReferral Bonus ProgramWellness ProgramTeam Building EventsCommunity Service Events
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.00The 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.RequirementsStrong 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 ServersGeneral 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 ScriptBe on call on an on-call roster for database and systems support activity.General Knowledge & SkillsWorking 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.RequirementsEducation and Experience: (Must meet at least one of the following)Bachelor’s Degree with 5+ years in RDBMS experienceAssociate Degree with 7+ years in RDBMS experience7-10+ years’ IT and RDBMS related experienceBenefitsBody, 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 ScheduleHealth/Dental Insurance401k Plan with Employer MatchShort & Long Term DisabilityProfit SharingPaid Time OffLeadership Development ProgramFitness ReimbursementTuition ReimbursementReferral Bonus ProgramWellness ProgramTeam Building EventsCommunity Service Events