Database Administrator - Oracle to PostgreSQL

Sorry, this job was removed at 12:11 p.m. (CST) on Friday, May 23, 2025
Hiring Remotely in United States
Remote
Information Technology
The Role
Description

Ready to Ignite your career and work alongside some of the most innovative and brightest professionals in federal services today? Join us and unleash your potential working in an agile environment alongside the men and women charged with ensuring the success of one of the most important missions in American Government. We’re looking for a skilled Database Administrator (DBA) with deep expertise in migrating enterprise workloads from Oracle to PostgreSQL in cloud and hybrid environments. In this role, you’ll assess and lead database migration efforts, optimize performance in PostgreSQL, and use AWS-native tools to ensure secure and seamless transformation. If you enjoy modernizing legacy systems, solving complex data challenges, and delivering secure and high-performing databases—this is the opportunity for you.

As a Database Administrator you will:

  • Lead the assessment, planning, and execution of Oracle to PostgreSQL migration projects.
  • Perform schema conversion, data mapping, and validation to ensure accurate transformation and integrity.
  • Develop and optimize PostgreSQL databases to meet performance, availability, and security requirements.
  • Use AWS-native services like Database Migration Service (DMS), Schema Conversion Tool (SCT), and RDS PostgreSQL.
  • Collaborate with development and DevSecOps teams to integrate migrated databases into application ecosystems.
  • Implement database security controls aligned with federal compliance standards such as NIST 800-53 and FedRAMP.
  • Develop backup strategies, high availability configurations, and disaster recovery plans for PostgreSQL environments.
  • Document migration procedures, tuning recommendations, and SOPs for operational handover.
  • Support cloud-native and hybrid database configurations aligned with the government’s multi-cloud architecture.
  • Contribute to documenting 'As-Is' and 'To-Be' database architectures and phased migration plans.
  • Assist with System Engineering Management (SEM) artifacts including validation plans and failover testing.
  • Participate in Disaster Recovery planning, documentation, and execution for cloud-based database systems.

Ensure quality assurance and compliance with data availability and integrity throughout migration lifecycle.

Requirements
  • Minimum of 8 years of professional IT experience working with cloud technologies, preferably AWS.
  • Bachelor’s degree in Computer Science, Engineering, or a related field.
  • US Citizenship Required.
  • 2+ years of experience migrating enterprise databases from Oracle to PostgreSQL in cloud or hybrid environments with demonstrable experience in handling large datasets and complex database architectures during the migration process.
  • Hands-on expertise with AWS Database Migration Service (DMS) and Schema Conversion Tool (SCT) with documented examples of past migration projects.
  • Expert command of SQL, PL/pgSQL, and performance tuning techniques in PostgreSQL, including query optimization and indexing strategies specifically for PostgreSQL environment.
  • Scripting skills (e.g., Shell, Python) for automation of migration-related tasks.
  • Familiarity with tools and utilities for data migration like Oracle Data Pump, pg_dump, and third-party tools such as ora2pg, AWS Database Migration Service, or other ETL tools.
  • Experience in setting up test environments and performing migration dry runs.
  • Skills in data validation and reconciliation to ensure data integrity post-migration.
  • Experience with database security hardening, encryption, and auditing.
  • Understanding of federal data security standards including NIST RMF and FedRAMP.
  • Familiarity with CI/CD pipelines, database automation, and Git-based version control.
  • Experience contributing to Disaster Recovery Exercises (DREs) and technical documentation for cloud-based databases.
  • Familiarity with configuration baselines, automated patching, and secure data handling practices.
  • Experience managing or supporting System Security Plans (SSPs) and Authority to Operate (ATO) documentation.

Preferred Qualifications

  • AWS Certified Database – Specialty or Solutions Architect – Associate/Professional.
  • Certified PostgreSQL DBA or Oracle Certified Professional (OCP).
  • Experience with cloud-native PostgreSQL services such as Amazon RDS and Aurora PostgreSQL.
  • Knowledge of legacy Oracle features and how to modernize them in open-source environments.
  • Experience supporting data replication, failover, and recovery scenarios across cloud regions.
  • Experience migrating mission-critical databases to PostgreSQL within federal cloud environments.
  • Understanding of application rationalization strategies and data tiering for Oracle-to-cloud transitions.
