Home > Dallas jobs > Dallas computer/technical

Posted: Wednesday, September 6, 2017 5:13 PM

TITLE: Sr. SQL Server, Production DBAResponsibilitiesInstallation, administration and maintenance of standalone and clustered SQL Server database instances in development, testing, staging and production environments.Apply data modeling techniques to ensure development and implementation support efforts meet integration and performance expectations.Create users and assign permissions based on authorized level of access.Design database backup and restoration strategy. Monitor to ensure backups are done regularly. Recover database to specific point of time per the requests or during outages.Configure high-availability as part of a disaster recovery strategy for the databases.Proactive monitoring and performance tuning from physical server level, db level and query tuning.Refine and automate regular processes, track issues, and document changesAutomate monitoring with Spotlight, System Center Operations Manager (SCOM) or other tools.Ensure data and databases are fully secured and comply with PCI regulations.Establish and maintain best practices and operational procedures and generally provide guidance on SQL Server operation.Qualifications8+ years in MS SQL Server Administrator experience in a production environment supporting consumer focused applications.Strong knowledge in database backups, restores and recovery models.Experience with SQL replication that includes Availability Group (AG), mirroring, log shipping, maintenance plans and DR recovery strategies.Strong database performance tuning and optimization, using native monitoring and troubleshooting tools that includes Profiler, Index Tuning Wizard, Dynamic Management Views and Functions (DMVs) and other third party tools.Strong experience with enterprise monitoring tools. Spotlight and Systems Center Operations Manager (SCOM) is a plus.Experience with T-SQL stored procedures, functions and Powershell scripts to automate processes and improve system performance.Knowledge of data mapping with logical and physical data modeling.Experience with local and SAN data storage for SQL Server databases. Working experience with physical and virtual servers.Experience with Windows Server 2008 and Windows Server 2012Strong understanding of database clusteringPREFERRED:Microsoft SQL Server certification(s) is a major plus.Experience with AWS, Azure or other cloud solutions is desirable. Experience with Couchbase is preferred.Lead or former mentoring experienceFamiliarity with Dell Compellent and HPE 3PAR storage is highly desired.Experience with SQL Server 2014Direct Hire PositionUnable to sponsor H1b visasNo third party firms - provided by Dicems sql, availability group, dr recovery, dmv, scom, t-sql, database clustering, aws, azure, couchbase, Dell Compellent, HPE 3PAR


• Location: Dallas

• Post ID: 65497092 dallas 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. © 2017