Senior Software Engineer

TekSynap; United States; Remote; USD 81,000 - 175,000; Full time

Job summary

TekSynap is seeking a Senior Software Engineer to join their remote team. The ideal candidate will have extensive experience in software development, particularly in SQL and Oracle applications. Responsibilities include system development, database management, and collaborating with stakeholders to meet business needs. This position offers a competitive salary and benefits in a flexible work environment.

Benefits

Medical insurance

Vision insurance

401(k)

Student loan assistance

Tuition assistance

Disability insurance

Qualifications

• Eight years of technical experience in applications software development.
• Three years in systems analysis, and one year as a technical lead.
• Familiarity with Oracle APEX development.

Responsibilities

• Conduct meetings with stakeholders to clarify business requirements.
• Create, design, update, and implement database changes.
• Develop and debug programs while ensuring proper exception handling.

Skills

SQL

PL/SQL

Database Design Principles

Oracle Forms & Reports

Oracle Analytics Publisher

Education

Bachelor’s degree in engineering/computer science

Tools

Oracle APEX

Git

Job description

Join to apply for the Senior Software Engineer role at TekSynap

Join to apply for the Senior Software Engineer role at TekSynap

Direct message the job poster from TekSynap

Human Resources Professional Veteran Advocate Talent AquisitionDriving Recruitment Strategy & Workforce Innovation

RESPONSIBILITIES

• Conduct meetings with Stakeholders to clarify and understand business requirements.
• Establish the high-level sprint schedule.
• Create, design, update, document and implement logical and physical database changes.
• Design and implement design solutions based on industry best practices.
• Utilize existing SOA services where feasible. build new SOA services, APIs and microservices when applicable and ensure the code is modular, re-usable, and portable.
• Modify or write new on-line programs, unit test cases, batch programs, interfaces, configuration changes, and reports. Build unit tests and integration tests as necessary.
• Ensure proper exception handling and appropriate logging.
• Identify and resolve information assurance weaknesses and vulnerabilities.
• Perform peer code reviews and ensure automation build failures resulting from code issues are resolved.
• Competent to work at a high level for all phases of system/database development/management.
• Sets priorities to meet the needs of users.
• Formulates/defines system scope and objectives.
• Devises or modifies procedures to solve complex problems considering computer equipment capacity and limitations.
• Prepares detailed specifications from which programs will be written.
• Designs, codes, tests, debugs, and documents programs.
• Participates in related areas, such as such as design, implementation, integration, management, and maintenance of complex databases, with respect to the operating system, access methods, access time, device allocation, validation checks, organization, protection and security, documentation, guidelines, and statistical methods; evaluation of commercial off-the-shelf (COTS) products; and analysis of hardware/software issues.
• May direct the work of other developers.
• Core Tool Proficiency: Demonstrated experience developing reports and dashboards using:
• Oracle BI Answers / Analysis Editor: Creating ad-hoc queries, visualizations, prompts, navigation, conditional formatting.
• Oracle BI Dashboards: Building interactive dashboards, embedding analyses, managing dashboard pages and prompts.
• BI Publisher: Designing and developing pixel-perfect, highly formatted reports (RTF templates, eText, bursting, scheduling). Must understand data models, layouts, and translation capabilities.
• RPD Modeling (Essential for Senior): Understanding and experience working with the Oracle BI Repository (.rpd file). This includes:
• Understanding the three layers (Physical, Business Model & Mapping (BMM), Presentation).
• Experience modifying the RPD (adding columns, creating aliases, basic joins). Advanced RPD skills (complex modeling, security implementation, optimization) are a big plus but basic modification is a minimum for senior report developers who need to understand the source.
• Strong SQL Skills: Ability to write, understand, and troubleshoot complex SQL queries. They need to validate data, understand query performance, and potentially use SQL within BI Publisher data models.
• Data Warehousing Concepts: Solid understanding of dimensional modeling (Star Schema, Snowflake Schema), Fact tables, Dimension tables, Hierarchies, and Slowly Changing Dimensions (SCDs). They need to understand the structures they are reporting against.
• Understanding of Oracle APEX development, including creating, designing, updating, documenting, and implementing logical and physical database changes ensuring data integrity and performance optimization.

