Back

Job ID: TT-1007
Job Title: Database Administrator
Location: Annapolis Junction, MD
Clearance: Secret
Travel: None
Description:

Primary Location: Annapolis Junction, MD

Position Description:
Develop, implement, administer, and maintain databases DB2 with HADR in Power HA AIX environment to ensure the service is up and running 24/7 at the company critical system Implement data models, database designs, data access and table maintenance codes. Resolve database performance and capacity issues, and replication and other distributed data issues. Possess familiarity with standard concepts, practices, and procedures within a particular field. Experienced in executing sound judgment to plan and accomplish goals. Perform a variety of tasks and work under general supervision. Typically reports to a project leader or manager.

Responsibilities Include:
• The DB2 will provide technical support for the day-to-day DB2 with HADR in AIX Power HA environment activities of the organization.
• Provide technical Support for chartered projects, e.g. Security Remediation, Disaster Recovery; coordinate changes to DB2 (version 10.5) and DB2 FixPaks in AIX and Linux
• Implement database changes to improve performance and security; plan, coordinate, and implement security measures to safeguard databases.
• Measure database performance and troubleshoot complex database and HADR issues.
• Configure and monitor databases with all project application services.
• Configure and maintain system, user databases and instances in AIX and Linux environment.
• Configure and maintain schemas, table spaces, tables, indexes, buffer pools and logs.
• Configure and manage database backups and recoveries with IBM TSM.
• Provide SQL and script Perl, Shell as project requirement.
• Review project requests describing database user needs to estimate time and cost required to accomplish project.

Qualifications for this position include:
• Experienced in configuration, security, failover, and optimization of databases in high availability environment.
• Experience with various business process and system modeling tools including: Data Flow Diagrams, Process Models, ER Diagrams, Dimensional Data Models, Context Models, Event Modeling, State Modeling, Process Decomposition and Use Case Scenarios.
• Hands-on experience with DB2 with HADR installations, upgrades, configuration, tuning, index creation and performance analysis.
• Experience in planning and implementing fault tolerant and high availability systems.
• Hands-on experience implementing and configuring packaged real-time monitoring and alerting solutions.
• Experience with other performance monitors (e.g. Omegamon).
• Hands-on experience with automation of tools, implementations, scripting and database reporting metrics and reports.
• Heavy SQL experience writing complicated queries from scratch, tuning other’s code, analyzing impacts.
• Experience with SAN storage systems.
• Expertise in backup/recovery/fail-over methods and best practices.
• Excellent written and verbal communication skills. Ability to write clear documentation of operating procedures, and ability to write detailed specifications.
• Must have a “can-do” attitude, work well in a cross-functional environment, must be able to work well without supervision and lead others. Candidate should be a self-starter, quick learner and great team player.
• Possess the ability to prioritize competing priorities and work in a cross-matrix management organization.
• Required to be on-call and respond in a timely manner.

Preferred Skills:
IBM AIX Administration
IBM Tivoli Monitoring
IBM Tivoli Storage Manager
ITIL Certification

Clearance Required: Minimum: Must be clearable Preference: Active Secret Clearance

Education: A Bachelor's degree or equivalent in Computer Science, Information Systems, Engineering, Business, or other related scientific or technical discipline with 3 or more years related professional experience. (Education can be substituted for experience).

Working Hours: 8:00 am-5:00 pm

Experience Required:

• Experienced in configuration, security, failover, and optimization of databases in high availability environment.
• Experience with various business process and system modeling tools including: Data Flow Diagrams, Process Models, ER Diagrams, Dimensional Data Models, Context Models, Event Modeling, State Modeling, Process Decomposition and Use Case Scenarios.
• Hands-on experience with DB2 with HADR installations, upgrades, configuration, tuning, index creation and performance analysis.
• Experience in planning and implementing fault tolerant and high availability systems.
• Hands-on experience implementing and configuring packaged real-time monitoring and alerting solutions.
• Experience with other performance monitors (e.g. Omegamon).
• Hands-on experience with automation of tools, implementations, scripting and database reporting metrics and reports.
• Heavy SQL experience writing complicated queries from scratch, tuning other’s code, analyzing impacts.
• Experience with SAN storage systems.
• Expertise in backup/recovery/fail-over methods and best practices.
• Excellent written and verbal communication skills. Ability to write clear documentation of operating procedures, and ability to write detailed specifications.
• Must have a “can-do” attitude, work well in a cross-functional environment, must be able to work well without supervision and lead others. Candidate should be a self-starter, quick learner and great team player.
• Possess the ability to prioritize competing priorities and work in a cross-matrix management organization.
• Required to be on-call and respond in a timely manner.

Skills Required:

• Experienced in configuration, security, failover, and optimization of databases in high availability environment.
• Experience with various business process and system modeling tools including: Data Flow Diagrams, Process Models, ER Diagrams, Dimensional Data Models, Context Models, Event Modeling, State Modeling, Process Decomposition and Use Case Scenarios.
• Hands-on experience with DB2 with HADR installations, upgrades, configuration, tuning, index creation and performance analysis.
• Experience in planning and implementing fault tolerant and high availability systems.
• Hands-on experience implementing and configuring packaged real-time monitoring and alerting solutions.
• Experience with other performance monitors (e.g. Omegamon).
• Hands-on experience with automation of tools, implementations, scripting and database reporting metrics and reports.
• Heavy SQL experience writing complicated queries from scratch, tuning other’s code, analyzing impacts.
• Experience with SAN storage systems.
• Expertise in backup/recovery/fail-over methods and best practices.
• Excellent written and verbal communication skills. Ability to write clear documentation of operating procedures, and ability to write detailed specifications.
• Must have a “can-do” attitude, work well in a cross-functional environment, must be able to work well without supervision and lead others. Candidate should be a self-starter, quick learner and great team player.
• Possess the ability to prioritize competing priorities and work in a cross-matrix management organization.
Education: A Bachelor's degree or equivalent in Computer Science, Information Systems, Engineering, Business, or other related scientific or technical discipline with 3 or more years related professional experience. (Education can be substituted for experience).


Spread the word: Tweet Share Link In

Back