Talent.com
Sr SQL Server Functional /Application DBA - 2022
Sr SQL Server Functional /Application DBA - 2022Tech Tammina • New York, NY, United States
Sr SQL Server Functional / Application DBA - 2022

Sr SQL Server Functional / Application DBA - 2022

Tech Tammina • New York, NY, United States
3 days ago
Job type
  • Full-time
Job description

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 jobs
    ObGyn

    ObGyn

    The Inline Group • Long Branch, New Jersey, US
    Full-time
    ObGyn physician job in New Jersey : The Inline Group -.Call Schedule : Varies best on site.Compensation : High earning potential provides financial stability and rewards your focus on quality patien...Show more
    Last updated: 30+ days ago • Promoted
    Sr Statistical R Programmer (North America Only)

    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: 15 hours ago • Promoted • New!
    RN

    RN

    Seabrook Village by Erickson Senior Living • Neptune, New Jersey, us
    Full-time
    Location : Seabrook Village by Erickson Senior Living.The RN promotes, restores, and maintains resident’s health and wellbeing by collaborating with providers, the interdisciplinary team, and care a...Show more
    Last updated: 2 days ago • Promoted
    Server

    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
    Actuarial Applications AVP

    Actuarial Applications AVP

    TEKsystems • Jersey City, NJ, United States
    Full-time
    The Actuarial Applications role will support actuarial technology initiatives and be responsible for data and applications for use across our Actuarial teams. The primary role is to build and deploy...Show more
    Last updated: 7 days ago • Promoted
    ObGyn

    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
    Restaurant Delivery - Sign Up and Start Earning

    Restaurant Delivery - Sign Up and Start Earning

    DoorDash • Fair Haven, US
    Full-time +1
    DoorDash is the #1 category leader in food delivery, food pickup, and convenience store delivery in the US, trusted by millions of customers every day. As a Dasher, you’ll stay busy with a variety o...Show more
    Last updated: 1 day ago • Promoted
    Senior System Administrator

    Senior System Administrator

    ACT Professional Solutions • Paramus, NJ, US
    Temporary
    This is a 6 month temp to perm.The Senior Systems Administrator I plays a vital role within the IT team, ensuring the reliability, security, and optimal performance of the organization's techno...Show more
    Last updated: 14 days ago • Promoted
    Server

    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: 20 days ago • Promoted
    Sr. Sales Manager (26674)

    Sr. Sales Manager (26674)

    Supermicro • New York, NY, United States
    Full-time
    Supermicro is a Top Tier provider of advanced server, storage, and networking solutions for Data Center, Cloud Computing, Enterprise IT, Hadoop / Big Data, Hyperscale, HPC and IoT / Embedded customers...Show more
    Last updated: 30+ days ago • Promoted
    SQL Server DBA with Azure Cloud expertise

    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
    Server

    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
    Banquet Server

    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: 13 days ago • Promoted
    AM Server

    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: 23 days ago • Promoted
    SQL Server DBA

    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: 3 days ago • Promoted
    SQL Server DBA

    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: 3 days ago • Promoted
    Data Migration Consultant (Siebel EIM / Oracle PL / SQL Exp.)

    Data Migration Consultant (Siebel EIM / Oracle PL / SQL Exp.)

    Trigyn Technologies Inc • New York City, NY, US
    Full-time
    Immediate contract opportunity for Data Migration Consultant.Trigyn's direct government client in New York, NY, has an immediate need for a consultant as below. Description of work and skills : • Def...Show more
    Last updated: 19 days ago • Promoted
    Lead ServiceNow Developer / Architect

    Lead ServiceNow Developer / Architect

    Top Tier Investment Company • Middletown, NJ, US
    Full-time
    Hi, This is a Full Time Position Role : Architect / Lead ServiceNow Developer Location : Remote with ACTIVE CSA & CAD certifications Mandatory - Kindly share your resume at sunil.Show more
    Last updated: 25 days ago • Promoted