Database Administrator - Elkin, United States - Partners Behavioral Health Management

Partners Behavioral Health Management Elkin, United States

3 weeks ago

Description

Competitive Compensation & Benefits Package
Position eligible for –

Annual incentive bonus plan
Medical, dental, and vision insurance with low deductible/low cost health plan
Generous vacation and sick time accrual
12 paid holidays
State Retirement (pension plan)
401(k) Plan with employer match
Company paid life and disability insurance
Wellness Programs

See attachment for additional details.

Location: Remote option available for any of our locations

Projected Hiring Range: Depending on Experience

Closing Date: Open Until Filled

Primary Purpose of Position:

This position is responsible for managing and supporting database platforms on prem, in Azure, hosted, and as part of Disaster Recovery, working closely with the vendors, external consultants, application support teams, technical support team, and network administrators; recognizing areas for improvement in the team; taking appropriate action to initiate changes; installing, configuring, upgrading, and maintaining database instances; recommending and implementing database security policies; recommending and implementing database backup, recovery, and redundancy strategies; implementing automated monitoring to ensure proactive handing of issues; working independently to perform database performance analysis, capacity planning, system sizing and ongoing maintenance; recommending best practices and performing other tasks assigned by the supervisor.

Role and Responsibilities:

50% *Database Administration

Install, configure, and maintain the performance of database servers.
- On-Prem
- Azure
- Hosted
- DR/BC
Monitor the performance of database hardware and software.
Monitor Azure and SQL Recommendations and implement best practices.
Reduce operational costs by optimizing routine administrative tasks.
Administer, patch and monitor performance of database servers.
Perform database migration and upgrade tasks.
Design, develop, implement Structure Query Languages (SQL) databases and analytical procedures.
Certifies accuracy and completeness of applications by preparing data and testing features, functionality, and results.
Develop processes for optimizing database access and security.
Prepares documentation of all procedures, changes or maintenance in applications
Create automation for repetitive database tasks.
Perform database backup and recovery.
Administer high availability (HA) database environment.
Research complex data issues: examine data in various source systems for inconsistencies, review transformation logic and propose corrective alternatives.
Confer with people originating, handling, processing, or receiving reports to identify problems and to gather suggestions for improvements.
Evaluate findings, using knowledge of workflow, operating practices, records retention schedules, and office equipment layout.
Participates on committees and other structured workgroups as a technical resource and as an IT Department liaison.
Deploy database code to development, test, and production environments.
Create and maintain documentation of database systems.
Creates complex reports and Data Cubes using various software tools such as structured query language (SQL), Microsoft (SSRS), (SSAS), SSIS, and Microsoft Excel.

30% *Application/Database Analysis and Development Support.

Develop and modify existing databases and database management systems to meet the evolving requirements of the LME/MCO.
Test programs or databases, correct errors and make necessary modifications.
Work as part of a project team to coordinate database and reporting development and determine project scope and limitations.
Identify and evaluate industry trends in database systems to serve as a source of information and advice for the Applications Support Manager and the SQL Development Manager. Write and code logical and physical database descriptions and specify identifiers of database to management system or direct others in coding descriptions.
Review workflow charts developed by system analysts to understand tasks computers will perform, such as updating records.
Independently audit and verify system information from both systems generated, and user produced reports for consistency and accuracy.
Assist IT staff with the development of automated processes as required in completion of the current and long-range goals set forth by the Applications Support Manager. Works with Project Teams and business resources to gather business requirements and drive functional and technical designs for Business Intelligence solutions (Data Warehouse, ETL, Metadata, Operational/Tactical/Strategic Reporting, and Dashboards)
Deliver projects on time and within budget with a high degree of quality.
Work with multiple cross-functional project teams to accomplish development activities that will include (but not be limited to) logical and physical data modeling leveraging BI design principles, semantic layer modeling and design, universe design and development, report design, development, testing and deployment, dashboard design, development, testing and deployment.
Create complex technical reports and reporting infrastructure including data definitions and views.
Conduct comprehensive analysis to produce complex documents that clearly define quality assurance, testing criteria, prototypes and mock-ups; measure results in sufficient detail; utilize version control for requirements.
Compile and integrate data from outside sources; analyzes errors in digital file exchange and makes corrections.
Responsible for the strict adherence all Federal and State Laws, Rules and Regulations including but not limited to the following: HIPAA, HITECH, FERPA, etc. and Industry Recognized Security Standards (ex. NIST).
Obtains, analyzes, queries and manipulates data as directed by supervisor.

