Senior Database Architect in Loudon, TN

7 days ago


Loudon, Tennessee, United States ShiftCode Analytics Full time
Database Administrator and Analyst

We are seeking a highly motivated and experienced Database Administrator and Analyst to join our Information Technology team at ShiftCode Analytics in Loudon, TN. As a critical member of our team, you will be responsible for designing and supporting our database infrastructure as well as helping us develop business intelligence structures for data analysis.

Key Responsibilities:

  • Implement and administer Microsoft SQL Server databases within a multi-tiered environment.
  • Manage database security, implement standard maintenance tasks, manage SQL Server configurations, and design database implementation strategies using best practices.
  • Patch and upgrade SQL Server, perform capacity planning, cluster setup, performance tuning, and monitoring.
  • Troubleshoot data and database issues, suggest resolutions, analyze processing issues, and identify solutions.
  • Build and monitor HA and DR systems using Failover Clustered instances, Always-On Availability Groups, Log Shipping, Mirroring, and Replication across different data centers.
  • Develop, maintain, and teach database standards and best practices.
  • Work with data owners to verify and obtain approval that transformed data retains its accuracy.
  • Resolve exceptions reported to data conversion and adapt business requirements developed by business systems analysts/development staff.
  • Model databases, develop tables, stored procedures, views, triggers, and other database objects, and work closely with developers to integrate databases with other applications.
  • Lead or own ETL process to/from any systems, assist in creating data analysis sets for reporting, and assist in creating multidimensional analytical data for reporting.

Requirements:

  • 7 years of experience working with Microsoft SQL Server.
  • 2 years of experience working with cluster mode.
  • 2 years of SQL performance tuning experience.
  • 2 years of DB design experience (preferred).
  • 2 years of SQL Server 2016 experience.
  • 1 year of capacity planning experience.
  • 1 year of disaster recovery experience.
  • Experience working in a Sarbanes-Oxley regulated company is preferred.
  • Experience with SQL 2016 Always-On, Availability Groups, and Failover.
  • Experience with data migration with different servers.
  • Knowledge of Index and Non-cluster Index.
  • A strong background in backend scripting.
  • Solid problem determination skills supporting Microsoft SQL problems.
  • Experience managing large databases in real-time production environments.
  • Expertise in ETL tools, data conversion, data de-duplication, data cleansing methodologies, ETL, and data warehousing experience.
  • MICROSOFT SQL certification is a plus.
  • Excellent written and verbal communication skills.
  • Ability to work well independently and within a team environment.

