Database Administrator

Database Administrator Network

IP - 3.3

Longview, TX Job Details Full-time 7 hours ago Benefits Health savings account Paid holidays Health insurance Dental insurance 401(k) Flexible spending account Tuition reimbursement Paid time off Vision insurance 401(k) matching Opportunities for advancement Flexible schedule Life insurance Retirement plan Qualifications Data integrity assurance Data replication Automation Data migration High availability solutions design Improving system uptime or availability Database backup and recovery Data Retention (Data management) IT system monitoring Data retrieval time improvement System design Data recovery Server backup and recovery Schema design Stored procedures Database server management Data Architecture Design (Architecture design skills) System validation System testing Retention policy implementation Contingency planning Data backup Database migration or upgrading Data validation Senior level Informix Improving system uptime through database tuning Database replication implementation High availability System performance monitoring Full Job Description 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. What We Offer 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. Send resume and salary expectations to t.

Benefits:

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

Work Location:

Hybrid remote in Longview, TX 75601