Adaptive Solutions Group SQL Database Administrator in Overland Park, Kansas

This job was posted by https://www.kansasworks.com : For more information, please see: https://www.kansasworks.com/ada/r/jobs/10779676 Installation, Configuration and administration of database instances on SQL 2008R2, 2014 to 2017.Create ETL ProcessesExperience with SSIS. Development of Enterprise Data Warehouse infrastructure processes for loading data.Maintain mirror databases to provide foundation for disaster recovery.Monitor Backups, taking backups and restoring them depending upon requirements.Monitor customized jobs using to alert the failure of jobs and database server.Day to day monitor of database servers for any errors or failures. Check errors, re-indexing, updating stats etc.Write and debug Complex SQL Queries, Stored procedures & Views.Play a role on Users and Security following the business standards.Set permissions to tables, stored procedures following business security guidelines.Log Shipping, for fail-over.Work on Client/Server tools like SQL Server Management studio 2008R2, 2014, 2017. SQL Server Enterprise Manager (2000) to Administer SQL Server.Perform automatic as well as manual failover.Performance Tuning the SQL Servers & Databases.Install and Configure SQL server 2008R2, 2014, 2017, on Windows advance server and windows systems.Work on Replication and Transactional Replication.Work on Load balancing for the SQL Servers.Role in Database Normalization, Optimization and Tuning, Backup/Restore, Data Import/Export, Troubleshooting, Database Objects authorization, DTS,ETL using DTS(SSIS), Objects Creation such as Tables, Views, User created Data Types, Indexes, Stored Procedures, Cursors, and Triggers.Performance Tuning, Query Optimization, Client/Server Connectivity, Database Consistency Checks using DBCC Utilities.24*7 on call support for Production database