Oracle SQL Developer

JOB SUMMARY

Covalent Solutions (Covalent) is seeking a mission driven, highly motivated and collaborative Oracle SQL Developer who is truly excited about building great products to support one of our clients at the National Institutes of Health (NIH). As an Oracle SQL Developer , you will apply your skills to support development and maintenance of Oracle databases that support .NET applications. We are looking for a candidate who thrives in a mission-driven organization.

This opportunity is full-time with Covalent and is on-site in Bethesda, Maryland.

DUTIES AND RESPONSIBILITIES include, but are not limited to:

• Develop, modify, and optimize Oracle database packages, stored procedures, and piped functions to support .NET applications.
• Manage and configure Oracle Database Scheduler to automate jobs and send emails from Oracle databases.
• Analyze existing database code to enhance performance, resolve bugs, and maintain functionality.
• Collaborate with the DBA and .NET development teams to integrate new features and optimize database operations.
• Ensure efficient database operations by optimizing query performance, ensuring data integrity, and troubleshooting database-related issues.
• Serve as a backup Oracle DBA, assisting with DBA tasks as needed.
• Create, modify, and optimize complex SQL queries, triggers, and views for business applications.
• Provide technical guidance to developers for integrating .NET applications with Oracle packages and piped functions.
• Document database structures, changes, and programming efforts to ensure smooth knowledge transfer.
• Assist in the design and implementation of database partitioning strategies.
• Participate in code reviews, performance tuning, and best practice improvements.

QUALIFICATIONS

Education

• Bachelor’s or Master’s in Information Technology, Computer Science, Computer Engineering or Electrical Engineering
• Desired certifications.
• Oracle Database Program with PL/SQL
• Oracle Database Administration I
• Oracle Database SQL
• Microsoft Power Platform Developer Associate
• Microsoft Azure Developer

Work Experience

• 2+ Experience with Agile methodology.
• 2+ years of the following
• Working with Oracle databases
• Managing/configuring Oracle Database Scheduler
• Develop/modify/optimize Oracle database packages/stored procedures/piped functions to support .NET applications.
• Basic Oracle DBA duties e.g backups
• SQL skills for Oracle database design, querying, and optimization.
• Database design. Strong knowledge of database schema design, normalization, and indexing strategies.
• Oracle DB performance tuning. Experience with database performance tuning, optimization, and troubleshooting.
• Backup and Recovery. Solid knowledge in Oracle database backup, recovery, and disaster recovery planning.
• 1+ years of working knowledge of integration Oracle DBs with Microsoft .NET applications

COMPETENCIES

Professionalism:

• Highly-developed database management skills.
• Sharp eye for detail.
• Proven ability to manage multiple tasks concurrently and in different phases of work at the same time. Flexibility and adaptability to perform in a fast paced and dynamic environment. Context-switching does not bother you.
• Effectively collaborates and influences people at all levels in the organization through strong interpersonal and communication skills.
• Highly organized with strong time-management skills.
• Ability to manage conflict and drive resolution.
• Focused on results, proactive, service oriented
• Can focus on both high level and detail level, knowing which is appropriate for the situation.
• Ability to self-direct and manage ambiguity.
• Ability to take in a lot of disparate information and find common themes, recommend clear paths forward and iterate.
• Motivated by professional rather than personal concerns.
• Show persistence when faced with difficult problems or challenges.
• Naturally curious about things you don't understand and actively look for opportunities to grow and learn from those around you.

Communication:

• Actively participate in meetings and be willing to advocate for what you believe in. Provide thoughtful, constructive review of others’ work, knowing that everyone is working towards the same objective.
• Superior written and verbal communication skills. You can always articulate the "why" behind your solutions.
• Listen to others, correctly interpret messages from others and respond appropriately.
• Ask questions to clarify, and exhibit interest in having two-way communication.
• Tailor language, tone, style and format to match the audience.
• Demonstrate openness in sharing information and keeping people informed.
• Speak intelligently about a wide variety of topics but know when to say, "I don't know."

Teamwork:

• Work collaboratively with colleagues to achieve organizational goals.
• Place team agenda before personal agenda.
• Support and act in accordance with the final group decision, even when such decisions may not entirely reflect your own position.
• Share credit for team accomplishments and accept joint responsibility for team shortcomings.

Accountability:

• Take ownership of all responsibilities and honor commitments.
• Deliver outputs for which you have responsibility within prescribed time, cost and quality standards.
• Operate in compliance with organizational regulations and rules.
• Take personal responsibility for your own shortcomings, where applicable.