Database Architect

US-FL-DME - Jacksonville
Type
Regular Full-Time

Mission

POSITION SUMMARY:

Design strategies for enterprise database systems and set standards for operations, programming, and security. Design and construct large relational and NoSQL databases. Integrate new systems with existing warehouse structure and refine system performance and functionality.

 

 

SCOPE OF THE POSITION:

Position reports to Development Manager.

 

The incumbent will be expected to work independently using technical judgment.

Position 80s

ESSENTIAL DUTIES & RESPONSIBILITIES:

  • Develop and document database architectures (relational and NoSQL).
  • Develop database architectural strategies at the modeling, design and implementation stages to address business or industry requirements.
  • Collaborate with system architects, software architects, design analysts, and others to understand business or industry requirements.
  • Create and enforce database development standards.
  • Demonstrate database technical functionality, such as performance, security and reliability.
  • Design database applications, such as interfaces, data transfer mechanisms, global temporary tables, data partitions, and function-based indexes to enable efficient access of the generic database structure.
  • Design databases to support business applications, ensuring system scalability, security, performance and reliability.
  • Develop data models for applications, metadata tables, views or related database structures.
  • Develop load-balancing processes to eliminate down time for backup processes.
  • Develop or maintain archived procedures, procedural codes, or queries for applications.

 

Other duties may be assigned.

Qualifications

JOB SPECIFICATIONS

Any equivalent combination of education and experience which provides the applicant with the knowledge, skills, and abilities required to perform the job will be considered.

 

Education: 

Bachelor’s Degree in Computer Science / Management Information Systems, or equivalent work experience.

 

 

Experience: 

Minimum 6 years experience.

 

 

Competencies: 

To perform the job successfully, an individual should demonstrate the following competencies:

 

Knowledge of:

  • Design and development of large database systems (20TB+)
  • Database architecture and administration (relational and NoSQL)

 

Skills:

  • Microsoft SQL Server 2008/2012/2014/2016
  • Detail oriented
  • Strong T-SQL development
  • Query optimization and performance tuning
  • SSIS and ETL processes
  • SSAS
  • Experience with Hadoop, Machine Learning, Python and R is a plus

 

Ability to:

  • Develop, design, or create new applications, systems, or products
  • Optimize queries to perform on large databases
  • Review and improve execution plans
  • Troubleshoots issues and resolves errors
  • Effectively communicate ideas
  • Multi-task, prioritize, coordinate projects and meet simultaneous deadlines

 

 

WORK ENVIRONMENT

The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

 

Normal office conditions.   The noise level in the work environment is usually moderate.

 

PHYSICAL REQUIREMENTS

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

 

The position requires telephone use and personal computer use.  Involves light physical effort including sitting, standing, and walking.  The position regularly requires the incumbent to talk and hear. The employee is occasionally required to use hands to finger, handle, or feel; reach with hands and arms; climb or balance and stoop, kneel, crouch, or crawl. The employee must occasionally lift and/or move up to 10 pounds. Specific vision abilities required by this job include close vision, color vision and ability to adjust focus.

Options

Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
Share on your newsfeed