Job Description :
Position: SQL Server DBA
Location: Jersey City, NJ
Duration: 6+Month
Phone and Face-to-Face
Basic Requirements:
Experience with Microsoft SQL Server 2008, 2012, & 2016
Experience in data base design for data integrity, performance and capacity.
Knowledge of the SQL language and its capabilities.
Ability to analyze SQL and provide recommendations (tuning, tables, views, triggers, indexes, constraints, and etc
Experience in tuning and best practices.
Experience in application (e.g., timeouts, deadlocks, etc and server troubleshooting.
Advanced knowledge of SQL Server components (Extended Events, SSIS, etc
Ability to automate routine processes with .NET or PowerShell
Experience with installation, configuration, support, and tuning of different complex Microsoft SQL Server installations and setups (Failover Clusters Instances, Local Availability Groups, Multi-site Availability Groups, etc
Strong understanding of monitoring implementations and administration
Past experience in Incident Management and good understanding of SOX compliance
Good communication skills
Ability to collaborate in a team
Someone who takes initiative instead of waiting for work to be assigned.
Someone who participates in discussions and who isn''t afraid to have and state opinions.
Ability to pick-up other Relational Database Technologies
Nice to have:
Familiarity with working on Cloud platforms such as Amazon Web Services
Experience with Transparent Data Encryption (TDE)
Experience in Managing a Multi-Site (Active-Active) Environment
Experience with No-SQL Databases (MongoDB, ElasticSearch, Cassandra, etc