We provide IT Staff Augmentation Services!

Sr. Database Consultant Resume

San Mateo, CA

SUMMARY:

  • A Database Consultant with strong knowledge in Oracle 11g,10g, 9i, 8i, 8 and Oracle 7 on Designing, Developing/Coding, Implementing, Migrating/Loading/Converting Data, Optimizing, Tuning and Maintenance of databases up to Peta bytes in size.Over 15 years of result driven experience in Database Technology, Administration, Programming and Training.
  • Served my services as Database Architect (Jr), Database Specialist, Solution Architect, Database Lead, Oracle DBA, Web/PL - SQL Developer, Corporate Trainer, Sr Database Consultant.
  • Expert in Developing, Optimizing and Tuning Oracle SQL statements, PL-SQL Procedures/Functions/Triggers/Packages/PIPELINED Tables/Bulk Collect or Load Statements/Dynamic Statements/Simple, Ref & Traditional Cursors/Exceptions, PL-SQL optimizer, Conditional compilation, Compile time Warnings, Error/Inquiry Directives, Err Tables/Exception packages and Oracle Instances/ Databases/Servers.
  • Hands on experience in designing & developing highly active transaction applications
  • Expert in designing OLAP and OLTP Data Models.
  • Strong in developing ETL tools to migrate/feed Data to down stream applications using SQL, PL-SQL, perl, shell scripts and schedule them accordingly as part of automation.
  • Developed strategies for data acquisitions, archive recovery, and implementation of a database.
  • Expert in writing PL-SQL procedures for Data Conversions, Data migrations, Batch Jobs/Processing and Applications business processing.
  • Worked on over Peta Bytes (PB) sized Database.
  • Hands on Oracle Database Administration like Client and Server Installations, Backup, Recovery, Performance & Tuning..
  • Good knowledge on SQL and PL-SQL Optimizers, NESTED LOOPS, HASH JOIN, MERGE, SORT AGGREGRATE, Explain Plan / Stats pack, Analytical Functions, Co-related Sub-query, Hierarchical query, Partitioned Tables/Queries, Joins, Hints, set operator like MINUS, INTERSET, UNION, Error Tables etc., .
  • Hands on experience of understanding business challenges & translates them into process/technical solutions.
  • Expert in determining requirements and functional specifications required of the data model and associated architecture.
  • Strong in Oracle security i.e., Connection & Access Privileges/Roles, Auditing, Encryption & Decryption, database, schema and object level Triggers and many more.
  • Strong business analysis, software development and design, and a solid understanding of data warehouse and enterprise application architecture.
  • Proven ability to be able to design, develop, and maintain Databases, Data Warehouses, and extraction queries (Relational/Multidimensional/Non-Relational Databases)
  • Strong experience with Data Analysis, Data Cleansing, Data Migration, Multidimensional Databases, Object Databases, etc.
  • Expert in BI solutions Some of the tools used are Oracle Reports, SSRS, NaviCat, BO.
  • Strong in maintaining Standards and Policies.
  • Experts in User-Administration, Space Management, Redo-log Management and Object Management.
  • Expert in Developing MySQL TSQL Procedures/Functions/Triggers and MySql Instances/Databases.
  • Strong in MS-SQL server 2000/2005 in SQL, T-SQL, user/object management, DTS, SSRS, MS-Reporting Services and creating databases.
  • Strong with Data Migration, Oracle Networks and User Managed Hot and Cold Backups, Logical Backups, RMAM and Troubleshooting. Observing Physical and logical Memory, Process, Transaction, Locks, Latches, Trace Files, Alert Log Files and Memory to name a few as part of Maintenance.
  • Excellent written, oral and interpersonal communication skills. Strengths include Leadership, problem solving, team-oriented and ability to work on multiple projects concurrently.
  • As a Team Lead managed Onsite and Offshore Teams, which includes assigning the work, reviewing the work estimation/source code w.r.t to CMM standard/functionality/Test-cases, Risk management, Approving the leave/Timesheet and providing the feedback to my senior's w.r.t to their performance/promotions on regular basis, motivating the Team members, conducted seminars on regular basis as part of training the fresher’s w.r.t to technology and Domain.
  • As part of training, trained clients on proper system and database functionality.
  • Hands on experience in Trouble shooting and investigation to correct for poor System, Application and Database performance.
  • Worked on Physical & Logical design and Custom data loading procedures.
  • Experience with defining rollback plans that would bring the database back to its previous stable condition as part of different recovery plans..
  • Audit database security configuration and operating system security environment.
  • Created WinForms(.Net, C#)
  • Created Test Cases using Company Template and also Excel QC/JIRA, Raised Defects/Bugs.
  • Created Database/System management and security programs and procedures.
  • Created Database/Unix users and associated them with a group and gave required permissions/privileges
  • Used some of the popular UNIX tools like AWK, SED, TOP, IOStat, PRStat, MPStat, SAR, DOS2UNIX, NMON, TOPAS .
  • Automation Created and Called/Scheduled shell scripts from RC scripts, CRON and Control-M, Autosys, DBMS SCHEDULAR
  • Applied Packages and Patches for Solaris and Linux Operating system
  • Configured/applied the Kernal and Environmental variables
  • Unix Networks configuration, Telnet, FTP
  • Created Virtual Directory in IIS.
  • Created Intranet/Internet based (Web) applications using ASP, XML, CGI, PERL, Applet.

TECHNICAL SKILLS:

Database/ETL tools: Oracle 8/8i/9i/10g/11g(SQL, PL-SQL and Administration), Vertica, SQLServer-2000/2005 (SQL), My-SQL 5.0.1 (SQL), GreenPlum, MS- Access, DB2 (SQL), OEM, Net-Manager, IMPORT, EXPORT, Data Pump, SQL-Loader, TKPROF, STATSPACK, SQLTRACE, MySQL Enterprise Dashboard, MySQL Administrator, Load-JAVA, DBCA, DBUA, LogMiner, RMAN, Have little knowledge on Informatica, SSIS, Oracle 6 Form/Reports, ODI, Oracle Application Express ( Confidential ) .

Reports: MS SQL-Reporting Services(SSRS), Report Builder (NaviCat), Business Objects (BO), Qlikview 11.2, Spotfire.

Web/Scripts: HTML, DHTML, VBScript, JavaScript, Jscript, CGI, Perl, ASP, XML, Kron Shell Script (KSH), Bash Shell Script, php, JSP, PSP, Servlet, Applets, .net, c#

Languages: Pascal, C, Java 1.2 (including JDBC, Applet, Swing), .Net, C#.

Office Utilities: MS-Office (Word, Excel, PowerPoint, Access, Front-Page), Star Office (on Solaris, Windows), Open Office.

Editor’s/Utilities: TOAD for DB2 and Oracle, Rapid SQL, SQL-Tool, Oracle SQL, Oracle SQL Developer, SQL Work Sheet, SQLPlus, iSQLPlus, MySQL Query Browser, TIBCO, Squirrel for DB2, MS-FrontPage, Visual Interdev, Visual Studio for Developing Reports for MS-Reporting Services, WASD, F-Secure, Putty, Winscp, ExamDiff to name a few.

Testing/Bug Management Tools QC (Quality Center), JIRA, Bugzilla Operating system Windows, UNIX Solaris, AIX, Redhat Linux, SuseLinux, HPUnix, System V

Source control / Change Management Tools: VSS, Clear Case, StarTeam, Accurev, PVCS,SVN

Schedular: Control-M, Autosys, RC-Scripts, CRONTAB, Oracle Scheduler (DBMS SCHEDULER)

PROFESSIONAL EXPERIENCE:

Confidential, San Mateo, CA

Sr. Database Consultant

Responsibilities:

  • Optimizing & tuning performance issue i.e., SQL and PL-SQL used in ETL process, reports or in an application
  • Design & PL-SQL development i.e., New modules & Enhancements.
  • Reviewing & signing-off DDL, DML, PL-Sql objects related scripts
  • Actively involved in Enterprise Application Architecture designs, Data Modeling, developments & migrations/conversions

Confidential, San Francisco, CA

Sr. Database Consultant

Responsibilities:

  • Worked in an Enterprise Architecture Team, were was responsible for optimizing & tuning high priority i.e., production & development performance issue i.e., SQL and PL-SQL used in ETL process, reports or in an application
  • PL-SQL ETL developments i.e., New modules & Enhancements.
  • Design & Development of Framework using PL-SQL processes as part of providing flexibility and reusability.
  • Automate existing manual PL-SQL process/Reports
  • Building Business Object Universe & Reports
  • Reviewing & signing-off DDL, DML, PL-Sql objects related scripts
  • Actively involved in Enterprise Application Architecture designs, Data Modeling, developments & migrations/conversions

Technologies & Tools: Oracle 11g SQL, PL-SQL, Vertica, Shell Script, Business Objects.

Environment: Windows, Unix

Confidential, San Francisco, CA

Sr. Database Consultant

Responsibilities:

  • Work on PL-SQL ETL Enhancements.
  • Optimizing and tuning long running PL-SQL ETL processes
  • Automate existing manual PL-SQL process

Technologies & Tools: Oracle 11g SQL, PL-SQL, Shell Script .

Environment: Windows, Unix

Confidential, San Fransisco, CA

Sr. Database Consultant

Responsibilities:

  • Design and develop framework for the below using SQL, PL-SQL, Shell Script
  • Built PL-SQL Packages for Validating the data before the migration for any inconsistency.
  • Built PL-SQL Packages for populating automated report for the same.
  • Built PL-SQL Packages for Migrating data from one CRM application to other.
  • Built PL-SQL Packages for populating automated report for the hand shake.
  • Created shell script wrapper for the above execution

Technologies & Tools: Oracle 10g, SQL, PL-SQL

Environment: Windows XP

Confidential, Palo Alto, CA

Sr. Database/BI Consultant

Responsibilities:

  • Building/tuning ETL process using perl, pl-sql and shell script.
  • Development, Tuning and Supporting Qlikview & Spotfire Reports
  • Data Modeling for building Qlikview Dashboards
  • Writing scripts to load data into the Qlikview fact tables.
  • Defining Standards for building Qlikview Reports
  • Deploying the Qlikview Reports to Testing and Production environment using the Confidential Infrastructure Standards .
  • Communicating with Onsite/Offshore Teams to get the ETL Processes built.
  • Verifying Objects in Vertica w.r.t consistency,
  • Writing Data Validation processes
  • Communicating with Top level Management & Business User w.r.t Requirement gathering
  • Helping Business Analyst in building New Business Model or Modify existing Business Model to benefit the revenue
  • Moving data from Vertica to SAS
  • Moving data from SAS to Vertica
  • Code Review

Technologies & Tools: Qlikview 11.2, Vertica, SVN, Spotfire, Oracle 11g SQL, PL-SQL

Environment: Windows 7, Solaris, Linux

Confidential, Santa Clara, CA

Sr. Database Engineer

Responsibilities:

  • Development, Tuning and Support for functional and PL-SQL batch Processes
  • Reverse Engineering w.r.t Design/process/Logical Design Designing/Building/Optimizing and Tuning Batch Jobs and Functional procedure/function/packages.
  • Writing Shell, Perl and AutoSys Scripts
  • Defining Standards for coding DB process/batch jobs in Distributed Database environments
  • Creating LLD’s and HLD’s for functional and batch Processes

Technologies & Tools: Oracle 9i/11G SQL, PL-SQL, shell script (ksh), perl, Putty, PL-SQL Developer

Environment: Solaris, Windows XP

Confidential, Seattle, WA

Sr. Database Engineer

Responsibilities:

  • Development, Tuning and Support for functional and batch Processes
  • Designing/Building/Optimizing and Tuning Batch Jobs and Functional procedure/function/packages.
  • Writing Shell, Perl and AutoSys Scripts
  • Defining Standards for coding DB process/batch jobs in Distributed and heterogeneous Database environments
  • Creating LLD’s and HLD’s for functional and batch Processes
  • Communicating with Business User w.r.t Requirement gathering

Technologies & Tools: Oracle 11G SQL, PL-SQL, shell script (ksh), perl, Informatica, OBIEE 10.3.1.4, .Putty, PL-SQL Developer.

Environment: Redhat Linux, Windows XP

Confidential, Houston,TX

Sr. Database Engineer

Responsibilities:

  • Development and Support for PHP Application, Oracle 10g Forms, Oracle 10g Reports.
  • PL-SQL Processes Designing/Building/Optimizing and Tuning Batch Jobs and Functional procedure/function/packages.
  • Writing Shell, Perl and AutoSys Scripts
  • Defining Standards for coding DB process/batch jobs in Distributed and heterogeneous Database environments

Technologies & Tools: Oracle 9i/10G, SQL, PL-SQL,, Oracle 10g Forms, Oracle 10G Reports, Putty, PL-SQL Developer, MySql SQL, Stored Programs, PVCS, PHPs, shell script, Autosys.

Environment: Solaris, Windows XP.

Confidential, Richfield, OH

Sr. Database Engineer

Responsibilities:

  • Development and Support for Application and Database Issues
  • Designing/Optimizing and Tuning Batch Jobs and Functional procedure/function/packages.
  • Defining Standards for coding DB process/batch jobs Code Reviewing

Technologies & Tools: Oracle 10G, SQL, PL-SQL, Putty, PL-SQL Developer, StarTeam, Accurev, JIRA

Environment: Solaris, Windows XP.

Confidential, Bellevue, WA

Database and Unix Developer

Responsibilities:

  • Created Shell Scripts for Automating the movement of files (both FTP and Local) and running the Batch jobs
  • Development and Support for Application and Database Issues
  • Optimizing and Tuning Batch Jobs.
  • Go-Live Support

Technologies & Tools: Oracle 10G, SQL, PL-SQL, Putty, WINSCP, Oracle SQL Developer Environment: AIX, Windows XP.

Confidential, Beaverton, OR

Database Specialist / Architect (Jr)/Solution Architect

Responsibilities:

  • Created cross-functional flow charts as part of Reverse Engineering
  • Physical Modeling for New Modules and Applications.
  • Requirement gathering.
  • Reviewing Func Spec’s.
  • Created Technical Specifications, HLD’s, Process Design
  • Code Reviewing.
  • Production and Staging Deployment/Support Designed and Developed Automation for Data Loading and Testing processes using Autosys/PL-SQL/Shell Scripts.
  • Created Reports using SSRS
  • Optimized and Tuned Long running PL-SQL Batch Jobs and Reports
  • Monitoring Production Batch jobs using Autosys UniCeneter.
  • Created Test Cases
  • Business Architecture Presentation for Clients.
  • Assign Tasks for Team Members follow-up/review the same.
  • Reviewing work estimation
  • Leading Off-Shore and On-Shore Team of Developers

Technologies & Tools: Oracle 11G/10G/9i, SQL, PL-SQL, Administration and Maintenance, SQL Navigator for Oracle, Oracle10G Enterprise Manager (OEM), Visio, Erwin, Import/Export, SQL*LOADER, SSRS, Log-Miner, QC (Quality Center), VSS, Putty.

Environment: SOLARIS, Windows XP.

Confidential, New York

Senior Data Analyst

Responsibilities:

  • Designed and Developed Automation for Data Loading and Testing processes using Control-M/PL-SQL/Shell Scripts.
  • Loaded data as per the requests for different teams which uses USGAP and IFRS methodologies.
  • Analyzed the Issues with Data, Database objects and processes, Shell scripts Kshell and UNIX environment.
  • Responsible to load the data form OLTP to Data warehouse and from Data warehouse to Data Marts.
  • Helped Support Team and Build Team to fix the Issues.
  • Tuned Data Load process.
  • Presentation on writing optimized queries for Report developers (BO Developer).
  • Worked on Partition Swapping approach to increase the performance and maintain the read consistency between Data-Load and QA departments.
  • Reverse Engineering to create ER Diagrams w.r.t Objects and Processes.
  • Created, Modified and Tuned Business Object Reports as per the requests.
  • Created, Modified and Tuned PL-SQL Procedures as per the Data Load requirements.
  • Communicated with Off-Shore Team to assign the jobs and review the same.
  • Took responsibility for delivering the data on Time during major releases.
  • Motivated Team members.
  • Raise the Defects in QC.
  • Created Test Cases in QC.
  • Manual Testing.
  • Batch Testing .

Technologies & Tools: Oracle 10G, SQL, PL-SQL, Administration and Maintenance, Rapid SQL for Oracle, SQL Tool for Oracle, Oracle10G Enterprise Manager (OEM), Visio, Erwin, Import/Export, SQL*LOADER, Log-Miner, Shell Scripts (Kshell), QC (Quality Center), BO (Business Objects), Clear Case 7, Putty.

Confidential, New Jersey

Senior Database Programmer /Database Specialist /Lead/Solution Architect

Responsibilities:

  • Designed to develop and manipulate SQL databases, data warehouses and multidimensional databases.
  • Migrated huge data from different sources to Oracle on monthly and quarterly basis using PL-SQL.
  • Upload data from file to tables in Greenplum using Copy command
  • Build highly de-normalized tables in Greenplum for Reports.
  • Created new Procedures/Functions/Triggers/Materialized Views/Packages / Simple, Ref & Traditional Cursors / Dynamic SQL / Pipelined / Table functions as part of Project/Application requirements.
  • Handled Exception so to avoid process termination and log the errors.
  • Coded the process with all standards like by putting comments on tables / columns/source code with readable pro-logs in SQL, PL-SQL source code.
  • Created Tables/Views/Materialized Views/Indexes/Partition Tables/ Compressed Tables/Index Organized Tables/Objects type.
  • Wrote Complex Queries like Sub-Queries, Joins, Hierarchical Query, Co-related Sub-Query, Traditional cursor used inside Query, Inline View, Simple/Aggregate Functions, Analytical Functions, to name a few.
  • Designed and created PL-SQL automated process for a vertical storage system.
  • Backing up and Restoring the database using Logical / Cold / Hot / RMAN based on required type of Backup.
  • Monitoring the Processes /Alert log file/ Trace files on regular intervals as part of maintenance .
  • Tuned complex SQL Statements used inside Merge statement, Materialized Views, Application and Reports, Optimized & Tuned PL-SQL Procedure/Function/Triggers /Packages.
  • Developed user interface screens and Report screens
  • Worked closely with Informatica Developer to Tune ETL Queries/Processes.
  • Responsible for technical support of applications through implementing predefined SQL/PL-SQL processes.
  • Designed, Developed & Implemented ETL processes using TOAD, SQL*Loader, SQL and PL-SQL to meet key project requirements.
  • Created transactions and ran tests to find errors and confirm program specifications.
  • Modified, Maintained, Optimized and tuned SQL and PL-SQL Source code as required.
  • Created reports using MS-Reporting Services. Requirement gathering as part of new enhancements.
  • Optimized and Tuned Confidential Databases/Instances/Servers w.r.t to Memory and Hardware.
  • Migrated huge data from Oracle to MySQL on weekly, monthly and quarterly basis.
  • Migrated Oracle Parent Database data to Oracle Child Database.
  • Exported MySQL data to Flatfiles on requests.
  • Installed/Configured MySQL Administration, MySQL Query Browser, MySQL Enterprize Dashboard, Navicat for accessing and maintaining MySQL Databases.
  • Configured and tuned MySQL Instances using my.ini config-file
  • Created users, granted and revoked privileges in MySQL and Oracle Databases
  • Monitoring MySQL Instances w.r.t Connection Health, Memory Health, Status Variables, Agent Status, Server Status, CPU Usage, I/O, Lock Contention, Caches, server logs.
  • Analyzed/checked/Optimized and repaired MySQL Tables, flushed Internal Caches also Cached Indexes
  • Monitoring and optimizing the performance of the database.
  • Building Oracle 10g Reports.
  • Collecting statistical Information about memory like Shared Pool (Library cache, Dictionary cache), Buffer Caches, Large Pool, PGA to verify the Load and hence to tune same if required.
  • Collecting Statistics about the Temporary /Undo and/or Rollback segments to verify the I/O Load so to tune the same.
  • Collecting Statistics about the Permanent segments to verify the I/O Load, Chained Rows, Migrated Rows, Fragmented Extents so to tune the Performance, remove/avoid row chaining and row migration and to de-fragment the extents and segregating the same / moving to another place if required.
  • Administering, Monitoring and Providing high availability and Fault-tolerant MySQL and Oracle Databases.

Technologies & Tools: Oracle 9i/10G, SQL, PL-SQL, Administration and Maintenance, Oracle 10G Reports, MY-SQL, MS-Report Services, DB2 SQL, MS-Access. TOAD for Oracle/DB2, Oracle 9i/10G Enterprise Manager (OEM), Oracle SQL, SQUREL for DB2, GreenPlum, Visual Studio, Import/Export, SQL*LOADER, Log-Miner.

Environment: SOLARIS, Windows XP, Windows Server 2000/2003

Hire Now