Staff SQL Database Administrator and Architect (Remote)

Job Description Summary

Position overview

Parata is seeking an experienced SQL DBA as a member of the Central Fill R&D team. The SQL DBA is responsible for application data analysis and database management. The DBA will work with engineering team leaders to create database architecture to accomplish the necessary goals of specialized computer software serving our Central Fill solution. This role will be key in ensuring database architecture and performance is able to deliver the business value and performance needs required to scale our product and buiness.

This is an opportunity to use your depth of knowledge working on one of the fastest growing businesses in Parata. You will collaborate with the architecture, engineers, and product owners leveraging Agile SCRUM methodology and cross functionality with other members of R&D through program increments.

This position also requires jumping on a client’s production call where there is production is performance issue. Candidate will be handling any database related issues at real time with client on call

Job Description

We are the makers of possible

BD is one of the largest global medical technology companies in the world. Advancing the world of health™ is our Purpose, and it’s no small feat. It takes the imagination and passion of all of us—from design and engineering to the manufacturing and marketing of our billions of MedTech products per year—to look at the impossible and find transformative solutions that turn dreams into possibilities.

We believe that the human element, across our global teams, is what allows us to continually evolve. Join us and discover an environment in which you’ll be supported to learn, grow and become your best self. Become a maker of possible with us.

Position overview

Parata is seeking an experienced SQL DBA as a member of the Central Fill R&D team. The SQL DBA is responsible for application data analysis and database management. The DBA will work with engineering team leaders to create database architecture to accomplish the necessary goals of specialized computer software serving our Central Fill solution. This role will be key in ensuring database architecture and performance is able to deliver the business value and performance needs required to scale our product and buiness.

This is an opportunity to use your depth of knowledge working on one of the fastest growing businesses in Parata. You will collaborate with the architecture, engineers, and product owners leveraging Agile SCRUM methodology and cross functionality with other members of R&D through program increments.

This position also requires jumping on a client’s production call where there is production is performance issue. Candidate will be handling any database related issues at real time with client on call

Key Responsibilities

Perform data analysis and database management.

Development of high-quality database solutions.

Creating and maintaining database standards and policies.

Supporting database design, creation, and testing activities.

Managing the database availability and performance, including incident and problem management.

Administering database objects to achieve optimum utilization.

Develop, implement, and optimize stored procedures and functions using T-SQL.

Analyze existing SQL queries for performance improvements.

Suggest the areas where the queries identified can be improved.

Identify all queries involved in the dead locks and fix those queries.

Identifying any performance related issues at various client environment and propose the solution to addresses those issues.

Designing high availability and disaster recovery solution that aligns with Central Fill application.

Review and identify the security risk at database. Propose the fix to those securities issues identified.

Skills and Experience

10 years of experience as a SQL DBA or similar role or combination of other database tools

Excellent understanding of T-SQL programming

Excellent understanding of Microsoft SQL Server

5 years of experience with database security practices and tools e.g. Transparent Data Encryption (TDE) and Secure Socket Layer (SSL) and Transport Layer Security (TLS). Good understanding of SQL Data masking.

5 years of experience of SQL Always-on

Knowledge of latest security methods for database / application productivity

Experience with Continuous Integration / Continuous Delivery (CICD) practices and tools e.g Azure DevOps, Git a plus

Ability to summarize information and communicate upstream and downstream

Capacity to work in a fast-paced environment

Demonstrated ability to prioritize, multi-task, and problem solve

Experience in the pharmacy automation industry a plus

Good working knowledge of SQL always-on any third parties high availability solutions.

Work environment and physical demands

The characteristics described below are representative of those encountered while performing the essential functions of this position. When properly requested and when feasible (without undue hardship to the company), reasonable accommodations will be made to enable individuals with disabilities to perform essential job functions.

Work will primarily be in an office setting with limited opportunities to be exposed to adverse environmental conditions.

Work will be primarily working with fingers by picking, pinching, typing, and grasping often with repetitive motion.

Must have visual acuity for viewing a computer screen, the ability to talk, hear and sit for extended periods of time.

Must be able to carry, lift and push / pull up to 5 pounds frequently and up to 30 pounds occasionally.

Additional physical duties may be required as necessary.

Primary contacts in this position

Manager / Supervisor- daily, weekly, or as needed

Parata employees – daily

At BD, we prioritize on-site collaboration because we believe it fosters creativity, innovation, and effective problem-solving, which are essential in the fast-paced healthcare industry. For most roles, we require a minimum of 4 days of in-office presence per week to maintain our culture of excellence and ensure smooth operations, while also recognizing the importance of flexibility and work-life balance. Remote or field-based positions will have different workplace arrangements which will be indicated in the job posting.

For certain roles at BD, employment is contingent upon the Company’s receipt of sufficient proof that you are fully vaccinated against COVID-19. In some locations, testing for COVID-19 may be available and / or required. Consistent with BD’s Workplace Accommodations Policy, requests for accommodation will be considered pursuant to applicable law.

Why Join Us?

A career at BD means being part of a team that values your opinions and contributions and that encourages you to bring your authentic self to work. It’s also a place where we help each other be great, we do what’s right, we hold each other accountable, and learn and improve every day.

To find purpose in the possibilities, we need people who can see the bigger picture, who understand the human story that underpins everything we do. We welcome people with the imagination and drive to help us reinvent the future of health. At BD, you’ll discover a culture in which you can learn, grow, and thrive. And find satisfaction in doing your part to make the world a better place.

To learn more about BD visit

Becton, Dickinson and Company is an Equal Opportunity / Affirmative Action Employer. We do not unlawfully discriminate on the basis of race, color, religion, age, sex, creed, national origin, ancestry, citizenship status, marital or domestic or civil union status, familial status, affectional or sexual orientation, gender identity or expression, genetics, disability, military eligibility or veteran status, or any other protected status.

Required Skills

Optional Skills

Primary Work Location

USA CA - San Diego (BDB)

Additional Locations

Work Shift

At BD, we are strongly committed to investing in our associates—their well-being and development, and in providing rewards and recognition opportunities that promote a performance-based culture. We demonstrate this commitment by offering a valuable, competitive package of compensation and benefits programs which you can learn more about on our Careers Site under Our Commitment to You () .

Salary or hourly rate ranges have been implemented to reward associates fairly and competitively, as well as to support recognition of associates’ progress, ranging from entry level to experts in their field, and talent mobility. There are many factors, such as location, that contribute to the range displayed. The salary or hourly rate offered to a successful candidate is based on experience, education, skills, and any step rate pay system of the actual work location, as applicable to the role or position. Salary or hourly pay ranges may vary for Field-based and Remote roles.

Salary Range Information

Becton, Dickinson and Company is an Equal Opportunity / Affirmative Action Employer. We do not unlawfully discriminate on the basis of race, color, religion, age, sex, creed, national origin, ancestry, citizenship status, marital or domestic or civil union status, familial status, affectional or sexual orientation, gender identity or expression, genetics, disability, military eligibility or veteran status, or any other protected status.