Estimated Salary: $120,000 - $180,000 per year



  • Loudon, Tennessee, United States Upstream Rehabilitation , Inc. Full time

    Job OpportunityWe are seeking a skilled Physical Therapist Assistant to join our team at Upstream Rehabilitation, Inc. in Loudon, TN.About the RoleThe successful candidate will provide exceptional care and support to patients as part of our interdisciplinary team.ResponsibilitiesAssist licensed physical therapists with patient evaluations and treatment...


  • Loudon, Tennessee, United States Maxim Healthcare Service Full time

    As a home healthcare nurse with Maxim Healthcare Services in Loudon, TN, you will have the opportunity to provide quality care to medically fragile patients in the comfort of their own homes. Our skilled nursing team is dedicated to delivering exceptional patient outcomes and fostering strong relationships with our clients and their...


  • Loudon, Tennessee, United States Innova Solutions Full time

    Industrial Materials Handler Job DescriptionWe are seeking an experienced Industrial Materials Handler to join our team at Innova Solutions. This is a full-time contract position with a duration of 11 months, based in Loudon, TN.About the Role:The successful candidate will be responsible for loading and unloading trucks, moving materials throughout the...


  • Loudon, Tennessee, United States Food Lion Full time

    Job DescriptionAs a Produce Sales Associate at Food Lion in Loudon, TN, you will be responsible for maintaining a clean and organized produce department, while also providing exceptional customer service to our customers.Key Responsibilities* Clean and maintain produce shelves and displays, including sweeping and mopping floors as needed* Restock produce...


  • Loudon, Tennessee, United States Food Lion Full time

    OverviewWe are seeking an experienced retail associate to join our team at Food Lion in Loudon, TN. As a Produce Sales Associate, you will be responsible for ensuring that our produce department is fully stocked and maintained, while also providing exceptional customer service to our customers.Responsibilities* Restock produce shelves and ensure that all...


  • Loudon, Tennessee, United States CareStaff Partners Full time

    At CareStaff Partners, we are seeking a highly skilled Physical Therapist Assistant (PTA) to join our team for a contract position at an Outpatient Rehab in Loudon, TN.About the RoleWe are looking for a PTA with recent experience in Long Term Care settings. As a PTA with our team, you will be working with adult and geriatric patients in a dynamic outpatient...


  • Loudon, Tennessee, United States CareStaff Partners Full time

    Physical Therapist Assistant Opportunity in Outpatient RehabCareStaff Partners is seeking a skilled Physical Therapist Assistant (PTA) for a rewarding travel or local contract position in an Outpatient Rehab setting in Loudon, TN.Job Details:Specialty: PTA - Physical Therapist AssistantSetting: Outpatient RehabPatient Population: Adult and Geriatric...


  • Loudon, Tennessee, United States MedAdventures Full time

    We are seeking a dedicated and compassionate Physical Therapist to join our team at MedAdventures. This role involves working with diverse populations, including geriatrics, pediatrics, and outpatient clients, in both clinic settings and home health environments.Key Responsibilities:Evaluate patients' physical conditions and develop individualized treatment...


  • Loudon, Tennessee, United States Primient Full time

    Join Primient as a Human Resources GeneralistWe are seeking an experienced HR professional to join our team at our Loudon, TN site. As a key player in sustainable manufacturing, you will be responsible for shaping our people strategy and implementing HR processes and initiatives.About the OpportunityThis exciting role offers the opportunity to work with a...


  • Loudon, Tennessee, United States Fox Rehabilitation Full time

    About FOX Rehabilitation">We are a primarily clinician-operated, professional private practice of full-time physical, occupational, and speech therapists. Our one-on-one care fosters a rewarding environment, and therapists have the flexibility to shape their schedules for a successful work-life balance.">Our Team is Growing">We are currently seeking...


  • Loudon, United States Marvel Medical Staffing Full time

    Specialty: Physical TherapistLocation: Loudon, TNStart date: ASAPShifts per week: Duration: 13 weeksShift type: DaysWeekly gross pay: Contact us for more information!


  • Loudon, United States Marvel Medical Staffing Full time

    Specialty: Physical TherapistLocation: Loudon, TNStart date: ASAPShifts per week:Duration: 13 weeksShift type: DaysWeekly gross pay: Contact us for more information!


  • loudon, United States Marvel Medical Staffing Full time

    Specialty: Physical TherapistLocation: Loudon, TNStart date: ASAPShifts per week:Duration: 13 weeksShift type: DaysWeekly gross pay: Contact us for more information!


  • loudon, United States MedAdventures Full time

    *Job Overview*We are seeking a dedicated and knowledgeable Physical Therapist to join our team. The ideal candidate will possess a strong understanding of human physiology, anatomy, and medical terminology, with the ability to develop effective care plans tailored to individual patient needs. This role involves working in various settings, including clinics...


  • Loudon, United States Marvel Medical Staffing Full time

    Specialty: Physical Therapist AssistantLocation: Loudon, TNStart date: ASAPShifts per week: Duration: 13 weeksShift type: DaysWeekly gross pay: Contact us for more information!


  • Loudon, United States Concentric Healthcare Staffing Full time

    Concentric is currently seeking candidates in Therapy profession with focus in Physical Therapist (Allied Health) for a 13 week contract in the Loudon, TN area. Concentric is a premier staffing firm dedicated to matching outstanding talent with exceptional opportunities. Our commitment to excellence and our consultative approach has helped us become a...


  • Loudon, United States Concentric Healthcare Staffing Full time

    Concentric is currently seeking candidates in Therapy profession with focus in Physical Therapist (Allied Health) for a 13 week contract in the Loudon, TN area. Concentric is a premier staffing firm dedicated to matching outstanding talent with exceptional opportunities. Our commitment to excellence and our consultative approach has helped us become a...


  • loudon, United States Concentric Healthcare Staffing Full time

    Concentric is currently seeking candidates in Therapy profession with focus in Physical Therapist (Allied Health) for a 13 week contract in the Loudon, TN area. Concentric is a premier staffing firm dedicated to matching outstanding talent with exceptional opportunities. Our commitment to excellence and our consultative approach has helped us become a...


  • Loudon, United States Concentric Healthcare Staffing Full time

    Concentric is currently seeking candidates in Therapy profession with focus in Physical Therapy Assistant (Allied Health) for a 13 week contract in the Loudon, TN area. Concentric is a premier staffing firm dedicated to matching outstanding talent with exceptional opportunities. Our commitment to excellence and our consultative approach has helped us become...


  • loudon, United States DoorDash Full time

    Do you have a car, scooter or motorcycle? Do you know Loudon, TN like the back of your hand? Then get paid good money just for delivering delicious food to hungry locals whenever you have some spare time. DoorDash lets you decide when you want to work. That’s why hundreds of people are choosing to become Dashers every week - as a Dasher, you will deliver...


  • Loudon, United States Ardor Health Solutions Full time

    Description: Estimated payment breakdown $1,960 per week in taxable pay and non-taxable stipends Specialty: PT Start Date: 12/2/2024 Duration: 13 40 hours per week Shift: 5x8 Days Employment Type: Traveler Ardor Health Solutions is looking for a Physical Therapist to join our travel team in a OUT PATIENT setting, in Loudon, TN! This is a full time travel...

  • Light Industrial

    1 month ago


    Loudon, United States Innova Solutions Full time

    A client of Innova Solutions is looking for Material HandlerPosition type: Full-time - Contract Duration: 11 months Location: Loudon, TNAs Customer Service Representative, you will be:


  • Loudon, United States GO Healthcare Staffing Inc Full time

    Our client in Loudon TN has a 8HR DAY travel position for an Therapist traveler with current Physical Therapy - PT experience. The ideal candidate must have at least 2 years of experience, with active Therapist license and BLS and/or ACLS (if required) certified by the American Heart Association What makes Go Healthcare Staffing Different? ...


  • Loudon, United States GO Healthcare Staffing Inc Full time

    Our client in Loudon TN has a 8HR DAY travel position for an Therapist traveler with current Physical Therapy - PT experience. The ideal candidate must have at least 2 years of experience, with active Therapist license and BLS and/or ACLS (if required) certified by the American Heart Association What makes Go Healthcare Staffing Different?From the first...


  • loudon, United States GO Healthcare Staffing Inc Full time

    Our client in Loudon TN has a 8HR DAY travel position for an Therapist traveler with current Physical Therapy - PT experience. The ideal candidate must have at least 2 years of experience, with active Therapist license and BLS and/or ACLS (if required) certified by the American Heart Association What makes Go Healthcare Staffing Different?From the first...


  • Loudon, United States Maxim Healthcare Service Full time

    Private duty nursing (PDN) allows medically fragile patients to receive quality, skilled nursing care in the comfort of their home: a setting preferred by most patients and their families. City State Zip Modality Skills Days Shift Pay Range Loudon TN 37774 LPN/RN G-tube Monday - Friday 7:30 am - 5:30 pm out of school and...


  • Loudon, United States Maxim Healthcare Service Full time

    Private duty nursing (PDN) allows medically fragile patients to receive quality, skilled nursing care in the comfort of their home: a setting preferred by most patients and their families. City State Zip Modality Skills Days Shift Pay Range Loudon TN 37774 LPN/RN G-tube Monday - Friday 7:30 am - 5:30 pm out of school and 8:30 am - 5:30 pm during school...


  • Loudon, United States GO Healthcare Staffing Inc Full time

    Our client in Loudon TN has a 8HR DAY travel position for an Therapist traveler with current Physical Therapist Assistant - PTA experience. The ideal candidate must have at least 2 years of experience, with active Therapist license and BLS and/or ACLS (if required) certified by the American Heart Association What makes Go Healthcare Staffing...


  • loudon, United States Fox Rehabilitation Full time

    Now Hiring - Full Time (30-40 hours a week) Our team is growing, and we're looking for top-caliber Physical Therapists to join us in Loudon and surrounding locations in Tennessee. Why Ageility powered by FOX Rehabilitation? • Provide physical therapy services in a 1:1 setting to help abolish ageism. • Drive rewarding patient outcomes. • Facilitate...


  • loudon, United States Fox Rehabilitation Full time

    Now Hiring - Full Time(30-40 hours a week) Our team is growing, and we're looking for top-caliber Physical Therapists to join us in Loudon and surrounding locations in Tennessee. Why Ageility powered by FOX Rehabilitation? • Provide physical therapy services in a 1:1 setting to help abolish ageism. • Drive rewarding patient outcomes. • Facilitate...