tekla

Job Title: Database Administrator (PostgreSQL) 

Experience: 3 to 6 years 

Location: Gurgaon (Hybrid) 

Employment Type: Full-time 

Job Description: 

We are seeking a skilled Database Administrator (DBA) with expertise in PostgreSQL and strong RDBMS concepts. The ideal candidate will be responsible for database performance monitoring, optimization, automation, and interaction with development teams to support business requirements. 

Key Responsibilities: 

1. Database Administration & Management 

• Manage, configure, and maintain PostgreSQL databases ensuring high availability and reliability. 
• Implement Primary-Slave replication architecture and ensure smooth data synchronization. 
• Work with AWS RDS for PostgreSQL database hosting. 
• Automate database backups and manage release versions for database changes. 
• Implement point-in-time recovery (PITR) backups in AWS RDS to ensure data integrity and disaster recovery. 

2. Performance Monitoring & Optimization 

• Regularly monitor database health and performance metrics. 
• Analyze and optimize slow queries to enhance application performance. 
• Fine-tune database performance using configuration parameters, buffers, connections, Disk IOPs, and memory. 

3. SQL Development & Optimization 

• Write, optimize, and maintain stored procedures, SQL functions, and SQL Views. 
• Implement indexing strategies to improve query performance. 

4. Collaboration & Requirement Analysis 

• Work closely with application developers and business analysts to understand new product requirements. 
• Provide recommendations on database design and architecture for scalable solutions. 

5. Database Security & Compliance 

• Implement best practices for database security, access control, and data integrity. 
• Ensure compliance with data governance and security policies. 

6. Automation & Maintenance 

• Automate database maintenance tasks such as backups, indexing, and archiving. 
• Establish monitoring and alerting systems to proactively address database issues. 

Technical Expertise Required: 

• 3 to 6 years of experience as a Database Administrator (DBA). 
• Strong knowledge of PostgreSQL and RDBMS principles. 
• Experience in writing stored procedures, SQL functions, and SQL Views. 
• Hands-on experience in query optimization and performance tuning. 
• Understanding of Primary-Slave architecture and replication setup. 
• Knowledge of database configuration tuning (buffers, connections, Disk IOPs, Memory, etc.). 
• Experience in automating database backups and version control for DB changes. 
• Familiarity with AWS RDS for PostgreSQL and point-in-time backup (PITR). 
• Experience in cloud-based database solutions (AWS RDS, Azure, GCP). 
• Strong problem-solving and analytical skills. 

Preferred Qualifications: 

• Experience in high-availability solutions and disaster recovery strategies. 
• Exposure to NoSQL databases is a plus. 
• Experience with database migrations and upgrades. 

• Responsible for overall AOP target achievement.
• Responsible for leading a team involved in direct Fixed Battery\2W sales.
• Driving BTL and local sales activities through team.
• Travelling across locations to focus on opportunities for Sales and Growth.
• Hiring, Leading, Managing and motivating Sales team to drive growth numbers.

About The Company :

SCIGON was founded in 2008 by technology practitioners with a people-focused mindset. We continually strive to build on a track record of success, establishing new avenues for capabilities and growth. Based in Chicago, SCIGON offers a complete suite of offerings to meet enterprise and public sector customer technical, engineering and product needs. SCIGON's professionals advance client initiatives with a high degree of quality and efficiency. SCIGON has received broad recognition nationally and has been recognized through industry awards, media coverage, and several case studies Our goal is to provide fresh and effective ideas for mutual success. Our Mission: SCIGON is committed to providing an innovative approach and solutions that enable our clients and partners to succeed. While knowledge, experience and technology provide the tools with which we reach these aims, we place the most value on relationships.

We focus on understanding customer and partner needs, bring a collaborative approach to the discussion, and work hand-in-hand to identify effective strategies that intersect outcomes with the business drivers that underpin needs. Our Vision: Understanding client and partner needs, and to working as a team to meet mutual objectives. Our company culture is also centered on a commitment to sustainability, as well as social and economic responsibility

Frequently Asked Questions :

Why work for us ?

It would be a Challenging, grounds up a promising circumstance for you. You get an opportunity to chip away at great technologies alongside stunning specialists with strong financial strength.

Also, we have some Employee Value Propositions :

- An outstanding work culture :

- Remote work :

- Work life balance :

- Provident fund Professional growth through our Learning and development

Required Skills

As a developer, you have a passion for development and a thirst to learn. You enjoy working in a fast-paced and dynamic environment. You are a quick learner who can step up and take ownership of work to get things done on time. You also enjoy and appreciate working and collaborating with others from various backgrounds as part of a team.

Job Requirement

• Full-stack developer with exposure working in building products from scratch
• Have 2+ years in implementing front-end of applications using ReactJS
• Proficient in HTML 5, CSS 3, Bootstrap Ant-D, Redux, JavaScript and writing cross-browser compatible code
• Good knowledge of MVC, MVVM, OOPS concepts, Web Development Concept.
• Experience with RESTful services
• Work experience any one of the backend technologies such as Java, NodeJS, .NET will be a major plus
• Experience in JavaScript build tools such as web-pack /gulp
• Familiar with testing frameworks (such as Jasmine) and Test runner framework (such as Karma) (good to have)
• Thorough understanding of the responsibilities of the platform, database, API, caching layer, proxies, and other web services used in the system
• Knows unit testing
• Critical thinker and problem-solving skills
• Good time-management skills
• Great interpersonal and communication skills

Duty /Responsibility

• Your specific duties in this role will include:
• Responsible for the front end/UI development for of the web-based and mobile-based application
• Responsible for communicating with clients
• Responsible for communicating with Designing Team and Team Manager
• Responsible for Requirement Analysis
• Responsible for mentoring junior front-end developers
• Responsible for researching new web technologies
• Responsible for developing POCs
• Respond to technical queries/requests from team members and customers.
• Coach, guide, and mentor junior members in the team.

Responsibilities:

• Strong Technical Chops: You should know how to build highly scalable, robust, and fault-tolerant services that support our unique rate-of-growth requirements.
• You should be on top of the latest architectural trends.
• Fast Learners: We are looking for folks who thrive on new technologies and don't believe in one-size-fit all solutions.
• You should be able to adapt easily to meet the needs of our massive growth and rapidly evolving business environment.

• You understand requirements beyond the written word.
• Whether you're working on an API used by other developers, an internal tool consumed by our operation teams, or a feature used by millions of customers, your attention to details leads to a delightful user experience.

Requirements:

• Strong knowledge of MySQL, NoSQL, PostgreSQL, ElasticSearch.
• Experience in Java and web technologies.
• Experience in any one scripting language like Python.
• Hands-on experience with systems that are asynchronous, RESTful and demand concurrency.
• Knowledge of best software engineering practices for all stages of software development life cycle, including coding standards, code reviews, testing and deployment.