Senior Oracle DB Developer - Remote, Data Warehouse Expert

Astor & Sanders; United States; Remote; USD 120,000 - 140,000; Full time

Benefits offered by this job

PTO & Federal holidays off

Health Insurance

Retirement Plan

Pre-Tax Benefit Programs

Wellness & Work-Life Support

Professional Development

Performance Bonuses

Life and Disability Insurance

Job summary

Astor & Sanders Corporation, headquartered in McLean, VA, is seeking a Senior Database Developer for a full-time remote role. The candidate will design, implement and optimize Oracle databases in multi-tier environments, with strong PL/SQL skills and data warehousing experience.

The role involves migration, performance tuning, and policy development for database standards. A Bachelor’s degree and 7+ years of Oracle experience are required; remote work is available.

Qualifications

• Bachelor’s degree in Computer Science or related discipline.
• 7+ years of experience in database development and support in Oracle environments.
• 7+ years of experience using Oracle.
• Experience with Oracle 19c and cloud database architectures and environments.
• Experience with Data Warehousing technologies.
• Strong understanding of Master Data Management policies including cleansing, normalization and standardization.
• Demonstrated experience with Configuration Management tools.

Responsibilities

• Manage database migration and data collection efforts from existing sources.
• Develop reports and aggregate application system attributes (OS, hardware, languages, licenses, etc.).
• Design, architect and plan database solutions to meet business needs; propose standards.
• Implement PL/SQL programming in views, cursors, stored procedures, normalization, multiple-table queries, materialized views, SQL tuning.
• Develop and modify triggers, packages, functions, and stored procedures for data conversions and PL/SQL procedures.
• Work with high-transaction databases and environments.
• Develop and implement standards, procedures, and policies for databases.
• Install and upgrade database software and resolve problems.
• Automate database tasks and health checks via tools or scripting.
• Performance tuning of databases and application queries.
• Test systems after migration to identify errors; rewrite poorly performing production code.

Skills

Oracle

PL/SQL

SQL

Data Warehousing

Cloud databases

Master Data Management

Education

Bachelor's degree in Computer Science or related discipline

Tools

Oracle 19c

Job description

Astor & Sanders Corporation, headquartered in McLean, VA, is seeking a Senior Database Developer for a full-time remote role. The candidate will design, implement and optimize Oracle databases in multi-tier environments, with strong PL/SQL skills and data warehousing experience.

The role involves migration, performance tuning, and policy development for database standards. A Bachelor’s degree and 7+ years of Oracle experience are required; remote work is available.