Database Administrator

Candidate local to Montgomery, AL, 36130 would be preferred.

Hello,

We at AgreeYa solutions are focused on hiring highly skilled professionals who are excited by the opportunity to make a true impact on their careers as well as on our clients' businesses. We power our client s success and drive our consultants career growth.

We are seeking an experienced and outstanding DB2 LUW Database Administrator for one of our esteemed clients. Kindly have a look at the below JD and reach us with your updated resume.

The job description is as follows:

Job Title :: DB2 LUW Database Administrator

Job Location :: Montgomery, AL, 36130

Position Description ::

• Database Administrator (DBA) responsible for all aspects of database administration and data solutions.
• This role maintains production and non-production DB2 LUW (Windows) version 11.5 data environments and detailed technical components on Hewlett-Packard (HP) physical and virtual servers running Microsoft Windows Server 2012 through 2019 operating systems.
• Managing data environments through competency in complex legacy SQL code modernization and concurrent new development.
• Ability to intelligently organize and document data processes is a must.
• Responsible for standards and design of physical data storage, maintenance, access and security administration.
• Performs backup and recovery on database management systems, configures database parameters, and prototype designs against logical data models, defines data repository requirements, data dictionaries and warehousing requirements.
• This position optimizes database access and allocates/re-allocates database resources for optimum configuration, database performance and cost.
• Must also attend and participate in all assigned project onsite meetings.
• The DBA reports directly to the database manager and may at times report directly to the deputy director.
• The DBA will be required to perform appropriate Change and Incident/Problem Management duties to comply with internal IT policies and procedures.
• Impromptu status reports may be requested at any time and a written weekly report on all assigned tasks/projects will be required.

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.

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.

Experience Preferred ::

• 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 Preferred shall relate to the Skills Preferred section outlined in the Position Details within this requisition request.

Education 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.

Education Preferred ::

• 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.

Additional Information ::

• Professional references may be requested. Location: 100% onsite in Montgomery, Alabama (NO remote work will be considered)

Contact: Vishwesh Rai at AgreeYa Solutions

ABOUT AGREEYA SOLUTIONS:
AgreeYa Solutions is a global provider of software, solutions and services to over 200 large to small organizations in the US, Europe, India, China, Korea, UAE, Singapore and Mexico across various industries. Headquartered in Folsom, California (US) and 6 Global Delivery Centers, AgreeYa s flexible Global but Local approach delivers world class technology and business solutions around Portal and Enterprise Social Collaboration (SharePoint and Social tend), Cloud & Infrastructure (Distend), Mobility (Envelop), Application Development & Management, Product Engineering, Independent Software Testing, IT Staffing (Workforce Solutions) and Risk and Compliance Staffing Solutions.

Along with this end-to-end portfolio of services, AgreeYa leverages mature quality processes based on ISO 9001-2008 and SEI-CMMI standards to become a trusted IT partner for our customers and have been recognized by Gartner as Cool Vendor for Enterprise Mobility; by Sacramento Business Journal as Top Software Companies; by Silicon India as the Top 5 Outsourced Product Development Companies; and by DiversityBusiness.com as Top 500 Diversity-Owned Businesses in the United States with Minority Business Enterprise certification from (NCMSDC)