Database Developer
Take2 Consulting, LLC
- Ort
- Distans (US)
- Arbetsplats
- Distans
- Anställningsform
- Heltid
- Lön
- $154k–$194k
- Publicerat
- I dag
- Källa
- DevITJobs
Requirements:
- Bachelors degree.
- At least five years of experience in Oracle database development, database engineering, ETL development, data integration, or related software engineering roles.
- Strong Oracle SQL and PL/SQL development experience, including packages, procedures, functions, triggers, views, materialized views, sequences, complex queries, performance tuning, and tools such as SQL Developer and SQL*Loader.
- Ability to design, develop, optimize, troubleshoot, and maintain databases for enterprise and mission-critical applications.
- Experience building ETL solutions, data transformation and batch-processing frameworks, and data migration initiatives.
- Experience with AWS data services, including Amazon Redshift, Amazon RDS, Amazon S3, and related analytics and integration technologies.
- Experience with Matillion ETL or similar cloud-native data integration, orchestration, and pipeline platforms.
- Strong knowledge of relational database architecture, data modeling, ERDs, normalization, indexing, query optimization, transaction management, and referential integrity.
- Experience analyzing and supporting complex enterprise application databases, schemas, and data models.
- Experience with database testing, including unit tests, regression tests, data validation, and deployment verification.
- Experience supporting production releases, operational incidents, defect triage, root-cause analysis, and post-release validation in enterprise or mission-critical environments.
- Ability to resolve database, data quality, integration, and application performance issues across distributed environments.
- Experience with CI/CD pipelines, release automation, and DevSecOps practices for database and application deployments.
- Experience working in Agile environments using Scrum, Kanban, or similar methodologies.
- Experience with source control and application lifecycle management tools such as Git, GitHub, Bitbucket, GitLab, or Azure DevOps.
- Experience using approved AI-assisted tools or automation for development, testing, troubleshooting, documentation, code review, knowledge management, and productivity improvements.
- Understanding of responsible AI, AI governance, cybersecurity, data privacy, and secure AI adoption in enterprise or government settings.
- Familiarity with AI-enhanced SDLC practices, AI-assisted DevSecOps, intelligent automation, and emerging AI engineering patterns.
- Strong analytical, problem-solving, communication, and organizational skills, with the ability to manage priorities, work independently or collaboratively, and adapt to evolving technologies.
- Eligibility to be sponsored for a Public Trust Clearance.
- Nice to have: experience supporting Federal Government or large enterprise applications, including grants, financial, case management, regulatory, or workflow-driven systems.
- Nice to have: experience with Oracle Data Pump, Oracle GoldenGate, Informatica, Talend, ODI, Liquibase, Flyway, or similar integration and migration tools.
- Nice to have: experience with PostgreSQL, SQL Server, MySQL, or other enterprise databases, and with cloud or application modernization and database migration.
- Nice to have: familiarity with Federal security and compliance practices, including audit logging, least-privilege access, encryption-aware data handling, and FISMA, NIST, or FedRAMP controls.
- Nice to have: experience in data warehousing, dimensional modeling, reporting, business intelligence platforms such as Power BI, Tableau, or Amazon QuickSight, and data platforms for analytics, AI, or machine learning.
- Nice to have: familiarity with AWS cloud-native application and service deployment architectures.
- Preferred Oracle certifications include Oracle Certified Professional (OCP), Oracle Database Administrator Certified Professional, or Oracle SQL Certified Associate.
- Nice to have: experience evaluating emerging AI technologies, modern AI data architectures, vector databases, RAG, AI agents, knowledge management systems, enterprise AI platforms, and AI-driven modernization or automation initiatives.
- Nice to have: hands-on experience with AI development tools such as GitHub Copilot, Microsoft Copilot, Amazon Q Developer, Cursor, ChatGPT Enterprise, Claude, or Gemini.
Responsibilities:
- Design, develop, and support Oracle database solutions, including database objects, with a focus on performance, scalability, and maintainability.
- Develop, enhance, and optimize SQL and PL/SQL for applications, reporting, integrations, and business operations.
- Create and maintain migration scripts, schema changes, release packages, and automated database deployment processes.
- Build and support ETL workflows, data transformations, validation frameworks, and batch-processing solutions.
- Analyze data models, schemas, enterprise data flows, ERDs, and mappings to address business and application needs.
- Develop and support cloud-based integration, reporting, and analytics solutions using AWS services such as Redshift, S3, and RDS.
- Build and maintain data pipelines with Matillion ETL and other enterprise integration platforms.
- Troubleshoot database issues, data quality concerns, integration challenges, and performance bottlenecks.
- Tune and optimize database performance using execution plans, indexing, partitioning, optimizer statistics, and Oracle diagnostic and monitoring tools.
- Partner with software engineers, architects, DevOps engineers, and business stakeholders to deliver reliable, scalable data solutions.
- Participate in Agile practices, including planning, backlog refinement, daily standups, code reviews, reviews, and retrospectives.
- Advance DevSecOps and CI/CD initiatives through automated testing, deployment, monitoring, and compliance practices for database solutions.
- Create and maintain technical documentation, including database designs, mappings, interface specifications, operational procedures, and support guides.
- Develop and support unit, regression, and data validation testing, as well as automated testing for SQL, PL/SQL, ETL, and migration changes.
- Support production operations, releases, incident investigation, root-cause analysis, and post-deployment validation for mission-critical systems.
- Use approved AI development tools to support SQL and PL/SQL development, code review, troubleshooting, documentation, testing, and knowledge sharing.
- Identify and implement opportunities to apply AI and intelligent automation to development, data engineering, deployments, monitoring, operations, and team productivity.
- Support data governance, security, privacy, and compliance through access controls, auditability, secure data handling, and applicable Federal standards.
- Assess emerging database, cloud, AI, and data engineering technologies and recommend improvements to platform capabilities and team productivity.
Technologies:
- AI
- AI Agents
- AWS
- Redshift
- Azure
- BitBucket
- Business Intelligence
- ChatGPT
- CI/CD
- Cloud
- Copilot
- Cursor
- DevSecOps
- DevOps
- ETL
- Flyway
- Git
- GitHub
- GitLab
- Informatica
- Support
- Kanban
- Liquibase
- Machine Learning
- MySQL
- ODI
- Oracle
- PostgreSQL
- Power BI
- RAG
- SQL
- Security
- Tableau
- Talend
More
We are Take2, a technology and people-solutions provider partnering with Federal and commercial clients to address their business challenges through tailored solutions and our proprietary People Cloud. We are hiring a Database Developer to support application modernization, database development, systems integration, analytics, and operations. This is a remote role for someone located in the United States, with work scheduled on East Coast hours.
last updated 44 week of 2026