• MY-SQL Jobs in Pune,India - 25309771

  • Zensar Technologies Ltd
  • Save Job
  • 5 - 8 Years
  • Posted : above 1 month

Job Description:

* Execute traditional DBA operational responsibilities to proactively guarantee availability and performance

* Strive to find opportunities to introduce or improve automation, monitoring, and process

* Manage SQL Server databases through multiple product life-cycle environments, from development to mission-critical production systems

* Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security

* Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end

* Refine and automate regular processes, track issues, and document changes

* Assist developers with complex query tuning and schema refinement

* Experience in installation and configuration Mysql

* Applying SQL Server patches and hotfixes

* Performing the Failover and Failback operations in the cluster environment, adding the new Disks, and troubleshooting activities

* Configured Transactional Replication and maintained in a production environment

* Experience in job scheduling and database mail configuration using it for sending alert notifications

* Provide 24x5 and on call on weekend support for critical production systems

* Perform scheduled maintenance and support release deployment activities after hours

* Share domain and technical expertise, providing technical mentor-ship and cross-training to other peers and team members

Skills and Qualifications

* 5 year experience supporting high volume MSSQL Server and MySQL databases in a large-scale consumer internet environment

* Deep knowledge of MySQL and MSSQL Server internals, debugging and query optimization

* Strong experience migrating database across platforms such as MSSQL to MySQL

* Demonstrable expertise in database design and architecture, capacity and scalability planning

* Strong systems administration knowledge and scripting skills

* Experience with AWS cloud

* Creating new RDS instances in AWS

* Modifying the database structure

* Controlling user access to the database

* Parameter configuration and tuning

* Monitoring performance metrics, response times, and request rates

* Setting cloud watch alarm

* Experience with Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools

* Experience with backups, restores and recovery models

* Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Server

* Excellent written and verbal communication

* Flexible, team player, get-it-done personality

* Ability to organize and plan work independently

* Ability to work in a rapidly changing environment

* Ability to multi-task and context-switch effectively between different activities

* Additional advantage if certified with MSSQL, MYSQL or AWS

Profile Summary:

Employment Type : Full Time
Eligibility : Any Graduate
Industry : Software Services, Internet/Dot com/ISP
Functional Area : IT Software : Software Products & Services
Role : Database Administration (DBA)
Salary : As per Industry Standards
Deadline : 03rd Jun 2020

Key Skills:

Taking these free online tutorials can help you get your next job

People who search this job also searched for the following Keywords

Salary trends based on over 1 crore profiles

View Salaries

All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd DMCA.com Protection Status