Staff Engineer, Database

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.

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