Senior Database Engineer

Summary
The Platform team focus is on the development of infrastructure, frameworks, tooling, and technology in support of FINEOS applications and our cloud-hosting service.
As a Senior Database Engineer within Platform, you are a key contributor in analysis, design implementation and maintenance of complex database systems.  This role requires expertise in database architecture, performance optimization, and data security. You will work closely with cross-functional software development teams, architects and other stakeholders to ensure database reliability, scalability and efficiency.  
This role involves exposure to the entire FINEOS product technology stack, lifecycle and range of features with an emphasis towards the FINEOS cloud platform (Oracle in AWS).  The successful candidate will provide guidance and direction on challenges relating to database configuration, best practices, data protection, production support, and operations. This is a hands-on role that offers an excellent opportunity to expand your practical software engineering experience.

Responsibilities (Other duties may be assigned.)
•    Design, build, and deploy database aspects of FINEOS cloud solutions: Oracle on RDS in AWS.
•    Lead database technology best practices and improvements within FINEOS, advising on the future direction of these technologies and strategies.
•    Collaborate with Operations DBAs to tailor solutions settings and defaults.
•    Consult on SQL tuning and database performance analysis.
•    Develop robust SQL and PL/SQL code to support new product features and upgrades.
•    Engage with developers, consultants, operations, and clients on database questions and issues.
•    Troubleshoot and resolve database integrity, performance, blocking, deadlocking, connectivity, and security issues.
•    Interact with internal and external customers to clarify requirements and design solutions.
•    Compile and review estimates around all technical aspects of a solution.

Knowledge, Skills and Abilities
•    Ability to work independently and accept leadership roles.
•    Strong collaboration, interpersonal, and communication skills (both written and verbal).
•    Experience with cross-functional teams covering all aspects of the SDLC (implementation, testing, deployment).
•    Agile environment experience is highly desirable.
•    Committed to creating readable, reliable, and maintainable code.
•    Ability to convey complex findings to technical and non-technical stakeholders.
•    Display natural technical problem-solving capabilities.
•    Experience in CI/CD pipelines and working on production/pre-production databases in AWS.
•    Exposure to Java/JEE stack.

Technical Skills
•    Deep knowledge of database technology and development.
•    Experience in designing and implementing robust database architectures.
•    Proficiency in SQL and experience with multiple database management systems (e.g., Oracle, SQL Server).
•    Proficiency in SQL programming languages (PL/SQL, SQL/PL, or Transact-SQL).
•    Expertise in performance tuning, query optimization, and troubleshooting tools.
•    Strong knowledge of database security best practices and compliance standards.
•    Experience with high-availability and disaster recovery solutions.
•    Experience with cloud database design, administration, and performance optimization.
•    Exposure to Infrastructure-as-Code (CDK, CloudFormation, Terraform) is an advantage.
•    Linux/Unix experience and proficiency in shell scripting (e.g., Bash).
•    Proficiency in automating database operations and infrastructure management using scripts.
•    Experience with AWS-specific database services (Aurora, DynamoDB, Redshift).
•    Skills in optimizing database costs on AWS.
•    Proficiency with AWS monitoring and logging tools (CloudWatch, CloudTrail, Performance Insights).
•    Strong understanding of AWS backup and recovery services.
•    Experience with compliance frameworks (e.g., GDPR, HIPAA) and AWS security tools (IAM, KMS, VPC).

Education and/or Experience     
•    Minimum of 5+ years post-qualification experience in a database engineering role with exposure to the full SDLC, preferably on enterprise-scale systems.
•    Relevant third-level qualification (BS/MS) or equivalent commercial experience.

Language Skills
•    Ability to speak the English language proficiently, both verbally and in writing.

Work Requirements 
•    Compliance with all relevant FINEOS Global policies and procedures related to Quality, Security, Safety, Business Continuity, and Environmental systems. 
•    Travel and fieldwork, including international travel may be required. Therefore, employee must possess, or be able to acquire a valid passport. 
•    Must be legally eligible to work in the country in which you are hired.    

FINEOS is an Equal Opportunity Employer. FINEOS does not discriminate on the basis of race, religion, color, sex, gender identity, sexual orientation, age, non-disqualifying physical or mental disability, national origin, veteran status or any other basis covered by appropriate law. All employment is decided on the basis of qualifications, merit, and business need.