Data Engineer (PL/SQL)

Job Description

Job Description

Position Overview

We are seeking a highly skilled Senior Data Engineer with Application DBA expertise to design, build, optimize, and support enterprise data platforms. This role combines advanced data engineering with hands-on database administration, ensuring high availability, performance, and scalability of critical data systems.

The ideal candidate brings deep experience in data warehousing, ETL development, and database management, along with a strong foundation in modern cloud data platforms.

Key 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

Bachelor's degree in Computer Science, Information Systems, or related field (or equivalent experience) and 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 Qualifications

• 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

Key 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