Apply Now





   

 

Thank you for Applying!



Your application has been successfully submitted. You will also receive an email with more information.


Close
Senior SQL Database Administrator
Job ID:23589
Kansas City, Missouri

RESOLVIT

Bringing Solutions That Make Business Better

Join Resolvit as a Senior SQL Database Administrator and be part of a creative, forward-thinking team. Our success at deploying skilled, highly knowledgeable experts has landed us on the Inc. 5000 list of America’s fastest-growing companies four times – and we’re just getting started.

As the Senior SQL Database Administrator, you will be a subject matter expert on the development and delivery of enterprise grade SQL server solutions. You will take a lead role in implementing assigned projects and tasks with minimal supervision. You will also provide 2nd and 3rd level support of database systems and will take the lead in driving problem resolution. Additionally, you will:

  • Work closely with members of the Software Engineering Team, the Quality Assurance team, Project Managers, and Business Analysts to write accurate and efficient T-SQL code to support mission-critical transactions processing OLTP and OLAP application databases
  • Work closely with the DBA team lead to plan for upcoming releases, raise opportunities for system improvement, and recommend technology direction for prioritized projects
  • Keep the DBA team lead apprised of project status and incidents/issues status so appropriate status updates can be delivered to the Software Engineering leadership
  • Provide support for query optimization, data analysis, and database tuning
  • Maintain documentation of database and all database object metadata
  • Build database schema, tables, and complex stored procedures to support new development initiatives and provide support for existing applications
  • Develop ETL solutions
  • Identify, recommend, and implement appropriate security to SQL Server database schemas
  • Provide primary support to mission-critical applications and processes via database changes and tuning
  • Participate with other members of the DBA team to monitor SQL Server performance via established monitoring tools and recommend/implement corrective, proactive action to ensure production systems support business needs
  • Participate in “front-line” 24/7 on-call support for assigned database systems/processes and participate in periodic application deployments to production
  • Ensure coding/DB standards are met via review process
  • Ensure project deliverables and timelines are accurate to specifications and successfully met
  • Participate in occasional strategy and roadmap discussions

What You’ll Need to be Successful:

  • At least 6 years of experience developing and administering solutions for SQL Server 2008 R2, 2012, 2016, and 2017
  • Expert knowledge of ANSI Standard Transact-SQL and latest Transact-SQL query language enhancements
  • Experience with AlwaysOn clusters
  • Strong experience maintaining enterprise-level databases including administration, optimization, tuning, and backup and restore procedures
  • Experience delivering and supporting large, high-performance databases across multiple SQL Instances
  • Strong written and verbal communication skills

Great Additional Skills:

  • Experience working with a data warehouse and an understanding of star schemas and database de-normalization using OLAP databases
  • Experience with ETL methodologies and SQL Server SQL Agent and other Automation tools
  • Experience working with servers and databases in Azure in a PaaS and/or IaaS environment
  • Experience working with GIT version control systems
  • Experience with automated deploys of SQL objects

Benefits:

At Resolvit, you’ll be given the support you need to grow in your consulting career. In addition to opportunities for advancement, we offer:

  • Medical, dental, and vision insurance
  • Life insurance coverage
  • Long-term and short-term disability coverage
  • 401(k) retirement plan with matching
  • Professional support from our Client & Employee Optimization Specialist

We currently have more than 100 open career opportunities across the country, so be sure to mention the appropriate Job Code with any correspondence!

About Resolvit:

Resolvit is an international technology consulting firm with industry-leading customers in the financial services, high tech, manufacturing, retail, life sciences, and government sectors. Through its partnerships, Resolvit delivers highly impactful, innovative solutions across five core areas: Infrastructure Modernization, Application Development Services, Enterprise Data Management & Analytics, Knowledge & Content Management, and Strategic Staffing.