Sr Data Engineer I

Share this job:Date: Aug 26, 2024Sr Data Engineer ILocation:Ipswich, MA, US, 01938Onsite or Remote: RemoteCompany Name: EBSCO Information ServicesEBSCO 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.Your Opportunity: Infrastructure Engineer IIWe are seeking a skilled Database Engineer for Cloud and On-prem operations to join our dynamic team. The ideal candidate will have expertise in managing databases, with a primary focus on upgrading, stabilizing, and migrating data solutions between on-prem environments and to the cloud. This role requires a deep understanding of database technologies, operational efficiencies, and data migration strategies. Ensure sound security, integrity controls and monitoring protocols are in place. Define and specify database access, structure, and functional capabilities, together with users and assigned personnel.What You’ll Do (Primary Responsibilities):• Troubleshoot and resolve issues related to database reliability, performance, and migration.• Monitors database performance and works closely with developers and users to tune queries and optimize database performance.• Plans, coordinates, implements, and supports database systems, working closely with Content production staff to anticipate and meet program requirements for database infrastructure.• Implement best practices for data management, backup, and disaster recovery in the cloud environment.• Responsible for refreshing development and test databases from production data using NetApp SnapCenter and other toolsets.• Plan, coordinate, and implement security measures to safeguard data against accidental or unauthorized damage, modification, or disclosure.• Develop scripts and automation tools to streamline the data migration process and ensure data integrity during the transition.• Evaluate existing on-premises database infrastructure and recommend solutions for optimization and scalability.• Collaborate with cross-functional teams to understand data requirements and design appropriate cloud-based database solutions.• Design and implement data migration strategies to move on-premises databases to cloud platforms such as AWS, or other providers.• Assures systems quality and maintenance of database dictionaries.• Participate in an on-call rotation as part of a DBA team.Your Team: Database Operations – SQL ServerAbout You:• 4+ years of experience with relational databases.• 2+ years of experience in design and implementation of large-scale database servers in on-premises or cloud environments.• Operations and/or solution deployment experience in a business-critical, high-availability context.• Working knowledge of Storage technologies (NetApp SnapCenter preferred), shell scripting, SQL Plus or off the shelf SQL tools.• Demonstrated expertise or additional certification in SQL Server database administration.• Experience in database development and coding in various languages (SQL, TSQL, Perl, etc.)• Experience with monitoring and alerting tools (New Relic, CloudWatch, Nagios XI, OpsGenie, etc.)• Understand and interpret infrastructure requirements such as Networking, Storage, and Hardware Optimization.• Implementation and tuning experience of databases• Knowledge of Schema Design, Query Tuning and Optimization, and Data Migration and Integrations.What sets you apart:• Strong interpersonal skills - ability to effectively interact with all levels of staff and external contacts.• Excellent analytical, organizational and time management skills.• Skill in interviewing users and identifying their needs.Our Offer to You:The actual salary offer will carefully consider a wide range of factors including your skills, qualifications, education, training, and experience, as well as the position’s work location.EBSCO provides a generous benefits program including• Medical, Dental, Vision, Life and Disability Insurance and Flexible spending accounts• Retirement Savings Plan• Paid Parental Leave• Holidays and Paid Time Off (PTO)• Mentoring program• And much more! Check it out here: https://www.ebsco.com/about/benefitsWe work hard to embrace diversity, equity, and inclusion and encourage everyone at EBSCO to bring their authentic selves to work every day. We have a wide representation of employee resource groups. To learn more, visit https://www.ebsco.com/about/diversity-equity-inclusionThe EBSCO WayAt EBSCO, our culture is defined by ten guiding principles. We put our customers first, and we're always looking for ways to innovate and improve. We make decisions based on facts, communicate openly, and hold ourselves accountable for results. Trust, respect, and care for each other are essential to how we work. Every day, our actions and teamwork shape who we are as a company. To learn more about our culture, visit https://www.ebsco.com/about/culture .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.Nearest Major Market: BostonJob Segment: Data Conversion, DBA, Database, SQL, Engineer, Data, Technology, Engineering