Engineer, IT Systems

Join to apply for the Engineer, IT Systems - DBA Specialist role at Concentra

Overview

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.

Responsibilities

• Application/Database Administration: Install, configure, and maintain SQL Server instances across development, testing, and production environments.
• Application/Database Administration: Manage database performance, security, backups, and recovery plans.
• Application/Database Administration: Support database design, development, and deployment for application projects.
• Application/Database Administration: Collaborate with developers to optimize database schemas, queries, and stored procedures.
• Application/Database Administration: 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.
• Cloud Database Management (Azure & AWS): Implement and support hybrid database architectures and cloud migration strategies.
• Cloud Database Management (Azure & AWS): 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.
• Performance Tuning: Conduct regular performance monitoring and troubleshooting
• Performance Tuning: 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.
• High Availability and Disaster Recovery: Test and maintain backup, recovery, and failover processes.
• High Availability and Disaster Recovery: 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.
• Security and Compliance: 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.
• Automation, Scripting & DevOps Integration: Implement database monitoring and alerting systems.
• Automation, Scripting & DevOps Integration: 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.
• Cloud Migration and Modernization: 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.
• Monitoring and Reporting: Generate reports on database usage, capacity planning, and operational efficiency.
• Monitoring and Reporting: 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.
• Collaboration and Support: Provide guidance and mentorship to junior DBAs and engineers.

• Upgrades and Migrations: Plan and execute SQL Server upgrades, migrations, and patching.
• Upgrades and Migrations: Evaluate new features and tools to enhance the database environment.

• Documentation & Mentorship: Document processes, standards, and best practices for database and cloud environments.
• Documentation & Mentorship: Mentor junior DBAs and application developers on database best practices.

Qualifications

• 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

Additional Data 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 Employer, including disability/veterans

Seniority level

• Mid-Senior level

Employment type

• Full-time

Job function

• Information Technology

Industries

• Hospitals and Health Care

Referrals increase your chances of interviewing at Concentra by 2x

Were unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.

#J-18808-Ljbffr

---