SQL Database Administrator

Overview

On Site
USD95,000 - USD105,000
Full Time

Skills

SQL Database Administrator

Job Details

job summary:

As a SQL DBA at KDL, you will be at the core of our operations, ensuring our database systems are optimized, secure, and scalable. You'll also work closely with application teams to design and implement API integrations and support our data-driven applications.




location: Pittsburgh, Pennsylvania

job type: Permanent

salary: $95,000 - 105,000 per year

work hours: 9am to 5pm

education: Bachelors



responsibilities:

Job Duties



  • Manage and maintain SQL Server databases, ensuring optimal performance, security, and availability.
  • Lead efforts in database tuning, backup strategies, and disaster recovery planning.
  • Collaborate with application teams to integrate databases with various business applications.
  • Troubleshoot and resolve database-related issues in a timely manner.
  • Perform database migrations, upgrades, and patch management.
  • Monitor database performance and provide recommendations for continuous improvement.
  • Develop and maintain documentation for database architecture and processes
  • Some design and implementation of APIs for seamless communication between systems.
  • Some application development and support


qualifications:

Qualifications


Experience: 5+ years of experience as a SQL DBA with knowledge of application and API development.


Technical Skills:



  • Proficiency in creating, maintaining, and optimizing databases.
  • Strong experience in writing and debugging complex SQL queries, stored procedures, functions, and triggers.
  • Expertise in implementing backup strategies and performing database restores.
  • Knowledge of roles, permissions, encryption, and implementing SQL Server security best practices.
  • Experience with query optimization, index maintenance, execution plans, and troubleshooting bottlenecks.
  • Proficiency in database schema design, normalization, and partitioning.
  • Experience with SQL Server clustering, replication, log shipping, and Always On Availability Groups.
  • Ability to create, deploy, and troubleshoot ETL packages for data imports/exports. (SSIS: SQL Server Integration Services)
  • Ability to build and deploy reports as needed. (SSRS: SQL Server Reporting Services)
  • Proficient in developing, testing, and deploying C# applications using .NET/.NET Core.




skills: Soft Skills:



  • Strong problem-solving and analytical abilities.
  • Excellent communication and collaboration skills.
  • Detail-oriented with a focus on delivering high-quality work.




Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.

At Randstad Digital, we welcome people of all abilities and want to ensure that our hiring and interview process meets the needs of all applicants. If you require a reasonable accommodation to make your application or interview experience a great one, please contact

Pay offered to a successful candidate will be based on several factors including the candidate's education, work experience, work location, specific job duties, certifications, etc. In addition, Randstad Digital offers a comprehensive benefits package, including health, an incentive and recognition program, and 401K contribution (all benefits are based on eligibility).

This posting is open for thirty (30) days.


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.