Dbeaver Vertica

admin



DBeaver - Windows 8 Downloads - Free Windows8 Download. You do not 'create variables' in Vertica the same way you do not 'create variables' in SQL Server. What you're trying to convert is a T-SQL script. You can do the same in Vertica by creating Perl or Python or Java. Scripts running outside the database or writing a user defined function in C or R or Java running inside Vertica. DBeaver 7.2.4 download - Windows 7 - Free Universal Database Manager and SQL Client.

SUMMARY:

  • Highly motivated software professional with over 11 years of experience in providing solutions and delivering projects with consistency and quality
  • Experienced in a wide range of responsibilities including prototyping, planning, managing and delivering solutions
  • Worked extensively on a variety of languages and tools, delivering projects ranging from OLTP, data warehousing, master data management, system mergers and data migration. Enjoy working on challenging projects and newer technology
  • Hands - on coach, guide and mentor who takes pride in nurturing young talent and turning them into experienced professionals in their own right
  • Like to be the driving force in project delivery
  • Work experience evenly divided between client locations onshore and delivery locations in India
  • Handled difficult projects, critical and unprecedented situations and resoled deadlocks through effective communication

AREAS OF EXPERTISE:

  • Software development and delivery
  • Database Development and design
  • System and Query Performance Tuning
  • Proof of Concept
  • Writing technical design specifications

TECHNICAL PROFICIENCIES:

Languages: Shell Scripting, Oracle SQL, Oracle PL/SQL, Vertica VSQL

Platform: UNIX (including HP-UX, Solaris), Linux (Red Hat), MS-Windows (NT, 95, 98, 2000, XP, Vista, 7, 8, 8.1, 10)

Databases: Oracle, Teradata, Vertica, MySQL, Sybase, SQL Server, Ingres, MS-Access

Tools: CronTab, Cronjob, CVS, FTP, SQL-developer, Toad, DBeaver

ETL Tools: Informatica

PROFESSIONAL EXPERIENCE:

Vertica

Confidential

Vertica Specialist Developer

Environment:Technology: Vertica, Informatica, Teradata

Database : Vertica 6.9/7.0/7.1, Teradata, Oracle

O/s: Windows Vista, Unix

Responsibilities:

  • Create database design for different feeds to be accommodated in Vertica
  • Convert Load scripts from Teradata to Vertica
  • Create schedulers to accommodate load scripts
  • Create mappings to accommodate transaction data for newly created components
  • Create scripts to load data into Teradata and Oracle tables
  • Analyze the current DB structure in Teradata for a possible Vertica conversion
  • Create Projections for tuning statistics
  • Create scripts in Teradata and Vertica for data movement for various streams to various applications
  • Train offshore team on Vertica and resolve their issues related to Vertica
  • Performance tuning for the scripts and queries migrated from Teradata to Vertica

Confidential, Bellerica, MA

Project Lead (Vertica Sr.Database Developer)

Environment:

Dbeaver vertical select

Technology: (Agile)Vertica

Database : Vertica 6.9/7.0/7.1

O/s: Windows Vista, Unix

Responsibilities:

  • Create database design for different feeds
  • Create data aging module for different feeds
  • Validate and deploy design
  • Create and Update Vertica bible for different solution applied in analytics
  • Validate various open source technologies for analytics solution
  • Create and present metrics to various stakeholders
  • Create Analytics modules for inter organization use
  • Monitor resources through their development process
  • Take evaluations from clients for projects and individual resources
  • Train resources in analytics, Vertica and Oracle
  • Co-ordinate between different teams in different time zones
  • Create estimations for New Developments and Implementations.
  • Create data Aging structure for different Feeds
  • Monitor and Design the Vertica Version migration
  • Create and help Vertica DB bible

Confidential, Waltham, MA

Project Lead (PL/SQL and Vertica Sr.Database Developer)

Environment:

Technology: (Agile)Oracle Database and Data warehousing, Vertica

Database : Oracle 10g and 11g, Vertica

O/s: Windows Vista, Unix

