PROFILE SUMMARY:

• Result - oriented Professional with over 20 years of rich experience in Database Architecture & Administration and Software Development
• Experienced in controlling migrations of database along with troubleshooting, installation, patching, cloning, maintenance, upgradation, performance tuning and system administration
• Extensive experience as DBA in DB2 UDB (LUW) 7/8/9/10/11, Oracle 10g/11g and SQL Server 2000/2005/2008 ; Business Analyst and Informatica ETL
• Migrated data from legacy systems to new solutions and developed database solutions to store & retrieve company information
• Maintained database performance by identifying and resolving production & application development problems; calculating optimum values for parameters and evaluating, integrating & installing new releases
• Developed web applications using Visual Interdev, ASP, IIS, JavaScript, VBScript, HTML, DHTML, Web Sphere, Servlets, JSP, J2EE, PHP, Struts and Java
• Possess Team-based management style coupled with strong leadership to motivate peak individual performances; successfully managed a team of 20 members across diverse geographies
• Hands on experience in developing and deploying enterprise based applications using major Hadoop ecosystem components like Map Reduce, YARN, Hive, Pig, Hbase, Flume, Sqoop, Spark Streaming, Spark SQL, Storm, Kafka, Oozie, Zookeeper and Cassandra.

TECHNICAL SKILLS:

Languages: C, VS COBOL II, SQL, PL SQL, VBA, Lotus Notes 4/5/6

Operating System: UNIX, Win95/2000/NT/XP, DOS, Linux, AIX, TSM

Databases: DB2 /7.x to 11.x UDB, LUW, Oracle 7/8/9/10/11, MS Access7.0, BW SQL Server / 2008, Lotus Notes 4/5/6, Post GreSQL, Sybase

Web Technologies: HTML, JavaScript, XML, WebSphere5, J2EE, PHP, Servlet, Applet, Swing, Java, Struts, Ajax, Hibernate

GUI: Visual Basic 4/5/6, Forms 4.5, Lotus Notes 4/5, CICS

Tools: /Utilities: Reports 2.5, Toad, Quest, db2haicu, Control Center, Command Center, Merge Backup, Optim, Confidential Development Studio, DB2MON, Foglight, Remedy, Informatica ETL, Hadoop/BigData Spark, MapReduce, HDFS, Hbase, Hive, Pig, Sqoop, Flume, Zookeeper

CORE COMPETENCIES:

• Database Administration
• Storage & Server Management
• Application DBA
• Vendor Management
• Cost Estimation & Budgeting
• Production Support
• Software Development Lifecycle
• Big Data Analysis
• Team Building & Leadership
• Analytical
• Communicator Thinker Intuitive Innovator Collaborator

PROFESSIONAL EXPERIENCE:

Confidential, NY

DBA Consulatant/Big data Analyst

Environment: DB2 UDB 9.7/10.5/11.1 UDB LUW, Data Studio, Informatica ETL, Cognos Report

Confidential, NC

Senior Implementation DBA

Environment: DB2 UDB 9.1/9.5/9.7/10.1 UDB LUW, Toad, SAN, AIX, LINUX, Remedy, HADR, HACMP, EMC Avamar Storage

Confidential, Jacksonville FL

Database Architect

Environment: DB2 UDB 8.2 /9.5/9.7 UDB LUW, Oracle 10g/11g, SQL Server 2005/2008, Quest, RMAN, PL/SQL, ASM, SAN, db2top, db2pd, db2diag, Merge Backup

Confidential, Raleigh, NC

Database Manager & Architect

Environment: DB2 UDB 8.2 /9.5/9.7 UDB LUW, Oracle 10g/11g, SQL Server 2005/2008, Quest, Toad, RMAN, PL/SQL, ASM, SAN, RAC, db2top, db2pd, db2diag

Confidential, Raleogh, NC

Team Lead & Database Architect

Environment: DB2 UDB 8.2 /9.5/9.7 UDB, Oracle 10g/11g, SQL Server 2000/2005/2008 , Sybase, Tivoli (TSM), Java, Struts, Quest, Toad, RMAN, PL/SQL, ASM, SAN, RAC, Struts, Java, Tomcat, Balance Warehouse

Confidential, RTP, NC

Database Developer

Environment: DB2 UDB 5/7/8, Oracle 9i, Web Sphere, JSP, Java, J2EE, Lotus Notes, DESC, LEI, JavaScript, HTML, DB2 Stored Procedure Builder, Visio, Notes Pump, ASP Visual Interdev, Tomcat, Apache, PHP, PostGreSQL, XML, Servlet, Struts, Ajax, Hibernate

Confidential, Rochester, NY

Programmer Analyst

Confidential, SFO, CA

Web Developer

Responsibilities:

• Determining database structural requirements by analyzing client operations, applications and programming and developing database solutions by designing proposed system
• Performing the optimization/debugging of complex queries & procedure calls, supervising the activities in the databases with snapshots & event monitors, design reviews and implementing BLU
• Estimating the budget for new databases, specifications for CPU & storage required and evaluating vendors & development of new vendors meeting organizations requirement
• Installing, configuring and upgrading Database (DB) server software and related products; working with Confidential in opening PMR with the known issues
• Minimizing IT disruptions by providing IT continuity through redundant or fault-tolerant components with High Availability, setting up HADR, DR Recovery Site and performing DR drills
• Migrating servers and testing & implementing different physical & logical back-up & recovery methods such as point in time, cross node recovery, media recovery, incremental delta back-up, merge back-up and so on
• Supervising database performance tuning at system and application levels; applying patches as appropriate, executing application patches and ensuring that the rollback strategy is in place
• Designing databases & its layout, automating process by writing shell scripts and installing patches for database servers
• Coordinating with cross-functional teams in developing database architectures, coding standards and quality assurance policies
• Monitoring CPU & memory utilizations, formulating reports and driving annual database storage management
• Collaborating with clients for capacity planning and development of long-term strategic goals for production databases
• Training & mentoring team members; creating & sustaining a dynamic environment that fosters development opportunities & motivates high performance amongst team members
• Worked on analyzing Hadoop stack and different big data analytic tools including Pig, Hive, Hbase database and Sqoop.