[Hiring] Oracle and PostgreSQL Developer @Revolutional, LLC

Role Description

We are seeking an Oracle and PostgreSQL Developer who will be responsible for the design, development, implementation, and maintenance of database solutions using both Oracle and PostgreSQL platforms. The role involves working closely with application developers, business analysts, and system administrators to ensure data integrity, performance, and security across multiple database environments.

• Design, develop, and maintain database objects (tables, views, indexes, stored procedures, functions, triggers) in both Oracle and PostgreSQL environments.
• Write efficient, well-documented SQL and PL/SQL (Oracle) and PL/pgSQL (PostgreSQL) code to support application requirements.
• Perform data modeling, database normalization, and schema design for new and existing applications.
• Optimize and tune database queries and overall database performance.
• Develop and maintain ETL processes for data extraction, transformation, and loading.
• Troubleshoot and resolve database-related issues, ensuring high availability and reliability.
• Collaborate with application developers and business stakeholders to gather requirements and translate them into technical solutions.
• Document database structures, processes, and procedures.
• Monitor database health, usage, and capacity, and recommend improvements as needed.
• Stay current with industry best practices and emerging technologies related to Oracle and PostgreSQL.

Qualifications

• U.S. Citizenship is required with an active DHS Public Trust clearance.
• Bachelor’s degree in Computer Science, Information Systems, or a related field (or equivalent experience).
• 3+ years of hands-on experience with Oracle database development (SQL, PL/SQL).
• 2+ years of hands-on experience with PostgreSQL development (SQL, PL/pgSQL).
• Strong understanding of relational database concepts, data modeling, and normalization.
• Familiarity with database administration tasks, including installation, configuration, backup, recovery, and security.
• Proficiency with database development tools (e.g., Oracle SQL Developer, TOAD, pgAdmin, psql).
• Experience with performance tuning and query optimization in both Oracle and PostgreSQL.
• Familiarity with database migration and integration techniques between Oracle and PostgreSQL.
• Experience with version control systems (e.g., Git).

Requirements

• Experience with cloud-based database solutions (e.g., AWS RDS Oracle and PostgreSQL).
• Knowledge of additional programming languages (e.g., Java, Python).
• Experience with CI/CD pipelines and DevOps practices for database deployments.
• Familiarity with data warehousing concepts and tools.
• Strong analytical and problem-solving skills.
• Excellent verbal and written communication skills.
• Ability to work independently and as part of a team.
• Strong attention to detail and organizational skills.
• Ability to manage multiple tasks and priorities effectively.

Benefits

• Traditional and HSA-eligible medical insurance plans.
• 100% employer-paid dental and vision insurance options.
• 100% employer-sponsored STD, LTD, and life insurance.
• 5% 401(k) company matching.
• Flexible schedules and teleworking options.
• Paid holidays and PTO Accrual Plans.
• Paid Parental Leave.
• Professional development and career growth opportunities.
• Team and company-wide events, recognition, and appreciation.