Home > Las Vegas jobs > Las Vegas computer/technical

Posted: Monday, February 5, 2018 9:57 PM

Title: SQL DBALocation: Las Vegas, NVDIRECT HIRESalary: $100,000 - $115,000/year + Great BenefitsJob Summary:The SQL DBA role largely responsible for providing operational database services to the organization.Some of the primary responsibilities of this role would include owning, tracking and resolving database related incidents and requests, fulfilling requests and resolving incidents within SLAs, reviewing service related reports (eg: database backups, maintenance, monitoring) on a daily basis to ensure service related issues are identified and resolved within established SLAs, responding to database related alerts and escalations. Job Functions: Expertise in database structure design and database administration. Administer production, test and development SQL Server databases on Windows platforms Proficient in complex query analysis and tuning Strong experience creating and maintaining Views, Stored Procedures and System Functions in MS SQL Server (mix of 2005, 2008, 2012, 2014, 2016) Experience in troubleshooting and resolving database integrity, performance, blocking and deadlocking, replication, log shipping, SQL Clustering, connectivity and security challenges Create and maintain reports with SQL Server Reporting Services (SSRS) Experience with SQL Server Integration Services (SSIS) Monitor database performance and tune databases when necessary Experience with implementing SQL Server Always On availability groups Experience managing database roles, users and permissions Ensure the databases are highly secure, available, and recoverable Install, configure, and patch database software and complete database migrations and upgrades Support web application development, focusing on helping the team interact with the database efficiently Provides technical assistance and mentoring to lower level associates.Qualifications: Bachelor s degree in Computer Science or related area 7-9years of experience with Database Administration for MSSQL Server. Strong understanding of MS SQL Server (mix of 2005, 2008, 2012, 2014, 2016) Intimate knowledge and demonstrable expertise with database planning Record of solid operations management Troubleshooting skill and ability to coordinate with systems staff Must have the ability to communicate effectively with all levels of management and technical staff Contributes to a positive team environment Experience in troubleshooting and resolving database problems. Experience in Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools. Experience with Microsoft Replication design, implementation and support. Experience with Microsoft SQL Server Always On availability groups - design, implementation and support. Experience with backups, restores and recovery models. Knowledge of High Availability (HA) and Disaster Recovery (DR) options for MSSQL Server. Experience in implementing operational automation using scripts. Knowledge of indexes, index management, and statistics. Experience working with Windows server, including Active Directory and proper disk configurations. Good communication and documentation skills. Willingness to work in an on-shore & Off-shore environment Proven record of good judgment in solving problems and handling technical challenges Ability and desire to work with technical and non-technical people Excellent written and verbal communication skills Customer service acumen and effective company communications Self-motivated and willingness to work long hours and off-hours


• Location: Las Vegas

• Post ID: 40644742 lasvegas is an interactive computer service that enables access by multiple users and should not be treated as the publisher or speaker of any information provided by another information content provider. © 2018