Senior Database Administrator

Worldone New York , NY 10007

Posted 3 months ago

Are you ready to make a difference in the world of healthcare data and insights delivery? Then you've come to the right place. Sermo is moving medicine forward, one conversation at a time. Our mission is to revolutionize real-world medicine by connecting doctors online to the support, wisdom and insights of their peers globally.

Our team is:

  • Passionate: whether a technologist, qual buff, savvy marketeer, biz dev guru, or quant geek, we are all motivated by our passion to improve access to global healthcare data and insights each and every day.

  • Diverse: with 350 employees in 9 countries, we bring together talent from across the globe to meet the needs of our network of 1.3M medical professionals and serve clients in 80+ countries.

  • Innovative: our tech and customer-first approach to the conventional worlds of physician engagement and market research enables us to actually make a difference - and have fun while we're at it.

Knowing your hard work is helping physicians across the world unite to improve patient outcomesand even save lives is an incredible feeling. Interested?

Summary

We are looking for a very qualified and skilled database administrator to join our team in NYC or you can work remotely anywhere in the US or Denmark. You will be responsible for extending and maintaining our enterprise data warehouse and own the core data pipeline and the systems it integrated with. We expect you to be a very SQL tech-savvy professional, who is curious about new digital technologies and aspires to combine huge amounts of data with automated systems to maintain and keep things efficient. The role comes with a lot of flexibility in terms of technologies that you will be using daily, and you will have a lot of say in terms of how those technologies should be used.

You will be working with a team of very skilled professionals that has a high drive and strives for better and faster, and we will expect the same from you. You will be focusing on helping getting data into our warehouse for ease of extracting and querying from mainly our Marketing department. Data transformation and aggregation is key to keep our systems fast and responsive.

Senior Database Administrator Tasks:

  • Be the owner of the core data pipeline and be excited about ETL

  • Design, develop, deploy, test, and maintain data processing solutions to support analysts

  • Maintain and develop the data model based on business- and engineering needs

  • Integrate external data sources into the data warehouse

  • Optimize existing processes and integrations to allow faster throughout

  • Support requested ad-hoc data queries, analysis, and reports

  • Building automated error checking to monitor and facilitate data synchronization

  • Help and be part of analyzing feedback to allow us to continuously improve our offerings

  • Assist in creating functional requirements documentation and guides

  • Participate in meetings (internal as well as external) and standups

  • Be part of the decision process in terms of technologies and processes

  • Work with our highly skilled and dedicated backend developers to further integrate our internal systems with our data warehouse

  • Participate in pager duty and call rotation to ensure system stability

Minimum Requirements:

  • 7+ years of experience with data warehousing and the integration of multiple data sources

  • Experience in developing tools for monitoring, reporting, analysis, and data transformations

  • You must be able to provide examples of a software and scripts that you have been part of building in the past

  • Extensive hands-on experience with relational databases and SQL

  • Must have experience with both PostgreSQL and MS SQL

  • Experience with NoSQL databases

  • Must have experience with Redshift

  • Experience using Git for maintaining code and scripts

Bonus Skills and Experience:

  • Experience using Solr

  • Experience with Etlworks a great plus

  • Advanced experience (performance tuning, etc.) with PostgreSQL a great plus

  • Experience with Asp.Net (Core)

  • Understanding and experience with the medical industry

  • Understanding and experience with GDPR compliance

  • An ability to perform well in a fast-paced environment

  • Experience working with high volume data platforms

What you'll get:

  • A competitive base salary

  • Competitive benefits; 401k match, health, dental, and vision insurance + health and wellness

  • The opportunity to revolutionize real world medicine and amplify the voice of physicians globally

Any questions, please email: jens.storm@sermo.com

About:

Sermo is a global social platform for physicians that fosters impactful peer-to-peer collaboration & discussions through meaningful insights, data, and trends. It is the most trusted global platform for physicians with over 800,000 fully verified and licensed physicians across 150 countries. The platform enables doctors to anonymously talk real-world medicine, review treatment options via our proprietary Drug Ratings platform, collectively solve patient cases, and earn honorarium from surveys. Through Sermo's unique community, pharmaceutical and healthcare partners can drive physician awareness and gain deep understanding of brand perceptions to benefit the medical community at large. To learn more, visit www.sermo.com


