SUMMARY

• Over 10 years of experience with proven expertise as Enterprise Data Architect and Data warehouse solution designer and expert database administrator.
• Experienced database administrator and design architect in Teradata, DB2 UDB LUW, Oracle 9i/10g and SQL server databases.
• Managed team of DBAs and database application developers, provided support, managed daily tasks, assignments, work distribution and deliveries, status in offshore - onsite project resource structure.
• Data warehouse Solution Architect defining and guiding information architecture strategy providing optimum solution for converting business data into useful information.
• Provide technical architectural solution for Enterprise Business Intelligence and Business performance management principal and analytical data warehouse for decision support system application and design.
• Perform leadership role for enterprise technical architecture team, lead architectural effort to translate business partner’s need to technical solutions.
• Communicate architectural strategic direction and provide an understanding of various technical platforms and applications spanning from data architecture, database design and advance system application design.
• Advocate and follow application design standard and best practice with repeatable process and deliverables. Significant contributor to proof of concepts of new technologies.
• Lead multiple project efforts with team of highly skilled people for optimum solution design and implementation for large business warehouse and analytical as well as operational system.
• Sound knowledge in normalized design techniques, dimensional modeling, star schema and OLAP modeling.
• Worked as Data Architect and Database Design Architect for various RDBMS like IBM DB2 UDB, Teradata, Oracle and SQL server databases. Provided design solution and implementation process guidance to various data warehouse application using software technologies like datastage, Informatica, Ab intio, Microstrategy, Web Focus, BO and Cognos.
• Experience in Database Architect role defining and guiding organization’s data design strategy providing optimum solution use of business data converting it to useful information.
• Seasoned Database Architect and administrator capable in all phases of design, and development and testing involving Data Analysis, Logical and Physical Database Design, physical implementation, capacity planning, SAN Analysis, performance tuning, Testing, Security, backup and recovery, installation and upgrades in UDB DB2 running on Unix, Linux and Windows.
• Sound knowledge in RDBMS design theory, architecture building, Database and application design.
• Have very good understanding on Teradata database parallel architecture including parsing engine (PE), Access Module processor (AMP) and Bynet.
• Strong work experience in designing, implementing and supporting multi terabyte VLDB across data partitions environment in UDB DPF (V8.2, V 9.5 & V 9.7) environment in AIX system and Teradata.
• Experienced working in Data Warehouse & Data Mart requirement analysis, data analysis, logical and physical modeling, design, and development, supporting Business Intelligence applications in Decision Support System (DSS).
• Performed data analysis, Data quality and profiling, guided team to design and develop best data architecture to support large warehouse applications.
• Performed feasibility study along with business users, decided database placement platform, selection of DBMS, data usage, data resource planning, and determined cost estimates of different solutions and approaches.
• Used several quality audit tools, project management tools and experienced in delivering sophisticated software development practice and project management and worked as SOA Architecture and business support .
• Proven expertise to work on multi-person team and projects involving Data architect, Data modeler, ETL architect, Application developer and system administrator to deliver high quality software development project using RDBMS and successfully implemented business critical projects.
• I have led DBA support and maintenance team for UDB DPF databases in DSS environment and highly computing, CPU intensive operational database (OLTP) running .Net and Java applications.
• Defined and developed sophisticated database health report, usage report and performance report for higher management.
• Expertise in advanced SQL programming, proficient in writing complex store procedures and SQL queries, performed heavy query tuning for large and complex queries and rewriting for optimum performance.
• Skilled in writing shell scripts using (KORN & BASH) UNIX and PERL scripting language.
• Provided training and hold many knowledge sharing sessions in order to bring other team members up to the speed.
• Experienced in working in large financial and retail organizations.
• Self starter, enthusiastic and hard working managed successfully working several projects diligently.
• Have strong analytical ability, problem solving capability, project management skills with excellent communication, interpersonal and presentation skills.

TECHNICAL SKILLS

Software/Databases: Teradata (R12 and R13.10), DB2 UDB V9.7, V9.5, V9.1. DB2 UDB V8, DB2 V7.X, DB2 UDB VER 5.X/6.1/7.x (EEE), DB2 UDB EE, DB2 Infosphere, DB2 Connect, Erwin, TSO, ISPF Dialog manager, SPUFI, QMF, Queryman, PLATINUM, DB2 connect, DB2PM, Erwin, ER-Studio, Informatica, Data Stage V8, Power Designer, Autosys, Control-M, SQL Loader, REXX, IMS DB/DC, Microstrategy, Cognos, control center, Control M, Quest central, Tivoli Storage Manager (TSM), CICS V3.1, MS SQL Server 2000, Business Object, Brio, Oracle 9i, Rational Rose

