Database Administrator

Role & responsibilities

DB Admin Support with 5+year of experience ? Key activities: ? Execute routine program walk-throughs prior to all code change releases ? Provide support to development teams, including handling error codes, binding programs to specific schemas, and addressing data integrity issues in the development environment. ? Additional activities may include, physical modeling, logical modeling, and supporting performance issues. ? Enhance SQL performance monitoring and tuning ? Analyze and scan program code changes (e.g. COBOL, DB2 components, etc.) and SQL statements for efficiency, accuracy, and cost optimization ? Provide feedback to development team before deploying to production ? Streamline SDLC process for code releases & Support Development team ? Maintain integrity of development and production environments (approximately 10 environments, 10 schemas) ? Populate development environment from provided flash copies ? Monitor utilities and control of database objects 3. ? Utilize ticketing process and L2 support foundation to handle development issues ? Perform data archiving and quarterly purges. ? SQL performance monitoring and tuning ? Analyze traces and identify programs that have exceeded percentage thresholds for average CPU utilization ? Optimize monitoring of DB2 using Mainview and other tools ? Streamline alert messaging ,Reduce log fatigue,Proactive measurement of scalability and data volume ? Support the documentation of all net new processes and tools developed during the program and establish a centralized knowledge repository to ensure continuity and broader team enablement