Solution Architect (Backend) IV

Company: Apex Systems, Inc
Location: Bellevue
Posted on: February 16, 2020

Job Description:

Job Description Job : 1047311 POC: Joseph Ghio Phone: (425) 278-0083 Email: jghioapexsystems.com Job Title: Data Warehouse Solution Architect Description: The Data Warehouse Solutions Architect is responsible for all activities related to the database system administration, architecture, data modeling, design and development of the Teradata Data Warehouse environment. This individual will translate complex business requirements into scalable technical solutions, provide comprehensive technical expertise in database technologies, determine project scope, and liaise with hardware vendors, business analysts, system administrators, and BI/application developers. We are seeking a motivated self-starter who must be able to work well both independently and with a project team to coordinate database system and infrastructure development. Responsibilities: Implement and maintain database security, create and maintain users/roles, and assign privileges. Capacity planning for growth to support current and future needs. Identify key thresholds and bottle necks which could impact system performance. Optimize and performance tune queries. Establish and maintain sound backup and disaster recovery policies and procedures. Prepare detailed ETL specifications to design, code and test all SQL/BTEQ scripts and utilities. Database design modeling and implementation to meet business objectives and the needs of BI/application enhancements and other project deliverables. Project planning, estimating, approach definition and implementation planning. --- Identify and recommend alternative solutions. Maintain awareness of new developments in industry and processes. Establish quality processes and standards to deliver stable and reliable solutions. Participate in after-hours support rotation and perform duties in the data centers to support system upgrades or hardware problem resolutions. Ability to install, configure and upgrade Teradata server hardware, software, and related products Qualifications: Minimum 5-7 years experience as a DBA or similar role working with Teradata databases. Teradata Certified Master certification a plus. UNIX shell scripting, Teradata utilities experience required. System administration for AIX, Linux SuSe, and NCR MPRAS a plus. MS/SQL Server, Oracle database knowledge a plus Windows developer experience a plus. C++, Java, VB, or .NET coding a plus. Experience with MicroStrategy a plus. CRM experience a plus. ETL/ELT tool knowledge required. Control-M job automation tool experience preferred. Experience with retail environment is strongly preferred. Bachelor' s degree in Information Systems, Computer Science or equivalent course work/job experience. ADDITIONAL SKILLS: Advanced analytical and problem solving skills Strong PC skills Strong organizational, verbal and written communication skills Superior customer service skills Strong interpersonal skills Team player --- Attention to detail --- Ability to interface with all levels of staff --- Multi-tasking skills --- Must be flexible and able to work in a fast-paced environment --- Consistent delivery of results Excellent data architect skills --- Performance tuning of Teradata database systems --- Perform database loads, backups and recoveries using Fastload, Multiload, ARC, NetVault, and NetBackup --- Understanding of data modeling and use of modeling tools EEO Employer Apex Systems is an equal opportunity employer. We do not discriminate or allow discrimination on the basis of race, color, religion, creed, sex (including pregnancy, childbirth, breastfeeding, or related medical conditions), age, sexual orientation, gender identity, national origin, ancestry, citizenship, genetic information, registered domestic partner status, marital status, disability, status as a crime victim, protected veteran status, political affiliation, union membership, or any other characteristic protected by law. Apex will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable law. If you have visited our website in search of information on employment opportunities or to apply for a position, and you require an accommodation in using our website for a search or application, please contact our Employee Services Department at 844-463-6178. - provided by Dice

Keywords: Apex Systems, Inc, Seattle , Solution Architect (Backend) IV, Other , Bellevue, Washington