Guidehouse · United States
Join Guidehouse as a Database Administrator to ensure the reliability, scalability, and security of critical Oracle database environments. You’ll design, develop, and maintain automation scripts, troubleshoot performance issues, and collaborate with cross-functional teams to support production implementations. This role demands strong technical expertise in Oracle PL/SQL and SQL, with a focus on optimization and data integrity. Ideal for a proactive, self-motivated professional who thrives in fast-paced, mission-driven environments.
About the Role
You will be responsible for maintaining Oracle database environments, ensuring they follow best practices for reliability, scalability, and security. You’ll participate in production implementations, working closely with other members of the production support group to ensure the proper transition of system changes into production environments.
What You Will Do
Design, develop, and maintain scripts for automation, data processing, and database maintenance and monitoring solutions using scripting languages including PL/SQL, Perl, and shell.
Perform general technical troubleshooting and provide consultation to development teams.
Analyze and debug data with a focus on identifying data quality issues. Provide application troubleshooting support, identifying root causes and implementing permanent resolutions.
Create and maintain technical documentation including system diagrams and operational procedures.
Analyze, troubleshoot, and resolve database and application performance issues, working closely with application, infrastructure, and support teams.
Ensure database environments follow best practices for reliability, scalability, and security.
Participate in production implementations and system change transitions.
What We Are Looking For
Strong knowledge and experience in Oracle PL/SQL and SQL.
Experience with Oracle functions, procedures, triggers, packages using Oracle 11g or newer.
Experience in production implementations and system change transitions.
Ability to create, modify, and tune SQL queries and PL/SQL code.
Ability to troubleshoot and resolve data, system performance issues.
Proficiency in SQL Developer, SQL Loader, and related Oracle tools.
Experience in Oracle performance tuning, including SQL and PL/SQL optimization.
Ability to work effectively in cross-functional teams.
Knowledge of AWS cloud technologies (RDS, Lambda, EC2, Redshift).
Ability to work independently with minimal direction.
Solid understanding of SDLC including Agile and Waterfall methodologies.
Ability to research and resolve complex technical problems in distributed IT environments.
Ability to obtain and maintain Federal or DoD Public Trust.
Nice to Have
Experience with Oracle database performance tuning.
Experience with Grants.gov applications.
Experience with Linux/Unix environments and shell scripting.
Knowledge of AWS.
If you’re passionate about database excellence and enjoy solving complex technical challenges, this is your opportunity to make a meaningful impact. Apply today to join our mission-driven team.