SQL Database Administrator /SQL Developer --Carmichael, CA-- Local to CA -- W2 only - 12+ Months

SQL Database Administrator /SQL Developer --Carmichael, CA-- Local to CA -- W2 only - 12 Months

Role Information:

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 ZOOM interview. Candidate must be able to manage / maintain large production databases.

Job 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)

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.