WashingtonRecruiter Since 2001
the smart solution for Washington DC jobs

DB2 DBA

Company: TalTeam
Location: Washington
Posted on: August 3, 2020

Job Description:

Position DB2 DBA Location Washington, DC Job Description Provide day-to-day database support for misson critical applications on DB2 DPF (Database Partitioning Feature) and DB2 HADR (High Availability Disaster Recovery) databases. Rotating 24x7 on-call support responsibility Manage and monitor DB2 HA (High Availability) infrastructure and TSA (Tivoli System Automation) to ensure 24 x7 system availability Design and implement DB2 management functions such as system backup, database reorganization, runstats, etc for HA environment and to maximize system availability and use. Conduct performance tuning and optimization work on multiple DB2 databases tuning SQL and database structures for optimal performance and system throughput. Analyze performance issues and troubleshoot hardware, storage, network and workload for optimization. Install, configure, and manage the full DB2 software stack on AIX environment for HA and maximum performance. Partner with project teams and interact with customers to identify technical solutions for projects and operational issues Provide support for data replication between production site and disaster recovery site Ensure stability of both infrastructure and software stack Provide support for performance testing sytem optimization Work with product vendors (e.g., IBM and EMC) for troubleshooting and collecting traces for enhanced vendor support Other duties as assigned. Technical Skills Bachelor's Degree or equivalent work experience, including 5-10 years of hands-on DB2 UDB experience in an AIX environment Experience installing DB2 and applying DB2 Fixpack upgrades on AIX High Availability (HA) systems (both DPF and non-DPF) Configure, tune and maintain HA using Tivoli System Automation (TSA)High Availability Disaster Recovery (HADR) for database failover and failback support Experience in DB2 SQL performance tuning using tools such as db2advis, db2expln, db2batch, db2exfmt and DSM Configure DB2 Workload Manager (WLM) for load balancing and tuning different workloads (on-line transaction, ad-hoc querry, and batch) Install and set up Q-Replication between databases, MQSeries and handle subscription changes. Configure DB2 backup clients with Tivoli Service Manager (TSM) and EMC DataDomain Boost (DDBoost) for point-in-time backup recovery. Experience with flashcopysnapshot functionality for database cloning and backup Working knowledge of Federation, MultiDimensional Clustering (MDC) and Materialized Query Tables (MQT). Experience with IBM DB2 troubleshooting tools including, but not limited to, db2pd, db2diag, db2inspect, db2dart, db2top, and Data Server Manager (DSM) Experiencewith DB2 data movement and copy utilities such as loadimportexportHigh Performance Unload (HPU) Ability to write and troubleshoot DB2 shellkornperl scripts for automation Working knowledge of scheduling tools such as Control-M and Crontab Experience with database archiving tools such as Optim Data Growth (ODG) preferred Understanding of DB2 BLU and knowledge of when BLU data structures are appropriate for implementation Prior experience supporting Ab Initio, Cognos, HTTP server and Websphere applications. Ability to review and troubleshoot SQL scripts to identify and address performance issues. Software DB2 10.511 LUW Advanced Server Edition, DB2 Extended Enterprise EditionDatabase Partitioning Feature(DPF). AIX 6.17.1, Linux, TSM, TSA, Q-Replication, EMC DDBoost, DataDomain, DSM, shellPerl Scripting, Websphere application Cognos, Sharepoint, Microsoft Office. Best Fit Team Dynamics Sense of urgency given role of database support Open to feedback Independent contributor will partner with developer Self ndash starter and high initiative Interpersonal flexibility Works effectively in high state of change and ambiguitySDL2017

Keywords: TalTeam, Washington DC , DB2 DBA, Other , Washington, DC

Click here to apply!

Didn't find what you're looking for? Search again!

I'm looking for
in category
within


Other Other Jobs


S&T Programmatics Officer (Chantilly,VA)
Description: NGA needs your expertise Seeking an experienced, prior GS-1102 contracting series tradecraft journeymen experienced acquired as either a civilian and /or active duty military to grow the next generation (more...)
Company: National Geospatial-Intelligence Agency (NGA)
Location: Chantilly
Posted on: 08/6/2020

Grocery shopper and delivery driver - Earn extra cash
Description: Help people get what they need while earning extra income. Shipt is a marketplace that provides fresh produce, household essentials, and more from trusted local stores. There''s never been a better
Company: Shipt
Location: Chantilly
Posted on: 08/6/2020

Licensed Practical Nurse (L.P.N.)
Description: Job Description: Licensed Practical Nurse L.P.N. US-VA-Charlottesville Job ID: 2020-6757 Type: Regular Full-Time of Openings: 1 Category: Resident Care Commonwealth Senior Living at Charlottesville (more...)
Company: Commonwealth Senior Living
Location: Charlottesville
Posted on: 08/6/2020


Senior Systems Integrator - Sensor Projects
Description: Business Group Highlights IntelligenceThe Intelligence group provides high-end systems engineering and integration products and services, data analytics and software development to national and military (more...)
Company: Perspecta
Location: Chantilly
Posted on: 08/6/2020

Security Officer - DoD Cleared - Allied Universal
Description: At Allied Universalour Security Professionals assist clients, and the public at large, by providing essential jobs that keep our communities safe and secure. During this time, we need your help more than (more...)
Company: Allied Universal
Location: Leesburg
Posted on: 08/6/2020

AV Specialist Top Secret clearance required
Description: AV Specialist - Top Secret clearance required MIS0000HP Jacobs is seeking a Audio/Visual specialist in Chantilly, VA. Duties will include, but not limited to: Provide systems administrator/AV support (more...)
Company: Jacobs Engineering Group
Location: Chantilly
Posted on: 08/6/2020

Ground Systems - Test Engineer
Description: Description Find your next Systems Test Engineer role and jump-start your career with SAIC We bring together the best minds in the industry to deliver IT excellence and support to solve our Customers'' (more...)
Company: SAIC Corporation
Location: Chantilly
Posted on: 08/6/2020

Attitude Control Subsystems Engineer - TS/SCI Cleared
Description: Description SAIC is seeking anengineer with technical expertise in Spacecraft Attitude ControlSystems to support theVehicle Engineering branch with the Spaceand Launch S amp L Division.S amp L provides (more...)
Company: SAIC
Location: Chantilly
Posted on: 08/6/2020

Lecturer (Faculty Wage)
Description: Job location: Charlottesville, VA Employment Type: Part-time Posted data: 2020-06-15 Req: R0015939 The Department of Mechanical and Aerospace Engineering at the University of Virginia School of Engineering (more...)
Company: University of Virginia
Location: Charlottesville
Posted on: 08/6/2020

Sales Representative - Insurance
Description: Job DescriptionStart your career in an Allstate agency to serve all customers including our growing customer base. Are you looking for a meaningful career in a local business that has national brand support (more...)
Company: Allstate
Location: Leesburg
Posted on: 08/6/2020

Log In or Create An Account