Data Warehouse DBA

Dbm Global; Phoenix (AZ); On-site; USD 100,000 - 140,000; Full time

Job summary

DBM Global invites a seasoned database and data warehouse developer to join our Phoenix headquarters. You will design data architectures, develop and maintain data models, write advanced SQL scripts, and collaborate with DBAs and developers to optimize data integration and governance.

We seek 5–7+ years of experience, a Bachelor’s degree in CS or related field, and strong knowledge of SSIS, SQL Server, and data modeling.

Qualifications

• Bachelor's degree in Computer Science or related field required or proven experience in lieu of degree.
• 5–7+ years experience in database/data warehouse development.
• Proficiency in SQL Server and ETL tooling (SSIS).
• Experience with data modeling and schema design.

Responsibilities

• Collaborate in design of data architectures; translate data so that it can be read by various types of computer systems.
• Collaborate in designs and building of databases used with data architectures.
• Collaborate in development of strategies for data acquisition.
• Partner with development teams and DBAs to understand data management and governance protocols; manage information lifecycle; design integration controls.
• Understand business strategy and translate BI needs to the database level.
• Maintain advanced models and logical database designs.
• Write and maintain advanced SQL scripts.
• Analyze and report the performance of database operations against key metrics.

Skills

Customer Focus

Functional Technical Skills

Integrity and Trust

Listening

Peer Relationships

Planning

Problem Solving

Technical Learning

Timely Decision Making

Written and Verbal Communications

Education

Bachelor's degree in Computer Science or related field

Tools

SQL Server

SSIS

Oracle SOA Suite

Job description

Job Details

Job Location: DBMG Headquarters - Phoenix, AZ 85016

Responsibilities

• Collaborate in design of data architectures; translate data so that it can be read by various types of computer systems.
• Collaborate in designs and building of databases that are used in relation with data architectures.
• Collaborate in the development of strategies for data acquisition.
• Partner with development teams and DBAs to understand data management and governance protocols, manage the information lifecycle, design infrastructure and data integration controls.
• Understand business strategy and cascade business intelligence needs to the database level.
• Maintain advanced models and logical database designs.
• Write and maintain advanced SQL scripts.
• Analyze and report the performance of database operations against key database performance metrics.

Core Competencies

• Customer Focus – dedicated to meeting customers’ expectations and requirements.
• Functional Technical Skills – possess high-level knowledge and skills to perform the job at a high level of accomplishment.
• Integrity and Trust – trustworthy, truthful, keeps confidences, admits mistakes.
• Listening – practices attentive and active listening.
• Peer Relationships – collaborative, fair, and supportive of colleagues.
• Planning – scopes projects, sets objectives, develops schedules, measures performance.
• Problem Solving – uses rigorous logic to solve difficult problems.
• Technical Learning – quickly learns new technical skills and knowledge.
• Timely Decision Making – makes decisions under tight deadlines and pressure.
• Written and Verbal Communications – writes and speaks clearly and succinctly.

Core Technical Competencies

• High level knowledge of SQL.
• Advanced experience with ETL (in particular SSIS) and application-related integrations.
• Knowledge of design, development and maintenance of various data models and their components.
• Experience with data modeling and schema.
• Experience and understanding of common programming design patterns and best practices.
• Ability to debug and troubleshoot issues.
• Ability to translate business requirements into system functional and non‑functional solutions.
• Experience with business and system process flow techniques using UML (Use Case Diagrams, Activity Diagrams, Entity Relationship Diagrams).
• Experience with automating DBA tasks.
• Knowledge of Web Service / Web API technology.
• Understanding of BI tools and technologies and optimization of underlying databases.
• Experience with software development lifecycle methodologies (Waterfall, Iterative, Agile).
• Experience using Oracle SOA Suite is a plus.
• Experience with an ERP implementation is a plus.

Work Experience

5–7+ years experience in database/data warehouse development.

Education / Training

• Bachelor’s degree in Computer Science or related field required (Proven experience can substitute for degree).

Software & Technology

• SQL Server
• SSIS
• Oracle SOA Suite (Desirable)

Work Environment

DBM Global is an Equal Opportunity Employer with an Afficategoryitional Action Plan.

Qualifications

See above for required experience, education, and technical competencies.