Junior DB2 DBA

Apply Now
Company: Compnova
Location: Westlake, TX
Date Posted: October 8, 2014
Source: CompNova
This is a junior candidate they are looking for.  So ultimately a person with 2 yrs DB2 experience
	
		 
	
		 
	
		 
	
		 
	
		Job Description:
	
		 
	
		Fidelity Financial Advisor Solutions (FFAS) database administration team is looking to hire a Principal Database Administrator to support FFAS DB2 databases running on z/OS.
	
		 
	
		FFAS Database Administration team provides 24x7 database support and ensuring their availability, performance and security.  
	
		 
	
		Primary Responsibilities:
	
		
			To proactively monitor the database systems and ensure minimum downtime
		
			Maintenance and improvement of databases including upgrade
		
			Performing tuning, including database/query tuning and re-writing SQLs
		
			Database development including writing and reviewing stored procedures and COBOL programs
		
			Backups and recovery including disaster recovery
		
			Replication from DB2 to Oracle using QREP
		
			Database refreshes, data masking and schema patches
		
			Setup and maintain documentation, policies and standards
		
			Provide recommendations for physical database design
		
			Provide strategic direction, evaluation and recommendation of database products
		
			Problem escalation with IBM/vendors as appropriate
		
			Mentor junior ...
This is a junior candidate they are looking for.  So ultimately a person with 2 yrs DB2 experience
	
		 
	
		 
	
		 
	
		 
	
		Job Description:
	
		 
	
		Fidelity Financial Advisor Solutions (FFAS) database administration team is looking to hire a Principal Database Administrator to support FFAS DB2 databases running on z/OS.
	
		 
	
		FFAS Database Administration team provides 24x7 database support and ensuring their availability, performance and security.  
	
		 
	
		Primary Responsibilities:
	
		
			To proactively monitor the database systems and ensure minimum downtime
		
			Maintenance and improvement of databases including upgrade
		
			Performing tuning, including database/query tuning and re-writing SQLs
		
			Database development including writing and reviewing stored procedures and COBOL programs
		
			Backups and recovery including disaster recovery
		
			Replication from DB2 to Oracle using QREP
		
			Database refreshes, data masking and schema patches
		
			Setup and maintain documentation, policies and standards
		
			Provide recommendations for physical database design
		
			Provide strategic direction, evaluation and recommendation of database products
		
			Problem escalation with IBM/vendors as appropriate
		
			Mentor junior members of the DBA team
		
			Work as part of a team and provides 24x7 support with on-call rotation 
	
	
		 
	
		Education and Experience:
	
		 
	
		
			B.S. in Information Systems or related fields
		
			2+ years of DB2 DBA experience on z/OS (Mainframe)
		
			IBM DB2 DBA certification
		
			Experience in managing very large DB2 databases
		
			Expert level skills in Cobol and native scripting
		
			Expert level skills in QREP
		
			Experience using CA Detector and PMON
		
			Experience in Oracle would be a plus
		
			Ability to diagnose and troubleshoot
		
			Experience to work with offshore resources
	
	
		Skills and knowledge:
	
		
			Ability to work effectively at multiple levels of the organization and with multiple project teams
		
			Solid prioritization and project management skills
		
			Self motivated with strong team and interpersonal skills
		
			Good communication and presentation skills
		
			Strong evidence of initiative and follow-through
Show more
Show More

Other jobs you might like

  • Senior Oracle DBA

    NEW

    Citi

    - Irving, TX

    DescriptionSR ORACLE Database Administrator The Oracle Database Administrator would work with GFTS DBA Team and responsible for Administering Oracle Database for ...

    13 hours ago from Citi
  • Member Technical Staff

    Verizon Wireline

    - Irving, TX

    Grow your IT career at one of the leading global technology companies. We offer hands-on exposure to state-of-the-art systems, applications and infrastructures. ...

    6 days ago from Verizon Wireline
  • PeopleSoft Asset Management Functional Senior Associate (6412769)

    NEW

    PwC

    - Dallas, TX

    PwC/LoS Overview: Are you interested in the opportunity to work for an industry-leading firm that services clients that include the Fortune 500, and will give you the ...

    5 hours ago from PwC
  • Need a Data Recovery Service

    NEW

    Private Contract

    - Euless, TX

    Media type(s): PC laptop hard drive. Data type: Personal. Device make and model: HP G-7. Issues: Data is corrupted. Is this an emergency?: No. More info: Windows 8.1 Op ...

    15 hours ago from Thumbtack
  • ORACLE DBA

    Vensiti

    - Fort Worth, TX

    The Database Administrator handles multifunctional database projects. The DBA administers development/test databases. The DBA is primarily responsible for performing ...

    5 days ago from Tech Fetch
  • Oracle Database Administrator

    Citi

    - Irving, TX

    DescriptionThe Oracle Database Administrator is responsible for all activities relating to the design, implementation and maintenance of corporate databases. The DBA role ...

    6 days ago from Citi
  • Data Scientist

    VED Software Services, Inc.

    - Roanoke, TX

    Location Tax Terms - W2 only. No C2C Duration Long term The focus is on Data Visualization and not as much performancecapacity. Data Visualization Analyst (Performance ...

    7 days ago from Dice
  • Oracle DBA

    NEW

    Atlantic Associates Inc.

    - Roanoke, TX

    Senior Oracle Database Administrator The Infrastructure Database Operations team supports a wide variety of applications utilizing Oracle RDBMS back end deployments ...

    1 day ago from Dice
  • Oracle DBA

    Verizon Wireline

    - Irving, TX

    Grow your IT career at one of the leading global technology companies. We offer hands-on exposure to state-of-the-art systems, applications and infrastructures. ...

    18 days ago from Verizon Wireline
  • Need a Data Recovery Expert

    NEW

    Private Contract

    - Hurst, TX

    Media type(s): PC laptop hard drive. Data type: Personal. Device make and model: ispiron. Issues: Clicking or whirring noises coming from device. Is this an emergency?: No.

    15 hours ago from Thumbtack

Show Me More