-
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.
-
Travel Required: Up to 10%
-
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, 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. Candidates with an ACTIVE PUBLIC TRUST or SUITABILITY are 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.