THE ROLE We are seeking an experienced Database Engineer with AWS experience to join our newly created Service Consultant Sub-Practice and exclusively work with a mature and impactful long-term client in the financial services industry. This role requires a balance of independent work and teamwork, focusing on advancing the client's agenda. The ideal candidate will possess some understanding of the financial services sector, coupled with a proven track record of independent work and team collaboration. Join us to make a meaningful impact and contribute within our innovative team. What you'll do:
- Assist in migrating on-prem databases (Oracle and SQL Server) to AWS
- Develop and maintain IaC using Terraform and Gitlab
- Assist in upgrading Oracle database
- Assist in diagnosing and remediating problems including performance issues in Oracle Databases
- Monitor and tune database environments to ensure optimum performance and maximization of available resources.
- Coding experience with Python (including PySpark)
- Assist in tuning complex business analytical queries
- Collaborate with the application developers, architects and project team on physical database design and implementations
- Provide assistance with the investigations and resolution of complex infrastructure technical issues
- Prepare high quality documentation of design/architecture/database infrastructure documents
- Assist in ad hoc projects, assignments and responsibilities as necessary
Requirements:
- Bachelors Degree in Computer Science or related field or at least 7+ years relevant work experience as Database Engineer with focus in IaC, AWS and Oracle (on-prem)
- Solid understanding and experience IaC using Terraform and Gitlab
- Solid understanding and experience Oracle performance Tuning
- Good understanding and experience in AWS data stores such as DocumentDB, Postgres, MySql (Aurora)
- Good Understanding of Oracle Goldengate
- Knowledge of CI/CD pipeline
- Effective verbal and written skills, including good presentation skills
Nice To Have:
- Experience in agile methodologies
- Experience in Databricks
Lab49 is a specialist strategy, design, and technology consulting company dedicated to the financial services industry. We were founded in 2002 to fill a need in the Financial Technology marketplace for high-end execution and reliable delivery of technology projects. We have office hubs in Midtown Manhattan, Washington DC, London, Budapest, New Delhi and Sydney.
Our Hybrid Work Model At Lab49, we embrace a hybrid work model, offering you the flexibility to work from the office or remotely. We expect our Lab49ers to average 2-3 days per week in person and this could be at our midtown office in NYC or at a client site. We believe that both the flexibility and in person connection to each other and our clients build a collaborative culture and the opportunity to accelerate growth and innovation. Lab49/ION is committed to maintaining a supportive and inclusive environment for people with diverse backgrounds and experiences. We respect the varied identities, abilities, cultures, and traditions of the individuals who comprise our organization and recognize the value that different backgrounds and points of view bring to our business.
Lab49/ION adheres to an equal employment opportunity policy that prohibits discriminatory practices or harassment against applicants or employees based on any legally impermissible factor.