Snowflake Developer

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. 

🌟💼 Calling All Social Media Enthusiasts! Join our Social Media Manager Internship at Marktecons!

Gain Valuable Experience in a Dynamic 3 Months Internship! 💼🌟

Are you a social media savvy individual looking to kickstart your career in the digital marketing world? 📲🌍

We have an exciting opportunity just for you! ✨

Our innovative company, Marktecons, is seeking a talented and passionate Social Media Manager Intern to join our dynamic team. 🎉

If you're ready to gain hands-on experience, sharpen your skills, and make a real impact, this internship is the perfect stepping stone for your career! 🚀

Roles and Responsibilities:-

Schedule and post content on social media accounts, boost engagement, and manage community interactions as part of the social media management team. 📅✨💬

Review designs for errors, obtain approval, and transfer final designs to the appropriate drive folders. ✔️🎨💻

Collaborate with the content calendar design team to assemble content from writers and designers into a comprehensive content calendar. 🤝📆🖌️

Conduct market research and assist in the development of digital marketing strategies to drive brand awareness, increase website traffic, and generate leads. 📊🔍📈

Knowledge of Canva to develop basic content for social media. 🎨📷🔧

Exceptional copywriting skills to craft compelling and catchy content for social media posts. ✍️🔥🎯

Knowledge of best practices for optimizing copy length, hashtags, and emojis for different social media platforms. ⏱️⌨️📌

Stipend- INR 5000/month 💰💸

Don't miss out on this incredible opportunity to gain practical experience, refine your skills, and make your mark in the digital marketing industry! Apply now and kickstart your career with Marktecons! 💼🌟🚀

Marktecons is an equal opportunity employer. We value diversity and are committed to creating an inclusive environment for all interns. 🌈🤝

#SocialMediaEnthusiasts #DigitalMarketing #InternshipOpportunity #GainExperience #HandsOnLearning #MarkteconsInternship #CareerDevelopment #SocialMediaManagement #DigitalMarketingStrategies #ContentCreation #CopywritingSkills #MarketResearch #BrandAwareness #WebsiteTraffic #LeadGeneration #CanvaDesign #Optimization #ApplyNow #KickstartYourCareer #MakeYourMark #EqualOpportunityEmployer #InclusiveWorkplace #DiversityMatters

Our client is a chain of hospitals that focus on providing high quality healthcare for all. Their hospitals have over 17 centers of excellence across all medical specialties. Through their proprietary technology, hospitals can maintain medical quality standards, give their patients a better experience and also serve them at cheaper prices.

Headquartered in Bangalore, they have their network of hospitals across locations in Bangalore and Chandigarh. Currently they have 40+ hospitals with 2000+ beds. All of their hospitals are accredited by the National Accreditation Board for Hospitals & Healthcare Providers (NABH).

Our client is funded by tier-1 investors and has raised a total of $6.3M in funding over 1 round.

• Developing, implementing and maintaining performance management and talent review processes
• Maintaining a deep understanding of the business and culture inside and out so that you can provide strategic HR partnership to the business and the teams you support
• Acting with the employee experience top of mind, continuously seeking feedback, inefficiencies, and maintaining business relationships based on trust and respect
• Resolving employee relations issues; providing coaching and counselling to management and staff; collaborating with legal counsel on issues as appropriate
• Administrating total rewards program
• Designing compensation and benefits packages
• Managing employees’ grievances
• Setting up and running a learning & development function customized for the needs of each function
• Evaluating and improving employee NPS
• Owning overall hiring process and scale to match organization growth

Desired Candidate Profile

• At least 7+ years of experience
• Previous experience in a fast paced startup environment
• Good problem solving skills
• Outstanding communication skills, specifically in written form and presentation and public speaking skills    

Responsibilities:

As a Power Platform developer, you will be responsible for analysis, prototyping, designing, and building solutions to meet business requirements. The ideal candidate is a self-starter and creative developer who can intake business automation requests, research how they can be met using the Microsoft cloud, design and build solutions to meet those needs, and present working prototypes to showcase process automation opportunities.

Requirements:

