JOBSEARCHER

PostgreSQL Developer / DBA

We are hiring a PostgreSQL Developer / DBA to lead the migration of our application and database platform from Microsoft SQL Server on Windows to PostgreSQL on Linux. You will own the migration end to end, then run and tune the new platform in production. This is a hands-on role that combines database design and development as well as administration. The ideal candidate has already taken a production database from SQL Server to PostgreSQL and knows where the hard parts are: T-SQL conversion, data type and collation differences, cutover planning and performance under real transaction load. You will work closely with our application developers, infrastructure team and business stakeholders from our Alpharetta office. Migration Plan and execute the migration of schemas, data and database code from SQL Server on Windows to PostgreSQL on Linux. Convert T-SQL stored procedures, functions, triggers and jobs to PL/pgSQL and PostgreSQL-native equivalents. Resolve differences in data types, collation, identity and sequence handling, transaction isolation and locking behavior. Design and rehearse the cutover, including data validation, rollback plans and minimal-downtime strategies. Work with application developers to update queries, connection settings and data access code for PostgreSQL.Database administration Install, configure, patch and upgrade PostgreSQL on Linux. Build and maintain high availability, replication, backup and point-in-time recovery, and test restores regularly. Monitor database health and capacity, and respond to production incidents. Manage roles, permissions, encryption and auditing to keep data secure. Automate routine operations with shell scripting and related tooling. Development and performance Design schemas, indexes and partitioning strategies for high-volume transactional workloads. Write and review SQL and PL/pgSQL, and tune slow queries using execution plans and statistics. Tune PostgreSQL configuration, vacuum behavior and connection pooling for sustained throughput. Document standards, runbooks and architecture, and coach developers on PostgreSQL best practices.
Required qualifications: Hands-on experience migrating a production database from Microsoft SQL Server on Windows to PostgreSQL on Linux.5+ years of combined database development and administration experience, including recent production PostgreSQL work. Strong SQL and PL/pgSQL skills, plus enough T-SQL fluency to read, convert and validate existing SQL Server code. Solid Linux skills: command line, shell scripting, service management and basic OS-level troubleshooting. Proven experience with PostgreSQL backup and recovery, replication, and high availability. Demonstrated query and server performance tuning, including execution plans, indexing and configuration. Clear written and verbal communication, and the ability to work directly with developers and business stakeholders. Lives in or near Alpharetta, Roswell, Johns Creek or Cumming, and can work from our Alpharetta office a few days each week.
Preferred qualifications: High-transaction environments (strongly preferred). Experience supporting high-volume OLTP systems where concurrency, locking, latency and uptime are critical. AWS (a big plus). Experience running PostgreSQL on AWS, such as Amazon RDS for PostgreSQL, Aurora PostgreSQL or self-managed on EC2, and with migration tooling such as AWS DMS and the Schema Conversion Tool. WildFly (a plus). Experience with the WildFly application server, including datasource and connection pool configuration. Experience with connection pooling and HA tooling such as PgBouncer, Patroni or repmgr. Experience with monitoring and observability tools for PostgreSQL.This is a hybrid role based at our offices in the Alpharetta area. You will work from the office a few days each week and remotely the rest. We are specifically looking for candidates who live in the Alpharetta, Roswell, Johns Creek or Cumming area and could commute to our office in Alpharetta. If you do not live in Atlanta, please do not apply...this role is local to Atlanta candidates only. This is a full-time position with a base salary of $140,000 – $160,000, depending on experience, plus bonus. To apply, send your resume and include your experience with a SQL Server to PostgreSQL migration you have worked on, including the size of the database and your role in the project.