*SQL Server DBA* *Hartford, CT*
*6 Months* *Professional Summary* • 8 years of experience in Database Administration using MS SQL Server 2012/2008 R2 /2005. • Expert Level skills in providing 24x7 DBA Level 3 support in Production, QA and Development. • Day-to-day monitoring and maintenance, problem investigation and resolution, SQL and database optimization and tuning, analyzing, and recommending patches, upgrades, and new technologies surrounding all aspects of data management using relational databases. • Excellent working skills in MS SQL Server business intelligence tools SSIS, SSRS and SSAS. • Performed and designed Data Center Migration and Disaster recovery Solutions. • Knowledge working with Windows, SQL, IIS, NLBS Clustering, SAN and infrastructure. • Migration experience with multiple databases/servers from SQL 2000, 2005, SQL 2008R2 and SQL 2012. • Design, Architect and capacity planning OLTP or OLAP requirements. • Experience Administration of Heterogeneous RDBMS like SYBASE, MySQL, Oracle using Third Party tools like DBArtisan, Toad etc. • Experience and Knowledge on HA/DR like log shipping/Mirroring/Clustering & Replication. • Designed and Configured Partitioning of Tables and Indexes to Improve query performance in SQL 2008 R2/SQL 2012 especially considering memory limitations. • Experience managing Onsite & Off shore team. • Implemented Latest Features like Data Compression and Backup compression reducing I/O and Transparent Data Encryption for encryption in SQL 2008 R2 Resource Governor and policy based management. • Well Experienced in Performance Tuning (System level/Database Level/Query Level) and optimization. • Experience in working with DTS/SSIS (ETL) in SQL, 2000, 2005 and with SSRS 2005, 2008, 2012. • Extensive experience in SDLC in developing an application, with Installation, design, architecture, data flow, Maintenance and Operations of a system. • Thorough understanding of blocking/lock issues, Tempdb Optimization, Filegroup management and Catalog views. • Experience of Export/Import Database Objects / Tables /data using DTS and SSIS packages. • Experience in working with VLDB databases up to 16TB, Managing Backups, Disk & Drive Space issues, managing indexes, Partitioning, compression, free space etc. • Hands on experience with TFS and SharePoint. • Experience in Installation and configuration of SSRS, SSIS and SSAS servers. • Thorough understanding of tools like Solar winds DPA, Perfmon, SQL Profiler, DTA, DB Artisan, LiteSpeed , SQL sentry etc. -- You received this message because you are subscribed to the Google Groups "Citrix and Sap problems" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/citrix-and-sap-problems. For more options, visit https://groups.google.com/d/optout.