Programming Languages: Assembler, COBOL/ COBOL II, JCL, PL/SQL, SQL, VB, VB++, Java, UNIX Shell Scripting, Ksh/Bash/PERL Shell Scripting, C++

Operating Systems: UNIX, AIX 5.x/4.x, OS 390, MVS XA/ESA, Z/OS, Windows NT Server, Windows 2000, Solaris 2.7/2.6, Linux 2.6

Hardware: Teradata 5625, IBM ® RISC|6000, IBM PC, eServer™, P series ® and power3 ™ processor, Sun E15K and HP servers, p690, RS/6000, IBM Regatta, AS/400, IBM

PROFESSIONAL EXPERIENCE

Confidential - Connecticut

Data Warehouse Solution Architect

Responsibilities:

• Led information management architectural team to design and develop several standards and guidelines for data design best practice.
• Performed analysis and designed template for data profiling guidelines and technique to analyze business data to understand its implication in business intelligence projects and analytical reporting.
• Perform data design, data mapping and data structure design for organizations very large and critical initiative to integrate data center silos and independent data marts into enterprise warehouse creating more visibility of actual business data without redundant duplicated data in various places.
• Worked with ETL technical architect to design better solution of complex ETL process flows and data transformation in order to improve data processing and removed unnecessary data flows simplifying and improving performance cutting down overall ETL processing times making sure more continuity meeting SLAs.
• Worked on multiple projects as Warehouse solution expert and assisted data analysis and data design activities in multiple BI projects and developed process to ensure data quality.
• Designed and develop several art facts for projects which are used to gather business metadata, source system application process flow and data domains.
• Worked with business SMEs and business analyst, BI report analyst to understand true data requirement and align that with organizational direction for a centralized BI strategy and plan.
• Performed analytical business requirement analysis for strategic and tactical decision support applications for enterprise business intelligence.
• Developed and designed data architecture data model using third normal form using tool like CA-Erwin.
• Used concept of super type, Sub type, Associative entities to develop ERD model for base foundational architecture for enterprise warehouse.
• Developed and designed dimensional models using renormalization technique for analytical application for BI reporting for tools like Microstrategy and BO.
• Led research, planning and implementation of new database installations, upgrades and patches.
• Monitor systems capacity for existing requirements and plans for future needs.
• Facilitated root cause analysis on database issues, and communicate issues and resolutions to the production DBAs.
• Established and monitored policies, procedures and standards relating to BI database management, in conjunction with corporate DBA group and Data Warehouse best practices.
• Works closely with application project, systems and BI team leads on all issues related to databases and logical designs.
• Demonstrated a commitment to core values of safety, integrity, process improvement, and customer satisfaction.
• Identify and define critical elements, including how they should be implemented, shared, and used, as well as how to optimize data quality.
• Supplying data warehousing conceptual and logical design consultation attribute specification, and data mapping services.
• Providing logical data warehouse database design and coordination with database analysts during the conversion to physical implementation.
• Offering leadership in developing and maintaining fluid communications with business partners and other data stakeholders to develop data marts/subject areas
• Designed and Developed Physical data model (PDM) using power designer, created and modified and updated Logical data model (LDM) and Physical Data Model (PDM) and performed review and audit of several project logical and implementation model along with Data Architect and DBAs.
• Provided design guidance for some of the weekly and monthly report transitioning to near real time reports, integrated source system data flow with exporting to warehouse and transforming into analytic oriented usable information.
• Performed various knowledge sharing sessions among business intelligence and Data warehouse technical community for better understanding of business intelligence practice and data driven approach using presentation and documentation.

Confidential - MINNESOTA

Database Administrator and Design Architect

Responsibilities:

