Apply Now

Sr SQL Functional/Application DBA

New York, NY, US • Posted 11 hours ago • Updated 11 hours ago

Full Time

No Travel Required

On-site

Depends on Experience

DyaTech LLC

Fitment

Dice Job Match Score™

🫥 Flibbertigibetting...

Job Details

Skills

Banking
Clustering
DMV
Transact-SQL
Writing
Microsoft SQL Server DBA
Extract, Transform, Load
Microsoft SQL Server
Debugging
Encryption
Enterprise Software
Data Centers
Database
Database Administration
Log Shipping
Microsoft SSIS
Mirroring
Replication
Servers
Stored Procedures
SQL

Summary

Work Location: 26th Street and Madison Ave

Duration: 1yr renewable contracts.

Start: ASAP

Positions: 4

Work Remote: NO. They want all consultants on site.

Work Status: Citizens, .

Skills Need:

Must have 10+ years of experience working for US companies in the US.
Must have 4 + years of ‘Recent’ Banking experience (Since 2018).
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 in a team environment 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 8+ years experience working as a SQL Server DBA.
Must have experience with Functional & Application DBA duties.
Must have at least 8 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 8+ years experience working in a SQL DBA Role with multiple databases and SQL development issues.
Proficient in MS SQL Server 2014 - 2022.
Must have exposure to SQL Server 2025.
SSIS Package creation and debugging skills.
Stored procedure development and tuning.
Data replication exposure.

The JOB:

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.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

Dice Id: 91130761
Position Id: 8934673
Posted 11 hours ago

Company Info

About DyaTech LLC

DyaTech began operations in 2019 with the straightforward goal of offering “Dynamic Technology Solutions” to businesses wishing to combine their operations with IT advancements and inventions. Since our company’s beginning, we have successfully collaborated with organizations in the public and commercial sectors to assist them in realizing their strategic business objectives.

DyaTech provides subject expertise, unmatched knowledge, and years of industry experience to suit the needs of our clients. In order to help our clients, succeed in their various industries, we work together to offer them high-quality services at reduced costs.

Go to company profile

Create job alert

Never miss an opportunity! Create an alert based on the job you applied for.

Similar Jobs

SQL Database Administrator

New York, New York

•

Today

Company Description Job Description We are seeking a skilled SQL Database Administrator (DBA) with a strong background in programming to manage and optimize our database systems, ensure data integrity, and contribute to application development. The ideal candidate will have experience designing, implementing, and maintaining databases while supporting development teams with SQL and programming expertise. Responsibilities include but are not limited to: - Database Administration: -Manage, mon

Full-time

Database Engineer

New York, New York

•

Today

Company Description Job Description ABOUT OATH: The City of New York's Office of Administrative Trials and Hearings (OATH) is the nation's largest administrative tribunal, holding more than 250,000 trials and hearings a year. As the City's central, independent administrative law court, OATH adjudicates a wide range of matters filed by nearly every city agency, board and commission. OATH also houses the Center for Creative Conflict Resolution which provides mediation and restorative justice sup

Full-time

USD 250,000.00 per year

Senior Database Administrator II

Remote or New York, New York

•

Today

Senior Database Administrator II Employment Type: Full-Time, Mid Level Department: Information Technology Contact Government Services is seeking a Senior Database Administrator to assist with administering all aspects of Microsoft SQL Server. CGS brings motivated, highly skilled, and creative people together to solve the government's most dynamic problems with cutting-edge technology. To carry out our mission, we are seeking candidates who are excited to contribute to government innovation, ap

Full-time

USD 114,816.00 - 165,845.33 per year

Database Analyst, Bureau of IT Application and Platform Engineering

Queens, New York

•

Today

Company Description Job Description Certified IT Administrator (DB) I-13644 - Open to candidates who are permanent and those who will successfully file for the Open-Competitive Exam 3644 Certified It Administrator (Database) 6033 within the filing period commencing 5/7/2026.(amended) The Division of Information Technology's mission and vision is to promote and protect the health of all New Yorkers through the use of innovative technology and health information that is useful and available. We

Full-time

Search all similar jobs