Talent.com
SQL Database Administrator

SQL Database Administrator

Allegheny CountyPittsburgh, Pensilvania, US
30+ days ago
Salary
$80,000.00–$84,460.00 yearly
Job description

Position Summary

Under the supervision of the Infrastructure Operations Supervisor, the SQL Database Administrator is responsible for the administration, maintenance, development, and implementation of policies and procedures that focus on ensuring the security and integrity of County Databases.

Overview : Duties :

  • Monitors daily SQL processes for successful completion.
  • Troubleshoots production problems and assists the first-level support team in investigating and resolving issues.
  • Performs security configuration and administration.
  • Maintains multiple databases in development and production environments.
  • Works with development teams on all aspects of database design including tables, views, stored procedures, permissions, etc.
  • Performs logical database design and physical database implementations.
  • Creates tests and conducts performance tuning on databases.
  • Develops SQL processes for data loading, migration, and application interfaces.
  • Designs and implements backup and recovery strategies.
  • Creates deployment scripts, including rollback scripts for all database changes.
  • Develops and enforces organizational SQL standards and best practices.
  • Assists with project plans and may lead technical projects.
  • Communicates project status, issues, and ideas to management.
  • Performs other duties as requested / required.

Knowledge, Skills, and Abilities Knowledge of :

  • Backup, recovery, and database design and modeling.
  • Configuration of hardware and software with system administrators.
  • Security administration, database analysis, and optimization.
  • Database creation, tuning, troubleshooting, and problem-solving.

    • Skill in :

  • SQL Server installation and maintenance, T-SQL, SQL, and scripting.
  • SQL Server Reporting Services.
  • SQL Integration Services, Visual Studio, and Business Intelligence Transformations in SSIS.

    • Ability to :

  • Work effectively with little supervision, both alone and in a group.
  • Demonstrate strong interpersonal and creative skills, as well as the drive to meet real needs with technology.
  • Develop accurate project specifications & time estimates.
  • Communicate effectively, orally and in writing.
  • Create informative technical documentation and guides.
  • Facilitate frequent meetings with client departments and vendors.
  • Work outside of normal business hours as needed or required.

    • Residency : Allegheny County within 1 year.

    Veterans' Preference : Will be awarded to eligible candidates.