• Performed Design, install, monitor, maintain, and performance tune database multi environment setting while ensuring high levels of data availability, data integrity for a large enterprise warehouse as large as 100 TB data warehouse in EDW environment in Teradata.
• Maintain current database environments, Maintain database data integrity and recoverability
• Worked as design DBA in business intelligence project designing physical data model from logical data structure and used Teradata database design principal and features to create physical instance of logical structure.
• Designed databases, developed database structure decided surrogate key, primary key, Referential Integrity (RI), primary index, secondary index, table constraint, column default, determine table partition requirement, choosing primary index, deciding USI index and ranges for primary index, DDL implementation, Index design and alter database objects in multi node environment.
• Defined and created database application user roles, estimated spool space usage, perm and temp space requirement for database objects and applications.
• Created and maintained Teradata database, user, tables, views, stored procedure, UDFs, MLOAD scripts and automated collection statistics.
• Designed and implemented Teradata global temporary tables, volatile tables, join index, hash index.
• Develop, implement, and oversee database policies and procedures to ensure the integrity and availability of database.
• Used all of Teradata Utilities Including Fastload, MultiLoad, Fast Export. TDW and Performance Monitoring.
• BAR responsibility (Netvault) for daily and weekly backup.
• Managed technical projects in the BI group by defining and deciding project technical objective, setting tracks for deliverables and milestones, status reports, work distributions, assignments and resource planning and estimates.
• Applied many standard guidelines and best practice for Teradata design for large warehouse environment.
• Create clear and concise documentation in support of databases design and development.
• Manages database design, and advise the DBA group on performance tuning and environment maintenance related to the BI data warehousing.
• Performs performance tuning and capacity planning activities of data warehousing having tables with billions of rows and Terabyte in size.
• Heavily involved in tuning SQL query for Teradata database using Teradata SQL assistant and index advisor and Teradata manager.
• Facilitated root cause analysis on database issues, and communicate issues and resolutions to the production DBAs.
• Provided solution for any database related issues, troubleshoot and responded to any performance related issues.
• Established and monitored policies, procedures and standards relating to BI database management, in conjunction with corporate DBA group and Data Warehouse best practices.
• Works closely with application project, systems and BI team leads on all issues related to databases and physical designs.
• Demonstrated a commitment to core values of safety, integrity, process improvement, and customer satisfaction.
• Writing SQL queries to understand existing tables and their contents.
• Assist developers write and optimize SQL and Teradata database applications.
• Designed and Developed Physical data model (PDM) using power designer, created and modified and updated Logical data model (LDM) and Physical Data Model (PDM).
• Heavily involved in performance tuning for UDB database running on AIX and Solaris.
• Used IBM DB2 data replication method and data propagator for creating innovation space DW environment for special analytical application users.
• Defined best strategy for ETL architecture and worked with ETL architect to design optimum and efficient data extraction, load processes.
• Provided alternate solution for space and time optimization and recommended ELT methodology utilizing DBMS engine over ETL wherever applicable and improved process.
• Saved 100 Gigs of data space in production by applying data and index compression and improved performance.
• Worked closely with large project team consisting Business analyst, Data Architect, data modeler, ETL developer and Architect, Unix admin and implemented successful projects.
• Used DBArtisan, Design Advisor and DB2 Governor, DB2 Performance Experts, Query patroller to enhance query performance and improved throughput.
• Performed data analysis with Data architect and business managers and provided database solution and performed capacity planning and cost estimation for better decision.
• Worked as a team to define data requirement, rule based data purge process using ETL tool Datastage and shell scripts, combined data quality, data integration process, define data granularity and aggregation.
• Applied sound knowledge of ERD and dimensional modeling technique, experience in working with star schema for Data Mart and Data warehouse and good normalization and demoralization concept for removing redundancy and performance and easy accessibility of data.
• Performed primary DBA role in migrating DB2 to version 9.1 to V 9.7 and provided support and troubleshoot problems during migration.
• Applied and supported many DB2 version 9 features line STMM, Compression, auto storage tablespaces, table partition etc.
• Worked closely with application team to develop DB2 application programs and wrote and changed many complex SQL queries, triggers and store procs and functions.
• Involved in tuning heavily performance sensitive queries and tuned several large and complex DSS type queries and rewrite them for best optimal performance.
• Used DB2 connect software to connect Z O/S DB2 server and database from unix server running UDB database.
• Performed performance tuning and connectivity of DB2Connect ESE, DB2Connect Personal edition and unlimited edition.
• Helped team to write and implement several database health scripts, monitor and proactive and reactive maintenance practice using DB2 governor, QP and shell scripts.
• Improved large database backup and recovery strategy in order to meet business SLA of database maximum downtime for disaster recovery.
• Trained and helped to build level -2 support from third party vendor database support team and prepared several standard, best practice and knowledge vault documents for training new team members on-boarding.
• Provided optimum near real time data extraction strategy using IBM CDC (Change Data Capture) real time data extraction tool.
• Provided scripts to extract data from UDB server to load on Teradata database and resolved many data migration issues.
• Determine and resolve locking issues for data load and user access for maximizing concurrency.
• Designed and developed data warehouse using IBM Infosphere Warehouse.
• Performed capacity planning for database, determine SAN required for new implementation or volume growth for existing application.
• Set up backup, reorg, runstats and other database maintenance jobs in AUTOSYS scheduler.
• Performed redirect restore, instance recycle, tune memory parameters, used snapshot monitoring to resolve database related issues and problems.
• Provided 24x7 on-call DBA support and provided DBA support to application team for project implementation on rotation basis.

