Job description
We are currently seeking an Sr. SQL Database Administrator for an onsite opportunity in Manhattan, NY (zip code 10010). This is for a 1+ year opportunity opportunity (with potential for extension).
Location: Manhattan, NY (will consider local or candidates willing to travel to NYC)
Rate: Starting around $70.00 -$85.00 per hour depending on experience (will discuss rates and possibility for travel assistance may be available for those outside of NYC or NY).
Industry: Banking
Responsibilities:
- 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.
- Resolve users complain about the performance of a particular query, help developers improve the performance of that query by tweaking it or modifying.
- Conduct SQL Server lunch-and-learn sessions for application developers.
- Advise developers on the most efficient database designs (tables, datatypes, stored procedures, functions, etc.).
- Design tables and picking datatypes using Profiler traces and other tools to find the most frequently run queries.
- Deciding whether clustering, log shipping, mirroring, replication, etc. are the right fit to solve a business problem.
- Provide On-call troubleshooting for SQL Server service outages.
Ideal Candidate will have the following experience:
- 7+ years of experience working as a SQL Server DBA.
- 3+ years of recent experience working within the Banking Industry.
- 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.
- Proficient in MS SQL Server 2014 - 2019.
- Experience with T-SQL Queries.
- SSIS Package creation and debugging skills.
- Stored procedure development and tuning.
- Data replication exposure..
If qualified, interested, and available (or know somebody who is), please reply with an updated resume and desired salary for immediate consideration to kara.vanlaeke@comcentric.com
offroadmanagementgroup.com is the go-to platform for job seekers looking for the best job postings from around the web. With a focus on quality, the platform guarantees that all job postings are from reliable sources and are up-to-date. It also offers a variety of tools to help users find the perfect job for them, such as searching by location and filtering by industry. Furthermore, offroadmanagementgroup.com provides helpful resources like resume tips and career advice to give job seekers an edge in their search. With its commitment to quality and user-friendliness, offroadmanagementgroup.com is the ideal place to find your next job.