Database Administrator Resume Profile Gaithersburg, MD - Hire IT People

Database Administrator/Database Developer/Database Architect

More than a decade extensive experience in IT services concentrated on Oracle RDBMS/Database warehouse design, administration and modeling in industry. Hands on experiences in SQL/PLSQL/Shell scripts. Strong mathematical and analytical ability.

OBJECTIVE

To continue with present career path as an Oracle or MySQL Database Architect/Analyst/Developer after relocating to Northern California. Can work remotely from home office or on location in northern California.

TECHNICAL SKILLS AND KNOWLEDGE

Proficient in Erwin Database modeler to build ER-diagram in designing both logical and physical models.
Experience in Oracle database tuning including SQL explain plan, partitioning, index
Proficient in Oracle SQL Plus, PL/SQL, Oracle Developer, OBIEE
Proficient in Oracle security system monitoring via Oracle Enterprise Console
Extensive experience in development of ETL processes in data warehouse construction
Extensive experience in database design using both star/snowflake approach
Extensive experience with Oracle7/8/8i/9i/10g/11g/12c database administration and management in both Sun Solaris and Window based OS
Full cycle development in OBIEE application, including star schema design, RPD construction, analysis and dashboard development.
Hands on experiences in using computer languages including FORTRAN, Basic, VB, C, JAVA, Unix Shell languages, PERL, JMP script.

PROFESSIONAL EXPERIENCE

Confidential

Data Architect

Architecting and designing Oracle data warehouse in Amazon Cloud computer environment.
Designing entity model, logical model and physical model using Erwin modeler.
Developing data transferring plan from staging DB to Production
Developing ETL procedures

Confidential

Senior Data Analytics Engineer

Migrated Oracle Express OLAP Cube's report into Oracle 11g environment using OBIEE
Recycled and reloading Multi dimension Oracle Express Cubes
Deployed ETL work request via Unix environments
Developed OBIEE RPD and their reports
Developed complex SQL queries to meet client need
Developed automated PL/SQL procedures for creating tables with partitions

Confidential

Principal Data Analyst/Oracle Database Developer/Administrator

Architected, designed and developed Oracle DBMS application to assist client contracts and internal research projects
Migrated legacy MS Access database into Oracle DBMS
Configured and installed Oracle database servers in both UNIX and Window based OS
Designed and structured of data warehouse model, developed ETL processes in PL/SQL to transfer data from transaction systems to data warehouse
Performed Oracle database daily administration including data security monitoring, trouble shooting, data loading, data mining, data warehouse, tuning, backup and recovery
Performed Oracle database upgrading, patching and migrating from Oracle 8 to Oracle11g
Established in silico screening platform in assisting drug discovery projects by integrating available bioinformatics and cheminformatics tools and methods
Developed, coordinated and supervised internal web interface development
Provided support for IT, mathematical modeling and statistical analysis
Developed and conducted data processing plan including source-to-target mappings, data collection, data validation, data storing, data analysis including assessment / profiling and statistical data modeling