Confidential - MINNESOTA

Senior Database Analyst and Administrator

Responsibilities:

• Worked as Database design analyst and Administrator for enterprise data warehouse decision support system for Home Mortgage business intelligence application.
• Designed architecture of new of 20 TB database spread across 13 partition databases for lending home mortgage operation on Teradata R 12.
• Performed as primary DBA for supporting and maintaining approx 14 TB Teradata data mart (with MVC compression for large tables) with installed capacity of over 20 TB.
• Supported and maintained many new databases in Teradata and UDB DB2 on AIX and Solaris for capital management and lending securities line of business.
• Performed primary DBA role for VLDB DSS data warehouse database spanning across multiple physical servers in MPP system.
• Performed database support, monitoring and tuning using Teradata manager.
• Designed and Developed Physical data model (PDM) using power designer, created and modified and updated Logical data model (LDM) and Physical Data Model (PDM).
• Designed databases, developed database structure decided surrogate key, primary key, Referential Integrity (RI), table constraint, column default, determine table partition requirement, choosing partition key, DDL implementation, Index design and alter database objects in Teradata database.
• Supported database used for Visual Basic (VB) and .NET programming for operational (OLTP) type of applications.
• Heavily involved in advanced performance tuning for Teradata database.
• Created and maintained Teradata database, user, tables, views, stored procedure, UDFs, MLOAD scripts and automated collection statistics.
• Responsible for successful Teradata database backup (Netvault) at weekly basis.
• Worked closely with large project team consisting Business analyst, Data Architect, data modeler, ETL developer and Architect, Unix admin and implemented successful projects.
• Lead IBM content manager installation and upgrade project as a primary database analyst and DBA to implement various new features of DB2 LUW V9.5 like STMM, Auto storage, Auto configure in OLTP environment.
• Performed database redesign, normalization to reduce redundancy, improve performance.
• Saved 100s of Gigs of disk space of data by table redesigning, defragmenting and reorganizing data.
• Responsible for ensuring proper backup (using Netvault) and availability of Teradata databases.
• Designed and developed several database applications using store procedures, scripting languages, performed database design and tuning.
• Took high level business requirement and worked with business analyst and software developer to discover database related requirement, designed and developed database structures.
• Defined compression strategy for large table using MVC and ALC choosing optimization technique for storage and space savings alternatives.
• Scripted DDLs for Teradata tables, views wrote macros, SPs for Teradata database.
• Monitor database health; verify usage and growth of CPU, space and memory for Teradata and UDB databases.
• Provided support to several databases in a distributed database environment on ORACLE, SQL SERVER, DB2 on Z o/s and UDB LUW.
• Troubleshoot oracle database issues, performance tuning of databases and slow running application queries.
• Executed upgrade, migrate ORACLE and SQL server databases and lead effort from offshore and co-ordinated successful implementation.
• Developed shell script wrapper for executing batch mode SQLs using BTEQ in UNIX environment.
• Wrote automated script for DBQL archival.
• Script for remote triggering of Netvault backup jobs via ssh sessions (cross-platform from MP-RAS Unix to Windows).
• Improved query performance by troubleshooting corrupted index and resolved many application issues by recovering tables from corrupted data.
• Used DBArtisan, Design Advisor and DB2 Performance Experts to enhance query performance and improved throughput.
• I wrote and implement several database health scripts, monitor and proactive and reactive maintenance practice using DB2 governor, QP and shell scripts.
• Performed data analysis with Data architect and business managers and provided database solution and performed capacity planning and cost estimation for better decision.
• Used DSS data modeling concepts and knowledge to design and develop normalized and de-normalized data models and physical database structure.
• Developed several dimensional model (star schema) for data warehouse/data mart (DSS/OLAP) design and ER Model for OLTP database design.
• Worked as a team to define data requirement, rule based data purge process using ETL tool Datastage and shell scripts, combined data quality, data integration process, define data granularity and aggregation.
• Applied sound knowledge of dimensional modeling technique, experience in working with star schema for Data Mart and Data warehouse and good normalization and demoralization concept for removing redundancy and performance and easy accessibility of data.
• Performed primary DBA role in migrating DB2 to version 9.1 FP 3 and provided support and troubleshoot problems during migration.
• Set up new UDB database (DB2 V9.1) environment on new enhanced SAN of 16 TB. Installed database software, fix pack, set up maintenance jobs like backup, reorgs and runstats, process monitor and performance monitor snapshot scripts, audit scripts.
• Supported and maintained UDB database of multi terabyte IN both DSS, Data Marts and in transaction processing system having UDB database V9.1.
• Applied and supported many DB2 version 9 features line STMM, Compression, auto storage tablespace etc.
• Worked closely with application team to develop DB2 application programs and wrote and changed many complex SQL queries, triggers and store procs and functions.
• Involved in tuning heavily performance sensitive queries and tuned several large and complex DSS type queries and rewrite them for best optimal performance.
• Improved and hand tuned backup process of database of 12 TB, reduced backup time by 2 hours.
• Performed several performances tuning on existing SQL queries and store procedures and rewrite many of them. Used index advisor, formatted explain and visual explain utility to tune application query generated using BI tools like microstrategy and cognos and ad-hoc queries.
• Automate runstats, reorgcheck and reorg, backup and recovery processes using shell scripts.
• Implemented high availability solutions like HACMP for VLDB’s and HADR on OLTP databases.
• Used index advisor, formatted explain and visual explain utility to tune application query. Tuned several query generated using Business Object. Wrote many advanced SQL programs and store procs for online database application (operational).
• Worked with data architect for determining business data, identifying system of records data, defining data granularity and aggregation for faster broad base data access for reporting, data navigation and drill down.
• Worked as Business intelligence and Data warehouse core team to determine business intelligence technology strategy and define analytical need for the organization tactical and strategic and operational.
• Sound knowledge in ER Modeling, dimensional Modeling, Data Integration technique and meta data management, Data Quality management.
• Worked closely with business intelligence architect using ETL tool as DataStage and Unix based scripting, provided suggestion and guidance for best solution.
• Designed and developed operational database for OLTP application and used normalization technique to improve performance and reduce redundancy.
• Worked heavily on performance tuning activities and tuned bufferpool, database manager and database configuration parameters and tuned and rewrite several queries.
• Written and modified several shell script using PERL and KORN shell scripts used for reorg, runstats, backup (online & offline) jobs, changed and maintained Crontab scripts.
• Troubleshoot and resolve database problems like load failure, connections issues, lock situation, abnormal tablespace status, backup failure.
• Set up and supported TSM and Netbackup for standard database backup to tape server. Resolved issue related to backup policy and configuration.
• Worked with Teradata Engineers in migrating large multi TB UDB data warehouse to Teradata database. Created and modified migration object list, participated in new schema design, helped to migrate de-normalized design to normalized and vice versa, participated in designing tables in Teradata, defining primary index, partitions etc, Exported database structure, grants and authority scripts for migration.
• Provided scripts to extract data from UDB server to load on Teradata database and resolved many data migration issues.
• Performed capacity planning for database, determine SAN required for new implementation or volume growth for existing application.
• Set up backup, reorg, runstats and other database maintenance jobs in AUTOSYS scheduler.
• Performed redirect restore, instance recycle, tune memory parameters, used snapshot monitoring to resolve database related issues and problems.
• Provided 24x7 on-call DBA support and provided DBA support to application team for project implementation.

