Roles and Responsibilities
● Creating and maintaining database standards and policies
● Supporting database design, creation, and testing activities
● Managing the database availability and performance, including incident and problem
management
● Administering database objects to achieve optimum utilization
● Defining and implementing event triggers that will alert on potential database
performance or integrity issues
● Performing database housekeeping, such as tuning, indexing, etc.
● Monitoring usage, transaction volumes, response times, concurrency levels, etc.
● Identifying reporting, and managing database security issues, audit trails, and forensics
● Designing database backup, archiving, and storage strategy
Prerequisites
● Should have 2-4 years of experience
● Have an IT, computer science, or engineering educational background
● Understand coding and service management (to some degree)
● Should have worked on MySQL, Oracle, MongoDB with large size of DBs 1TB+
● Experience with replication configuration
About Zopper
Similar jobs
Greetings!!
We are looking for an Oracle HCM Technical consultant for one of our premium clients for their Chennai and Bengaluru locations.
Requirements:
- Advise client on options, risks, and any impacts on other processes or systems.
- Assist the Oracle HCM Functional Team in making the changes to make sure the Application works in the Fusion Environment.
- Experience in HDL, Fast formulas, Extracts and BI Reports.
- Experience of Migrating data for Projects from legacy systems of the clients.
- Assist client in preparing validation scripts, testing scenarios and develop test scripts for Fusion HCM projects.
- Hands-on experience with Fusion Release 13.
- Expertise in RTF, Excel, E-Text Template.
- Strong knowledge required in SQL PL/SQL.
- Good hands on BIP & OTBI, Dashboard Report.
- Experience on Oracle Report Tool, Extract, OIC, Personalization & Customization.
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
- Installing and maintaining the Oracle database software.
- Creating storage database structures with high-level security features.
- Altering storage structures to meet the evolving needs of the company.
- Setting up database user accounts.
- Training users on how to access the information in the database.
- Finding and debugging malfunctioning programs affecting the database integrity.
- Creating autonomous database backups.
- Regularly updating the database security protocols.
Please find the Job Description for C/C++.
Mandatory Skills
-Must have experience and Good understanding about pointers & memory in C/C++
-Must have experience in Unix/Linux IPC (semaphore, shared memory, socket, multi thread)
-Must have Debug skills : gdb, coredump analysis, network packet analysis
-Must have experience in Source code syntax parser (Preferably lex, yacc, bison, etc.)
-Must have worked on build tools : Makefiles, make, etc.
-Database : Preferably Oracle Good at SQL and stored procedures
Optional Skills
-Telegram development using C/C++
-Finance/Industry domain knowledge
-Japanese speaking skills
- Responsibilities:Troubleshoot and report RCA, propose solutions(how to fix)
- Debug identified problems and provide fixes swiftly
- Ability to write clear and concise documentation
- To understand and maintain legacy codebase
- Individual contributor, but also works closely with junior developers
- Review source code developed by peers
- Proactive to suggest and implement improvements on current products
- Design and develop new features based on requirement document
Location-Bangalore
Please share your updated resume to proceed further.
Thanks & Regards
Shruti(Assistant Executive-HR)
Nichi-In Software Solution Pvt Ltd
URL:- www.nichi.com
• Bachelor’s degree with a background in math will be a PLUS.
• Must have 5+ years system administration experience with a mix of Linux and Window systems in a medium
to large business environment.
• Must have command level fluency and shell scripting experience in a mix of Linux and Windows
environments.
• Must have experience in one or more public cloud environment: AWS / Azure / GCP
• Must have experience in using automation tools (Cloud Formation, Terraform) to build cloud infrastructure.
• Must have experience in basic MySQL administration – configuration, backups, replication.
• Must have experience in Apache and other webserver administration on Linux platforms.
• Must have exposure to VMware or other enterprise virtualization software.
• Certification with Red Hat or any other Linux variant will be a BIG PLUS.
• Fluent in the use of Microsoft Office Applications (Outlook / Word / Excel).
• Possess a strong aptitude towards automating and timely completion of standard/routine tasks.
• Must be able to work in a complex, dynamic team environment and possess good organizational skills.
• Ability to communicate with individuals and in an articulate, professional manner.
• Experience with automation and configuration control systems like Ansible, Puppet or Chef.
• Ability to organize, prioritize, and handle multiple assignments on a daily basis.
• Previous experience with leading technical projects desired.
• Track record of mentoring junior team members.
• 6 - 8 years of software development / consulting / support experience is required.
• Experience with one of these databases - Neo4j, Oracle, MS SQL Server, PostgreSQL – is required.
• Strong understanding of relational and / or graph database concepts is required.
• Experience working with public cloud technologies specifically AWS, Azure & GCP.
• Experience working with RedHat / CentOS / Amazon Linux operating systems will be a plus.
• Competence in at least one of the following languages (in no particular order): Java, C++, C#, Python, Scala
• Experience with ETL tools ingesting / cleansing / transforming data from multiple data sources will be a plus.
• Knowledge / Hands on experience in Kettle will be a plus.
• Experience with Customer Support for databases primarily on Linux OS.
• Familiarity with enterprise software architectures and application development methodologies is required.
• Familiarity with Linux diagnostics and tuning; Windows tuning knowledge will be a plus.
• Performance Tuning and Troubleshooting skills are required.
JD-
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