Job Listing Information

Database Architect
  • 02-Feb-2023 to 16-Feb-2023 (UTC)
  • Richmond, VA, USA
  • Full Time
  • Long Term Contract Length
  • 40 Weekly Hours

Candidates will need to be able to attend onsite meetings, when requested, NO exceptions

First round of interviews will be conducted by phone. Second round will be via webcam

Assignment will possibly be extended another six months

 

Perform operation and maintenance support for Oracle  and SQL Server databases along with building out new databases and data integrations as per project requirements.

- 7+ years hands-on experience in Oracle 12c or greater is required.

- 5+ years serving in a data architecture position is required.

- 5+ years experience building data flows using ETL tools is required.

- Ability to architect and model mission critical RDMS, BI, OLTP, OLAP and solutions leveraging multiple DBMS technologies is required.

- Extensive experience with Data Analysis, Data Profiling, Data Flows and Data Modeling is required.

- Demonstrated experience with profiling and loading files from various data sources which include RDMBS, OLAP cubes, mainframe file systems, web services, APIs, XML, text files and other documents is required.

- Extensive experience creating and implementing ETL processes is required.

- Ability to work with both business and technical users to define and gather reporting/analytics requirements with experience translating business and technical requirements into comprehensive data reporting strategies and analytic solutions is required.

- Ability to work with both business and technical users to define and gather reporting/analytics requirements with experience translating business and technical requirements into comprehensive data reporting strategies and analytic solutions is required.

- Ability to work in a fast paced environment, delivering quality systems in short time frames, is required.

- Excellent verbal and writing skills, along with the ability to develop and present complex material effectively to a variety of audiences are also required.

- Ability to communicate effectively and work with both business and technical users across all levels of the organization is required.

- Proven ability to work collaboratively on project teams, and to work independently with minimal supervision, is required.

- Demonstrated ability to develop and maintain positive, productive working relationships with customers and co-workers while delivering quality systems in short time frames is required.

- Experience with Azure PowerBI and PowerAutomate is nice to have.

- Experience with Microsoft SQL Server and Azure Dataverse is nice to have.

 

Fill the skill matrix below:

Skill

Required/Desired

Amount

Candidate's No. of years of experience

Oracle 12c or greater (hands on)

Required

7

 

Building dataflows using ETL tools

Required

5

 

Data Analysis, Data Profiling, Data Flows and Data Modeling

Required

7

 

Profiling and loading files from data sources which include RDMBS, OLAP cubes, mainframe file systems, web services, APIs, XML, text files, etc.

Required

7

 

Ability to communicate extensively with both business users (all levels of the org) and highly technical specialists.

Required

5

 

Ability to work in a fast paced environment, delivering quality systems in short time frames

Required

5

 

Ability to translate business requests into actionable requirements for building data reporting strategies and analytic solutions.

Required

5

 

Excellent verbal and writing skills, along with the ability to develop and present complex material effectively to a variety of audiences

Required

5

 

Proven ability to work collaboratively on project teams, and to work independently with minimal supervision

Required

5

 

Experience with Azure Dataverse

Highly desired

5

 

Experience with Azure PowerBI and PowerAutomate

Desired

4

 

SQL Server 2012 or greater (hands on)

Desired

3

 

Experience with Azure Synapse Analytics

Nice to have

4