Database Administrator
Core
Technical lead for day-to-day operations and maintenance of production and non-production PostgreSQL environments, leading the migration from SAP ASE to PostgreSQL for a federal government client.
Role type
Senior IC Database Administrator (Technical Lead)
Builds
Production PostgreSQL databases and migration artifacts for a federal government client
Domain
Enterprise Database Administration (PostgreSQL, SAP ASE/Sybase)
Required skills
PostgreSQL administration, SAP ASE administration, database performance tuning, database replication, backup and recovery strategies, Linux administration, SQL, shell scripting, database architecture design, team leadership
Preferred skills
Enterprise PostgreSQL experience, advanced scripting experience
Technologies
PostgreSQL, SAP ASE, Sybase, Linux, Bash, Korn
Responsibilities
Administer and maintain production and non-production PostgreSQL environments on Linux; Lead database physical design, query optimization, indexing, and performance tuning; Implement replication, backup, recovery, and disaster-recovery strategies; Support schema conversions and data migrations from SAP ASE to PostgreSQL; Evaluate PostgreSQL configuration parameters and recommend improvements; Maintain capacity planning, security controls, and patching strategies; Troubleshoot ASE performance issues and support replication processes; Oversee daily ticket queue triage and assign work to other DBAs; Provide mentorship and technical leadership to a small team; Coordinate with customer project management and participate in technical design reviews.
Seniority
Senior, hands-on IC with leadership responsibilities