Data Architect

Atlanta, GA 30346

Posted: 07/10/2019 Employment Type: Contract Category: Architect Job Number: 52985

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.

 

           

                 
Apply Online
Apply with LinkedIn Apply with Facebook Apply with Twitter

Send an email reminder to:

Share This Job:

Related Jobs:

Login to save this search and get notified of similar positions.

Posted

  HUNTER Technical Resources Celebrates its 20thAnniversary ATLANTA, GA HUNTER Technical Resources LLC is proud to announce its 20th anniversary as a leading IT staffing and project solutions provider. The company has blossomed from the original dreams of its Georgia Tech founders, growing from a regional company into a national resource for recruiting… Read more »

Posted

IT Staffing

HUNTER Expands Professional Services Offerings with Addition of Patti Dismukes LEADER IN IT RECRUITING TO GROW PROFESSIONAL SERVICES PARTNERSHIP   ATLANTA, GA September 2016 Atlanta-based HUNTER Technical Resources, a leading provider of IT recruiting and staffing services, announces the hiring of Patti Dismukes as Vice President of Professional Services. Patti will grow HUNTER s Professional… Read more »

Posted

Recruiter Quote

What should you expect from your partnership with a recruiter?   CONTACTS – Recruiters are immersed in the hiring process day-in and day-out. They have cultivated relationships with numerous Hiring Managers at major companies and their sole purpose is to match the right candidate with the right role. Partnering with a recruiter makes sure your… Read more »

Posted

IT Staffing and Recruiting

When it s time to navigate a job search choose to partner with an EXPERT! A recruiter or headhunter is someone who spends their days and nights searching for quality candidates in order to create a pipeline of individuals skilled and ready to step in to their next role. As experts at building relationships, recruiters create… Read more »

Posted

New headquarters for IT staffing & recruiting firm

ATLANTA, GA December 15, 2015 Atlanta-based HUNTER Technical Resources, LLC (HUNTER) a leading provider of IT recruiting and staffing services, announces its Atlanta headquarters relocation and expansion. HUNTER s headquarters will move to Glenridge Highlands One, a class A office space located along the bustling GA 400 corridor inside of I-285. The new address… Read more »

Posted

Leader in IT recruiting to help companies meet staffing needs with top talent. ATLANTA, GA September 30, 2015 Atlanta-based HUNTER Technical Resources, a leading provider of IT recruiting and staffing services, announces its expansion into Dallas/Ft. Worth with a regional office to serve the region s growing IT industry. This expansion strategically positions HUNTER to… Read more »

Posted

Atlanta, GA September 16, 2015 – Clint Bailey, Managing Partner of HUNTER Technical Resources, LLC (HUNTER), a leading provider of IT recruiting and staffing services, was honored on September 12, when TiE Atlanta announced the rankings of the 2015 TiE Atlanta Top Entrepreneurs at the TiECON Southeast Conference in Atlanta. This recognition honors company… Read more »

Posted

ATLANTA, GA April 14, 2015 Atlanta-based HUNTER Technical Resources, a leading provider of IT recruiting and staffing services, announces its expansion into Austin with the opening of a regional office to serve the area s growing IT industry. This expansion strategically positions HUNTER to better serve new and existing clients throughout Texas and the Southwestern… Read more »

Posted

ATLANTA, GA December 1, 2014 Atlanta-based HUNTER Technical Resources, a leading provider of IT recruiting and staffing services, has announced the expansion of their regional office located in Denver, CO. In response to continued strength in the information technology job market, HUNTER is growing their U.S. footprint to better serve their existing Denver, West… Read more »