We provide IT Staff Augmentation Services!

Lead Database Engineer Resume

Washington, DC

SUMMARY:

  • Over 11 years Database consulting experience in IT, Finance, HealthCare Administration, Energy and Education industries.
  • Microsoft Certified DBA (MCDBA), Certified in Microsoft Business Intelligence BI (SSIS,SSAS,SSRS), Certified Oracle 10g Advanced PL/SQL Programmer, Microsoft Certified Application Developer for C# .NET (MCAD).
  • M.S in computer science, M.S in Applied Math.
  • Expertise in writing T - SQL and PL/SQL Queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors.
  • Expertise in Merging data from various Heterogeneous sources, Populating Dimension and Fact tables in Data warehouses and Data Marts, Cleaning and Standardizing data loaded into OLTP and OLAP databases using SSIS.
  • Expert in creating Star schema cubes using SSAS.
  • Created various SSRS Reports involving variety of features like Reports, Charts, Filters, Sub-Reports, Drilldown, Drill-Through, Multi-valued parameters.
  • Extensive Experience in RDBMS concepts such as Tables, User Defined Data Types, Indexes, Functions, Table Variables and Stored Procedures.
  • Expertise in tuning slow running SQL script to achieve high performance.
  • Implemented database project script version control on stored procedure/table/index using Source Tree with Mercurial.
  • Expertise in leading and maintaining project objectives to ensure alignment with business strategic initiatives.
  • Expertise in creating web applications with SQL Server database and .NET C#/VB.

PROFESSIONAL EXPERIENCE:

Lead Database Engineer

Confidential, Washington DC

  • Created and optimized SQL queries, stored procedures, user defined functions, Indexes, views and triggers to achieve maximum efficiency and scalability.
  • Wrote T-SQL Queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors.
  • Fixed database performance issues caused by parameter sniffing by adding recompile hint to stored procedure and optimize-for hint to variables. Forcing SQL server to use regenerated execution plan on different parameters.
  • Advanced T-SQL coding technique of passing indefinite number of parameters to stored procedure by user-definied-table-type; optimize cursor performance with fast forward read only; parameterized dynamic SQL execution with exec sp executesql; preventing parameter sniffing problem with option(recompile); recursive CTE.
  • Tuned slow running SQL script by changing the table variable to temp table to take advantage of SQL server statistics for 3 million rows of data.
  • Created T-SQL search student stored procedure with database side pagination on millions rows dataset for 23 states that use AIR Student Online Exam website.
  • Created SSIS Sequence container to load dimension and fact table for data warehouse.
  • Set up control flow tasks (FTP task, Bulk Insert task, Execute Package task, etc) for SSIS packages.
  • Maintained SSIS package for loading data from multiple databases to data warehouse dim tables and fact tables.
  • Deployed SSIS packages and scheduled job in SQL Server Agent to run the packages automatically.
  • Monitored SSIS packages with SSIS log and event handler.
  • Debugged SSIS package by setting breakpoint and using checkpoint file.
  • Created Star schema cubes using SSAS.
  • Performed data mining with SSAS Cubes.
  • Created and maintained SSRS report using OLTP data, OLAP multidimensional data, and SSAS Cubes.
  • Built various types of SSRS reports: parameterized report, dynamic column report, looked up value field report, dashboard report, etc.
  • Designed, Developed and Deployed reports in MS SQL Server environment using SSRS 2012.
  • Generated Sub-Reports, Cross-tab, Conditional, Drilldown reports, Drillthrough reports and Parameterized reports using SSRS 2012.
  • Designed database/data warehouse schema based on business requirements. Set up primary key, foreign key, not null, unique, check constraint, clustered/non-clustered index.
  • Reviewed database design and gave suggestions on setting up clustered/non-clustered index, table normalization/denomalization, table partitioning, multiple file group for parallel I/O.
  • Identified query performance with SQL Profiler, traces.
  • Changed poorly performing SQL queries by checking CPU, memory, network I/O, application code, statistics, index and query structure.
  • Created database project with SSDT in Visual Studio 2015.
  • Implemented database project script version control on stored procedure/table/index using Source Tree with Mercurial.
  • Performed schema compare/data compare using SQL Server Data Tool to maintain database consistency between Dev, Test and Production databases.
  • Created database unit test projects for hundreds of stored procedures.
  • Analyzed complex business needs presented by clients and recommends technical solutions.
  • Used JIRA to tracked tickets status and transitions during their work flows.
  • Maximized productivity by setting clear expectations and proactively communicating project status, issues, and risks to internal and external stakeholders.

Sr. Database Consultant

