SQL Server Database Administrator

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