Profile/Role Description: Administer, develop, test, and maintain databases. Perform many related database functions across one or more teams or clients, including designing, implementing and maintaining new databases, backup/recovery, performance tuning, and configuration management. Install database management systems (DBMS) and provide input for modification of procedures and documentation used for problem resolution and day-to-day maintenance.
Candidate will be part of the team responsible for administration of a large-scale DB2 mainframe system. Responsibilities include but are not limited to: schema updates, data replication, SQL creation and analysis, integration with JCL and other batch.
Provides high-level database support by verifying databases associated with network tools and solutions function as required. Focuses on establishing the architecture, design, and security of various databases. Provides database support by verifying databases associated with network tools and solutions function as required. Applies expert knowledge of database management systems to coordinate maintenance and changes to database. Provides direction to programmers and analysts as required to affect changes to database management systems.
Essential Duties and Responsibilities
Oversees the preventive and corrective maintenance and incident management measures performed by team members. Provides technical direction and frameworks to meet business needs. Serves as a key representative and subject matter expert on major database initiatives. Determines high-level database structural requirements from a project's inception to its conclusion by working with business stakeholders and identifying optimal database specifications. Ensures that database design and system capabilities meet validated user requirements. Uses complex data mapping, data mining and data transformational analysis tools to design and develop databases. Supports sequencing diagrams and process flow development, data profiling, data analysis, and logical and physical data modeling. Gathers and researches user requirements and liaises with developers and other staff to improve applications and establish standards, best practices and procedures with an ability to document, report issues, and provide resolutions. Maintains knowledge of new tools or technologies, evaluates integration, and makes recommendations based on the capabilities of the existing infrastructure. Creates advanced tests, develops complex databases, and tunes database performance, reviewing database performance trends and identifying opportunities for improvement. Designs large-scale disaster recovery procedures and database backup and recovery plans. Responsible for planning the installation of operating systems, databases, applications, development upgrades, and new releases. Leads the planning and execution of any needed upgrades to software applications and ensures necessary licensing is maintained. Establishes standards, controls and procedures to ensure data integrity and security. Performs capacity planning and projection for future growth. Develops strategies and processes for data implementation, data acquisition, execution, reporting and archive recovery.
Bachelor's Degree required or equivalent relevant experience. Master's Degree Preferred. Candidates may be subject to a government background investigation and must meet eligibility criteria for access to classified information. U.S. Citizenship is required. 15+ years of experience working with progressively more complex or large-scale databases.
Excellent attention to detail and analytical skills. Advanced written and verbal communication skills. Ability to multitask and work well under pressure. Advanced knowledge of database backup and recovery strategies. Experience in developing and maintaining complex database environments. Knowledge of Data Warehouse, Big Data constructs, Business Intelligence and end-user displays. Ability to work with Developers, System Administrators, Architects, and IT Management to plan and size production systems. Extensive experience with DBA productivity and performance tools. Familiar with database concepts and technologies in a cloud environment. Experience with DoD and Federal Government is strongly desired. Advanced knowledge of security network and infrastructure tools, including access control and/or encryption. In depth knowledge of troubleshooting skills and out of the box thinking to overcome data obstacles. Ability to create and maintain connections between databases and data sources. Ability to delegate/split tasks among a team.