Database Administrator

TEKsystems•Centennial, CO

1d•$40 - $45•Hybrid

About The Position

This position supports the organization’s mission by providing technical database expertise and managing the efforts to import, collect, store, transmit, and use data across the organization. The City currently maintains a SQL environment and has recently completed an Information Technology Strategic Planning process that identifies a number of necessary system upgrades. Design, implementation and administration of databases to support these new systems is an essential function for this position.

Requirements

Requires a BA/BS or equivalent in Computer Science
a database management certification (preferred)
a minimum of 6 years of experience with administering relational database technology.
Bachelor’s Degree (or equivalent experience) in Computer Science, Information Systems/Sciences, or a related field, with an emphasis on database design, development, and data management
Experience with backups, restores and recovery models as designer and process owner.
Experience working with Windows Server OS.
Significant experience with database design.
Experience with backups, restores and recovery models as designer and process owner.

Nice To Haves

Experience with database products other than SQL Server a plus.

Responsibilities

Responsible for installation, support and maintenance of the database platforms across the organization.
Under minimal or no supervision, the position will be responsible for applying new releases and upgrades and supporting all products.
Creates and manages multiple databases, tablespaces and indexes. Maintains databases up to current security standards. May direct staff in advanced database management procedures and diagnostics when necessary.
Monitors, tunes, diagnoses, resolves problems with databases and their performance. Develops and maintains a backup and recovery strategy for all databases.
Establishes standards and procedures.
Oversee SQL Developer
Develop, implement, manage, and maintain databases, data management systems, software, and analytical tools.
Analyze, design, write, document, test, train, monitor, maintain and support databases and database applications across all City departments.
Improve efficiencies, enhance analysis, and automate processes relating to data across the organization.
Work as part of a project team to coordinate database development and determine project scope and limitations.
Provide applications support by developing reports, creating and modifying SQL queries and stored procedures, designing and implementing automated processes, modifying and maintaining forms, performing system upgrades, and general troubleshooting.
Plan, coordinate, and implement security measures to safeguard information in computer files against accidental or unauthorized damage, modification or disclosure.
Recommend solutions by defining database physical structure and functional capabilities, database security, data back-up, and recovery specifications.
Support the transition to Enterprise-class and ERP solution(s).
Schedule, plan, and perform the testing of new databases and data-related products and services, identify and troubleshoot errors, and make necessary modifications and corrections.
Development and design of Enterprise GIS database strategies(s), monitoring and improving database performance and capacity and planning for future expansion requirements
Develop methods for integrating different sources of data from across the organization to enable data driven decisions.
Consult with users to determine needs and solutions.
Identify and evaluate industry trends in database systems, anticipate long-term data needs, and proactively serve as a source of information and advice for OTI management.
Provide technical database expertise and training to internal and external users as required.
Establish technical requirements and policies, and ensure staff, vendors, and clients are in compliance.
Identify and communicate database related issues to key stakeholders, including management, development teams, and end users.
Design and maintain quality service by establishing and enforcing organization standards.
Structure data for reporting.
Perform other tasks and duties as assigned.
Responsible for the maintenance, updating and retention of records, data and content managed within the scope of the position. Acquires and utilizes knowledge of City’s electronic content management systems and guards against the unauthorized removal, destruction, or use of municipal records. Recognizes and respects that City employees forgo any personal or proprietary right to the City’s records including those that may have been developed, created or compiled during their tenure in employment.