• 3+ Years of Knowledge of IT systems development experience, with a primary focus on the Microsoft solution stack
• Hands-on Knowledge of Power Platform, Microsoft technologies and Hybrid/Cloud technologies
• Understanding of the capabilities of Power Apps, Power Automate, PowerBI, Robotic Process Automation (RPA), Office 365/SharePoint Online, and Teams
• understanding of the full lifecycle of development: Analysis, Research, Prototyping, Design, and Development
• Understanding of Agile methodology and self-starter who can quickly acclimate to a dynamic environment
• Thorough knowledge of SharePoint Online features for collaboration and business process automation
• Great communication skills (written and Spoken in English)
• Bachelor's Degree in Computer Science or a related field or the equivalent demonstrated experience

Roles and Responsibilities

Hiring for Mobile app Developer (1 to 2 yrs.)

- Develop hybrid mobile app for iOS and Android platform using Flutter framework

- Hands of experience in Flutter

- Proven software development experience

- Flutter/ React Native Developer

- Must have Experienced 6 months to 2 yrs. in above

- Developed at least 2 apps and live

Desired Candidate Profile

Fresher, Experience mobile app developer

- Experience in developing Android/ iOS applications

- Testing and debugging skills

- Design, Develop and maintain applications

Experience: 2 - 5 years

Talents from Product/eComm/Internet firms Only

Key Skills: Spring boot, RESTful web services, JSON, Servlet, JSP, MySQL, MongoDB, Kafka, AWS Solr, Design Patterns, Java, Distributed systems, AWS

Looking for team members passionate about building platforms for next billion users and re-imagine the e-commerce for mobile-first users. You will be building solutions for personalization, logistics, search & discovery, payments, fraud prevention, and scalability that works and solve problems elegantly

Responsibilities:

• Develop server-side components, REST APIs

• Assume ownership for existing and new modules including design, development, and unit testing for enhancements of existing modules and development of new modules.

• Analyse problems logically and exercise sound judgment in defining, evaluating, and solving difficult technical and operational problems where solutions may be of a precedent-establishing nature.

• Lead the design and architectural improvements

• Participate and collaborate with team members in design discussions, determines areas of complexity, potential risks to successful implementation, suggest enhancements to architecture, implement POCs, and enhance application.

• Reduce technical debt with quality coding

 
Requirements:

• A solid grounding in Computer Science fundamentals (based on a BS or MS in CS or related field) from IITs and Premier Engineering College.

• Excellent Object Orientation, coupled with excellent problem solving and debugging skills.

• Highly skilled at Java and related technologies, including Java Frameworks like Spring-boot or Drop wizard, RESTful web services, JSON, Servlet, JSP, MySQL, MongoDB, Kafka, AWS Solr.

• Must have hands-on experience in building scalable and secure back end systems.

• Have hands-on experience with systems that are asynchronous, RESTful and demand concurrency

• Good to have knowledge of best software engineering practices for all stages of the software development life cycle, including coding standards, code reviews, testing, deployment.

• Experience level: 2-5 years of software development experience in Java with web architecture and scalable design

• Java / Java Script code development using frameworks like Spring, Hibernate , Rest web services,  AWS services.
• · Dev-Ops activities using Maven, Eclipse and other tools
• · Contribute to providing estimates for implementation of new requirements and work diligently towards delivering within the estimates
• · Ensure Quality of the releases by adhering to SDLC best-practices such as, unit tests,continuous integration, system testing
• · Re-use code. Ensure delivered code is modular and extensible
• · Ensure adequate coverage of functional and non-functional requirements in test plans Position Requirements
• · 3-5+ years of hands on experience in Java/J2EE development. Experience with the implementation of a distributed, enterprise JAVA/J2EE solution is strongly preferred
• · Experience in JAVA/J2EE Frameworks such as Spring, hibernate is strongly preferred
• · Experience in SOA and SOA related technologies, solutions and products as well as experience with implementation of REST full web services is preferred
• · Experience with data modelling and experience with relational databases like MySQL, SQL Server or Oracle is desirable
• · Mobile application development experience on Android or iOS is desirable