Tagcor

Required Skills

Sr SQL Server Functional Application DBA

Work Authorization

US Citizen
Green Card

Preferred Employment

Corp-Corp
W2-Permanent
W2-Contract
Contract to Hire

Employment Type

Consulting/Contract

education qualification

UG :- - Not Required
PG :- - Not Required

Other Information

No of position :- ( 1 )
Post :- 27th Jan 2024

JOB DETAIL

•Must have 8+ years of experience working for US companies in the US.

•Must have 4 + years of ‘Recent’ Banking experience (Since 2017).

•Must have recent experience performing Level 3 support (The highest level Support).

•These positions are for a ‘Global’ unit. Consultants must have experience (Constantly and On Average) working with DB sizes of 30TB or more (Not Less).

•Experience working with large-scale enterprise application setup across Data centers.

•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 2014 - 2019.

•SSIS Package creation and debugging skills.

•Stored procedure development and tuning.

•Data replication exposure.

The JOB:

•Client 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).