SQL Database Administrator/Developer,$60/HR, CALIFORNIA LOCAL CANDIDATES Only

  • Posted 15 days ago | Updated moments ago

Overview

Remote
$60
Accepts corp to corp applications
Contract - Independent
Contract - W2
Contract - 12 Month(s)

Skills

DBA
Data Modeling
Microsoft SQL
SQL
SQL Server
SQL Server Integration Services
Tuning
UML
data mining
ETL
MS SQL
OLAP
SSRS
Database Administration
Data Warehouse
Business Intelligence

Job Details

Role-SQL Database Administrator/Developer

Rate- $60/HR

Location- Remote(SACRAMENTO, CA)

*PST TIMEZONE A MUST; LOCAL CANDIDATES

Position Details-SQL Database Administrator /SQL Developer

IMPORTANT INFO:
DBA candidates must have installed MS SQL server, SSMS, SSIS on their PC/laptop. Any free version for MS SQL server would suffice. Candidate to provide some of the answers by demoing the activity that is being discussed during the Skype interview. Candidate must be able to manage / maintain large production databases.
Interview time: 1 hour

Role Description:
Database Administrator and SQL developer with 7 years of experience and expert-level skill in development, analysis, architecture, design, installation, configuration, operation, and maintenance of information systems hardware and software.
Expert-level skill and knowledge and experience in DDL, DML, Physical and Logical Data Modeling (w/UML), Stored Procedures, DB Index Management, Normalization and de-normalization, Data replication, Reporting, ETL, database design, development, and administration-related concepts, methods, and tools
Expert-level skill and knowledge and experience in Data Warehouse concepts, including data mining, data marts, on-line analytical processing (OLAP), etc.
Expert-level skill and knowledge and experience in Microsoft SQL Server, Business Intelligence Solutions, SQL Server Monitoring/Performance tools, Database security and integrity
Resolve database performance and capacity issues, and replication and other distributed data issues.
Determine and implement appropriate change management policies and processes.
Install, configure, test/benchmark, and maintain the general health of database servers and related infrastructure, monitor system logs for alerts, errors and warnings, and available/free space on the OS and storage volumes, and analyze space usage history and recommend changes as needed.
Create/update documentation for new/existing maintenance and installation processes.
Advanced T-SQL, PowerShell skills.
Deep familiarity with SQL Server tools, e.g. SSMS, SQL Profiler, Database Tuning Advisor, SQL Server Configuration Manager, DMVs, Extended Events, etc.
Proven database maintenance skills (backups, index defragmentation, database integrity checks).
Execute ETL tasks in support of data loads.
Troubleshoot and resolve issues.
Experience with High Availability (HA) and Disaster Recovery (DR) options for SQL Server

Required Skills: Microsoft SQL Server (MS SQL Server);Database Administration; Database Design; Database development; SQL Server Integration Services (SSIS); SQL Server Reporting Services (SSRS)