We provide IT Staff Augmentation Services!

Sql Developer Resume Profile

2.00/5 (Submit Your Rating)

Professional 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

Data Analyst

  • 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

  • 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

Confidential

  • DB2 for OS/390 System Administration, IBM
  • DB2 for OS/390 Database Administration, IBM
  • DB2 for OS/390 System Performance and Tuning, IBM
  • DB2 for OS/390 Application Data Recovery, IBM
  • DB2 for Z/OS, OS/390 System/Disaster Recovery Workshop, IBM
  • DB2 Application Design, IBM
  • DB2 for OS/390 Application Programming, IBM
  • Creating Applications in SAS, SAS
  • School of Management Technology of Efficient Control and Influence , Business School
  • Visual Basic, Sacramento City College
  • Database Management Oracle, Access , Sacramento City College

We'd love your feedback!