Confidential, McLean, VA

  • Designed data architecture, data model and Mapping Process to load data based on business requirement and provided documentation.
  • Maintained SSIS package for loading data from multiple databases to data warehouse dim tables and fact tables.
  • Deployed SSIS packages and scheduled job in SQL Server Agent to run the packages automatically.
  • Wrote T-SQL and PL/SQL Queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors.
  • Set up the Reporting database with database mirror from production database.
  • Created the package of BI solution for American Petroleum Institute: OLAP star schema logical design and physical implementation, ETL with SSIS, multidimensional SSAS data cube model and sample reporting with SSRS.
  • Created and maintained SSRS report using OLTP data, OLAP multidimensional data, and SSAS Cubes.
  • Built various types of SSRS reports: parameterized report, dynamic column report, looked up value field report, dashboard report, etc.
  • Designed database/data warehouse schema based on business requirements. Set up primary key, foreign key, not null, unique, check constraint, clustered/non-clustered index.
  • Developed VB .NET/C# .NET web application with ADO .NET and ensured that the code has no hidden threat (SQL injection, inline dynamic SQL, etc. ) to Database.
  • Resolved database lock with system stored procedure sp who2, sp lock, DBCC input buffer.
  • Developed VB .NET/C# .NET web application with ADO .NET and ensured that the code has no hidden threat(SQL injection, inline dynamic SQL, etc) to Database.
  • Configured SQL server agent to perform maintenance tasks on databases: check database corruption task, shrink database task, backup data file task, backup log file task, rebuild index task, update statistics task, notify operator task.
  • Managed database security, user accounts and user-defined database roles.
  • Planed project initiatives, communicate goals and provide continual updates on progress to Senior Leadership.
  • Liaised between business and technical teams to achieve on-time, on-budget, and on-spec project completions.
  • Assessed issues and identified solutions to align with quality standards and customer goals.

Sr. Database Consultant

Confidential, Fairfax, VA

  • Created and maintained SSRS report using OLTP data, OLAP multidimensional data, and SSAS Cubes.
  • Built various types of SSRS reports: parameterized report, dynamic column report, looked up value field report, dashboard report, etc.
  • Created and maintained SSIS packages to construct high performance ETL for data mart and data warehouse.
  • Deployed SSRS reports to SQL Server Reporting Service.
  • Created SQL Server database snapshot against mirrored database to provide read-only access.
  • Created and maintained SQL Server/.NET VB Web application with Visual Studio 2010 to provide public health report.
  • Developed VB .NET/C# .NET web application with ADO .NET and ensured that the code has no hidden threat(SQL injection, inline dynamic SQL, etc) to Database.

Lead Database Developer

Confidential, Tallahassee, FL

  • Designed database/data warehouse schema based on business requirements. Set up primary key, foreign key, not null, unique, check constraint, clustered/non-clustered index.
  • Implemented data schema, fields, and whole database design. Created data warehouse star schema.
  • Created and maintained SSIS packages to construct high performance ETL for data mart and data warehouse.
  • Set up SSIS data flow data sources, transformation tasks and destinations.
  • Maintained SSIS package for loading data from multiple databases to data warehouse dim tables and fact tables.
  • Built various types of SSRS reports: parameterized report, dynamic column report, looked up value field report, dashboard report, etc.
  • Created and maintained SQL Server/.NET VB Web application with Visual Studio 2010 to provide public health report.
  • Created and maintained SSRS report using OLTP data, OLAP multidimensional data, and SSAS Cubes.
  • Implemented SSAS Data Mining in healthcare data warehouse with Decision Tree, Neural Network, and Linear Regression.
  • Built various types of SSRS reports: parameterized report, dynamic column report, looked up value field report, dashboard report, etc.
  • Deployed SSRS reports to SQL Server Reporting Service.
  • Created SQL Server database snapshot against mirrored database to provide read-only access.
  • Created and maintained SQL Server/.NET VB Web application with Visual Studio 2010 to provide public health report.
  • Developed VB .NET/C# .NET web application with ADO .NET and ensured that the code has no hidden threat(SQL injection, inline dynamic SQL, etc) to Database.
  • Developed Web Service with VB .NET ADO .NET to provide data for ArcGIS layered map application.
  • Reviewed database design and gave suggestions on setting up clustered/non-clustered index, table normalization/denomalization, table partitioning, multiple file group for parallel I/O, physical disk RAID level.
  • Created and maintained Operators, Alerts, Notifications, and Schedules. Monitor connections, locks and performance of SQL server.
  • Resolved database lock with system stored procedure sp who2, sp lock, DBCC input buffer.
  • Created ER diagram with MS Visio and Management Studio.
  • Analyzed and monitor disk space usage for data file, log file. Truncated log file periodically to prevent log file run out of disk space.
  • Performed database backup and restore. Implemented Full database backup, Differential database backup, Transaction log backup.
  • Created file groups to balance data storage, placed data files on multiple physical drives to improve throughput with parallel data access, placed transaction logs on separate disks.
  • Interfaced with the clients to discuss project scope and specifications, project cost and scheduling, risks mitigation, contingency planning, and delivery and implementation procedures.
  • Suggested and provided immediate solutions and decisions for escalated issues.

