Multiple Requirements: .Net Developer(TX) & SQL DBA(TX, Locals Only for F2F Interview)
Manish Gupta
Role : .Net Developer
Work Location : Houston, TX
Duration of assignment (in Months) : 8 months
Relevant Experience(in Years): 6-8 Years
Role Description:
Business requirement document preparation.Net code changes Offshore Coordination
Essential Skills
Core .Net Experience is system analysis/Business requirements gathering Exposure to financial and treasury management systems. Experience working on application integration/interfaces Good communication skills
Urgent Requirement: SQL Server DBA (TX, Face to Face Interview)
Role : SQL Server DBA
Work Location : Grapevine, TX
Duration of assignment (in Months) : 6-12 months
Local Resumes Only
Face to Face Interview
Role Description:
· Strong experience in Database Administration in SQL Server (2014, 2012 and 2008R2)
· Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues etc.
· Experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools.
· Ability to detect and troubleshoot SQL Server related CPU, memory, I/O, disk space and other resource contention.
· Strong knowledge of backups, restores, recovery models, database shrink operations, DBCC commands, Clustering, Database mirroring, Replication.
· Expert experience in implementing operational automation.
· Strong knowledge of how indexes, index management, integrity checks, configuration, patching. How statistics work, how indexes are stored, how they can be created and managed effectively.
· Knowledge of SQL Server tools ( Profiler, DTA, SSMS, SAC, SSCM, PerfMon, DMVs, system sprocs)
· SQL Development – ability to write and troubleshoot SQL Code and design ( stored procs, functions, tables, views, triggers, indexes, constraints )
· Solid acquaintance with windows server, security delegation, SPNs, storage components.
· Documentation skills for processes and procedures ( creating KBs, runbooks, topology etc )
· SQL Database Operational support to tech users
· Experience in extracting and transforming data between homogenous and heterogeneous systems using dynamic DTS packages, IMPORT/EXPORT, BULK Insert, BCP and XML Technologies.
· Experience in developing DTS Packages and migrating DTS Packages to SSIS Packages.
· Experience in developing Capacity Planning Reports and involved in SQL Server Consolidation projects
· Experience in Automating Administration tasks and Database Maintenance Tasks.
· Support SQL Reporting Services