p>The position involves the following essential functions: • Developing, debugging and optimizing database objects using Oracle PL/SQL • Writing ad-hoc queries and reports; developing BI dashboards to meet business needs • Supporting the ERP system, including integrations with external systems • Ensuring ERP system stability, security, and functionality; monitoring backups of all databases and database servers • Partnering with HR, Accounting, and Design and Construction teams to identify system improvements and implement solutions • Coordinating system upgrades, patches, and releases; conducting regression testing and validation • Participating in disaster recovery planning and testing • Running monthly processes in the ERP system to support corporate/field operations • Creating new user accounts • Triaging customer issues • Managing vendor relationships, submitting and tracking vendor help requests and feature requests • Accurately recording, updating and documenting requests using the IT service desk system • Creating user guides and other related documentation • Building rapport and communicating effectively with technical and non-technical colleagues at all levels in the organization • Maintaining compliance with all company policies and procedures • Performing related duties as assigned by supervisor.
• Bachelor's degree in computer science, engineering, information systems, or equivalent • 4+ years database development in Oracle environment • 4+ years writing and debugging stored procedures, functions, views, triggers, indexes, constraints • 2+ years experience with Business Intelligence tools such as Tableau or PowerBI • Experience with SQL Server Reporting Services, Oracle Forms, Oracle Reports or Jasper • Strong analytical, problem solving, and troubleshooting skills • Ability to prioritize tasks, manage schedule, and work under pressure • Excellent written and verbal communication skills • Proactive approach to customer service • Experience in database design and modeling • Experience in performance tuning and query optimization • Advanced use of Windows applications and file systems, including RDP, UNC paths, folder permissions, and batch scripting • CMiC or other construction ERP experience a plus • Experience with Toad a plus • Advanced use of Excel formulas, Power Queries, and Pivot Tables a plus • Knowledge of HTML, CSS a plus • Experience with PowerShell, Python, or other scripting languages a plus • Desire to continue education through trade shows, conferences, online courses, etc.