Now Hiring: Are you a driven and motivated Data Scientist or a Senior Software Engineer?

Oracle DBA/Developer (Lead/Architect) (Fintech, PL|SQL, SQL Server/PostgreSQL, LATAM/Nova Scotia) #25162

. . . create world-changing products using God-given talents . . .

PROJECT DESCRIPTION::

As an Oracle Database Adminstrator specializing in database performance and query
optimization, you will serve as the technical authority for all database initiatives across the
Equity Management platform, reporting to the Manager of Database Administration and
working closely with the DevOps teams. This is a specialized technical role that combines
strategic data architecture thought leadership with hands-on implementation – you’ll
analyze our current Oracle database architecture, identify optimization opportunities, and
architect its transformation into a modern, performant data platform while rolling up your
sleeves to execute key technical implementations. You’ll need to not only identify and
implement solutions but also teach, influence, drive change, and hold teams accountable
to data engineering standards and best practices.

You will be joining the team at a pivotal transformation point as we modernize our data
architecture to fully leverage cloud capabilities and support next-generation analytics. We
are looking for someone who can evaluate our current Oracle database architecture, lead
optimization initiatives for performance and scalability, and architect solutions that
enhance integration with modern BI platforms. You’ll work day-to-day with our DBAs,
Solution Architect, and team of Principal Engineers to execute the transformation of our
database systems.

PROJECT STACK and TEAM::
  • Multinational team – Excellent communication skills in English are needed.
  • Start Date: ASAP
  • Interview process: 2 Rounds
  • Overlap Time: 9 AM to 5 PM EST (may require coverage of other U.S. time zones as needed).
  • Follows Kanban and Agile.
  • We have 6 DBA’s currently. So may require to work on weekends for once in 6 weeks.
  • The current team is spread across the East Coast, West Coast and LATAM.
MAIN REQUIREMENTS::
  • Strong Oracle database expertise with 10+ years of experience in performance tuning, query optimization, and large-scale systems
  • Expert-level SQL and PL/SQL skills for developing and optimizing complex queries and procedures
  • Solid experience in database design and architecture, including data modeling, normalization, and handling transactional and analytical workloads.
  • Hands-on experience with CI/CD pipelines and database deployment automation using tools like Liquibase or Flyway.
  • Knowledge of performance monitoring, execution plans, indexing strategies, along with exposure to cloud databases such as Azure SQL or PostgreSQL.
  • Need experience in Linux and Bash scripting.

GOOD TO HAVE::
  • Financial Domain Experience: Experience building applications in the financial domain.
  • Oracle Database Skills: Proficient in working with Oracle databases, including writing/optimizing complex queries, stored procedures, and scripting.
  • Education and Experience: Bachelor’s degree in Computer Science, or equivalent work experience.
JOB RESPONSIBILITIES::

Database Architecture & Strategy:
• Evaluate and lead efforts to normalize the database architecture and optimize data
models for performance and scalability.
• Assess current database bottlenecks, long-running queries, and performance issues,
designing and implementing optimization strategies.
• Design data architecture patterns to migrate business logic from Oracle stored
procedures to proper application tiers in collaboration with application engineers.
• Develop database modernization roadmap for read-optimization and tighter integration
with modern BI tools.
• Lead strategic decisions on database patterns, indexing strategies, partitioning, and data
lifecycle management.
Database Modernization & Tooling:
• Evaluate and replace our custom-built database deployment tool with enterprise-grade
solutions (DACPAC, Liquibase, Flyway, or similar).
• Design and implement robust database deployment pipelines across multiple
environments (Dev, QA, UAT, Prod).
• Architect database CI/CD processes that ensure reliability, repeatability, and auditability
of schema changes.
• Lead database migration strategies from write-optimized to read-optimized architectures.
• Design and implement database observability, monitoring, and alerting solutions.
Hands-On Implementation & Optimization:
• Analyze and optimize long-running queries and database performance issues impacting
customer experience.
• Design and implement database changes that support cloud-native application patterns
• Develop proof-of-concepts for database modernization approaches and data
architecture improvements.
• Implement database normalization initiatives while maintaining system stability.
• Work hands-on with Oracle 19c to solve immediate performance challenges while
planning longterm improvements.
Cross-Team Collaboration & Technical Leadership:
• Collaborate with Solution Architect on data strategy and phased database modernization
approaches
• Work closely with Principal Application Engineers to ensure application and database
architectures are optimally aligned
• Bridge the gap between development teams and database operations, translating
application requirements into database design
• Mentor and teach engineering teams on database best practices, performance
optimization, and modern data patterns
• Drive adoption of database standards and hold teams accountable to data quality and
performance requirements
• Lead by example through hands-on technical contributions while inspiring others to
embrace modern data engineering practices

SUMMARY::

Database Architecture & Strategy:
• Evaluate and lead efforts to normalize the database architecture and optimize data
models for performance and scalability.
• Assess current database bottlenecks, long-running queries, and performance issues,
designing and implementing optimization strategies.
• Design data architecture patterns to migrate business logic from Oracle stored
procedures to proper application tiers in collaboration with application engineers.
• Develop database modernization roadmap for read-optimization and tighter integration
with modern BI tools.
• Lead strategic decisions on database patterns, indexing strategies, partitioning, and data
lifecycle management.
Database Modernization & Tooling:
• Evaluate and replace our custom-built database deployment tool with enterprise-grade
solutions (DACPAC, Liquibase, Flyway, or similar).
• Design and implement robust database deployment pipelines across multiple
environments (Dev, QA, UAT, Prod).
• Architect database CI/CD processes that ensure reliability, repeatability, and auditability
of schema changes.
• Lead database migration strategies from write-optimized to read-optimized architectures.
• Design and implement database observability, monitoring, and alerting solutions.
Hands-On Implementation & Optimization:
• Analyze and optimize long-running queries and database performance issues impacting
customer experience.
• Design and implement database changes that support cloud-native application patterns
• Develop proof-of-concepts for database modernization approaches and data
architecture improvements.
• Implement database normalization initiatives while maintaining system stability.
• Work hands-on with Oracle 19c to solve immediate performance challenges while
planning longterm improvements.
Cross-Team Collaboration & Technical Leadership:
• Collaborate with Solution Architect on data strategy and phased database modernization
approaches
• Work closely with Principal Application Engineers to ensure application and database
architectures are optimally aligned
• Bridge the gap between development teams and database operations, translating
application requirements into database design
• Mentor and teach engineering teams on database best practices, performance
optimization, and modern data patterns
• Drive adoption of database standards and hold teams accountable to data quality and
performance requirements
• Lead by example through hands-on technical contributions while inspiring others to
embrace modern data engineering practices.

Job Category: Database Administrator
Job Location: Canada Latin America - 100% remote Nova Scotia
Skills: PL/SQL PostgreSQL SQL Server
For more job openings, please follow Evolve Squads on Linkedin