ChandlerRecruiter Since 2001
the smart solution for Chandler jobs

SQL Server DBA

Company: Diverse Lynx
Location: Chandler
Posted on: January 12, 2022

Job Description:

Job Description Job Title: IT - Technology Analyst - Database Administration - PostgreSQL Work Location: Chandler, AZ 85224 Contract duration: 12 months More Information: Target Start Date: 1st December 2021 Relevant experience: 8-10 years Detailed Job Description: 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. Good understanding of mongo engine (Mongo 3.4, 4.0, 5.0), preferably 4 to 6 yrs of hands on experience Good understanding of Subscription / Consumers / Queues / Topics / Bridge / User Management Prior understanding on Configurations files Engine performance tuning Good understanding of AMQ configuration files Understanding and debugging using logs Understanding of SSL configuration Hands on experience in troubleshooting issues as Active MQ DB administrator Prior experience supporting AMQ in a production environment involving round the clock support 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. 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 Diverse Lynx LLC is an Equal Employment Opportunity employer. All qualified applicants will receive due consideration for employment without any discrimination. All applicants will be evaluated solely on the basis of their ability, competence and their proven capability to perform the functions outlined in the corresponding role. We promote and support a diverse workforce across all levels in the company.

Keywords: Diverse Lynx, Chandler , SQL Server DBA, IT / Software / Systems , Chandler, Arizona

Click here to apply!

Didn't find what you're looking for? Search again!

I'm looking for
in category
within


Log In or Create An Account

Get the latest Arizona jobs by following @recnetAZ on Twitter!

Chandler RSS job feeds