TechnoGen
Database Admini
TechnoGen, Atlanta, Georgia, United States, 30383
Title:
Database Administrator (DB2
Location:
Atlanta, GA {Onsite)
Duration:
05 Months
Client
:
State of Georgia
743869 - GA DOL -
Under broad supervision as a DB2 LUW DBA DATABASE ADMINISTRATOR, designs and secures computer databases to store, track, and maintain a large volume of critical business information. SQL Development. Develops database models and coordinates projects.
*On-Site position*
*Local Candidates*
Job Responsibilities: •Experience with planning, documenting and performing upgrades and migration, setting up new database environments. •Develop moderate/complex SQL statement for data migration (ETL process). •Support Application Developers in designing, implementing and testing database changes to support business applications. •Assist Application Developers code efficient SQL statements, review the SQL statements for performance and make recommendations for indexes. •Design and plan upgrade strategies including coordination with system administrators and developer. Upgrade plans must include checklist, milestones, complete checkout, and exercised fallback procedures •Assist other Database Administrators 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.
Qualifications: •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). •One year experience with Relational Data Modeling. •One year experience with Microsoft's Outlook, EXCEL and WORD. •One year experience with Erwin.
Preferred Qualifications: •Experience with Quest's Toad for DB2 LUW,IBM's DataQuant or QMF. •Experience with moderate/complex SQL development •Experience with Unix shell scripts, such as ksh, csh, bash or sh. •Experience with COBOL. •Experience with DBI Software's Performance Suite for DB2 LUW. •Experience with Sql Server, MySQL or Teradata •Experience with Local, State or Federal government.
Database Administrator (DB2
Location:
Atlanta, GA {Onsite)
Duration:
05 Months
Client
:
State of Georgia
743869 - GA DOL -
Under broad supervision as a DB2 LUW DBA DATABASE ADMINISTRATOR, designs and secures computer databases to store, track, and maintain a large volume of critical business information. SQL Development. Develops database models and coordinates projects.
*On-Site position*
*Local Candidates*
Job Responsibilities: •Experience with planning, documenting and performing upgrades and migration, setting up new database environments. •Develop moderate/complex SQL statement for data migration (ETL process). •Support Application Developers in designing, implementing and testing database changes to support business applications. •Assist Application Developers code efficient SQL statements, review the SQL statements for performance and make recommendations for indexes. •Design and plan upgrade strategies including coordination with system administrators and developer. Upgrade plans must include checklist, milestones, complete checkout, and exercised fallback procedures •Assist other Database Administrators 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.
Qualifications: •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). •One year experience with Relational Data Modeling. •One year experience with Microsoft's Outlook, EXCEL and WORD. •One year experience with Erwin.
Preferred Qualifications: •Experience with Quest's Toad for DB2 LUW,IBM's DataQuant or QMF. •Experience with moderate/complex SQL development •Experience with Unix shell scripts, such as ksh, csh, bash or sh. •Experience with COBOL. •Experience with DBI Software's Performance Suite for DB2 LUW. •Experience with Sql Server, MySQL or Teradata •Experience with Local, State or Federal government.