The role involves architecting, designing and developing SQL solutions to support the business needs using Oracle and PostgreSQL. Optimizing and tuning existing programs and developing new routines will be integral part of the profile.
Key Responsibility Areas:
- Architect, Design and Develop solutions to support business requirements using SQL on Oracle.
- Must be well versed in PL/SQL & PostgreSQL/Oracle to interact with stored data
- Work closely with programming teams to deliver high quality software
- Optimize queries, business logic, process, etc to improve efficiency and accuracy of the programs
- Analyze application problems and provide solutions
- Help in developing a test plan, test data and testing of the software
- Provide support in different phases of software development
- Experience in cluster set up and replication set up.
- Good knowledge on database backup and recovery. Connectivity and security. Database creation and role assignment using DataStax/ Cassandra enterprise version.
- Knowledge of scripting languages (such and Unix, shell, PHP).
1+ years of experience in database development using SQL/ NoSQL
Must have worked using NoSQL preferably using Cassandra
Working knowledge of PostgreSQL/Oracle will be preferred
SQL knowledge and strong knowledge of Oracle, command line utility
Must have good command on PL/SQL and exposure to PostgreSQL/Oracle environment
Must know how to invoke SQL scripts/commands using shell script in Linux environment
Analyze application problems, recommend and develop solution
Strong knowledge on query optimization
Experience of designing/architecting database solutions
Ability to work well under pressure
Strong experience in data stax/ Casandra installation and configuration
Experience in database deployment, performance and / troubleshooting issues.
Deep understanding of cluster management like add/bootstrap nodes, remove/replace node to clusters.
End to end performance tuning / troubleshoot performing tuning of DataStax/Cassandra clusters against very large data sets.
Salary: Not Disclosed by Recruiter
Industry:Internet / Ecommerce
Functional Area:IT Software - Application Programming, Maintenance
Desired Candidate Profile
UG:B.Tech/B.E. - Any Specialization
PG:M.Tech - Any Specialization
IndiaMART InterMESH Ltd
Contact Company:IndiaMART InterMESH Ltd