Tech Tammina
Sr SQL Server Functional /Application DBA - 2022
Tech Tammina, New York, New York, us, 10261
Title: Sr SQL Server Funtional /Application DBA V2014 - 2022Work Location: New YorkOnsite
Skills Need: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).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 datatypes3) Using Profiler traces and other tools to find the most frequently run queries.4) 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.
Skills Need: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).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 datatypes3) Using Profiler traces and other tools to find the most frequently run queries.4) 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.