Database Engineer - Ann Arbor, United States - CMK Resources, Inc.

    CMK Resources, Inc.
    CMK Resources, Inc. Ann Arbor, United States

    2 weeks ago

    Default job background
    Description

    CMK Resources is seeking a Database Engineer to design stable and reliable databases, according to our client'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 customers 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.

    This is a Direct Hire opportunity - Must be a US Citizen. This is also a Hybrid opportunity with an office in Ann Arbor, MI.

    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

    At CMK Resources, we value referrals If you know someone who would excel in this role, we'd love to hear from them.

    CMK Resources is an information technology services company that is focused on providing storage and data management related professional services. Our mission is clear – accelerate the operational readiness and value of our customers' technology investments. CMK is built on a promise to provide a personal experience to every customer and consultant across our partnership ecosystem. With origins as an IT staffing company, CMK's talent acquisition team consistently identifies top-tier IT talent.

    CMK has services-based partnerships with leading storage and data management technology providers, enterprise VARs and solution providers. We listen to customer challenges, understand upcoming projects, and recognize culture and technologies to identify the right solution with the right consultant. Our entire engagement and delivery model is led by our on-shore based industry-recognized experts. We provide unrivaled personal service, customer-centric services, and industry knowledge that transcends the competition.

    CMK Resources, Inc. is an Equal Opportunity Employer and does not discriminate on the basis of Sex or gender identity, Mental disability or physical disability, Religion, Age, National origin or ethnicity, Sexual orientation, Marital status, Veteran status or Parental status. Notice: Depending on your specific placement, you may be required to prove that you have received the COVID-19 vaccine or have a valid religious or medical reason not to be vaccinated. CMK Resources, Inc. is an Equal Opportunity Employer and reasonable accommodations will be considered.