SUMMARY:

• An experienced Database Architect with expertise in Logical & Physical Database Design, Data Modeling, and Database Performance Tuning in various production and development environments.
• Expert in administering systems, PL/SQL, TSQL, Shell scripts and explaining complex concepts in down to earth terms.
• Expert in Oracle Golden Gate data replication tool.

TECHNICAL SKILLS:

Database: Oracle 7.x/8i/9i/10G/11G, MS Access, ODBC, JDBC, Netscape LDAP, MS SQL Server 2005/2008, Golden Gate

ERP: Oracle 10.7/11i

Languages: Oracle SQL, PL/SQL, JSP,UNIX Shell, Java, J2EE, Pro*C, Perl,SQL Server SQL

OS: MS Windows, SUN OS 5.X, HP - UNIX 9.0/10.0, IBM AIX 4.X, Linux

DBA: Quest SQLSpy, SQLCoder, SQLLab, Oracle Enterprise Manager(OEM), Quest SQLNavigator, Toad, Spotlight, SharePlex, Quest Central, Quest Code Tester, Oracle SQL Developer, DbVisualizer 7.x, SQL Server Management Studio, SSIS

App Server: Oracle Web Server, 9iAS

Web Server: Apache

Data Modeling: Erwin, Sybase PowerDesigner, Toad Data Modeler

Presentation Tools: PowerPoint, Visio

Report Writer: SQR, Report Smith, Crystal Report, and Oracle Report

Search Engine: Verity, Oracle interMedia

Java: WebGain Visual Cafe Enterprise 4.0, J2EE, JNDI, Solaris JDK 1.2

PROFESSIONAL EXPERIENCE:

Data Architect/Development DBA/Projet Lead

Confidential

• Implemented Oracle Golden Gate 11.2.X for data replication between Oracle AIX and Oracle Solaris

• Designed data replication between OLTP and ODS data storage
• Performed Application DBA role to support multiple Java/Oracle development teams
• Developed stored procedures, triggers, function, procedures, materialized views to support various application teams
• Developed multiple DBA utilities to manage the full development cycle
• Led a team of 8 PL/SQL developers to develop DWH project using PL/SQL, UIX Shells, CTRL-M

Data Architect/Development DBA

Confidential

Responsibilities:

• Provided Operational/Application support for Oracle databases and infrastructure (Including dev, test, integration, training, and production instances)

• Used Sybase PowerDesigner for data modeling to model Data Warehouse (Star Schema)
• Conducted Database Platform lifecycle support (releases, patches, etc), Storage capacity, performance and reliability management, initiating changes required to meet business requirements
• Conducted Database platform capacity, performance and reliability management support
• Developed stored procedures, triggers, functions, procedures, materialized views to support various application needs

Data Architect/Development DBA/Production DBA

Confidential

Responsibilities:

• Used Sybase PowerDesigner for data modeling to model OLTP tables

• Used Sybase PowerDesigner for data modeling to model Data Warehouse (Star Schema)
• Maintained both logical and physical ERD for the whole development cycle
• Implemented physical data model based on logical model
• Managed Development/QA/Integration/Production databases for agile development process
• Developed packages, procedures, views, stored procedures using PL/SQL, TSQL
• Tuned complex SQLs, stored procedures, and packages
• Developed ETL scripts using Unix shell, SQLs, and PL/SQL packages
• Managed the software release process using Jira, TortoiseSVN
• Migrated data from SQL Server 2005 to Oracle 11G

Data Architect/Development DBA/Production DBA/Unix Admin

Confidential

Responsibilities:

• Used Erwin for data modeling to model 50 OLTP tables

• Maintained both logical and physical ERD for the whole development cycle
• Implemented physical data model based on logical model
• Managed Development/QA/Integration/Production databases for agile development process
• Developed packages, procedures, views, stored procedures using PL/SQL,
• Quest Toad, SQL Navigator, Java
• Tuned complex SQLs, stored procedures, and packages
• Developed ETL scripts using Unix shell, SQLs, and PL/SQL packages
• Managed the software release process using Jira, SVN, and database using ANT build scripts
• Installed Oracle 10G, 11G on HP-UX
• Converted databases from 9i to 10G to 11G
• Configured OEM 11G version, implemented 11G DataGuard
• Developed database backup/restore routine using Shell/RMAN to do Cold, hot backup and clone databases

Data Architect/Development DBA/PL/SQL Development

Confidential, Bloomington, MN

Responsibilities:

• Designed complex ETL process through the data flow process from data cleansing to data mapping, to data modeling, to data governance, to Data Warehouse.

• Managed Development/QA/Integration/Production databases for agile development process
• Developed packages, procedures, views, stored procedures using PL/SQL,
• Quest Toad, SQL Navigator
• Developed complex data loading process using various Table Partitions,
• UNIX Shell, and PL/SQL packages
• Tuned complex SQLs, stored procedures, and packages
• Managed the software release process using Jira, SVN, and database
• ANT build scripts
• Developed UNIT TEST process for PL/SQL using Quest Code Tester
• Installed Oracle 10G on Sun Solaris and Windows AMD 64 environments
• Developed cold/hot backup shell scripts for all databases
• Configured Veritas Netbackup to backup databases
• Cloned database from production system

Data Architect/Oracle DBA/Database Development

Confidential, Minneapolis, MN

Responsibilities:

• Re-engineering the existing system and re-modeling the existing system for performance and data quality improvement

• Installed Oracle 10G/Oracle Enterprise Manager on multiple Linux servers
• Developed packages, procedures, views, stored procedures using PL/SQL,
• Quest Toad, SQL Navigator
• Designed and implemented the architecture to streamlined the database development process using ANT build scripts to maximize the productivity for all Java developers
• Tuned complex SQLs, stored procedures, and packages using TKPROF
• Managed the software release process using Jira, SVN, and database
• ANT build scripts
• Developed database backup/disaster recovery scripts using RMAN

Data Architect/Oracle DBA/Database Development

Confidential, Arden Hills, MN

Responsibilities:

• Used TDE 10GR2 to design database encryption

• Used Erwin to design data model to support medical device management system
• Maintained both logical and physical ERD for the whole development cycle
• Installed Oracle database to support the development/QA/Integration team
• Used Oracle PL/SQL to develop stored procedures, functions, triggers, and packages to support Webshpere Java development data creation and data validation efforts
• Developed rule based process to verify the complicated database release process
• Conducted performance benchmark testing between various Oracle technologies to support corporate architecture design requirements
• Developed data creation tool to hide the complexity of data model from developers
• Developed database build process using ANT as the build tool to build database objects and to load testing data

Data Architect/Oracle DBA/Database Development

Confidential, Edina, MN

Responsibilities:

• Led DBA department to support Development, QA, Testing, Architecture, Analytechnic Data Warehouse, and Production database needs

• Used Erwin to design the logical model for more than 200 tables
• Designed physical data model for 7 databases (development, testing, integration, and production)
• Maintained both logical and physical ERD for the whole development cycle
• Tuned multiple SQLs to optimize performance
• Developed multiple database triggers for application auditing