Job Location : Rochester,NY, USA
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 finishfrom an initial study to determine a projects 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 clients Rochester office (hybrid work week - 3 days in office). The propose of this position will provides the following: Provides database support for the AVANGRIDs 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 SQLLoader. Knowledge of database programming, SQLPlus 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 Bachelors 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 walletLaBellas 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