Database Administrator

BEAT

Database Specialist responsible for Oracle databases, ETL solutions, and data architecture. Leading projects with technical expertise in data warehousing and analytics.

Posted 7/18/2026full-timeRemote • Texas • 🇺🇸 United StatesSeniorLeadWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates extensive expertise in Database Design, ETL Solutions, and Business Intelligence, with a strong focus on Oracle and Informatica technologies. Proven ability to lead development teams, manage technical architecture, and implement data warehousing solutions in compliance with security guidelines.

Highest-signal resume keywords

Oracle Database ManagementInformatica ETL DevelopmentBusiness Intelligence SolutionsData Warehousing ArchitecturePL/SQL Programming

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

ETL SolutionsData AnalysisDatabase Performance OptimizationData Modeling TechniquesSQL QueriesPL/SQL Stored ProceduresBusiness ObjectsData Warehouse DesignData Definition Language (DDL)Quality Assurance Processes

Soft Skills

Verbal CommunicationWritten CommunicationClient Relationship DevelopmentProblem SolvingTeam Leadership

Tools & Technologies

InformaticaOracle Enterprise EditionComputer Associates ERwin Data ModelerBusiness ObjectsPowerDesigner

Certifications & Qualifications

Informatica Certification

Industry Keywords

Business IntelligenceData WarehousingAgile MethodologyDISA Security GuidelinesTechnical Architecture

Tech Stack

Tools & technologies

ETLInformaticaOracleSQL

About the role

Key responsibilities & impact

As the Database Specialist, you will act as the primary technical architect operating environment managing and solving some of the toughest challenges on the project.
The replication environment includes two servers running Oracle Enterprise Edition databases in a multi-master replication setup, as well as multiple End User Devices (EUDs) running Oracle Enterprise Edition configured as materialized view sites.
Responsible for creating and maintaining the database installation, update, and configuration scripts, as well as the Procedure Language/Structured Query Language (PL/SQL) packages and procedures used in configuring and performing replication between the mobile portion of the application running on tablet PCs and the central web application, in accordance with DISA security guidelines.
Uses Computer Associates ERwin Data Modeler software to design the database, to generate SQL scripts containing Data Definition Language (DDL) for the database, and to generate the Data Dictionary documentation.
You will also be responsible for providing deep technical expertise in database design, ETL, reporting and analytics.
Serves as the primary point of contact for all development tasks. Provides thought leadership on business intelligence and data warehouse design concepts and leading practices.
Responsible for technical architecture creation, product selection tasks, overall technical strategy for the project, and design of the system infrastructure.
Translate client user requirements into technical architecture vision and implementation plan. Ability to solve complex technical problems, assimilate information rapidly, and work under time constraints.
Analyze business requirements and translate them into functional and high-level technical design specifications. Reviews and updates and data model as required.
Design, develop, document, and deploy solutions to populate the Data Warehouse from source to target. Participate in Daily, Weekly, Monthly, and other technical meetings to provide status or input as needed.
Lead and support Agile status meetings, analyze Systems Change Requests (SCRs), System Incident Reports (SIRs), and Technical Advances (TAs).
Manages development team in executing PMO prioritized change requests through implementation: including identifying the level of effort, estimated timelines, constraints, etc. Assigns PMO priorities to development team. Conducts code walkthroughs on a periodic basis.

Requirements

What you’ll need

Minimum of 10 years’ experience in IT consulting with at least 6 years in Business Intelligence and Data Warehousing.
Experienced practitioner in implementing mid- to large-scale ETL solutions, performing data analysis and profiling, interacting with client management, leading ETL teams, and designing and architecting DW ETL solutions.
INFORMATICA: At least 3 years’ experience in Informatica version 8.x or higher design and development is a must. Informatica certifications desirable.
ORACLE: Experience in database performance optimization techniques, multidimensional database designs, and physical database implementations. In-depth knowledge of BI best practices and data modeling techniques a must.
Capable of writing sophisticated queries and PL/SQL stored procedures.
BUSINESS OBJECTS: Strong background in BO 6.5 and XI. Experience installing and configuring BO, as well as designing and developing Universes and reports.
Experience with AT LEAST ONE OTHER BI OR ETL TOOL (see Desired Elements).
ERWIN or POWERDESIGNER: Experience using one or both data modeling tools from logical design through physical implementation and generation of data definition language (DDL).
Strong verbal/written communication skills.
QA/Testing: expert knowledge of quality processes, ability to recommend and implement improvements to existing quality assurance processes.
Ability to interact with client personnel and develop positive working relationships.

Benefits

Comp & perks

Certifications: CompTIA Security+
Clearance: Active DoD Secret
Flexible work arrangements