Database administrator-Cincinnati, OH - Georgia IT Inc.
Cincinnati, OH
About the Job
Job Title : Database administrator
Location : Cincinnati, OH
Position Type : Full Time
Interview mode : Phone
Salary + benefits (HealthCare and PTO Etc.)
US Citizen, Green Card and GC EAD only.
No sponsorship available for this job, direct hire and NO 1099 or C2C
(Please include the expected Salary Range)
Job Description:
Location : Cincinnati, OH
Position Type : Full Time
Interview mode : Phone
Salary + benefits (HealthCare and PTO Etc.)
US Citizen, Green Card and GC EAD only.
No sponsorship available for this job, direct hire and NO 1099 or C2C
(Please include the expected Salary Range)
Job Description:
- Responsible for database design, development and administration of large scale Operational, OLTP and Analytical data structures including logical and physical design
- Provide SQL performance tuning on both OLTP and Data warehouse environments.
- Optimize DB2 resource utilization by tuning queries (static and dynamic), recommending indexes, and configuring database parameters
- Provide data migration support
- Work with application team to review the SQLs before production migration.
- Lead, mentor and/or provide guidance to junior DBAs including guidance for troubleshooting escalated issues
- Partner with offshore DBA resources and thoroughly document processes to ensure successful implementation by offshore staff and Production Control
- Provide on-call rotational 24/7 Incident Response to database alerts from production monitoring tools and Command Center personnel
- Analyze Key Performance Metrics and make recommendations for improvements
- Work with IBM and follow-up with PMR tickets.
- Maintain the integrity of data within the production environment including the execution of proper backup and restoration policies and procedures which provide point-in-time restore capabilities (disaster recovery)
- Perform database capacity planning and trend analysis in IDAA
- Deploy database changes in strict accordance with change management policies and procedures
- Interact and coordinate work with System Administrators, Project Managers and fellow team members to support various project requests
Source : Georgia IT Inc.