Oracle DBA

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.

Senior Oracle Database Administrator

Experience and CTC: 7 to 10 Years (20 LPA- 25 LPA)

Educational Qualification: B.Tech/ MCA

Location: Noida

Notice Period: Immediate to 20 Days

Required Skillsets:

DBA, RAC , RMAN, Perfromance tuning, Backup & recovery, Data guard

Primary Responsibilities

• Oracle database administration and basic understanding of performance Tuning
• Instance tuning, schema management, space management, disaster recovery, data replication, database refresh, and SQL programming and tuning
• Basic Understanding of Oracle RAC
• Basic Understanding of Oracle Data guard
• Understanding of UNIX shell scripting
• Knowledge of upgradation and Migration to higher version
• Should be ready for travel in India and abroad and open for working in any shift
• Good troubleshooting skills required and ability to handle production support
• Sound knowledge of Oracle Database Performance tuning
• Sound knowledge of RMAN backup and recovery procedure
• Ability to work across multiple global sites and working teams is imperative
• Experience with Grid Control, Performance Tuning and Diagnostic packs
• Should have worked on big Oracle development/UAT and production databases
• support across multiple hardware and software platforms including Solaris and AIX, HP-UX, LINUX is desired
• Ability to perform DBA activities that span multiple phases of database application life cycle
• Good understanding of Database performance tuning Oracle 11g & 10g
• Maintain standards and strategies for security, database objects and backup/recovery
• Validate that all physical database designs satisfy business requirements and meet standards to database objects, data integrity, security, performance and recoverability
• Understanding of Operating system like HP-UX, AIX, Solaris, Linux and storage
• Inventory of Best Practices , Automation scripts, SLA and KPI benchmark
• Must be self- motivated and well- organised

• Strong in both Core and Apps side.
• Strong in Apps DBA areas, R12.1, R12.2, Cloning, Patching, Multinode, DMZ, Troubleshooting, Concurrent Manager, Sysadmin Activities 
• Strong in Core BDA areas , Architecture, Installation, Cloning, Patching, Performance Tuning, Standby , DG, RAC, OEM, Upgrade, Migration,Troubleshooting, Replication tool 
• Should be flexible for timng

Job Location: Chennai

Client: A leading Indian IT major hiring for a leading insurance client

Experience: 5-9 Years

Primary skills: Filenet

Secondary Skill: IBM FileNet Capture/Oracle DBA/

Domain Skill: Technical Lead File Net

Detailed Job Description: 

• Overall 3-6 years of experience in IT. 
• Strong understanding of Application admin / Software Development Life Cycle 
• ability to work with a technical team to meet sure deliverables everyday. 
•  Must have 1-2 years of an experience in working in IBM FileNet, IBM Data Capture, Oracle DB 
•  Prefer to have 1-2 years of experience WAS, HA Configuration, Cantera storage & EMC ECS storage. 
• Must stay current on IBM, Windows, WAS… versions. 
• must have experience in managing workflow having API CALLs & Documaker to FileNET 
• having support experience dealing with interfaces from internal and external sources. 
• should be able to do deployment to production 
•  Applying patches to production with the GIT technical team. 
•  Excellent communication skills 
• Willing to work in 24x7 Shifts

smartShift Technologies is looking for a seasoned Database Administrator - Oracle to join our Bangalore team.

 Responsibilities

• Perform regular Database administration tasks.
• Perform HA and DR setup maintenance tasks
• Analyze the performance metrics and provide tuning recommendations
• Analyze the repetitive support requests and provide the automation feasibility
• Handle incidents and problems
• Perform trend analysis of the incidents/events and help in finding the resolution

 Skills & Experience

• Strong experience in Database Administration  in Oracle database 
• Have strong knowledge on Oracle SQL and PL/SQL 
• Expertise in writing and analysing Stored procedure , packages and triggers. 
• Exposure to AWS Cloud RDS is required
• Experience in Database Patching/Upgrade/Migrations
• Experience in managing the HA and DR setups ( Standby, DataGuard)
• Experience in performance tuning ,query optimisation
• Experience with client interaction is preferred
• Exposure to other MySQL database is preferred
• Excellent written and verbal communication skills. 
• Real time experience in DB administration (Installation/Tablespace Management/Object Management
• Expertise in RMAN and other backup(Expdp/Impdp) methodology implementations
• Experience in Database Patching/Upgrade/Migrations
• Knowledge on GoldenGate is desirable
• Knowledge on Oracle 12C/19C new features
• Experience with client interaction is preferred
• Knowledge on RAC & ASM is desirable
• Exposure to AWS Cloud is desirable
• Excellent written and verbal communication skills