DATABASE ADMINISTRATOR

We are looking for a Database Administrator (DBA) to join our small, yet a highly skilled team of IT professionals and make an impact on the future of the financial services industry. In this position, you will be responsible for providing strategic direction by researching, testing, and implementing new technologies, ETL processes, and system architectures, and maintaining firmwide database systems. Reporting directly to the CTO and SVP of Engineering, you will have the chance to take care of the whole infrastructure and database design.

Your responsibilities:

• Database architecture and design
• Lead database performance issue investigation and resolution efforts
• Provide suggestions and solutions for big data processing – ETL and DWH
• Work closely with the business and deliver technical implementations, according to their needs
• Collaborate with the dev team and resolve the performance problems together
• Perform proactive database performance analysis reviews; develop recommendations; implement approved improvements
• Maintain technical documentation as system modifications are made
• Perform daily database health checks
• Take care of the automation for the database standard tasks

Our requirements:
- Core:
• 5+ years of Oracle Database Administrator experience - Oracle SE/EE (rman, ASM, OCI, Data Guard, Data Pump)
• SQL database development and performance tuning experience (Oracle 19c)
• Performance optimization (Indexes, database reorganization, stats, database parameters, execution plan investigation, AWR, ASH)
• Knowledge of relational database, data warehouse, and operational data store design that lead to support business intelligence solutions/applications
• Experience with advanced query design, stored procedures, views, functions, index design, and SQL performance tuning techniques
- Desirable:
• BI reporting
• Shell scripting
• Data lifecycle
• Oracle Partitioning
• SQL, PL/SQL skills

Our offer:
• You will be part of our highly capable and experienced technology team
• Casual work environment with fun, hard-working, and open-minded colleagues
• Competitive salary and performance-based bonuses
• Comprehensive health plan
• Convenient office location
• Flexible work schedule and work from home options
• 25 days of paid annual leave
• Stocked kitchen and weekly lunches
• Sportscard