Web Developers

IT - Consultant - Infrastructure Management | Database Administration | MS SQL Server Contract

MUST HAVE:

  1. SQL DATABASE ADMINISTRATION EXP.
  2. MYSQL DATABASE ADMINISTRATION EXP.

Minimum years of experience*: 5

Responsibilities you would expect the Subcon to shoulder and execute*:

  • Specific skills needed to perform or understand sql queries, should be able to write queries for good support of database validations or logs
  • Good knowledge on high availability(Always ON, Replication, clustering etc.)
  • Able to take quick and right decisions in business hours/off hours/weekends if there is something went wrong related to the database or server.
  • Troubleshooting the index rebuilding/reorganize
  • Performing update statistics
  • Should be able to take right decisions on blocking issues
  • Troubleshooting slow running queries and take necessary steps to resolve them
  • Troubleshooting the fails backup jobs
  • Building and supporting processes to replicate data from one datastore to another, often from on premise to AWS
  • SQL Server Version Upgrades
  • DBA is often needed to deploy SQL Server portion of software releases
  • Storage Migrations - Work with Storage team to move network attached storage to another filer
  • Experience with supporting SQL Server in cloud environment.
  • Should have excellent communication skills to effectively interface with client/users/internal offshore team.
  • Issues related to Host down, MySQL Services down, client lose connections etc.
  • Need to understand about the Replication failure errors and take necessary steps
  • Provisioning new MySQL hosts and software
  • User access requests, including for new programs or new client machines
  • Provide DBA services including installations, replication, backups, loads, and schema alterations for all prod Databases in all MySQL versions.
  • Good knowledge on Linux environment
  • Hands on Experience in MySQL Migrations and upgrades from all versions.
  • Experience with supporting MySQL in cloud environment.
  • Contribute to database planning efforts such as DR, tool selection, and scaling initiatives.
  • Should have excellent communication skills to effectively interface with client/users/internal offshore team.
  • Must have good experience on oracle latest version 10g, 11g, 12c etc,
  • RAC Knowledge on all versions of oracle for storage automation and management
  • Extensive knowledge on troubleshooting Data guard
  • Rman backup tool and performance tuning
  • Need to be well verse in Oracle backup and recoveries
  • Unix scripting knowledge is must as we have MySQL DBA as well
  • Experience in handling complex database recoveries scenarios
  • Experience in troubleshooting various installation and patching issues
  • Should have excellent communication skills to effectively interface with client/users/internal offshore team.

Interview Process (Is face to face required?) No

Does this position require Visa independent candidates only? No

  • Share

  • Tweet

  • Pin

  • Share

  • Mail

  • Share

Tags

Overview

  • Job ID: 151635060
  • Location: Ipswich, MA, USA
  • Hours: 40h / week
  • Pay / Salary Range: Negotiable
  • Work Authorization Any
  • Close Date: 25, February 2020
Apply For This Job

Apply For This Job