Today
Secret
Mid Level Career (5+ yrs experience)
$125,000 - $150,000
No Traveling
IT - Database
Remote/Hybrid•McLean, VA (On/Off-Site)
Stored Procedures DBA
Remote | (Must pick up PIV in McLean, VA)
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
We are seeking a skilled Stored Procedures DBA with expertise in Oracle and PostgreSQL to support database development, optimization, and cloud integration. This role focuses on writing, managing, and optimizing stored procedures, ensuring seamless data migration and synchronization between on-prem and cloud environments. The ideal candidate will have a strong background in database performance tuning, PL/SQL, and cloud-based database solutions.
- Develop, optimize, and maintain stored procedures in Oracle (PL/SQL) and PostgreSQL (PL/pgSQL).
- Design and implement efficient database structures, indexing strategies, and performance tuning techniques.
- Support data migration and replication efforts between on-prem databases and cloud environments.
- Collaborate with development teams to ensure efficient database interactions and query performance.
Implement and maintain database security best practices, including access controls and encryption.
- Optimize ETL processes for efficient data movement to cloud platforms such as AWS RDS, Azure Database, or Google Cloud SQL.
- Monitor and troubleshoot database performance issues, ensuring high availability and minimal downtime.
- Develop backup, recovery, and disaster recovery strategies for cloud-integrated databases.
- Work closely with cloud engineers to integrate database solutions into cloud-based applications.
- Document database architectures, stored procedures, and performance tuning best practices.
Requirements
- 5+ years of experience as a Database Administrator (DBA) with a focus on stored procedures in Oracle and PostgreSQL.
- Strong expertise in PL/SQL (Oracle) and PL/pgSQL (PostgreSQL) for stored procedure development.
- Experience with cloud-based databases (AWS RDS, Azure Database for PostgreSQL/Oracle, Google Cloud SQL).
- Hands-on experience in performance tuning, indexing, and query optimization.
- Strong knowledge of database replication, backup, and disaster recovery strategies.
- Experience integrating on-prem databases with cloud environments.
- Familiarity with database security best practices and compliance standards.
- Ability to troubleshoot complex database issues and optimize query performance.
- Strong scripting skills for automation (Python, Bash, or SQL scripting).
- Excellent communication and collaboration skills to work with development and cloud teams.
Preferred Qualifications
- Experience with Oracle GoldenGate or AWS DMS for database replication.
- Familiarity with Kubernetes, Docker, or CI/CD pipelines for cloud database deployments.
- Certifications such as Oracle Certified DBA, AWS Certified Database Specialty, or PostgreSQL Professional Certification
- Experience working in federal or highly regulated environments.
Education/Certification Requirements
- There are no education requirements for this position
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. Please be aware that onboarding can take 4-6 weeks for this position.
Other Duties
- Please 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 Us
Northern 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 Statement
Precision 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.
Remote | (Must pick up PIV in McLean, VA)
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
We are seeking a skilled Stored Procedures DBA with expertise in Oracle and PostgreSQL to support database development, optimization, and cloud integration. This role focuses on writing, managing, and optimizing stored procedures, ensuring seamless data migration and synchronization between on-prem and cloud environments. The ideal candidate will have a strong background in database performance tuning, PL/SQL, and cloud-based database solutions.
- Develop, optimize, and maintain stored procedures in Oracle (PL/SQL) and PostgreSQL (PL/pgSQL).
- Design and implement efficient database structures, indexing strategies, and performance tuning techniques.
- Support data migration and replication efforts between on-prem databases and cloud environments.
- Collaborate with development teams to ensure efficient database interactions and query performance.
Implement and maintain database security best practices, including access controls and encryption.
- Optimize ETL processes for efficient data movement to cloud platforms such as AWS RDS, Azure Database, or Google Cloud SQL.
- Monitor and troubleshoot database performance issues, ensuring high availability and minimal downtime.
- Develop backup, recovery, and disaster recovery strategies for cloud-integrated databases.
- Work closely with cloud engineers to integrate database solutions into cloud-based applications.
- Document database architectures, stored procedures, and performance tuning best practices.
Requirements
- 5+ years of experience as a Database Administrator (DBA) with a focus on stored procedures in Oracle and PostgreSQL.
- Strong expertise in PL/SQL (Oracle) and PL/pgSQL (PostgreSQL) for stored procedure development.
- Experience with cloud-based databases (AWS RDS, Azure Database for PostgreSQL/Oracle, Google Cloud SQL).
- Hands-on experience in performance tuning, indexing, and query optimization.
- Strong knowledge of database replication, backup, and disaster recovery strategies.
- Experience integrating on-prem databases with cloud environments.
- Familiarity with database security best practices and compliance standards.
- Ability to troubleshoot complex database issues and optimize query performance.
- Strong scripting skills for automation (Python, Bash, or SQL scripting).
- Excellent communication and collaboration skills to work with development and cloud teams.
Preferred Qualifications
- Experience with Oracle GoldenGate or AWS DMS for database replication.
- Familiarity with Kubernetes, Docker, or CI/CD pipelines for cloud database deployments.
- Certifications such as Oracle Certified DBA, AWS Certified Database Specialty, or PostgreSQL Professional Certification
- Experience working in federal or highly regulated environments.
Education/Certification Requirements
- There are no education requirements for this position
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. Please be aware that onboarding can take 4-6 weeks for this position.
Other Duties
- Please 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 Us
Northern 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 Statement
Precision 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.
group id: 10501259
