SQL DBA in Atlanta, GA at MDI Group

Date Posted: 9/20/2018

Job Snapshot

Job Description


Our client has an immediate need for a SQL DBA for their office in the Brookhaven area of metro Atlanta. This is a contract to hire role. As the SQL Server DBA, you will be responsible for the implementation, configuration, maintenance, and performance of critical SQL Server RDBMS systems to ensure the availability and consistent performance of the client’s applications.  APPLY TODAY!!

Responsibilities:

  • Manage SQL Server databases through multiple product lifecycle environments from development to mission-critical production systems
  • Configure and maintain database servers and processes including monitoring system health and performance, to ensure high levels of performance, availability, and security
  • Test and configure database backups to meet the business’s Recovery Point Objectives (RPO) and Recovery Time Objectives (RTO)
  • Analyze, solve, and correct issues in real time, providing problem resolution end-to-end
  • Determine the most effective way to increase performance including hardware purchases, server configuration changes, or index/query changes
  • Assist developers with complex query tuning and schema refinement
  • Provide application developers with a list of the top 10 most resource-intensive queries on the server and suggesting ways to improve performance on each
  • Design indexes for existing applications, proactively monitor query performance, and determine when to add or remove indexes
  • Troubleshoot SQL Server service outages as they occur, including providing Oncall support during after-hours and weekends; after-hours work may also include, but not limited to scheduled maintenance, supporting application deployment, and hardware/software upgrades
  • Plan and schedule the installation and configuration of new SQL Servers
  • Analyze requirements for new projects and determine whether to use clustering, log shipping, mirroring, Windows Azure, or other technologies to solve a business problem
  • Implement SQL Server monitoring utilities, refine and automate regular processes, track issues, and document changes
  • Configure access levels for each segment of the database.
  • Share expertise with team members providing technical mentorship and cross-training as needed

Requirements:

  • Bachelor’s degree in computer science or a related field from an accredited college or university AND 5+ years MS SQL Server Administration experience required
  • Experience working with Microsoft SQL Server 2008 R2/2012 & higher (stored procedures, triggers, functions, views, constraints & indexes)
  • Experience with Performance Tuning and Optimization (PTO) using native monitoring and troubleshooting tools
  • Experience with backups, restores and recovery models
  • Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Server
  • Experience working with Windows server including Active Directory
  • Understanding of different database models and styles (OLTP, OLAP, NoSQL)
  • Experience developing/prototyping products, software applications, and/or data modeling is a plus
  • Experience with automated reporting tools and methodologies is a plus
  • Experience developing reports and presentations to share analysis results and recommendations with management and others a plus
  • Experience in analyzing information using various statistical methods to identify patterns is a plus

Contact Sandeep sprabhu@mdigroup.com


A GREAT PLACE FOR GREAT PEOPLE TO WORK

Search IT Jobs