SUMMARY:

• Over 16 years of experience in fast paced agile software development with expertise in database design, development and administration.
• Exceptionally strong PL/SQL, and tuning experience. Comfortable with both Developer and DBA roles.
• Proficient in the architecture, design, development and deployment of enterprise applications, automated functional/performance testing infrastructure/execution, object - oriented frameworks, and client-server systems.
• Highly motivated professional, skillful communicator and excellent team player.
• Proven ability to quickly adapt to new technologies and shifting priorities.

TECHNICAL SKILLS:

Language/Software: SQL, PL/SQL, Perl, SQLPLUS, MS OFFICE, DESIGNER 2000, DEVELOPER 2000, Enterprise Manager 10G Grid Control, Toad, SQLLOAD, VISUAL BASIC, POWER DESIGNER, Erwin, Business Object XI 3.1, DataStage, CSS, PHP

Operating Systems: UNIX, VMS/VAX, Windows 2000/2003/2008/ XP, MS-DOS/WINDOWS

Databases: ORACLE 11G / 10G / 9i / 8i / 7, INGRES, MYSQL, SYBASE, SQL SERVER, POSTGRES

PROFESSIONAL EXPERIENCE:

Confidential, San Francisco, CA

Oracle Engineer

• Developed new Core APIs: Developed new core APIs to retrieve account plan information, invoice details, write off details, and new core APIs to let client to purchase plan/plan unit instances. Added new features/fixed bugs to existing core APIs by developing/modifying Stored procedures, PHP functions and YML file. Tested APIs in rest and SOAP WSTL.
• Developed new web pages in CSR tools to manage dunning process, payment method, create, assign, modify and remove surcharge to account. Fixed display error and back end bugs for the CSR tool web pages by adding new CLOB in database tables, modifying database tables, creating new stored procedures to display data using HTP package, using CSS style and JavaScript to control the elements displayed in web pages.
• Developed patch process to generate prorated invoice for accounts. Debug the patch process and improved the efficiency of the patch process.

Confidential, Arlington, VA

Database Engineer STF

Responsibilities:

• Installed and upgraded DBMS software, installed, configured, and managed all aspects of the Oracle special add-on products like Enterprise Manager System, Data Guard, and SQL Client. Applied security patches.
• Designed, developed, and implemented automated data backup and restoration procedures using RMAN. Used imp/exp utility to refresh DEV/QA database at schema level.
• Write/Modify shell scripts to automate database related jobs.
• Design, implement and test database objects like tables, triggers, functions, procedures and packages for our core applications.
• Troubleshoot and fix any database related issues proactively. Turn and optimize SQL statements using Explain plan, SQL*TRACE, and AUTO TRACE.
• Run Automatic Workload Repository (AWR) and other Oracle diagnostic tools regularly to tune databases.
• Troubleshoot/turn current ETL processes in production database. Analyze current ETL process data flow, modified the process to eliminate redundant steps, use bulk SQL statement, avoid full table scans to optimize ETL processes.
• Develop new ETL processes according to our customer needs. Work with Business Analyst and Application developers, get requirement from customers, design and implement database objects like tables, sequences, functions, triggers, procedures and packages, design and implement materialized views, indexes to optimize SQL statements.
• Use external tables, SQL*LOAD to load data, Use Oracle build-in and user defined Exceptions and UTL FILE to handle process exceptions, Use Records and PL\SQL collections and records to improve the performance.
• Use Wallet to store user password in DB server, use DBMS CYYPTO to encrypt, decrypt sensitive data stored in database, use DBMS METADATA to extract DDL statements from database.
• Unit test all the code in DEV database, Develop detailed build and upgrade documents for production deployment.
• Perform data analyses to support both future design decisions and an assessment of the current systems’ suitability. Perform data analysis for manager team to assess current systems’ abilities and work out solutions to improve systems’ performance.
• Perform data analyses for our customers to make sure the data in our database is consistent with the data in other systems.
• Maintain and develop set of Perl scripts in Unix to load database objects and load data.
• Establish coding standards and name conventions for the database team.
• Provide technical guidance to team members by examples and code reviews.
• Maintain and modify DataStage ETL process for FDIC HR department RAPT project.

Confidential, Spring Field, VA

Database Admin

• Implemented and maintained Oracle PL/SQL procedures, packages, functions for the finance applications.
• Monitored database performance, Monitored database space usage and users activities. Resolved any production database issues.
• Created and maintained Oracle database objects for the finance applications, including tables, table partitions, views and indexes.
• Compiled SQL queries for users. Monitored daily performance and disk space usage. Packaged builder for database releases.
• Monitored and debugged ETL processes. Utilizes analytic function, partition, materialized view, parallel query and bulk load to optimize the process.
• Troubleshoot/tune SQL statements by running AWR/ADDM reports.
• Designed, coded, and tested new ETL processes based on requirements provided.
• Created DOS batch files /Shell scripts which automate various processes at main and remote servers.
• Created knowledge database for finance team by document all the ETL processes including process run time, duration of execution, dataflow, database objects affected, Web reports usage and how to debug and fix common errors.
• Upgrade Oracle RDBMS from 10g to 11i, Applied security patches, Using RMAN to backup the database.

Confidential, Herndon, VA

Senior Database Engineer

Responsibilities:

• Designed and implemented Oracle database solutions that work well within the existing system (web based front end, web server as middle tier, IT Oracle database with Advanced Queuing as back end).
• Created and maintained data architecture to increase the robustness, performance, and scalability of the entire system.
• Collaborated with Marketing Analysts and Project Teams to define and clarify business and technical requirements for enterprise products, such as domain name TLDs, web hosting products, SEO products, SSL, Seals, and other Web presence products.
• Analyzed business requirements, define functional and technical specifications. Work together with Application Developers to optimize solutions that meet requirements for both ends.
• Reviewed and implemented possible optimizations to database design and develop stored procedures, functions, and triggers using indexing, partitioning, CBO hints, parallel executions and analytical functions.
• Worked with System Architects to improve existing OLTP model, reduce transaction cost, and increase overall data through-put. Tune SQL queries and database performance for OLTP and DSS applications;
• Monitored database performance after each production release. Diagnosed and troubleshot performance problems. Worked with Application Developers to identify and solve production issues, and fixed bugs.
• Generated data analysis reports as requested by management using ad-hoc SQL queries. Created and maintained complex reporting procedures utilizing advanced Oracle Analytic Functions.
• Created and maintained the necessary documentations for all databases, data dictionaries, database infrastructure, applications, procedures, packages and reports.
• Implemented key database instrumentation tool sets.
• Set-up database performance bench marks.
• Executed benchmark simulations for critical user cases.
• Reviewed and tuned initialization parameters, memory structure, and physical data layout for optimal performance.
• Worked with Product Specialists and Team Leaders to create an estimation of resources requirement and schedule for individual products.
• Created and maintained tools to simplify database support tasks by extensively using database tools such as TKPROF, Explain Plan, Statspack, Toad and SQL scripts.
• Evaluated and tested new features and functionalities of Oracle products. Participated in establishing coding standards for stored procedures, triggers, and logical and physical database design. Enforced the coding standards within the development team.

Confidential, Herndon, VA

Software Engineer

• Designed and developed the customer-specific features.
• Coded and tested the needed Perl/C code to realize customer needs.
• Customized the OPC.