Senior Data Engineer

About the role

Our client seeks a Senior Data Engineer with Application DBA expertise to design, build, optimize, and support enterprise data platforms. The role combines advanced data engineering with hands-on database administration to ensure availability, performance, and scalability across Oracle, Snowflake, and modern analytics environments. Due to client requirements, applicants must be willing and able to work on a w2 basis.

Responsibilities

• Administer, monitor, and tune Oracle databases supporting critical applications.
• Manage database performance including query optimization, indexing, partitioning, and execution plans.
• Perform database maintenance such as backups, recovery, patching, and upgrades.
• Ensure high availability, disaster recovery, and data integrity.
• Support application teams in database design and troubleshooting.
• Develop and maintain dimensional and normalized data models.
• Build and optimize enterprise data warehouse solutions across Oracle and Snowflake.
• Design, develop, and maintain scalable data pipelines and ETL processes using Informatica and Python.
• Ensure efficient ingestion, transformation, and integration of structured and unstructured data.
• 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.
• Implement best practices for Snowflake architecture, cost optimization, and performance.
• Work with NoSQL technologies such as MongoDB for semi-structured and unstructured data.
• 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.
• Ensure data quality, consistency, security, validation, cleansing, and lineage tracking.
• Adhere to corporate data governance and compliance standards.

Requirements

• 7+ years in data engineering and database administration.
• Application DBA experience with Oracle Database.
• Informatica ETL development and data warehousing expertise.
• Hands-on experience with Snowflake, Oracle Analytics Server, Python, and advanced SQL.
• Experience with NoSQL databases, preferably MongoDB.
• Preferred: Cloud platforms such as Azure, AWS, or GCP.
• Preferred: Modern data stack tools such as dbt and Airflow.
• Preferred: Knowledge of DevOps and CI/CD pipelines.
• Preferred: Experience supporting high-volume OLTP systems.