• Brandmuscle - Oracle Database Developer - PL-SQL Jobs in Bangalore,India

  • Brandmuscle
  • Save Job
  • 4 - 6 Years
  • Posted : above 1 month

Job Description:

About the Company

- Brandmuscle is the largest provider of distributed marketing software and services in North America, offering a comprehensive local marketing automation platform backed by 24/7 on-demand support Brandmuscle helps national and global brands capitalize on opportunities and local market conditions with brand-compliant, customized marketing across all media and formats

- Headquartered in Chicago with offices in Cleveland, Austin, New Jersey and Kansas City and a new office in Bangalore, India, with their India Development Centre Brandmuscle employs more than 800 talented professionals and serves more than 250 of the worlds leading brands

- People who work for Brandmuscle are can-do self-starters who love to be challenged and deliver solutions that exceed our clients expectations Brandmuscle offers a competitive salary, along with personal development opportunities and excellent benefits Brandmuscle is an equal opportunity employer

Position Database Developer

Department Technology Engineering

Location Bangalore, India

Position Responsibilities

- Create a database and normalize the database into small tables by applying rules of Normalization, define check constraints and apply business rules

- Write complex PL-SQL queries

- Create stored procedures, functions and triggers

- ETL from various Transactional data stores to Operational Data Stores

- Verify and execute scripts developed by teams in staging and production environments

- Diagnose and resolve production issues

- Design, test and deploy database schemas

- Database performance tuning including identifying bottlenecks with suitable fixes

- Create & implement custom PL-SQL scripts to automate various database operations including data migration

- Create and maintain database documentation

- Create a performance benchmark conformance report for newly developed and altered functions

- Assist software developers to achieve performance benchmark

- Optimization of existing database queries and procedures

Required Skills

- 5+ years of Oracle 11i Development experience

- Strong experience in Oracle 11i, PL-SQL, TOAD, Oracle Hyperion (SQR), Oracle Forms

- Ability to write sql scripts for data migration from sources like excel, Oracle, MySql, MS Access, MS Sql Server, CSV/text file, etc

- Should be able to troubleshoot PL-SQL queries for performance tuning

- Experience with profiling queries and resolving performance issues

- Experience in DTS, SSIS, SSRS, SSAS, overall MS Sql Server is a huge plus

- Database analysis and designing & database design methodologies

Soft skills

- Good problem-solving abilities

- Good written and verbal communication skills

- Ability to work in a team and individually

Profile Summary:

Employment Type : Full Time
Salary : Not Mentioned
Deadline : 15th Mar 2020

Key Skills:

Company Profile:

Not Mentioned

Would you like to try out these free online tutorials?

People who search this job also searched for the following Keywords

Salary trends based on over 1 crore profiles

View Salaries

All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd DMCA.com Protection Status