Confidential - Florida

Sr. UDB DBA & Architect

Responsibilities:

• Worked as a senior DBA of OLAP EDW database of 6 TB of size spanning across 12 partitions.
• Designed and Developed Physical data model (PDM) using ER Studio, created and modified and updated Logical data model (LDM) and Physical Data Model (PDM).
• Worked in multi database platform and mixed environment with several other senior database architect and SMEs to design and develop multi database cross platform large project.
• Designed databases, created database structure decided surrogate key, primary key, Referential Integrity (RI), table constraint, column default, determine table partition requirement, choosing partition key, DDL implementation, Index design and alter DB2 objects in single partition and multi partition EEE (DPF) environment.
• Performed feasibility study with application developer and business managers and provided database solution and performed capacity planning and cost estimation for better decision.
• Developed several dimensional model (star schema) for data warehouse/data mart (OLAP) design and ER Model for OLTP database design.
• Worked extensively on defining software development life cycle and procedures for business intelligence projects. Worked on data governance and domain determination and maintenance project.
• Worked as a team to define data requirement, rule based data cleaning process using ETL tool informatica, combined data quality an data integration process, define data granularity and aggregation.
• Sound knowledge of dimensional modeling technique, experience in working with star schema for Data mart and Data warehouse and good normalization and demoralization concept for removing redundancy and performance.
• Developed and maintained metadata repository for data warehouse databases.
• As a primary DBA implemented various new features of DB2 LUW V9 like STMM, Auto storage, Auto configure, range partitioning and table compression.
• Tuned and improved performance for database backup and streamlined multi partition database restore operation.
• Worked closely with application team to develop DB2 application programs and wrote and changed many complex SQL queries, triggers and store procs and functions.
• Supported Unix Admin to facilitate various OS level upgrade and software installations of patches and fixes.
• Heavily involved in performance tuning for UDB database running on unix (AIX and Solaris).
• Performed database redesign, normalization to reduce redundancy, improve performance.
• Improved query performance by troubleshooting corrupted index and resolved many application issues by recovering tables from corrupted data.
• Used DBArtisan, Quest tool, Design Advisor and DB2 Performance Experts to enhance query performance and improved throughput.
• Performed several performances tuning on existing SQL queries and store procedures and rewrite many of them. Used index advisor, formatted explain and visual explain utility to tune application query generated using BI tools like microstrategy and cognos and ad-hoc queries.
• Performed capacity planning for very large database, guided application team for SAN analysis and space management and lead design and performance tuning for brand new application database built in house to replace third party vendor software.
• Provided senior DBA level support in migrating several DB2 database to version 9 and troubleshoot any problem related to migration.
• Applied several features of DB2 version 9 like STMM, Compression etc.
• Automate runstats, reorgcheck and reorg, backup and recovery processes using shell scripts.
• Implemented high availability solutions like HACMP for VLDB’s and HADR on OLTP databases.
• Used index advisor, formatted explain and visual explain utility to tune application query. Tuned several query generated using BI tools like microstrategy and cognos.
• Wrote many advanced SQL programs and store procs for online database application (operational).
• Recovered corrupted tables, restored database and helped application team to meet their SLA.
• Worked with data architect for determining business data, identifying system of records data, defining data granularity and aggregation for faster broad base data access for reporting, data navigation and drill down.
• Worked as Business intelligence and Data warehouse core team to determine business intelligence technology strategy and define analytical need for the organization tactical and strategic and operational.
• Sound knowledge in ER Modeling, dimensional Modeling, Data Integration technique and meta data management, Data Quality management.
• Worked closely with business intelligence architect using ETL tool as informatica, DataStage and generated multi stage database for ETL process in OLAP database.
• Designed and developed operational database for OLTP application and used normalization technique to improve performance and reduce redundancy.
• Worked heavily on performance tuning activities and tuned bufferpool, database manager and database configuration parameters and tuned and rewrite several queries.
• Written and modified several shell script using PERL and KORN shell scripts used for reorg, runstats, backup (online & offline) jobs, changed and maintained crontab scripts.
• Worked as a primary DBA in migration of ORCALE 10g third party vendor application to inhouse customized application on UDB v8.1 database.
• Troubleshoot and resolve database problems like load failure, connections issues, lock situation, abnormal tablespace status, backup failure.
• Performed capacity planning for database, determine SAN required for new implementation or volume growth for existing application.
• Implemented incremental backup to improve performance, reduce backup timing and faster disaster recovery.
• Sound knowledge of IBM SAN and EMC.
• Good understanding of AIX system performance tuning.
• Used MQTs and MDCs to meet high performance requirement.
• Performed redirect restore, instance recycle, tune memory parameters, used snapshot monitoring to resolve database related issues and problems.
• Provided on-call DBA support and provided DBA support to application team for project implementation.