20% *Special projects

Automation projects
ETL projects

Performs other job-related tasks as required.

Knowledge, Skills and Abilities:

Considerable knowledge of computers and related information technology devices
Considerable knowledge of programming techniques, the appropriate programming language(s), operating systems, and the capabilities and limitations of computer and peripheral equipment
Demonstrated technical aptitude through strong analytical skills, problem identification and resolution, organizational skills, creativity, and critical thinking.
Excellent customer service; written and oral communication skills; and effective listening skills required in working with users and team members.
Ability to communicate effectively with users who may not be coherent in clarifying problem situations.
Ability to understand operations and organize component parts into a logical system.
Ability to work under time constraints, be able to multitask and be able to make adjustments to be able to meet the dynamic needs of the company and its users. Ability to display a positive attitude and show initiative to meet and/or exceed departmental goals and customer expectations.
Ability to communicate well with staff at various levels throughout the agency to understand their needs and communicate how they can leverage technology to successfully complete their assigned tasks.
Ability to display a positive attitude and show initiative to meet departmental goals and customer expectations.
Demonstrated strong work ethic by contributing high quality work to a number of projects, a willingness to be available as required outside standard hours, personal motivation, and the ability to meet or exceed deadlines.

Education/Experience Required: Bachelor's degree in Information Technology, engineering, or computer science, or equivalent work experience.

Minimum of 5+ years of experience performing Database administration or database engineering duties for database internals, and you have experience supporting these database platforms: SQL Server, MySQL

Minimum of 3 years of experience supporting software engineering teams through the software development lifecycle

Minimum of 3 years of experience deploying, operating, and monitoring infrastructure in the AWS cloud of training and experience.

Service and Sales Assistant

1 week ago

Yugo Ronda, United States

Overview: · Yugo is the trusted name for student housing, globally. Every day we connect young people to opportunities and students to amazing spaces. Here at Yugo, we like to do things differently. It's about people, planet, and passion. · We are looking for #Futureshapers who ...
Human Services Assistant III

5 days ago

Commonwealth of Virginia Galax, United States

Hiring Range: $13.69 to $14.42 · Full Time or Part Time: Part Time · Title Description- Human Services Assistant III represents the specialist level in the occupational group for Human Services Assistants. Employees serve as the initial point of contact for clients seeking bene ...
Marketing Coordinator

1 week ago

One Hour Heating & Air Conditioning Mount Airy, United States

POSITION SUMMARY : The Marketing Coordinator is responsible for the administration, development and reporting of company marketing efforts, websites, lead sources and promotions to ensure that marketing strategies are on track. NOTE: This is NOT a work from home position. PRIMAR ...
Supply Chain Analyst

2 weeks ago

Triumph Group Clemmons, United States

Responsibilities · Position Profile: Supply Chain Data Analyst · FLSA: Exempt · Reports to: Manager, Procurement · Summary: · The Supply Chain Data Analyst will conduct data analysis and data mining to improve our supply chain operations. In this role, you should have an analyti ...
Sr Department Coordinator

2 weeks ago

Brandeis University Brandeis, United States

Brandeis University is delighted to announce a career opportunity for a Senior Department Coordinator. If you are looking for an opportunity to work at a beautiful university campus with lots of perks including free parking and access to a top of the line athletic facility, look ...
Director, Finance

23 hours ago

Stonewood Group Cana, United States

About the Client Our Client is a non-profit corporation supported by membership fees, with major funding of its programs and activities provided by the Government of Canada. · Established in 1993, Client manages an ultra high-speed network, hundreds of times faster than the inter ...
RTO Clerk

1 week ago

Leonard Aluminum Utility Buildings Mount Airy, United States

