SQL/Oracle DBA Lead Job at Commonwealth Care Alliance

Commonwealth Care Alliance Boston, MA 02108

Why This Role is Important to Us:


This position is an essential position in our organization. You will interact with all departments and develop code, perform database management tasks, and develop interfaces with current systems and future systems.

The job also involves scoping, designing and implementing new features as well as maintenance of the existing applications. We are a young and growing organization and this position is vital to our growth in the health care industry.

Supervision Exercised:No




What You'll Be Doing:


  • Experience with Database Administration for MSSQL Server.
  • Experience in troubleshooting and resolving database problems.
  • Experience in Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools.
  • Experience with backups, restores and recovery models.
  • Knowledge of High Availability (HA) and Disaster Recovery (DR) options for MSSQL Server.
  • Experience in implementing operational automation using scripts.
  • Knowledge of indexes, index management, and statistics.
  • Experience working with Windows server, including Active Directory and proper disk configurations.
  • Good communication and documentation skills.

Teradata Database Admins Only:

  • Experience with Database Administration for Teradata Database Systems.
  • Experience in troubleshooting and resolving database problems.
  • Experience in Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools.
  • Experience with backups, restores and recovery models.
  • Knowledge of High Availability (HA) and Disaster Recovery (DR) options for Teradata.
  • Experience in implementing operational automation using scripts.
  • Knowledge of indexes, index management, and statistics.
  • Experience working with Windows server, including Active Directory and proper disk configurations.
  • Good communication and documentation skills.



What We're Looking For:


Education Required:

  • Bachelor's Degree or equivalent experience

Experience Required:

  • 7-10 years Healthcare Experience (3 – 10 years of experience)
  • 3 – 10 years of experience in Database Administration for MSSQL Server
  • Experience with Database Administration for MSSQL Server.
  • Experience in troubleshooting and resolving database problems.
  • Experience in Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools.
  • Experience with backups, restores and recovery models.
  • Experience in implementing operational automation using scripts.
  • Experience working with Windows server, including Active Directory and proper disk configurations.

For Teradata Database Admins Only:

  • Healthcare Experience (3 – 10 years of experience) is a plus
  • Preferred - Active in forums or newsgroups
  • 7 – 10 years of experience as a Teradata DBA (Teradata V13 & Higher)
  • Experience working with Teradata in a VMWare environment
  • Experience with Teradata client tools (TD Admin, SQL Assistant, Viewpoint, Visual Explain, etc.)
  • Experience with Teradata utilities (BTEQ, Arcmain, FastLoad, MultiLoad, FastExport, TPT, TPump)
  • Experience Configuring and managing Teradata Data Labs and Workload Data Manager
  • Experience with advanced SQL coding/tuning
  • Full life cycle experience in Data Warehousing Data Integration, and Data Management
  • Experience with Database Administration for Teradata Database Systems.
  • Experience in troubleshooting and resolving database problems.
  • Experience in Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools.
  • Experience with backups, restores and recovery models.
  • Experience in implementing operational automation using scripts.
  • Experience working with Windows server, including Active Directory and proper disk configurations.

Knowledge, Skills & Abilities Required:

  • Knowledge of High Availability (HA) and Disaster Recovery (DR) options.
  • Knowledge of indexes, index management, and statistics.

Good communication and documentation skills.

Language(s) Required:

  • English




Please Note :
ajayjain.com is the go-to platform for job seekers looking for the best job postings from around the web. With a focus on quality, the platform guarantees that all job postings are from reliable sources and are up-to-date. It also offers a variety of tools to help users find the perfect job for them, such as searching by location and filtering by industry. Furthermore, ajayjain.com provides helpful resources like resume tips and career advice to give job seekers an edge in their search. With its commitment to quality and user-friendliness, Site.com is the ideal place to find your next job.