Confidential - KY

DB2 UDB DBA

Responsibilities:

• Installation and configuration of UDB DB2 V8.1/V7.1 on AIX, as a DB2 Database Administrator responsible for the performance tuning of applications.
• Involved several database design and architectural activities working directly with data architect involving in physical design and configuration of database.
• Designing and constructing partitioning key, primary key, table constraints (foreign key, check constraint etc), DDL implementation, modification and design of DB2 database objects and used ERWIN tool for database design and configuration.
• Performance tuning activities to manage database manager, database configuration, buffer pool configuration, registry variable configuration.
• Provide support to development, testing and Production Systems.
• Understand and implement star schema with a thorough understanding of FACT tables and dimension tables.
• Performance tuning activities to manage database manager, database configuration, buffer pool configuration, registry variable configuration.
• Supporting the development team and also 24x7 productions on call support.
• Migration of data from various development environments to production.
• Created the MQTs and MDCs after an extensive analysis of the pro’s and con’s
• Understand the SAN layouts and implement it with the help of Storage admins on ESS
• Implemented the backup of database across all partitions to go onto TSM
• Written shell scripts to backup the database across all partitions
• Used Tivoli Work Load Scheduler to kick of the Load jobs and regular DB maintenance jobs across development and production environments.
• Worked with SYSADMIN in writing the Flash Copy scripts to implement it from Staging to production environment
• Created Snapshot monitors and event monitors to regularly check the health of the system.
• Created MDC indexes to get the best performance.
• Created block based bufferpools to get the better performance.
• Created monitors for tablespaces, tables and calculated the Bufferpool hit ratio for various tablespaces.
• Creating and Populating User-maintained Materialized Query Tables.
• Generated database statistics reports using DB2LOOK utility.
• Created EXPLAIN tables and ran the Visual Explain utility on SQL statements.
• Automated the scripts like backup, recovery, runstats etc.
• Used Load utility to load data in partitioned environment.
• Created EXPLAIN tables and ran the Visual Explain utility on SQL statements.
• Used different Data movement utilities like IMPORT, EXPORT and LOAD utilities to load data.
• Performed Reorgchk, Reorg and RUNSTATS as and when necessary to eliminate the defragmentation.
• Developed Backup and Recovery Strategies, completed many backup and restores including redirect restore to a point in time.
• Implemented Union all views with the combination of MDC’s to get the best performance ever from the data ware house.
• Led training for developers and operations staff on DB2 issue resolution procedures to reduce DBA support calls.
• Performed REDIRECT RESTORE solution to transfer full volume data from production to Uat environment to help user debugging data problem.
• Implemented Archival logging and utilized User Exit utility to tape (TSM) or to disk.
• Optimized database performance
• Used Quest Tool to monitor the BufferPools, Tablespaces and Locks to improve the performance.
• Participated in data migration from version 8 to version 8i.
• Performed installation, upgrades and application of patches.
• Installed fix pack 12 on DB2 udb database.
• Allocated and maintained space and data storage needs for database objects.
• Planned the backup and recovery of database objects and monitored the existing backup and recovery procedures.
• Handled database performance analysis and optimization.
• Used DBA tools such as RMAN, STASPACK, SQL Loader, Export, Import and OEM utilities to manage database.

