Engineer, IT Systems - DBA Specialist at Concentra

Addison, Texas, United States -

Full Time

Start Date

Immediate

Expiry Date

09 Jan, 26

Salary

0.0

Posted On

11 Oct, 25

Experience

10 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

SQL Server, Database Administration, Cloud Database Management, Performance Tuning, High Availability, Disaster Recovery, Security, Compliance, Automation, Scripting, DevOps Integration, Cloud Migration, Monitoring, Reporting, Documentation, Mentorship

Industry

Hospitals and Health Care

Description

Overview Concentra is recognized as the nation’s leading occupational health care company. With more than 40 years of experience, Concentra is dedicated to our mission to improve the health of America’s 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. 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. Qualifications Bachelor’s Degree; Major: Computer Science, Information Technology. Experience in lieu of required education is acceptable. Master's 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

Responsibilities

The 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.