Sr. SQL DBA
Responsibilities · Administration and support on 150+ SQL Server instances in multiple data centers including Production and Test Environment · Perform SQL Server installations, upgrade and patches in multi-nodes Windows cluster environments. · Perform database performance analysis, tuning and disaster recovery · Configure database backup and perform backup/recovery testing. · Provide technical recommendation and database support on assigned projects with different vendors, application support and Windows admin group. · Provide DBA support on existing SQL Server environments including change management, code releases, breakfixes and (7X24) on call support · Work with Enterprise Monitoring team to configure and review database monitoring. Technical Skills & Experience · 5-7 years experience as production SQL Server DBA in enterprise environment · Practical and solid experience with SQL 2000, SQL 2005, 2008 and 2008 R2 in multi-nodes Windows clustering environments · Must have recent hands on experience within last 6 months with Active\Active SQL Server installation or add node installation in Windows clustering environments with more than 2 nodes · Extensive experience in T-SQL, Replication, Clustering, Database Mirroring, Log Shipping, Backup and Recovery, High Availability, SSIS/SSAS/SSRS, DTS, SQL Jobs, linked servers, SQL Profiler, PerfMon, Policy Based Management and SOX audit · Knowledge of migrating databases residing on servers in one data center to another and upgrading database platforms to newer versions · Experience in the Database Design, analysis, development, administration and support of SQL Server in Production, QA, Test and Development environments · Experience in install, patch, configure, monitor, maintain, and performance tuning on production databases · Experience with supporting large database over 1 TB a plus · Experience working in secure DMZ's with multi tiered architecture in a distributed environment. · Good Knowledge in DB monitoring Tool such as HP Openview and Idera a plus · Good Knowledge to setup Policy Base Management with PowerShell Script · Good Knowledge to install and performance troubleshooting on SQL Server Reporting Services in scale out deployment · IDERA Diagnostic Manager · SQL Server Analysis Service Good understanding of the general firewall configuration concepts
Related projectsSearch for freelance jobs
can’t wait for more clients
and advertising. Thank you."