Company:
Naphcare, Inc.
Location: Birmingham
Closing Date: 01/12/2024
Hours: Full Time
Type: Permanent
Job Requirements / Description
Overview:
NaphCare is hiring an experienced SQL Server Database Administrator to join our team on-site at our Corporate Headquarters in Birmingham, AL 35216.
The SQL Server DBA will be responsible for the implementation, configuration, maintenance, and performance of critical SQL Server RDBMS systems, to ensure the availability and consistent performance of our corporate applications. This is a “hands-on” position requiring solid technical skills, as well as excellent interpersonal and communication skills.
The successful candidate will be responsible for the development and sustainment of the SQL Server Warehouse, ensuring its operational readiness (security, health and performance), executing data loads, and performing data modeling in support of multiple development teams. The data warehouse supports an enterprise application suite of program management tools. Must be capable of working independently and collaboratively.
NaphCare is a family owned, healthcare technology company that has been delivering high quality healthcare to correctional facilities across the nation for over 35 years. Come join our team of over 6000 employees and growing! NaphCare pays well, offers outstanding benefits, and has an incredibly engaged corporate support team to make sure you have what you need to be truly excellent at what you do.
NaphCare partners with correctional facilities to provide proactive, patient-focused healthcare.
NaphCare Full Time Benefits:
Prescriptions free of charge through our health plan
Health, dental & vision insurance that starts day one!
We offer low-cost benefits to our employees and their families
Employment Assistance Program (EAP) services
100% vested 401K and Roth with company contribution that starts day one!
Tuition Assistance
Referral bonuses
On-site education
Free Continuing Education!
Term life insurance at no cost to the employee
Generous paid time off & paid holidays
Responsibilities:
Manage SQL Server databases through multiple product lifecycle environments, from development to mission-critical production systems.
Performance Tuning and monitoring of custom application
Understanding of SQL DBA best practices and ability to apply them in real world situations
Strong/advanced understanding of replication topologies: merge , transaction and snapshot - most of our deployments based on merge and filtered publications
Experience with data migration. Ability to map flat files, external data tables , other outside sources to existing database3 structures
Able to manage instances on premise and in AWS cloud
Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.
Create new Microsoft SQL Server instances and configure them, including AlwaysOn availability groups and failover clustering
Facilitate brainstorming meetings with clients to review, analyze, and assess business systems and needs
In charge of database backup and recovery methods, database access security and integrity, physical data storage design, and data storage administration
Assists in the selection of a database management system and the maintenance of database performance
Participate in continuous process improvement
Download and install SQL Server service packs and updates
Configure and maintain SQL Security controls
Apply data modeling techniques to ensure development and implementation support efforts meet integration and performance expectations
Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end.
Refine and automate regular processes, track issues, and document changes
Assist developers with complex query tuning and schema refinement
Provide 24x7 support for critical production systems
Perform scheduled maintenance and support release deployment activities after hours
Share domain and technical expertise, providing technical mentorship and cross-training to other peers and team members
Manage database backup and recovery, as well as disaster recovery planning, in coordination with the IT manager and System Engineer
Create, change, and improve SQL Server Agent tasks and maintenance plans
Proactively monitor SQL Server maintenance tasks, troubleshoot failed processes, and address issues as soon as possible
Troubleshoot application sluggishness and poor performance
In charge of T-SQL query tuning
In charge of database migrations and server updates
Create documentation and training for routine database administration activities, as well as train server operations employees on them
In charge of big data ETL into SQL Server, as well as authoring and modifying SQL Server Reporting Services reports
Integrate SQL Server with corporate applications
T-SQL (Transact-SQL) Programming
Qualifications:
5+ years MS SQL Server Administration experience required
Experience with Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools
Extensive knowledge of SQL and SQL server tools
Experience in Database Performance, Development and Maintenance
In-depth understanding of database security, backup and recovery, and performance monitoring requirements
Familiarity with relational and dimensional data modelling
Extensive knowledge in database design, implementation, and conversion
Knowledge of PowerShell and Unix shell scripting
Experience with SSAS, SSIS, and SSRS
Experience with backups, restores and recovery models
Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Server
Experience working with Windows server, including Active Directory
Excellent written and verbal communication
Flexible, team player, “get-it-done” personality
Ability to organize and plan work independently
Ability to work in a rapidly changing environment
Ability to multi-task and context-switch effectively between different activities and teams
MCTS, MCITP, and/or MVP certifications a plus
Equal Opportunity Employer: disability/veteran
NaphCare is hiring an experienced SQL Server Database Administrator to join our team on-site at our Corporate Headquarters in Birmingham, AL 35216.
The SQL Server DBA will be responsible for the implementation, configuration, maintenance, and performance of critical SQL Server RDBMS systems, to ensure the availability and consistent performance of our corporate applications. This is a “hands-on” position requiring solid technical skills, as well as excellent interpersonal and communication skills.
The successful candidate will be responsible for the development and sustainment of the SQL Server Warehouse, ensuring its operational readiness (security, health and performance), executing data loads, and performing data modeling in support of multiple development teams. The data warehouse supports an enterprise application suite of program management tools. Must be capable of working independently and collaboratively.
NaphCare is a family owned, healthcare technology company that has been delivering high quality healthcare to correctional facilities across the nation for over 35 years. Come join our team of over 6000 employees and growing! NaphCare pays well, offers outstanding benefits, and has an incredibly engaged corporate support team to make sure you have what you need to be truly excellent at what you do.
NaphCare partners with correctional facilities to provide proactive, patient-focused healthcare.
NaphCare Full Time Benefits:
Prescriptions free of charge through our health plan
Health, dental & vision insurance that starts day one!
We offer low-cost benefits to our employees and their families
Employment Assistance Program (EAP) services
100% vested 401K and Roth with company contribution that starts day one!
Tuition Assistance
Referral bonuses
On-site education
Free Continuing Education!
Term life insurance at no cost to the employee
Generous paid time off & paid holidays
Responsibilities:
Manage SQL Server databases through multiple product lifecycle environments, from development to mission-critical production systems.
Performance Tuning and monitoring of custom application
Understanding of SQL DBA best practices and ability to apply them in real world situations
Strong/advanced understanding of replication topologies: merge , transaction and snapshot - most of our deployments based on merge and filtered publications
Experience with data migration. Ability to map flat files, external data tables , other outside sources to existing database3 structures
Able to manage instances on premise and in AWS cloud
Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.
Create new Microsoft SQL Server instances and configure them, including AlwaysOn availability groups and failover clustering
Facilitate brainstorming meetings with clients to review, analyze, and assess business systems and needs
In charge of database backup and recovery methods, database access security and integrity, physical data storage design, and data storage administration
Assists in the selection of a database management system and the maintenance of database performance
Participate in continuous process improvement
Download and install SQL Server service packs and updates
Configure and maintain SQL Security controls
Apply data modeling techniques to ensure development and implementation support efforts meet integration and performance expectations
Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end.
Refine and automate regular processes, track issues, and document changes
Assist developers with complex query tuning and schema refinement
Provide 24x7 support for critical production systems
Perform scheduled maintenance and support release deployment activities after hours
Share domain and technical expertise, providing technical mentorship and cross-training to other peers and team members
Manage database backup and recovery, as well as disaster recovery planning, in coordination with the IT manager and System Engineer
Create, change, and improve SQL Server Agent tasks and maintenance plans
Proactively monitor SQL Server maintenance tasks, troubleshoot failed processes, and address issues as soon as possible
Troubleshoot application sluggishness and poor performance
In charge of T-SQL query tuning
In charge of database migrations and server updates
Create documentation and training for routine database administration activities, as well as train server operations employees on them
In charge of big data ETL into SQL Server, as well as authoring and modifying SQL Server Reporting Services reports
Integrate SQL Server with corporate applications
T-SQL (Transact-SQL) Programming
Qualifications:
5+ years MS SQL Server Administration experience required
Experience with Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools
Extensive knowledge of SQL and SQL server tools
Experience in Database Performance, Development and Maintenance
In-depth understanding of database security, backup and recovery, and performance monitoring requirements
Familiarity with relational and dimensional data modelling
Extensive knowledge in database design, implementation, and conversion
Knowledge of PowerShell and Unix shell scripting
Experience with SSAS, SSIS, and SSRS
Experience with backups, restores and recovery models
Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Server
Experience working with Windows server, including Active Directory
Excellent written and verbal communication
Flexible, team player, “get-it-done” personality
Ability to organize and plan work independently
Ability to work in a rapidly changing environment
Ability to multi-task and context-switch effectively between different activities and teams
MCTS, MCITP, and/or MVP certifications a plus
Equal Opportunity Employer: disability/veteran
Share this job
Useful Links
Similar Jobs
- View Job
Salesforce System Administrator (Onsite)
Birmingham