What are the responsibilities and job description for the Senior Database Administrator position at ComplexCare Solutions?
Overview: The Senior Database Administrator is responsible for managing, maintaining, and optimizing enterprise-level databases to ensure high availability, security, and performance. This role involves advanced technical expertise, strategic planning, and leadership in database operations.
Duties and Responsibilities:
In addition to the base compensation, this position may be eligible for performance-based incentives.
The actual base pay offered may vary depending on multiple factors including, but not limited to, job-related knowledge/skills, experience, business needs, geographical location, and internal equity. At ComplexCare Solutions, it is not typical for an individual to be hired at or near the top end of the range for their role, and compensation decisions are dependent upon the facts and circumstances of each position and candidate.
Base Compensation Range
$112,600—$140,700 USD
Studies have shown that women and people of color are less likely to apply for jobs unless they believe they meet every one of the qualifications listed in a job description. If you don't meet every qualification listed but are excited about our mission and the work described, we encourage you to apply regardless. ComplexCare Solutions is most interested in finding the best candidate for the job and you may be just the right person for this or other roles.
By embracing diversity, equity and inclusion we enhance our work environment and drive business success. ComplexCare Solutions strives to reflect the diversity of the communities where we operate and of our clients and everyone whom we serve. We endeavor to create a culture of inclusion in which our associates feel empowered to bring their full, authentic selves to work and pursue their professional goals in an equitable setting. We understand that by fostering this type of culture, and welcoming different perspectives, we generate innovation and growth.
ComplexCare Solutions is proud to be an equal opportunity workplace and is an affirmative action employer. We are committed to equal employment opportunity regardless of race, color, ancestry, religion, sex, national origin, sexual orientation, age, citizenship, marital status, disability, gender identity or Veteran status. We also consider qualified applicants regardless of criminal histories, consistent with legal requirement.
The Company maintains a drug free work environment for all of its associates, which includes employees, contractors and vendors. It is unlawful for associates to manufacture, sell, distribute, dispense, possess or use any controlled substance or marijuana in the workplace and doing so will result in disciplinary action, up to and including termination of employment or the contracted relationship.
To review the legal requirements, including all labor law posters, please visit this link
Duties and Responsibilities:
- Administer the production database operations of CCS's proprietary systems, ensuring schedules are met and system resources are used effectively.
- Manage and maintain Databricks workspaces, clusters, jobs, and user permissions to ensure stable and efficient operations.
- Troubleshoot database and Databricks production-related issues and coordinate their successful resolution.
- Implement database and Databricks performance tuning, monitoring, and optimization techniques.
- Ensure database and Databricks production high availability, capacity management, and resource utilization optimization.
- Support database and Databricks incident management response and restoration of services activities.
- Support problem management through root cause analysis and implementation of permanent fixes across both SQL Server and Databricks environments.
- Collaborate with data engineering teams to manage ADF pipelines, data ingestion, and integration processes within Databricks.
- Maintain compliance with CCS's policies, procedures, and mission statement.
- Adhere to all confidentiality and HIPAA requirements as outlined within CCS's Operating Policies and Procedures at all times with respect to any aspect of the data handled or services rendered.
- Fulfill those responsibilities and/or duties that may be reasonably provided by CCS for the purpose of achieving operational and financial success of the Company.
- Uphold responsibilities relative to the separation of duties for applicable processes and procedures within your job function.
- CCS reserves the right to change this job description from time to time as business needs dictate and will provide notice of such.
- 3 three years of experience in the job offered; or
- 3 years of experience as a Project Manager or a related role; and
- Proven experience in troubleshooting and resolving database and Databricks platform issues.
- Strong expertise in Performance Tuning and Optimization (PTO) using native monitoring and troubleshooting tools.
- Experience with indexes, index management, and statistics.
- Skilled in backups, restores, and recovery models.
- Strong proficiency in SQL and T-SQL query development in a SQL Server environment.
- Hands-on experience administering Azure Databricks, including cluster configuration, job scheduling, workspace management, and integration with Azure Data Factory and Data Lake.
- Familiarity with monitoring and securing Databricks resources, managing libraries, and automating deployments via CI/CD pipelines.
- Understanding of data governance, data lineage, and compliance best practices across both SQL Server and Databricks ecosystems.;
- Master's Degree in Computer Science, Information Systems, Engineering, or related field of study;
- In lieu of a Master's degree plus three years of experience, Employer is willing to accept a Bachelor's degree in Computer Science, Information Systems, Engineering, or related plus at least five years of experience in the job offered or five years of experience as a Project Manager or a related role.
- Sedentary work (i.e., sitting for long periods of time);
- Exerting up to 10 pounds of force occasionally and/or negligible amount of force;
- Frequently or constantly to lift, carry push, pull or otherwise move objects and repetitive motions;
- Subject to inside environmental conditions; and
- Travel for this position will include less than 5% locally usually for training purposes.
In addition to the base compensation, this position may be eligible for performance-based incentives.
The actual base pay offered may vary depending on multiple factors including, but not limited to, job-related knowledge/skills, experience, business needs, geographical location, and internal equity. At ComplexCare Solutions, it is not typical for an individual to be hired at or near the top end of the range for their role, and compensation decisions are dependent upon the facts and circumstances of each position and candidate.
Base Compensation Range
$112,600—$140,700 USD
Studies have shown that women and people of color are less likely to apply for jobs unless they believe they meet every one of the qualifications listed in a job description. If you don't meet every qualification listed but are excited about our mission and the work described, we encourage you to apply regardless. ComplexCare Solutions is most interested in finding the best candidate for the job and you may be just the right person for this or other roles.
By embracing diversity, equity and inclusion we enhance our work environment and drive business success. ComplexCare Solutions strives to reflect the diversity of the communities where we operate and of our clients and everyone whom we serve. We endeavor to create a culture of inclusion in which our associates feel empowered to bring their full, authentic selves to work and pursue their professional goals in an equitable setting. We understand that by fostering this type of culture, and welcoming different perspectives, we generate innovation and growth.
ComplexCare Solutions is proud to be an equal opportunity workplace and is an affirmative action employer. We are committed to equal employment opportunity regardless of race, color, ancestry, religion, sex, national origin, sexual orientation, age, citizenship, marital status, disability, gender identity or Veteran status. We also consider qualified applicants regardless of criminal histories, consistent with legal requirement.
The Company maintains a drug free work environment for all of its associates, which includes employees, contractors and vendors. It is unlawful for associates to manufacture, sell, distribute, dispense, possess or use any controlled substance or marijuana in the workplace and doing so will result in disciplinary action, up to and including termination of employment or the contracted relationship.
To review the legal requirements, including all labor law posters, please visit this link
Salary : $112,600 - $140,700