SQL Database Administrator

2 weeks ago


Kansas, United States Moonshot Solutions Full time

RESPONSIBILITIES

Considering making an application for this job Check all the details in this job description, and then click on Apply.
  • Plan and manage data extractions from various systems for migration of patient records
  • Create extraction scripts using SQL to pull and format all relevant data
  • Lead data migration calls with clients
  • Query performance and tuning to ensure timely and efficient data loads
  • Write SQL code for ETL process
  • Troubleshoot databases to identify and resolve issues, ensuring data integrity and system reliability
  • Monitor systems health and performance
  • Develop and maintain reports

QUALIFICATIONS

  • Proficient in SQL Query Optimization to enhance database performance
  • Experienced in the development and implementation of T-SQL Stored Procedures for efficient data processing
  • Experience/familiarity with ETL tables
  • Proficiency in data analysis and manipulation using tools such as SQL and Python
  • Strong analytical skills with the ability to translate complex data into actionable insights
  • Customer-centric mindset with a strong commitment to delivering high-quality solutions and exceeding customer expectations
  • A proactive and inquisitive learner who seeks out and capitalizes on opportunities for growth
  • Knowledge of setting up and implementing SSRS (SQL Server Reporting Services) for comprehensive reporting solutions
  • Familiarity working with Stored Procedures
  • Technical Skills: SQL, T-SQL, MySQL, Stored Procedures, ETL, Python, Hadoop, Git/Gitlab, Windows, MS Office, EHR
  • Strong written and oral communication skills
  • Healthcare industry experience (highly preferred)

