*Role: SQL Server Application DBA (Face to Face interview)* *Location: Arlington VA. * *Duration: 12 Months* *2 Openings* *Must be Citizen or Green card holder. * *Mode of Interview Skype and In Person.*
*Role Overview: * This is a SQL Server Application DBA role primarily responsible for providing DBA support services to the corporate IT organization including development, testing and production environment. This role requires a solid knowledge of SQL and Transact SQL in order to perform review analysis of stored procedures or views created or modified during development life cycle and to provide performance tuning recommendations as needed. In addition, this role requires in-depth knowledge and experience in ETL development life cycle including design, development and support (batch process and asynchronous ETL) using SQL Server Integration Services (SSIS). Other responsibilities include owning, tracking and resolving database-related incidents and service requests, fulfilling service requests and resolving incidents within SLAs, reviewing service-related reports and logs (database backups, maintenance, monitoring, etc.) on a daily basis to ensure service related issues are identified and resolved within established SLAs. It also includes responding to database-related alerts and escalations and working to come up with strategic solutions to recurring problems. This role requires a service-oriented mentality, high sense of ownership of the problems and requests assigned, focus on managing and resolving issues in alignment with the SLAs. In addition, the role requires communicating with technology customers to keep them updated with status of their requests and performing database changes on production systems and proactively escalating any issues that cannot be resolved within the established timeframes. *Skills Required / Position Requirements:* • 4+ years of experience in database development and production support in SQL Server 2008 R2 and/or SQL 2012. • Strong experience in SSIS development, data profiling and supporting data warehouse. • Strong experience in writing SQL -- ability to write and troubleshoot SQL code and design (stored procedures, functions, tables, views, triggers, indexes, constraints, etc.) • Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, log shipping issues, connectivity issues, security issues etc. • Experience in performance tuning, query optimization, performance monitoring, SQL Profiler and other related monitoring and troubleshooting tools. • Ability to detect and troubleshoot SQL Server performance related issues such as CPU, memory, disk I/O and other resource contention. • Strong knowledge of backups, restores, recovery models, database shrink operations, DBCC commands, clustering and database mirroring. • Strong knowledge of index management, integrity checks, configuration. *Mazhar Khan* *||Tel: 703-962-7227 X 427 || Fax: 703-439-2550 || * *Email: maz...@gsquire.com <maz...@gsquire.com>* *Gsquire Business Solutions Inc || www.gsquire.com <http://www.gsquire.com> || 4229 Lafayette Center Dr , Suite #1625, Chantilly, VA 20151Women Owned Small Business / MBE / SWAM Certified* -- You received this message because you are subscribed to the Google Groups "Business_Intelligence" group. To unsubscribe from this group and stop receiving emails from it, send an email to business_intelligence+unsubscr...@googlegroups.com. To post to this group, send email to business_intelligence@googlegroups.com. Visit this group at https://groups.google.com/group/business_intelligence. For more options, visit https://groups.google.com/d/optout.
