Role: My SQL DBA
Work Location: Noida/Hyderabad
Exp : 3+ Yrs
About the Role:
The ideal candidate would be working on the servers which impact various SaaS AI/ML products and
1000+ models in AI/ML. As a DBA administrator the server support would be provided for various
industry verticals like Finance, Telecom, Travel & Transportation, Healthcare, Government etc. This role
would give an opportunity working on multiple and complex databases for fortune 500 customers which
have impact on their data related to AI/ML products/models of the company.
About the Company:
We are America’s oldest machine learning solutions company. With offices across US, China and India,
we hire people with a broad set of technical and domain skills who can contribute to the creation of
machine learning solutions across verticals such as financial services, telecommunications, healthcare,
consumer products etc.
Preferred Qualification:
(Must have)
· Three years or above working experience, more than two years in MySQL, familiar with MySQL
database architecture.
· Have good experience in database troubleshooting and solutions for the whole system chain,
including OS, Database, storage, network, application, cloud and so on.
· Familiar with SQL tuning, know about how to split large tables in MySQL.
· Familiar with the daily backup and restore operations of MySQL, and know about the HA
principles of MySQL replication and MySQL Cluster. Experience in PostgreSQL is preferred.
· Familiar with Linux operating system, be able to write daily scripts with Shell/Python.
· Experience about NoSQL databases is preferred, such as MongoDB, Redis.
· Experience about distribution databases is preferred, such as Greenplum, Clickhouse.
· Oracle DBA or SQL Server DBA working experience is preferred.
· Careful work, strong sense of responsibility, good learning ability and team spirit.
Responsibilities:
· Responsible for the daily maintenance and troubleshooting for all Databases, such as MySQL
and postgreSQL, make sure all database system running safely and stably.
· Establish MySQL daily backup and recovery policies, and data security policies.
· Responsible for the design and implementation of Database tables, and large table split policy.
· Provided daily support to the development team and application team, such as database design
specification and performance tuning suggestions.
About Gipfel & Schnell Consultings Pvt Ltd
Similar jobs
Proven work experience as a Database Programmer, Database Developer, or similar role.
Strong proficiency in SQL and hands-on experience with PostgreSQL.
Solid understanding of relational database concepts and principles.
Experience in database design, schema modeling, and optimization.
Familiarity with database administration tasks, such as user management, backup and recovery, and performance tuning.
Ability to write efficient SQL queries, stored procedures, and functions.
Detail-oriented with a focus on data accuracy and integrity.
Familiarity with software development methodologies and programming languages is a plus.
Hi,
We are looking for cloud solution professionals with the following skill sets;
Experience: 10+ years in cloud architecting
Location: Mumbai
Job Responsibilities:
- Analyze and understand customer business processes and workflows, define requirements and design appropriate solutions.
- Provide End 2 end cloud Solutioning along with secured infra
- Collaborate with vendors for the execution
- Well understanding on open source stack frameworks, AWS & Azure Cloud services
- Solutioning extending from green field to enterprise view
- Presentation skills with a high degree of comfort with both large and small audiences.
- High level of comfort communicating effectively across internal and external organizations
- Intermediate/advanced knowledge of the cloud services, market segments, customer base and industry verticals.
- Demonstrated experience leading or developing high quality, enterprise scale software products using a structured system development life cycle.
- Demonstrated ability to adapt to new technologies and learn quickly.
- Certified Solutions Architect( AWS / Azure)
- Recommendations on security, cost, performance, reliability and operational efficiency to accelerate challenging, mission-critical projects
- Experience migrating or transforming customer solutions to the cloud
Primary Skills :
JAVA / J2EE; Spring, Spring Boot, Microservices,Angular JS, Instream data handling, Elastics search DB, Mango DB,DevOps tools- Jenkin, github,maven build, Hands on AWS & Azure cloud services,Mobile: Native and hybrid app hands on;Docker Containers , AKS,Big data and Hbase, Data Lake , service bus, AD
Secondary Skills :
- Extensive experience in Microservices, Rest Services, JPA, Automated unit testing through tools.
- Proven design skills and expertise is required.
- Good knowledge of current / emerging technologies and trends.
- Good analytical, grasping and problem solving skills. Excellent written and verbal communication skills. High levels of initiative and creativity.
- Good communication skills with all stake holders, good team player with ability to mentor juniors
Requirements:
• Installing and configuring software, hardware and networks. •Administrate infrastructure, including firewalls, databases, malware protection software and other processes
•Provide technical support for hardware/software issues and resolve help desk requests
•Monitor the system daily and respond immediately to security or usability concerns.
•Upgrade systems with new releases and models and ensuring security and efficiency of IT infrastructure.
•Constant finetuning of the OS for improving the performance of the system.
•Coordinating with OEM support teams in case of any dockets raised and ensure the issues are resolved.
•Provisioning Operational support and troubleshooting the issues related to system administration.
•Perform in 24 x 7 environment in shift roaster and attend calls whenever assigned
•Must be Red Hat certified professional.
Skills Required:
•Red Hat (Primary)
•Debian
•Ubuntu
•SUSE
This is a remote-based role but preference will be given to candidates who are already based in Bangalore. Compensation will be a mix of cash and stock component commensurate to the experience and skill level of the candidate.
Founding team includes members with experience in consulting, venture capital and product at leading firms.
ABOUT US.
Established in 2009, Ashnik is a leading open-source solutions and consulting company in South East Asia and India, headquartered in Singapore. We enable digital transformation for large enterprises through our design, architecting, and solution skills. Over 100 large enterprises in the region have acknowledged our expertise in delivering solutions using key open-source technologies. Our offerings form critical part of Digital transformation, Big Data platform, Cloud and Web acceleration and IT modernization. We represent EDB, Pentaho, Docker, Couchbase, MongoDB, Elastic, NGINX, Sysdig, Redis Labs, Confluent, and HashiCorp as their key partners in the region. Our team members bring decades of experience in delivering confidence to enterprises in adopting open source software and are known for their thought leadership.
As a team culture, Ashnik is a family for its team members. Each member brings in different perspective, new ideas and diverse background. Yet we all together strive for one goal – to deliver best solutions to our customers using open source software. We passionately believe in the power of collaboration. Through an open platform of idea exchange, we create vibrant environment for growth and excellence.
THE POSITION
Ashnik is looking for talented and passionate people to be part of the team for an upcoming project at client location.
QUALIFICATION AND EXPERIENCE
- Preferably have a working experience of 4 Years and more , on production PostgreSQL DBs.
- Experience of working in a production support environment
- Engineering or Equivalent degree
- Passion for open-source technologies is desired
ADDITIONAL SKILLS
- Install & Configure PostgreSQL, Enterprise DB
- Technical capabilities PostgreSQL 9.x, 10.x, 11.x
- Server tuning
- Troubleshooting of Database issues
- Linux Shell Scripting
- Install, Configure and maintain Fail Over mechanism
- Backup - Restoration, Point in time database recovery
- A demonstrable ability to articulate and sell the benefits of modern platforms, software and technologies.
- A real passion for being curious and a continuous learner. You are someone that invests in yourself as much as you invest in your professional relationships.
RESPONSIBILITIES
- Monitoring database performance
- Optimizing Queries and handle escalations
- Analyse and assess the impact and risk of low to medium risk changes on high profile production databases
- Implement security features
- DR implementation and switch over
LOCATION: Pune
Experience: 8 yrs plus
Package: upto 17 LPA
Ability to translate Wireframes and PSD Designs into functional web
apps using HTML5, React , Node.js, and Mongo
Binding of UI elements to JavaScript object models
Creating RESTful services with Node.js
Architect scalable web architectures
Work in a cross-functional team to deliver a complete user experience
Create Unit and Integration tests to ensure the quality of code
Be responsive to change requests and feature requests
Write code that is cross-platform and cross-device compatible
Ability to wear many hats and learn new technologies quickly
2.Overall 3-4 yrs Experience in PHP
3. Expert in working on CRM Software, the excellent ability for making applications in CRM Software.
4.Strong Experience in the large data set
5.Strong Knowledge in any one of PHP ( Yii2, Larvel, Codeigniter)
6.Good understanding of Code optimization
7.Expert in working on core PHP,Oops,MySQL,Javascript,Ajax,HTML5,CSS3,& JQuery technologies
8.Proficient Understanding of Code Version Tools Such as Git, Bit Bucket
9.The candidate should be well versed with problem-solving skills, task breakdown & code reviewing.
Job Description:
MySQL - DBA L3 Support
- 7 -10 years of experience in MySQL, handled multiple versions & flavors of MySQL servers both for standalone & enterprise version, Data center and VM/Cloud setup.
- Strong database Configuration and troubleshooting / problem solving skills.
- Strong knowledge of database backup and recovery concepts and practices.
- Enabling disabling scheduled Jobs on MySQL Server
- Work with Dev and DevOps engineers to ensure that all needed data is gathered and provided to them for any performance issues
- Experience in managing both on-prem DB as well as VM / cloud based DBs
- Maintenance of backups (perform backups, monitor backup, report obsolete backups)
- Maintenance of user access (creating user accounts, dropping user accounts, granting privileges)
- Maintenance of log and trace files (remove, initialize, archive them)
- Knowledge on SQL scripts
- Managing Database administration includes Daily health checks, Database tuning, Query optimization & Backup & Replication
- Experience in alert configurations using existing alerting tools or scripts
- Strong proficiency in MySQL database management
- Table design including normalization
- Database backups and recovery is a plus
- Experience with recent versions of MySQL
- Understanding of MySQL’s underlying storage engines, such as InnoDB and MyISAM
- Good Experience with Procedure and events in MySQL
- Experience with replication configuration in MySQL
- Proficient in writing and optimizing SQL statements
- Knowledge of MySQL features, such as its event scheduler
- Knowledge of limitations in MySQL and their workarounds in contrast to other popular relational databases
- Strong MySQL Queries tuning skills
- Write scripts using Shellscript to automate manual administrative tasks
- Maintain backups and perform point-in-time restorations
- Creating tables, alter column, and store procedure.
- Good Experience in Creating index and query optimizing
- Experience in MongoDB to SQL migration
Overall 11+ years of experience, with at-least 2+ years in Architecture. Hands-on and able to go deep into the code, if needed.
Mandatory Architecture & Design Skills: Design Pattern, Scalablity, Security, Resiliency, Micro-Services.
Mandatory Technology Skills: Kafka, Spring WebFlux, Spring Reactor, NoSQL (at least 1 NoSQL database experience is must), Java 8+, JWT, Spring Boot, Jmeter, New Relic, JVisualVM, JVM tuning.
Desirable Technology Skills: Couchbase, AWS, Docker, JProfiler, ELK, HDFS, HBase, Kubernetes. docker
Job Responsibilities
Mentor the team and guide to resolve the issues
- design
- Scalability testing
- Security
- Microservices
- Java8
- Java Workflow Tooling (JWT)
- Jmeter
- New Relic
- Spring WebFlux
- Kafka
- NoSQL DB
- Spring Boot
Keyskills - Nice to Have
- Couchbase
- Amazon Web Service (AWS)
- Docker
- ELK
- Kubernetes