EXTRA DETAILS

  • THIS IS AN ON-SITE POSITION IN KANSAS CITY - NO REMOTE OPTIONS
  • NOT OPEN FOR CORP-TO-CORP OR H1B SPONSORSHIPS - MUST BE A US CITIZEN
  • THIS IS A JUNIOR-LEVEL ROLE WITH A TON OF GROWTH POTENTIAL


  • Kansas City, United States Moonshot Solutions Full time

    RESPONSIBILITIES Plan and manage data extractions from various systems for migration of patient records Create extraction scripts using SQL to pull and format all relevant data Lead data migration calls with clients Query performance and tuning to ensure timely and efficient data loads Write SQL code for ETL process Troubleshoot databases to identify and...

  • Senior SQL Database Administrator with Security Clearance

    Found in: Dice One Red US C2 - 2 weeks ago


    Kansas City, United States Peraton Full time

    About Peraton Peraton is a next-generation national security company that drives missions of consequence spanning the globe and extending to the farthest reaches of the galaxy. As the world's leading mission capability integrator and transformative enterprise IT provider, we deliver trusted, highly differentiated solutions and technologies to protect our...

  • Commissions Systems Administrator

    Found in: Resume Library US A2 - 2 weeks ago


    Leawood, Kansas, United States SelectQuote, Inc. Full time

    About the Role: Commissions System Administrator   Job Summary: We are seeking a highly motivated and detail-oriented Commissions Systems Administrator to join our team. The Commissions Systems Administrator will play a crucial role in understanding and managing the compensation process for our organization. This role involves a deep understanding of...

  • Administrator II

    1 week ago


    Kansas City, United States US Logistics Solutions Full time

    Job DescriptionJob Description**Job Summary:**We are looking for an Administrator II to join our team as an equal opportunity employer. In this role, you will contribute to the smooth operation of our office through strong organizational skills, effective communication, and attention to detail.**Qualifications:**- Bachelor's degree in Business...

  • Administrative Assistant

    Found in: Appcast Linkedin GBL C2 - 3 weeks ago


    Kansas City, United States Morgan Hunter Full time

    Are you ready to kickstart your career in Human Resources/Payroll Administration? Our client is searching for an Administrative Assistant to become an integral part of their Human Resources Operations and Payroll Administration team! As an Administrative Assistant, you'll support various vital functions of HR, with an emphasis in onboarding and payroll...

  • Administrative Assistant

    Found in: Appcast US C2 - 2 weeks ago


    Kansas City, United States Morgan Hunter Full time

    Are you ready to kickstart your career in Human Resources/Payroll Administration? Our client is searching for an Administrative Assistant to become an integral part of their Human Resources Operations and Payroll Administration team! As an Administrative Assistant, you'll support various vital functions of HR, with an emphasis in onboarding and payroll...


  • Kansas City, United States Morgan Hunter Full time

    Are you ready to kickstart your career in Human Resources/Payroll Administration? Our client is searching for an Administrative Assistant to become an integral part of their Human Resources Operations and Payroll Administration team! As an Administrative Assistant, you'll support various vital functions of HR, with an emphasis in onboarding and payroll...

  • Administrative Assistant

    Found in: Appcast Linkedin GBL C2 - 3 weeks ago


    Kansas City, United States Morgan Hunter Full time

    Administrative AssistantKansas City, MOOur client is seeking a skilled Administrative Assistant to provide essential support to our office, focusing on client assistance, database management, and schedule coordination. If you excel at organization and communication, thrive in a dynamic environment, and possess essential financial services experience, we'd...

  • Tax Examining Technician

    Found in: Talent US 2 C2 - 2 weeks ago


    Kansas City, United States Internal Revenue Service Full time

    Summary Eligibilities being considered and other IMPORTANT information. WHERE CAN I FIND OUT MORE ABOUT OTHER IRS CAREERS? Visit us on the web at Duties WHAT IS THE WAGE AND INVESTMENT (W&I) DIVISION? A description of the business units can be found at: Vacancies will be filled in the following specialty areas: Wage and Investment...

  • Administrative Assistant

    Found in: Resume Library US A2 - 1 week ago


    Olathe, Kansas, United States Johnson County Kansas Full time

    Overview: A career with Johnson County Government is more than just a job, it is an opportunity to serve a diverse and expanding community in meaningful ways. We challenge ourselves to be a different kind of government because we care deeply about our community and each other. Committed to our shared values, we provide excellent public service, seeking...

  • Data Scientist with Security Clearance

    Found in: Dice One Red US C2 - 2 weeks ago


    Kansas City, United States Mission Services LLC (MSI) Full time

    The ISB Database Scientist is responsible for the design, build, automation, support, security, management, and optimization of databases, such as Oracle and Microsoft SQL Server on Windows or Linux Servers. Databases may be developed in house, commercial off-the-shelf (COTS), or Government off-the-shelf (GOTS). • Design, develop, enhance, and support new...


  • Kansas City, United States Sorella Group Full time

    Job DescriptionJob DescriptionSalary: $18/hr - $20/hrJOB DESCRIPTION:Sorella Group, Inc. is a national specialty contractor and building material supplier. You will play a vital role in supporting the overall operations of our Kansas City office. This position requires a detail-oriented, organized, and proactive individual capable of managing receptionist...


  • Kansas City, United States Sorella Group Full time

    Job DescriptionJob DescriptionSalary: $18/hr - $20/hrJOB DESCRIPTION:Sorella Group, Inc. is a national specialty contractor and building material supplier. You will play a vital role in supporting the overall operations of our Kansas City office. This position requires a detail-oriented, organized, and proactive individual capable of managing receptionist...


  • Kansas City, United States Newcore Technology Group Full time

    Job DescriptionJob DescriptionSalary: Newcore Technology Group provides flexible, scalable Information Technology staffing and consulting solutions that help clients and employees transform and evolve while delivering true business value.   We are assisting our client, a printing and digital media organization, in their search for a Systems...


  • Kansas City, MO, United States ORACLE Full time

    The Systems Engineer I (Data Protection) needs a strong understanding of core data protection processes. Basic understanding of other core IT concepts: storage, networking, security, guest operating systems, and general troubleshooting skills is required. Required Qualifications • Receipt of the appropriate government security clearance card applicable for...


  • Kansas City, United States Frontier Schools Full time

    Job DescriptionJob DescriptionSalary: $73,000 per yearDescription: Responsible for assisting the principal and assistant principals and providing administrative leadership   necessary to create a safe and orderly school environment.Job type: Full timeClassification: Exempt Calendar Type: 11 Month (Calendar 2)QUALIFICATIONS: Bachelor’s degree from...


  • Kansas City, United States TCI Technology Consulting Inc Full time

    TCI has an immediate need for a Remote 3rd Shift Production Support Analyst. This is not a Corp2Corp opportunity. This is a long-term contract opportunity with the possibility of hire. In addition to competitive, market-rate based pay, TCI provides all our Consultants with Comprehensive Medical/Dental Insurance, 401k, Life Insurance and Long-Term Disability...

  • IT Business Analyst

    Found in: beBee jobs US - 3 weeks ago


    Kansas City, Missouri, United States GROM Associates, Inc Full time

    The IT Business Analyst will interface with users and ensure that requirements are effectively documented, and will provide detailed project status reports to the project management team on a regular basis.Candidates must have 2+ years of IT Business Analyst experience with Epicor 21 or comparable ERPs in a manufacturing or supply chain context.Identify,...

  • Data Scientist with Security Clearance

    Found in: Careerbuilder One Red US C2 - 3 weeks ago


    Kansas City, MO, United States Mission Services LLC (MSI) Full time

    The ISB Database Scientist is responsible for the design, build, automation, support, security, management, and optimization of databases, such as Oracle and Microsoft SQL Server on Windows or Linux ServersDatabases may be developed in house, commercial off-the-shelf (COTS), or Government off-the-shelf (GOTS)• Design, develop, enhance, and support new and...


  • Kansas City, United States tekHouse Full time

    Remote Contract 6 month with possible extension Corp to Corp or 1099 Analyzes, designs, develops, modifies, writes, edits, and implements software programming applications. Job Duties: Analyzes and defines software requirements to determine specifications and standards. Proposes software solutions. Determines the cost of new and modified systems and engages...