Vacancy expired!
Description : Manage the development and performance of SQL databases for web applicationsConfigure and maintain database servers and processesEnsure high levels of performance, availability, sustainability and securityDesigns install, upgrade, monitors, maintains and conducts performance tuning procedures in a production MS SQL Server database environment while ensuring high levels of data availability. Develops, implements and oversees SQL Server database policies and procedures to ensure the integrity and availability of databases and their accompanying software. Create, maintain and execute scheduled jobs, data extracts, data refreshes, data loads and data replication.Perform data modeling and optimization, preliminary data received from customer designs, data analysis, report writing from existing data using SQL (Structured Query Language) queries, and creation of new records and information updates as needed.Diagnose and troubleshoot database errors.Create automation for repeating database tasks.Troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, connectivity issues, security issues, etc. Basic Qualification: Minimum with 6+ years of technical experience in SQL Server similar Application support or Development environmentKnowledge and strong experience and understanding of database structures, theories, principles, and practices. Strong experience with SQL Server 2012 and 2016Knowledgeable of T-SQL (Indexes, Triggers, Functions, Packages and Procedures)Familiarity with SSAS, SSIS, SSRSStrong Experience in High availability (Always On, cluster environment)Strong knowledge of backups, restores, recovery modelsStrong communication, interpersonal and human relations skills to interact with clientsStrong analytical and problem-solving skillsAbility to work collaboratively on multi-disciplinary teams
- ID: #21618886
-
State: Virginia
Mclean
20598
Mclean
USA
- City: Mclean
- Salary: Depends on Experience
- Job type: Contract
- Showed: 2021-10-24
- Deadline: 2021-12-09
- Category: Et cetera