Senior Applications DBA

  • Location: Durham, NC
  • Type: Contract
  • Job #32704

Senior Applications DBA
 

  • Local Durham, NC candidates only, please.
  • This is a hybrid position.

Job Description:

  • The client requires a Senior Applications DBA to support migration of Oracle database effort from on-prem to AWS cloud and development support of various applications for NC FAST in AWS Cloud.

Responsibilities:

  • Primary responsibilities include managing the application schema, design, and extensions within the database for development, test, and production environments for Oracle database on Linux platform. The responsibilities also include database technical support, performance tuning, application administration and consulting, and providing support for Oracle, Oracle Data guard, Oracle Golden Gate.
  • This resource will serve in a key role in the managing Oracle database on cloud platforms like AWS, Lead the development of procedures and best practices for effective database for high volume application system and providing database solution for application modernization.
  • This position is responsible for performing tasks associated with the Leading the management of the Curam application schema, design, and extensions within the database, in development, test and production environments.
  • Provision and manage Oracle database instances on AWS/LinuxInstall, configure, and troubleshoot Golden Gate for batch and online process synchronization for high volume database
  • Set up replication and high availability for Oracle databases using tools like Golden gate
  • Monitor Oracle database performance
  • Troubleshoot Oracle database problems
  • Perform backups and restores of Oracle databases
  • Work with application developers to identify and refine data requirements, table/database design, assist in SQL writing

Required Skills/Experience:

  • Demonstrable skills in designing schema, access patterns, locking strategy, SQL development, and tuning Oracle Databases in an enterprise environment Required 7 Years
  • Modifying the database structure, creation, and update to existing database objects per application needs Required 7 Years
  • Experience in configuring, monitoring, and Cache management for Oracle database servers Required 3 Years
  • Strong experience in allocating system storage and planning future storage requirements for the database system Required 3 Years
  • Experience in Install, configure, and troubleshoot/maintain Golden Gate Required 2 Years
  • Must have experience in implementing and supporting Oracle on AWS including EC2, RDS and S3 Required 2 Years
  • Experience authoring code in SQL, PL/SQL on Unix/Linux Required 5 Years
  • Proficiency in one or more shell scripting languages Required 2 Years
  • Hands-on experience enrolling users and maintaining system security, Controlling user access to the database, Locking down host access Required 5 Years
  • Monitoring performance metrics, response times, and request rates Required 5 Years
  • Designing and implementing backup/restore service and disaster recovery (DR) solutions Required 2 Years
  • Installing and upgrading the database software, Patching the software that powers database Required 3 Years
  • Good Analytical, Technical, Time Management, and Communication Skills Required 7 Years
  • Participate in on-call rotation and weekend work Required 5 Years
  • Experience with advanced security and Oracle DataGuard replication Required 2 Years
  • Experience in Oracle Data Masking and Subsetting Highly desired
  • Demonstrable skills with Curam Software and database schema Desired
Proper email communication will only be done to and from @astyra.com email addresses. Please ensure you are communicating with approved Astyra recruiters by checking this point when receiving offers and messages from us. Please ensure you are communicating within these guidelines and proper channels for the quickest possible interview consideration!

Home Health RN

  • Location: Durham, NC
  • Type: Contract
  • Job #32284

Are you an RN ready to make a difference in the lives of North Carolinians? Astyra is looking for passionate Home Health Registered Nurses  to join our team statewide! Keep reading to see if this is the right fit for you:

Why us? This opportunity is a chance to change your career and own your schedule. There is an added opportunity for growth within an innovative, person-centric healthcare organization.

We have engaged with Acentra Health Formerly Kepro to support North Carolina Medicaid Linking individuals & Families for Long Term Services and Supports (NC LIFTSS) project. NC LIFTSS was created to streamline access to LTSS programs. It covers a variety of services:

  • Process referrals and perform option counseling
  • Conduct assessments and quality assurance reviews
  • Provide service plan management and customer service
  • Conduct provider training for the following LTSS programs: State Plan Personal Care Services (PCS), Community Alternatives Program for Children (CAP/C) and Community Alternatives Program for Disabled Adults (CAP/DA). 

This exciting role requires you to travel within your region to conduct assessments, as well as, work out of your home office when needed. This offers flexibility in your weekly schedule. As part of the Personal Care Services (PCS) program, you’ll provide vital services to NC Medicaid Beneficiaries with medical conditions, cognitive impairments, or disabilities, ensuring they receive the hands-on assistance they need for daily living activities (ADLs).
As a PCS Home Health Registered Nurse, you’ll play a crucial role in determining needs-based eligibility for Medicaid-funded personal care services, whether in-home, adult care, or supervised living homes. This role is documentation-intensive to meet the needs of beneficiaries. Join us in this rewarding opportunity to help our community thrive and make a significant impact on the lives of those in need.
What you’ll need:

  • Registered Nurse, licensed by the state of North Carolina
  • Minimum of two years’ experience in home care setting is required.
  • Computer proficiency in Microsoft Excel, Word and Outlook and the ability to utilize computer equipment and web-based software to conduct work is required
  • Experience with community-based individuals needing personal assistance with ADL and IADL tasks is highly preferred.
  • Experience conducting PCS assessments highly preferred.
  • Experience with OASIS tool (or similar) highly preferred.
  • Knowledge of North Carolina Medicaid Clinical Coverage Policy (Clinical Policy) 3L and PCS Program Provider Manual highly desired
  • Knowledge of standards of practice related to Medicaid-funded Personal Care Services, home and community-based services (HCBS) programs, and EPSDT highly desired

What you’ll do:

  • Conducts assessment to determine whether the beneficiary meets eligibility, using state-approved standardized assessment tool(s).
  • Ensures that PCS are provided on a “needs basis” in quantities appropriate to the Beneficiary’s unmet need for services based on the severity of their medical condition, functional disability, physical, or cognitive impairment.
  • Ensures that the privacy and dignity of individuals receiving assessment for PCS is maintained at the highest standards.
  • Ensures that new, expedited, annual, change of status, mediation/appeals, reconsideration review, and derivative assessments are conducted within established timeframes.
  • Include an interview with family members and informal caregivers who are present at the time of the assessment.
  • Provide the Beneficiary with guidance and assistance, as necessary, to select PCS providers.
  • Conduct service plan reviews as needed.
  • Submit the completed assessments using state-approved interface
  • Participate in the Beneficiary’s mediation and appeal processes.
  • Respond to state inquiries regarding assessments conducted.
  • Attend and actively participate in staff meetings and conduct case consultations/peer reviews/internal auditing as assigned.
  • Develops level of care recommendations based upon clinical evaluations.
  • Participates in training of PCS stakeholders as needed.
  • Computer proficiency in Microsoft Excel, Word and Outlook and the ability to utilize computer equipment and web-based software to conduct work.

Skills & Abilities:

  • Insightful Understanding of public sector services and supports.
  • Interact and Collaborate with various office staff as needed to support necessary workflows, as well as healthcare professionals, patients, their families and other supports.
  • Effective Communication to individuals and groups through spoken, written and electronic media.
  • Attention to Detail and Highly Organized in documentation to effectively prioritize and execute tasks in a timely manner.
  • Person-Centered thinking, planning, and competency in awareness of the needs of persons with disabilities.

If this opportunity sounds like a bullseyes, apply today!  

Mileage reimbursement at the ready for all travel.