Job Title: Database Developer/Analyst for DevOps Team
Location work will be performed: - Raleigh – NC 3 days onsite 2 days offsite.
Net 60 days payment
Job Description: Database Developer/Analyst for DevOps Team
Our client requires a Database Developer 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.
Types of services / activities required:
Provide DevOps Support (including Reporting/Analytics).
Creation and maintenance of data feeds for dashboards.
Provide Program Management Office (PMO) with various reports and metrics.
Support pricing & business rules for Clients for RSS systems.
Payment Card Industry (PCI) data collection.
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.
Expertise in PL/SQL Oracle programming language
Knowledge 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 performance
Design stable, reliable and effective databases
Optimize and maintain database system.
Modify databases according to requests and perform tests.
Solve database usage issues and malfunctions.
Liaise with developers to improve applications and establish best practices.
Gather user requirements and identify new features.
Provide Entity Relationship Diagrams (ERD), Dataflow for data schemas.
Provide data management support to users.
Ensure all database programs meet company and performance requirements.
Research and suggest new database products, services and protocols.
Able to work independently and as part of a team.
Able to multitask and prioritize tasks.
Education / Experience:
Bachelor’s degree in science, Business or related disciplines or equivalent work experience
A minimum of ten (10) years' experience in software development, database administration, and/or related field.
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.