Infrastructure SQL DBA Automation Engineer

Job Description

Our IT team operates as a business partner proposing ideas and innovative solutions that enable new organizational capabilities. We collaborate internationally to deliver the services and solutions that help everyone to be more productive and enable innovation.

We are seeking a Database engineer with an SQL Server DBA background to join our Enterprise Database team. The ideal candidate will have a strong DBA-Developer skillset with SQL Server database on Windows, AWS RDS and Azure. Be part of our global team which focuses on developing automated database solutions leveraging agile methodology. Looking for a self-motivated person who proactively completes tasks with a strong attention to detail. The candidate should be able to work independently and as part of a team.

Required Skills:

• 3+ years SQL Server DBA (install, monitor, backup, restore) experience on Windows.

• 3+ years AWS cloud technologies, especially AWS-RDS, SQL Server on EC2, S3.

• 3+ years writing provisioning, patching, maintenance scripts

• 3+ years scripting in PowerShell, SQL

Desired Skills:

• Experience with Azure SQL Managed Instance and Infrastructure As A Solution

• Ansible playbooks, templates, and workflows in Ansible tower

• Experience in using DevOps tools like Kanban Board, Git, Confluence and Jira

• Experience implementing Microsoft Always-On and Clustering solutions

• Infrastructure as code experience, such as Terraform, Jenkins.

• Agile product development experience.

• Understand Microsoft SQL licensing requirements related to Edition and Version, virtual or physical platform

• Excellent communication with management, peers, and customers.

• Possession of a growth mindset

• Experience supporting all phases of the system development life cycle including development, testing, QA, and production.

Education Minimum Requirements:

Minimum level of education and years of relevant work experience.

• High School Diploma with IT experience

What you will be doing:

• Define SQL Server databases standards

• Developing procedures for provisioning, upgrading, patching of SQL Server databases including advanced features like Always on Availability Groups

• Develop and Implement automation routines in Ansible for provisioning, patching and maintenance of SQL Server databases.

• Develop and implement infrastructure as Code in Ansible and Terraform for MSSQL databases on AWS.

• Lead projects and teams focused on engineering work. Plan work, deliver to timelines, act independently and proactively.

• Understand the importance of maintaining control and compliance of our processes, images, and systems, folding this work into all tasks

• Gather requirements for new system implementations, and migrations to newer environment based on SQL Server.

• Assist with planning and executing tasks to build the environments, migrate data, and configure user and group security.

• The engineer will work with outside vendors to explain process and limitations for new system onboarding and help identify solutions to complete the project.

• Drive process improvements using automation.

• Drive innovation with thought leadership and technical expertise.

Our Support Functions deliver services and make recommendations about ways to enhance our workplace and the culture of our organization. Our Support Functions include HR, Finance, Information Technology, Legal, Procurement, Administration, Facilities and Security.

Who we are …

We are known as Merck & Co., Inc., Rahway, New Jersey, USA in the United States and Canada and MSD everywhere else. For more than a century, we have been inventing for life, bringing forward medicines and vaccines for many of the world's most challenging diseases. Today, our company continues to be at the forefront of research to deliver innovative health solutions and advance the prevention and treatment of diseases that threaten people and animals around the world.

What we look for …

Imagine getting up in the morning for a job as important as helping to save and improve lives around the world. Here, you have that opportunity. You can put your empathy, creativity, digital mastery, or scientific genius to work in collaboration with a diverse group of colleagues who pursue and bring hope to countless people who are battling some of the most challenging diseases of our time. Our team is constantly evolving, so if you are among the intellectually curious, join us—and start making your impact today.

NOTICE FOR INTERNAL APPLICANTS

In accordance with Managers' Policy - Job Posting and Employee Placement, all employees subject to this policy are required to have a minimum of twelve (12) months of service in current position prior to applying for open positions.

If you have been offered a separation benefits package, but have not yet reached your separation date and are offered a position within the salary and geographical parameters as set forth in the Summary Plan Description (SPD) of your separation package, then you are no longer eligible for your separation benefits package. To discuss in more detail, please contact your HRBP or Talent Acquisition Advisor.

Employees working in roles that the Company determines require routine collaboration with external stakeholders, such as customer-facing commercial, or research-based roles, will be expected to comply not only with Company policy but also with policies established by such external stakeholders (for example, a requirement to be vaccinated against COVID-19 in order to access a facility or meet with stakeholders). Please understand that, as permitted by applicable law, if you have not been vaccinated against COVID-19 and an essential function of your job is to call on external stakeholders who require vaccination to enter their premises or engage in face-to-face meetings, then your employment may pose an undue burden to business operations, in which case you may not be offered employment, or your employment could be terminated. Please also note that, where permitted by applicable law, the Company reserves the right to require COVID-19 vaccinations for positions, such as in Global Employee Health, where the Company determines in its discretion that the nature of the role presents an increased risk of disease transmission.

Current Employees apply HERE

Current Contingent Workers apply HERE

US and Puerto Rico Residents Only:

Our company is committed to inclusion, ensuring that candidates can engage in a hiring process that exhibits their true capabilities. Please click here if you need an accommodation during the application or hiring process.

For more information about personal rights under Equal Employment Opportunity, visit:

EEOC Know Your Rights

EEOC GINA Supplement​

Pay Transparency Nondiscrimination

We are proud to be a company that embraces the value of bringing diverse, talented, and committed people together. The fastest way to breakthrough innovation is when diverse ideas come together in an inclusive environment. We encourage our colleagues to respectfully challenge one another’s thinking and approach problems collectively. We are an equal opportunity employer, committed to fostering an inclusive and diverse workplace.

Under New York City, Washington State and California State law, the Company is required to provide a reasonable estimate of the salary range for this job. Final determinations with respect to salary will take into account a number of factors, which may include, but not be limited to the primary work location and the chosen candidate’s relevant skills, experience, and education.

Expected salary range:

Available benefits include bonus eligibility, health care and other insurance benefits (for employee and family), retirement benefits, paid holidays, vacation, and sick days. For Washington State Jobs, a summary of benefits is listed here.

Learn more about your rights, including under California, Colorado and other US State Acts

Search Firm Representatives Please Read Carefully
Merck & Co., Inc., Rahway, NJ, USA, also known as Merck Sharp & Dohme LLC, Rahway, NJ, USA, does not accept unsolicited assistance from search firms for employment opportunities. All CVs / resumes submitted by search firms to any employee at our company without a valid written search agreement in place for this position will be deemed the sole property of our company. No fee will be paid in the event a candidate is hired by our company as a result of an agency referral where no pre-existing agreement is in place. Where agency agreements are in place, introductions are position specific. Please, no phone calls or emails.

Employee Status:

Relocation:

VISA Sponsorship:

Travel Requirements:

Flexible Work Arrangements:

Shift:

Valid Driving License:

Hazardous Material(s):

Requisition ID:R230254