Sr Infrastructure Engineer II - Database

EBSCO Information Services (EIS) provides a complete and optimized research solution comprised of e-journals, e-books, and research databases - all combined with the most powerful discovery service to support the information needs and maximize the research experience of our end-users. Headquartered in Ipswich, MA, EIS employs more than 2,700 people worldwide, most now working hybrid or remotely. We are the leader in our field due to our cutting-edge technology, forward-thinking philosophy, and outstanding team. EIS is a company that will motivate you, inspire you, and allow you to grow. Our mission is to transform lives by providing relevant and reliable information when, where, and how people need it. We are looking for bright and creative individuals whose unique differences will allow us to achieve this inclusive mission around the world.

Focus:

We are looking for an experienced engineer to join our Database Operations practice supporting our private and public-cloud (AWS) infrastructure as well as on-prem and hybrid database service offerings. Primarily responsible for various database administration activities related to management of Oracle [Standard Edition] 19c and MySQL databases (installation, migration, administration, backups, re-orgs, and any additional required maintenance stemming from proprietary application usage). Ensures sound security, integrity controls and monitoring protocols are in place. Works with developers, architects, and assigned personnel; defines and specifies database access, structure, functional capabilities, etc.

Responsibilities:

• Responsible for refreshing development and test databases from production data. Executes necessary tasks to accomplish this, including export, drop, create, and import using NetApp Snapcenter toolsets.
• Monitors database performance and works closely with developers and users to tune queries and optimize database performance.
• Establishes various database objects, such as database procedures, indexes groups and roles in support of database applications and database schema.
• Plans, coordinates, implements, and supports database systems, working closely with Content production staff to anticipate and meet program requirements for database infrastructure.
• Participate in an on-call rotation as part of a DBA team (Bi-weekly rotation)
• Assists in database design and implementation and maintains an understanding of the various databases used in the library content business.
• Assures systems quality and maintenance of database dictionaries.
• Develops reports and on-line form images in support of various application programs.
• Test programs or databases, correct errors and make necessary modifications.
• Modify existing databases and database management systems or direct programmers and analysts to make changes.
• Ability to work closely with systems administrators and developers to develop optimized systems for data access.
• May be responsible forreview, design, and migration of on-prem Oracle workloads to AWS .
• Plan, coordinate and implement security measures to safeguard information in computer files against accidental or unauthorized damage, modification, or disclosure.

Qualifications:

• 8+ years experience in a professional setting working with relational databases in a business-critical, high-availability context
• 2+ years hands on experience in the administration of a RDBMS.
• 2+ years hands on experience with Oracle databases.
• Working knowledge of Storage technologies, shell scripting, SQL*Plus or other off the shelf SQL tools.
• Proficiency writing and maintaining one or more SQL query languages and scripting tools (bash shell, SQL, SQLPLUS, PL/SQL, Python, etc.).
• Proficiency at the Linux operating system command line (various flavors).
• Skilled in Database software installation, upgrades, and patching
• Skilled in interviewing users/developers and identifying their needs.
• Understand and interpret infrastructure requirements such as Networking, Storage, and Hardware Optimization.
• Implementation and tuning experience of Databases including knowledge of Schema Design, Query Tuning and Optimization, and Data Migration and Integrations.
• Strong interpersonal skills - ability to effectively interact with all levels of staff and external contacts.
• Excellent analytical, organizational and time management skills.
• Additional PLUS: Experience with NetApp Storage solutions.
• Additional PLUS: Experience with MySQL, PostgreSQL, MongoDB, Amazon RDS.
• Additional PLUS: Experience in AWS Cloud provisioning, AWS RDBMS solutions, DBaaS, or a willingness to learn.

We are an equal opportunity employer and comply with all applicable federal, state, and local fair employment practices laws. We strictly prohibit and do not tolerate discrimination against employees, applicants, or any other covered persons because of race, color, sex, pregnancy status, age, national origin or ancestry, ethnicity, religion, creed, sexual orientation, gender identity, status as a veteran, and basis of disability or any other federal, state or local protected class. This policy applies to all terms and conditions of employment, including, but not limited to, hiring, training, promotion, discipline, compensation, benefits, and termination of employment.

We comply with the Americans with Disabilities Act (ADA), as amended by the ADA Amendments Act, and all applicable state or local law.