Remote PostgreSQL Database Administrator

Other Jobs To Apply

No other job posts for this day.

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 inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity employer that believes everyone matters. Qualified candidates will receive consideration for employment opportunities without regard to race, religion, sex, age, marital status, national origin, sexual orientation, citizenship status, disability, 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 Human Resources Request Form ( . The EEOC "Know Your Rights" Poster is available here ( . To learn more about how we collect, keep, and process your private information, please review Insight Global's 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. Remote Benefits: Gym Memberships, Maternity/Paternity Paid Leave, Retirement / Pension Plans, Vacation/paid time off, Transportation Allowance, Employee Events, Parking , Employee Referral Program, Performance bonus, Flexible Spending Accounts, Vehicle Allowance, Paid Holidays, Paid sick days, Medical, Dental and Vision, Merchandise Discounts, Professional Development, Free Food and Coffee, Mobile Phone Discount, Work From Home, Subsidized Commuting, 401K About the Company: Insight Global We are a staffing agency helping individuals find jobs and employers fill open positions. Based in Atlanta, Insight Global is a premier provider of employment and staffing solutions to Fortune 1000 customers across the United States and Canada. We provide long-term contract, short-term contract, temporary-to-permanent, direct placement, and enhanced staffing services. Insight Global specializes in placing contract job seekers into Information Technology, Accounting and Finance, Engineering (non-IT), and Government jobs. Since our inception in 2001, we have experienced unprecedented growth within our industry, rapidly expanding from an Atlanta-based start-up to one of the most successful staffing firms in America. Our core staffing services are the backbone upon which Insight Global was founded and have driven our success. We cater our delivery approach and recruiting efforts to meet each client’s unique demands, ensuring that we deliver both maximum client value and the differentiated Insight Global experience. Company Size: 2,500 to 4,999 employees Industry: Healthcare Services Founded: 2001 Website: Apply tot his job

Back to blog

Common Interview Questions And Answers

1. HOW DO YOU PLAN YOUR DAY?

This is what this question poses: When do you focus and start working seriously? What are the hours you work optimally? Are you a night owl? A morning bird? Remote teams can be made up of people working on different shifts and around the world, so you won't necessarily be stuck in the 9-5 schedule if it's not for you...

2. HOW DO YOU USE THE DIFFERENT COMMUNICATION TOOLS IN DIFFERENT SITUATIONS?

When you're working on a remote team, there's no way to chat in the hallway between meetings or catch up on the latest project during an office carpool. Therefore, virtual communication will be absolutely essential to get your work done...

3. WHAT IS "WORKING REMOTE" REALLY FOR YOU?

Many people want to work remotely because of the flexibility it allows. You can work anywhere and at any time of the day...

4. WHAT DO YOU NEED IN YOUR PHYSICAL WORKSPACE TO SUCCEED IN YOUR WORK?

With this question, companies are looking to see what equipment they may need to provide you with and to verify how aware you are of what remote working could mean for you physically and logistically...

5. HOW DO YOU PROCESS INFORMATION?

Several years ago, I was working in a team to plan a big event. My supervisor made us all work as a team before the big day. One of our activities has been to find out how each of us processes information...

6. HOW DO YOU MANAGE THE CALENDAR AND THE PROGRAM? WHICH APPLICATIONS / SYSTEM DO YOU USE?

Or you may receive even more specific questions, such as: What's on your calendar? Do you plan blocks of time to do certain types of work? Do you have an open calendar that everyone can see?...

7. HOW DO YOU ORGANIZE FILES, LINKS, AND TABS ON YOUR COMPUTER?

Just like your schedule, how you track files and other information is very important. After all, everything is digital!...

8. HOW TO PRIORITIZE WORK?

The day I watched Marie Forleo's film separating the important from the urgent, my life changed. Not all remote jobs start fast, but most of them are...

9. HOW DO YOU PREPARE FOR A MEETING AND PREPARE A MEETING? WHAT DO YOU SEE HAPPENING DURING THE MEETING?

Just as communication is essential when working remotely, so is organization. Because you won't have those opportunities in the elevator or a casual conversation in the lunchroom, you should take advantage of the little time you have in a video or phone conference...

10. HOW DO YOU USE TECHNOLOGY ON A DAILY BASIS, IN YOUR WORK AND FOR YOUR PLEASURE?

This is a great question because it shows your comfort level with technology, which is very important for a remote worker because you will be working with technology over time...