SUMMARY

• Database Administrator with 15 years private businesses and government agencies of experience and specialization in database maintenance, data modeling, performance optimization, replication, and migration, secure, recoverable and scalable database solutions, meeting business requirements and user specifications.
• Easily adopter of new product features, tools and techniques.
• Team player and mentor, self - motivated with strong team and interpersonal skills.
• Open and have experience to work in 24x7 shifts.
• 12 years of experience on Z/OS, OS/390, 5 years DB2 UDB

TECHNICAL SKILLS

Hardware: Sun SPARC M4000, IBM 9672, IBM 2066, IBM 2064, EMS SAN

Operating System: Z/OS, OS/390, Solaris, Linux, MVS/ESAMS Windows

Databases: DB2, ORACLE, MySQL, SQL Server, PostgreSQL, MS ACCESS

Language: JCL, SQL, Shell Scripting, PL/SQL, CLIST, C

Software: IBM Data Studio, BMC TOOLS, CATALOG MANAGER, DASD, ERWIN, QMF, SPUFI, OMEGAMON, VISUAL EXPLAIN, DB2 CONNECT, TIVOLY, TSO/ISPF, ABEND-AID, VSAM, JCL,CHECK, JES2,JES3, CA, SDSF, RACF, SYNCSORT, QUEST, MQ, SAS, WebSphere, MS Office

PROFESSIONAL EXPERIENCE

Confidential, San Francisco, CA

Data Analyst

Responsibilities:

• Provide routine and consistent checks to ensure data integrity, correctness, and completeness with Oracle DB
• Effectively performing Integration testing between Web App, WAP and External
• Clients using internal API test tool and XML
• Ability to create users and general system administrative functions
• Designing, implementing the conceptual, logical and physical design for distributed databases (OLAP, OLTP)
• Configuring Query Replication to full testing environmental and compare dates after changes applications
• Create and present data reports, implement customers with statistical summaries using Informatics software
• Testing recovery using NAS technology and TSM software
• Test ETL function on different environment using VMware
• Write summaries to accompany graphs and charts
• Performing test for Marketing and Business teams using reporting tools eSearch and Omniture
• Interacting with Compliance team to execute Certification test with every new product/short code
• Implemented test plans and test cases templates

Confidential

Data Analyst

Responsibilities:

• Responsible Capacity Planning, Database Performance & Tuning, Database Maintenance, Database Backup &Recovery, Data Administration, Logical Design and Modeling, Physical Database Design, Replication
• Installation and administration DB2 on OS390, Z/OS and DB2 UDB on Linux, Windows
• Provide support to System Administration in database installation, upgrade (PTF using SMP/E, Fix Pack)
• Logical and physical database design, data modeling
• Performance tuning using system software and thing tuning with ZPARM
• Optimizing queries to be executed against high volume, high availability OLTP and OLAP
• Database backup & recovery (offline & online backups; full, incremental & Delta incremental)
• Write and optimize SQL, work with Developer Team to SQL tuning
• Data Replication between Data Centers, subsystems, nodes and databases (Data Propagator, QReplication)
• Designing system storage structure and planning future storage requirements (choice, performance and tuning DASD)
• Tuning WLM, performing Databases (Reorg, Runstats, Build and others DB2 Utilities)
• Database monitoring (event monitor outputs, security audit reports, performance report)
• Installing, performing, executing, troubleshooting client applications on Z/OS, Unix, Linux, Windows platforms
• Preparing to migrate databases from zLinux to AIX platform: create plan, organize rules, review application schema
• Tune all Oracle instance components including SQL and PL/SQL
• Control all migrations of Oracle schema objects
• Install maintenance SAS Server on Z/OS and MS Windows. Work with thin, thick clients change codes in Macros, Procedures. Create Map Diagrams, detailed statistical charts and tables
• Production support MS Access Databases. Work with developers to create SQL for business reports
• Monitor systems performance on MS Access and MS Server
• Integrate with SAS team to develop SAS application for ETL processing
• Troubleshooting application writing on code VB, JAVA, C, C++, Cobol, SAS, Assembler
• Create technical documentation and operational instructions
• Management MS Windows Advanced Server 2000/2003

Environment: DB2, DBA, SQL, Windows Server 2000/2003, Linux, Z/OS, OLAP