icon no score

See how you match
to the job

Find your dream job anywhere
with the LiveCareer app.
Mobile App Icon
Download the
LiveCareer app and find
your dream job anywhere
App Store Icon Google Play Icon
lc_ad

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Senior Oracle Database Administrator

Sirius XM

Posted 2 weeks ago

VIEW JOBS 1/4/2020 12:00:00 AM 2020-04-03T00:00 Regular Location: NY - 5 Penn Plaza Position Summary: The Senior Database Administrator position is responsible for the design, setup, and management of large complex databases that are located on multiple servers in a diverse hardware environment across geographically separate data centers. The Senior Database Administrator also is responsible for the maintenance of databases, which includes but is not limited to: production support, security and auditing, performance turning, backup and recovery, data replication, DR testing and documentation. Duties and Responsibilities: * Provide 24x7 support to production and critical project including participating in a weekly on call rotation. * Management of Oracle software versions, installations, upgrades and patch installations across all production and non-production environments. * Provide database management and support for Oracle Enterprise 12c (CDB/PDB) environments, including setup, configuration, deployment, backup/restore, monitoring, alerting, auditing and security. * Responsible for the development and implementation of preventative maintenance routines to ensure availability and performance of database files and their related management systems. * Monitoring of database server performance, making and implementing tuning recommendations, capacity planning, database security and data integrity including backup/recovery with RMAN and other tools, export/import etc. * Support enterprise capacity and performance planning efforts, capacity planning, maintaining and auditing security roles, cloning systems to development environments, patch management. * Provide internal consulting to internal customers' complex database-related issues, systems, and implementation projects. * Refresh development and test databases with production data as requested * Enforce user access control based on the company compliance policy. Provide weekly, quarterly and adhoc audit reports to Information Security Officers. * Ensure proper security of all databases and their respective database management systems within the corporation including maintaining and auditing security roles, auditing security and account management functions. * Perform periodic database backup restore and DR test exercises. * Responsible for the development of documentation to perform tasks listed above. Supervisory Responsibilities: Individual Contributor. No supervisory responsibilities. Minimum Qualifications: * Education: Bachelor's Degree in Computer Science or related field. At least 7 years of Oracle database administration experience within a specific technology. * Years of relevant experience: A minimum of 7+ years of relevant experience is required. Requirements and General Skills: * Good public speaking and presentation skills. * Interpersonal skills and ability to interact and work with staff at all levels. * Excellent written and verbal communication skills. * Ability to work independently and in a team environment. * Ability to pay attention to details and be organized. * Ability to project professionalism over the phone and in person. * Ability to handle multiple tasks in a fast-paced environment. * Commitment to "internal client" and customer service principles. * Willingness to take initiative and to follow through on projects. * Spelling, grammar, proofreading and editing skills. * Creative writing ability. * Excellent time management skills, with the ability to prioritize and multi-task, and work under shifting deadlines in a fast-paced environment. * Must have legal right to work in the U.S. Technical Skills: * Experience as an Oracle database administrator supporting production and non-production environments * Comprehensive knowledge of various Oracle Database design techniques, including: Oracle Golden Gate Replication, Data Guard, RAC, Partitioning, Performance Tuning, Audit Vault, Database Vault and RMAN. * Experience working in a Linux-based and vm environment with comfortable familiarity with Linux commands and operations * Good interpersonal skills, with ability to work across functional lines, and at many levels. * Ability to work on assigned tasks independently and executes with minimal direction. * Must be able to work on multiple projects simultaneously, meet project deadlines, and work under pressure. * Experience on Oracle DB Vault, Audit Vault, Oracle Unified Directory, Mongo DB, Python scripting are pluses. SiriusXM is an equal opportunity employer that does not discriminate on the basis of sex, race, color, age, national origin, religion, creed, physical or mental disability, medical condition, marital status, sexual orientation, gender identity or expression, citizenship, pregnancy, military or veteran status or any other status protected by applicable law. The requirements and duties described above may be modified or waived by the Company in its sole discretion without notice. Sirius XM New York NY

Senior Database Administrator

Worldone