Data Architect in Dunwoody, GA at HUNTER Technical Resources

Date Posted: 7/11/2019

Job Snapshot

Job Description

Data Architect

Summary

Data Architect - This consultant position provides value by solving business problems through the creation, modification, and maintenance of applications and services related to Microsoft SQL Server, SSIS, BizTalk and other Data Integration systems. This role is for an experienced Data Architect who will work closely with our data integration and application development teams to recommend database structures based on the data storage and retrieval needs within each department. The successful candidate will also submit reports to management that outline the changing data needs of the company and come up with related solutions. The person in this role must be familiar with multiple data integration systems and technologies and be an expert in an at least one of those systems with at least 10 years of experience. Must be able to hit the ground running. 

Top 5 Technical Must Haves:      

• Hands-on and experienced candidate with thorough knowledge of SQLServer and various ETL tools (BizTalk, SSIS, Reporting, etc). We are currently using SQLServer-version 2017. Knowledge of MySQL is a plus.

• Deep understanding of core database and application layer performance tuning in mission critical OLTP application. Review existing setup (indexes, tablespaces, partition, backups, …) and be able to recommend and implement improvements (like moving to parameterized queries).

• Ability to program and debug Stored Procedures, provide ad-hoc queries (SQL), review existing code (PHP) and recommend improvements

• Capable of looking at the entire architecture holistically and provide recommendations to architects and software development manager to utilize core DBMS features (especially new features in version 2017) to improve stability and throughput.  Knowledge about system level configuration of SQL-Server and follow Microsoft best-practices. Review, recommend, and implement improvements to policies and procedures for business continuity.

• Recommend and build archiving and data-warehouse for reporting infrastructure. Knowledge of implementing a bigdata solution is a plus.

Responsibilities

1. Help maintain the integrity and security of the company databases, and work with the application development team to optimize queries for performance and security.

2. Provide insight and justifications into the changing database storage and utilization requirements for the development team and the company and offer suggestions for solutions.

3. Analyze business needs for data storage, performance, cost, security, and accuracy in order to provide solutions for the application development and data integration teams.

a. Design, create, and maintain databases, tables, stored procedures, triggers, and indexes in at least one enterprise-level database such as Microsoft SQL Server, Oracle, or Sybase.

b. Design and maintain SQL Server configurations and understand how to optimize for performance, speed, and security.

c. Experience with ETL solutions utilizing SSIS and BizTalk or other enterprise-level integration tools a must.

d. Experience with open-source technologies and integrated environments a plus.

e. Experience with MySQL/MariaDB a plus.

4. Develop database design and architecture documentation for use by technical staff such as the application development team along with content digestible by management and executive teams.

5. Communicate daily work and manage personal resources using industry standard communication and tracking tools.

a. Manage code using standard versioning software such as SVN, GIT, or MS Team Foundation.

b. Manage development time and progress for each SPRINT using internal SCRUM tools.

c. Experience with JIRA, ServiceNow, and SharePoint for managing time and tasks a plus.

Qualifications and Skills

Bachelor’s Degree in Computer Science or related experience.

10 or more years’ experience in a data analysis, data integration, and data management.

Knowledge of C# or PHP languages, and how to communicate with SQL Server using related technologies.

Ability to work in distributed and complex systems data systems.

Ability to find creative solutions to complex problems.