DB2 Database Administrator for Attorney General's Office, Austin, Tx

Location: Austin, TX, United States
Date Posted: 08-21-2017
DB2 Database Administrator for Attorney General, Austin, Tx

Agency: Texas Office of the Attorney General – Child Support Division (OAG). 
Solicitation Number:  302CSD1811
Primary Work location: ​5500 E. Oltorf Street, Austin, Texas 78741
Hours: Monday through Friday from 8:00 AM through 5:00 PM, excluding State holidays when the agency is closed. 
Submit resume by: August 28 at 12:00 noon
Visa/Contracting Type: W-2 employment with benefits. Must be US Citizen, EAD, or Green Card Holder. No H1-B's, 1099's, or Corp-to-Corp.
Job Description:
All work products resulting from the project shall be considered “works made for hire” and are the property of the OAG.  OAG may include pre-selection requirements that potential Vendors (and their Workers) submit to and satisfy criminal background checks as authorized by the Texas law. OAG will pay no fees for interviews or discussions, which occur during the process of selecting a Worker(s).
The worker will be responsible for installing, configuring, designing, administering, maintaining, developing and implementing policies and procedures to ensure the security and integrity of the agency databases; including patching, upgrading, and installation. This role optimizes the DB2 data environment by keeping databases finely tuned (queries/tables/indexes), by automating incoming and outgoing data feeds, and by troubleshooting any data access problems. Work is accomplished in a highly collaborative environment and independently with a focus on quality and customer service.
  • Resolves database performance issues, database capacity issues, replication, and other distributed data issues
  • Designs, builds, configures, and administers Relational Database Management Systems (RDBMS’s)
  • Supports software developers with database operations including the development of complex SQL, tuning of DML, and the creation of stored procedures
  • Develops strategies configuration, backup/recovery, high-availability, and disaster recovery solutions for DBMS’s on Unix based platforms
  • Troubleshoots existing DBMS’s by monitoring and diagnosing performance related issues
  • Works with Database Architect to deploy and fine-tune test databases for the purpose of production validation.
  • Installs and configures RDBMS software
  • Recommends and coordinates the upgrading and patching DBMS’s
  • Works with other departments to streamline data processe
Years Skills/Experience
4 Experience with IBM DB2 v10.x or above
4 Experience with DB2 LUW
4 Experience working in a UNIX/LINUX environment (including writing shell scripts and commands)
4 Experience with logical and physical database design
4 Experience as a Database Administrator in a Java development environment
4 Experience developing stored procedures, scripting, SQL, and optimizing SQL calls
4 Information technology, database administration, computer system analysis, computer programming, or closely related experience
4 Experience supporting application development teams
4 Considerable knowledge of software development life cycle methodologies
4 Skill in identifying and resolving problems using strong analytical techniques, innovative approaches, and taking initiative in preventing and solving problems
4 Skill in effectively sharing accurate information both orally and in writing
Years Skills/Experience
4 Graduation from an accredited four-year college or university with a Bachelor of Science in Computer Science, Management Information Systems, Engineering, Mathematics, or closely related discipline
4 IBM Certified DB2 10.X DBA LUW
4 Experience in providing technical support for system architecture planning and design
4 Experience in Websphere product stacks and database support
4 Experience with any of the following tools: Rational RequisitePro, Rational ClearCase, Rational ClearQuest, TOAD and InfoSphere Data Architect
4 Proficient in administering and tuning DB2 on AIX environment, and tuning multi-partition and cluster databases
  Experience with the Texas Child Support Program

Debbie Pedigo
Owner, Staffing Consultant
Pedigo Staffing Services
9504 IH35 North, Suite 3012, San Antonio, Tx 78233
210.401.4501 o
210.845.3348 c
We Are Connected
Debbie Pedigo
Senior Staffing Consultant
210.401.4501 o
210.845.3348 c

Pedigo Staffing Services LLC
We Are Connected
this job portal is powered by CATS