Senior SQL Server DBA

13 Nov 2024

Vacancy expired!

Position: Senior SQL Server DBA

Location: New York, NY

Duration: 1 + Year

Rate: $Open/Hour

Number of positions: 3

Start Date: ASAP

Job Description:Our client is seeking consultants that will ensure that the new database code meets company standards for readability, reliability, and performance.Each week give developers a list of the top 10 most resource-intensive queries on the server and suggest ways to improve performance on each.Design indexes for existing applications, choosing when to add or removeindexes.When users complain about the performance of a particular query, helpdevelopers improve the performance of that query by tweaking it or modifyingindexes.Conduct SQL Server lunch-and-learn sessions for application developers.Advise developers on the most efficient database designs (tables, datatypes, stored procedures, functions, etc).

Consultant must have experience:Writing and improving SQL Serverm T-SQL queries for at least a year. You will be known amongst the office as the go-to person for T-SQL questions.Designing tables and picking datatypesUsing Profiler traces and other tools to find the most frequently run queries.Using free tools like spBlitzIndex® and DMV queries to answer questions aboutindex usage.On-call troubleshooting for SQL Server service outages.Deciding whether clustering, log shipping, mirroring, replication, etc are theright fit to solve a business problem.

Skills Need: Must have 10+ years of experience working for US companies.Must have 4 + years of ‘Recent’ Banking experience.Must have recent experience performing Level 3 support (The highest- level Support).These positions are for a ‘Global’ unit. Consultants must have experience working ‘Constantly’ with DB’s of 30TB or more (Not Less).Experience working with large-scale enterprise application setup across Data centres.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 10+ years’ experience working as a SQL Server DBA.SQL Server DBA V2008 to 2016Must 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 experience.Proficient in MS SQL Server 2008 - 2016.SSIS Package creation and debugging skills.Stored procedure development and tuning.Data replication exposure.Please send your resume in word format to following details to , or call me @ Name in Full:Contact Details:Email ID:Current Location:Relocation:Availability:Expected Billing Rate:Work Authorization:LinkedIn Profile:DOB(Month and Day):Zip Code:Skype ID:Employer Details if Any:

  • ID: #22667526
  • State: New York New york city 10001 New york city USA
  • City: New york city
  • Salary: Depends on Experience
  • Job type: Contract
  • Showed: 2021-11-13
  • Deadline: 2022-01-11
  • Category: Software/QA/DBA/etc