Database Administrator

Database Administrator

Responsible for control of the City's computerized information resource through development and implementation of security and access procedures and development of standards for design and documentation of information systems. Performs other job-related duties as required. Typical tasks include maintaining data security by controlling who may access the data, preparing directories of security, users, and structures and controls distribution of the directories, determining requirements for backup and recovery of information structures to insure data integrity, controlling creation, deletion or recognition of logical file procedures, providing new access permissions and determining if files are consistent with interfaces to existing data structures, monitoring data storage space utilization and implementing necessary action to improve space utilization, coordinating vendor training of Data Center employees in file design techniques, program coding techniques and security characterization, providing technical guidance in logical and physical structures and assisting in implementation, and developing standards associated with control of data base.

Minimum qualifications include an associate's degree in computer science, business administration, criminal justice, or related field from an accredited college, university, or vocational school, and two years of full-time paid experience supporting users in a midrange IBM environment, NT environment, or other networking environment. Additional requirements include knowledge/understanding of dumb terminals, CAT 5, twinax cabling, modems, and installing/removing hardware and software, and the ability to lift and carry a minimum of fifty (50) pounds. A valid state of Ohio driver's license is required.

Additional responsibilities include managing MS SQL and Oracle ecosystems (on-prem and cloud) ensuring optimal performance, resiliency, redundancy, security and data integrity, responsible for the entire lifecycle of data: development, integration, reporting and management, leading audits and managing database environment licensing and related contracts, ensuring optimal utilization and alignment with NIST 800 Cybersecurity, risk management, database monitoring, compliance and data governance frameworks, leading database environment IR, to include disaster recovery planning, testing, and documentation, providing oversight in database driven application development and BI solution deployment, assisting in database resource development, and performing other technical and administrative duties as assigned.

Preferred skills and tools include Microsoft database certifications, proficiency in on-premises MS SQL Server administration, configuration, performance tuning, and backup/recovery strategies, expert use of SQL Server Management Studio (SSMS), including indexing, query optimization, and system troubleshooting, proficiency in SSIS for data migration and multi-source data integration, and SSRS for designing and deploying enterprise-level reports, strong command of SQL development and scripting, comprehensive understanding of database security, access control, compliance protocols, and proficiency with database monitoring tools and troubleshooting techniques, experience in PowerShell scripting for automation of administrative tasks, proficiency with SFTP and FTP, including IP switch secure FTP for secure file transfers, familiarity with Microsoft Visual Studio for debugging and developing SQL-related applications, proficiency in managing Azure SQL Database, including provisioning, configuring, optimizing, and maintaining cloud databases, knowledge of Power Automate for automating workflows and processes, including integration with databases, experience with setting up Azure Backup and Geo-replication to ensure cloud data availability, and knowledge of Azure security best practices for databases, including integration, firewalls, and encryption.

The City's guiding principles are as follows: placing Clevelanders at the center, empowering employees to do purposeful work, defining clear and pragmatic objectives, leading with trust and transparency, striving for equity in all we do, and embracing change. All City employees are responsible for embracing and carrying out these principles in all that they do.