Senior Oracle Developer in SmartTek Solutions

Senior Oracle Developer Львів, за кордоном, віддалено Smart Tek Solutions isaleadingIT service provider serving Fortune 500 companies inthe US. Our goal istobecome aleading employer inEurope, and weare now looking for atalented and experienced Senior Oracle Developer tojoin our dynamic team! Requirements: —Experience inproviding consulting support services for AME Approvals and setting upnew approval rules; —Familiarity with Table structures &Application Object Library (AOL); —Ability toanalyze program changes, participate intechnical troubleshooting, and implement technical solutions; Expertise inthe following Oracle Database Tools and Technologies: —SQL; —SQL*Plus; —SQL*Loader; —PL/SQL Store Procedures &Packages; —Java &J-Developer; —Application Programming Interface (API); —Data Loader; —Oracle Reports; —Oracle XMLPublisher; —Workflow builder; —Data Conversions &Interfaces. Experience inOracle User Management: —Creating, maintaining, and modifying access tousers. —Managing online Access forms onManage Engine (Harmony Ticketing Application); —Updating and maintaining Approval Hierarchies; —Accurate and effective record-keeping for audit purposes (Sarbanes Oxley Compliance requirements); Conducting user management audit activities asper Sarbanes Oxley Compliance requirements: —Daily, weekly, and monthly reporting; —Obtaining relevant approval; —Record-keeping; —Ensuring aclean Audit report (Harmony’s SOXrequirements). —Willingness tobeon-site asand when required byHarmony. Responsibilities: —Solve all production issues (Functional &Technical); —Configure existing and new functionality within Harmony’s deployed Oracle modules; —Assist “Super Users” with reconciliation and Month-End processes; —Assist “Super Users” with Testing for implementation ofbusiness and system changes and upgrades. —Open, manage, and resolve Oracle SRs with Oracle Support; —Assist, monitor, and measure Interface Table Cleaning onaweekly basis; —Coordinate with Oracle DBAs and System administrators toresolve internal technical issues; —Provide knowledge transfer toHarmony ERP resources; —Make modifications/changes and minor new developments for components/tasks such asstandard functionality not deployed inHarmony, custom Oracle Reports, custom API and Packages, workflows and notifications, ad-hoc PL/SQLqueries, AME and standard workflow approvals; —Prepare implementation methodology documents for Enhancements/Changes/Issue Fixes/Oracle SRs Solution ifapplicable; —Perform Data Cleansing; —Database Administration and System Administration Activities; —Server administration including Unix/Linux administration and network administration; —Hardware O/S, Network, Storage procurement/configuration/installation; —Issues related tohardware, hardware sizing &performance tuning. Weoffer: —Variety ofdomains; —Full stack oftechnologies; —Professional and highly interactive team environment; —Management style based onopenness and trust; —Stable support inpersonal education and growth; —Worthy compensation; —Active community with regular knowledge sharing; —Flexible work conditions; —Huge office with extra space for work &leisure.