Be the next big change > Dassault Systèmes

Be the Next Game Changer

Staff Engineer, Database

United States, NJ, Iselin Regular 6/10/2022 999007831

Medidata: Powering Smarter Treatments and Healthier People

Medidata is leading the digital transformation of life sciences, creating hope for millions of patients. Medidata helps generate the evidence and insights to help pharmaceutical, biotech, medical device and diagnostics companies, and academic researchers accelerate value, minimize risk, and optimize outcomes. More than one million registered users across 1,900+ customers and partners access the world’s most trusted platform for clinical development, commercial, and real-world data. Medidata, a Dassault Systèmes company, is headquartered in New York City and has offices around the world to meet the needs of its customers. Discover more at www.medidata.com and follow us @medidata

Your Mission:


The Database Administrator function is responsible for supporting and coordinating all database activities in area of specialty at Medidata. This includes running scripts, database tuning, monitoring, back-up and recovery, designing and creating databases in area of specialty, resolving complex client related problems, and monitoring all database related work orders relating to their area of specialty in a timely manner.

  • Act as Subject Matter Expert for Hosting in one or more of the following specialties: MySQL & Postgres

  • Support AWS and On Prem datacenters.

  • Responsible for the overall performance, tuning, backup/recovery of all installed cloud databases in area of specialty

  • Verify and run scripts written by programmers in PRODUCTION, UAT and DEV environment for specific area of specialty

  • Diagnose and resolve production problems in area of specialty

  • Develop optimization plans for client databases.

  • Proactive Maintenance and monitoring.

  • In a team environment, successfully design, test and deploy database schema in area of specialty.

  • Work closely with other IT team members to successfully maintain and monitor the databases

  • Work closely with R&D to identify any possible performance bottlenecks.

  • Plan and implement database upgrades in area of specialty as needed.

  • To ensure that all client requests are handled in a timely manner.

  • Adhere to and suggest improvements to the Change Management Process.

  • Write custom scripts in area of specialty to automate various daily DBA operations.

  • Document and improve existing processes for area of specialty.

  • Provide 24 x 7 production support on a rotating basis as needed.

  • Identifies linkages of specialty area to other systems/ applications and communicates potential impact to peers and key stakeholders.

  • Experience in any of MongoDB, Snowflake, NuoDB, RedShift is desirable, but not required.


Your Competencies:

 

  • Uses advanced knowledge of database administration and data management lifecycle to analyze complex issues and implement appropriate solutions and optimize processes for the future in area of specialty

  • Analyzes specialized work requests/problems by troubleshooting in area(s) of specialty/specialties 

  • Translates trending and profiling into performance analysis and designs process improvements for area(s) of specialty/specialties 

  • Identifies linkages of specialty area to other systems/ applications and communicates potential impact to peers and key stakeholders

  • Analyzes how application change will impact the data management systems

  • Follows documented processes and procedures to solve complex problems

  • Assists in creating documented processes and procedures to solve complex problems

  • Assists in developing reports and monitors to ensure problem solving procedures are followed

  • Consistently performs independent problem solving for specialty

  • Acts as a subject matter expert and resource for problem solving

  • Communicates more complicated technical information to peers, requesters, and direct management team in layman’s terms in area of expertise

  • Communicates with external clients occasionally in area of expertise with management oversight

  • Develops technical documents in collaboration with architecture team (e.g., infrastructure diagrams, requirements and constraints, installation qualification, checklists, data lifecycle management policies, etc.) for specialty area

  • Trains peers and coworkers (IT colleagues, developers, product teams and professional services) in specialty area

  • Builds and maintains partnerships with developers, product team members, etc., to influence process, product and application development

  • Understands advanced installation processes for area(s) of specialty/specialties

  • Knowledge of database maintenance (e.g., indexes, statistics, and disaster recovery, etc.) in area of specialty and makes recommendations to management

  • Analyzes and implements database configuration settings (e.g., memory, storage, etc.) for area of specialty

  • Advanced understanding of specialty area (e.g., OLTP, data warehouses, data architect, business objects)

  • Scripting knowledge using linux

  • Experience creating and managing security groups preferred

  • Experience monitoring and troubleshooting advanced maintenance (e.g., indexes, statistics, and disaster recovery, etc.) required

  • Experience with YAML-based deployment tools

 

 

Medidata is making a real difference in the lives of patients everywhere by accelerating critical drug and medical device development, enabling life-saving drugs and medical devices to get to market faster. Our products sit at the convergence of the Technology and Life Sciences industries, one of most exciting areas for global innovation. Nine of the top 10 best-selling drugs in 2017 were developed on the Medidata platform.

 

Medidata’s solutions have powered over 14,000 clinical trials giving us the largest collection of clinical trial data in the world. With this asset, we pioneer innovative, advanced applications and intelligent data analytics, bringing an unmatched level of quality and efficiency to clinical trials enabling treatments to reach waiting patients sooner.

 

COVID Statement
 
Medidata requires all U.S. employees to be fully vaccinated against COVID-19 and to provide documentation of full vaccination, unless qualified for an accommodation as determined by Medidata, consistent with applicable law.  Although accommodation requests will be considered (and granted where appropriate/possible), it may be determined that a candidate is unable to adequately perform the essential functions of the position without imposing an undue hardship on Medidata due to customer requirements, staffing needs, or other business reasons.

 

Medidata Solutions, Inc. is an Equal Opportunity Employer. Medidata Solutions provides equal employment opportunities to all employees and applicants for employment without regard to race, color, religion, gender, sexual orientation, gender identity, national origin, age, disability status, protected veteran status, or any other characteristic protected by the law. Medidata Solutions complies with applicable state and local laws governing non-discrimination in employment in every location in which the company has facilities. 


#L1-AT1

#LI-REMOTE

Your Education & Experience:

  • Relevant degree preferred

  • 8+ years relational database experience required

Equal opportunity

In order to provide equal employment and advancement opportunities to all individuals, employment decisions at 3DS are based on merit, qualifications and abilities. 3DS is committed to a policy of non-discrimination and equal opportunity for all employees and qualified applicants without regard to race, color, religion, gender, sex (including pregnancy, childbirth or medical or common conditions related to pregnancy or childbirth), sexual orientation, gender identity, gender expression, marital status, familial status, national origin, ancestry, age (40 and above), disability, veteran status, military service, application for military service, genetic information, receipt of free medical care, or any other characteristic protected under applicable law. 3DS will make reasonable accommodations for qualified individuals with known disabilities, in accordance with applicable law.
MEDIDATA Logo > Dassault Systèmes

MEDIDATA generates the evidence and insights to help pharmaceutical, biotech, medical device and diagnostics companies, and academic researchers accelerate value, minimize risk, and optimize outcomes.