Mid-Level Database Administrator - Washington, DC
Remote position with 50% of time at IRS, New Carrollton, MD - this can vary from week to week
Candidates must be a US Citizen or Permanent Resident and have an active MBI.
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.
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.
Suppliers, please note these are the top technical skills that the Buyer feels a candidate MUST have. General knowledge of basic office software such as MS Office Suite as well as good communications skills are a given.
Bachelors/Masters Degree in Computer Science, or related field. Database design and implementation experience with at least 2 years as a DB2 database engineer/administrator in the areas listed below is required. An additional 4 years of related experience may substitute for degree.
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.
NICE TO HAVE SKILLS
Suppliers, please note these are nice to have skills. It does not preclude a candidate who does not possess all or some of these skills from the selection process but this could be used as a differentiator between candidates. •Active IRS Medium Risk MBI
•IRS system and data knowledge experience
NOTE: This position is a combination remote/work at home and work at the IRS office. Depending on the needs of the business, the worker may need to work at the IRS building in New Carrollton, MD 50% of the time. This can vary from week to week.