Here's the profile of our IBM Certified DB2 UDB DBA for your review. He has eleven years of IT experience & has worked as Database Administrator, Designer, Analyst, Data warehousing Developer and Engineer. He has expert level skills in DB2/UDB multi-partitions and Oracle 7.3/8/8i.
He is located at NYC, available immediately & willing to work in NJ/NYC only. Please contact me for further information. Thanks, Hitendra Badrakiya cyberThink Inc. P: 201-984-4940 Ext: 531 F: 908-429-8005 www.cyberthink.com Resume of J R SUMMARY OF EXPERIENCE: * Eleven years of experience in IT as a Database Administrator, Designer, Analyst, Data warehousing Developer and Engineer. * Expert level skills in DB2/UDB multi-partitions and Oracle 7.3/8/8i * Experience in Installation, Configuration, back up, recovery, maintenance, support of DB2/UDB database. * Expert in DB2/UDB Clustering, OLAP, Data Warehousing, Object Oriented Design, Oracle Parallel Server, CORBA and Web-based applications utilizing Java, EJB, JSP and XML. * Proficient in designing, developing and implementing multi-terabyte Data Warehouse and Data Mart Business Intelligence systems. * Proven ability to create, administrate, and migrate; and effectively performance tune over 300 databases on a 24X7 basis in High Availability Clustered and Data Warehouse environments. * Very Strong performance tuning skills in database designing, implementation and post deployment. * Excellent expertise in Logical and Physical relational/dimensional modeling using Erwin 4.x. * Proficient in Data Replication, OLAP, Data Warehousing, Object Oriented Design, Oracle Parallel Server, CORBA and Web-based applications utilizing Java, EJB, JSP and XML. * Lead technical teams. Participated in technical design and analyzing functional requirements and data flows and translating them to data models. * * CERTIFICATIONS: * IBM Certified Solution Expert DB2 UDB DBA 7.x * IBM Certified Specialist DB2 UDB DBA 7.x * Oracle Certified Professional Oracle 8 * Brain Bench Certified Oracle 8 DBA and Oracle 7 DBA * TECHNICAL EXPERTISE: Platforms: IBM PC, MS Windows 2000/ XP, Linux, IBM RS/6000, Solaris, HP, Sun, AIX, Regatta p690 Technologies: DB2/UDB 8.x/7.x/5.x, Oracle 7/8/8i, Sybase 10x, PL/SQL, WebSphere, OEM, Transact SQL, DB Artisan, DB2 Data Joiner, Oracle Replication, DB2/UDB 8.x/7.x/5.x, MS Access, Erwin, Unix Shell Scripts, OAS, SQL*Loader, C/C++, Quest Center, PVCS, SQL, Java, MS SQL Server 6.x/7, Qualix Legato HA, Perl/awk, PowerBuilder, ER/Studio, Oracle DBA Studio, Quest Spotlight, Java Applications: Business Intelligence, Data Warehouse, Data Mart, Telecommunications, E-Commerce, Financial, HRMS, B2B/B2C, Supply Chain, CRM PROFESSIONAL EXPERIENCE: Jan 06 to Present New York Police Department (NYPD) Database Administrator/Data Warehouse Developer NYC Worked as lead DBA and senior data warehouse analyst and developer in team of twelve analysts and developers; assigned to implement Real Time Crime Center for NYPD. This application Extract, Transform and Load data from different subsystems into Data Warehouse and Data Mart. Informatica is used as an ETL tool to Extract, Transform and Load data from flat files and mainframe systems into DB2/UDB ESE databases; installed on IBM Blades and backed by SAN storage. Achievements: Developed, managed and monitored fifteen databases on Production, Testing and Development environments. Effectively Improved ETL jobs and BI reports performance by 50-90% by tuning SQLs by adding correct indexes using DB2 Design Advisor. Designed and developed Informaticas workflows to load data from mainframe and flat files to DB2/UDB databases. Analyzed user requirements to design star schema to implement Data Mart. Developed semi-automated redirect-restore script to support development and testing activities between test and production databases. Performed troubleshooting and provided problem resolution of database issues. Worked with IBM Support to resolve database issues and communicated with them to resolve database and SQL performance issues. Used db2look, db2move, import/export and load utilities to move structure and data between different environments. Designed and developed the METRIC database to capture monitoring information from Database, Applications and Operating System to trouble shoot the application. Wrote shell scripts to take Backup; to run Runstats and Reorg on the tables and indexes. Used DB2/UDB Snapshot and Event monitors to monitor the database for application performance. Worked closely with development and testing teams; and Unix Administrator. Environment: DB2/UDB ESE 8.2, Quest Central, DBArtisan, Cognos, Informatica, Linux SuSE 9, IBM Blades, SAN Storage, Cognos Jan 04 to Dec 05 Verizon Communication Inc Application DBA NYC Worked as a senior member of a team of four Database Administrators and ten ETL Developers assigned to implement three Terabyte Business Intelligence Data Warehouse and Data Mart Application called Network Operations Results Mart (NORM). This application Extract, Transform and Load data from different subsystems of Verizon Communication located in different geographical locations throughout US. DataStage is used as an ETL tool to Extract data from flat files coming from subsystems, then Transform and Load them into DB2/UDB Enterprise Edition with 17 Partitions installed on IBM powerful machine Regatta p690, which is backed by EMC storage. Achievements: Developed, implemented, managed and monitored NORM multi-partitions databases on Development, Testing, Disaster Recovery (DR) and Production environment. Created databases, users, table spaces, tables, views and stored procedures in development, testing and Production environments. Administered & Monitored the DB2/UDB databases and instances using Crontab and UNIX scripts. Managed and Monitored instance and database performance; users and SQL activities on different nodes using Quest Spotlight tool. Performed effective performance tuning of DB2/UDB databases and instances. Effectively Improved ETL jobs performance by 30-50% by tuning SQLs by adding correct indexes using DB2 Design Advisor. Improved the performance of the SQLs with Star Schema joins by adding Replicated Tables on Reference and Dimension tables. Improved the Stored Procedure performance by profiling the stored procedure code and finding out the most expensive piece of code. Implemented companys security policies to secure data and databases from unauthorized access; through user/group access features of DB2/UDB. Developed automated Backup and Restore UNIX script to take Full and Incremental backup and weekly and daily basis for each environment. Developed DR and Production database sync process using DB2HPU and LOAD utility. Data from production is unloaded using DB2HPU and Loaded into DR database. Developed semi-automated redirect restore script to support development and testing activities between System Integration and User Acceptance Testing databases. Developed Reference and Dimension tables backup and sync process between Production, DR and Test databases. Designed and Developed Purge and Archive process to Archive the data then Purge it from large MART and Warehouse tables on basis of entry date. Performed troubleshooting and provided problem resolution of database issues. Worked with IBM Support to resolve database issues and communicated with them to resolve database and SQL performance issues. Used db2look, db2move, import/export and load utilities to move structure and data between different environments. Used db2dart utility to validate database structure and to unload data from corrupted/inaccessible table. Mentored new team members to effectively develop and monitor database systems. Used DB2HPU utility to unload table from compressed backup. Used DB2/UDB Snapshot and Event monitors to monitor the database for application performance. Deployed the database release changes on different databases using SVR5 Packaging. Worked closely with development and testing teams; and Unix Administrator. Environment: DB2/UDB ESE 8.2 with 17 Partitions, DataStage, DB2HPU 2.2, AIX 5.2, Regatta p690, EMC Storage, BCV Split mirror backup Aug 03 to Dec 03 Prudential Inc DB2/UDB DBA Roseland, NJ Worked as a member of a team of ten Senior DBAs assigned to the DBA Technology group to provide DBA support to more than 300 large databases running on Oracle, DB2 UDB, DB2 OS/390, Sybase and MS SQL Server on AIX, Sun Solaris, HP, Linux and Windows NT platforms. These databases interface with Java, Websphere, Web Logic, Tuxedo, JDBC and ODBC. Achievements: Created instances/databases in Development, Testing and Production environment. Managed instances and databases of DB2 UDB EE/EEE on various UNIX platforms. Monitored the DB2/UDB databases and instances improve the over-all database performance. Supported the database backup and restore activities for development and testing groups. Supported development and testing database refresh from Production database. Wrote setup instructions to build tested databases into Production environment. Performed troubleshooting and problem resolution of DB2/UDB databases. Coordinated with vendor support to apply database patches. Used db2look, db2move and import/export utilities to move structure and data between different environments. Worked closely with development and testing groups; and Unix Administrator. Used Remedy to distribute the database changes between different departments. Environment: DB2/UDB 8.x EE/EEE, Websphere Application Server, Remedy ARS, PVCS 7.5, AIX 5.2 June 03 to July 03 Terra Lycos Inc DB2/UDB DBA Worked as DB2/UDB DBA to analyze, design and implement Terabyte Data Mart "Marketing Automation Project (MAP)" in DB2/UDB database. This system loads data into new Data Mart from an existing Data Warehouse, developed in Redbrick. Achievements: Installed and migrated the DB2/UDB instances from DB2/UDB 7.x to 8.x. Planned and implemented the creation of DB2/UDB instances, databases, table spaces, containers and database objects. Loaded billions of records into Fact and Dimension tables from Warehouse to Data Mart. Wrote UNIX scripts to Upsert data into large Fact tables. Designed and managed the start schema in CASE Studio tool. Created Multi Dimension Cluster (MDC) tables for Fact tables. Performed troubleshooting and problem resolution for database environment. Environment: DB2/UDB 7.x/8.x, Solaris, AIX, RedBrick, DB2 Information Integrator Mar 03 to May 03 PeopleSoft Inc Senior DB2 UDB/Oracle DBA Worked as a member of a team of fourteen Senior DBAs assigned to the IT Database Services group to provide DBA support to more than 300 small and VLDB databases running on Oracle, DB2 UDB and MS SQL Server on AIX, Sun Solaris, HP, Linux and Windows NT platforms. These databases interfaced with applications developed on varied platforms using PeopleSoft Application Server, PeopleTool, Java, Web Logic, Web Sphere, Tuxedo, ODBC and JDBC and were actually backend databases to a number of internal Peoplesoft Applications CRM, HRMS, PS Financial and PSynergy. Achievements: Migrated PeopleSoft CRMs Oracle database to DB2 UDB database. Created and maintained Oracle and DB2 UDB instances and databases for various PeopleSoft products. Monitored Oracle and DB2 UDB Instances to improve the over-all database performance using native and third party tools. Oracle and DB2 databases backup and restore on different environment including production, development and testing. Created and maintained DB2 Federated Systems with heterogeneous data sources from different databases (Oracle, DB2, SQL Server) to exchange data between different PeopleSoft applications hosted on muti-platforms. Created and maintained DB2 databases, bufferpool, tablespaces, tables, views and db links. Used db2look, db2move and import/export utilities to move structure and data between databases. Thoroughly tested and quality assured databases migration from Development to Production using detailed activity project plan. Created and sized tablespaces and rollback segments according to data growth and transaction size in Oracle. Defined and updated DB2 configurations parameters according to instance and database tuning requirements. Wrote Unix scripts and defined Cron jobs to monitor Oracle and DB2 instances and databases for failure and disk space utilization; and for table refreshment, export/import, and table/index statistics update. Worked closely with system support to define EMC storage for database servers. Environment: DB2 UDB 7.x, Oracle 7x/8i, DataJoiner, Oracle DBA Studio, Quest Central, WebSphere Application Server, Unix Shell Scripting, AIX, Solaris, HP-Unix May 01 to Feb 03 Aspentech, Inc DB2 UDB DBA / Database Analyst Designed, developed and supported the databases for Aspen Market Place. This E-Business application is being used by the chemical industry to support collaborative supply chain management. The system was developed using IBM E-Business Suites, Net.Commerce, WebSphere Application Server (WAS) and DB2 UDB 7.2/5.2 as RDBMS on an AIX and Linux platforms. Achievements: Analyzed, designed and developed the relational database in DB2. Designed and developed the relational database using Erwin Data Modeler tool. Analyzed and designed the data loaders to load data for catalog contents. Collected the business requirements from client and providing optimal solution. Coordinated with application development team to provide database support in writing and tuning complex queries. Deployed database releases and patches on both staging and production environment. Provided day-to-day troubleshooting support. Created databases, table spaces, containers and users on different DB2 instances. Migrated data from DB2 5.2 to DB2 7.2. Utilized event monitors for performance tuning of DB2 5.2 and DB2 7.2. Wrote Unix Shell Scripts to perform online backups and to monitor the database performance and scheduled using AT/Crontab. Defined the strategies to remove contention of applications accessing DB2. Reviewed and optimized application access to DB2 database. Environment: Net.Commerce, WebSphere Application Server, DB2 UDB 7.2/5.2, Erwin, Unix Shell Scripting, AIX, Red Hat Linux Oct 00 to Feb 01 Genuity, Inc Database Administrator Worked as a member of a team of eight Senior DBAs assigned to the Web Hosting group to install and maintain more than 300 small and VLDB databases running on Oracle, DB2 UDB, Sybase, MS SQL Server and Informix on Solaris, Windows NT and HP UNIX platforms. These databases interfaced with applications developed on varied platforms using Java, CORBA, Broadvision, WebSphere, Cold Fusion, ODBC, JDBC and were actually backend databases to a number of leading e-Commerce / B2B / B2C / Banking Internet sites. Achievements: Installed, created and configured the Oracle databases. Analyzed business needs, database statistics (utlbstat-utlestat), explain plan and recommend database/application modifications and upgrades to customers. Migrated and upgraded the Oracle database servers. Integrated the databases with backup and monitoring scripts. Performed remote Oracle 7/8/8i server and client installation using Exceed/Terminal Service Client. Used highly secured SSH tools to access the remote servers. Provided on call 24X7 support on rotational basis to ensure availability of the databases. Implemented High Availability strategy, standby databases and databases on Qualix (Legato HA) Clusters. Implemented the performance tuning strategies after collecting the database statistics during peak hours. Wrote Cron/AT jobs to monitor Oracle databases on Solaris and NT platform. Implemented and integrated RMAN and Legato backups and monitoring scripts written in Unix Shell and Perl. Provided Level 3 support to customer complaints, queries, change requests, and post-mortem of customer outages and providing customer with tuning and application related recommendations. Utilized Explain Plan, SQL DBA and Server Manager, analysis of Oracle alert files and trace files, listener logs and traces, application of Oracle patches and upgrade of database versions. Provided quotes as well as time and resource estimations for T&M projects. Used Vantive ticketing system to respond to database issues. Worked closely with vendor support, Unix and NT Administrators. Provided basic Sybase and MS SQL Sever databases support. Environment: DB2/UDB 7.x, Oracle 7.x/8.x/8i, MS SQL Server, Sun Solaris, AIX, Windows NT Jan 96 to Oct 00 CresSoft Limited Database Manager/Senior Database Administrator/Database Analyst While acting as Internal Manager of the Database Department, from 10/98 to 10/00: Managed department activities on different projects, team structuring, and interaction with other sections and higher management. Involved in the recruitment, software selection and acquisition process of company. Participated in company management meetings to present progress of database projects status. Involved in resource assignments and management for different projects. Played an important role in achieving ISO9001/TickIT Certification for CresSoft. Optimized the software development process under the ISO/Tick/IT standards. Provided technical database support to different development sections of CresSoft, which included installation and administration Oracle Database Server, Oracle Application Server, and DB2/UDB databases on Sun Solaris and Windows NT. While acting as a Database Analyst/Engineer worked on multiple projects for US based fortune 500 companies, from 01/96 to 10/00: Participated in system analysis and design of CRM, OLTP and OLAP applications. Designed and developed relational data models using Erwin CASE Tools. Wrote stored procedures, triggers to implemented business logic at the back end. Provided DBA support to install and maintain Sybase, SQL Server, Oracle and Oracle Application Server on Windows and Sun Solaris. Led a team of Developers to develop Time Sheet System using PowerBuilder 5.0 and SQL Server 6.5 on a Windows NT platform. Performed project management activities to manage multiple projects. Designed and developed mapping strategies between flat files and tables for data migration. Designed and developed stored procedures to export data to flat files residing on server and developed SQL*Loader control files to import data from flat files residing on client. Optimized SQL queries and used SQL-Station tool to debug stored procedures Created instances, databases, table spaces and users for testing and development teams. Provided DBA support to front-end development teams. Designed and developed specifications, GUIs and performed implementation using PowerBuilder. Projects: Metering & Billing System for PrivaSeek, Inc. USA Training Requirement Forecaster for Northwest Airlines, Inc. USA. Trouble Administration for Customer Service (TACS) for WorldCom Inc. USA Customer Management System for Time Warner Communications Inc. USA Environment: Sybase 10.x, Erwin 3.x, Small Talk 2.0, Sun Solaris, MS Windows, PowerBuilder, 5.0, SQL Server 6.5, Oracle 8/7 EDUCATION: Bachelor in Computer Science (B.C.S.) Degree FAST Institute of Computer Science --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups ".NetIndia" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/TechdotNetIndia?hl=en http://www.satheeshbabu.com http://www.satheeshbabu.blogspot.com/ -~----------~----~----~----~------~----~------~--~---
