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.
