Required Skills

SQL DBA

Work Authorization

  • Us Citizen

  • Green Card

  • EAD (OPT/CPT/GC/H4)

  • H1B Work Permit

Preferred Employment

  • Corp-Corp

Employment Type

  • Consulting/Contract

education qualification

  • UG :- - Not Required

  • PG :- - Not Required

Other Information

  • No of position :- ( 1 )

  • Post :- 29th Jul 2021

JOB DETAIL

       Extensive Hands-On Experience configuring, administering, and troubleshooting experience working on SQL Server on either private or public cloud environments.
       Hands-On experience installing, configuring, administering, and troubleshooting SQL server on 2012, 2014, 2016, 2017, 2019,Most recent experience should be on 2016 and 2019, Hands on experience working on SQL Server on physical servers in a clustered and non-clustered environment.
       Hands on experience working on SQL Server on physical servers in a clustered and non-clustered environment.
       Skills in optimization and tuning of SQL Servers on all environments clustered, non-clustered, cloud, physical, etc. Extensive knowledge with performance troubleshooting of high-performance SQL Server environments
       Responsible for orchestrating upgrades, backups, and provisioning of database instances.
       Oversee the operations of the production and staging environments databases
       Design, implement, and monitor disaster recovery plans as it pertains to the production database environment.
       Give design recommendations for database functions that meet business operating standards while improving the efficiency of business processes
       Effectively communicate with different stakeholder groups of the organization
       Provide 24x7 support for critical production systems
       Refine and automate regular processes, track issues, and document changes
       Implement best practices on Microsoft SQL Server Databases and Servers
       Interface and communicate with customers
       Support SSIS, SSRS, SSAS solutions for customers
       Create automation for repeating database tasks
       SQL Server Replication Designing SQL Server Systems and Implement
       Ensure data consistency in the database through DBCC commands.
       Patch Management and Version Control
       Plan growth and changes (capacity planning)

       MYSQL
       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.

Company Information