| Duties & Responsibilites : | 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 ActiveActive 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
|
