Oracle Senior Database Engineer in Bengaluru, India
Senior Database Engineer
We at Oracle have set out on a mission to streamline the clinical trial study startup process. Oracle Health Sciences already offers customers the industry's most advanced cloud solution for clinical trial planning, data collection, trial execution and safety management. goBalto adds the leading industry cloud solution that significantly reduces clinical trial startup time. Together, Oracle and goBalto will provide the most complete end-to-end cloud platform dedicated to unifying action and accelerating results for the Life Sciences industry
Who we are...
goBalto is about re-imagining how study teams get clinical trials started and done. We're building the modern way to work together; a fast and versatile web application that connects sponsors, CROs, and sites with what’s going on, their shared priorities, and who owns each part of the effort.
We're software engineering, clinical operations, and thought leaders from companies like Amgen, Genentech, Quintiles, Roche, Johnson & Johnson, CERN, McKinsey & Company, Intuit, Cisco WebEx, E
- TRADE, Peoplesoft and Sun Microsystems. We're backed by Aberdare Ventures, Singapore EDBI, Qualcomm Life Fund of Qualcomm Ventures, West Health Investment Fund, and an experienced team of advisors.
Why we're here...
The clinical study startup process is awful. Existing tools used to track site activation tasks and documents are manual, bloated, and complex. To take the next step in clinical study productivity, we need a fresh start. We created goBalto to help take that step; to improve the productivity of sponsors, CROs, and sites, to ultimately get medicines to those in need faster.
The PostgreSQL DBA should have experience in cloud hosted environment managing backup recovery, replication, high availability, designing and managing schema, monitoring diagnosing and optimizing database performance. Using your experience, you will develop and maintain technical standards, procedures, and documentation. You will also maintain highly available system supporting PostgreSQL database in multiple clouds and container environments. This person will work with software engineers, QA engineers, DevOps engineers and other groups to design strong reliable solutions.
Work alongside our cloud infrastructure DevOps team to plan, administer, maintain and secure PostgreSQL databases in an AWS environment.
Work closely with QA and product team to ensure build and deployments of database changes within sprints.
Work closely with data engineers in Analyze team to support schema and data structure changes. Seek to automate data service throughout analyze product offerings.
Define standard practices and procedures for operational support, writing and updating documentation
Ensure databases are running at the highest possible performance level as well as analyzing and tuning queries by proactively monitoring online DB performances.
Analyze database changes requested by the Agile development teams for impacts to database designs, naming standards, design standards, data conversions, and documentation.
Desire to learn about the data and its use to make recommendations for improvements in how it is stored and processed
Build and maintain highly available systems to ensure maximum up time.
Work in unity with our Analyze (BI) team to design, build and maintain GBU analytics for analyze reporting and analytics
R&D database in containers on Kubernetes clusters.
Participate annual DR tests. Periodically launch database backup and recovery tests and document results.
A Bachelor’s Degree and 5 years of PostgreSQL DBA
Hands-on experience and in-depth knowledge of AWS database offerings (for example AWS RDS, redshift, Dynamo)
Technical expertise regarding data models, database design and development
Demonstrated experience in data modeling tools.
Experience with Data Warehousing and utilizing ETL tools such as AWS Glue
Knowledge of Oracle a plus
Must be a team player
Experience in any of the deployment tools like Puppet, Ansible, Chef or Salt is a plus
Excellent written and verbal communication skills with ability to communicate technical issues to nontechnical and technical audiences.
Experience in Linux/Unix environment Experience in any of the deployment automation tools like Puppet Ansible, Chef or Salt.
Demonstrate strong ability to delivery and show passion.
Will be handling production escalation calls/emails support as and when required.
Show operational excellence treats.
Demonstrate strong ability to drive project and delivery results
Show passion for devops career and help improve operational excellence KPI.
Detailed Description and Job Requirements
Analyze, design develop, troubleshoot and debug software programs for commercial or end user applications. Writes code, completes programming and performs testing and debugging of applications.
As a member of the software engineering division, you will perform high-level design based on provided external specifications. Specify, design and implement minor changes to existing software architecture. Build highly complex enhancements and resolve complex bugs. Build and execute unit tests and unit plans. Review integration and regression test plans created by QA. Communicate with QA and porting engineering as necessary to discuss minor changes to product functionality and to ensure quality and consistency across specific products.
Duties and tasks are varied and complex needing independent judgment. Fully competent in own area of expertise. May have project lead role and or supervise lower level personnel. BS or MS degree or equivalent experience relevant to functional area. 4 years of software engineering or related experience.
Job: Product Development
Job Type: Regular Employee Hire