Welcome page Returning Candidate? Log back in! Oracle & PostgreSQL DBA/Developer Category Information Technology Location : Location US-DC- Clearance Requirements Active Secret Clearance Required Commute Requirements Remote ID 2024-4663 Overview

Oracle & PostgreSQL DBA/Developer

Remote | Local to DMV for Badging Purposes

Active Secret Clearance Required

 

Summary

Our client is an employee and Service-Disabled, Veteran-owned Small Business focused on providing niche technical services. They are a team of experienced cybersecurity professionals with a track record of success in the Federal, Commercial, and Academic workspaces. Additionally, our client designs, builds, operates, and secures scalable cloud and IT infrastructures to meet their customers’ near-term needs and fulfill their long-term requirements.

 

Responsibilities

Our client is seeking an Oracle & PostgreSQL DBA/Developer to support a high-impact, large-scale migration project from on-premises to a cloud-based infrastructure. This role involves database administration, scripting, and development, with a strong focus on working in AWS. The ideal candidate has a robust background in database administration with Oracle and PostgreSQL and is looking to transition or grow in a developer-focused role. Hands-on experience with AWS RDS, database automation, and ETL tools is highly valued.

Manage and support Oracle and PostgreSQL databases in both on-premises and cloud (AWS) environmentsDevelop and implement database automation scripts, primarily using Shell and PythonExecute and optimize database migrations from on-premises to AWS RDSDesign, model, and document database schemas, ensuring data normalization and efficient data structuresMonitor and tune database performance, including query optimization, indexing, and other performance-enhancing techniquesEnsure data security through robust authentication, authorization, encryption, and access control methodsImplement backup and recovery solutions and perform regular performance monitoring and tuningPerform data integration and migration tasks, utilizing ETL tools like SSIS or Oracle Data Integrator where possibleCollaborate with development and operations teams to enhance data handling and support seamless data movement

Requirements

Minimum of 5 years of experience in Database AdministrationProficiency with Oracle 19c (experience with 23c is a plus) and PostgreSQL databasesExperience with AWS RDS and cloud-based database solutionsStrong scripting skills in Shell and Python for database automationProven experience in database design and modeling (E-R diagrams, data normalization)Advanced SQL skills, including query tuning and indexing for performance optimizationFamiliarity with database security protocols, including authentication, authorization, encryption, and access controlHands-on experience in backup/recovery, performance monitoring, and data warehousing practices

Preferred Requirements

Any AWS certifications (highly desired, but not required)Experience with ETL tools such as SSIS or Oracle Data Integrator is a major plusExperience with Oracle Data Integrator or other ETL toolsKnowledge of SQL Server Integration Services (SSIS)Strong understanding of data migration strategies and best practices

Education/Certification Requirements

 None

Clearance Requirements

Applicants selected will be subject to a security investigation and may need to meet eligibility requirements for access to classified information; an active Secret clearance is required; but our client can hold up to a Top Secret Clearance if applicable. Please be aware that onboarding can take 4-6 weeks for this position.
Other DutiesPlease note this job description is not designed to cover or contain a comprehensive listing of activities, duties, or responsibilities that are required of the employee for this job. Duties, responsibilities, and activities may change at any time with or without notice. -------------- About UsNorthern Virginia-based Precision Solutions is an expert in staffing solutions for companies of any size that open the door to new opportunities and seek outstanding talent. We pride ourselves on being versatile enough to tailor our relationships to the needs of each individual client, being agile in the fast-paced marketplace, and being precise in meeting the needs of any company. Equal Opportunity Employer StatementPrecision Solutions is an equal opportunity employer. We prohibit discrimination and harassment of any kind based on race, color, sex, religion, sexual orientation, national origin, disability, genetic information, pregnancy, or any other protected characteristic as outlined by federal, state, or local laws. Options ApplyApplyShareRefer this job to a friendRefer Sorry the Share function is not working properly at this moment. Please refresh the page and try again later. Application FAQs

Software Powered by iCIMS
www.icims.com