Sr. Database Consultant

Confidential, Tallahassee, FL

  • Lead Database Developer, Florida Confidential .
  • Sr. Database Performance Tuning Expert, Papa John’s Pizza online ordering website.
  • Lead Database Developer, Florida Medical Quality Assurance.
  • Lead .NET C#/VB developer, Database Developer, Florida Agency for Persons with Disability.
  • Database Architect, Florida Supreme Court online sentence system.
  • Tuned SQL Server database for Papa John’s Pizza online ordering website to improve response time. Solved the problem of slow response time by changing index structure, parameter sniffing, table normalization, file groups, physical data file location, and .NET C# coding standard compliance with stored procedure call.
  • Created and Developed Tables, Views, Triggers, Cursors, Dynamic Stored Procedures, User Defined Functions, Transact-SQL (DDL, DML) statements and other advanced queries for databases by using Query Analyzer and SQL Server Management Studio.
  • Performed maintenance tasks on databases like check database corruption task, shrink database task, backup data file task, backup log file task, rebuild index task, update statistics task, notify operator task.
  • Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, send mail task, active script task, xml task.
  • Designed and generated reports with data warehouse cubes using SQL Server Reporting Services (SSRS) 2008.
  • Designed, Build the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS).
  • Developed .NET Web application/Web Service with Visual Studio 2005/2008 in C#/VB/JavaScript.
  • Migration of databases from Oracle 10g to SQL Server 2005, including move data, stored procedures, index, functions, user security setting, web application testing.
  • Developed PL/SQL packages, stored procedures, functions, Cursors, triggers.
  • Creating databases, objects, roles and privileges. Partitioned large tables to increase the performance.
  • Responsible for Data load on different databases using SQL*Loader.
  • Export and import of database objects using EXP and IMP.
  • Configure and manage RMAN backup and recovery.
  • Populating data, security management (using roles, profiles), maintaining database security through users, roles, grants and audits. Fine tuning of Production applications in SQL, PL/SQL.
  • Managed Oracle database Control files, Data files, Redo Log files.
  • Managed Oracle instance SGA, PGA and Background processes, such as PMON, SMON, CKPT.
  • Installed and configured tools for end users: SQL Developer, TOAD, ODBC, JDBC, ADO .NET, Crystal Report.
  • Used Oracle Net services to establish and maintain network connections, configure Listener.ora file, tnsnames.ora file, listerner control utility Lsnrctl.
  • Monitored the Oracle database performance (CPU, Memory, Network, I/O, application code) with Server generated alerts and Automatic Database Diagnostic Monitor(ADDM), Oracle Enterprise Manager.
  • Set up Online Backup running database in ARCHIVELOG mode, archived datafiles, redo log files.
  • Defined project scope, goals and deliverables that support business goals in collaboration with senior management, stakeholders, vendors, and project sponsors.
  • Responsible for the overall enterprise-wide stakeholder management as well as proper communication of project expectations to team members with project stakeholders in a timely and clear fashion using appropriate channels.
  • Proactively managed changes in project scope, identify potential crises, and devises applicable contingency plans.
  • Applied effective project management techniques to mitigate risk by identifying, escalating, and resolving issues

Data Analyst/.NET C# developer

Confidential

  • Developed ER diagrams of the Florida Retirement Financial System (Oracle 9i) with Erwin.
  • Created database and database objects like Tables, Stored Procedures, Views.
  • Developed Oracle stored procedures with PL/SQL.
  • Developed and maintained web application with .NET C#/VB.

TECHNICAL SKILLS:

RDBMS : SQL SERVER 2005/2008r2/2012/2014, Oracle 9i/10g/11g.

Databases Tools : SQL Server Management Studio, BIDS, Database Engine Tuning Advisor, Enterprise Manager, Data Tool in Visual Studio 2015, Query Analyzer, SQL Profiler, Data Transformation Services, Upgrade Wizard, Replication, MS Visio, SSRS, SSIS, SSAS, Crystal Report, Oracle Enterprise Manager(OEM), TOAD, RMAN, SQL Plus, SQL Developer.

Programming Languages: SQL, TSQL, PL/SQL, C#/ VB .NET, JAVA, Adobe FLEX/FLESH, VBA, HTML, XML

Project Management Tools: MS Project, JIRA

Operating Systems: Windows, Linux, UNIX, DOS, Windows Server

Utility Tools: MS Office, MS Project, BI, SSAS, SSIS, SSRS, Sharepoint 2010, Source Safe, SourceTree, FTP, SSH, IIS

Hire Now