Database Developer / Analyst
Qty : 1
Desired Start Date : 11 / 13 / 2023.
End Date : 9 / 30 / 2024
Hrs / Wk : 40.00
Clearance Level : Public Trust
Description :
Client is seeking support for 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.
Types of services / activities required :
- 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 Client 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.
Skillset :
Expertise in PL / SQL Oracle programming languageKnowledge and understanding of the ETL (Extract, Transform, Load) process.Ability to create database objects such as tables, views, indexes, clusters, stored procedures, ...Able to perform database modeling, optimization, and integration.Knowledge of database design principles.Knowledge of techniques such as aggregate functions, subqueries, ordering and grouping to retrieve data from a table.Optimization and database performanceRequirements :
Design stable, reliable and effective databasesOptimize and maintain database systemModify databases according to requests and perform testsSolve database usage issues and malfunctionsLiaise with developers to improve applications and establish best practicesGather user requirements and identify new featuresProvide Entity Relationship Diagrams (ERD) , Dataflow for data schemasProvide data management support to usersEnsure all database programs meet company and performance requirementsResearch and suggest new database products, services and protocolsAble to work independently and as part of a teamAble to multitask and prioritize tasks.Education / Experience :
Bachelor's degree in science, Business or related disciplines or equivalent work experienceA minimum of ten (10) years' experience in software development, database administration, and / or related field.Additional Provisions :
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.Agency will not be reimbursed for overtime charges without previous written authorization. Authorized overtime will be reimbursed at straight time.The enforced dress code is business casual, i.e., collared shirt with slacks for men, no skirts above the knee for women.ABBTECH is an EOE / Minorities / Women / Disable Individuals / Veterans