SQL Lead

Compensation

: $94,330.00 - $148,460.00 /year *

Employment Type

: Full-Time

Industry

: Information Technology



Loading some great jobs for you...





The level of expertise are as follows: 1 - Beginner 2 - Intermediate 3 - Expert Responsibilities: Deployment (Level 2) Deploy SQL scripts, schema changes Deploy data imports, data manipulation, data migration Deploy data quality fixes Automate the deployment process Backups (Level 2/3) Setup/maintain/monitor Database/TLog backups Automation of backup/restores/validation Monitoring (Level 2) Monitor database health (e.g. CPU, memory, disk, etc.) Monitor backup, restore and validation processes Monitor general Database environment counts (e.g. file size, free space, remaining identity values, etc.) Monitor performance Log shipping monitoring AG monitoring Performance Optimization (Level 2/3) Optimize query and database performance Providing solution to increase overall performance (new SQL feature, hardware, etc.) Database Architecture (Level 2/3) Physical layout of database files and filegroups Design/Implement Table structure, location, partitioning Design/Implement Indexes, Constraints, Keys, Data Types, Column Store Indexes Design/Implement database environments upgrades Handle/Troubleshoot production issues (Level 1/2/3) Analyze/identify/resolve database production issues Analyze/identify/resolve backup/restore issues Analyze/identify/resolve Log shipping issues Analyze/identify/resolve availability groups issues Analyze SQL Server/Windows logs Analyze Database performance issues Analyze/identify/resolve concurrency, locking, blocking and deadlock issues Forensic analysis Scripting (Level 2/3) Writing scripts including TSQL, powershell, batch files Review TSQL scripts (correctness, conventions, performance, etc.) Development Environment (Level 1/2/3) Update staging environment and databases Database localization Test pre deployment database changes Test new feature Capacity planning (Level 2/3) Storage CPU New Server/Equipment (Level 2/3) Specing hardware requirements Hardware evaluation/benchmarking (CPU, Memory, Storage, etc.) Hardware performance testing Migrating a server from old machine to a new machine Storage capacity planning Storage evaluation/setup UpdatesPatching (Level 2) Perform SQL server patching on scheduled basis, the task includes the following steps Review the pending patches and notify the development if there is a risk for applications/services Verify that same patches were installed and tested on the Live-test environment Schedule time for patching Perform sanity test of the applications/services after the updates were done Production Contact (Level 1/2/3) Contact Rackspace when there is an issue or change (e.g. SQL backups, patching) Be a contact for Rackspace when they found an issue Monitor rackspace Alerts/Monitoring tools Monitor rackspace backups High availability/Failover (Level 2/3) Design and implement a solution for high availability/failover when some servers go down Implement/Maintain availability groups Documentation and defining SLAs Periodically test the solution Disaster Recovery (Level 2/3) Design and implement a solution for disaster when some servers go down Implement/Maintain Log shipping Documentation and defining SLAs Periodically test the solution Documentation (Level 1/2) Create and maintain a documentation of all the Database related components for example Document all the equipment Document all the services Document all the SQL Agent Jobs Runbooks for production deployment/patching Build document for new installation Requirements: Minimum 5+ years of experience as a DBA/SQL Developer in a production OLTP environment Experience in SQL server installation/administrations/updates/upgrades (2016) Strong experience with T-SQL Powershell (3 or later) Ability to evaluate server/storage hardware, RAID configurations Good knowledge of windows administration (2016) Experience in troubleshooting and optimizing query execution plans and performance Experience in troubleshooting concurrency, locking, blocking and deadlock issues Experience with log shipping Experience with availability groups (advantage)Salary Range: $110K - $130KMinimum Qualification5 - 7 years
Associated topics: data administrator, data analytic, data architect, data engineer, data integrity, data quality, data warehousing, etl, sybase, teradata * The salary listed in the header is an estimate based on salary data for similar jobs in the same area. Salary or compensation data found in the job description is accurate.

Launch your career - Create your profile now!

Create your Profile

Loading some great jobs for you...