Job Description :
Hi,
Hope you are doing well.
Please find the job description below and let me know your interest.
Position: SQL Server DBA
Location: Jersey City, NJ
Duration: 6+ Months
Mode of Interview: Phone and F2F
Job Description:
· 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