Senior Oracle Developer (offline)

Smart Tek Solutions is a leading IT service provider serving Fortune 500 companies in the US. Our goal is to become a leading employer in Europe, and we are now looking for a talented and experienced Senior Oracle Developer to join our dynamic team

Requirements:
- Experience in providing consulting support services for AME Approvals and setting up new approval rules;
- Familiarity with Table structures & Application Object Library (AOL);
- Ability to analyze program changes, participate in technical troubleshooting, and implement technical solutions;
- Expertise in the 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 XML Publisher;
- Workflow builder;
- Data Conversions & Interfaces.
- Experience in Oracle User Management:
- Creating, maintaining, and modifying access to users.
- Managing online Access forms on Manage 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 as per Sarbanes Oxley Compliance requirements:
- Daily, weekly, and monthly reporting;
- Obtaining relevant approval;
- Record-keeping;
- Ensuring a clean Audit report (Harmony’s SOX requirements).
- Willingness to be on-site as and when required by Harmony.

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 of business and system changes and upgrades.
- Open, manage, and resolve Oracle SRs with Oracle Support;
- Assist, monitor, and measure Interface Table Cleaning on a weekly basis;
- Coordinate with Oracle DBAs and System administrators to resolve internal technical issues;
- Provide knowledge transfer to Harmony ERP resources;
- Make modifications/changes and minor new developments for components/tasks such as standard functionality not deployed in Harmony, custom Oracle Reports, custom API and Packages, workflows and notifications, ad-hoc PL/SQL queries, AME and standard workflow approvals;
- Prepare implementation methodology documents for Enhancements/Changes/Issue Fixes/Oracle SRs Solution if applicable;
- 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 to hardware, hardware sizing & performance tuning.


We offer:
- Variety of domains;
- Full stack of technologies;
- Professional and highly interactive team environment;
- Management style based on openness and trust;
- Stable support in personal education and growth;
- Worthy compensation;
- Active community with regular knowledge sharing;
- Flexible work conditions;
- Huge office with extra space for work & leisure.

About Smart Tek Solutions, LLC

SmartTek Solutions is a community of specialists with common values, great ambitions, and respect for professionalism. Being passionate about technology, we provide high-quality software in the area of web and mobile development, AVR Development, Odoo ERP, Blockchain, Cyber Security, IoT, Cloud Solutions, and E-commerce. Our mission is to deliver intelligent solutions for businesses all over the world by joining talented people and leveraging cutting-edge technologies.

Founded in 2019, with over 190 professionals on board, Smart Tek maintains 3 locations in Ukraine with corporate headquarters in Lviv. Working remotely or from the office, our specialists know how to work harmoniously and efficiently.

We are focused on growth and creating an efficient work environment. That’s why our corporate culture is based on humanity and teamwork. Smart Tek provides all the conditions and benefits to keep our specialists growing and getting the best results.

Build your career with us!

Company website:
https://smarttek.solutions

DOU company page:
https://jobs.dou.ua/companies/smarttek/