plaintext
JOB SUMMARY
Senior Data Engineer 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