Database Administrator - Clarity ETL Admin and Clarity DBA at Tacoma

Job Description

Job PreviewResponsible for implementing production databases and the day to day monitoring and support of client production data.Job Summary:

• Implements and maintains the data plan and develop a reusable data repository supporting all phases of testing a large-scale enterprise system.
• Works with Business Analysts, application teams, and Testers to analyze data requirements to support all phases of testing.
• Determines source of data and designs and implements extract, transformation and load (ETL) processes to populate data plans.
• Creates and maintains documentation and descriptors for data elements / attributes, and other required forms of metadata.
• Creates and/or manipulates data in support of application test efforts.
• Utilizes queries and scripts to mine existing data.
• Creates and/or maintains logical relational data models for subsequent translation into physical database models.
• Works with IT database administration staff to translate logical data models into physical data models.
• Assists with ad-hoc query and report requests.
• Develops and implements back-up and recovery processes
• Develops and ensures database security procedures are in place
• Works with application groups on performance and tuning of database in production systems
• Provides consultation and training to business users and IT developers in the efficient use of data reporting and ad-hoc tools.
• Is familiar with all standards and ensures that all processes follow the data methodology.
• Will require some on-call coverage responsibilities

Job Requirements

Education

• Bachelor of Science degree in Computer Science or related technical field required.

Experience:

• 2 years experience working as a Data or Database Analyst, specifically significant experience working on a large-scale system, which has both online and batch processing components is required.
• 5 years of total IT/database experience required.
• May substitute an equivalent combination of education and experience.
• Experience with translating functional information into data plans.
• Utilizing data analytical skills to create data and validate large-scale test efforts.
• Project experience involvement with application testing lifecycle, methodology and tools.
• Experience in Crystal Reports and Mercury Quality Center / TestDirector a plus.
• Hands-on experience with design and implementation of logical data models
• using ERWIN or comparable data modeling tool.
• Experience in TOAD (or comparable tool), Microsoft Excel, Microsoft Access, UNIX shell scripting.
• Exhibits good communication, interpersonal skills, and ability to work with large, diverse teams.
• Experience installing/maintaining Microsoft SQL 2005/2008 in an enterprise environment.
• Experience installing/maintaining Oracle 10g or newer in a diverse enterprise UNIX environment.
• History of proven database implementation and tuning

Additional Responsibilities

• The DBA will work closely with IT Project Managers, applications teams and QA Testing to implement production data
• Coordinates with users, help desk and application areas to provide level 1and level 2 database supports
• Provide query support to report developers
• Work with change control analyst to implement changes to database systems
• Adheres to and exhibits our core values:
  Reverence: Having a profound spirit of awe and respect for all creation, shaping relationships to self, to one another and to God and acknowledging that we hold in trust all that has been given to us.
  Integrity: Moral wholeness, soundness, uprightness, honesty and sincerity as a basis of trustworthiness.
  Compassion: Feeling with others, being one with others in their sorrows and joys, rooted in the sense of solidarity as members of the human community.
  Excellence: Outstanding achievement, merit, virtue; continually surpassing standards to achieve/maintain quality.
• Maintains confidentiality and protects sensitive data at all times.
• Adheres to organizational and department specific safety standards and guidelines.
• Works collaboratively and supports efforts of team members.
• Demonstrates exceptional customer service and interacts effectively with physicians, patients, residents, visitors, staff and the broader health care community.

Catholic Health Initiatives and its organizations are Equal Opportunity Employers. CBCHI

Shift: 1

Scheduled Hours per 2-week Pay Period: 80

Weekends Required: Occasional

Status: Full Time
Country: USA, State: Washington, City: Tacoma, Company: Catholic Health Initiatives.