Senior Database Architect and DB2 Database Administrator Resume Memphis, TN - Hire IT People

SUMMARY

Expert Level Database Architect/DB2 Administrator with extensive experience performing conversions and supporting OLTP and Data Warehousing environments.
Expertise in enterprise architecture with evaluation, design, delivery, and performance of technical solutions to meet business needs.
Years of hands - on experience in systems management, IT strategic planning, customer service, release management, project management, and training.
Adept at communicating across levels, while supporting databases designed to optimize manufacturing, supply chain, finance, sales and distribution, and procurement solutions to help achieve strategic business objectives. Currently open to new opportunities. Expertise includes:
DB2 LUW installations, upgrades, and fix packs.
Informix installations, upgrades, patches, and conversions.
Various flavors of UNIX.
Shell scripting.
Creation and maintenance of database standards.
Tivoli Storage Manager and CommVault.
Refresh of QA and Sandbox environments from Production.
SAP ECC, SCM, BI, and Solution Manager.
Numerous Development Life Cycles; Waterfall to Spiral.
Training/ Coaching Developers and Junior DBAs.
Project Management.
24 x 7 Production Support.

PROFESSIONAL EXPERIENCE

Senior Database Architect and DB2 Database Administrator

Confidential, Memphis, TN

Responsibilities:

DB2 administration including physical/logical design, performance monitoring, maintenance, query analysis and optimization, backup and recovery, DR, replication and migration.
Support all DB2 SAP systems in Sandbox, Development, QA, and Production environments comprising of approximately 60TBytes compressed; ECC, BI/BW, MII, APO, Solution Manager, DBACockPit, DB6CONV, BLU in an SAP BW/BI environment.
Design, creation and maintenance of databases for highly demanding environments.
Replication and Migration of databases across heterogeneous platforms.
Perform all DB2 database maintenance activities such as backup, restore, reorg, runstats, and moving tables to dedicated tablespaces and bufferpools.
Install and configure new DB2 instances; Experience with Upgrades & fixpacks from DB2 LUW Version 8.2 to 9.1 to 9.7 to 10.5.
Pro-actively monitor performance, diagnose problems and tune queries.
Creation and modification of primary database storage structures (tablespaces) and primary objects (tables, views, indexes).
Create and maintain documentation such as Functional design documents, detailed design documents, data flow diagrams, data entity relationships documents for internal projects.
Interface with business analysts & developers with regards to application, logical & physical database design, create and maintain logical entity relationship diagrams, transform logical models into physical data models.
Change instance level and database level configuration parameters for database concurrency, authentication, performance and allowing remote clients accessing server.
Perform capacity planning and analysis and implement required changes on the database server.
Provide 24x7 on-call support to troubleshoot issues with the Production schedule.

Senior Database Administrator

Confidential - Millington, TN

Responsibilities:

Perform database software installations including database creation and configuration.
Database Backup/Recovery of databases, including redirected restores.
Implement a library of homegrown scripts to automate the scheduling and notification of periodic maintenance jobs, including REORG, BACKUP, RUNSTATS, LOAD, IMPORT, etc.
Monitor DB2 UDB processes and logs for any anomalies, provide corrective actions.
Provide assistance to the development team on performance tuning, resolving locking solutions, assist data modeler with SQL scripts.
Implement and test HADR performance for production environments.
Analyze application SQL for performance improvement opportunities and work with DB2 support on problems and questions.
Conversion of data from Informix to DB2 LUW.
Take Snapshots and gathering other information related to the database and the system during stress tests for performance tuning.
24x7 on-call support and problem resolution.

TECHNICAL SKILLS

Operating Systems: AIX, SUN Solaris, HP/UX andother flavors of UNIX.

Hardware: Various IBM physical and virtual servers, SAN EMC/DMX, V7000, Tivoli Storage Manager.

Databases: Informix, DB2 LUW.

Database Tools: Infomatica, SAP DBACockPit, Visual Explain, Erwin.

Web Servers: IBM Websphere.

We provide IT Staff Augmentation Services!

Senior Database Architect And Db2 Database Administrator Resume

Memphis, TN

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship