DB2 Database Administrator

The Company

Founded in 2003, Cambria Solutions, Inc. (Cambria) is a national information technology and management consulting firm headquartered in Sacramento, California, with offices in Los Angeles, California; Olympia, Washington; Jackson, Mississippi; Washington, DC; Tallahassee, Florida; and Atlanta, Georgia.

Cambria builds custom-tailored solutions helping clients successfully deliver their most important projects and solve their most difficult challenges using ingenuity and a distinctly humanized approach, something we like to call HumanGenuity™.

Since its founding, the company has experienced double-digit growth nearly every year. Cambria has been recognized six times by Inc. Magazine as one of the nation’s 5000 fastest-growing private companies, most recently in 2015. Cambria was also selected in 2014 as one of Consulting magazine’s “Seven Small Jewels.”

DB2 Database Administrator (Backend Web Developer) Responsibilities:

• Provides technical leadership and operational expertise at the decision-making level for the implementation, architecture, design, ongoing support and maintenance of DB2 databases and related software tools;
• Acts as the principal DB2 database administrator and technical resource for the design, development, and implementation of multiple DB2 tests databases and related systems;
• Supports object-relational features and non-relational structures (e.g., JSON, XML);
• Designs, develops, and maintains data models utilizing data modeling and code generation tools (e.g., DB2 Data Studio, Erwin Data Modeler, Sparx Enterprise Architect);
• Utilizes available IBM DB2 tools (e.g., QMF and QMF for Workstation, DB2 Administration, Query Monitor, db2top, Recovery Expert, Cloning Tool, Object Comparison Tool) and other supporting tools (e.g., File AID for DB2);
• Creates queries and stored procedures needed to identify and cleanse data incompatibilities between new and old environments;
• Leads specification, capacity planning, monitoring and reporting activities related to database configuration and sizing per project need and expected transaction volumes;
• Performs System Administration, which includes database security, configuration, troubleshooting, performance monitoring, and tuning to address performance issues and improve response times;
• Facilitates direct support to application developers and testers including responding quickly to data refresh requests, reorganizing database structures as needed, and automating scheduled database maintenance at regular intervals to maximize data availability;
• Conducts backup and restore of DB2 databases used to support development and testing, verifies implementation of onsite/offsite backup and recovery strategies, develops recovery procedures, supports recovery of data loss caused by user or system error, and performs offsite disaster recovery as needed;
• Develops utilities to monitor and evaluate data quality. Assist with advanced SQL development guidance and tuning, including creating context relationships and stored procedures and user defined functions;
• Provides first-level support in the DB2 z/OS environments managed;
• Develops and applies policies and procedures relating to database and application security including procedures that authorize, enable, change and withdraw access;
• Develops, documents, and implements flexible, non-restrictive standards, policies, and procedures and ensures compliance for all database platforms and related systems;
• Coordinates testing, install and documentation of new releases and database patches; and
• Develops training criteria, training plans, course design, handouts, and provides training and knowledge transfer to staff.
• Bachelor’s Degree in a related field