Database Analyst jobs in Ann Arbor, MI

We are looking for a Database Engineer to design stable and reliable databases, according to our company’s needs. You will be responsible for developing, testing, improving, and maintaining new and existing databases to help users and applications retrieve data effectively. As part of our Engineering team, you will work closely with application developers, business analysts, and quality assurance personnel to ensure system consistency. You will collaborate with administrators and clients to provide technical support and identify new requirements. Communication and organization skills are keys for this position. Ultimately, you should be able to ensure our database systems run efficiently and securely daily.

Responsibilities

· Design stable, reliable and effective databases

· Optimize and maintain legacy systems as well as help design new systems

· Modify databases according to requests and perform tests

· Solve database usage issues and bugs

· Perform database migrations for sprint releases

· Liaise with developers to improve applications and establish best practices

· Gather user requirements and identify new features

· Develop technical and training documentation

· Build dashboards and ad hoc reports to synthesize and aggregate data across multiple sources for internal and external stakeholders

· Performs ad-hoc analysis using SQL query language within the database systems using a process-oriented approach

· Design and develop database objects, tables, stored procedures, views and triggers

· Collaborate with software engineers on multiple teams to facilitate database query optimization and SQL development needs

· Work closely with the other areas of the Business (such as Engineering and Product) on design and implementation to ensure business requirements are being met accurately and in a scalable matter and communicated to the business at large

Required Skills

· 3 years work experience as a database developer

· Relational database design and development using tables, triggers, views, functions, partitions, indexes.

· In-depth understanding of data management (e.g. permissions, recovery, security, and monitoring)

· Hands on experience with SQL querying languages

· Familiarity working with .Net Framework, PowerShell, Python, Shell Scripting, Postgres, Microsoft SQL Server, Amazon AWS, Windows Azure, Power BI experience is a plus

· Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues etc.

· Proven analytical problem solving and debugging skills

· Excellent analytical and organization skills

· Excellent verbal and written communication skills

Preferred Skills

· Experience with Liquibase or similar migration applications

· Lambda

· GitLab, CI/CD

· Data warehousing, ETL, data archiving

· Knowledge of software development and scripting

· BS degree in Computer Science or relevant field

· Agile software development experience