MNJ Software [Remote] PostgreSQL DBA Job: Apply for Remote Roles
MNJ Software
View All Jobs from MNJ Software →MNJ SOFTWARE is actively hiring for remote PostgreSQL DBA roles, offering professionals with 3 to 6 years of experience the opportunity to work from home while managing and optimizing complex, global database architectures. These remote MNJ Software PostgreSQL DBA jobs are ideal for candidates with strong academic backgrounds who want to actively participate in the design, development, and implementation of high-level architectural deliverables for custom projects and products.
You will be part of a highly skilled team leveraging the Global Network Delivery Model to provide unmatched service levels. The role demands deep expertise in the PostgreSQL ecosystem, including performance tuning, High Availability (HA) configurations, and UNIX shell scripting, offering the perfect blend of technical challenge, cross-functional collaboration, and professional autonomy.
Quick Job Details
What You'll Do
As a PostgreSQL DBA at MNJ SOFTWARE, your daily responsibilities will revolve around independently administering large-scale databases and managing the entire database lifecycle.
- Manage the entire database lifecycle, including creating and managing schemas, tables, tablespaces, users, roles, and groups.
- Generate and explain execution plans for SQL queries to identify bottlenecks, optimize indexing, and implement table partitioning.
- Take full ownership of backup and recovery strategies by setting up WAL archiving, managing Point-in-Time Recovery (PITR), and utilizing tools like Pg dump.
- Configure and manage High Availability (HA) setups, handling streaming replication and replication failovers using Repmgr, Barman, PG bouncer, and PG pathman.
- Perform routine hands-on maintenance operations such as vacuum, vacuum full, and analyze.
- Monitor alert logs and scheduled jobs to ensure system reliability and high performance.
- Execute hardware capacity planning by forecasting requirements for storage, memory, and CPU cycles based on system loads.
- Collaborate cross-functionally with technical leads, testers, product managers, and designers to ensure reliable system integration.
- Work flexible 9-hour shift schedules between 6 AM – 10 PM IST or 6 PM – 6 AM IST (Monday through Friday), with occasional unpaid overtime based on business needs.
Get Latest 📰 Job Updates
Never miss an opportunity! Join our official channels for daily job alerts and career tips.
What You Need (Requirements)
To qualify for this position, you must possess a strong academic background and deep expertise in core database fundamentals and administration.
- Hold a relevant academic degree such as an ME, M.TECH, BE, B.TECH, MCA, or M.Sc(IT).
- Have 3 to 6 years of proven experience working as a PostgreSQL DBA.
- Possess expert knowledge of PostgreSQL architecture, system catalogs, index management, and performance tuning.
- Demonstrate a strong understanding of database fundamentals, including Multi-version Concurrency Control (MVCC), transactions, and locking mechanisms.
- Show deep expertise in backup and High Availability technologies, specifically Point-in-Time Recovery (PITR), WAL archiving, streaming replication, and replication failover.
- Have hands-on practical experience with PostgreSQL tooling, including PG Admin, Repmgr, Barman, PG bouncer, and PG pathman.
- Exhibit a strong understanding of UNIX environments, coupled with the ability to write robust Shell Scripts for automation.
- Display strong analytical and problem-solving capabilities as an independent thinker.
- Demonstrate professionalism, teamwork, effective planning, and mandatory fluency in oral and written English.
- Be willing to successfully complete a comprehensive recruitment process that includes Aptitude Tests, Technical Tests, Interviews, and a Medical Health Checkup.
Tech Stack
💡 Gigsdock Pro-Tip
To succeed in the recruitment process for remote MNJ Software PostgreSQL DBA jobs, ensure your resume heavily highlights your hands-on experience with replication failovers, WAL archiving, and Point-in-Time Recovery (PITR). For the technical test and interview, be prepared to confidently explain execution plans, discuss your live-environment query tuning approach, and demonstrate your proficiency in UNIX shell scripting. Furthermore, emphasizing your past experience with hardware capacity planning—specifically how you forecast storage and CPU requirements based on system loads—will significantly set you apart as a senior-level administrator ready for complex, enterprise-grade challenges.
⚠️ Disclaimer & Important Information
- Never pay any amount for getting a job.
- Apply before the hiring closes or the employer stops accepting applications.