Description

Data Base Administrator

Examples of Duties

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: Maintains data security by controlling who may access the data. Prepares directories of security, users, and structures and controls distribution of the directories. Determines requirements for backup and recovery of information structures to insure data integrity. Controls creation, deletion or recognition of logical file procedures. Provides new access permissions and determines if files are consistent with interfaces to existing data structures. Monitors data storage space utilization and implements necessary action to improve space utilization. Coordinates vendor training of Data Center employees in file design techniques, program coding techniques and security characterization. Provides technical guidance in logical and physical structures and assists in implementation. Develops standards associated with control of data base.

Minimum Qualifications

A High School Diploma or GED is required. An Associate's Degree in Computer Science, Business Administration, Criminal Justice, or related field from an accredited college, university, or vocational school is required. Two (2) years of full time paid experience supporting users in a Midrange IBM environment, NT environment, or other Networking environment is required. (Substitution: Two (2) years of full time experience may substitute for each year of college education lacking.) Must have a knowledge/understanding of Dumb Terminals, CAT 5, Twinax Cabling, Modems, and Installing/Removing hardware and software. Must be able to lift and carry a minimum of fifty (50) pounds. A valid State of Ohio Driver's License is required. PUBLIC SAFETY: A High School Diploma or GED is required. A Bachelor's Degree in Computer Science, Information Technology, Business Administration, or closely related field from an accredited four-year college or university is required. Four years of full time paid experience supporting and maintaining SQL Server, Oracle, or similar enterprise level database environments is required. (Substitution: Two years of full time experience may substitute for each year of college education lacking.) A valid State of Ohio Driver's License is required. Must be able to lift and carry 50 pounds. Must have a demonstrated knowledge of database monitoring, scripting, and reporting services as well as database backup, recovery, security, integrity, and SQL (DDL and DML). The following are preferred: A post-graduate degree in Computer Science or Engineering, Business Administration, or closely related field; Data Warehouse experience; Business Intelligence experience; Microsoft SQL Server or Oracle DBA certifications.

Supplemental Information

Additional Responsibilities

  • Manage 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.
  • Lead audits and manage database environment licensing and related contracts, ensuring optimal utilization and alignment with NIST 800 Cybersecurity, Risk Management, Database Monitoring, Compliance and Data Governance Frameworks.
  • Lead database environment IR, to include disaster recovery planning, testing, and documentation.
  • Provide oversight in database driven application development and BI solution deployment.
  • Assist in database resource development
  • Perform other technical and administrative duties as assigned.

Preferred Experience

  • Advanced proficiency in SQL (including DDL, DML, DQL, DCL, and TCL command types), FTP/SFTP, Power BI, Networking and PowerShell.
  • Advanced experience with MS SQL Server, SSMS, SSIS, SSAS, SSRS, Azure, large databases, Database Management, Resiliency, Integration, Security, Tuning, and Troubleshooting across complex on-prem and cloud environments.
  • Current knowledge and experience with data and database NIST 800 Cybersecurity, Risk Management, Database Monitoring, Compliance, Governance,
  • Advanced experience in developing database-related applications, stored procedures, functions, debugging code.

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.

The City of Cleveland makes available a variety of benefit options depending upon your employment status and any applicable union membership. In general, benefit options include comprehensive medical, dental, vision, prescription medical and life insurance. Specific information regarding benefit eligibility will be discussed and reviewed at the time of hire.

Read Full Description
Confirmed 3 hours ago. Posted 5 days ago.

Discover Similar Jobs

Suggested Articles