Environment: & Tools:DB2 UDB ESE V7.1,8.1, IBM Regetta, AIX 5.2, Linux 2.6, Tivoli Storage Manager, DB2 Connect, Erwin, DB2 Move, DB2 Utilities, Win NT, Shark - ESS, Oracle 9i

Confidential - CA

Sr. DB2 UDB DBA

Responsibilities:

• Primary DBA for an EDW database, total size 12TB span across 2 physical and 14 logical nodes.
• Designed and Developed Logical and Physical data model (PDM) using ER Studio & Power designer, created and modified and updated Logical data model (LDM) and Physical Data Model (PDM).
• Primary duties include involving physical database design and create physical database structure, deciding partitioning key, primary key, table constraints (foreign key, check constraint etc), DDL implementation, modification and design of DB2 database objects.
• Performed tuning of microstrategy and cognos complex and large SQL queries for BI reporting.
• Tuned existing SQL queries and store procedures and rewrite many of them.
• Developed many new store procedures and web based applications using SQL queries for DB2 database.
• Using Indexes, Views, Triggers, Stored Procedures for updating and cleaning the existing data and also the new data.
• Worked with application team to develop DB2 application programs and wrote and changed many complex SQL queries and store procs.
• Wrote many database utility programs using UNIX shell scripting and Perl language to automate database maintenance processes.
• Performance tuning activities to manage database manager, database configuration, buffer pool configuration, registry variable configuration.
• Used ER-Studio tool for logical and physical design of database in DB2 UDB V8.2.
• Worked in database replication and federation for OLTP applications in distributed environment.
• Determined RDBMS solution and database selection based on the information captured from application team as number of transactions, no of users, current volume of data, database growth rate and database availability requirement.
• Supported the DPF environment with a size of 4 TB, 9 logical nodes and SMP configuration.
• Used KSH and BSH shell to execute runstats, reorg and backup etc.
• Provided DBA support in migration of finance application from ORACLE 9i database to UDB v8.1 database.
• Supported the flash copy and disk mirroring which runs on the EDW.
• Supported and maintained UDB database for SAP application.
• Worked as a SQL SERVER Administrator supporting various SQL SERVER databases.
• Using DTS/BCP to copy data from text file to SQL Server. Maintaining the data, database backups & restoration, backup strategies, scheduling backups.
• Added/Changed Tables, columns, triggers, and T-SQL code.
• Created users roles and views assigned object permissions for database security
• Migrated SQLSERVER database to db2 udb on unix platform.
• Supported and maintained UDB database for ORACLE CRM applications SIEBEL for customer data integration and BI applications.
• Troubleshoot the problems occurring out of the backup/flash copy.
• Performed offline and online backups, restore, redirect restore and roll forward activities and make sure they are complete and successful.
• Monitor usage of temp and swap spaces.
• Restore the production copy to the Remote server, DR testing.
• Make sure the regular jobs are on schedule and always running like, reorg, runstats, backups, purge jobs etc.
• Open PMR’s whenever necessary.
• Implement and upgraded fixpacks whenever needed.
• Mentor developers, tune or rewrite the SQL queries whenever needed, help with application related issues.
• Load the data from production to various other environments as and when needed.
• Support the ETL & BI Reporting team with the daily production issues.
• Implement incremental backup on different production systems.
• Restore the database from incremental backup.
• Use DB2 Information integrator and DB2 cursor load to migrate the database.
• Good understanding of AIX system performance tuning.
• Sound knowledge of various SAN’s like IBM, EMC.
• Strong understanding of database shared memory parameters and tuning memory parameters in DB and dbm cfg.
• Good understanding of tuning various parameters using bufferpool, catalog, package and application hit ratios.
• Resolve various database locking issues, sorting issues and sort overflow issues working directly with application development team.
• Proficient in v8 features like MDC’s/MQT’s etc
• Created Shell scripts for migration of data and automate database maintenance operation.
• Performed DB2 redirected restores as and when needed to copy data from production to QA and test environments.
• Automated the backups, runstats, reorgs, moving the transaction logs and db2diag.log, check the skewing of tables.
• Created snapshot monitors and event monitors to regularly check the health of the system.
• Performance monitoring and tuning the databases configuration parameters and database manager configuration parameters.
• SQL tuning and ran the Visual Explain utility on SQL statements
• Used different data movement utilities like LOAD, EXPORT, IMPORT utilities to load data
• Creation of database, database partitions, bufferpools, tablespaces, tables.
• Created shell scripts for online and incremental backup of the database across all partitions using TSM.
• Supporting the development team and also 24x7 productions on call support.
• Worked in migration project from IBM mainframe to ORACLE CRM Apps (SIEBEL) using ORACLE 9i and 10g.

