Database Administrator - PostgreSQL

Dewpoint • Lansing, MI

4d • Onsite

About The Position

The Database Administrator will join the Enterprise Data team, focusing on PostgreSQL and SQL Server. The role is responsible for installing, patching, securing, and managing the capacity of enterprise database management systems. The position monitors production and non-production databases, supports system stability and performance, develops operational processes and work instructions, evaluates database technologies, and supports business and disaster recovery. The role also provides technical assistance to database users and participates in a shared monthly 24/7 on-call rotation. Candidates must be local to Michigan for on-site interviews and work. 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 a Microsoft Windows Server or Unix operating-system environment.
• Experience tuning database systems supporting OLTP and Data Warehouse environments.
• Proficiency with backup and recovery software products and concepts.
• Experience with high-availability solutions for database systems.
• Experience with cloud database migration and administration.
• Ability to work autonomously and with multiple teams to triage database performance issues.
• 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 requirements.
• U.S. citizenship or naturalized citizenship is required for duties that involve systems requiring ADP I or II clearance.
• W2 only; no C2C or third-party submissions.

Nice To Haves

• Experience with EDB.

Responsibilities

• Monitor production and non-production database systems and manage database and operating-system-level space to ensure smooth, uninterrupted operation.
• Create and respond to automated alerts to maintain database system integrity and stability.
• Develop and maintain work instructions to train the database administration team on operating and creating supported database systems.
• Develop and maintain processes for monitoring database performance and integrity, including backup and recovery, automation of routine tasks, system health, and operational readiness.
• Evaluate, recommend, and oversee implementation of database-related technologies and their integration into the enterprise technology environment.
• Ensure business recovery and disaster recovery processes are developed and maintained.
• Provide technical assistance and support to internal and external users of the corporation’s databases.
• Participate in shared 24/7 on-call support on a monthly rotation.
• Automate routine database maintenance activities using scripting languages in Microsoft Windows Server or Unix environments.
• Tune database performance for systems supporting OLTP and Data Warehouse environments.
• Troubleshoot database performance issues autonomously and with multiple teams.
• Provide other teams with guidance on database best practices and efficiency improvements.

What This Job Offers

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