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
