Get job as soon as 2 days (HURRY UP) ENROLL NOW or Call   +1 (804)-454-3215
+


Job Id : 14693

Jobtitle : MySQL DBA

Location : Fishkill, NY

Company Name : MedAllies

Industry : Information Technology

Salary : $15,000 - $185,000  PER YEAR

Job type : Fulltime

Posted on: 2020-06-30


Required Skills : MySQL Clustering Configuration, Setup And Maintenance,PERL For Database Maintenance And Interaction,MySQL In Both Windows And Linux Environments

Benefits : No benefits are available


Job Description :

 

Responsibilities:

 

  • Develop, implement, and maintain MySQL database structures in test, quality assurance, and production environments utilizing current standards and procedures.
  • Provide performance-related support and systems related support for MySQL data structures in production, test, development, and QA environments utilizing current tool sets.
  • Provide support on all the stages of database implementation and/or database related deployments
  • Installation of new MySQL instances, applying necessary patches and version upgrades.
  • Run diagnostic tools to identify database performance bottlenecks, and take appropriate corrective actions to improve database performance. Work with development teams to tune SQL queries.
  • Ensure database connectivity requirements are met and be able to troubleshoot connectivity issues.
  • Responsible for capacity planning and installation of database software, including upgrade and patch management.
  • Communicate regularly with technical, applications, and operational staff to ensure the database integrity and security.
  • Troubleshoot MySQL performance and non-performance related issues either independently or in conjunction with other DBAs.
  • Maintain existing MySQL environments, including large replication environments and mid-sized High Availability environments.
  • Manage backup/recovery for MySQL instances and provide Disaster Recovery (DR) support.
  • Management of database and resource capacity planning.
  • Implement and enforce database security based upon best practice, industry regulations, and company policies.
  • Participate in project meetings, as necessary, to understand application and database requirements.
  • Utilize logic and reasoning to identify the strengths and weaknesses of alternative solutions, conclusions, or approaches to problems.
  • Write database documentation, including data standards, procedures, and definitions for the data dictionary.
  • Provide 24 hour on-call support on a rotational basis.

 

Education and Certifications:

 

  • Master’s Degree in Computer Science or related field

 

Required Experience:

 

  • 3 -7 years’ experience in a MySQL DBA role.
  • Minimum of 3 years’ experience with the design, creation and maintenance of database engine and its structures.
  • Minimum of 3 years’ experience with the development and revision of database standards, procedures and strategies
  • Demonstrated ability to architect application relationships.
  • Data element analysis experience.
  • Experience with MySQL Clustering configuration, setup and maintenance.
  • Experience with High Availability MySQL environments.
  • Experience using PERL for database maintenance and interaction.
  • Experience with MySQL in both Windows and Linux environments.
  • Expert in SQL language
  • Experience in one or more scripting languages; Python, Perl, Shell, Ruby
  • Java experience is a plus
  • Experience is agile development environments is plus
  • Experience in reporting and data mining technologies is a plus
  • Passionate about data and making sense out of data
  • Ability to quickly learn new concepts and technologies and adapt to changing needs
  • Organized, detail oriented and capable of working independently with minimal supervision

Latest jobs for you

  • Junior Data Scientist

    NBC Universal Universal City, CA

    Job Description: The Junior Data Scientist will be responsible for delivering advanced analytics ...

    View Job
  • API Developer

    NTT DATA Corporation Brighton , MA

    Role Responsibilities: Provide API and web development in an AWS environment. Develop ...

    View Job
  • Java Developer (MID) - API

    Horkus Solutions Charlotte , NC

    Duties & Responsibilities: Design, develop, and test solutions to integrate with disparate...

    View Job
  • Enterprise Console Web Front-End/Full Stack Software Engineer (Consult

    Bloomberg New York, NY

      Job Description: Currently seeking motivated Web Front-end and Full Stack Engineers who...

    View Job
  • Front End Developer

    OneAPPS Cupertino, CA

    Required Qualifications: Strong communication and presentation skills. Expertise with ...

    View Job

Thanks For Your Feedback

We’re an equal opportunity provider.
All applicants will be considered for employment without attention to race, color, religion, sex, sexual orientation, gender identity, national origin, veteran or disability status.
OPTnation.com is not a Consulting Company/Training Company/H1B Sponsor.

Attach A Resume First