Database Engineer (352), New York (hybrid)

5 Days ago • 7 Years +

About the job

Summary_{By Outscal}

Database Engineer with AWS experience needed to migrate on-prem databases to AWS, develop IaC using Terraform and Gitlab, and tune Oracle databases for optimal performance. Experience with Python (including PySpark) and knowledge of CI/CD pipeline required.

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

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.