MySQL Staff Database Administrator - Pune, India - Medidata Solutions
Description
Requisition ID:
519719
About DASSAULT SYSTEMES
Dassault Systemes, The 3DEXPERIENCE Company, is a French multinational software company that develops 3D design, 3D digital mock-up, and product life-cycle management software and services that support industrial processes by providing a 3D vision of the entire life-cycle products, from conception to maintenance.
Dassault Systemes is a scientific company, which combines Science, Technology, and Art to create a sustainable society and thereby provides the businesses and people with virtual universes to imagine the sustainable innovations.
What will your role be?
- Your Mission:
- Architect, design, develop, administer, monitor and manage MySQL databases in AWS RDS and On-Premise
- Provide operational support of Medidata MySQL databases
- Develop DBA Services standards. Mentor on database standards and best practices to internal DBA's and
- Identify and assist in improving Infrastructure tools/services with automation and process enhancements
- Maintain availability, stability, reliability, security and data integrity standards across database hosting
- Ensure databases are highly scalable and deployable using configuration management tools
- Provide feedback and insight on designing and scaling of SaaS and cloudbased environments and tools
- Troubleshoot and administer critical production and testing environments. Diagnose and address performance
resolution plan
- Create and maintain documentation such as Standard Operating Procedures, architecture diagrams, high level
to support configuration management for all environments
- Provide database hosting guidance on new database components
- Create knowledge base articles that can be used by the organization in response to routine or complex
- Able to participate in multiple cross platform projects and cross functional teams to ensure the projects are
- Participate in 24x7 oncall rotation
Your Commitments:
- 5+ years of Database architecture, design, development, implementation, and support experience
- 5+ years of experience working with Unix/Linux systems
- 5+ years of experience in highly transactional and high volume database systems
- Experience with HA, DR & other data replication strategies for highly available cloud based database systems
- Experience scripting using Unix shell, SQL and/or any other scripting language
- Experience providing production operations support on client facing systems and products in a hosting/vendor
- Proven ability to streamline and automate technical processes using various disciplines
- Knowledge of standard internet/network protocols including: DNS, SSH, TCP
- Strong interpersonal and communication skills, both written and verbal
- Ability to provide strategic vision for selection, implementation and support of technology solutions
- Able to thrive in an agile, fast paced, high energy and fun work environment
- Ability to communicate technical concepts to technical and nontechnical audiences
- Ability to understand operational requirements and translate to technical solutions
- Strong analytical and problemsolving abilities
- Ability to lead projects/initiatives and act as mentor for other database engineers in the team
- Ability to work in a globally diversified team of DBA's
- Your Preferred Competencies:
- Experience working with AWS cloud services
- Experience with automation tools
- Ansible, Jenkins
- Experience working with databases in MySQL, Postgres, Oracle, and/or MongoDB
- Nice to have experience working with any of Snowflake, NuoDB
- Software development experience using any dynamic language
- Experience with cloud based or other monitoring solutions (New Relic, Solarwinds, SumoLogic)
Your Education & Experience:
- Bachelor's degree or equivalent experience.
Qualifications:
BE/ME/MCA/MSc