What are the responsibilities and job description for the Data Base Analyst position at City of Cleveland?
Data Base Analyst
We are looking for an experienced Database Analyst (DBA) with a minimum of 5 years of hands-on experience to join our team. The ideal candidate will have a strong ability to work independently with minimal supervision while managing our SQL Server databases and associated tools. The DBA will play a crucial role in ensuring database performance, security, and reliability, while actively participating in reporting and ETL processes to support organizational data needs.Analyzes information requirements of new or modified systems and develops data file specifications. Assists Project Leaders, Systems Analysts, and Programmers with the implementation of data files to the City's Information Systems. Creates and assigns descriptors to elements needed for data organization, access and control. Anaylzes current and planned database usage and makes recommendations to management for improving and modifying database structure. Performs other job-related duties as required. TYPICAL TASKS: Develops file data specifications including standard names for data elements. Consults with and assists Project Leaders on procedures related to new or existing data file structures. Monitors and analyzes the performance of databases and prepares reports on findings to management including recommendations for improvement. Assists Project Leaders, Systems Analysts, and Programmers with implementation of data files to database. Develops and documents standards for use, control, updating, and maintenance of databases. Interfaces with tech support and computer operations in the reorganization of databases and recovery and backup procedures.A High School Diploma or GED is required. A Bachelor's Degree in Computer Science, Business Administration, or closely related field from an accredited four (4) year college or university is required. Two (2) years experience in Database Management Systems (DMS) is required. (Substitution: Two (2) years of experience may be substituted for each year of college education lacking.) Must be proficient in Windows and Microsoft Office Suite. Must be able to lift and carry a minimum of thirty (30) pounds. A valid State of Ohio Driver's License is required.Key Responsibilities
Database Management:
- Utilize SQL Server Management Studio (SSMS) to manage SQL Server databases, including the configuration and maintenance of High Availability Groups.
- Create, troubleshoot, and tune T-SQL queries to optimize database performance and ensure efficient data retrieval.
Reporting Development:
- Use Visual Studio to create and modify reports using SQL Server Reporting Services (SSRS), ensuring that reports meet user requirements and provide accurate insights.
- Collaborate with stakeholders to gather reporting needs and develop tailored solutions.
ETL Process Development:
- Design, implement, and maintain ETL processes using SQL Server Integration Services (SSIS) through Visual Studio, ensuring streamlined data flows and integrity between systems.
- Regularly review and optimize existing ETL processes for efficiency and reliability.
Performance Monitoring:
- Monitor database performance using SSMS, identifying and resolving bottlenecks to maintain optimal operational efficiency.
- Conduct regular database maintenance tasks, including backups and restorations, to ensure data integrity and availability.
Security and Compliance:
- Implement and manage database security protocols, ensuring user access controls and permissions are appropriately configured.
- Maintain documentation of database configurations, processes, and compliance with industry standards.
Collaboration and Support:
- Work closely with application developers and system Analysts to enhance database usage and resolve issues as they arise.
- Utilize SQL Developer for occasional database management tasks to support various database environments.
Scripting and Automation:
- Write and execute PowerShell scripts as needed to automate routine tasks and streamline database management processes.
Data Transfer Management:
- Manage data transfers and integrations using FTP as required to facilitate smooth data operations and ensure data consistency across platforms.
Preferred Qualifications
- Bachelor’s degree in Computer Science, Information Technology, or a related field.
- Minimum of 5 years of experience as a Database Analyst or in a similar role.
- Strong proficiency in SQL Server Management Studio (SSMS) and T-SQL.
- Experience with Visual Studio for report development (SSRS) and ETL processes (SSIS).
- Familiarity with SQL Developer for database management tasks.
- Knowledge of PowerShell for scripting and automation tasks.
- Understanding of data transfer protocols, including FTP.
- Excellent problem-solving skills, with the ability to work independently and manage multiple tasks effectively.
- Strong communication skills, both verbal and written.
- This position requires on-site presence, and occasional after-hours support may be required during critical updates or incidents. If you are a motivated and experienced Database Analyst who thrives in a fast-paced environment, we encourage you to apply for this exciting opportunity.
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.
Salary : $65,000 - $75,000
