Epicareer Might not Working Properly
Learn More
K

SQL DBA

  • Full Time, onsite
  • Key Business Solutions, Inc.
  • Hybrid, United States of America
Salary undisclosed

Apply on


Original
Simplified

SQL DBA

Sacramento, CA

12+ Months

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)

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.
Report this job