SUMMARY

• 20+ years of IT industry experience as Lead DBA, Sr. DBA, Asst Manager with the challenges of Managing the team, Database Administration, System administration, Case Study, Analysis, Design and Programming.
• 15+ years’ experience with Database Administration including Database Replication - HDR
• DBA experience with large database (Terabytes fragmented across multiple disks)
• Unix Administration (HP & Sun) and shell scripting experience
• Excellent Communication, Organizational and Interpersonal skills.
• Hard working, enthusiastic, team player who is also able to work independently.
• Multi-function dba with knowledge on Oracle 11g, DB2 UDB, MYSQL and Apache Hadoop

Area of excellence

• Banking
• Insurance
• Telecommunication
• Finance
• Accounting
• Real Time Systems

TECHNICAL SKILLS

Hardware: HP Blade system, Sun E10000, HP 9000, Digital's Alpha 2000, DEC - 5500, PDP - 11, Hitachi's HIDIC V90/25, IBM Compatibles; HP itanium 64

Operating Systems: IA 64, Linux, Sun OS 5.6,Sun Solaris, HP Unix 11.11, 10.20, Digital Unix, SCO UNIX, Ultrix, RSX-11, Renix, PMS, MS-DOS, Windows 95/98/NT/2000;Linux

RDBMS: Informix 7.x, 9.x, 11.x (Online Dynamic Server), DB2 UDB, Oracle 11g Informix SQL 6.0, RDS 6.0, Informix Standard Engine 4.0,MySQL 5.7

Languages: Informix 4GL IDS 6.04/4.1, ESQL/C, COBOL, FORTRAN, Pascal, INFO-BASIC, Prime-COBOL, SPL, C, IGS, BASIC, Turbo Pascal, 8085 Assembly, LISP

Other Skills: IBM- ITIM,LDAP, Lotus Notes, Visual Basic 4.0, C Shell Programming, UNIX Shell Scripting, Veritas netbackup, Server Studio 6.0 for Informix . SQL power

PC Software: MS Project, MS Word, MS Excel, MS Access, Visio, Guradium ..

Case Tools: Erwin

PROFESSIONAL EXPERIENCE

Confidential

Sr, Consultant (Informix Logical DBA)

Environment: Sun /Linux / Informix 11.7/MySQL 5.7

Responsibilities:

• Reviewing and fine tuning of long running queries.
• Migration of Informix database to MYSQL.
• Collecting database statistics and Transaction processing statistics in to database for trend analysis and capacity management
• Trouble shooting /Root cause analysis of PBI's and providing solutions.
• Writing Queries as and when needed for changes and management (crs/gpm).
• Various Trend graph generation for management on CRS performance, Shopping Transactions, Database growth using excel. (web front end is in progress)
• Writing DDLS for Schema, Triggers and Stored Procedures
• Responsible for activities related to the development of the logical data model(s) for assigned projects including Establishment and monitoring of project plans
• Diagnose, Analyze and Solve production problems.
• Interaction with customers and client team members for the best throughput of the applications
• Change review for database changes and making changes as needed across all Informix environments.
• Making standards for db changes.
• Knowledge transfer sessions on need basis.

Confidential, Newark, DE

Vice President - (Sr. Informix DBE(Informix )/ Oracle DBA )

Environment: HP Unix 11.0 /Informix Online 7. 31 /9.4/11.5 , Win NT

Responsibilities:

• Migration of Informix instances from 7.31 & 9.4 to 11.5
• Migrations of Informix from Pa RISC platform to itanium ia 64 .
• Database Administration of Informix 11.5 Dynamic Server with Production Support for various Production servers (more than 50 instances) which are replicated (HDR)
• Database support for Oracle 11g environment in Linux
• Install/Upgrade and Admin Support of DB2 UDB database for Various IBM products ITIM,LDAP
• Database Engineering Support and expert advice in Database technologies and disciplines which includes Database design (logical & physical), development and implementation
• Assigning and managing DBA resources to individual projects
• Supports application deployment and deployment projects by developing database installation and upgrade procedures and scripts.
• Provides management with recommendations and information regarding system hardware, software and database to improve performance.
• Actively participate in capacity planning and hardware evaluation.
• Instance/Database monitoring/control using command line and various in house developed scripts
• Responsible for activities related to the development of the logical data model(s) for assigned projects including Establishment and monitoring of project plans
• Database upgrades and consolidation to new HP 11.0 Boxes from 10.2 Boxes
• Reviewing and Tuning of SQL on all projects. All SQL’s needs an approval from A DBE before going into uat/production.
• Review and approval of all database changes (Schema, Triggers, Stored Procedures)
• Installation, configuration, Instance/database creation and upgrading of Informix and tools.
• Diagnose, Analyze and Solve production problems.
• Migrate and refresh databases between the uat/Test and production environments
• Database Fragmentation, Indexing and Reorganization.
• Making disaster recovery procedures and implementation.
• Backup and recovery using onbar (veritas netbackup) and ontape utilities
• Information sharing and cross training of current DBA staff to nuances of current technology.
• Interaction with customers and client team members for the best throughput of the applications

