Database Administrator

Washington, US
U.S. News & World Report

About this job

Location options: Visa sponsor
Job type: Full-time
Experience level: Mid-Level
Role: Database Administrator
Industry: Media
Company size: 201–500 people
Company type: Private



Technologies

amazon-web-services, database, postgresql, agile



Job description

The Database Administrator will be responsible for developing and maintaining a wide variety of database architectures across our business units. The person will develop and revise processes and procedures to optimize database infrastructure. This resource will play a key role on data security and analytics initiatives.

For more than 85 years, U.S. News & World Report has been the driving force behind decisions that largely define the quality of consumers’ lives. We measure progress across institutions, products & services and governments locally, nationally and globally.

Focusing on Education, Health, Money, Travel, Cars and Civic, U.S. News reaches more than 40 million people monthly during moments when they are most receptive to expert advice.

Responsibilities:

●     Designing schema, access patterns, locking strategy, SQL development, and tuning for various Applications.

●     Making changes, updates and modifications to database structure and data.

●     Managing, monitoring and maintaining various databases

●     Optimizing application and end-user queries.

●     Improve efficiency of data ingestion pipelines

●     Engineer reusable capabilities and pipelines for DML, DDL, maintenance, and ETL needs that can be shared across teams.

●     Ensuring database security, integrity, stability and system availability

●     Maintaining database backup and recovery infrastructure. Debug database performance issues.

Basic Qualifications:

●     Bachelor's degree or equivalent experience

●     At least 3 years of database administration experience with PostgreSQL, MySQL or other relational databases.

●     At least 2 years of experience developing, deploying, testing in AWS.

●     2+ years of experience with Agile development methodologies

Preferred Qualifications:

  • At least 1 year of experience with AWS RDS.
  • Experience with Cloud Datawarehouse platforms such as SnowFlake, Redshift or Google BigQuery
  • At least 1 year experience using Git version control and Jenkins
  • AWS and Database Certifications

We are offering a competitive salary and comprehensive benefits package that includes healthcare, dental, and a 401(k) plan.

EOE

M/F/D/V



Location

1050 Thomas Jefferson Street Northwest Washington, US

By clicking apply you will leave devsnap. Please be careful. You should never have to pay to apply.
A new version is available REFRESH