Sr SQL Server Funtional Application DBA

LOCATION : 26th Street Madison Ave New York (Onsite Role)

Only GC / USC

ALL CANDIDATES WILL BE TECHNICALLY SCREENED VIA AN AI BEFORE SUBMITTAL TO CLIENT.

MUST HAVE :

• Must have recent experience performing Level 3 support (The highest level Support).
• Must have a Minimum of 10 years conducting general database administration tasks (e.g. DB implementation DB code deployments DB backups creation of DB user accounts).
• Minimum of 7 years experience working as a SQL Server DBA.
• Must have experience as an Functional & Application DBA.
• Must have at least 5 years administering database platform specific advanced features (e.g. clustering encryption logical / physical standby ETL replication) and performance optimizing server database servers and SQL code.
• Minimum of 5 years experience working in a SQL DBA Role with multiple databases and SQL development issues.
• Proficient in MS SQL Server.

Additional Requirements :

Job Description :

1) Writing and improving SQL Server TSQL queries for at least a year. You will be known amongst the office as the goto person for TSQL questions.

2) Designing tables and picking datatypes Using Profiler traces and other tools to find the most frequently run queries.

3) Using free tools like spBlitzIndex and DMV queries to answer questions about index usage.

5) Oncall troubleshooting for SQL Server service outages.

6) Deciding whether clustering log shipping mirroring replication etc are the right fit to solve a business problem.

Skills Need :

Key Skills

Employee Relations,Forecasting,Information Technology Sales,Account Opening

Employment Type : Full Time

Experience : years

Vacancy : 1