Database Administrator (DBA)
EDUCATION,EXPERIENCE REQUIRED:
BE/MCA/ B.TECH / BCA
Exp - Min 4 yrs
CTC – Upto 12 LPA
Job Description:
- Installing, Configuring, Managing, Monitoring and troubleshooting SQL Server 2005/2008/2008R2/2012/2014/2016
- Database administration activities like Installation, Configuration, Backup & Recovery, and Database Security.
- Providing availability solutions like Mirroring, Log Shipping, Replication and Always on.
- Database Up gradation and Migration
- Ensure performance monitoring, backup, restore, and security recovery solutions.
- Troubleshooting expertise in SQL server issues under production environment.
- Handling the entire production servers with skills and understanding client's requirement Experience in Database administration activities for DB Security (creating users, roles, and assigning permission to them).
- Automating process by creating jobs, and error reporting using Alerts by SQL Server Agent.
- Backup and Recovery strategy, Database Refreshes.
- Creation and maintenance of Databases, creating Roles and managing user permissions.
- Setting up, trouble shooting and maintenance of production server databases.
- Providing Production support for Database and Applications.
- SQL Server store procedure, functions, View, Index and trigger development.
Job requirement:
- Deep understanding of OS and its management including kernel space management
- Experience with Linux servers in virtualized environments
- Experience installing, configuring, and maintaining services such as Bind, Apache, MySQL, Nginx, etc.
- Experience in Monitoring tools like Nagios.
- Familiarity with load balancing, firewalls, etc.
- Proficient with network tools such as iptables, Linux IPVS, HA Proxy, etc.
- Experience with virtualization technologies, such as Xen KVM and VMware.
- Ability to build and monitor services on production servers
About BANKIT
Similar jobs
Sr IT Administrator
Experience - 4 - 5 yrs
Location- Hyderabad - Hybrid
Mandatory skills : AWS , VMware,trouble shooting, SQL , Problem solving
Responsibilities:
Diagnose and troubleshoot technical issues - Windows
Upgrade the network infrastructure - Windows
Install servers (VMWare and Dell Servers),devices and firewalls(Sonicwall)
Monitor the performance of servers, software and hardware
Ensure the smooth deployment of new applications and SQL DB changes(Manual,Script and CICD) on Windows Environment
Update technical documentation.
Requirements and skills:
Solid understanding of LAN/WAN and Hybrid networks
Good problem-solving and communication skills
Good experience on AD,DNS,MS SQL Server,IIS, VMware and AWS
Hand on experience on Migation of servers(File, AD and Application servers)
Good experience on AWS and VMWare ESXi networks (Miagtion, upgade, and troubleshooting)
Knowledge of security techniques.
Should have worked in complex projects
All the experience is expected in Windows Domain only. Not Linux or Unix.
Working knowledge in AWS is also mandatory.
We need people with good exposure and good attitude and willingness to work in a team.
Enterprise Minds, with core focus on engineering products, automation and intelligence, partners customers on the trajectory towards increasing outcomes, relevance, and growth.
Harnessing the power of Data and the forces that define AI, Machine Learning and Data Science, we believe in institutionalizing go-to-market models and not just explore possibilities.
We believe in a customer-centric ethic without and people-centric paradigm within. With a strong sense of community, ownership, and collaboration our people work in a spirit of co-creation, co-innovation and co-development to engineer next-generation software products with the help of accelerators.
Through Communities we connect and attract talent that shares skills and expertise. Through Innovation Labs and global design studios we deliver creative solutions.
We create vertical isolated pods which has narrow but deep focus. We also create horizontal pods to collaborate and deliver sustainable outcomes.
We follow Agile methodologies to fail fast and deliver scalable and modular solutions. We constantly self-asses and realign to work with each customer in the most impactful manner.
Pre-requisites for the Role
1.Job ID-EMSP0120PS
- Primary skill:
- Splunk Development and Administration
- Secondary skill:
Python, Splunk DB connect, Visual Studio (C#), BitBucket, Kafka, Devops tools.
- 4. Years of Experience: 5-8 Years
- Location:(Hybrid Model)-Pune
- Position-1
- Budget- - 5-6 years (Max up to 17 LPA) and 6-8 Years (Max up to 22 LPA)
- NP- Immediate
Primary Role & Responsibility:
As a software engineer, your daily work involves technically challenging applications and projects where your code makes a direct contribution to the further development and upkeep of our software suite and to its application in projects.
You should be able to create Splunk dashboards, apps and should have good understanding of source interfaces for Splunk.
You should have idea of onboarding of data from different sources like JSON, XML, syslog, errorlog files.
As a software engineer, we expect much more from you than just the ability to design and develop good software. We find it important that you possess an inherent drive to get the best out of yourself every day, that you are inquisitive and that you are not intimidated by situations which require you to branch off from the beaten track. You work together with colleagues in a SCRUM team. In addition, you have regular contact with other software teams, software architects, testers and end users. Good communication skills are therefore extremely important, as well as the ability to think pro-actively and suggest possible improvements. This gives you every opportunity to contribute your personal input and grow and develop within the department.
The often complex functionality of the software includes business logic, controls for logistical transport, communication with external computer systems, reporting, data analysis and simulation. This functionality is spread across various components. You design, program and test the software based on a design concept and a set of requirements. In some cases, you will have to personally formulate these requirements together with the (end) users and / or internal stakeholders. Learn more about the Software modular stack
Desired Profile & Experience: Knowledge of Kafka and experience with Java
- Splunk Architecture, on-premise and cloud based deployment.
- IoT edge.
- Analytical skills and capabilities to understand how raw (unstructured) data needs to be transformed into processed information.
About Us
We are an AI-Powered CX Cloud that enables enterprises to transform customer experience and boost revenue with our APIs by automating and analyzing customer interactions at scale. We assist across multiple voices and non-voice channels in 30+ languages whilst coaching and training agents with minimal costs.
The problem we are solving
In comparison to worldwide norms, customer support in traditional contact centers is quite appalling, due to a high number of queries, insufficient capacity of agents and inane customer support systems, businesses struggle with a multi-fold rise in customer discontent and bounce rate, resulting in connectivity failure points between them and customers.
To address this issue, IITian couple Manish and Rashi Gupta founded Rezo's AI-Powered CX Cloud for Enterprises 2018 to help businesses avoid customer churn and boost revenue without incurring financial costs by
providing 24x7 real-time responses to customer inquiries with minimal human interaction.
Roles and Responsibilities:-
- To Maintain the required uptime for Azure Cloud and IT Infrastructure.
- To provide the earliest resolution of the reported issues, which may include but are not limited to cloud & end-user related issues.
- Configuring and managing the alerts through Nagios, which may include but is not limited to scripting knowledge.
- Linux and Windows Server administration.
- Managing Firewalls and Domain Controllers.
Requirements
- Having relevant experience of 3+ yrs.
- Sound knowledge of Linux & Windows System administration
- Good Hands-on experience on Azure/AWS ( Willing to work on Azure only)
- Must be an expert in at least one of OpenStack, Cloudify, SaltStack, Rundeck, Ansible
- Good knowledge of networking, firewall & domain controller
- Basic knowledge of DevOps/Scripting
- Should be willing to work in rotational day shifts and WFO
- Flexibility to be able to work in a 24/7/7 environment
Life at Rezo.AI
- We take transparency very seriously. Along with a full view of team goals, get a top-level
- View across the board with our regular town hall meetings.
- A highly inclusive work culture that promotes a relaxed, creative, and productive
- environment.
- Practice autonomy, open communication, and growth opportunities, while maintaining a
- perfect work-life balance.
- Go on company-sponsored offsites, and blow off steam with your work buddies.
Perks & Benefits
Learning is a way of life. Unlock your full potential backed with cutting-edge tools and mentor-ship
Get the best in class medical insurance, programs for taking care of your mental health, and a Contemporary Leave Policy (beyond sick leaves)
Why Us?
We are a fast-paced start-up with some of the best talents from diverse backgrounds. Working together to solve customer service problems. We believe a diverse workforce is a powerful multiplier of innovation and growth, which is key to providing our clients with the best possible service and our employees with the best possible career. Diversity makes us smarter, more competitive, and more innovative.
Explore more here
http://www.rezo.ai/" target="_blank">www.rezo.ai
ABOUT US. (https://www.ashnik.com/" target="_blank">https://www.ashnik.com/)
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: 2 yrs plus
Technical Skills Required – Mandatory:
- Cloud Technologies – AWS OR Bigdata (Basic Level)
- Python (Highly Experience Level)
- Databases – SQL (Highly Experience Level)
- Operating Systems – Unix (Highly Experience Level)
Strong knowledge in writing complex SQL queries and Knowledge of Performance Tuning
Excellent working knowledge of production support role and Strong debug/troubleshooting skills
Provide 24×7 operational support to all production practices on holidays and weekends.
Hands-on experience in production support for data engineering processes, root cause analysis, and identifying opportunities to improve existing processes.
Roles and Responsibilities:
Set up and optimize the existing integration, monitoring and alerting processes.
Working knowledge of ETL/ELT in Hadoop, Spark and MPP databases is required.
Effectively collaborate with the partners (SMEs, DBA, and Business users) to ensure the reliability of the Data systems.
Taking ownership of customer issues reported and seeing problems through to
resolution
Understand, interpret, reproduce, and diagnose issues reported by the customers.
Researching, troubleshooting and identifying solutions to resolve product issues
Should be able to handle voice calls, emails and online web sessions with the
customer as part of technical troubleshooting
Should exhibit patience and empathy while working with customer with an aim to
drive positive customer experience
Following standard procedures for proper escalation of unresolved issues to the
appropriate internal teams
Following standard procedures for submitting tickets to the engineering team for
further investigation of unresolved issues
Contributing actively towards knowledge base articles
Adherence to strict SLA’s
Ready to work in early morning, general and afternoon shifts, including weekends, on
rotation basis
Should demonstrate an aptitude and appetite for learning newer technologies while
expanding on the core knowledge
Primary skills:
1-3;3-8 years of relevant experience.
Strong technical knowledge on:
Cloud Technologies – AWS, Azure etc.
Databases – SQL, Oracle, MySQL etc.
Operating Systems – Linux, Windows etc.
Networking – Basic networking concepts and troubleshooting
Programming knowledge – Java, Python (Desirable, not a must has) o Prior experience
with REST and SOAP calls.
Excellent communication skills – English written and verbal
HTTP technology and principles, including REST and SOAP principles (Required)
JSON & XML Data formats (required)
Javascript Regular Expression (Good to have)
Good understanding of networking protocols and applications (TCP/IP, proxies, load
balancing, firewalls, etc.) (Required)
Working knowledge of database technologies and SQL (Required)
In-depth familiarity of Linux (Required) (advanced user; sysadmin experience a bonus,
but not required)
Strong analytical and logical reasoning for technical troubleshooting
Ability to collaborate with cross-functional teams – Dev, QA, Infrastructure teams etc.
Should be a team player who keeps team’s success before individual achievements
Knowledge on data integration (Informatica/ Mulesoft))
- 4-15 year experience in Application Support
- Must have good knowledge in Java/J2EE, Microservices, PL/SQL, Unix
- Good to have knowledge in Agile, JIRA, Splunk, Service Now
- Good understanding and hands-on experience in Incident, Problem and Change Management
- Provide technical leadership to the team & contribute in the skill development within team
Interact with internal teams and client stakeholders to trouble shoot the tickets/incident and manage other support activities - Good communications skills are necessary, must be team player and inquisitive.
- Strong customer service and support focus with a desire to deliver a high-quality service
- Ability to multi-task, work under pressure and to tight deadlines
- Flexible in working outside of office business hours at short notice (as required)
- Should be able to examine the system and identify the areas for Service Improvements & Value adds.
- 2 years of hands-on Linux System Administration experience (RHEL / CentOS).
- 2 years experience in AWS Cloud administration
- 2 years relevant work experience in a high-volume and/or critical production service environment.
- Minimum 1+ years experience with Windows Server operating system administration
- Minimum 2 years experience with Cloud Service Providers (AWS)
- Minimum 2 years experience in enterprise environments
- Bachelor degree or equivalent experience preferred
- Any Amazon Web Services (AWS) certification preferred.
- Understanding of supporting Enterprise applications such as SAP systems and databases on AWS EC2 like (HANA, Db2, Oracle) with cluster management, HA management, etc.
- Implement security policies and controls (e.g. CIS, malware, anti-virus, secret management) using AWS services
- Strong ability to document standards, methods and produce drawings of systems and applications.
- Strong Scripting skills with any scripting languages (Python (Lambda), Bash Shell)
- Administration of Linux / Windows servers
- Deep understanding of AWS of IT Infra Architecture, Automations in deployments, SAP Architecture, Integration of On-Prem, Hybrid Infra, etc.
- Participate in Design Discussion, a new way of working (Automations, operational management), etc.
- Must have knowledge of AWS, Azure, Git
2. Perform data migration and conversion activities.
3. Develop and integrate software applications using suitable development
methodologies and standards, applying standard architectural patterns, taking
into account critical performance characteristics and security measures.
4. Collaborate with Business Analysts, Architects and Senior Developers to
establish the physical application framework (e.g. libraries, modules, execution
environments).
5. Perform end to end automation of ETL process for various datasets that are
being ingested into the big data platform.