MSys Inc. logo

Data Architect - Hybrid

MSys Inc.

Washington, DC · HybridJobSeen 1 day agoSeen in employer's feed 1 day ago

Most applications go out cold — see where you stand first. No sign-up to start.

Watch jobs like this.

At a glance

Compensation
No compensation found
Location
Washington, DCHybrid
Work Authorization
US work authorization required

Olive lists jobs from US employers, including remote roles you can work from the United States.

Requirements

Credentials this posting asks for.

Associate's degree

Job overview

The Data Architect designs, develops, secures, and improves Oracle-based relational and multidimensional data environments. The role supports enterprise applications, data warehouses, and data marts through database development, performance tuning, data integration, backup and recovery, security, and high-availability practices. The position is hybrid in Washington, DC, College Park, GA, Fort Worth, TX, or Des Moines, WA, with telework, and is limited to U.S. citizens.

Skills & qualifications

RequiredNice to have

Skills

Oracle DatabaseSQLPL/SQLStored ProceduresFunctionsPackagesTriggersAutomationRelational Data ModelingMultidimensional Data ModelingQuery OptimizationExecution-Plan AnalysisIndexingPerformance TuningBackup and RecoveryArchivalMigrationContinuity PlanningHigh AvailabilityMonitoringTroubleshootingProduction SupportDatabase SecurityAccess ControlsLeast PrivilegeAuditingData WarehousingMetadataData IntegrationData MartsMicrosoft ExcelMicrosoft WordVerbal CommunicationWritten Communication

Qualifications

Associate Degree3+ Years Relevant ExperienceU.S. Citizenship

Full job description

**** Webcam interview; *** Long term project Linkedin Must Hybrid - Washington, DC / College Park, GA / Fort Worth, TX / Des Moines, WA and telework. **** Due to security reasons only USC ****

Job Description Position Summary

Designs, develops, secures, and improves Oracle-based relational and multidimensional data environments using Oracle SQL and PL/SQL, performance tuning, backup and recovery, security, and high-availability practices.

Key Responsibilities

  • Define, design, develop, and maintain relational and multidimensional Oracle structures supporting enterprise applications, data warehouses, and data marts.

  • Develop and optimize Oracle SQL and PL/SQL queries, procedures, functions, packages, triggers, and automation scripts.

  • Review schemas, indexes, execution plans, queries, and workloads; identify bottlenecks and implement performance improvements.

  • Develop and maintain data acquisition, integration, migration, archival, backup, recovery, and continuity strategies.

  • Apply access controls, least privilege, secure coding, auditing, and protection of sensitive information.

  • Support high availability, production readiness, monitoring, troubleshooting, standards, metadata, documentation, and continuous improvement across test and production environments.

Required Skills

  • Oracle Database, SQL, and PL/SQL

  • Stored procedures, functions, packages, triggers, and automation

  • Relational and multidimensional data modeling

  • Query optimization, execution-plan analysis, indexing, and performance tuning

  • Backup, recovery, archival, migration, and continuity planning

  • High availability, monitoring, troubleshooting, and production support

  • Database security, access controls, least privilege, and auditing

  • Data warehousing, metadata, integration, and data marts

Education and Experience

At least 3 years of relevant experience with an Associate degree. Experience must include Oracle SQL and PL/SQL development, database design, automation, performance tuning, backup and recovery, security, high availability, data integration, and support of test or production database environments.

Additional Requirements

  • Microsoft Excel and Microsoft Word proficiency.

  • Excellent verbal and written communication skills.

  • Potential overtime, weekend work, and travel; no on-call requirement.

  • No separately identified nice-to-have skills.

Similar jobs, posted recently

Open roles like this one, listed in the last 30 days.

You've read the whole posting — now see how you match it.