Position OverviewWe 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