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

  • Database Specialist

    Hewlett Packard

    - Plano, TX

    Want to work on something that will fundamentally change an enterprise market? How about building the next generation Contact Center Recording and Big Data Analytics ...

    30+ days ago from Hewlett Packard
  • Senior Oracle DBA

    Citi

    - Irving, TX

    Description * Provide database administration, performance tuning and troubleshooting support for ICG business areas. * The day-to-day responsibilities are to install, ...

    3 days ago from Citi
  • Senior Database Admin - Oracle

    Matrix Resources

    - Southlake, TX

    Our Client is seeking a Senior Database Admin - Oracle for a 6-month contract opportunity located in Southlake, TX. Job Description: Design database structures for new app ...

    8 days ago from Matrix Resources
  • SQL Database Administrator

    Kaztronix

    - Southlake, TX

    Responsibilities Planning, building, implementing, administering, and maintaining SQL SERVER databases in the Commercial Data Systems (CDS) organization. Builds and ...

    30+ days ago from Kaztronix
  • Senior Data Modeler

    NEW

    Smith Hanley Associates LLC

    - Dallas, TX

    Smith Hanley Associates Sr. Data Modeler Dallas, TX area $85,000 - $100,000 salary Contact Nancy Darian at ndarian@smithhanley.com Dallas, TX area company is seeking ...

    20 hours ago from icrunchdata
  • Need data recovery service

    NEW

    Private Contract

    - Hurst, TX

    Media type(s): PC laptop hard drive. Data type: Personal, Business. Device make and model: Hitachi 2.5 inch. Issues: Other (Bad head rack assembly). Is this an ...

    2 days ago from Thumbtack
  • SQL Production DBA (C to P)

    Matrix Resources

    - Plano, TX

    Successful client is seeking a SQL Production DBA for a possible contract to hire opportunity in Plano, TX! The selected DBAs will provide day to day operational support for ...

    9 days ago from Matrix Resources
  • Database Administrator III

    Rose International

    - Allen, TX

    Job Description Location: ALLEN, TX Duration: 0-6 month(s) Pay Rate: $57.90 Job Description Min 8 years of experience as Oracle Database Administrator Current ...

    13 days ago from StartWire
  • Middleware Administrator

    Alleare Consulting

    - Fort Worth, TX

    Middleware Administrator Fort Worth, TX ndash Fulltime The Middleware Administratoris responsible for the design, configuration, integration, installation and maintenance of ...

    6 days ago from Dice
  • Sr MSSQL DBA

    NEW

    Citi

    - Irving, TX

    Description * Monitor system performance, troubleshoot and resolves problems which arise, especially as required to enhance performance or improve the efficiency of the ...

    2 days ago from Citi

Show Me More