Title : Sr SQL Server Funtional / Application DBA V2014 - 2022
Work Location : New York
Onsite
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 datatypes
3) 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.
Create a job alert for this search
Sql Server Dba • New York, NY, United States
Related searches
Related jobs
Senior Financial Analyst
Vaco by Highspring • Red Bank, NJ, US
Full-time +1
Senior Financial Analyst – SaaS Industry.We are partnering with an innovative, high-growth organization in the SaaS industry to hire a.
This is a strategic role that will support financial planning ...Show more
Last updated: 14 days ago • Promoted
Sr Statistical R Programmer (North America Only)
Syneos Health / inVentiv Health Commercial LLC • New York, NY, United States
Full-time
Sr Statistical R Programmer (North America Only).Syneos Health is a leading fully integrated biopharmaceutical solutions organization built to accelerate customer success.We translate unique clin...Show more
Last updated: 2 days ago • Promoted
Sr. Data Engineer
Equinox • New York, New York, United States
Full-time
Equinox Group is a high growth collective of the world's most influential, experiential, and differentiated lifestyle brands.
We restlessly seek what is next for maximizing life - and boldly grow th...Show more
Last updated: 30+ days ago • Promoted
Server
Castell's • Brooklyn, NY, US
Full-time
Castell’s is looking for a server with sharp attention to detail, fast hands, and a professional, hands-on approach to service.
Someone who works clean, moves with intention, and is never abov...Show more
Last updated: 30+ days ago • Promoted
Travel CT Tech - $2464 / Week
SambaTraveler • Neptune, NJ, US
Full-time
SambaTraveler is seeking an experienced CT Tech for an exciting Travel Allied job in Neptune, NJ.Shift : 5x8 hr PMs Start Date : ASAP Duration : 19 weeks Pay : $2464 / Week.
Working in healthcare, your ...Show more
Last updated: 2 days ago • Promoted
ObGyn
CompHealth • Little Silver, New Jersey, US
Full-time
ObGyn physician job in New Jersey : Come practice in Little Silver in eastern Monmouth County.It is located along the banks of the Shrewsbury River, and only 4 miles from the Atlantic Ocean.It has ...Show more
Last updated: 30+ days ago • Promoted
Server
Harta at Grayson Hotel • New York, NY, US
Full-time
HARTA - BAR HARTA WINE TERRACE - BAR CIMA - TACALLE.Located steps from Bryant Park in the heart of New York City, HARTA, BAR HARTA WINE TERRACE, BAR CIMA, and TACALLE are immersive escapes within T...Show more
Last updated: 30+ days ago • Promoted
Server
Bistro29 • New York, NY, US
Full-time
European restaurant located in the heart of.An ideal candidate is someone who : .Appreciates modern European and French-inspired cuisine.
Is passionate about creating warm, memorable guest experiences...Show more
Last updated: 21 days ago • Promoted
Server
Sunrise Senior Living • Lincroft, NJ, US
Full-time
When you join Sunrise Senior Living, you will be able to use your unique skills to empower residents to live longer, healthier, and happier lives.
Not only will you build meaningful relationships wi...Show more
Last updated: 30+ days ago • Promoted
SQL Server DBA with Azure Cloud expertise
InterSources • New York, NY, United States
Full-time +1
SQL Server DBA with Azure Cloud expertise.Duration : 12 Months Contract Position.Database technical design, storage configuration, space management, backup and recovery, disaster recovery, troublesh...Show more
Last updated: 30+ days ago • Promoted
Senior Database Administrator / Data Engineer
DistroKid • New York, NY, United States
Full-time
DistroKid is the world’s largest music distributor to Spotify, Apple, Google and more.Most new music today is released through DistroKid.
Help us help millions of musicians be more prolific!.IMPORTA...Show more
Last updated: 30+ days ago • Promoted
Banquet Server
Cosmopolitan Club • New York, NY, US
Part-time
On-Call Banquet Server ($24 / hr).We are seeking professional, reliable.This role supports a variety of high-end events, including weddings, corporate functions, galas, and private celebrations.Ideal...Show more
Last updated: 15 days ago • Promoted
Associate Data Analyst
Sagesure • Neptune City, New Jersey, United States
Full-time
SageSure, a leader in catastrophe-exposed property insurance, is seeking a.This is a great opportunity for an early-career analyst to build hands-on experience with enterprise data systems, reporti...Show more
Last updated: less than 1 hour ago • Promoted • New!
AM Server
Zero Bond • New York, NY, US
Full-time
Join Our Morning Service Team at Zero Bond!.A place like no other - Re-imagine the experience of membership with the opportunity to belong to an eclectic and stellar community; that is the Zero Bon...Show more
Last updated: 25 days ago • Promoted
SQL Server DBA
APN Consulting • New York, NY, United States
Temporary
IT staffing and services company offering innovative business solutions to improve client business outcomes.We focus on high impact technology solutions in ServiceNow, Fullstack, Cloud & Data, and ...Show more
Last updated: 4 days ago • Promoted
SQL Server DBA
Tachyon Technologies • New York, NY, United States
Full-time
We are seeking a highly skilled and experienced SQL Server Database Administrator (DBA) to manage, maintain, and ensure the optimal performance, availability, and security of our critical SQL Serve...Show more
Last updated: 4 days ago • Promoted
Server
Libbi • New York, NY, US
Full-time
Now Hiring : Servers for Our New Restaurant.We’re looking for strong, committed, and professional candidates to join our team as Servers.
Prior serving experience in a fast-paced, high-standard...Show more
Last updated: 30+ days ago • Promoted
Remote Database Architects (Professional, Scientific, and Technical Services) - AI Trainer ($100-$180 per hour)
Mercor • Hackensack, New Jersey, US
Remote
Full-time
Mercor is recruiting • •Database Architects who work in the Professional, Scientific, and Technical Services • • as independent contractors working on a research project • •for one of the world’s top A...Show more