Database Administrator
- Design, develop, implement and maintain our core Oracle applications.
- Maintain our SQL / PLSQL processes.
- Ensure DB availability.
- Proactively manage and maintain security standards and controls by creating storage database structures with high-level security features.
- Actively seek to optimise and simplify our architecture.
- Take ownership of performance and capacity monitoring aspects of the DB.
- Execution of data migration jobs and scripts as required.
- Assist the infrastructure team in sizing hardware used for the DB.
- Support and collaborate with product developers.
- Contribute to the creation and maintenance of disaster recovery plans.
- Work closely with the application vendors, co-ordinate and manage the DBA activities.
- Own and follow up with Vendors/Stakeholders & their DBAs when required.
- Create a reliable backup strategy. Ensure database backups are appropriately
- executed and periodic restorations are exercised to ensure backup quality.
- Determine and document DB policies, procedures and standards.
- Performance testing and evaluation to ensure data security, privacy and integrity.
- Identification of bottle necks and deadlock issues.
- Ensure SLA's & operational KPI’s are met, working as necessary with internal and external support functions when major incidents occur.
- Install upgrades and security patches.
- Alter storage structures to meet the evolving needs of the company.
- Set up database user accounts.
- Train users on how to access the information in the database.
- Find and debug malfunctioning programs affecting the database integrity.
- Create autonomous database backups.
- Regularly update the database security protocols.
Desired Skills:
- Ideally Oracle Certified DB Professional (OCP) with more than 5 years’ experience with Oracle, preferably in a lead role.
- Technical degree preferable (B.E. / B. Tech).
- Must experience with an organisation that has 24x7 reliability on its database.
- Must have experience with Oracle Exadata.
- Must Operating system experience in Linux.
- Must hands on knowledge of Shell scripting on Linux Platform
- Must hands on knowledge of Oracle management tools (Data Guard, RMAN).
- Must hands on knowledge of SQL / PLSQL.
- Experience should include DB design (modelling and normalisation), capacity planning, performance tuning, storage management, back-up and recovery, managing schemas, report generation and DB clustering technologies.
- Knowledge of Partitioning.
- Knowledge of architecture design principles.
- Good problem solver, focused and dedicated developer with ability to work on
- your own as well as with a team.
- Hands on experience with DB standards and end user applications-translating
- capacity requirements into infrastructure deployment technology.
- Strong practical experience of ORACLE in a production environment (Ver 19c).
- Must be a self-starter with a strong attention to detail.
About A listed organisation in Telecom & Broadband
Similar jobs
JOB DESCRIPTION AND RESPONSIBILITIES:
- Work as a Member of The File Transfer Engineering team involved with the Configuration, Maintenance, and Support of Sterling File Gateway, Connect Direct (NDM) environment.
- This position will participate in the design & development of technical solutions within company strategic B2B/MFT platform which provide innovative technical improvements, improve quality and operational excellence, lower cost, satisfy regulatory and compliance requirements, mitigate risk, and satisfy business objectives.
QUALIFICATIONS:
- Bachelor’s degree in computer engineering/Science Degree or related field
- 4-5 years’ experience in supporting real time production environments.
- Extensive debugging skills and fixing experience
- General knowledge of industry standards and best practices for supporting middleware technologies
- Knowledge of Ping Access, Ping Federate, LDAP, Active Directory, Connect Direct (NDM) Unix/Windows/Mainframe
- Developing transformation maps and processes for any-to-any data formats and RDBMS queries using IBM Sterling B2B Integrator mapping and business process modeling tools.
- This position requires sophisticated knowledge of B2B/MFT concepts, technologies, best practices, standards, and architectures within the IBM File Gateway suite.
- Minimum five years of technical experience in IBM File Gateway Suite (IBM Sterling B2B Integrator (preferably version 6.x) and IBM Sterling File Gateway, Sterling External Authentication Server, Secure Proxy, IBM Control Center Monitor) including:
- Experience with Installation and configuration of multi-node architecture environments, including upgrades and platform migration.
- Experience in setting up and testing disaster recovery environment to handle failover scenarios.
- Experience with onboarding new partners, transactions and making changes to existing partners to meet internal and external requirements.
- Experience in configuring adapters, service configuration and policies.
- Experience in setting up and configuring industry-standard communication protocols such as SFTP, FTPs, FTP, HTTP, HTTP, Connect: Direct, WebSphere MQ
- Experience with security configurations SSL certificates, SSH keys, PGP/GPG
- Experience with IBM File Gateway Suite maintenance and administration
- Experience with external authentication integration
- Experience with Java extensibility
- Development of custom protocols, custom file layers and custom consumer identification
- Must possess strong analytical, problem-solving, and root cause analysis skills.
- Hands-on experience in Production Support, resolving critical incidents using the IBM File Gateway Suite
- Knowledge of SQL queries, database schemas and related concepts using Oracle
- Knowledge of IBM Sterling File Gateway APIs.
- Should have Excellent communication and customer service skills.
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-EMPS0120PS
- Primary Skills:
- Hands-on experience in Python, Shell Scripting, and SQL Queries
- Good experience in Linux.
- Hands-on experience in Python, Shell Scripting, and SQL Queries.
4.Years of Experience: 2-4 Years
- Location:(Hybrid)-Bangalore
- Position-2
- Budget- 2-3 years (upto 8.5 LPA) and 3-4 (upto 11 LPA)
- NP- Immediate-15 Days
What will you do?
- Oversees testing, deployment & maintenance of the Voice infrastructure.
- Performing a variety of tasks associated with user provisioning and call routing within the assigned platform
- Build loaders for internal systems ensuring tasks are completed accurately and in a timely manner
- Participate in meetings with clients and internal departments to understand the requirements of call routing
- Document and design call flow diagrams to ensure that all call variables have been accounted for in preparing a routing plan
- Support the clients solution by correcting any issues with call routing or provisioning during the initial implementation phase, constantly communicating status of any issues with client
- Complete testing to ensure that call flow is operating properly
- Monitors and ensures compliance to standards, policies, and procedures
What are we looking for?
- 0.6~2 year’s implementation experience in Asterisk PBX, IP Telephony, SIP.
- Able to thrive in a demanding and team-oriented environment
- Basic and strong knowledge of the Linux operating system.
- Knowledge of bash and perl shell scripting is an added advantage.
- RHCE Certification is an added advantage.
About Us
Rezo.ai is an AI-Powered Contact Centre that enables enterprises to enhance customer experience and boost revenue by automating and analyzing customer agent interactions across multiple channels including voice, email, chat/WhatsApp, and social, at the required scale, whilst training agents with minimal costs.
How do we do it
Rezo’s AI-Powered contact center leverages ground-breaking technologies in AI, ML, ASR, NLP, RPA, and predictive intelligence to transform customer experience and reduce costs by automating, analyzing social media, whilst coaching them.
Overview
Database administrator (DBA) will be the performance, integrity and security of a database. You'll be involved in the planning and development of the database, as well as in troubleshooting any issues on behalf of the users.
Job Responsibilities:
- Monitoring system performance and identifying problems that arise.
- Install and maintain the performance of database servers.
- Develop processes for optimizing database security.
- Set and maintain database standards.
- Install, tune, implement and upgrade DBMS installations
- Write and deploy MYSQL patches
- Upgrade and improve application schema and data upgrades
- Manage database access.
- Performance tuning of database systems.
- Install, upgrade, and manage database applications.
- Diagnose and troubleshoot database errors.
- Recommend and implement emerging database technologies.
- Create and manage database reports, visualizations, and dashboards.
- Create automation for repeating database tasks.
- Be available for on-call support as needed.
Skills Required:
- A minimum of 3 years' experience as a database administrator.
- Strong and Proficiency in data manipulation languages, including MS SQL,
- Advanced knowledge of database security, backup and recovery, and performance monitoring standards
- Understanding of relational and dimensional data modelling
- Strong mathematical and statistical knowledge
- Excellent written and verbal communication skills
- Impeccable attention to detail
Experience Install, Configure, Maintain & Lifecycle Management of Linux Systems | ||||||||||||||
Experience in Building & Maintaining File Systems, Storage Volumes including LVM concepts, LUNs, Swap etc | ||||||||||||||
Expert hands on Knownledge on Bash/Shell or Python scripting | ||||||||||||||
Build and maintain container orchestration platform (Docker) using Kubernetes, Openshift, Micro k8s or similar | ||||||||||||||
Develop and maintain automated processes, tools, and documentation in support of Docker and Kubernetes container orchestration platform | ||||||||||||||
Ability to perform automated infrastructure code test, integration, deployment, and assurance using DevOps and CI/CD methodologies for e.g. Jenkins, Gitlab is a plus | ||||||||||||||
Automation/Configuration Management with Ansible or Puppet and scripting | ||||||||||||||
Strong background in linux networking ( ip, iptables, ipsec ) | ||||||||||||||
Strong knowledge on configuration of diverse subsystems (systemd, printers, graphic adapters, networking, SELinux, firewalls…etc) | ||||||||||||||
Strong knowledge on Storage Concepts - NAS, NFS, SAN, RAID, ZFS | ||||||||||||||
Knowledge on creation and maintenance of repositories (intranet and internet) | ||||||||||||||
Hands on with Installation procedures: yum, kickstart, anaconda, plymouth | ||||||||||||||
UEFI/ legacy BIOS: How to boot, how to make a medium bootable, handling of keys etc. | ||||||||||||||
Strong Knowledge of wide variety of open source technologies/tools and cloud services | ||||||||||||||
Strong Knowledge of best practices and IT operations in an always-up, always-available service | ||||||||||||||
Experience in Server Virtualisation Technology mainly in VMware vSphere, vCenter, vSAN etc, Proxmox is a plus | ||||||||||||||
Experience in Setting Up DNS Bind and LDAP Directory Services is a plus | ||||||||||||||
Experience in using Atlassian toolchains – Jira & Confluence is a plus | ||||||||||||||
Knowledge on Ceph Storage technology is a plus Roles & Responsibilities
|
Designation:Linux/System/Support Engineer (L2) Experience : 2-5 Yrs
Notice period : immediate to 30 Days
- Server Monitoring
- Deployments
- Collecting information about the reported issues
- Ensuring whether all the information has been logged in the ticketing system or not
- Must be able to follow and execute instructions specified in user guides, emails to run, monitor and trouble shoot
- Must be able and willing to document activities, procedures
- Must have trouble shooting skills and have knowledge on Antivirus, Firewall, Gateway
- Should be ready to work for extended shifts, if
- Good customer management skills bundled with good communication skills
- Databases: concepts and ability to use DB tools such as psql,
- Good Understanding of Oracle, weblogic, Linux/ Unix Terminology and able to execute commands
- Internet Technologies : Tomcat/ apache concepts, basic html, etc
- Able to use MS- Excel, Power Point