Statement of Work:
Technical support services for DB2 Optimization and SQL Performance Tuning.
The Database Administrator will be responsible for overall design and implementation of the DB2 database solution. Analyses proposed design alternatives for future database interfaces and applications. Demonstrates good oral and written communications skills. Works independently or as a member of a team.
Duties:
Job Duty 1 - The data base Administrator will be responsible for overall design and implementation of the DB2 database solution. Designs, develops and implements database applications to accommodate a variety of user needs. Performs data modeling, data access, data integration, database design and implementation. Provides standards and guidelines for the design & development, tuning, deployment and maintenance of DB2 models and physical databases, conforming to the government’s requirements. Designs and creates data architectures and collaborates with peers to translate the solution into logical and physical data models. Provides overview for logical and physical data model development across applications teams. Analyzes and determines informational needs and elements, data relationships and attributes, proposed manipulation, data flow and storage requirements and data output and reporting capabilities. Defines logical attributes and inter-relationships and designs data structures to accommodate database production, storage, maintenance and accessibility. Tests designed applications utilizing database management software or general programming software. Installs, implements and supports systems within the user base. Performs system level database maintenance. Performs optimization and performance tuning of the database environment.
Job Duty 2 - Optimizing interfaces between data sources, load processes, and data services and the databases.
Job Duty 3 - Assisting in performance tuning of components directly accessing the databases (i.e. reports, queries, etc.)
Job Duty 4 - Optimizing database maintenance components, including utilities used to maintain data synchronization with data sources, such as beginning of year and mid-year database conversions.
Job Duty 5 - Analyzing and optimizing database performance through the best use of triggers, stored procedures, indices, constraints, commit points, and database partitions, and database configuration settings.
Job Duty 6 - Detecting and troubleshooting CPU, memory, I/O, disk space and other resource contention.
Skills:
a. Experience in DB2 data base technology and tools
b. Experience in troubleshooting and resolving database integrity issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues etc.
c. Strong knowledge of backups, restores, recovery models, Clustering, Database mirroring, Replication.
d. Experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools.
e. Ability to detect and troubleshoot CPU, memory, I/O, disk space and other resource contention.
f. Strong knowledge of indexes, index management, integrity checks, configuration, patching, how indexes are stored, how they can be created and managed effectively.
g. Knowledge of SQL, SQL fine tuning, and use of stored procedures.
h. Documentation skills for processes and procedures.