Senior Software Engineer

We are looking for a Senior Software Engineer/ Database Developer to join Team. This is an amazing opportunity to work on the Content Management Systems and product platforms that support Clarivate’s Alexander Street multi-media products. The team consists of 20 people and is reporting to the Director of Technology. We have a great skill set in digital content publishing and we would love to speak with you if you have skills in working with relational databases, mySQL and MS SQL Server.About You – experience, education, skills, and accomplishments At least 5 years of database development experienceAt least 3 years of experience working with Relational Databases, including mySQL and MS SQL Server. Proficient in SQL.At least 5 years proven experience with database design; Solid understanding of data architecture, replication schemes, writing and optimizing complex queries, and troubleshooting. Ability to create/modify database schema, tables, indexes, etc.Proven ability in developing APIs to support varied application requirementsAt a minimum, Bachelor’s degree in Computer Science, Computer Engineering, or similar Engineering or Science discipline.It would be great if you also had . . . Experience working in an Agile environmentExperience with Cloud architectures and services, AWS ideallyFamiliarity with search engines, SOLR or Elasticsearch, and with NoSQL databases, such as DynamoDBUnderstanding of digital content publishing workflowsWhat will you be doing in this role?Developing and maintaining the databases that are integral components of the systems that support the workflows of the Content Operations team.  These systems manage the Alexander Street digital content (audio, video, text/documents, images) from ingestion, to indexing, through publishing to the Alexander Street product platforms.Maintain databases that are a part of the Alexander Street .NET product platform and the corresponding usage statistics database.Will be integral part of project teams in designing and developing solutions around product platform enhancements, and in initiatives to enhance the content management applications and systems.Directly support the Content Operations team in resolving issues and responding to requests for system changes.Collaborate with other technology teams on development projects, working with Scrum Masters and Leads on cross-team initiatives, coordinate testing with QA team, and deployments with Infrastructure and Deployment team.Product you will be developingThe Content Management systems and applications are used by the Content Operations team to ingest digital content and prepare that content for publishing to one of the Alexander Street product platforms at search.alexanderstreet.com and video.alexanderstreet.com. The systems support workflows including creating content metadata, indexing content, processing to prepare for publishing (such as transcoding audio/video content, formatting text and transcript files), and loading to the CDN. Metadata is processed and fed to the product platform databases and search engines.The applications and systems involve a variety of technologies including Python and PHP with mySQL databases, and ASP.NET with MS SQL Server databases. Supporting applications also involve Python with some PHP, HTML/JavaScript.The content databases also interface with other systems in providing data to the customer Administration Portal, to the royalty reporting system, and to other content publishers.About the Team  In working primarily on the Content Management systems, this team is providing direct support to the Content Operations team. As part of the larger organization, this team also works closely with the development team that is responsible for the Alexander Street product platforms as well as other teams that utilize Alexander Street content and data. The team also supports a product platform which shares technology with the indexing system.Hours of Work This is a full-time position. The other part of the technology organization is geographically distributed and work remotely, and generally work core hours of 9AM-4PM EDT.At Clarivate, we are committed to providing equal employment opportunities for all persons with respect to hiring, compensation, promotion, training, and other terms, conditions, and privileges of employment. We comply with applicable laws and regulations governing non-discrimination in all locations.