Data Warehouse DBA

DBM Global Inc.; Phoenix (AZ); On-site; USD 90,000 - 120,000; Full time

Job summary

DBM Global Inc. is seeking a Database Administrator to contribute to and maintain databases supporting data warehouses, web-based applications, and client/server systems. You will partner with DBAs and developers to build scalable data solutions and ensure performance aligns with SLAs.

Responsibilities include designing data architectures, developing data acquisition strategies, and implementing governance controls while translating business needs into database design and BI outcomes.

Qualifications

• 5-7+ years experience in database/data warehouse development.
• Proven experience can substitute for degree requirement.

Responsibilities

• Collaborate in design of data architectures; translates 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.
• Understands business strategy and cascades 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 the key database performance metrics.

Skills

SQL

Data modeling

Education

Bachelor's degree in Computer Science or related field

Tools

SSIS

SQL Server

Oracle SOA Suite

Job description

As the Database Administrator at DBM Global, you'll be responsible for contributing and maintaining databases in support of data warehouses, web-based applications, as well as client server applications by using requirements analysis and design techniques. Partner with other DBAs and/or Developers to write and maintain databases according to specifications. The Database Administrator will partner with technical groups to ensure that database performance standards adhere to service level agreements set with the enterprise.

Core Responsibilities

• Collaborate in design of data architectures; translates 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.
• Understands business strategy and cascades 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 the key database performance metrics.

Additional Duties & Responsibilities

This job description is not an exclusive or exhaustive list of all job responsibilities and functions that an employee in this position may be asked to perform. Above statements describe the general nature and level of work being performed. Duties and responsibilities can be changed, expanded, reduced, or delegated by management to meet the business needs of the company.

Core Competencies

• Customer Focus - Is dedicated to meeting the expectations and requirements of internal and external customers; gets first-hand customer information and uses it for improvements in products and services; acts with customers in mind; establishes and maintains effective relationships with customers and gains their trust and respect.
• Functional Technical Skills - Has the functional and technical knowledge and skills to do the job at a high level of accomplishment.
• Integrity and Trust - Is widely trusted; is seen as a direct, truthful individual; can present the unvarnished truth in an appropriate and helpful manner; keeps confidences; admits mistakes; doesn't misrepresent him/herself for personal gain.
• Listening - Practices attentive and active listening; has the patience to hear people out; can accurately restate the opinions of others even when he/she disagrees.
• Peer Relationships - Can quickly find common ground and solve problems for the good of all; can represent his/her own interests and yet be fair to other groups; can solve problems with peers with a minimum of noise; is seen as a team player and is cooperative; easily gains trust and support of peers; encourages collaboration; can be candid with peers.
• Planning - Accurately scopes out length and difficulty of tasks and projects; sets objectives and goals; breaks down work into the process steps; develops schedules and task/people assignments; anticipates and adjusts for problems and roadblocks; measures performance against goals; evaluates results.
• Problem Solving - Uses rigorous logic and methods to solve difficult problems with effective solutions; probes all fruitful sources for answers; can see hidden problems; is excellent at honest analysis; looks beyond the obvious and doesn't stop at the first answers.
• Technical Learning - Picks up on technical things quickly; can learn new skills and knowledge; is good at learning new industry, company, product, or technical knowledge—like Internet technology; does well in technical courses and seminars.
• Timely Decision Making - Makes decisions in a timely manner, sometimes with incomplete information and under tight deadlines and pressure; able to make a quick decision.
• Written and Verbal Communications - Is able to write and speak clearly and succinctly in a variety of communication settings and styles; can get messages across that have the desired effect.

Core Technical Competencies

• High level knowledge of SQL
• Advanced experience with ETL (in particular SSIS) and application related integrations
• Knowledge of the design, development and maintenance of various data models and their components.
• Experience with data modeling and schema
• Experience and understanding using 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 using business and system process flow techniques using UML (e.g. Use Case Diagrams, Activity Diagrams, Entity Relationship Diagrams)
• Experience with automating DBA tasks
• Knowledge of Web Service / Web API technology
• Understands BI tools and technologies as well as the optimization of underlying databases.
• Experience of software development lifecycle methodologies (e.g. Waterfall, Iterative, Agile)
• Experience using Oracle SOA Suite is a plus.
• Experience with an ERP implementation 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 requirement).

Software & Technology

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

Work Environment

DBM Global is an Equal Opportunity Employer with and Aff…