Database Administrator 3
Apply NowCompany: Lorven Technologies Inc
Location: Atlanta, GA 30349
Description:
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 Ballolu
Lorven Technologies, Inc.
101 Morgan Lane | Suite 209 | Plainsboro | NJ 08536
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 Ballolu
Lorven Technologies, Inc.
101 Morgan Lane | Suite 209 | Plainsboro | NJ 08536