1. Home
  2. Remote Jobs
  3. Dba Database Developer Oracle Postgresql Secret Cleared 86cf1f

DBA/Database Developer (Oracle/ PostgreSQL)- Secret Cleared

Job Summary:

We are seeking a skilled and experienced DBA/Database Developer with expertise in Oracle to PostgreSQL migration and a strong background in AWS cloud services. The ideal candidate will play a key role in migrating, optimizing, and managing databases while ensuring high performance, scalability, and reliability. This position requires a deep understanding of database architecture, migration tools, and cloud-based database solutions. This position is fully remote and requires an active Secret clearance or higher.

Responsibilities:

    • Database Migration:
    • Plan, design, and execute Oracle to PostgreSQL migration projects, ensuring minimal downtime and data integrity.
    • Analyze existing Oracle schemas, stored procedures, and triggers to create optimized PostgreSQL equivalents.
    • Leverage tools like AWS Database Migration Service (DMS), ora2pg, or other migration utilities.
    • Database Design and Development:
    • Develop and optimize database schemas, indexes, and queries for PostgreSQL.
    • Write and maintain complex SQL scripts, functions, and stored procedures.
    • Collaborate with development teams to design scalable database solutions for applications.
    • Cloud Integration:
    • Deploy and manage databases in AWS cloud environments, using services like RDS, Aurora, and EC2.
    • Optimize database configurations for performance, cost, and reliability in the cloud.
    • Implement backup, recovery, and disaster recovery solutions in AWS.
    • Performance Tuning and Optimization:
    • Monitor database performance, identify bottlenecks, and implement tuning strategies.
    • Conduct capacity planning and ensure efficient resource utilization.
    • Security and Compliance:
    • Ensure databases meet security and compliance standards, including encryption and access control.
    • Conduct audits and apply patches or updates as needed.
    • Collaboration and Documentation:
    • Work closely with application developers, system administrators, and other stakeholders.
    • Create and maintain documentation for database designs, processes, and migrations.
$120,000 - $145,000 a year
Apply for this job

Latitude

Employment type

Full-Time

Region

North America

Location

United States

Salary range

$120,000 - $145,000

Posted

9 days ago

Similar Jobs