We provide IT Staff Augmentation Services!

Database Developer Resume

0/5 (Submit Your Rating)
Hire Now

SUMMARY

  • Ten (10) years plus of overall experience is Database and BI related projects.
  • Experience working with BI tool Tableau creating visualizations using databases Vertica, MySQL, Postgres DB, Oracle, SQL Server.
  • Experience creating visualizations with dashboards and reports using Tableau
  • Experience working with Amazon Web services (AWS console, S3, RedShift, EMR)
  • Experience using SQL and PL/SQL; experience using Oracle Packaging and Stored Procedure in the Data warehouse project, implemented best practices to achieve the expected results.
  • Well versed with concepts of Hadoop Framework, Bigdata, NoSQL, Mapreduce.
  • Extensively work with PL/SQL, performance tuning of Oracle using Explain plan, SQL hints, Oracle partitioning, indexes and join types.
  • Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, partitioning / sub - partitioning in Oracle, Alter Indexes.
  • Experienced in working with tools like TOAD, SQL Server Management studio and SQL plus for development and customization.
  • Experience with Teradata as the target for the datamarts, worked with BTEQ, FastLoad and MultiLoad, Experience using Teradata SQL Assistance
  • Experience in UNIX and writing Shell scripts for Informatica pre & post session operations and database administration activities.
  • Experience using Github, SVN Tortoise version tool

TECHNICAL SKILLS

Databases: Vertica 6.1, Postgres 8.0, HBase, SQL Server 2012, Oracle 11.2g/9i/8i, DB2 UDB 8.x, Teradata V6

Cloud Services: AWS, S3,EMR, RedShift, AWS-Hadoop, HiveQL

Scripting: HiveQL, Bash, PLSQL, Python, PIG, UNIX Shell scripting, Cron jobs, Java script

Operating Systems: Windows NT/2000/XP/Vista, Mac OS, UNIX/ SUN SOLARIS, Linux SUSE

GUI / ETL Tools: Informatica 8.6.1, Pentaho Kettle, SQL Workbench, PLSQL Developer, SQL Developer, Teradata SQL Assistance, TOAD for DB2/Oracle, Microsoft Office, Project, Visio, Autosys, (SVN Tortoise) Sub Version

Reporting Tools: Tableau, Pentaho Data Analytics, MS Excel, SSRS.

Hire Now
Report an issue

We'd love your feedback!

Privacy Policy
Resume Categories
Client Services
Job Seekers
Visa Sponsorship