Database Administrator

Database Administrator (Oracle & PostgreSQL)

Join us as a Database Administrator in our DB Services in our corporate headquarters Gurgaon to get the opportunity to do the best work of your career and make a profound impact in our journey of enabling retail in India.

What You'll Achieve:

We are seeking a highly skilled and experienced Database Administrator (DBA) with expertise in both Oracle and PostgreSQL databases.

The ideal candidate will possess a deep understanding of database architecture, high availability configurations, disaster recovery, performance

optimization, and automation, with hands-on experience working in cloud and on-prem environments.

You will:

• Database Management: Create, configure, and maintain Oracle and PostgreSQL databases, ensuring high availability, data integrity, and performance.
• High Availability & Disaster Recovery: Implement and maintain high availability (HA) setups and disaster recovery (DR) strategies, including failover management, replication (streaming/logical), and backup strategies.
• Performance Monitoring & Optimization: Monitor database performance, optimize queries, and fine-tune configurations using native and third-party tools for both Oracle and PostgreSQL databases.
• Automation & Scripting: Automate routine tasks such as backups, database health checks, and maintenance using scripting languages such as Shell Scripts, Python, DOS, and PowerShell.
• Capacity Planning: Plan for database growth, including storage, memory, and load balancing for optimal performance in both Oracle and PostgreSQL environments.
• Database Upgrades & Version Updates: Ensure smooth and secure database version upgrades and patching in both Oracle and PostgreSQL environments.
• Database Security: Implement and maintain database security best practices for both Oracle and PostgreSQL, including user access control, encryption, and vulnerability patching.
• Backup & Recovery: Plan and implement effective backup strategies for both Oracle and PostgreSQL databases, ensuring data protection and integrity.
• Cloud & Multi-Tenant Environments: Administer databases in cloud environments (such as Azure, AWS) with experience in multi-tenant architecture, ensuring scalability and efficiency.
• Third-Party Monitoring Tools: Integrate with third-party monitoring systems like Grafana, Kibana, Prometheus, and Elasticsearch to track database performance and health.
• Collaboration & Support: Work closely with cross-functional teams to ensure smooth database operations, resolving issues, and providing database support for various projects.

Take this first step towards your dream career and an insane learning path.

Every Ginesys team member brings something unique to the table. Here's what we are looking for with this role:

Essential Requirements:

• Database Expertise: Proficiency in the installation, configuration, and administration of Oracle and PostgreSQL databases.
• HA & DR: Hands-on experience with high availability and disaster recovery configurations, including replication (streaming and logical), failover management, and backup strategies.
• Performance Tuning: Expertise in database performance analysis, query optimization, and capacity planning.
• Automation: Strong scripting skills in Shell, Python, DOS, or PowerShell to automate routine tasks.
• Database Security: Solid understanding of database security principles and best practices for both Oracle and PostgreSQL.
• Cloud Environments: Experience working with cloud-based databases and multi-tenant architectures.
• Operating Systems: Experience with both Windows and Linux operating systems in managing databases.
• Communication Skills: Strong written and verbal communication skills for effective collaboration and documentation.

Desirable Requirements:

• Cloud Platforms: Exposure to cloud platforms like Azure or AWS, particularly with managed database services.
• Integration Tools: Familiarity with integrating databases with third-party tools like Grafana, Kibana, Prometheus, and Elasticsearch for performance monitoring.
• Disaster Recovery Planning: Experience in planning and implementing disaster recovery solutions for Oracle and PostgreSQL databases.
• Version Control: Experience with database versioning and updates in high-availability architectures.
• Knowledge of Connection Poolers: Experience with connection poolers like pgPool and pgBouncer for PostgreSQL.
• Cross-Platform Experience: Experience managing databases across both Oracle and PostgreSQL in hybrid or multi-cloud environments.

Personal Attributes:

• Strong problem-solving abilities and troubleshooting skills.
• Ability to work both independently and in a team environment.
• Excellent planning, organizational, and documentation skills.
• Ability to communicate complex technical concepts to non-technical stakeholders.

Benefits:

We like to think that talent grows at Ginesys and stays at Ginesys. To ensure this, we provide our employees with the best working environment, the latest technology and continuous support. We go out of our way to retain the small business feeling with which we started and stimulate innovation and collaboration through teamwork and our non-hierarchical approach. We offer competitive salary, and other fantastic perks and benefits, such as:

• Ginesys Academy for holistic training and development
• Comprehensive health insurance coverage
• Excellent rewards and recognition policy
• Transparent compensation policy with no unnecessary deduction in CTC
• Annual company off-site and a variety of events, celebrations throughout the year
• Travelling opportunities between our offices across the country.
• Annual Ginesys walkathon & related sporting events
• Quarterly Coffee with CEO

and more

Here's our story; now tell us yours

"Ginesys One" is India's best omniretail suite backed by Ginesys, the first integrated Retail specific ERP software for online retail, offline retail and distribution. It is the largest Indian company in the retail tech industry catering to both online and offline needs brands including (Manyavar, V-Mart, Skechers) are accelerating their businesses with Ginesys. With a team of 400+ employees, Ginesys One plans to revolutionise retail by being a single-stop cloud-based retail suite.

We have a pan India presence with offices in major cities including Gurgaon, Kolkata, Bangalore, Hyderabad, Mumbai, Coimbatore & Goa and are expanding rapidly. We love the challenges of retail and are busy solving them to create a great retail tech suite.

Ginesys core mission is to continue to build world-class internal service capabilities, in a bid to deliver outstanding external service value to customers. We are an ISO-certified and SOC compliant company having won myriad awards for our innovation and support. For further information, please visit our website