Database Administrator

City of Glendale • Glendale, AZ

1d • Onsite

About The Position

The City of Glendale's Innovation & Technology department focuses on the delivery and operations of vital IT infrastructure, computer support, IT governance, project management, as well as support and maintenance of enterprise applications, data analytics, GIS services, and cybersecurity. The Database Administrator directs and controls the activities related to data planning and development and the establishment of policies and procedures pertaining to data management, data security, data maintenance, and data utilization. Job duties include establishing, monitoring and maintaining database standards; and advising management on database concepts, functional capabilities, database performance improvement and data utilization.

Requirements

• Bachelor's Degree in Computer Science, Engineering or related field and five years experience designing and supporting databases and applications.
• Any equivalent combination of education, training and experience that provides the required knowledge, skills and abilities is qualifying.
• One year of relevant experience may be substituted for each year of required education.
• Knowledge of: Principles of relational database design, development and administration, data integration, data security, data quality, data warehouse/ETL/ELT, and BI analytics reporting
• Strong knowledge of modern data architecture principles, ensuring efficient data storage, optimized query performance, and reliable pipelines that support analytics and enterprise reporting
• Microsoft SQL Server database architecture and features
• Database administration and management techniques in a client-server environment
• Structured Query Language (SQL)
• Physical database design, backup and recovery strategies, performance monitoring, and tuning
• Relational database management systems such as Oracle, SQL Server, My SQL
• Ability to work effectively with users, technical personnel and consultants to achieve stated objectives
• Conduct research, evaluate user needs and system capability, and design appropriate plans and programs
• Work on concurrent projects
• Communicate effectively both verbally and in writing.
• Identify root cause and develop effective solutions
• Conduct research and complex systems analysis and integration
• Continually learn and demonstrate new skills via hands on training, classroom training and self-study

Nice To Haves

• The preferred candidate for this role will have an industry recognized database certification. Examples include but are not limited to Oracle, Microsoft, or enterprise class database products.

Responsibilities

• Evaluates, implements and makes recommendations regarding new features of the database product and tools; schedules and performs database upgrades.
• Performs database analysis and manages changes to database design and operation.
• Recommends appropriate physical partition size of disk subsystems related to data storage.
• Designs and implements database indexes, triggers and other essential database functionality.
• Defines application program interfaces to the database as appropriate.
• Identifies data available for use for specific or general access.
• Interface with users, consultants, technical teams and vendors for maximum guidance in determining the most appropriate selection, installation and configuration of database technologies.
• Monitors applications systems performance and recommends methods for improving efficiency through database and application design; investigates, analyzes and reviews user performance issues.
• Develops documentation, checklists and processes for communicating support information as appropriate.
• Provides technical support to the Helpdesk.
• Insures code changes and modifications are managed using a documented change request system.
• Provides technical support within Information Technology and other departments as required.
• Evaluates, and implements solutions to complex problems using the appropriate application access and database tools.
• Consults with Information Technology teams to develop application installation and maintenance procedures to assure database standards and practices are maintained.
• Maintains security and integrity controls of the database software tools and the database.
• Establishes procedures for loading database software; backup and recovery of the database; stopping and restarting the database.
• Develops project schedules, prioritize tasks, meet project schedule requirements.
• Provides on call support during non-business hours.
• Maintains a high level of current knowledge regarding systems, technology, and communications.
• Performs other related duties as assigned.

Benefits

• 10.5 paid holidays per year
• 12 hours of holiday special leave per calendar year
• Vacation leave accrues at: 5.33 hours per pay period (138 hours/17.25 days per year)
• Increases to 6.12 hours per pay period after 5 years
• Capped out at 7.6 hours per pay period after 10 years of service
• Sick leave accrues at 4.4 hours per pay period (114 hours/14.25 days per year)
• Participation in the Arizona State Retirement System (ASRS)

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level