Benefits
  • 401(k) with matching and 100% Vested
  • Health Insurance - 3 plans to select from
  • Dental insurance
  • Vision Insurance
  • Health savings account
  • Life insurance
  • Short Term Disability
  • Long Term Disability
  • AD&D
  • Paid time off
  • Professional development assistance
  • Training
  • Tuition reimbursement
  • Flexible schedule
  • Flexible spending account
  • Referral program
  • Paid Legal Plan
  • and more....

Ignite IT is an Equal Employment Opportunity/Affirmative Action Employer. We evaluate qualified applicants without regard to race, color, religion, sex, national origin, disability, Veteran status, sexual orientation, or other protected characteristic. In accordance with EO 13665 Final Rule, Ignite IT will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant.

Applicants selected must be able to possess and maintain a government clearance

US CITIZENSHIP REQUIRED'

Similar Jobs

GRAIL Logo GRAIL

Staff Medical Science Liaison # 4463

Artificial Intelligence • Big Data • Healthtech • Machine Learning • Software • Biotech
Remote or Hybrid
Pennsylvania, USA
918 Employees
159K-211K Annually

GRAIL Logo GRAIL

Consultant

Artificial Intelligence • Big Data • Healthtech • Machine Learning • Software • Biotech
Remote or Hybrid
Minnesota, USA
918 Employees
114K-150K Annually

Dynatrace Logo Dynatrace

Account Manager

Artificial Intelligence • Big Data • Cloud • Information Technology • Software • Big Data Analytics • Automation
Remote or Hybrid
Boston, MA, USA
5200 Employees
128K-160K Annually

Samsara Logo Samsara

Accounts Receivable Specialist

Artificial Intelligence • Cloud • Computer Vision • Hardware • Internet of Things • Software
Easy Apply
Remote or Hybrid
United States
4000 Employees
71K-109K Annually
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: Ashburn, Virginia
41 Employees
Year Founded: 2018

What We Do

Passion and Purpose. We are a start-up borne out of a group of architects and engineers providing solutions that transform with digital breakthroughs.
We Partner - Partnership to us means being all in - on the ground, in the weeds, producing and delivering mission solutions.
We Innovate - driving digital innovation and experimentation to improve decision services for the American people.
We Engage – co-creating to deliver HCD (human centered design) to solve tour customers digital challenges.
We Deliver – and take pride and accountability in everything we do.

We are Ignite IT.

Ignite IT deploys teams that are customer-obsessed, delivering a CX (Customer Experience) renaissance to our Private and Public Sector customers. We combine Commercial BX (Business of Experience) with customer delivery experts to benefit agencies to innovate and improve services and launch new digital solutions. We have built a company foundation dependent on each of our employee’s success, and provide a healthy, engaging, community where learning and knowledge sharing are encouraged. We empower our employees to be bold, continually innovate and propose new ideas to improve processes and services. We engage daily on work that touches millions of people, always focusing on positive impacts and results.

We enable mission services that enable Enterprise companies to succeed in digital transformation, protect Border Agents, deploy the Army Reserve and National Guard, providing decision dominance to make America safer. We apply these digital services across the Private and Public Sectors to include include HHS, DHS, AOUSC and Army. We aim to continually raise the bar for our customers to expect more from their digital services. For more information, visit www.igniteitservices.com

Similar Companies Hiring

Axle Health Thumbnail
Logistics • Information Technology • Healthtech • Artificial Intelligence
Santa Monica, CA
17 Employees
Scrunch AI Thumbnail
Software • SEO • Marketing Tech • Information Technology • Artificial Intelligence
Salt Lake City, Utah
LayerOne Thumbnail
Software • Information Technology • Artificial Intelligence
New York, NY
15 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account