Data Engineer (Oracle DBA)

Title: Data Engineer (Oracle DBA)

Responsibilities:

Application DBA Responsibilities

• Administer, monitor, and tune Oracle databases supporting critical applications
• Manage database performance (query optimization, indexing, partitioning, and execution plans)
• Perform database maintenance activities (backups, recovery, patching, upgrades)
• Ensure high availability, disaster recovery, and data integrity
• Support application teams in database design and troubleshooting

Data Engineering & Architecture

• Develop and maintain data models (dimensional and normalized) to support analytics and reporting
• Build and optimize enterprise data warehouse solutions across Oracle and Snowflake platforms
• Ensure efficient ingestion, transformation, and integration of structured and unstructured data
• Design, develop, and maintain scalable data pipelines and ETL processes using tools such as Informatica and Python

Reporting & Analytics Support

• Support and enhance Oracle Analytics Server reporting environments
• Collaborate with BI and analytics teams to ensure data accuracy and usability
• Optimize data structures for reporting performance

Cloud & Modern Data Platforms

• Develop and maintain solutions in Snowflake cloud data warehouse
• Implement best practices for cloud data architecture, cost optimization, and performance
• Work with NoSQL technologies (MongoDB) for semi-structured and unstructured data use cases

Development & Automation

• Write efficient, reusable, and scalable code using Python and SQL
• Automate data workflows, monitoring, and alerting
• Implement CI/CD practices for data pipelines and database deployments

Data Governance & Quality

• Ensure data quality, consistency, and security across platforms
• Implement data validation, cleansing, and lineage tracking
• Adhere to corporate data governance and compliance standards

Required Qualifications

• 7+ years of experience in data engineering and database administration

Technical Skills

• Strong expertise in:
• Oracle Database (Application DBA experience required)
• Informatica (ETL development)
• Data Warehousing concepts and architecture
• Hands-on experience with:
• Snowflake
• Oracle Analytics Server (reporting and integration)
• Python
• SQL (advanced querying and performance tuning)
• NoSQL databases (MongoDB preferred)

Preferred Skills:

• Experience with cloud platforms (Azure, AWS, or GCP)
• Familiarity with modern data stack tools (dbt, Airflow, etc.)
• Knowledge of DevOps and CI/CD pipelines
• Experience supporting high-volume transactional systems (OLTP)
• Exposure to data governance and security frameworks

Competencies:

• Strong analytical and problem-solving skills
• Ability to balance development and operational DBA responsibilities
• Excellent communication and stakeholder collaboration
• Detail-oriented with a focus on performance and reliability
• Proactive in identifying and resolving system bottlenecks

Dexian stands at the forefront of Talent + Technology solutions with a presence spanning more than 70 locations worldwide and a team exceeding 10,000 professionals. As one of the largest technology and professional staffing companies and one of the largest minority-owned staffing companies in the United States, Dexian combines over 30 years of industry expertise with cutting-edge technologies to deliver comprehensive global services and support.

Dexian connects the right talent and the right technology with the right organizations to deliver trajectory-changing results that help everyone achieve their ambitions and goals. To learn more, please visit https://dexian.com/.

Dexian is an Equal Opportunity Employer that recruits and hires qualified candidates without regard to race, religion, sex, sexual orientation, gender identity, age, national origin, ancestry, citizenship, disability, or veteran status.