Lucid Technologies Inc

Job Title: IT - Database Analyst/Programmer III

Location work will be performed: NC - Raleigh – Hybrid 3 days onsite and 2 days remote.

NOTE: *U.S. Citizens, Green card are authorized to work in the U.S. are encouraged to apply*

Database Developer/Analyst

•Client requires Supplier to support the DevOps team, including Reporting & Analytics, for enterprise data distributions and updates, back-end database support for operational retail data as well as non-production environmental data, and front-end interfaces for all RSO hosted reports and dashboards for the RSS PMO as well as reporting and analytic activities in connection with the system health and software currency of the RSS application.

•Provide DevOps Support (including Reporting/Analytics).

•Provide reporting assistance with data mining.

•Perform ServiceNow Incident & Change Management implementation.

•Creation and maintenance of data feeds for dashboards.

•Provide Program Management Office (PMO) with various reports and metrics.

•Support pricing & business rules for for RSS systems.

•Payment Card Industry (PCI) data collection.

Technical Requirements: 

Specific criteria is outlined in the following tasks to provide packaging, provisioning, DevOps (including reporting & analytics), and server application support for the Retail Systems Software (RSS) application that spans 66 RSS/RS-SS production servers and over 48,000 retail terminals/devices in the field.

•Perform Oracle database Extract, Translate, and Load (ETL) processes to facilitate monitoring and reporting functions.

•Support Oracle databases and stored procedures.

•Provide Web Tools for end users.

•Support interfaces for data updates from data stewards.

•Validate interface data according to data specifications.

•Manage client-specific 12-digit bar codes for Postal products.

•Provide programming support to reboot terminals when necessary.

• Provide programming support to continuously retrieve the health of the 66 Production RSS/RS-SS application servers and provide data feeds to the monitoring dashboards.

•Provide programming support to retrieve software installation and registry information from 48,000+ terminals and devices in the field to determine software currency.

•Send dashboard alerts when critical infrastructure is in alarm status.

•Manage interfaces between the terminal ordering system and the monitoring/reporting system to keep a current inventory of systems in the field.

•Provide monthly, or upon request, key performance metrics based on established deliverables.

Above requirements shall meet the following acceptance criteria.

•Number of interface files as expected and within specifications.

•Successful Electronic Data Distributions (EDD) for Postal products/services.

•Documented processes for ETL, Web Tools, interfaces, and programming logic.

•Dashboards showing current system health of retail terminals and servers.

•Number of servers in good health.

•Number of systems with current software at 100% for given release levels.

•Number of systems not at current software or release level.

•Quarterly accomplishments.

•Monthly and ad-hoc performance metrics.

•Bachelor’s degree in science, Business or related disciplines or equivalent work experience

•Pass both a client mandated clearance process to include drug screening, criminal history check and credit check.

•Please note that any usage and detection of cannabis with or without a prescription will result in a failed US Postal clearance regardless of the legalization under State Laws.

•Once candidate’s resume is approved and interview passed, the agency is responsible for providing drug screening. Failure to submit the drug screening results will delay the security clearance process.

•If a candidate is given an interim clearance, continuation of employment is then based on the candidate receiving a sensitive clearance.

•All candidates must be a US Citizen or have permanent residence status (Green Card).

•Candidate must have lived in the United States for the past 5 years.

•Cannot have more than 6 months’ travel outside the United States within the last five years. Military Service excluded. (Exception does not include military family members.) 

• All overtime must be pre-approved in writing by the client manager or his/her designated representative