*Send available consultants profile at....... **[email protected] <[email protected]>*
*Duration:* 6 months + *Location:* Nashville, TN *Interview Mode:* client will hire off Skype/ phone *NEED A DB2 DBA FOR THE zOS PLATFORM WITH Q REPLICATION EXPERIENCE * · An expert level understanding of Relational Database Management System (RDBMS) fundamentals · Ability to use SQL programming skills to perform data troubleshooting and data manipulation tasks is required · *Q Replication support IS HIGHLY HIGHLY Preferred * · Experience with disaster recovery planning and implementation is required · Strong experience with data profiling, meta-data analysis, data modeling, and relational schema design is required · Expertise in crossing platforms (e.g. – MySQL to Oracle), code migration, database change management and data management through the various stages of the development life cycle is preferred · Experience using third-party database monitoring tools is required · Strong communication skills; including ability to express complex technical concepts effectively, both verbally and in writing is required · Ability to work well with people from many different disciplines with varying degrees of technical experience · Expertise supporting the data repository needs of the IBM product stack · Designs and develops standards for production and test database administration activities · Responsible for the creation of development, staging & production database instances and the migration of those application objects from one environment to another · Responsible for all the performance tuning of the staging and production database instances · Creates clear documentation of operating procedures, database object layout, work flow diagrams and specifications for developed databases · Leads training for technical support and applications staff · Provides guidance to other IT departments concerning database related issues · Designs tools and scripts to assist with data analysis, problem diagnosis, strategic planning and the management of the database and transaction processing environment · Designs, implements, documents and monitors backup/recovery procedures · Develops a methodology for the ongoing assessment of database performance and the identification of problem areas · Develops a security scheme for the database environment, as well as assisting in disaster recovery *Specific Skills and Abilities:* *DB2 Database * - Able to write and profile SQL and REXX. Ability to use SQL programming skills to perform data troubleshooting and data manipulation tasks is required · Minimum seven years experience with DB2z relational databases and high volume transaction processing systems, preferably in a custom software development environment, with at least one year in large data environment of 100 TB of data · Minimum five years providing technical design, development and maintenance of DB2z database environment · Minimum two years leading technical implementation teams · Provides production design, administration and support of large, 24x7 IBM DB2z database environment including determining on call responsibility and unscheduled off-hour support · Provides production design, administration and support of large, 24x7 Oracle RAC database environment, determines on call responsibility and unscheduled off-hour support *Anuj Rai* *Sr. Recruitment Manager* *Zenith tech Solutions* *Desk: 518-621-0048Fax: 518-244-49773 park Hill* *Albany, NY 12204* *Email Id:- [email protected] <[email protected]>* *Gmail:- [email protected] <[email protected]>* *Website:- www.zenithtechsolutions.com <http://www.zenithtechsolutions.com/>*
