Database Administrator
Apply NowCompany: Tata Consultancy Services
Location: Columbus, OH 43230
Description:
Mainframe DB2 System DBA
Ability to manage a multi-DB2 Data Sharing / Sysplex environment
Manage DB2 disaster recovery requirements and provide event support
Proficiency in DB2 Systems Performance Tuning and Capacity Planning
Proficiency in application related performance and tuning, access path analysis including extensive SQL coding tuning
Proficiency in the use of DB2 monitoring tools (DB2PM, Insight, OMEGAMON, Detector, RMF other)
Logical and physical database design skills
Knowledge and understanding of an SDLC development lifecycle
Working knowledge of application development/debugging tools (Data Studio, Visual Explain, etc.)
REXX, HTML and/or java coding ability
Perform database refreshes or clones upon request
Support data import or export requests as required
Create copies of data or databases as requested
Create and maintain database links
Plan table space reorganizations
Execute table space reorganizations on a scheduled basis
Monitor and manage database space (add data files as needed)
Maintain database inventory
Create database indexes as requested by Customer
Create and manage database and metadata profiles
Configure and manage database audit profiles
Perform database restores or recovery from export dumps or backups, archived logs or SAN
Create, refresh development, test and staging databases from production data
Implement database data definition requirements for applications (e.g., IMAC for tables, triggers, attributes, stored procedures)
Maintain documentation for all database instance parameters and system settings
Implement database data definitions for applications and developer schemas
Define and execute database start up, shutdown, performance monitoring and tuning scripts, and keep database running at defined service levels for the required workload
Implement and administer appropriate database management Tools across all database instances. Performance metrics and historical data must be available for trending and reporting in order to meet Customer requirements
Proactively identify and remediate bottlenecks (e.g., locking conflicts, latch contention, rollback requirements) for all database instances
Resolve locking conflicts, latch contentio n, rollback requirements, problematic SQL, processes, etc., for all database instances
Proactively monitor databases and report Incidents to the Service Desk
Open, track, and manage to Resolution all database Incidents and Problems
Import new versions of database code components supplied by application support and allow for rollback of data
Patch database Software as needed according to development to QA to production life cycle, and provide one annual new version release update and unlimited minor patches and emergency releases, as necessary
Execute Customers database backup and recovery policies
Execute performance testing, database tuning, and threshold activities for both ongoing and project work
Periodically run Tools to determine and validate database integrity
Support database user ID administration
Implement database security per design
Provide security administration, including Service Requests, managing role and End User database permissions in accordance with Customer Policies
Maintain consistent database parameters and system settings across all like instances according to Customer-approved development-to-quality assurance-to-production life cycle, including security and data privacy
Collaborate with Customer in penetration test activities and perform database tuning to mitigate security risks identified in penetration test activities
Salary Range- $100,000-$120,000 a year
#LI-CO1
#LI-SN1
Ability to manage a multi-DB2 Data Sharing / Sysplex environment
Manage DB2 disaster recovery requirements and provide event support
Proficiency in DB2 Systems Performance Tuning and Capacity Planning
Proficiency in application related performance and tuning, access path analysis including extensive SQL coding tuning
Proficiency in the use of DB2 monitoring tools (DB2PM, Insight, OMEGAMON, Detector, RMF other)
Logical and physical database design skills
Knowledge and understanding of an SDLC development lifecycle
Working knowledge of application development/debugging tools (Data Studio, Visual Explain, etc.)
REXX, HTML and/or java coding ability
Perform database refreshes or clones upon request
Support data import or export requests as required
Create copies of data or databases as requested
Create and maintain database links
Plan table space reorganizations
Execute table space reorganizations on a scheduled basis
Monitor and manage database space (add data files as needed)
Maintain database inventory
Create database indexes as requested by Customer
Create and manage database and metadata profiles
Configure and manage database audit profiles
Perform database restores or recovery from export dumps or backups, archived logs or SAN
Create, refresh development, test and staging databases from production data
Implement database data definition requirements for applications (e.g., IMAC for tables, triggers, attributes, stored procedures)
Maintain documentation for all database instance parameters and system settings
Implement database data definitions for applications and developer schemas
Define and execute database start up, shutdown, performance monitoring and tuning scripts, and keep database running at defined service levels for the required workload
Implement and administer appropriate database management Tools across all database instances. Performance metrics and historical data must be available for trending and reporting in order to meet Customer requirements
Proactively identify and remediate bottlenecks (e.g., locking conflicts, latch contention, rollback requirements) for all database instances
Resolve locking conflicts, latch contentio n, rollback requirements, problematic SQL, processes, etc., for all database instances
Proactively monitor databases and report Incidents to the Service Desk
Open, track, and manage to Resolution all database Incidents and Problems
Import new versions of database code components supplied by application support and allow for rollback of data
Patch database Software as needed according to development to QA to production life cycle, and provide one annual new version release update and unlimited minor patches and emergency releases, as necessary
Execute Customers database backup and recovery policies
Execute performance testing, database tuning, and threshold activities for both ongoing and project work
Periodically run Tools to determine and validate database integrity
Support database user ID administration
Implement database security per design
Provide security administration, including Service Requests, managing role and End User database permissions in accordance with Customer Policies
Maintain consistent database parameters and system settings across all like instances according to Customer-approved development-to-quality assurance-to-production life cycle, including security and data privacy
Collaborate with Customer in penetration test activities and perform database tuning to mitigate security risks identified in penetration test activities
Salary Range- $100,000-$120,000 a year
#LI-CO1
#LI-SN1