Data Architect & Database Developer

We are looking for a dedicated and meticulous data architect/database developer to join an Engineering team. Candidate will be working on a small team with Software and Web Developers, and will be responsible for designing, setting up, analyzing, and maintaining the database architecture for a new product. Additionally, the candidate will be analyzing data inquiry needs, ensuring security of information and organizing the data layout to best retain the information needed and allow for the analytical processing required.

The ideal candidate in this role will be a self-starter, self-reliant, analytically minded, and excellent problem-solver. They will be able to work as effectively independently or as part of a team. Candidate must be flexible and adjust to change quickly and effectively in a fast-paced environment. Candidate will need to take directives and complete them within the time allotted or recognize and report early on that the timeframe is not adequate. Candidate will need to break large daunting tasks into smaller more manageable and achievable chunks and then coordinate the completion of those chunks. Candidate must have the ability to think big, think outside the box and develop creative solutions that meet the objectives while remaining within the company’s framework and capacity.

As a small company it is expected that the candidate is willing wear multiple hats and as needed take on “Extra Duties as Assigned”. These extra duties may include, but are not limited to database administration where they must work with the IT Lead to maintain data backups storage and data integrity, audits and reviews to verify the security of our data and solution. Coding outside of the direct database. Engaging in product design and testing. Beyond the immediate team, the candidate will likely engage with the VP of Engineering, Systems Software Manager, IT Lead and the Software Engineering team.

Duties and Responsibilities

· Identify the requirements for the functionality of the Server

· Work closely with team to determine database structural requirements

· Propose database solutions through system designs

· Define database structure, capabilities, backup, recovery and security specifications

· Install database systems i.e. develop flowcharts, apply optimum access techniques, coordinate installation actions, document installation process

· Facilitate maintenance of database performance

· Identify and resolve production and application problems

· Evaluate and install new releases

· Facilitate training for users

· Provide support by responding to user questions, resolving problems, and coding utilities

· Self-educate on industry updates i.e. read industry publications, maintain personal networks, participate in professional organizations, participate in educational opportunities

Data Architect Requirements and Qualifications

· Bachelor’s degree in computer engineering or related field

· 3-5+ years’ experience in data analysis

· Extensive coding and optimization of queries, triggers, functions, and stored procedures

· Extensive PL/SQL, NoSQL, T-SQL and database coding, performance tuning, and troubleshooting

· Experience with ETL Technologies

· Knowledge of C, C++, Python and Java languages

· Familiarity with SQL and NoSQL DBs, e.g., PostgreSQL, Oracle SQL and NoSQL, Scylla, Apache Cassandra and Redis

· Experience in distributed systems (Preferred)

· Analytical mind, critical thinker, problem-solver

· Meticulous attention to detail

· Solid communication skills, both verbal and written

· Ability to communicate with functional and technical resources

Job Types: Full-time, Contract

Experience:

• ETL Technologies: 5 years (Preferred)
• Extensive coding and optimization of queries, triggers: 5 years (Preferred)
• Data Analytics: 5 years (Preferred)
• PL/SQL, NoSQL, T-SQL and database coding, performance tuning: 5 years (Preferred)

Education:

• High school or equivalent (Preferred)

Contract Length:

• More than 1 year

Contract Renewal:

• Possible

Full Time Opportunity:

• Yes