SGR_cart_icon.png Shopping Cart          

SGR_Homepage_Header.png

 
SGR Job Board


Please click on Position links below for more information.


SQL DBA - City of Frisco, TX (ID: 328769)

Title SQL DBA
Type IT/MIS
Date Posted 2019-04-26
City / Organization City of Frisco, TX
Website Click Here for the Position Listing
Description

Under general supervision of the MIS/Computer Technology Manager, the Database Administrator will develop, maintain, implement, backup and administer databases for the City of Frisco; develop and implement policies and procedures for ensuring the security and integrity of all City databases; troubleshoot, resolve, and fine tune database issues involving performance, integrity, capacity, replication, backup, and any other distributed data issues.
 
The intent of this position description is to provide a representative summary of the major duties and responsibilities performed by incumbent(s) in this position. Incumbent(s) may not be required to perform all duties in this description and incumbent(s) may be required to perform position-related tasks other than those specifically listed in this description.

Essential Job Functions & Other Important Duties:
  • Serves as the database administrator and provides technical support for all database environments within the City.
  • Installs and configures any/all new SQL Servers.
  • Implements database security, maintenance and back up routines. Establishes user accounts and specifies user access levels.
  • Creates, implements, manages, tests and documents enterprise wide database backup and recovery plans.
  • Reviews existing databases and optimizes for best performance.
  • Ensures the consistency and maintainability of existing data and applications by creating, maintaining and enforcing standards/procedures on the citywide use of databases and enterprise data.
  • Configures SQL Server monitoring utilities to minimize outages.
  • Troubleshoots SQL Server service outages as they occur, including after-hours and weekends.
  • Determines the most effective way to increase performance including hardware purchases, server configuration changes, or index/query,
  • Supports IT staff by creating views of complex and multiple databases to provide information in useable format to users.
  • Advises IT staff on the most efficient database designs (tables, datatypes, stored procedures, functions, etc).
  • Develops and documents requests for change management.
  • Installs, maintains and troubleshoots system hardware including clustered or mirrored server environments and SAN deployments.
  • Designs, develops, manages, and documents business intelligence solutions.
  • Trains other IT staff.
  • Researches current industry trends, new technologies, innovations and related legislation and provides recommendations on when and which these are best suited to meet the city's objectives.
 
Other Important Duties:
  • Travels to assigned meetings, presentations, conferences and training.
  • Performs maintenance functions as necessary.
  • May be required to work irregular hours.
  • Performs other related duties as assigned.
  • Regular and consistent attendance for the assigned work hours is essential.

 
 Job Requirements:
  • Knowledge of Database Administration for MS SQL Server 2012, SQL 2014, and SQL 2016.
  • Knowledge of best practices for database administration, data warehousing, security procedures and products.
  • Knowledge of Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools.
  • Knowledge of indexes, index management, and statistics.
  • Knowledge of and experience with SQL 2012, 2016 AlwaysOn for High Availability (HA) and Disaster Recovery (DR).
  • Knowledge with Microsoft Power BI, Data Lakes, Data Pools and Data Warehouses.
  • Knowledge with Block Chain Technology.
  • Knowledge of backups, restoration and recovery models.
  • Knowledge of SSRS, SSIS & SSAS
  • Knowledge of SQL Azure – (Azure Data Studio) cloud implementations & Migrations.
    Knowledge of research and technical support techniques.
  • Ability to migrate and upgrade SQL 2008 databases to SQL 2012. SQL 2014 and SQL 2016.
  • Ability to troubleshoot and resolve database problems.
  • Ability to implement operational automation using scripts.
  • Ability to work with Windows server, including Active Directory and proper disk configurations.
  • Ability to communicate clearly and concisely, both verbally and in writing about technical subjects to non-technical users in a manner in which they can easily understand.
  • Ability to document processes and issues clearly and concisely.
  • Skill in effectively managing multiple projects.
  • Skill in resolving customer complaints and concerns.
 
Preferred Education, Experience, and Certifications:
  • Bachelor's Degree in Information Systems, Computer Science or related field; and five (5) years progressively responsible experience in database development and support in MS SQL server environments or equivalent combination of education and experience..
  • Microsoft certification (MCITP or MCDBA) preferred.
  • Must pass a pre-employment drug screen, criminal background check and MVR check.
  • Must possess a valid State of Texas Drivers License.

 
 Environmental Factors & Conditions/Physical Requirements:
  • Work is performed in an office environment.
  • Crouching – bending body forward by bending leg, spine.
  • Feeling – perceiving attributes of objects by touch with skin, fingertips.
  • Fingering – picking, pinching, typing, working with fingers rather than hand.
  • Hearing 1 – perceiving sounds at normal speaking levels, receive information.
  • Kneeling – bending legs at knee to come to rest at knees.
  • Lifting – raising objects from lower to higher position, moving objects side to side, using upper extremities, back.
  • Mental Acuity – ability to make rational decisions through sound logic, deductive reasoning.
  • Reaching – extending hands or arms in any direction.
  • Repetitive Motion – substantial movements of wrists, hands, fingers.
  • Speaking – expressing ideas with spoken word, convey detailed, important instructions accurately, concisely.
  • Standing – for sustained periods of time.
  • Talking 1- expressing ideas by spoken word.
  • Visual Acuity 1 - prepare, analyze data, transcribing, computer terminal, extensive reading.
  • Visual Acuity 2 - color, depth perception, field of vision.
  • Visual Acuity 3 - determine accuracy, neatness, observe facilities/structures.

Work Environment:     
  • Work performed is primarily light work, exerting up to 20 pounds of force occasionally, and/or up to 10 pounds of force to move objects.
Equipment and Tools Utilized:
  • Equipment utilized includes personal computer, scanner, copier, calculator, fax machine, other standard office equipment.

Job Post Expiration Date   August 31, 2019

    All jobs posted are considered open until filled and may close at anytime except as stated in the Job Description. .