Skip to Main Content

Senior SQL Database Administrator

CardinalHire
Jersey City, NJ
  • Posted: over a month ago
  • $80 to $90 Hourly
  • Contractor
Job Description

Skills Need:
Must have 4 + years of ‘Recent’ Banking experience (With in the last 6 years) in the US.
Minimum of 10+ years experience working as a SQL Server DBA.
Must have experience working with DB’s on average of 30TB plus.
Must have experience as an Funtional & 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 / 17.
SSIS Package creation and debugging skills.
Stored procedure development and tuning.
Data replication exposure.


The Job:
BNP is seeking senior consultants to work for there Global database unit. Must have recent experience working with DB sizes of 30TB’s or larger.
The consultants 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 o 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.
 

CardinalHire

Address

Jersey City, NJ
USA

Industry

Technology

View all jobs at CardinalHire

What email should the hiring manager reach you at?

By clicking the button above, I agree to the ZipRecruiter Terms of Use and acknowledge I have read the Privacy Policy, and agree to receive email job alerts.