MDM Application Database Administrator
General Dynamics Information Technology.com
127k - 155k USD/year
Hybrid
USA VA Home Office (VAHOME), United States
Full Time
Type Of Requisition:
RegularClearance Level Must Currently Possess:
NoneClearance Level Must Be Able to Obtain:
SecretPublic Trust/Other Required:
NACLC (T3)Job Family:
IT Infrastructure and OperationsJob Qualifications:
Skills:
Database Security, Oracle Database Administration (DBA), SQL Query DevelopmentCertifications:
NoneExperience:
8 + years of related experienceUs Citizenship Required:
YesJob Description:
MDM Application Database Administrator
Oversee complex programs that drive impactful mission outcomes for our customers as an IBM Master Data Management (MDM) Application Database Administrator. Here, you’ll see the bigger picture on mission initiatives and where your career can go at GDIT.
MEANINGFUL WORK AND PERSONAL IMPACT:
As a Master Data Management (MDM) Application DBA for the Duplicate Identity Resolution Processing Team (DIRP-II) you will contribute to a fast-paced team responsible for monitoring and maintaining various Oracle production databases at the Defense Manpower Data Center (DMDC). The successful candidate will be responsible for ensuring data integrity and availability of the IBM Infosphere Master Data Management (MDM) database, developing reports, ensuring smooth operation of applications that interact with the MDM database, and working with the team to implement new requirements.
- Lead and Support MDM application database activities
- Collaborate with developers, data analysts, business analysts, and customers to understand and assist in developing requirements and provide technical support as a DBA
- Maintain the MDM databases in accordance with contractual deliverables
Role Requirements / Daily Activities:
- Proactively monitor MDM application database health and take preventive or corrective action as necessary. Areas include:
- Monitor free space in table spaces
- Check log files for database errors
- Check for free disk space and disk usage
- Monitor server resources usage and errors
- Monitor performance and resolve any bottlenecks identified
- Develop transaction analysis reports regarding:
- Transaction volumes by application
- Error – Types and volumes by applications
- Acquire in-depth understanding of the MDM database member tables, dictionary tables, task tables, and algorithm configuration tables
- Demonstrated skills to develop SQL scripts
- Work closely with developers, data analysts, business analysts, and business users to implement new requirements and provide technical support
- Acquire in-depth understanding of the MDM database
- Member tables, dictionary tables, task tables, algorithm configuration tables
- Acquire an in-depth understanding of the MDM algorithm and functional components
- Standardization functions
- Bucketing functions
- Comparison functions
- Generation functions
- Assist with the implementation of Electronic- Identity, Credentialing and Access Management (E-ICAM) for the MDM application
- Manage/oversee migration of MDM database from our current on-premises to OCI Cloud
- Ensure all MDM data management practices adhere to relevant Government standards and regulations
- Implement and monitor MDM security auditing through Wed Application Service (WAS)
- Maintain current knowledge of MDM Infosphere product suite and relevant technologies within the DMDC infrastructure
- Troubleshoot issues identified by users
- Acquire an understanding of DMDC application interactions with the MDM interface and database
- Monitor free space in table spaces
- Check log files for database errors
- Check for free disk space and disk usage
- Monitor server resources usage and errors
- Monitor performance and resolve any bottlenecks identified
- Transaction volumes by application
- Error – Types and volumes by applications
- Member tables, dictionary tables, task tables, algorithm configuration tables
- Standardization functions
- Bucketing functions
- Comparison functions
- Generation functions
WHAT YOU’LL NEED TO SUCCEED - REQUIRED:
Bring your expertise along with a drive for innovation to GDIT. The MDM Application Database Administrator must have:
- Citizenship: US Citizenship
- Security Clearance level: Ability to obtain DMDC Position of Trust
- Certification(s): Meet DOD 8570 Baseline IAT Level II certification (i.e. Security+ CE or higher)
- Education: BA/BS in computer science, information systems, or equivalent related field
- Years’ Experience: 8+ years of relevant experience
- Technical Skills:
- Demonstrated knowledge, experience and proficiency in Oracle and SQL tools, Microsoft Office 365 products, JIRA, and awareness of Department of Defense (DoD) cyber security policies
- Must be a quick learner with medium to high complexity IT systems
- Must be an analytical thinker with excellent communication skills
- Demonstrated knowledge, experience and proficiency in Oracle and SQL tools, Microsoft Office 365 products, JIRA, and awareness of Department of Defense (DoD) cyber security policies
- Must be a quick learner with medium to high complexity IT systems
- Must be an analytical thinker with excellent communication skills
- Location: Position is 100% remote
Desired Qualifications:
- Security Clearance level: DMDC Public Trust
- Certification(s): Security+ CE or higher
- Knowledge of IBM Infosphere Master Data Management Products is highly desired
- Configuring and administering IBM InfoSphere MDM components
- Understanding of IBM InfoSphere MDM architecture and data model
- Knowledge of MDM Websphere Application Server (WAS)
- Previous experience within the DoD and DMDC
- Experience with Cloud (Oracle, AWS, Azure) containerization technologies (e.g., Kubernetes)
- Knowledge leveraging Artificial Intelligence (AI) tools
- Software Development knowledge
- Knowledge of JAVA and UNIX scripting
- Configuring and administering IBM InfoSphere MDM components
- Understanding of IBM InfoSphere MDM architecture and data model
- Knowledge of MDM Websphere Application Server (WAS)
- GDIT IS YOUR PLACE:
- At GDIT, the mission is our purpose, and our people are at the center of everything we do.
- Growth: AI-powered career tool that identifies career steps and learning opportunities
- Support: An internal mobility team focused on helping you achieve your career goals
- Rewards: Comprehensive benefits and wellness packages, 401K with company match, and competitive pay and paid time off
- Community: Award-winning culture of innovation and a military-friendly workplace
- OWN YOUR OPPORTUNITY:
- Explore a career in program management at GDIT and you’ll find endless opportunities to grow alongside colleagues who share your passion for the mission and delivering results.