Responsibilities:

  • Create engine process flow design and logical flow design
  • Create POC for the same design and represent it to client
  • Build engine and perform unit testing
  • Convert all the front schemas to be Vertica Compatible
  • Convert Oracle application queries to be Vertica compatible queries
  • Decompose the stored procedures in to functional and logical blocks
  • Depict the functionality of the stored procedures to be Vertica compatible
  • Gather the knowledge and build understanding by KT given on requirement document (K245) by BSA’s.
  • Get and deliver the understanding to the dev team including DB, ADF and SOA teams
  • Data Modeling based on the requirement
  • Creating LDM and PDM based on the module design requirement
  • Creating DDL’s, DML’s, Sequences, Grants, Synonyms and other DB objects in order to create the design structure.
  • Creating Views, Procedures, Functions, Cursors, Triggers to create the workflow
  • Get the views design and procedure/function calls to ADF and SOA teams
  • Defects closer assigned to me or my team.
  • Perform Performance Tuning on the objects and process flow.
  • Perform query tuning based on the explain plan.
  • Read Explain plan and work on the development/Modification approaches
  • Close/ resolve ad-hoc requests.
  • Maintain and modify functions, procedures and packages as per requirement.
  • SRS understanding from client and explain it further to the team.
  • Develop test case scenarios on the basis of SRS and design document.
  • Develop prototype SQL code for the fellow developers.
  • Perform sync up between developer and BI testing teams.
  • Explain test case scenarios to client.
  • Explain test case development to the client.
  • Involved in upgrade requirement analysis for all 10 applications.
  • Performed application development as per requirement for different applications.
  • Created various triggers, procedures, functions and cursors as per job requirement.
  • Performed Installation, configuration and troubleshooting for windows servers, Linux servers.
  • Involved in root cause analysis and failure analysis for all the escalations.
  • Involved in application installation.
  • Performed Hot Fixes and Soft fixes.
  • Created various shell scripts according to the application and user requirement.
  • Performed the required upgrades on applications.
  • Wrote File Transmission FTP scripts.
  • Upgrading OS Installation and patches.
  • Performed Cronjob Configuration.
  • Coordinated during outage between users and different teams.
  • Delivered various presentations to the client.
  • Coordinated team meeting for Syntel and guitar center.
  • Involved in Change management board meeting for guitar center.

Confidential, Columbus, OH

Lead PI- Developer

Environment:

Dbeaver Vertica

Dbeaver Vertically

Technology: Oracle, Korn Shell, Perl, CGI

Database :Oracle 11g, Oracle 10g,

Tools: AIX 5.3, Solaris 9,Apex web server, SQL/SQL Plus, TOAD, Putty, F-secure Shell.

Responsibilities:

  • Involved in requirement analysis, design, development testing and deployment.
  • Used Oracle’s Virtual Private Database (VPD) capability to implement additional security layer on data elements.
  • Wrote complex SQL queries for data analysis.
  • Involved in creating an Application Programming Interface (API) to automate the process of enforcing data access controls.
  • Wrote SHELL scripts to automate the SQL batches.
  • Created many stored procedures and triggers to load data into tables.
  • Perform the performance tuning based on the requirement and performance.
  • Created QA documentation for testing and deployment.
  • Provided application support by helping users understand the new process of requesting access to data based on their business role.
  • Automated field search using complex sql scripts.
  • Involved in KEON server testing to initiate tech refresh.
  • Involved in bulk data migration using data pump.
  • Identified Sell and Sql scripts involved in batch process required remediation.
  • Remediate tested and deployed numerous Shell and sql scripts in various schemas.
  • User ftp, sftp, scp for bulk file transfer.
  • Validated and converted ftp mirror logic for test servers.
  • Converted and tested DBlinks for new environment.
  • Configured UNIX and Database accounts for various users.
  • Fixed numerous objects (tables, views, procedures, functions & triggers) for various user accounts.
  • Wrote numerous installation scripts to deploy process on production.
  • Involved in deciding system requirement.
  • Involved in WaMu data merger project’s system analysis and requirement, new database building.
  • Solved priority one tickets for WaMu merger.
  • Helped business users by step by step documentation and on call .
  • Tested load scripts using test data files and validated these changes.
  • Altered, control files, tables and views based on the needs of the business.
  • Wrote and debugged shell scripts for WaMu changes.
  • Archived WAMU legacy schemas using oracle regular import and data pump.

Confidential

Project Lead/DBA/Unix Admin

Environment:

Dbeaver vertica

Technology: Oracle, UINX

Vertica

Database :Oracle 9i

Tools: SQL/SQL-Plus, Humming bird secure Shell.

Dbeaver Vertical Tabs

O/s: Solaris 9, Windows XP, Mac-OS X

Responsibilities:

Dbeaver Vertica Driver

  • Oracle DBA, Unix Administrator
  • Managed database for AcademicSuccessCenter, SJSU subscribers (faculty and students)
  • Manage UNIX accounts for over 10000 subscribers.
  • University Computer Lab Management and maintenance,