CSS Tec Jobs

Your next opportunity is here!

  • Share this Job

SQL Systems Analyst #108075

Location : Wilmington, DE
Job Type : Temp/Contract
Compensation : 1.00 USD/HOUR
Start Date : 09/27/2021
End Date : 03/25/2022
Hours : Full Time
Travel : No
Relocation : No
Industry : IT
Job Category : Mid-Senior level (4-10 yrs)

Job Description :








Our client is an industry leader in precious metals, trading and exchange. They are seeking an experiences Production SQL DBA & Applications Support Analyst to join their Application Team. This is a 100% ON-PREMISE position, 6 month contract to hire.


 


Summary:  As a Production SQL DBA / Application Support Analyst, you will perform various functions in order to ensure that all the applications, databases as well as the IT systems run smoothly, and that the customer inquiries are appropriately addressed. You will provide first and second line of IT support, resolving technical queries, and communicating solutions directly to customers. You will also coordinate with the third-party systems and network engineers on troubleshooting and implementing network and PC changes.


 


Responsibilities:



  • Responsible for monitoring and responding to support tickets submitted through the incident management system

  • Manage, prioritize, and resolve issues and work requests through our ticketing system

  • Progress issues and provide relevant information for troubleshooting or for clarification

  • Identify opportunities for process improvement and contribute to departmental initiatives

  • Troubleshoot the issues and escalate incidents that cannot be resolved to the concerned teams

  • Responsible for improving and documenting the technical processes around the production support

  • Work collaboratively with Account Managers on change requests, approvals

  • Handle off-hours deployment schedules

  • Create and maintain reports using Crystal Reports and SSRS

  • Create and run SQL server scripts, jobs, and stored procedures to support production users and resolve issues

  • Monitor and maintain SQL server replication

  • Maintain in SQL server permissions

  • Perform day-to-day monitoring of applications/databases, initiate troubleshooting/mitigation of issues reported from alerts, health check failures, database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues etc

  • Detect and troubleshoot SQL Server related CPU, memory, I/O, disk space and other resource contention

  • Setup users and assist third party engineers with the management of windows active directory

  • Assist third party network engineers in resolving network, pc, and phone issues, configuring hardware, phones and other devices, and implementing data security

  • Assist third party network engineers with disaster recovery tests

  • Assist third party network engineers in supporting the Azure environment

  • Recommends solutions by defining database physical structure and functional capabilities, database security, data back-up, and recovery specifications

  • Manage and monitor database backups and restores

  • Develop scripts/jobs to automate repeatable manual tasks

  • Deliver all tasks on-time with quality

  • Maintains professional and technical knowledge by attending educational workshops; reviewing professional publications; establishing personal networks; benchmarking state-of-the-art practices; participating in professional societies.

  • Monitor the deployment of OS/Network patches

  • Completes responsibilities promptly, completely, and accurately

  • Works effectively and harmoniously with co-workers


 




Qualifications



  • Bachelor’s degree in computer science or closely related field.  

  • Minimum 4+ years of experience working on Incident, Event and Availability management

  • Minimum 2-4 years of experience supporting .Net applications

  • Minumum 2-4 years of experience writing T-SQL complex queries

  • 4+ years of experience writing queries, stored procedures, debugging application and database issues in Microsoft SQL Server 2014-2017

  • 3+ years of database management

  • 3+ years of experience with Crystal Reports or SSRS

  • 2+ years of software development experience in C# and .Net technologies and best practices

  • Extensive experience ‘Manually’ debugging of web base apps that have been in production


Preferred skills:



  • Knowledge of Azure Clouds technologies and DevOps

  • Knowledge of Networking concepts

  • Knowledge of SQL Server tools (Profiler, DTA, SSMS, SAC, SSCM, PerfMon, DMVs, system stored procedures)

  • Knowledge or Full stack .Net production support

  • A proactive approach to problem solving, taking ownership of issues and having the determination to follow things through

  • Excellent prioritization and time management

  • Ability to balance multiple time-critical tasks at the same time

  • Ability to present and absorb complex ideas quickly and accurately

  • Have an open attitude towards sharing ideas and knowledge and receiving constructive feedback

  • Knowledge of windows server, security delegation, SPNs, storage component

  • Knowledge of VMware or virtual servers


#LI-DH1

 



Required Qualifications :
 
Powered by AkkenCloud