Sign upLog in

PL/SQL Developer

System One

REMOTE, Virginia(remote)

Apply
JOB DETAILS
SKILLS
AWS Lambda, Adjudication, Agile Programming Methodologies, Amazon Elastic Compute Cloud (EC2), Amazon Relational Database Service (RDS), Amazon Web Services (AWS), Analysis Skills, Automation, Best Practices, Cloud Computing, Communication Skills, Computer Science, Cross-Functional, Data Analysis, Data Quality, Database Administration, Database Programming, Database Triggers, Debugging Skills, Identify Issues, Information Technology & Information Systems, Linux Operating System, Management of Information Systems/Technology (MIS), On Call, Onboarding, Operations Processes, Oracle, Oracle 11i, Oracle Database, Oracle PL-SQL, Oracle SQL*Loader, Organizational Skills, Outsourcing, Performance Tuning/Optimization, Perl Programming Language, Presentation/Verbal Skills, Problem Solving Skills, Production Support, Production Systems, Research Skills, Root Cause Analysis, SQL (Structured Query Language), SQL Databases, Scripting (Scripting Languages), Service Delivery, Software Administration, Software Development Lifecycle (SDLC), System Operations, Team Player, Technical Writing, Time Management, United States Citizen, United States Department of Defense (DoD), Unix Operating Systems, Unix Shell Programming, Waterfall Model of Software Development, Writing Skills
LOCATION
REMOTE, Virginia
POSTED
3 days ago
Job Title: PL/SQL Developer

Location: REMOTE, Virginia

Responsibilities
  • Develop and maintain Oracle PL/SQL solutions, including functions, procedures, triggers, and packages using Oracle 11g or newer.
  • Participate in production implementations by partnering with the production support group to ensure correct transition of system changes into production environments.
  • Design, develop, and maintain automation and data-processing scripts, including database maintenance and monitoring solutions using PL/SQL, Perl, and shell.
  • Troubleshoot technical issues and provide consultation to development teams.
  • Perform data analysis and debugging to identify data quality issues, support application troubleshooting, identify root causes, and implement permanent resolutions.
  • Create and maintain technical documentation, including system diagrams and operational procedures.
  • Analyze, troubleshoot, and resolve database and application performance issues in partnership with application, infrastructure, and support teams.
  • Ensure database environments follow best practices for reliability, scalability, and security.
Requirements
  • US Citizen with ability to obtain a public trust.
  • Bachelor's degree in computer science/management information systems or an associated discipline or FOUR (4) additional years of experience.
  • Minimum of SIX (6) years of job-related experience as an Oracle Database Developer.
  • Ability to create, modify, and tune SQL queries and PL/SQL code.
  • Ability to troubleshoot and resolve data and system performance issues.
  • Knowledge with AWS cloud technologies like RDS, Lambda, EC2, Redshift is a plus.
  • Ability to work effectively both independently and within cross-functional teams.
  • May require participation in a 24X7 on-call rotation or overnight deployment.
  • Must be able to OBTAIN and MAINTAIN a Federal or DoD "PUBLIC TRUST"; candidates must obtain approved adjudication of their PUBLIC TRUST prior to onboarding with Guidehouse; ACTIVE PUBLIC TRUST or SUITABILITY preferred.
  • Strong expertise in Oracle performance tuning, including SQL and PL/SQL optimization.
  • In-depth knowledge and hands-on experience with Oracle SQL and PL/SQL, including triggers, procedures, functions, and packages.
  • Proficiency in SQL Developer, SQL Loader, and related Oracle tools.
  • Excellent analytical, organizational, problem-solving, and time-management skills.
  • Strong verbal and written communication and listening skills.
  • Proven ability to work effectively in a team-oriented environment, with strong planning and coordination capabilities.
  • High levels of self-motivation and adaptability, with the ability to meet aggressive deadlines.
  • Ability to work independently with minimal direction.
  • Solid understanding of the software development life cycle (SDLC), including Agile and Waterfall methodologies.
  • Demonstrated ability to research and resolve complex technical problems in a distributed and complex IT environment, collaborating with both local and remote teams.
  • What would be nice to have: Oracle database performance tuning.
  • What would be nice to have: Linux/Unix environments and shell scripting.
  • What would be nice to have: Knowledge of AWS is a plus.
System One, and its subsidiaries including Joulé and Mountain Ltd., are leaders in delivering outsourced services and workforce solutions across North America. We help clients get work done more efficiently and economically, without compromising quality. System One not only serves as a valued partner for our clients, but we offer eligible employees health and welfare benefits coverage options including medical, dental, vision, spending accounts, life insurance, voluntary plans, as well as participation in a 401(k) plan.
System One is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex (including pregnancy, childbirth, or related medical conditions), sexual orientation, gender identity, age, national origin, disability, family care or medical leave status, genetic information, veteran status, marital status, or any other characteristic protected by applicable federal, state, or local law.
#LI-KA1
#M1



Ref: #851-Rockville-S1


About the Company

S

System One

Every day, System One focuses on services and solutions that require a high degree of specialization, in-demand technical skills, and large-scale operational expertise. We are essential partners to those on the front lines of our nation’s most critical infrastructure, technology, and life sciences initiatives. 

Founded more than 40 years ago as a staffing partner to the engineering industry, today System One is a diversified organization operating in over 50 locations and putting more than 9,000 people to work in the United States, Canada, and the United Kingdom.

COMPANY SIZE
2,500 to 4,999 employees
INDUSTRY
Staffing/Employment Agencies
WEBSITE
https://systemone.com

Resume Resources

Free Resume TemplatesFree Resume Builder