Nashville, TN, 37230, USA
3 days ago
Remote PostgreSQL Database Administrator
Job Description We are seeking an experienced PostgreSQL Database Administrator with a strong track record in PostgreSQL, Oracle, Oracle-to-PostgreSQL migration projects. The ideal candidate will have deep expertise in PostgreSQL administration, performance tuning, high availability, and backup/recovery strategies, as well as hands-on experience converting large-scale, mission-critical Oracle databases to PostgreSQL in both on-prem and cloud environments. This person will be training a group of 4-6 Oracle DBA's on Postgres. Key Responsibilities: Lead the migration of enterprise Oracle databases to PostgreSQL, including schema conversion, data migration, and application integration. Perform detailed assessment of Oracle schemas, PL/SQL code, and database features to plan equivalent PostgreSQL implementations. Configure, administer, and maintain PostgreSQL databases for performance, availability, and security. Implement high availability (HA) and disaster recovery (DR) solutions for PostgreSQL (e.g., streaming replication, Patroni, pgpool-II). Develop and execute performance tuning strategies, including query optimization, indexing, and configuration adjustments. Manage database backup and recovery processes, ensuring RTO/RPO objectives are met. Collaborate with application teams to rewrite PL/SQL code into PostgreSQL-compatible functions and procedures (PL/pgSQL). Monitor database health, capacity, and growth; troubleshoot and resolve incidents promptly. Document migration plans, configuration standards, and operational procedures. Stay current on PostgreSQL features, tools, and migration best practices. We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to HR@insightglobal.com.To learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy: https://insightglobal.com/workforce-privacy-policy/. Skills and Requirements 8+ years of experience as a Database Administrator, including 5+ years in PostgreSQL. Proven, hands-on experience in end-to-end Oracle-to-PostgreSQL migration for large, complex systems. Expertise in migration tools such as Ora2Pg, AWS SCT/DMS, EDB Migration Toolkit, or equivalent. Proficiency in PostgreSQL architecture, configuration, administration and SQL and procedural languages (PL/pgSQL, PL/SQL). Solid experience with backup/recovery tools (pgBackRest, Barman) and HA solutions. Experience with Linux/Unix environments and shell scripting AWS cloud environment background Performance tuning SQL null We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal employment opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment without regard to race, color, ethnicity, religion,sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military oruniformed service member status, or any other status or characteristic protected by applicable laws, regulations, andordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or the recruiting process, please send a request to HR@insightglobal.com.
Por favor confirme su dirección de correo electrónico: Send Email