Lorven Technologies
Database Administrator 3
Lorven Technologies, Atlanta, Georgia, United States, 30383
Position: Database Administrator 3
Location: Atlanta, GA (Onsite Role)
Contract
*On-Site position*
*Local Candidates Only*
*Either Webcam (or) In-person Interview
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 Data Quant 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.
Skill
Required / Desired
Amount
of Experience
Experience as a Database Administrator
Required
5
Years
Experience with Structure Query Language (SQL).
Required
5
Years
Experience as a Database Administrator on DB2 LUW.
Required
3
Years
experience with Red Hat's Enterprise Linux (RHEL).
Required
3
Years
Experience with Relational Data Modeling.
Required
3
Years
Experience with Microsoft's Outlook, EXCEL and WORD.
Required
1
Years
Experience with Erwin
Required
1
Years
Experience with Quest's Toad for DB2 LUW,IBM's DataQuant or QMF.
Highly desired
Experience with moderate/complex SQL development
Highly desired
Experience with COBOL
Highly desired
Experience with Local, State or Federal government
Highly desired
Thanks & Regards
Roopesh BalloluLorven Technologies, Inc.101 Morgan Lane | Suite 209 | Plainsboro | NJ 08536Work: 609 840 9417 Extn : 223| Fax: 609-799-4204Email: roopesh@lorventech.com | Web: www.lorventech.com
Location: Atlanta, GA (Onsite Role)
Contract
*On-Site position*
*Local Candidates Only*
*Either Webcam (or) In-person Interview
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 Data Quant 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.
Skill
Required / Desired
Amount
of Experience
Experience as a Database Administrator
Required
5
Years
Experience with Structure Query Language (SQL).
Required
5
Years
Experience as a Database Administrator on DB2 LUW.
Required
3
Years
experience with Red Hat's Enterprise Linux (RHEL).
Required
3
Years
Experience with Relational Data Modeling.
Required
3
Years
Experience with Microsoft's Outlook, EXCEL and WORD.
Required
1
Years
Experience with Erwin
Required
1
Years
Experience with Quest's Toad for DB2 LUW,IBM's DataQuant or QMF.
Highly desired
Experience with moderate/complex SQL development
Highly desired
Experience with COBOL
Highly desired
Experience with Local, State or Federal government
Highly desired
Thanks & Regards
Roopesh BalloluLorven Technologies, Inc.101 Morgan Lane | Suite 209 | Plainsboro | NJ 08536Work: 609 840 9417 Extn : 223| Fax: 609-799-4204Email: roopesh@lorventech.com | Web: www.lorventech.com