Database Administrator at Everest Consultants, Inc. in Portland, OR

Job description

• Job Title: Database Administrator
• Duration: 9-month contract
• Location: Portland, OR (Hybrid)
• Pay Range: $62.51 – $65.85 per hour
• The Database Administrator will analyze inspection and correction data across multiple source systems, databases, and applications to support data conversion and migration into a modernized database environment. The role will research relational database structures, develop source-to-target mappings, document data definitions and relationships, identify data quality issues, and support conversion planning, mock loads, and validation activities. The analyst will collaborate with business and technical teams to ensure data is accurately understood, mapped, and prepared for ingestion.

Responsibilities

• Perform detailed analysis of inspection and correction data across multiple source systems, databases, and applications to understand how data is structured, stored, maintained, and used by the business.
• Research source databases and system tables to identify table and field names, relationships, data types, key values, joins, dependencies, and other information needed to support data conversion and migration.
• Analyze relational database structures and use SQL queries to research, profile, validate, and reconcile data, identify patterns, and investigate data quality issues.
• Develop and maintain clear source-to-target data mappings that align legacy inspection and correction data with the target data model, schema, and ingestion requirements.
• Create and maintain detailed data dictionaries, table inventories, mapping workbooks, schema alignment documentation, conversion specifications, assumptions, and open issue logs.
• Collaborate with business stakeholders, application teams, database administrators, data engineers, testers, and project teams to validate data definitions, clarify requirements, resolve mapping questions, and preserve business meaning during conversion.
• Translate business rules and operational inspection and correction processes into technical data requirements, mapping logic, transformation rules, and validation criteria.
• Identify data gaps, inconsistencies, duplicates, and other quality issues that could affect successful data ingestion, document findings, and recommend remediation steps.
• Support data conversion planning, mock loads, validation activities, and conversion issue resolution to ensure inspection and correction data is accurately prepared for ingestion into the target database.
• Research and document data lineage, table relationships, system dependencies, and system-of-record considerations across legacy applications and business systems.
• Work independently on complex data research and analysis assignments, manage competing priorities, maintain accuracy and attention to detail, and communicate risks, blockers, and unresolved issues in a timely manner.
• Serve as a knowledgeable resource for project team members by explaining source-system data structures, mapping decisions, data lineage, conversion impacts, and technical findings to both technical and nontechnical audiences.

Requirements

• Bachelor's degree in computer science, information systems, data management, engineering, mathematics, business technology, or a related field, or equivalent experience.
• Typically five or more years of experience working with databases, data analysis, data mapping, data conversion, schema analysis, or application data support.
• Strong experience analyzing relational databases, including tables, fields, keys, joins, dependencies, data types, and schema relationships.
• Strong SQL skills for querying, profiling, validating, and reconciling data across source systems.
• Experience creating source-to-target mappings, data dictionaries, table inventories, mapping workbooks, or conversion specifications.
• Experience working across multiple business systems or legacy applications to understand data lineage, operational processes, and system-of-record decisions.
• Working knowledge of data modeling, schema design, data transformation, and data ingestion concepts.
• Ability to translate business processes and operational rules into data requirements, mapping logic, transformation rules, and validation criteria.
• Strong documentation skills, including maintaining mapping documentation, data dictionaries, table inventories, issue logs, and conversion assumptions.
• Advanced attention to detail, analytical thinking, and problem-solving skills, including the ability to investigate complex data issues, trace data lineage, identify patterns, and draw clear conclusions from technical research.
• Strong collaboration and communication skills, with the ability to work effectively with business users, database administrators, developers, data engineers, testers, and project stakeholders and explain technical findings clearly to technical and nontechnical audiences.
• Ability to work independently, follow through on detailed assignments with minimal guidance, manage competing priorities, and raise risks or blockers early.
• Strong relational database analysis skills, including tables, fields, keys, joins, dependencies, and data quality profiling.
• Experience creating source-to-target mappings, data dictionaries, table inventories, and conversion specifications.
• Advanced attention to detail, analytical thinking, and ability to document and resolve complex data lineage and mapping issues.
• Preferred experience with inspection, correction, asset management, work management, field operations, or utility data.
• Preferred experience with Microsoft SQL Server, Oracle, cloud databases, AWS Glue, data integration tools, or reporting and query tools.
• Experience with inspection, correction, asset management, work management, field operations, or utility data.
• Experience with AWS Glue, cloud databases, data integration tools, or reporting and query tools.
• Ability to translate business rules and operational processes into mapping logic, transformation rules, and validation criteria.

Skills

Required

• Strong SQL skills
• Data modeling
• Schema design
• Data transformation
• Data ingestion concepts
• Documentation skills
• Problem-solving skills
• Collaboration and communication skills

Benefits

• The following benefits are offered for this position: medical, dental, & vision insurance, short-term disability, life and AD&D insurance, and a 401(k) retirement plan.