Confidential, Tampa, FL

Sr. Informix DBA - Consultant

Environment: Sun OS 5.6 /Informix Online 7. 30

Responsibilities:

• Database Administration of Informix 7.30 Dynamic Server which includes 24*7 Production Support (pager rotation) for the Thirty Sun E10K servers physically spanned across USA.
• Installation, configuration and upgrading of Informix and tools.
• Tuning the OLTP database for optimum performance.
• Scripting to support Monitoring of the system
• Configured/Used Onbar utility for the Backup/Recovery (point in time) .
• Development of scripts and functions to monitor performance and execute optimization strategies.
• Diagnose, Analyze and Solve production problems.
• Migrate and refresh databases between the development and production environments
• Establish and maintain db level security
• Database Engineering for various related projects
• Database Fragmentation, Indexing and Reorganization.
• Documentation.

Confidential, Cleveland, OH

Team Lead - Informix - Consultant

Environment: HP Unix 10.20 /Informix Online 7.14

Responsibilities:

• Database Administration of Informix 7.14 Dynamic Server which includes 24*7 Production Support.
• Training and manage performance for the DBA team
• Installation and upgrading of Informix and tools.
• Installation, Tuning and Maintenance of Continuous Data Replication (HDR) with remote server as part of the disaster recovery plan.
• Tuning the database for optimum performance. Database recovery, database sizing and capacity planning.
• Writing Stored procedures and Triggers.
• Administration of the QV, Test and development Informix servers with fully automated installation scripts (ksh) with machine dependent configurable parameters.
• Scripting Automated Backup and Recovery procedures (Onarchive utility)
• Development of scripts and functions to monitor performance and execute optimization strategies.
• Scripting database-purging methodology.
• Analyze and Solving production problems with extensive use of SQL
• Migration of Informix database on HP Unix to DB2 on mainframe.
• Analysis and Design of Data Conversion (Informix -> DB2) for the Internet Banking Version 2.
• Documentation.

Confidential

Assistant Manager / Informix DBA

Environment: Informix 7.2 Online Dynamic Server, Informix RDS/4GL, SCO-UNIX, Ultrix, Open Server, Informix 4.1 Standard Engine, UNIX Shell Scripting

Responsibilities:

• Led a team of Programmers for various projects for the company like Fire, Accident, Life, & Medical including design and development of all modules.
• All local reinsurance activities and Facultative Reinsurance Business are integrated to the basic modules.
• Entire responsibility for the Customization (Feasibility Study, Analysis and Design, Coding and Implementation) of various modules like Motor Insurance
• Marine Insurance, Financial Accounting and Payroll & Personnel Module from standardized software (COINS).
• System Administration for DEC Alpha 2000(Digital UNIX), Dec 5500(Ultrix), SCO UNIX Machines and various PC's which are linked through TCP/IP network.
• Database Administration for Informix 7.2 DSA and Informix 4.0 SE which includes Installation, Troubleshooting, Performance Tuning
• Backup & Restore, Optimization, Indexing, Security Considerations and Training on various UNIX platforms.
• Conversion of Applications written in Informix 4.0 to Informix 6.2 and Data Migration (SE 4.0 to Online 7.22).
• Installation and Maintenance of PC software, SCO-UNIX, TCP/IP, Informix, Additional I/O ports etc.
• Completed cost, quality and optimum performance evaluations of various Hardware and Software purchases for the organization.
• Conducted Project Meetings and Administrative duties.
• Conducted user training sessions and seminars on computer awareness.
• Independently designed and developed various packages for the Company.
• Developed Internet Home Page for the company with latest Internet tools.
• Monitored and maintained Terminals and Printers in main office and in branches (linked through Modems).
• Integrated Financial Accounting System with other Insurance modules
• Designed & developed the Investment System, including the Share Management, Fixed Deposit, Treasury Bills, Bonds, & Real Estate Management modules.
• Designed & developed the Fire & General Accident Insurance System, including Policy Data Maintenance, Claims & Recoveries, as well as Statistics
• Tested & modified all application software to be Y2K compliant.
• Customized the Payroll & Personnel systems using Informix 4GL

Confidential

Software Engineer

Environment: HITACHI’s HIDIC V 90/25 series with UNIX and Real Time Operating System - “Process Monitor Systems”

Responsibilities:

• Design, Development and Implementation of Plant Performance Evaluation system
• Hardware Testing and Maintenance
• Database Management
• Graphic generation of plant operation using industrial Graphic System (IGS)
• Log Generation, User training and Documentation.