Position Overview
The Database Analyst is responsible for managing, maintaining, and optimizing databases to support business operations and reporting needs. This role focuses on KPI and metric development, report generation, data analysis, database migrations, system monitoring, and ongoing database support across multiple platforms and computing environments. The ideal candidate has strong SQL expertise, experience with database administration and procedural coding, and the ability to analyze data requirements, improve database performance, and collaborate with technical teams to deliver reliable data solutions.
Key Responsibilities
- Create, manage, and maintain key performance indicators (KPIs), metrics, and reporting solutions.
- Develop and maintain reports, dashboards, alerts, and data monitoring processes.
- Perform database migrations, deployments, hardware replacements, and ongoing database maintenance.
- Monitor database performance, replication, and system operations across multiple platforms and environments.
- Coordinate with technical teams to support database patching, system updates, and vendor deployments.
- Develop Power BI reports and perform in-depth data analysis to identify trends, issues, and opportunities for improvement.
- Analyze data requirements, application architectures, processing environments, data dictionaries, and database schemas.
- Design, develop, modify, and optimize database structures to meet system and business requirements.
- Gather, analyze, and normalize data related to business processes and operations.
- Evaluate data accuracy, integrity, credibility, and relevance to support informed decision-making.
- Troubleshoot database issues and implement solutions to improve reliability and performance.
- Collaborate with cross-functional teams to support database systems and ongoing technical initiatives.
- Contribute to project delivery and provide technical guidance to junior team members as needed.
Required Qualifications
- Bachelor’s degree in Computer Science, Information Systems, or a related field, or equivalent professional experience.
- At least 5 years of IT experience in database administration, SQL procedural coding, database design, and related computing environments.
- Strong proficiency in Oracle PL/SQL and Microsoft SQL Server Transact-SQL (T-SQL).
- Experience supporting, maintaining, and optimizing databases in complex technical environments.
- Knowledge of database design, data structures, database schemas, and data management principles.
- Experience analyzing data, developing reports, and troubleshooting database-related issues.
Preferred Qualifications
- Experience with Power BI report and dashboard development.
- Experience with database migrations, replication, deployments, and performance monitoring.
- Familiarity with database patching, system monitoring, and vendor-managed deployments.
- Experience working across multiple database platforms and computing environments.
- Experience developing KPIs, metrics, alerts, and operational reports.
Required Skills and Competencies
- Strong analytical, troubleshooting, and problem-solving skills.
- Ability to interpret business and technical requirements and translate them into effective database solutions.
- Strong attention to detail and commitment to data accuracy and integrity.
- Excellent written and verbal communication skills.
- Ability to manage multiple projects and priorities in a deadline-driven environment.
- Ability to work independently and collaboratively as part of a technical team.
- Strong organizational skills and a commitment to continuous improvement.
Work Environment
This is an intermediate-level professional role involving moderately to highly complex technical assignments. The Database Analyst may contribute to multiple projects simultaneously, lead project activities as needed, and provide guidance to junior technical staff.