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

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

v MYSQL
v Issues related to Host down, MySQL Services down, client lose connections etc.
v Need to understand about the Replication failure errors and take necessary steps
v Provisioning new MySQL hosts and software
v User access requests, including for new programs or new client machines
v Provide DBA services including installations, replication, backups, loads, and schema alterations for all prod Databases in all MySQL versions.
v Good knowledge on Linux environment
v Hands on Experience in MySQL Migrations and upgrades from all versions.
v Experience with supporting MySQL in cloud environment.
v Contribute to database planning efforts such as DR, tool selection, and scaling initiatives.

Additional Responsibilities:
• Knowledge of design principles and fundamentals of architecture • Understanding of performance engineering • Knowledge of quality processes and estimation techniques • Basic understanding of project domain • Ability to translate functional / nonfunctional requirements to systems requirements • Ability to design and code complex programs • Ability to write test cases and scenarios based on the specifications • Good understanding of SDLC and agile methodologies • Awareness of latest technologies and trends • Logical thinking and problem solving skills along with an ability to collaborate

Minimum years of experience*: 5+

Company Information