Data Engineer (PL/SQL)
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 SQLAutomate 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 SkillsStrong 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)
- PythonSQL (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