Tagcor

Required Skills

SQL Server Database Administrator

Work Authorization

Us Citizen
Green Card
EAD (OPT/CPT/GC/H4)
H1B Work Permit

Preferred Employment

Corp-Corp

Employment Type

Consulting/Contract

education qualification

UG :- - Not Required
PG :- - Not Required

Other Information

No of position :- ( 1 )
Post :- 17th Sep 2021

JOB DETAIL

• Ability to identify requirements, design/develop data models, logical and physical databases, data dictionaries and schemas.

• Refine and automate regular processes, track issues, and document changes.

• Design and develop database objects, tables, stored procedures, views and triggers in MS SQL Server.

• Design and develop reports using MS SQL Server Reporting Services (SSRS).

• Create and manage ETLs using MS SQL Server Integration Services (SSIS).

• Assist C# developers with complex query development, tuning, and optimization.

• Configure and maintain database servers and processes, monitor system health and performance, ensuring high levels of performance, availability, capacity planning, and security.

• Participate in the development and deployment of the Disaster Recovery Plan.

• Manage the deployment of database scripts in development, test and production environments.

• Develops complex PowerShell scripts

• Maintain C# and SQL application code

• Develops and maintains system documentation.

• Strong communication skills to support all project phases, in particular technical and business requirement discussions.

• Participate in C# and SQL code reviews and walk-throughs.

• Self-motivated, organized, independent, and proactive.

• 5+ years in database design, development, optimization and administration of MS SQL Server.

• 3+ years C#.

• Experience with the installation, configuration and support for MS SQL Server 2012 or newer.

• In-depth knowledge of standard concepts, practices and procedures related to database management and security.

• Experience in proactively monitoring database health, executing maintenance packages, monitoring space and indexing strategy.

• Experience in troubleshooting and resolving database integrity issues, and performance issues.

• Experience with Microsoft Integration Services (SSIS) and Microsoft Reporting (SSRS).

• Experience writing technical documentation.

• Vendor Certification(s) is a plus.

• Experience with ColdFusion is a plus.