As a mid/senior Database Administrator (DB2), you will develop, implement, administer, and maintain databases - DB2 with HADR - in Power HA AIX environment. You will ensure the service is up and running 24/7. You will implement data models, database designs, data access and table maintenance codes. You will resolve database performance and capacity issues, and replication and other distributed data issues. You must be a US Citizen to qualify for required clearances.
Work location: Annapolis Junction, MD
What you will do:
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.
Bachelor's degree in a related field with a minimum of 3 years of relevant experience
US Citizenship is a requirement
You should have experience in MOST of these
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.
Ability to write clear documentation of operating procedures, and ability to write detailed specifications.
Required to be on-call and respond in a timely manner.
Better if you have:
IBM AIX Administration
IBM Tivoli Monitoring
IBM Tivoli Storage Manager
Ideal candidate is looking for a learning environment where they can grow their skill set to a World-class level.
Simple Technology Solutions is an EEO/AA employer. All qualified applicants will receive consideration without regard to race, color, religion, sexual orientation, gender, gender identity, national origin, disability status, protected veteran status, or any other characteristic protected by law. Simple Technology Solutions promotes affirmative action for minorities, women, disabled persons, and veterans.
Apply now to have the opportunity to be considered for similar jobs at leading companies in the Seen network for FREE.
Zero stress and one profile that can connect you directly to 1000s of companies.
We’ll take it from there. After you tell us what you’re looking for, we’ll show you off to matches.
Boost your interview skills, map your tech career and seal the deal with 1:1 career coaching.
Join now and Be Seen.