DesPlainesRecruiter Since 2001
the smart solution for Des Plaines jobs

Database Administrator

Company: AAOS
Location: Des Plaines
Posted on: January 11, 2022

Job Description:

Your meticulous attention to detail pairs nicely with your logical approach. You are conscientious, inquisitive and relish the idea of working in a dynamic environment. You are excited by defining and building data pipelines that will enable faster, better, data-informed decision-making within the business. You are passionate and able to quickly understand and guide significant projects to completion, while working collaboratively with colleagues and stakeholders - both technical and non-technical. You are collaborative, insightful and want to work for an organization making a difference in the field of orthopaedics on behalf our members and their patients.If -this sounds like you (or someone you know), please read on! - The -Database Administrator -position is primarily responsible for -keeping AAOSs data safe -and -accessible. - -This position -will -support our registry databases and environments along with providing support for the Academys database systems, warehouse, marts, and supporting applications. -The Database Administrator ensures all environments are up to date, planning and performing all upgrades. Helps build the structure and design of the database. Implements security measures for the data, monitoring and controlling access. Restores lost data. Creates new and refreshes environments. Merges databases, updates systems and creates data backups as necessary. Continually monitors database systems. Fully documents environments. Leads the effort to develop a unified enterprise data model for the Academy. - -Adds insights into the design, development, and -maintenance of -high-performance data platforms on premise and in Microsoft Azure cloud-based environments. - -including leading the development of a data warehouse environment to support the Registrys business intelligence roadmap. - -Designs, develops, and maintains the ETL pipelines using SSIS that standardize raw data from multiple data sources and optimize both the operational and dimensional/star schema data model necessary for transactional systems and business intelligence applications. Gathers business and functional requirements and translate these requirements into robust, scalable, operable solutions aligning to an overall data architecture. Extracts, transforms, and loads data to and from various data sources including relational databases, -Cosmo -database, web services, and flat files. Produces various technical documents such as ER diagrams, table schemas, data lineage, API documents, -standards, -templates -and naming conventions. -Provides leadership and oversight on database architectural design for existing Academy systems including database administration, -SQL -users -management, -performance monitoring, and troubleshooting. Provides analysis, conceptualizes, designs, implements, and develops solutions for critical data-centric projects. Performs dataflow, -system -and data analysis, and develops meaningful and useful presentation of data in downstream applications. Plans and implements standards -and templates for stored procedures and database objects, perform database design and data repository modelling. -Monitors ETL processes, system audits, dashboard reporting, and presentation layer functioning and performance. - - -Monitors database performance, provides optimization recommendations, and implements recommendations. Follows the release cycles and implements delivery of task assignments, defect correction, change requests, and enhancements. Troubleshoots and solves technical problems. - -Manages -all -database refreshes -for various environment and servers (UAT, QA, QA2, DEV). Performs database backups -and restores for Registry databases. -Champions the database upgrades for new releases and -deployment during release nights. -
Exemplifies -the -following -essential values -of the Academy: -
Teamwork: Effective collaboration and team-focus to solve complex problems and drive innovation. -
Empowerment: -The authority, information, and skills to make decisions and drive results. - Accountability: Ownership of process and results that drive decisions and ensure implementation. - Mindset of Growth/Continuous Learning: - Focused on and invested in self and staff development to become more adaptable, making the Academy more agile, innovative, and sustainable. -Travel: - - -

  • Up to 5 -days -per yearQualifications: Required:
    • Bachelors degree in Computer Science, Information Systems, Business Administration, or -another -related field required - -
    • Minimum of -5 -years of relevant work experience in a -Database Administrator -role leveraging SQL; -knowledge of Microsoft technology stack; background in Azure Infrastructure as a Service environment -preferred - -
    • Data modeling experience in building logical and physical data models -
    • Experience working with both structured and unstructured data - -
    • Applied knowledge of Microsoft Security/Authentication Concepts (Active Directory, IIS, Windows OS) -
    • Strong technical planning skills with the ability to prioritize and multitask across -several -work streams -
    • Must have a passion for continued improvement, learning, and mentoring -
    • Polished presentation skills; experience creating and presenting findings to executive level staff -
    • Strong written, -verbal, -and interpersonal communication skills, with an ability to communicate ideas and solutions effectively -
    • Must be highly collaborative with the ability to manage and motivate project teams and meet deliverables -
    • Ability to build strong stakeholder relationships and translate complex technical concepts to non-technical stakeholders -Desired: - -
      • Minimum of -2 -years of data warehousing experience including the design, development, and ongoing support of star or snowflake data schemas to support business intelligence applications -
      • Demonstrated understanding of Business Intelligence and data solutions including cubes, data warehouse, data marts, and supporting schema types (star, snowflake, etc.) -
      • Knowledge of SSRS or PowerBI - - -
      • Experience with SSIS - -
      • Experience with NOSQL - - - -
      • Health Care industry experience - - -
      • Experience with Cosmos, -Azure Data FactoryIf this describes YOU, please apply by sharing the -following: - - -Clearly communicate why you are the ideal candidate for this role, providing specific examples and experiences as proof points. -Resumes must be accompanied by a cover letter with salary expectations to be considered. -Please note:This position is based in Rosemont, Illinois and is open to applicants who are able to relocate to commuting distance to that office. Alternatively, the position may be performed remotely and is open to applicants in any U.S. state other than California, Colorado, Montana and New York.
        AAOS requires all employees to be fully vaccinated against COVID-19. An applicant(i) who is disabled -or -who has a qualifying medical condition that contraindicates a COVID-19 vaccination, or (ii) who objects to being vaccinated on the basis of a sincerely held religious belief, observance or practice may request -a reasonable accommodation. This determination will be made on a case-by-case basis and in accordance with applicable law -and public health guidance. Any medical information concerning an applicant's disability will be treated as a confidential medical record in compliance with applicable federal, state and local laws. - -Exemptions from the vaccine policy may also be provided to fully remote positions that do not involve any business travel or in-person work activities. -

Keywords: AAOS, Des Plaines , Database Administrator, IT / Software / Systems , Des Plaines, Illinois

Click here to apply!

Didn't find what you're looking for? Search again!

I'm looking for
in category

Log In or Create An Account

Get the latest Illinois jobs by following @recnetIL on Twitter!

Des Plaines RSS job feeds