What are the responsibilities and job description for the Senior SQL Server Functional/Application DBA position at Cybertec, Inc.?
Job Details
Role: Senior SQL Server Functional/Application DBA
Location: New York, NY (onsite)
Duration: Long term contract
Interview: Virtual
ALL CANDIDATES WILL BE TECHNICALLY SCREENED VIA AN AI BEFORE SUBMITTAL TO CLIENT.
100% must haves:
Experience with VLDBs (very large data bases) Over 30tbs
4 years min experience in Banking (banking meaning banks not American Express or Visa etc..)
Experience as an Application DBA and Production DBA
Job Title: Senior SQL Server Functional/Application DBA
Job Overview:
We are seeking four experienced Senior SQL Server DBAs for an exciting opportunity with a prestigious financial institution. This is a 1-year renewable contract role with an immediate start date, subject to a brief administrative pause. All compensation details and the hiring organization are being kept confidential.
Key Responsibilities:
- Collaborate with a global DBA team to ensure that new database code adheres to high standards for readability, reliability, and performance.
- Provide weekly performance insights by identifying the top 10 most resource-intensive queries and suggesting optimization strategies.
- Design and optimize indexes for existing applications, and offer actionable recommendations when users report performance issues.
- Conduct SQL Server lunch-and-learn sessions to support application developers.
- Advise on efficient database designs, including table structures, datatypes, stored procedures, and functions.
- Engage in on-call troubleshooting for SQL Server service outages and determine the best high availability strategies (e.g., clustering, log shipping, mirroring, replication).
Required Skills & Experience:
- Finance Experience: Demonstrated experience working within the financial services sector (Banks) is essential.
- Database Administration:
- Minimum of 10 years in general database administration (implementation, code deployments, backups, and user account creation).
- At least 7 years as a SQL Server DBA with 5 years focusing on advanced platform features (clustering, encryption, standby configurations, ETL, replication, and performance optimization).
- Proven track record in administering databases with sizes of 30TB or larger is absolutely required.
- Technical Expertise:
- Proficient with MS SQL Server 2014 through 2019, including SSIS package creation and debugging, stored procedure development/tuning, and data replication techniques.
- Extensive experience in Level 3 (highest level) support within a banking environment (at least 4 years since 2016).
- Adept at using performance tools (e.g., Profiler traces, sp_BlitzIndex , DMV queries) and skilled in both SQL development and troubleshooting.
Contract Details:
- Contract Duration: 1-year renewable
- Positions Available: 4
- Start Date: ASAP (applications will be accepted starting March 3, 2025)
