A1 Placement

Receive alerts when this company posts new jobs.

Similar Jobs

Job Details

SQL DBA

at A1 Placement

Pay: $69,000 to $77,000/year
Posted: 7/5/2019
Job Status: Full Time
Job Reference #: 27167

Job Description

A Pittsburgh-based, growing tech company is in need of two SQL Database Administrators Help Desk Specialists to be a part of the team responsible for their operational support for project initiatives surrounding the company’s Database environments. This position will play an integral role in the maintenance, support and enhancements of business-critical applications.

RESPONSIBILITIES

  • Monitor and maintain database security
  • Migrate databases between servers and various platforms
  • Review database object and create and maintain change controls
  • Analyze and resolve SQL Server faults
  • Investigate and resolve reported application issues, escalating issues as necessary to the application owners
  • Design, develop and implement internal data feeds, data reporting extracts and ETL processes between disparate systems
  • Document data flows, application specifications from a DB perspective and system procedures
  • Monitor relational databases to optimize performance, resource use, backup/recovery, and physical implementation
  • Implement and maintain data distribution and disaster recovery solutions, such as mirroring, replication, and log shipping
  • Implement, create reports and provide general support for SQL Server Reporting services
  • Support highly-available and disaster recovery (HA/DR) database technologies (such as SQL Clustering and SQL Server Availability Groups across multiple data centers)
  • Provide 24×7 on-call support on a rotating basis

REQUIREMENTS

  • Bachelor’s degree in Computer Science or a related field
  • 5+ years of experience with SQL 2012, SQL 2014 and SQL 2016
  • Strong understanding of security implementation
  • Experience with SQL Server performance management and tuning, including understanding of SQL execution plans
  • SQL Server Administration experience including:
  • Triggers
  • Excellent communication skills
  • Stored Procedure Code Development and Standardization
  • Data Integration and Migration
  • Management Studio
  • SQL XML
  • Database Auditing and Controls
  • Proven troubleshooting abilities
  • Strong planning and analysis skills
  • Strong documentation skills

Preferred:

  • Ability to translate Logical Data Models into physical structures
  • Strong knowledge of Windows 2012 and 2016
  • Strong knowledge of physical and VMWareSQL configuration from an infrastructure perspective