SQL Server DBA
Toyota Motor Sales USA Inc
Contract Georgetown, Kentucky, United States Posted 5 years ago
About Position
SQL Server DBA (Contract)
$55.00 / Hourly
Georgetown, Kentucky, United States
SQL Server DBA
Contract Georgetown, Kentucky, United States Posted 5 years ago
Description
As the SQL Database Administrator, you will be responsible for performing both advanced and all general database administration functions including overall database and system design, database installs including upgrading and patching, backup and recovery, security, performance tuning, troubleshooting and developing replication strategies on clustered and nonclustered environments for high availability and disaster recovery. Troubleshooting and developing Reports and Packages using SSRS and SSIS. Responsibilities Knowledge and experience in SQL Server architecture and system design on latest versions of SQL Server editions like SQL 2018, SQL 2012, SQL 2014, SQL 2016. Proficient in SQL Server database administration install, configure, upgrade, patching, and migration of existing databases. Experience in implementing and maintenance of SQL Server replication. Strong knowledge of backups, restores, recovery models, database shrink operations and other database deployment models including Clustering, and AlwaysOn. Significant experience with modern data analytics infrastructure, such as MS SQL Server Integration Services and Reporting Services. Experience in creating, implementing and troubleshooting skills in SSRS & SSIS packages. Experience in data migration using DTS and SSIS services across SQL Server & flat files. Assist in formalizing and updating database policies, procedures, and technical standards, including disaster recovery planning. Help architect and implement solutions that solve complicated application challenges, including application performance, scalability, and security. This includes schema, index and key design and enterprise application architecture. Serve as an escalation point for any defined database issues regarding performance, security, or ongoing maintenance. Good understanding of Virtualization environment. Strong experience in Database Administration in using data modeling, ETL, migration and administration toolsets. Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using DBCC Utilities. Skills and Qualifications Strong proficiency in SQL Server database administration with 7+ years of experience as a SQL DBA in a high traffic, transactional environment. SQL DBA experience in a 24x7 production environment. Excellent analytical and problemsolving skills. High critical thinking, ability to evaluate alternatives and present solutions that are consistent with business objectives and strategy. Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues and security issues. Ability to detect and troubleshoot Database Server related CPU, memory, I/O, disk space and other resource contention. Strong knowledge of how indexes, index management, integrity checks, configuration, patching, statistics works and how indexes are stored, how they can be created and managed effectively. Documentation skills for processes and procedures (creating KBs, runbooks, topology). Makes technical presentations to external and internal customers. Excellent communication skills.
By applying to a job using PingJob.com you are agreeing to comply with and be subject to the PingJob.com Terms and Conditions for use of our website. To use our website, you must agree with the Terms and Conditions and both meet and comply with their provisions.