We provide IT Staff Augmentation Services!

Database Architect, Development And Lead Resume

4.00/5 (Submit Your Rating)

AZ

SUMMARY

  • Over 15 years of experience in Information Technology with expertise in Data Warehousing, Database Architecture, Data Modeling, Development, Implementation, Maintenance and Support.
  • Adept in Oracle, Oracle Tools and Utilities, SQL and PL/SQL.
  • Experienced in various database development and Production projects involving Oracle and SQL server.
  • Involved in exhaustive Performance Tuning, Monitoring and Optimization of PL/SQL blocks in both Development and Production environment, for Oracle and SQL server databases.
  • Experienced in creating/tuning complex SQL queries, Stored Procedures and Functions, ETL Packages and database triggers.
  • Involved in large volume data migration to Enterprise Data Warehouse using PL/SQL, UNIX scripts, SQL*Loader, SSIS.
  • Created Dimension and Fact tables using Snowflake and Star schema
  • Thorough Knowledge in creating DDL/DML queries in SQL for Oracle and SQL - Server databases.
  • Excellent Analytical and Problem-solving skills.
  • Ability to perform well as a Team member and as an Individual, with dexterity to blend well in any situation and environment.

PROFESSIONAL EXPERIENCE

Confidential, AZ

Database Architect, Development and Lead

Responsibilities:

  • Lead Data Architect for QR services, a startup health services company.
  • Responsible for Overall Data architecture and modeling for the organization in Snowflake Methodology
  • Managed End to End Database design, Administration and Data Engineering for MR Reports and case management system
  • ETL and Analysis of Hospital PII and clinical data
  • Data modeling and architecture with Data Vault Modeling philosophies.
  • Created Procedures, Scripts, Packages and Types for the current and new application.
  • Created DB and Python scripts to automate day to day functions.
  • Supported the development of Tableau reports which are fed directly from Hospital data
  • Automated the deployment of Database Objects and data deployment
  • Involved in production support during and after the release.
  • Involved in stats gathering and fine tuning the database model to suit the application needs.

Confidential, AZ

Sr. Database Developer

Responsibilities:

  • Lead Data Engineer and Data modeler for the Vendor/Sales Reports and Supply chain Management system.
  • Created Procedures, Scripts, Packages and Types for the current and new application.
  • Created DB Test scripts to identify and rectify data move issues between two models.
  • Supported the development of COGNOS reports which are fed directly from the Warehouse tables.
  • Database Modeling in Snowflake and Star schema for Oracle and SQL Server development Databases.
  • Analyzed and designed tables based on small and large database transactions.
  • Developed back-end interfaces using PL/SQL stored packages, procedures, functions, Collections, Object Types, K-Shell scripts
  • Developed Korn shell scripts to kick off back-end PL/SQL, SQL programs.
  • Developed automated Korn shell scripts to schedule the load of flat files on daily, weekly and monthly basis.
  • Modified existing and new DB objects to perform better using Oracle Hints.

Confidential, AZ

Tech Lead

Responsibilities:

  • Involved in the Design and analysis of new and existing database model and performance
  • Provide Team members with guidance and instructions.
  • Primarily involved in development towards achieving business goals for IDN.
  • Created Procedures, Packages and test modules for the Sybase applications and warehouse
  • Involved in scheduling contact with the business team
  • Created DB ETL scripts to identify and rectify data move issues between two models.
  • Coordinated with DBA in creating and managing table, indexes, table spaces, triggers, db links and privileges.
  • Mentoring team members towards excellence.
  • Responsible for performing code reviews.
  • Involved in complete SDLC life cycle of the new application.
  • Involved in production support during and after the release.

Confidential, CT

Database Developer

Responsibilities:

  • Involved in Database design for the new data model.
  • Created Sync Triggers for the old model data to be migrated to the new model tables.
  • Created Procedures, Triggers, Packages and Types for the current and new application.
  • Involved in cruise control deployment for Agile deployment
  • Changes made to improve the performance or process of existing programs, using the PLSQL advanced technologies like Collections, NOCOPY, Dynamic Cursors
  • Utilized PL/SQL developer tool in developing all back-end database interfaces.
  • Involved in stats gathering and fine tuning the database model to suit the application needs.

Confidential, DC

Database Developer

Responsibilities:

  • Developed complex queries, Functions, Stored Procedures and Triggers using PL/SQL.
  • Tuned frequently used SQL Statements and PL/SQL Blocks using SQL-Lab and increased performance by utilizing optimization techniques.
  • Created Database Triggers to accommodate for data integrity and additional Referential Integrity.
  • Tuning of stored procedures & developed business logic in database layer using PL/SQL.
  • Involved in creation of clone databases for QA testing, Reporting and user acceptance testing.
  • Performance tuned multiple SQL queries and PL/SQL blocks using Explain Plan, Hints and SQL Trace.

Confidential, KY

Database Developer

Responsibilities:

  • Created SQL Queries, scripts and Macros for the Purpose of Data Validation between the datamarts.
  • Generated DDL Queries for creation of new database objects like tables, views, sequences, functions, synonyms, indexes, triggers, packages, stored procedures, roles and granting privileges.
  • Generated and maintained Keys, Constraints and Relationships between the tables for OLTP, Test, Development, PV and Archive instances.
  • Created Test data as well as modified existing test data for validation.

Confidential, PA

Database Developer

Responsibilities:

  • Created new database objects like Sequences, Procedures, Functions, Packages, Triggers, Indexes and Views in Development and Production environment in PL/SQL and SQL*Plus (SQL Navigator).
  • Involved in creating Sequences, Tables, Functions and Procedures for the Oracle Back-end calls from the Java Front-end (Business Intelligence).
  • Also provided 24/7 production support for the batch/production jobs.
  • Involved in SQL Performance tuning.
  • Created Database Triggers for enforcing Data Integrity and logging.
  • Involved in creation of Test Plans and Mock Data for testing purposes.

We'd love your feedback!