Confidential

DB2 UDB DBA

Responsibilities:

• Write design specs, security plans, data migration plans, Architecture guidelines.
• Designing and constructing partitioning key, primary key, table constraints (foreign key, check constraint etc), DDL implementation, modification and design of DB2 database objects.
• Data Architecture, Data Modeling, getting specs from business analysts and Marketing groups. Determine scope, project timelines and resources for enterprise class data migrations and re-engineering projects.
• Involved in data mapping and designing of database architecture from IMS hierarchical database system to DB2 UDB relational database.
• Troubleshoot and fix both development and operational systems (Dev/QA and Production)
• Move the company's data infrastructure from early pilots to robust, revenue-generating, operational systems.
• Performance tuning activities to manage database manager, database configuration, buffer pool configuration, registry variable configuration.
• Lead a phased IMS DB to DB2 UDB migration including a major data mapping and clean up.
• Installed and configured UDB EE and EEE on AIX, Linux, Windows NT and Windows 2000.
• Created UDB DB2 Warehouse environment with database sized at 5.5 TB spread across 8 logical partitions on two p690 servers.
• Developed and Implemented an OLTP application with 4000 concurrent users maintaining a few million customer accounts.
• Provided DB2 Support for the Migration of applications to DB2 UDB from other Platform Database to DB2.
• Maintaining logical and physical data models using Erwin.
• Replicating the data from one server to other server, using Data Joiner and storing the backups and archiving the log files from TSM. (Tivoli Storage Manager).
• Worked on TSM and also supported applications on websphere, resolved performance and connectivity issues.
• Installed software, configured and maintained databases boxes.
• Carried out requirement analysis, capacity planning and prepared study document.
• Generated database statistics report and presented to higher management.
• Responsible for Cleaning data and data consistency.
• Physical database design, creation, implementation & maintenance operations (file system mount points & storage parameters) and logical database mapping to physical database (storage calculations, file systems, tablespaces, rollbacks, indexes, data files & logs).
• Database sizing, tablespaces, indexes and log spaces design & implementation work.
• Backup & Recovery procedures Design, Test & implementation using Shell Scripts & SQL.
• Database security & Audit Design, test & implementation.
• Set up DB2 UDB/AIX production and development environments.
• Data modeling (logical and physical data modeling using ERWIN.

Confidential

Graduate Engineer

Responsibilities:

• Co-ordinate and co-operate with major dealers.
• Regular visit to customer site and critical market places.
• Organization of customer meet and presentation of TATA range of commercial vehicles.
• Preparation and maintenance of customer database.
• Service meets organization and vehicle demonstration.
• Report to the Deputy General Manager of commercial business
• Presentation of sales report and activities to the Regional Manager.
• Participated in various management and quality management training like Six Sigma, Kaizen.