Data Architect in Alpharetta, GA at HUNTER Technical Resources

Date Posted: 2/17/2020

Job Snapshot

Job Description


We are looking for a Data Architect in the Alpharetta, GA area. 

The Data Architect will focus on data modeling and design of relational and noSQL databases to support a  product redesign. The candidate will be building POC' s in different technology to assess best solution, such as Hadoop, Mongo, Cloud solutions, and relational databases, or a combination of them.

Responsibilities:
* Review and understand high level requirements of the new product, and drive data requirements specifications.
* Produce data models from scratch based on business requirements (relational, NoSQL, Hadoop).
* Compare different tools and technology and determine where they fit.
* Review and assess existing enterprise data-driven applications, to support new features, performance improvements, upgrades, and ongoing maintenance
* Analyze large, complex systems to determine performance bottlenecks, application bugs, and opportunities to improve efficiency
* Capture and analyze database activity to identify improvements in indexing, file structure, maintenance processes, and query performance
* Plan and conduct database architecture assessments that examine DBMS and database configuration and performance
* Identify areas of instability and deviations from best practices with database components
* Participate in performance, load, and stress testing, and remediation of issues identified
* Lead efforts to design, implement, and support enterprise scale applications that perform extract/transform/load (ETL) operations with external data sources and SQL Server
* Participate in all aspects of the application lifecycle: requirements analysis & definition, system design, implementation, testing, deployment, and maintenance
* Participate in activities that ensure the successful use of these systems including: developing documentation, test scripts, and training materials
* Participate in security architecture reviews of large enterprise systems
* Hands on development of stored procedures

Required skills:
* MS/BS degree in a computer science field or related discipline is strongly preferred
* Minimum seven years of SQL Server RDBMS designs, development, implementations and operations
* Minimum two years of non relational data stores like Mongo, and Hadoop
* Strong experience development data models
* Experience working with Database Performance tools and monitoring
* Minimum five years of experience writing procedures and packages 
* Minimum five years of database development
* Strong experience with designing and optimizing data processing platforms including performance monitoring, tuning, etc.
* Experience creation data models (OLTP/ STAR Schema)
* Proven track record showing the ability to influence, drive change and make sound decisions to support the business
* Be a quick learner, self-starter with a strong sense of ownership to learn and promote new technologies or ways of doing