Database Engineer jobs in United States
cer-icon
Apply on Employer Site
company-logo

ALL KNOWN SERVICES · 23 hours ago

Database Engineer

ALL KNOWN SERVICES is seeking a highly experienced Senior Database / Data Engineer to lead and support database migration initiatives from Oracle to PostgreSQL. This role involves designing scalable database solutions, optimizing performance, and contributing to data engineering workloads using Databricks and PySpark.

Staffing & Recruiting
Hiring Manager
John J
linkedin

Responsibilities

Design and develop scalable, high-performance database solutions
Build and optimize SQL queries, stored procedures, and views
Define indexing strategies and data models for performance and reliability
Lead Oracle → PostgreSQL migrations using AWS DMS, Ora2PG , or custom scripts
Perform data mapping, conversion, reconciliation, and validation
Develop and execute migration plans ensuring data integrity and minimal downtime
Develop and optimize Databricks jobs for data processing and reporting
Use Python and PySpark for ETL pipelines and data transformations
Support analytics and reporting needs with performant data pipelines
Perform query optimization and database performance tuning
Troubleshoot production performance issues across Oracle and PostgreSQL
Implement caching, indexing, and optimization strategies
Monitor database health and proactively implement improvements
Automate routine database tasks using scripts and procedures
Provide limited DBA support (~20%) for SQL Server and Oracle

Qualification

Oracle to PostgreSQL migrationPostgreSQLDatabricksPySparkPerformance tuningSQLPL/SQLAWS DMSSQL ServerRDBMS architectureDatabase designIndexing strategiesWorkflow orchestration

Required

12+ years of experience in Oracle, SQL, and PL/SQL development
Proven experience with Oracle to PostgreSQL migration
Strong expertise in PostgreSQL, Oracle, SQL Server
Hands-on experience with AWS DMS and/or Ora2PG
Advanced skills in performance tuning and query optimization
Strong experience with Databricks and PySpark
Solid understanding of RDBMS architecture and database design

Preferred

~20% DBA experience (SQL Server preferred)
Exposure to Oracle DBA activities
Experience working in AWS cloud environments
Familiarity with workflow orchestration and job scheduling tools

Company

ALL KNOWN SERVICES

twitter
company-logo
All Known Services is committed to redefining how organizations hire talent and build technology.

Funding

Current Stage
Early Stage
Company data provided by crunchbase