Data Engineer (PL/SQL)
Job Description
Position Overview:
We are seeking a highly skilledSenior Data Engineer with Application DBA expertiseto 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 tuneOracle databasessupporting 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 optimizeenterprise data warehouse solutionsacross Oracle and Snowflake platforms
Ensure efficient ingestion, transformation, and integration of structured and unstructured data
Design, develop, and maintain scalabledata pipelines and ETL processesusing tools such as Informatica and Python
Reporting & Analytics Support
Support and enhanceOracle Analytics Serverreporting 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 inSnowflake cloud data warehouse
Implement best practices for cloud data architecture, cost optimization, and performance
Work withNoSQL technologies (MongoDB)for semi-structured and unstructured data use cases
Development & Automation
Write efficient, reusable, and scalable code usingPython 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 indata 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