Engineer, IT Systems - DBA Specialist

Concentra is recognized as the nations leading occupational health care company.

With more than 40 years of experience Concentra is dedicated to our mission to improve the health of Americas workforce one patient at a time. With a wide range of services and proactive approaches to care Concentra colleagues provide exceptional service to employers and exceptional care to their employees.

The IT Systems Engineer Database Administration Specialist (DBA) (Level 3) role involves designing implementing and maintaining database systems to ensure performance security and reliability. Database Admins optimize data storage and retrieval processes manage database configurations and perform regular maintenance to uphold system integrity. They work with development and operations teams to address database-related issues promptly ensuring seamless integration with applications. Additionally they monitor database performance metrics and implement security measures to protect sensitive data. This role optimizes critical database systems enhances core system stability through regular maintenance and strengthens accountability with robust monitoring practices. It complies with security and regulatory requirements while embracing automation to improve database processes and workflows. The role also prioritizes training and development to foster a culture of continuous improvement among technical staff.

Application/Database Administration

• Install configure and maintain SQL Server instances across development testing and production environments.
• Manage database performance security backups and recovery plans.
• Support database design development and deployment for application projects.
• Collaborate with developers to optimize database schemas queries and stored procedures.
• Provide support for database-centric application troubleshooting and issue resolution

Cloud Database Management (Azure & AWS)

• Manage cloud-based database services including Azure SQL Database Azure Managed Instances AWS RDS for SQL Server and other cloud-native solutions.
• Implement and support hybrid database architectures and cloud migration strategies.
• Monitor and optimize cloud database performance and cost efficiency.

Performance Tuning

• Analyze and optimize SQL queries indexes and database structures to enhance database and application performance.
• Conduct regular performance monitoring and troubleshooting
• Troubleshoot performance bottlenecks at both the database and application level
• High Availability and Disaster Recovery
• Design and implement HA/DR solutions in cloud and hybrid environments such as Azure Availability Zones AWS Multi-AZ and Always On.
• Test and maintain backup recovery and failover processes.
• Ensure database systems meet recovery time objectives (RTO) and recovery point objectives (RPO).
• Security and Compliance
• Implement database security best practices including encryption role-based access control and threat protection.
• Ensure databases comply with regulatory and organizational security standards
• Automation Scripting & DevOps Integration
• Develop automation scripts to streamline routine tasks using PowerShell T-SQL or other tools.
• Implement database monitoring and alerting systems.
• Integrate database management with DevOps pipelines (e.g. Azure DevOps AWS CodePipeline or Jenkins).
• Cloud Migration and Modernization
• Lead or participate in projects to migrate on-premises databases to Azure or AWS.
• Modernize existing databases by leveraging cloud-native features and tools.
• Monitoring and Reporting
• Use monitoring tools (e.g. Azure Monitor AWS CloudWatch SQL Server Profiler) to track database health and performance.
• Generate reports on database usage capacity planning and operational efficiency.
• Maintain up-to-date documentation for database configurations processes and procedures.
• Collaboration and Support
• Work closely with application development teams to design and optimize database architectures.
• Provide guidance and mentorship to junior DBAs and engineers.
• Upgrades and Migrations
• Plan and execute SQL Server upgrades migrations and patching.
• Evaluate new features and tools to enhance the database environment.
• Documentation & Mentorship
• Document processes standards and best practices for database and cloud environments.
• Mentor junior DBAs and application developers on database best practices.

• Bachelors Degree; Major: Computer Science Information Technology. Experience in lieu of required education is acceptable. Masters Preferred
• 8 years of experience as an SQL Server DBA focusing on application support.
• 3 years of experience managing cloud-based SQL Server environments on Azure and AWS
• Hands-on experience with multiple database technologies including relational and NoSQL databases.
• Expertise in database performance tuning backup and recovery disaster recovery and high availability architectures.
• Strong understanding of database security practices and regulatory compliance.
• Expertise with SQL Server (2016 and later) and cloud database services (Azure SQL AWS RDS etc.).
• Strong understanding of T-SQL query performance tuning and indexing strategies.
• Proficiency with cloud-native tools like Azure Data Factory AWS Glue and Data Migration Services.
• Hands-on experience with containerized database environments using Docker or Kubernetes is a plus.
• Familiarity with ETL processes data warehousing and BI tools is desirable.
• Experience with large heterogenous enterprise environments
• Developing and enforcing data retention policies to comply with regulatory standards like HIPAA.
• Leading or participating in database migration projects including on-premises to cloud transitions or upgrades to newer technologies.
• Planning and executing regular disaster recovery drills to validate backup and restoration strategies.
• Incident management including experience in diagnosing and resolving database-related incidents in a high-pressure environment ensuring minimal downtime.
• Creating and maintaining detailed documentation for database systems configurations policies and disaster recovery procedures.

Job-Related Skills/Competencies

• Works with leaders and team members to drive change and influence decision making by using objective metrics comprehensive viewpoints and strong partners
• Ability to influence decision making by preparing objective metrics comprehensive viewpoints and strong partnerships
• Uses logic and reasoning to identify the strengths and weaknesses of alternative solutions conclusions or approaches to problems
• Identifies and accomplishes challenging objectives or personal goals. Works effectively with others to achieve goals.
• Looks for and takes advantage of opportunities. Maintains a high level of interest enthusiasm
• Experience with Healthcare preferred

Employee Benefits

• 401(k) Retirement Plan with Employer Match
• Medical Vision Prescription Telehealth & Dental Plans
• Life & Disability Insurance
• Paid Time Off
• Colleague Referral Bonus Program
• Tuition Reimbursement
• Commuter Benefits
• Dependent Care Spending Account
• Employee Discounts

We will ensure that individuals with disabilities are provided reasonable accommodation to participate in the job application or interview process to perform essential job functions and to receive other benefits and privileges of employment. Please contact us to request accommodation if required.

*This job requires access to confidential and sensitive information requiring ongoing discretion and secure information management*

Concentra is an Equal Opportunity Employerincluding disability/veterans