Database Consultant Resume Bethesda, MD - Hire IT People

SUMMARY:

Over 18 years technical consulting experience with a proven track record in the design, development, and deployment of technical solutions.
Expertise in designing, implementing, and managing enterprise relational (OLTP) and dimensional (OLAP) data warehouse solutions, with a strong understanding of database modeling principles.
Experience with Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modeling and design techniques.
In depth experience in Oracle and Microsoft SQL Server database architecture, database development, and performance tuning and database administration.
Analyzes and solves problems in a deductive and logical manner.
Organized team player able to work closely with cross - functional teams in fast paced environments.
Demonstrated success in forging relationships with clients at different organizational levels.

TECHNICAL EXPERTISE:

Operating System: UNIX (Sun Solaris 9, 10), Red Hat Linux 5/6/7, WinNT/Windows 2003/Windows 2008 R2/Windows 2012

DBMS: Oracle 9i/10g/11g/12c, Microsoft SQL Server 6.5/7/2000/2005/2008/2012 , 2016, DB2, MySQL, PostgreSQL

Languages: C, C++, Python, PL/SQL, PSQL, T-SQL, C#, VB.NET, Bash Shell Scripting, ASP.NET, HTML, CSS

Data Modeling: ERwin, Visio, Oracle SQL Developer Data Modeler

Reporting: MicroStrategy 8, 9, SQL Server Reporting Services, Crystal Reports

Database Tools: SQL Developer, Toad, OEM, RMAN, Data Pump, SQL*Plus, SQL*Loader, SQL Profiler, SSMS (SQL Server Management Studio), SSIS, SSRS

ETL: Talend 6.4 / 7

Other: Git, Subversion (SVN), CVS, Visual Source Safe, JIRA

EXPERIENCE:

Database Consultant

Confidential, Bethesda, MD

Responsibilities:

Design and develop both highly normalized OLTP Oracle 10g/11g/12c databases and de-normalized star schema OLAP model for the enterprise data warehouse.
Design end to end ETL process using Talend 6.4 pulling data from source systems, load data into staging area, data validation and scrubbing procedures, and population of presentation tables for consumption by MicroStrategy dashboards for the White House.
Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.
Write Bash shell scripts to perform regular monitoring (checking disk usage, missing statistics on tables, check log files for errors) and backup and Recovery using RMAN.
Created indexes on the tables for faster retrieval of the data to enhance database performance.

Database Consultant

Confidential, Arlington, VA

Responsibilities:

Created PL/SQL stored procedures, functions and packages for moving the data from source systems into databases designed for reporting.
Generated migration procedures for legacy database for migration over to Amazon Web Services (AWS).
Install and configure both single node and multi node database across DEV, QA, UAT and PRODUCTION environments.
Partitioned the fact tables and materialized views to enhance the performance.
Improve MicroStrategy reports performance through query optimization that significantly reduces execution times by identifying performance issues using EXPLAIN PLAN.
Maintain the database document library containing documents such as service level agreements, E-R diagrams, network diagrams, performance reports, installation notes, and standard operating procedures (SOPs).

Senior DBA

Confidential, Rockville, MD

Responsibilities:

Managed the development and release cycles in a CMMI Level III environment.
Developed MicroStrategy dashboards and reports for executive management team.
Developed the ETL processes to extract/load legacy data from SQL Server / Oracle OLTP databases to the Oracle data warehouse.
Performed source systems data profiling, data scrubbing, validation, transfer, and loading.
Coded PL/SQL / T-SQL stored procedures to implement business logic at the database level.

Programmer / DBA

Confidential, Washington, DC

Responsibilities:

Designed and developed backend SQL Server 2000 database for web-based application that interfaces with Confidential SEVIS application that monitors exchange visitors.
Created database maintenance plans and ensured that all databases are backed up on a regular basis by monitoring full, differential, transaction log backups.
Redesigned and deployed system for the Confidential that enabled screening of new hires.
Redesigned system using ASP and SQL Server 7.