11 - 15 years experience •
Position Description:Implements and maintains smooth operation and physical design of databases. Conducts performance tuning of indexes and databases in general. Reviews database design and integration of systems, provides backup recovery and makes recommendations regarding enhancements and/or improvements. Maintains security and integrity controls. Formulates policies, procedures, and standards relating to database management, and monitors transaction activity and utilization. Provides actionable recommendations for improvements in application performance after analyzing underlying database-related infrastructure components.
The MDM Database Administrator will report to the MDM Operations Manager. He or she will also work closely with the rest of the EDSC MDM team to support various technical aspects of the MDM project throughout all phases of the Software Development Lifecycle (SDLC).
Roles and Responsibilities:
? Work is performed in the Validation and Production environments, with limited testing and analysis activities conducted in the sandbox environment.
? Documents and maintains database operations and best practices.
? Provides support for database implementation and periodic maintenance releases as required.
? Perform Database maintenance and day to day activities to using data base utility tools.
? Hands on experience coding JCL?s, parameters, load cards for unloads, loads, load dummy etc.
? Ability to run advisory analysis and test candidate indexes to support and suggest query performance.
? Experience using Endevor for JCL builds for version control and change management
? Explain plans for application SQL and provide areas of improvement to the development teams. Performs additional responsibilities as requested or assigned.
? Maintains RDBMS software at appropriate vendor-supported levels.
? Works closely with Central Database Administration team on various items related to reviews, implementation, standards, compliance, operational support, backup and disaster recovery.
Required Education and Experience:
? Bachelor's degree in Computer Science, MIS, related field or equivalent experience.
? 10 plus years of experience in Information Technology with at least last 4years as a DBA in IBM DB2 on Z/OS.
? Demonstrated ability to tune complex database systems at the application, database and system levels.
? Thorough knowledge of and experience with databasesecurity, backup, recovery and archiving.
? Knowledge of and experience with Z/OS operating system, utilities, file system, kernel, memory management & security on RDBMS.
? Knowledge and skills with IBM and third party products to automate and facilitate database management.
? Demonstrated collaboration, facilitation, and cross functional team skills.
? Experience with several RDBMS utility software like TOAD for DB2, BMC, SPUFI, JCL, TSO.
? Must have or obtain within the first 6months of hire, IBM Certified Database Administrator - DB210 for z/OS or DB211 DBA for z/OS.
? Knowledge of IBM DB2 LUW and Oracle database administration at the design, operational and system levels.
? Experience/understanding of Tivoli scheduling tool