SQL DBA $55/hr CTH Columbus, OH No C2C

Company: Vaco Technology
Location: Columbus
Posted on: November 19, 2023

Job Description:

The primary focus of this role is to ensure database stability and resiliency while also planning for growth and scaling as the company grows. The position will perform basic DBA tasks such as backup plans, maintenance jobs, performance testing, monitoring, and reporting in a MSSQL environment. The position will also require an in depth knowledge of T-SQL, script writing, and server administration. Successful candidates will be self-starters and have a passion for infrastructure development. KEY ACCOUNTABILITIES:

• Responsible for basic day-to-day SQL Server administration to all application DBs
• Keeps SQL Server databases patched and on latest appropriate/feasible versions
• Performs server and system health checks on a daily basis.
• Troubleshoot problematic database issues and performance problems
• Orchestrates performance testing and strategies
• Works with vendors to arrive at cost-effective licensing and architecture strategies
• Works with development team to build and deploy their software releases
• Maintains and enhances system security framework to adhere with industry best practices
• Plan and implement upgrades needed to maintain service levels.
• Maintains existing and develops new reporting stored procedures as requested by the business. Has a deep understanding of TSQL in this area
• Has a deep understanding of disaster recovery/business continuity practices
• Advanced knowledge of backup and redundancy concepts. Log shipping, mirroring, etc.
• Interfaces with key business stakeholders to arrive at new requirements for the system from a data standpoint
• Deep understanding of schema design and data modeling. Has the ability to look at a vendor system schema and be able to write reports
• Assist in managing Tech Support queue
• Comfortable working on multiple high priority tasks and interacting with business unit leads to resolve issues.REQUIRED QUALIFICATIONS:
  • 5+ years of MS SQL Server 2012,2014,2016 Administration
  • 5+ years of SQL Profiler, Perfmon, and Query Plans
  • 5+ years of TSQL script writing. Stored Procedures, Functions, Triggers
  • 5+ years of Windows Server 2012,2016
  • 5+ years of SSIS ETL Package writing
  • 5+ years Database Configuration and Release Management
  • 5+ years of Data Modeling and NormalizationDESIRED QUALIFICATIONS (NICE TO HAVE):
    • NoSQL database experience (i.e. MongoDB, RavenDB, etc)
    • Apache Solr
    • Powershell Script Writing
    • Strong interpersonal skills, able to communicate across a broad spectrum of users
    • Excellent oral, written and presentation communication skills
    • Development in an Agile environment
    • Knowledge of AWS/Azure database services
    • OLAP/Big Data knowledge a plus

Keywords: Vaco Technology, Columbus , SQL DBA $55/hr CTH Columbus, OH No C2C, Human Resources , Columbus, Ohio