*Hi Folks,* *Needed a Mainframe DB2 DBA in Nashville, TN* *Must have experience in Q replication.*
*Job Title: Mainframe DB2 DBA* *Duration: Long- Term* *Location: Nashville, TN* *Job Requirements:* • 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 *Warm Regards,* *Mir Ali* *Ph:(925) 973-0000 x 215(Off) | Fax: (408) 273-6002* *Email: m...@allianceit.com <m...@allianceit.com> * _________________________________________ Note: We respect your online privacy. This is not an unsolicited mail. Under Bills 1618 Title III passed by the 105th US Congress this mail cannot be considered spam as long as we include Contact information and a method to be removed from our mailing list. If you are not interested in receiving our e- mails then please reply with a "Remove" in the subject line and mention all the e-mail addresses to be removed with any e-mail addresses, which might be diverting the e-mails to you. I am sorry for the inconvenience if any caused to you. -- You received this message because you are subscribed to the Google Groups "American Vendor--IT Consulting" group. To unsubscribe from this group and stop receiving emails from it, send an email to sap-vendor+unsubscr...@googlegroups.com. To post to this group, send email to sap-vendor@googlegroups.com. Visit this group at https://groups.google.com/group/sap-vendor. For more options, visit https://groups.google.com/d/optout.