Senior Database Architect - Oracle/ETL, Agile

Compunnel Inc.; Merrimack (NH); On-site; USD 110,000 - 150,000; Full time

Job summary

Compunnel, Inc. is seeking a Senior Database Developer for the Workplace Investment team. You will design and implement applications/frameworks using Oracle, SQL Server, Informatica, and Control-M to meet business requirements.

The role involves developing high-performance database solutions, evaluating current implementations, and articulating a technical vision aligned with architecture and stakeholder needs.

Qualifications

• PL/SQL programming including packages, procedures, functions and triggers.
• Experience in designing high-performance database solutions.
• Experience with ETL design and development.
• Experience with Oracle and SQL Server in enterprise environments.
• Agile methodology experience.
• Strong analytical and problem-solving skills.
• Ability to work with stakeholders and partners.
• Ability to adapt in changing environments.
• Bachelor's Degree in Computer Science or similar subject.

Responsibilities

• Develop robust high-performance database solutions.
• Assess current implementations and elevate platform to meet customer needs.
• Set a technical vision from business requirements and architecture and articulate steps.

Skills

PL/SQL

Performance tuning

ETL design

Informatica

Oracle DB

SQL Server

Agile

Communication

Teamwork

Problem solving

Education

Bachelor's Degree in Computer Science or similar

Tools

Oracle

SQL Server

Informatica

Control-M

Job description

plaintext
JOB SUMMARY
The Senior Database Developer for the Workplace Investment team will be responsible for designing and driving implementation of applications/ framework using Oracle, SQL Server, Informatica, Control-M.

Key Responsibilities
Developing and designing robust high per-performance database solutions.
Assessing and researching current implementations of the platform and determining the course of action required to elevate the platform to meet customer needs.
Taking the business requirements coupled with existing architecture to set a technical vision for features and major components and clearly articulating the evolutionary steps to achieve it.

Required Qualifications
Experience in PL/SQL programming including packages, procedures, function and triggers.
Ability to optimize complex queries and design efficient solutions.
Experience working in enterprise environments with version control and deployment standards.
Excellent Analytical and problem-solving skills with detail-oriented mindset.
Experience in ETL design and development.
Experience with data base such as Oracle (Primary), SQL server.
Experience of working in Agile methodology.
Ability to build communication and rapport with partners, stakeholders.
Ability to adapt in a changing environment and be effective in many different business settings.
Ability to take initiative, define vision for betterment of products, and execute at high level of quality
Ability to plan and work with geographically spread-out teams
Strong presentation and interpersonal skills.
Curiosity to constantly relearn/explore new processes/technologies
Bachelor's Degree in Computer Science or similar subject.
7-10 years of experience in information technology.
Languages: Oracle PL/SQL , Informatica ETL (Mandatory)
Databases: Good understanding and experience on RDBMS (Mandatory)
Methodology: Agile

Preferred Qualifications
Financial services experience, preferably in retirement Domain.
Knowledge of Containerization and cloud deployment related to Database.
Other database like SQL Server and Sybase (Advantage)

Certifications
Certification in relevant technologies is preferred.