Senior Database Developer

Astor & Sanders

United States

Remote

USD 120,000 - 140,000

Full time

5 days ago

Be an early applicant

Application generator

Stand out for this role — generate a tailored resume and cover letter in about a minute.

Get past ATS filters

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

Senior Database Developer

Astor & Sanders Corporation (Astor) is an award-winning IT solutions provider headquartered in McLean, VA seeking a Senior Database Developer . This is a full-time and remote position.

Astoris looking for an experienced Oracle Database Developer to join our growing team.The ideal candidatewill have progressive experience designing,supportingandmaintainingOracle databases in multi-tiered environments.

Roles & Responsibilities

Manage database migration and database management by conducting data calls to includethe coordination,analysisand gathering efforts from existing data sources.
Develop reports and aggregate application systems attributes such as OS, hardware information, programming languages, technology and license versions, accountmanagementand release schedules.
Design, architect,andplan database solutions to meet the businessneed. Applies comprehensive business processes and functional knowledge in problem resolution. Proposes and defines solutions and standards
Implements PL/SL Programming especially in areas of Views, cursors, Stored Procedures, Normalization, Multiple table queries, Materialized Views, SQL Tuning etc
Develop and modify triggers, packages, functions and stored procedures for data conversions and PL/SQL procedures to create database objects dynamically based on user inputs
Prior experience of working with databases inhigh transaction environments
Develop and implement standards, procedures, and policiesregardingsoftware and applications databases
Installing & upgrading database software and resolving database software problems
Automating database tasks, Health Checkupsthrough the use oftools or via Scripting
Expertisein database performance tuning and application query tuning
Test the system after the migration process as well as the resulting data to find errors
Performance testing and rewriting of production Code/SQL statements & procedures performing badly, identified by database administrators
Additional duties as assigned

Requirements

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

The anticipated salary range for this position is $120,000-$140,000 annually. This is not, however, a guarantee of compensation or salary. Actual compensation will be determined based on factors, including, but not limited to, relevant work experience, candidate skills and education, geographical location, certifications, and business needs, as well as contract provisions regarding labor categories that are specific to the position and could fall outside of this range. This salary range represents Astor’s good-faith estimate of compensation for the position at the time of posting.

Benefits

Astor & Sanders Corporation (www.astor-sanders.com) offers a unique, stimulating and challenging environment that fosters individual growth and rewards performance. Astor & Sanders Corporation ( #Astor ) is an Equal Opportunity Employer.

Some of our competitive benefits include: