Beacon Systems, Inc, delivers Program Management, Science, Engineering, and Technology Solutions to Federal, Commercial State, and Local Agencies. We are a subsidiary of Radiant Digital Services. We have a vast portfolio of clients across the country. Our Technology support to many DoD Agencies, NASA, Voice of America, FDA, and State Agencies such as State of FL, RI, MS, ND, VA, and WV extends our delivery of solutions worldwide.
The Database Administrator will serve as the principal line of communication for the project team. The duties and responsibilities of this position are as follows:
Establish, maintain, and apply quality assurance techniques and processes to optimize Common Business-Oriented Language (COBOL) application development efforts;
Analyze and monitor existing mainframe environments for potential improvements and technical guidance;
Conduct performance tuning of the mainframe database environments at the system level, specifically for DB2 and IBM Z Operating System (IBM z/OS);
Participate in annual disaster recovery of the mainframe environment;
Establish and maintain the quality, accuracy, reliability, validity, precision, and integrity of data resources and the information derived from data resources;
Establish format standards for consistent documentation of data resources to ensure a reliable source of information;
Develop metadata regarding entities and data elements representing those entities, including their relationships, origins, meanings, uses, and representation, utilizing online and batch performance tools and data modeling techniques;
Develop and maintain an enterprise data model of the Offender Based Information System (OBIS) DB2 databases;
Assist in analyzing proposed data elements for addition to database structures, assessing their impact on size and performance;
Analyze database operational performance to ensure response time minimums are met, identifying problems early to protect database integrity while maintaining an enterprise data model; and
Collaborate closely with application programming staff on all aspects of data element access required by computer programs, ensuring new elements adhere to desired standards and maintain database integrity.
Minimum Qualifications:
1. Proven experience in developing and maintaining Data Warehouse (DW) architectures;
2. Proficient in building Microsoft Structured Query Language (SQL) and Server Integration Services (SSIS) packages for Extract, Transform, and Load (ETL) processes within the Microsoft SQL DW environment;
3. Experience working with various database management systems, focusing on database design, testing, implementation, maintenance, and administration across multiple platforms; and
4. Proficient in International Business Machines (IBM) Database 2 (DB2) management system, version 11.
Required Qualifications:
The Department is seeking a full-time, on-site Database Administrator
A bachelor s degree from an accredited college or university in Computer Science, Information Systems, Management Information Systems (MIS), Data Processing, or other related field, or four (4) years of equivalent work experience is required. Relevant experience may be substituted for education on a year-for-year basis when applicable.
The Department requires the following experience, skills, and knowledge for this position:
1. A minimum of six (6) years of experience with IBM's DB2 database, including skills in creating, maintaining, optimizing, and modifying DB2 databases;
2. Proficiency in using Computer-Aided (CA) database tools;
3. At least three (3) years of experience working in an Azure environment and utilizing cloud-native databases; and
4. A minimum of five (5) years of prior experience with the Department.
Preferred Qualifications:
The Department prefers the Candidates to have the following experience, skills, and/or knowledge for this position:
1. Supervise a team of DB2 Database Administrators;
2. Knowledge of Azure SQL databases;
3. Knowledge of Data Warehouse techniques and processes;
4. Knowledgeable creating and updating Entity-Relationship Diagrams (ERD) diagrams;
5. Knowledgeable in DB2 upgrade processes; and
6. Five (5) or more years of experience with SQL from version 2012 and higher.
Compensation for roles at Beacon Systems Inc depending on a wide array of factors including, but not limited to, the specific office location, role, skill set, and level of experience. As required by applicable law, BeaconGov provides reasonable range of compensation for this role.
Beacon Systems is dedicated to fostering an inclusive and diverse work environment. We ensure equal employment opportunities for all individuals, regardless of their race, color, religion, gender, national origin, age, disability, or any other legally protected characteristic. Our commitment to being an equal-opportunity employer extends across all aspects of employment, from recruitment and hiring to promotions and benefits. We firmly believe in treating all employees and applicants fairly, based on their qualifications, skills, and performance.
