Database Developer - Data Intelligence LLC

OpenTalent; San Diego (CA); On-site; USD 85,000 - 125,000; Full time

Job summary

OpenTalent in San Diego, CA seeks a database developer to design, implement, and optimize robust Oracle database solutions. You will work across the SDLC to build scalable data structures and efficient queries.

The role requires strong SQL/PLSQL, experience with JSON data exchange, ETL, and familiarity with SQL Server tools, Linux shell scripting, and security hardening (STIG). Collaborative, detail-oriented applicants with 3+ years in database programming will thrive.

Qualifications

• 3+ years of database programming experience in a corporate information system lifecycle
• Experience with Oracle 12c+ developer tools including SQL*Plus and SQL Developer
• Proficient in SQL for table structures, indexing, constraints, views, and queries
• Experience using JSON data exchange with web applications
• Hands-on full SDLC experience: planning to maintenance
• Troubleshoot and resolve database defects and operational issues
• Experience with SQL Server 2016 tools and Transact-SQL (T-SQL)
• Familiarity with Linux and shell scripting
• Experience with ETL tools and scripts
• Experience with XML data and cybersecurity policy requirements (STIG)

Responsibilities

• Design, develop, test, deploy, and maintain robust database structures and supporting solutions
• Develop and maintain Oracle database objects (tables, indexes, constraints, views, queries, procedures, packages, triggers)
• Develop database functionality using SQL and PL/SQL
• Support database integration with web applications using JSON
• Participate in all phases of the Software Development Lifecycle
• Troubleshoot, diagnose, resolve and document database defects
• Create and modify database schemas through scripts
• Support ETL activities as required
• Collaborate with developers and stakeholders to meet application requirements
• Apply secure development practices and satisfy cybersecurity and system security requirements
• Improve performance, reliability, and security of database environments
• Evaluate and recommend database development tools and technologies

Skills

Oracle 12c+

SQL

PL/SQL

T-SQL

JSON data exchange

ETL

Linux scripting

XML

Security STIG

Tools

SQL Developer

SQL Server Management Studio

Job description

• Design, develop, test, deploy, and maintain robust database structures, objects, and supporting solutions.
• Develop and maintain Oracle database objects, including tables, indexes, constraints, views, queries, procedures, packages, and triggers.
• Develop and maintain database functionality using SQL and PL/SQL.
• Support database integration with web applications using JSON and other data exchange formats.
• Participate in all phases of the software development lifecycle, including Planning, Requirements, Design, Build, Document, Test, Deploy, and Maintain.
• Troubleshoot, diagnose, resolve, and document database-related software defects and operational issues.
• Develop database scripts to create, modify, populate, and maintain database schemas and objects.
• Support data extraction, transformation, and loading activities as required.
• Collaborate with developers, technical teams, stakeholders, and end users to understand application requirements and develop effective database solutions.
• Apply secure development practices and support database changes required to meet cybersecurity and system security requirements.
• Contribute to the performance, reliability, maintainability, and security of supported database environments.
• Evaluate and recommend database development tools and technologies to improve application capabilities and development efficiency.
• Minimum of three (3) years of database programming experience supporting the life cycle of a corporate information system
• Experience with Oracle 12c or greater developer tools, including SQL*Plus and SQL Developer
• Demonstrated experience using SQL to create and maintain table structures, indexing, table constraints, user and role privileges, views, and queries
• Experience using SQL aggregate functions such as COUNT and SUM
• Development of procedures, packages, and triggers using PL/SQL
• Experience using the JSON data exchange format with web applications
• Hands-on experience across the full software development cycle: Planning, Requirements, Design, Build, Document, Test, Deploy, and Maintain
• Proven ability to troubleshoot and resolve software defects
• Experience with SQL Server 2016 developer tools, including SQL Server Management Studio
• Development of procedures, packages, and triggers using Transact-SQL (T-SQL)
• Familiarity with the Linux operating system and experience writing shell scripts to automate processes
• Experience developing Extraction, Transformation, and Loading (ETL) tools and scripts
• Experience performing software upgrades and database modifications to comply with cybersecurity policy requirements, including encryption, user rule enforcement, and Security Technical Implementation Guide (STIG) remediation
• Experience working with XML