• US Citizen

• Green Card

• EAD (OPT/CPT/GC/H4)

• H1B Work Permit

• Corp-Corp

• W2-Permanent

• W2-Contract

• Contract to Hire

• Consulting/Contract

• UG :- - Not Required

• PG :- - Not Required

• No of position :- ( 1 )

• Post :- 28th Mar 2025

• Credit Suisse is seeking consultants that will participate on a Global' DBA team. The team 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 remove indexes.
• When users complain about the performance of a particular query, help developers improve the performance of that query by tweaking it or modifying indexes.
• 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:

1) Writing and improving SQL Server T-SQL queries for at least a year. You will be known amongst the office as the go-to person for T-SQL 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 sp BlitzIndex® and DMV queries to answer questions about index usage.

5) On-call troubleshooting for SQL Server service outages.

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