Job Details

ID #23700510
State Texas
City San antonio
Job type Permanent
Salary USD TBD TBD
Source Dunhill Professional Search
Showed 2021-12-01
Date 2021-12-01
Deadline 2022-01-30
Category Et cetera
Create resume

IBM-DB2 Sr. Database Administrator

Texas, San antonio, 78205 San antonio USA

Vacancy expired!

IBM-DB2 Sr. Database Administrator

On-Site: San Antonio

US Citizenship Required

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.

Minimum Qualifications/Skills

IBM DB2 Database Management - P4 - Expert IBM DB2 Database Administration - P4 - Expert IBM DB2 SQL - P4 - Expert IBM DB2 Performance Tuning - P3 - Advanced SDLC - P3 - Advanced JCL Development/Test - P3 - Advanced Endevor - P3 - Advanced

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.

Other Job Specific Skills

Syncsort - P2- Proficient Control-M - P2 - Proficient

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

#CJpost

Vacancy expired!

Subscribe Report job