Get job as soon as 2 days (HURRY UP) ENROLL NOW or Call   +1 (804)-454-3215
+


Job Id : 14358

Jobtitle : MYSQL DBA

Location : New York, New York

Company Name : Trinamix

Industry : Information Technology

Salary : $15,000 - $115,000  PER YEAR

Job type : Fulltime

Posted on: 2020-06-18


Required Skills : Database Normalization, Logical And Physical Modelling, Capturing Data Lineage, Table And Column Data Definitions, Valid Values And Others Necessary Information In The Data Models,SQL Server Setup And Configuration On Windows Servers And Linux

Benefits : No benefits are available


Job Description :

 

Responsibility :

 

  • Proficiency in preparing, maintaining SQL server installation and configuration documents.
  • 9+ years of experience.
  • Query optimization experience with modification in TSQL queries, removing unnecessary columns, eliminating redundant and inconsistent data, normalizing database, establishing necessary joins, creating useful clustered index and non-clustered indexes.
  • 8+ years of experience.
  • Database Normalization, logical and physical modelling, capturing data lineage, table and column data definitions, valid values and others necessary information in the data models.
  • Enforcing standards and best practices around data modelling efforts.
  • SQL Server installation of SQL Server and updating with service packs and patches.
  • SQL Server setup and configuration on Windows Servers and Linux.
  • Installing and configuring SQL Server 2014/2016/2019 on the server and client machines, provide connections and manage databases.
  • SQL Server installation on stand-alone and Windows Server Clustered environments.
  • Administering the MS SQL Server security by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups.
  • Installing and configuring MYSQL databases.
  • Installing, authoring, and managing reports using SQL Server 2016 Reporting Services.
  • Performing daily database tasks including backup and restore by using SQL Server native tools and third party software, including VERITAS net backups and Lite speed backups.
  • Developing automated routine tasks for backup, restore and DBCC scripts for databases maintenance, optimization and transaction logs.
  • Performing backup and data compression using different editions of SQL Server.
  • Administering and monitoring MYSQL databases.
  • Planning, gathering the pre-deployment information and deployment of the third party tools like IDERA SQL Diagnostic, Dynatrace AppMon, and Quest Foglight etc.
  • Backup and recovery implementation Strategy for 24x7 operation support.
  • Designing and implementing enterprise data warehouse solutions.

Latest jobs for you

  • CISCO Network Engineer

    Nam Info Inc New York City, NY

    Experience/Qualifications: Requires good knowledge of Cisco routers and switches. Requires ...

    View Job
  • Network Engineer (Cisco, NMT, VLAN)

    Net2Source Inc Kohler, WI

    Job Description: Support for Cisco Switches, Riverbed WAN Accelerators, F5 Load balancers ...

    View Job
  • Senior Engineering Program Manager – SaaS (Remote)

    FireEye, Inc. Richmond, VA

    Job Description: The Senior Engineering Program Manager -SaaS will manage multiple ...

    View Job
  • Salesforce Platform Developer - Reomte

    Micro Focus LLC Plano, TX

    Job Description: Researches, designs, develops operates and maintains support services for ...

    View Job
  • Senior Software Developer

    Conversant Solutions Inc. Charlotte, NC

    Job Description: Senior Software Developer with Master’s degree in Computer Science, ...

    View Job

Thanks For Your Feedback

We’re an equal opportunity provider.
All applicants will be considered for employment without attention to race, color, religion, sex, sexual orientation, gender identity, national origin, veteran or disability status.
OPTnation.com is not a Consulting Company/Training Company/H1B Sponsor.

Attach A Resume First