Note: The job is a remote job and is open to candidates in USA. Guidehouse is a consulting firm that provides a range of services to clients. They are seeking a Database Administrator who will be responsible for managing and maintaining database environments, ensuring their reliability and security, and participating in production implementations. The role requires strong knowledge of Oracle PL/SQL and SQL, along with the ability to troubleshoot and resolve database performance issues.
Responsibilities
- Strong knowledge and experience in Oracle PL/SQL and SQL
- 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
Skills
- Strong knowledge and experience in Oracle PL/SQL and SQL
- 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
- 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
- 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
- Knowledge with AWS cloud technologies like RDS, Lambda, EC2, Redshift is a plus
- Oracle database performance tuning
- Exp with Grants.gov applications
- Linux/Unix environments and shell scripting
- Knowledge of AWS is a plus
Benefits
- 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
Company Overview