SQL Server Administrators (Downtown Manhattan)
Location
Manhattan, KS | United States
Job description
RCI Technologies is looking for experienced SQL Server Administrators for our prestigious client in Downtown Manhattan
Responsibilities:
- Manages data requirements gathering and analysis for new and existing projects.
- Supports Microsoft SQL Server 2012/2014/2016 databases across all environments.
- Supports Microsoft SQL Server 2012/2014/2016 replication feature widely used by different applications.
- Supports Microsoft Windows 2012 and 2016 Enterprise Servers including configuration and maintenance.
- Implements and supports Microsoft Clustering Services both on the SQL Server and System levels.
- Installs and configures Microsoft SQL Server 2012/2014/2016 and Microsoft Windows 2012 and 2016 servers.
Monitors Microsoft SQL Server activity on a proactive basis and tune the system for optimal performance
Requirements:
·Proficiency in preparing, maintaining SQL server installation and configuration documents.
9+ years of experience in the following:
- 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 in the following:
- 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.
Bachelors / Master degree with 5 years of experience.
[email protected]
Job tags
Salary