Senior Database Administrator

Company: Vericast
Location: Austin
Posted on: May 16, 2022

Job Description:

Company Description

We are Vericast. We create meaningful connections between business and the people that they serve-how, whenand where it matters. By pushing the boundaries ofdata and insights, we spark discovery and inspireaction to create profitable results.

Job Description

Valassis is seeking a Senior Database Administrator to join our platform engineering operations team. This person will be responsible for all aspects of PostgreSQL databases including, but not limited to administration, schema design, programming, security and performance. Our database infrastructure is a multi-tenant, multi-user, SOC2/HIPAA compliant environment that serves software developers, data engineers, data scientists, and business analysts. This role will work closely with both the Engineering teams and Data Center operations team to migrate, setup, upgrade and maintain our various database instances.

Responsibilities

• Manage and maintain relational database servers in all environments (production, staging and test)
• Design and implement database redundancy and fail-over strategies
• Be responsible for the monitoring and uptime of all production databases
• Perform quarterly audits of DB access and use for HIPAA and SOC2 compliance
• Design and implement regular backup/restoration strategies per data retention requirements
• Be responsible for the regular maintenance on databases (e.g., Vacuum, Reindexing, Archiving)
• Proactively diagnose and resolve production issues
• Create users, groups, database schemas and establish standards for database security and auditability
• Provide support for database upgrades and server patching
  Qualifications
  
  • 3-5 years of hands-on Postgres, Oracle or MySQL DBA experience
  • Extensive experience with developing SQL queries, stored procedures, triggers, and views
  • Substantial Postgres troubleshooting skills like identifying & resolving blocking, long running queries that impact the database performance
  • Knowledge of database design principles, query optimization, index management and integrity checks
  • Understanding of modern cloud computing platforms like OpenStack is preferred
  • Automation frameworks on database provisioning and maintenance is preferred
  • Strong understanding of Linux command line utilities and operations is a plus
  • Working knowledge of cloud database technologies like Amazon RDS, DynamoDB, Microsoft Azure is a plus
  • Excellent troubleshooting skills across the whole platform stack
  • Have an analytical mindset and the ability to work independently
    Additional Information
    
    Vericast offers a generous total rewards benefits package that includes medical, dental and vision coverage, 401K matching and flexible PTO.A wide variety of additional benefits like life insurance, employee assistance and pet insurance are also available, not to mention smart and friendly coworkers!
    
    At Vericast, we don't just accept differences - we celebrate them, we support them, and we thrive on them for the benefit of our employees, our clients, and our community.---AsanEqualOpportunity employer,Vericast considers applicants for all positions without regard to race, color, creed, religion, national origin or ancestry, sex, sexual orientation, gender identity, age, disability, genetic information, veteran status, or any other classifications protected by law.Applicants who have disabilities may request that accommodations be made in order to complete the selection process bycontacting our Talent Acquisition team attalentacquisition@vericast.com.
    
    #DICE
    

Keywords: Vericast, Austin , Senior Database Administrator, IT / Software / Systems , Austin, Texas