Resource Informatics Group
Database Administrator
Resource Informatics Group, Montgomery, Alabama, United States, 36136
Job Title: Database Administrator
Job Location: Montgomery, AL (On-Site Work - Monday - Friday)
Job Duration: Long Term Contract
Skills Required
Candidate must have experience performing standalone installation, adding features to an existing installation and the upgrading of an existing instance of DB2 LUW to different edition or version. Working knowledge of Microsoft Server Manager for maintenance and troubleshooting. Ability to comprehend and author complex and extensive SQL script is a must, with the expectations of maintaining and rewriting legacy processes to accommodate versioning and infrastructure changes. SQL (Structured Query Language) programming skills should be denoted via efficient and effective syntax, acceptable peer code reviews, demonstrable product results, and documentation principles. Candidate should be extremely proficient with Data Manipulation Language (DML) and Data Definition Language (DDL) as well as data management concepts such as normalization, aggregation, concurrency, and data modeling, to include data interchange formats such as JavaScript Object Notation (JSON). Security driven concepts are top priority in all development and applied against standards set by the National Institute of Standards and Technology (NIST) and any internal Departmental policies. Strong expertise in Data Modeling - Logical Modeling, Physical Modeling, Relational Modeling, ER Diagrams, Entities, Attributes, Cardinality, Functions, Views, and Triggers. Candidate must possess superior communication and documentation skills, strong decision making and organizational attributes along with exceptional analytical and problem-solving skills. Candidate will work closely with Project Management, Application Designers, Peer Data Administrators and Project Owners in workflow and business rule discovery, application design assistance, data modeling, and any applicable project related implementation of process controls. Skills Preferred
In Addition to the required skills listed above, the candidate may be required to utilize the following software: Advanced Query Tool (AQT), Quest Toad for DB2, and Redgate SQL Monitor for MS SQL Server and Oracle. They may be asked to assist in the support and maintenance of Microsoft SQL Server 2012 through 2019 data environments, DB2 12.0 z/OS and/or ORACLE systems, therefore skills related to some or all of the software and/or platforms are preferred but are not required. Work Experience Required
Candidate should have 5 to 10 years of experience working with various database management systems in the areas of database design, testing, implementation, maintenance and administration in a multiple platform environment and a required minimum of 5 years of experience in the role of a DB2 LUW (Windows) database administrator. Experience Required shall relate to the Skills Required section outlined in the Position Details within this requisition request.
Education/ Training Required
Bachelor's Degree in: Computer Science, Information Systems, or other related field with supporting work experience related to the Skills Required and Skills Preferred sections outlined in the Position Details within this requisition request.
Please submit candidates with the below requested information: Candidate Full Name: LinkedIn Profile (Must): Last 4 digits SSN: Phone Number: Email ID: Candidate Current location: If H1B, H4 EAD, GC EAD (Please send work authorization copy): If H1B, H4 EAD, GC EAD (Please send Photo ID): Education Details (University Name, Subject, and Completion year): Previous work experience with any State Clients or State of Alabama (yes/No): Interviewed before (OR) Submitted your resume to State of Alabama earlier?
Job Location: Montgomery, AL (On-Site Work - Monday - Friday)
Job Duration: Long Term Contract
Skills Required
Candidate must have experience performing standalone installation, adding features to an existing installation and the upgrading of an existing instance of DB2 LUW to different edition or version. Working knowledge of Microsoft Server Manager for maintenance and troubleshooting. Ability to comprehend and author complex and extensive SQL script is a must, with the expectations of maintaining and rewriting legacy processes to accommodate versioning and infrastructure changes. SQL (Structured Query Language) programming skills should be denoted via efficient and effective syntax, acceptable peer code reviews, demonstrable product results, and documentation principles. Candidate should be extremely proficient with Data Manipulation Language (DML) and Data Definition Language (DDL) as well as data management concepts such as normalization, aggregation, concurrency, and data modeling, to include data interchange formats such as JavaScript Object Notation (JSON). Security driven concepts are top priority in all development and applied against standards set by the National Institute of Standards and Technology (NIST) and any internal Departmental policies. Strong expertise in Data Modeling - Logical Modeling, Physical Modeling, Relational Modeling, ER Diagrams, Entities, Attributes, Cardinality, Functions, Views, and Triggers. Candidate must possess superior communication and documentation skills, strong decision making and organizational attributes along with exceptional analytical and problem-solving skills. Candidate will work closely with Project Management, Application Designers, Peer Data Administrators and Project Owners in workflow and business rule discovery, application design assistance, data modeling, and any applicable project related implementation of process controls. Skills Preferred
In Addition to the required skills listed above, the candidate may be required to utilize the following software: Advanced Query Tool (AQT), Quest Toad for DB2, and Redgate SQL Monitor for MS SQL Server and Oracle. They may be asked to assist in the support and maintenance of Microsoft SQL Server 2012 through 2019 data environments, DB2 12.0 z/OS and/or ORACLE systems, therefore skills related to some or all of the software and/or platforms are preferred but are not required. Work Experience Required
Candidate should have 5 to 10 years of experience working with various database management systems in the areas of database design, testing, implementation, maintenance and administration in a multiple platform environment and a required minimum of 5 years of experience in the role of a DB2 LUW (Windows) database administrator. Experience Required shall relate to the Skills Required section outlined in the Position Details within this requisition request.
Education/ Training Required
Bachelor's Degree in: Computer Science, Information Systems, or other related field with supporting work experience related to the Skills Required and Skills Preferred sections outlined in the Position Details within this requisition request.
Please submit candidates with the below requested information: Candidate Full Name: LinkedIn Profile (Must): Last 4 digits SSN: Phone Number: Email ID: Candidate Current location: If H1B, H4 EAD, GC EAD (Please send work authorization copy): If H1B, H4 EAD, GC EAD (Please send Photo ID): Education Details (University Name, Subject, and Completion year): Previous work experience with any State Clients or State of Alabama (yes/No): Interviewed before (OR) Submitted your resume to State of Alabama earlier?