Lead Database Administrator - Cassandra, Postgres SQL

About the position

Abbott is a global healthcare leader that helps people live more fully at all stages of life. Our portfolio of life-changing technologies spans the spectrum of healthcare, with leading businesses and products in diagnostics, medical devices, nutritionals and branded generic medicines. Our 114,000 colleagues serve people in more than 160 countries. Meet Lingo, a new biosensing technology that provides users a window into their body. Lingo tracks key biomarkers - such as glucose, ketones, and lactate - to help people make better decisions about their health and nutrition. Biowearable technology will digitize, decentralize and democratize healthcare, enabling consumers to take control of their own health. At Abbott, you can do work that matters, grow, and learn, care for yourself and family, be your true self and live a full life.

Responsibilities

• Create comprehensive database designs that align with business requirements and technical specifications.
• Review, validate and enhance logical database designs.
• Define and implement physical databases.
• Perform database administration activities (e.g., modifications, enhancements, expansions).
• Oversee the deployment of database solutions, ensuring effective integration with existing systems.
• Install, configure, and maintain Apache Cassandra clusters.
• Optimize Cassandra configurations for high availability and scalability.
• Monitor and tune database performance, including read/write operations, compaction, and garbage collection.
• Implement and maintain monitoring tools (e.g., Prometheus, Grafana, Datadog) to track database health and performance.
• Work closely with development teams to design and implement efficient database schemas and queries.
• Provide 24/7 support for production databases and resolve issues promptly.
• Collaborate with DevOps and infrastructure teams to ensure seamless integration of Cassandra with other systems.
• Maintain thorough documentation of database designs, configurations, and processes for future reference and compliance.
• Stay updated on emerging technologies and trends in database management to recommend improvements and innovations.
• Develop strategies for implementing new technologies.
• Evaluate and recommend new database software, utilities, and tools.
• Collaborate daily with internal clients and technical support peers on divisional and enterprise-wide projects.

Requirements

• Bachelor's degree in Computer Science, Information Technology, or a related field.
• Minimum 8 years of experience as a DBA in the design, testing, implementation, and administration of management systems databases.
• Technical training including Database Administration, Performance and Tuning, and Backup and Recovery.
• Minimum 4 years hands-on experience with Cassandra cluster management, performance tuning, and troubleshooting.
• Knowledge of SQL Server, MySQL, NoSQL databases.
• Proficient in SQL, CQL, and database languages.
• Experience with Linux/Unix, shell scripting, and monitoring tools (e.g., Prometheus, Grafana).
• Familiar with cloud platforms (AWS, Azure, GCP) and containerization (Docker, Kubernetes).
• Knowledge of monitoring tools like Prometheus, Grafana, or Kibana.
• Expertise in data modeling and performance tuning.
• Excellent communication skills for technical and non-technical collaboration.
• Ability to manage multiple projects in a fast-paced environment.

Nice-to-haves

• Certification in Apache Cassandra or related technologies.
• Knowledge of DevOps practices and tools (e.g., Terraform).
• Experience with Druid and spark.

Benefits

• Career development with an international company where you can grow the career you dream of.
• Free medical coverage in our Health Investment Plan (HIP) PPO medical plan in the next calendar year.
• An excellent retirement savings plan with high employer contribution.
• Tuition reimbursement, the Freedom 2 Save student debt program and FreeU education benefit - an affordable and convenient path to getting a bachelor's degree.
• A company recognized as a great place to work in dozens of countries around the world and named one of the most admired companies in the world by Fortune.
• A company that is recognized as one of the best big companies to work for as well as a best place to work for diversity, working mothers, female executives, and scientists.