Postgres Database Admin

  JOB DESCRIPTION:

1. Good knowledge of shell script.

1. Good knowledge of Linux server security.

  3  Should have exposure to WAF / IpTables

1. Experience of Live Migration tasks like hosting and mailing.

1. Exposure on LVM

1. Exposure on DNS Management and troubleshooting.

1. Configuration skill of SSL certificates on different web/mailing servers.

1. Experience in Load balancing of Apache / Nginx / Tomcat web server.

1. Configuration of web servers Apache / Tomcat / Nginx

1. Configuration & migration of Databases like Mysql, MongoDB, Postgresql

1. Configuring storage ISCSI/ NFS / CIFS

1. Troubleshooting skills on WordPress / Laravel / Magento / Angular / Nodejs

1. Exposure on virtualization technology VMWare / XEN / KVM

1. Experience of mail servers that runs postfix , sendmail , qmail

1. Syslog & Log management

  Desired Candidate Profile :

1. Good knowledge of shell script.

1. Good knowledge of Linux server security.

  3  Should have exposure to WAF / IpTables

1. Experience of Live Migration tasks like hosting and mailing.

1. Exposure on LVM

1. Exposure on DNS Management and troubleshooting.

1. Configuration skill of SSL certificates on different web/mailing servers.

1. Experience in Load balancing of Apache / Nginx / Tomcat web server.

1. Configuration of web servers Apache / Tomcat / Nginx

1. Configuration & migration of Databases like Mysql, MongoDB, Postgresql

1. Configuring storage ISCSI/ NFS / CIFS

1. Troubleshooting skills on WordPress / Laravel / Magento / Angular / Nodejs

1. Exposure on virtualization technology VMWare / XEN / KVM

1. Experience of mail servers that runs postfix , sendmail , qmail

1. Syslog & Log management

  Company Profile:

i2k2 Networks is a trusted name in the IT cloud hosting services industry. We help enterprises with cloud migration, cost optimization, support, and fully managed services which helps them to move faster and scale with lower IT costs. i2k2 Networks offers a complete range of cutting-edge solution that drives the Internet-powered business modules. We excel in:

  - Managed IT Services

  - Dedicated Web Servers Hosting

  - Cloud Solutions

  - Email Solutions

  - Enterprise Services

  - Round the clock Technical Support

   https://www.i2k2.com/">https://www.i2k2.com/

  Nidhi(@)i2k2.com
AM-Talent Acquisition
I2K2 Networks pvt ltd

Roles and Responsibilities 

Build database systems of high availability and quality depending on each end user’s specialised role

Design and implement database in accordance to end users information needs and views

Define users and enable data distribution to the right user, in appropriate format and in a timely manner

Use high-speed transaction recovery techniques and backup data

Minimise database downtime and manage parameters to provide fast query responses

Provide proactive and reactive data management support and training to users

Determine, enforce and document database policies, procedures and standards

Perform tests and evaluations regularly to ensure data security, privacy and integrity

Skills

Proven working experience as a Database Administrator

Hands-on experience with database standards and end user applications

Excellent knowledge of data backup, recovery, security, integrity and SQL

Familiarity with database design, documentation and coding

Previous experience with DBA case tools (frontend/backend) and third party tools

Problem solving skills and ability to think algorithmically

Degree in a computer discipline or relevant certification

• Experience  4 - 8 years
• Key Skills for Software Developer C++, Linux :
• - Looking only for candidates who can join immediately or max 10 day
• - should be able to work independently with no handholding
• - the ability to work with C/C++ code on Windows/Linux platforms
• - Database knowledge of MSSQL, Oracle, MySQL/MariaDB, ideally other ones too: Saphana, Teradata, Postgres.
• - Ability to work on their own fixing defects
• - should be able to understand secure coding practices
• - should have the Ability to work independently and with the team across different time zones

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

 SQL Server DBA duties and responsibilities

• Experience in  both sql server DBA and DBA developer

•             Configure and maintain database servers and processes

•             Monitor system's health and performance

•             Ensure high levels of performance, availability, sustainability and  security

•             Analyze, solve, and correct issues in real time

•             Provide suggestions for solutions

•             Refine and automate regular processes, track issues, and document changes

•             Assist developers with query tuning and schema refinement

•             Perform scheduled maintenance and support release deployment activities

•             Database programming skills(writing and understanding Procedures , scripts..)

Good to have experience to SSIS,SSAS SSRS or any reporting tools.

• 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.