We are seeking a DB2 Database Administrator who will responsible for working with the Application Development team to design, create and update DB2 LUW database objects and be a member of the Database Administration staff. The applications are primarily Java and some COBOL running on Red Hat's Enterprise Linux. You'll assist the Application Development team code efficient SQL statements, review the SQL statements for performance and make recommendations for indexes. You'll document entity types and the relationships between entities with an Entity Relationship Diagram using Erwin. You'll also support the Quality Assurance team with testing applications.
- Support Application Developers in designing, implementing and testing database changes to support business applications.
- Assist Application Developers to code efficient SQL statements, review the SQL statements for performance and make recommendations for indexes.
- Support the Quality Assurance team test applications.
- Assist other Database Administrators to maintain multiple DB2 LUW environments, such as Development, QA, Training, and Production.
- Support Database Administrators and Systems Administrators during patching of operating systems and database systems.
- Document entity types and the relationships between entities with an Entity Relationship Diagram using Erwin.
- Ability to work during non-business hours including weekends and holidays, as needed.
- Five years' experience as a Database Administrator.
- Five years' experience with Structure Query Language (SQL).
- Three years' experience as a Database Administrator on DB2 LUW.
- Three years' experience with Red Hat's Enterprise Linux (RHEL).
- Three years' experience with Relational Data Modeling.
- Three years' experience with Microsoft's Outlook, EXCEL, and WORD.
- One year of experience with Erwin.
- One year of experience with Java programming language.
- Experience with IBM's WebSphere.
- Experience with COBOL.
- Experience with Hibernate.
- Experience with IBM's DataQuant or QMF.
- Experience with Quest's Toad for DB2 LUW.
- Experience with DBI Software's Performance Suite for DB2 LUW.
- Experience with scripting languages, such as Perl or Python.
- Experience with Unix shell scripts, such as ksh, csh, bash or sh.
- Experience with Informatica's Intelligent Cloud Services (IICS).
- Experience with SharePoint.
- Experience with Local, State or Federal government.
Be innovative, energetic, energizing, flexible and eager to learn. Excellent work ethic, attention to detail, ability to work in a highly collaborative, collegial, multidisciplinary fast-paced team environment. Excellent analytical skills with the ability to manage multiple priorities and requests. Excellent communication and interpersonal skills. Ability to work independently and meet requested deadlines promptly.
- Experience as a Database Administrator
- Experience with Structure Query Language (SQL)
- Experience as a Database Administrator for DB2 LUW
- Experience with Red Hat's Enterprise Linux
- Experience with Relational Data Modeling
- Experience with Microsoft's Outlook, EXCEL, and Word
- Experience with Erwin
- Experience with Java programming language
- Experience with COBOL programming language