Database Administrator - PostgreSQL

Dewpoint • Lansing, MI

2d • Onsite

About The Position

The Database Administrator will join the Enterprise Data team, focusing on PostgreSQL and SQL Server. The role is responsible for installation, patching, security, and capacity management of enterprise database management systems. The successful candidate will monitor and maintain production and non-production database environments, develop operational processes and documentation, support users, and help ensure database performance, integrity, and availability.

The position includes shared 24/7 on-call support on a monthly rotation. It requires local presence in Michigan for on-site interviews and work. Certain duties may involve systems requiring ADP I or II clearance and U.S. citizenship or naturalized citizenship. W2 employment only; C2C and third-party submissions are not accepted.

Requirements

• At least 3 years of experience.
• Experience as a PostgreSQL database administrator; EDB experience is preferred.
• Experience as a SQL Server database administrator.
• Proficiency with scripting languages such as BASH, KSH, PowerShell, Python, or Perl.
• Experience developing automated processes for routine database maintenance in Microsoft Windows Server or Unix environments.
• Experience tuning database performance in OLTP and data warehouse environments.
• Proficiency with backup and recovery software products and concepts.
• Experience with high-availability database solutions.
• Experience with cloud database migration and administration.
• Ability to work autonomously and with multiple teams to triage database performance issues.
• Ability to guide other teams on best practices and efficiency improvements.
• Strong written and verbal communication skills.
• Ability to think outside the box.
• Must be local to Michigan for on-site interviews and on-site work.
• U.S. citizenship or naturalized citizenship may be required for duties involving systems requiring ADP I or II clearance.

Nice To Haves

• Experience with EDB.

Responsibilities

• Monitor day-to-day production and non-production database operations, including database and operating-system-level space administration.
• Create and respond to automated alerts to maintain database integrity and stability.
• Develop and maintain work instructions to train the database administration team on supported database systems.
• Develop processes for monitoring database performance and integrity, including backup and recovery, automation of routine activities, system health, and operational readiness.
• Evaluate, recommend, and oversee implementation of database-related technologies and their integration into the enterprise technology landscape.
• Ensure the development and maintenance of business recovery and disaster recovery processes.
• Provide technical assistance and support to internal and external users of corporate databases.
• Participate in shared 24/7 on-call support on a monthly rotation.

What This Job Offers

• Job Type: Full-time
• Education Level: No Education Listed