IDC Technologies: SQL DBA Nashville, TN or Chicago, IL (remote)

Wednesday, 31 January 2024

SQL DBA Nashville, TN or Chicago, IL (remote)

I hope you are doing well.

I am hiring a consultant for one of my client's requirements. I've written the Job Description for the same below. If you find yourself comfortable with the requirement please reply back with your updated resume

Position: MS SQL DBA

Location: Nashville, TN or Chicago, IL (remote)

Duration: 6+ Months

Visa: USC,GC,

REQUIREMENTS:

B.S. Degree in Information Technology, Computer Science or a related discipline is preferred.
MCSE/Azure Certification preferred.
5-8 years of experience in database development and support in MS SQL Server environment.
3+ years working experience in deploying physical and cloud instances of SQL Server. (Azure preferred)
2+ year of working with PostgreSQL.
Working Knowledge of Databricks administration and Datalake, is a plus. (Azure Preferred)
Working knowledge noSQL database technology. (Mongo, Cosmos, Others)
3+ years of experience in scripting language like Powershell, VB Script, Python, or similar.
Strong understanding of Security guidelines in Cloud environment.
Open to work on Infrastructure projects and assist on Environment buildouts from Database and Data Analytics perspective.
Experience in troubleshooting and resolving database integrity issues, performance issues, blocking & deadlocking issues, replication/log shipping issues, network/connectivity issues, security issues, etc.
Experience in Performance Tuning, Query Optimization using SQL Monitor, New Relic, and other related tools
Ability to detect and troubleshoot SQL Server related hardware resource contention such as CPU, memory, disk IO, etc.
Solid acquaintance with windows server, security models, and storage components such as SAN.
Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Server
Advanced experience with TSQL language and stored procedures, transactional replication, multi node clustering, mirroring, etc.
Knowledge of Data Warehousing and Column store databases.
A broad understanding of enterprise-class technologies
Extensive knowledge and experience with large scale client facing online systems
Extensive knowledge and experience with Amazon AWS technologies
Extensive knowledge and experience with Windows based technologies
Ability to communicate and to interact effectively with co-workers and customers is required.
Ability to work and adapt in a dynamic environment and recognize priority issues, escalating accordingly
Experience with creating standards and documentation
Ability to work both independently or as part of a project group, with time constraints
Strong customer service oriented; organizational and communication skills, positive and can-do attitude
A technical troubleshooting and prioritization skills test will be part of the interview process.