Database Administrator

• Oracle functions, procedures, triggers, packages using Oracle 11g or newer
• Participate in production implementations working closely with other members of the production support group to ensure the proper transition of system changes into the production environments
• 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 trouble shooting & give consultation to development teams
• Data analysis and debugging with a focus on identifying data quality issues. Provide application troubleshooting support, identifying root causes and implementing permanent resolutions.
• Create & maintain technical documentation including system diagrams & 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, working closely with other members of the production support group to ensure the proper transition of system changes into production environments.

• Bachelor's degree. FOUR (4) additional years of experience is needed in lieu of degree.

• Minimum of Four(4) to Ten(10)years of job-related experience as an DBA.

• Ability to create, modify, and tune SQL queries and PL\SQL code

• Ability to troubleshoot and resolve data, 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.

• 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.

• 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. Candidates with an ACTIVE PUBLIC TRUST or SUITABILITY are preferred.

• Oracle database performance tuning

• Exp with Grants.gov applications.

• Linux/Unix environments and shell scripting

• Knowledge of AWS is a plus

The annual salary range for this position is $85,000.00-$141,000.00. Compensation decisions depend on a wide range of factors, including but not limited to skill sets, experience and training, security clearances, licensure and certifications, and other business and organizational needs.

Guidehouse offers a comprehensive, total rewards package that includes competitive compensation and a flexible benefits package that reflects our commitment to creating a diverse and supportive workplace.

Benefits include:

• Medical, Rx, Dental & Vision Insurance
• Personal and Family Sick Time & Company Paid Holidays
• Parental Leave
• 401(k) Retirement Plan
• Group Term Life and Travel Assistance
• Voluntary Life and AD&D Insurance
• Health Savings Account, Health Care & Dependent Care Flexible Spending Accounts
• Transit and Parking Commuter Benefits
• Short-Term & Long-Term Disability
• Tuition Reimbursement, Personal Development, Certifications & Learning Opportunities
• Employee Referral Program
• Corporate Sponsored Events & Community Outreach
• Care.com annual membership
• Employee Assistance Program
• Supplemental Benefits via Corestream (Critical Care, Hospital Indemnity, Accident Insurance, Legal Assistance and ID theft protection, etc.)
• Position may be eligible for a discretionary variable incentive bonus

Guidehouse is an Equal Opportunity Employer-Protected Veterans, Individuals with Disabilities or any other basis protected by law, ordinance, or regulation.

Guidehouse will consider for employment qualified applicants with criminal histories in a manner consistent with the requirements of applicable law or ordinance including the Fair Chance Ordinance of Los Angeles and San Francisco.