Senior Data Engineer (PL/SQL)

Title: Senior Data Engineer (PL/SQL)
Location: Merrimack, NH :: Smithfield, RI :: Westlake, TX
Rate: $70 W2 
Interview: 2 rounds

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.
MUST HAVE ORACLE DBA EXPERIENCE

Top Skills:
Experience with:

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
What does this team do: This team is establishing a Center of Excellence for A.I. Data Governance within Charitable.

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 Google Cloud Platform)
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