Database Administrator

NetworkIP is seeking a versatile Database Administrator to take ownership of our data infrastructure. In this role, you will design, maintain, and optimize our core database environments to ensure high availability, data integrity, and peak performance. The primary focus will be on MySQL and Vertica, with occasional baseline support for legacy Informix systems.

The ideal candidate is a team player who bridges the gap between database administration and development, collaborating closely with engineers to design efficient schemas while keeping the underlying infrastructure rock-solid.

Core Responsibilities

Backup, Recovery, and Disaster Recovery (DR)

• Strategy & Execution: Own the end-to-end backup strategy for MySQL, Vertica, and Informix. Ensure consistent, point-in-time recovery capabilities.
• Granular Restoration: Manage and verify backups at all levels, including full instances, specific schemas, individual tables, views, and stored functions/procedures.
• Routine Testing: Establish a regular schedule for automated backup validation and restoration drills to guarantee data integrity in a disaster scenario.

High Availability & Replication Monitoring

• Replication Management: Configure, monitor, and troubleshoot replication topologies for both MySQL and Vertica.
• Proactive Alerting: Build and maintain monitoring systems to track replication lag, cluster health, and node availability, minimizing the risk of data drift or downtime.

Lifecycle Management

• Data Pruning Strategies: Design and execute automated data retention and purging policies for rapidly growing tables without impacting live production performance.
• Upgrades and Updates: Oversee database upgrades, patches, and schema migrations. Implement testing processes to ensure system uptime.

Database Design & Developer Collaboration

• Schema Architecture: Partner with development teams to design efficient databases, tables, views, and indexes.
• Optimization: Apply deep knowledge of database-specific data types to optimize storage and query performance.
• Review & Governance: Act as a reviewer for database migrations and schema changes before they hit production environments.

Do you have experience in System validation?

Pulled from the full job description

• Tuition reimbursement
• 401(k)
• Health insurance
• Retirement plan
• 401(k) matching
• Paid time off
• Vision insurance, * Fun, friendly, business casual work environment
• Full benefit package including medical, dental, vision, short-term, long-term, and life insurance
• 401K matching
• Vacation time accrued based on time of employment
• Two paid personal days per year starting on day 1 of employment
• Six paid observed holidays per year
• Semi - flexible work schedule
• Opportunity for growth and advancement

NetworkIP is located in Longview, Texas; however, remote employment is available for the right candidate. On-call rotation and occasional after-hours work will be required., * 401(k)

• 401(k) matching
• Dental insurance
• Flexible schedule
• Flexible spending account
• Health insurance
• Health savings account
• Life insurance
• Paid time off
• Retirement plan
• Tuition reimbursement
• Vision insurance