Back to Job Search

SQL Server DBA

Posted 19 days ago

SQL Server DBA

Small privately held organization seeking a seasoned SQL Server DBA to join their growing team in Decatur focused on advancing how the state of GA does business!  

Day-to-day:

  • Aid application developers by offering advice on database best practices, offers production support, and troubleshooting
  • Collaborate in the design and development of databases to accommodate application requirements
  • Perform all database upgrades and migrations applying SQL best practices
  • Anticipate and respond to technological innovations relating to SQL Server or relational databases in general
  • Define and implement database access levels and ensure overall database security
  • Monitor all databases to optimize database performance, resource use, and physical implementation
  • Address a variety of database integration issues including migration between disparate databases, integration, maintenance/conversion, capacity planning issues, and new applications
  • Develop, implement, and maintain regular maintenance procedures
  • Help to facilitate the constantly increasing demand for access to data
  • Design, develop, document, implement, and periodically tests disaster recovery and archiving procedures
  • Create and maintain data distribution schemes to replicate data to various sites
  • Perform regular backups of all databases and test those backups on a daily basis
  • Create, procure, and maintain various database-related documents such as manuals and programmers’ handbooks
  • Provide 24-hour on-call support relating to database issues
  • Create and maintain current ERDs for all databases
  • Perform SQL Server upgrades when needed
  • Perform miscellaneous job-related duties as assigned

Ideal candidate has a good mix of the following:

  • 8+ years experience as production DBA
  • Experience with database upgrades and migrations
  • Experience with managing large (TB+) databases and tables with millions of rows
  • Experience with High Availability (HA), Disaster Recovery (DR), and Microsoft Cluster
  • Failover Clustering (Always On: FCI & AG) design and configuration
  • Expert level experience in SQL replication technologies, Merge and Transactional replication Experience with backups, restores, and recovery models
  • Transact-SQL, stored procedure creation, execution plans
  • Index tuning
  • SSRS (SQL Server Reporting Services) SQL 2016 – SQL 2022
  • SSIS (SQL Server Integration Services)
  • Database maintenance plans
  • Database Partitioning
  • Troubleshooting and metric analysis with SQL Profiler, Database Engine Tuning Advisor, Performance Monitor and Query Store
  • Relational database diagramming software
  • Bachelor’s Degree
  • Excellent interpersonal, communication and collaboration skills
  • Critical thinking and problem solving skills

Bonus points for: 

  • Azure SQL 
  • .NET development 
  • PowerShell experience
  • IIS Experience 
  • VMWare experience 
  • SQL Server related certifications

The Perks:  Excellent benefits, casual environment, hybrid work model, great leadership and fantastic collaborative team.  Please send detailed SQL Server resume today!

​

Candidates will be responsible for following the client's COVID-19 protocols. Please refer to your MATRIX representative for specifics.

About Us

At MATRIX, we expertly match talented professionals with job opportunities to elevate careers. Since 1983, we have placed thousands of professionals at innovative clients across every industry ranging from small startups to Fortune 50 companies. It’s why we’re a top 15 U.S. IT staffing firm and why our consultants rate us well above the industry average. People come to us for a job, and stay with us because of our top-notch consultant care.

For hourly W2 contract roles, MATRIX offers a highly competitive benefit package including Medical, Dental, Vision, Life, Disability, HSA, and 401(k) with pre and post-tax options. Please see https://www.matrixres.com/consultants-overview/benefits-and-payroll for more information. For direct hire placement with our clients, benefits will be offered in accordance with that particular client’s offerings. This may include PTO, Medical, Dental, Vision, 401K and other pre and post-tax options.

MATRIX is an Equal Opportunity Employer, including disability/vets. All applicants must be currently authorized to work on a full-time basis in the country for which they are applying, and no sponsorship is currently available. Employment is subject to the successful completion of a pre-employment screening. Accommodation will be provided in all parts of the hiring process as required under Motion Recruitment Employment Accommodation policy. Applicants need to make their needs known in advance.