What are the responsibilities and job description for the MSSQL Database Administrator position at SOHO Square Solutions?
Job Details
Job Title: MS-SQL Database Administrator Specialist
Location: Plano, TX / McLean, VA (Hybrid)
Duration: 6 Months (CTH)
NOTE: Looking for W2 profiles (USC) only
Job Description:
Position overview:
Database engineering team looking for a skilled Database Engineer to provide database production support in a fast-paced operations environment supporting business critical applications using backend MS-SQL database platforms.
As a MSSQL Database Engineer, play a critical role in ensuring the performance, security, and scalability of our databases and collaborate with cross-functional teams, including software developers, data analysts, and system administrators, to deliver efficient and reliable database solutions. Provide expertise in SQL programming, database architecture, and troubleshooting will be essential in optimizing database performance and resolving complex technical issues.
Must Have Qualifications: Microsoft SQL server expert-all the performances, scripting, and in/ outs of SQL server. If they know additional Databases that would be a plus.
Required Skills
- More than seven years of experience working as a production support database administrator (DBA)
- Strong database administration experience on MS-SQL Server
- Experience in installation, configuration and migration with MS-SQL database platforms.
- Refine and automate regular processes, track issues, and document changes
- Strong database performance tuning skills - query optimization and server tuning with MSSQL platforms
- Possesses deep understanding of MSSQL internals and Optimizer functioning and ability to apply the skills to trouble-shoot real time production issues
- Provide deployment support for database objects in production and test environment
- Extremely comfortably in power shell scripting with prior experience in writing and maintaining complex scripts to perform database maintenance.
- Experience in migrating SQL platform to industry standard versions.
- Execute large database migration projects independently
- Experience with standard database monitoring.
- Understanding of industry standard High Availability and DR technologies
- Experience with providing 24x7 production on-call support on rotation basis
- Effective verbal and writing communication skills
- Experience in ansible automation is preferable
- Experience with data security and compliance with industry standards
- Experience on other db platforms Sybase or PostgreSQL and No-SQL like Mongo is preferable
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.