REQUIRED QUALIFICATIONS

• DOI Entry on Duty (EOD) background check
• Eight years of technical experience in applications software development, three of which are in systems analysis, and 1 year of which is acting as technical lead.
• Bachelor’s degree in engineering/computer science or area related to the project’s functional requirement.
• Proficiency in SQL, PL/SQL, and database design principles.
• Competence in Oracle Forms & Reports, Oracle Analytics Publisher and Oracle BI Reports.
• Familiarity of Oracle APEX development and database management.

DESIRED QUALIFICATIONS

• Understanding of database architecture.
• Proficiency in Git for efficient version control and collaboration on application code.
• Familiarity with REST and Web API services for integration, improving application connectivity, and functionality.
• Strong grasp of database architecture, SQL, PL/SQL, and database design principles, complemented by adept SQL skills for effective data management.
• Experience in creating interactive web applications, reports, charts, and dashboards using Oracle APEX.
• Proficiency in utilizing and customizing APEX components and plugins to enhance application functionality and user experience.
• Hands-on experience in implementing APEX security features and user management capabilities to ensure data protection and access control.
• Ability to integrate APEX applications with other systems and technologies, including web services (RESTful and SOAP) and external data sources, ensuring seamless interoperability.
• Experience in optimizing APEX applications and SQL queries for performance, including query tuning, indexing strategies, and caching mechanisms.
• Proficiency in using version control systems like Git for managing APEX application code, ensuring versioning, collaboration, and deployment efficiency.

WORK ENVIRONMENT AND PHYSICAL DEMANDS

The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of the job. Reasonable accommodation may be made to enable individuals with disabilities to perform the essential functions.

• Location: Telework
• Type of environment: Home office, Telework
• Work schedule: Schedule is day shift Monday – Friday. May be requested to work evenings and weekends to meet program and contract needs.
• Amount of Travel: Less than 10%

Seniority level

• Seniority level

  Not Applicable

Employment type

• Employment type

  Full-time

Job function

• Job function

  Information Technology

• Industries

  Software Development, IT Services and IT Consulting, and Information Services

Referrals increase your chances of interviewing at TekSynap by 2x

Inferred from the description for this job

Medical insurance

Vision insurance

401(k)

Student loan assistance

Tuition assistance

Disability insurance

Get notified when a new job is posted.

Sign in to set job alerts for “Software Engineer” roles.

Software Engineer - Fullstack, Multiple Locations

United States $81,900.00-$174,600.00 1 week ago

United States $170,000.00-$720,000.00 1 week ago

Full-Stack Software Engineer (New graduates: United States)

United States $70,000.00-$100,000.00 2 weeks ago

New York, NY $140,000.00-$185,000.00 5 days ago

Software Engineer (L5) - Ads Identity & Privacy

United States $100,000.00-$720,000.00 1 week ago

Software Engineer (L5) - Open Connect Platform

United States $100,000.00-$720,000.00 2 days ago

Software Engineer L4/L5, Model Serving Systems, Machine Learning Platform

United States $100,000.00-$720,000.00 1 week ago

New York, United States $142,600.00-$196,200.00 5 days ago

United States $140,000.00-$170,000.00 1 month ago

Orange County, CA $75,000.00-$85,000.00 11 hours ago

Fort Myers, FL $80,000.00-$100,000.00 4 hours ago

Software Engineer Intern/Co-op (Fall 2025)

New York, NY $145,000.00-$260,000.00 7 months ago

United States $90,000.00-$170,000.00 9 months ago

New York City Metropolitan Area 3 days ago

Software Engineer - AI/ML, Multiple Locations

Redmond, WA $81,900.00-$174,600.00 1 week ago

Software Engineering Intern (September 2025)

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.