Job Description · Job DescriptionDescription:Location: Mt. Airy, NC, Hybrid option · Established in the Blue Ridge foothills of North Carolina in 1963, Leonard Buildings and Truck Accessories is a manufacturer and distributor whose product lines include storage buildings, cargo a ...
Customer Service Specialist

3 weeks ago

AdaptHealth LLC North Wilkesboro, NC, United States

: · AdaptHealth Opportunity - Apply Today At AdaptHealth we offer full-service home medical equipment products and services to empower patients to live their best lives - out of the hospital and in their homes. We are actively recruiting in your area. If you are passionate about ...
LPN / IDD Nurse

1 day ago

RHA Health Services Westfield, United States

We are hiring for: · LPN / IDD Nurse · Type: · Regular · If you are a positive and personable individual looking for a satisfying and fun opportunity to make a real difference in the lives of people with intellectual, developmental disabilities, and people facing mental healt ...
Administrative Assistant to Chief Technology Officer

6 days ago

Wilkes County School District North Wilkesboro, United States

ADMINISTRATIVE ASSISTANT TO CHIEF TECHNOLOGY OFFICER · Wilkes County Schools provides a robust variety of state and local benefit offerings that include but are not limited to health insurance, annual leave, sick leave, holiday pay, dental insurance, vision insurance, life insur ...
Data Manager/Bookkeeper

6 days ago

Wilkes County School District North Wilkesboro, United States

DATA MANAGER · NATURE OF WORK · An employee in this class performs technical-clerical work preparing and maintaining a variety of computer databases pertaining to student attendance and demographic statistics in an assigned school. Work involves utilizing specialized computer-dr ...
Office Manager

2 weeks ago

MasTec Advanced Technologies Rural Hall, United States

Overview · Company Summary · MasTec Utility Services delivers critical infrastructure construction and engineering services for power delivery, gas, and water customers, specializing in overhead and underground electric distribution for power delivery systems, gas distribution co ...
Director of Fundraising/Development

3 weeks ago

Horizons Residential Care Rural Hall, United States

Responsible for the execution and management of a comprehensive fundraising strategy to grow annual giving and support capital campaign(s). The Director manages annual fundraising, special fundraising activities, donor cultivation, and ensures a solid stewardship of gifts and pla ...
Director of Fundraising/Development

5 days ago

The Ladders Rural Hall, United States

Responsible for the execution and management of a comprehensive fundraising strategy to grow annual giving and support capital campaign(s). The Director manages annual fundraising, special fundraising activities, donor cultivation, and ensures a solid stewardship of gifts and pla ...
Housing Specialist

3 weeks ago

Vaya Health Taylorsville, United States

***This is a grant funded position.*** · LOCATION: Remote - must live in or near Alexander, Caldwell, or McDowell County, North Carolina. · GENERAL STATEMENT OF JOB: · Vaya's Housing Specialist - is responsible for implementing Vaya's - Balance of State program aimed to prov ...
Voter Registration Field Director

2 weeks ago

The Outreach Team Lewisville, United States

Job Description · Job DescriptionField Directors · The Outreach Team is a field firm specializing in face-to-face canvassing operations. We fuel the nation's leading progressive groups to raise money and impact critical elections. · We are currently seeking Field Directors to joi ...
Provider Data Coordinator II

1 week ago

Fidelis Care Various, United States Full time

You could be the one who changes everything for our 26 million members. Centene is transforming the health of our communities, one person at a time. As a diversified, national organization, you'll have access to competitive benefits including a fresh perspective on workplace flex ...
Provider Data Management Specialist I

3 weeks ago

Sunflower Health Plan Various, United States Full time

You could be the one who changes everything for our 26 million members. Centene is transforming the health of our communities, one person at a time. As a diversified, national organization, you'll have access to competitive benefits including a fresh perspective on workplace flex ...
Health Information Management Tech II

3 weeks ago

Atrium Health North Wilkesboro, United States Full time

Overview · Health Information Management Tech II · 40 hours per week · Schedule: Sunday - Thursday, 8 am - 4:30 pm · JOB SUMMARY: HIM Tech II is responsible for maintaining the quality, accuracy, accessibility and security of both paper and electronic medical records. Position f ...