TECHNICAL SKILLS

Systems: UNIX (AIX/Solaris/HP), Linux (RHEL6/Ubuntu9/CentOS6.4), Windows, VMware, zOs

Databases: Oracle(9i - 12c), MS SQL, MySQL, HBase, MongoDb.

Programming: JAVA/J2EE/JVM, C++, SQL, PL/SQL, Shell/Python, JavaScript/XML/HTML

Applications: AWS EC2/RDS, BPM, PowerPoint, Visio, Erwin, JDBC/ODBC, Oracle(RAC/OEM/RMAN/DataGuard/ERP), SAP R/3(ECC6), DNS, VPN, TCP/IP, Putty, TOAD, Telnet, FTP, SoapUI, WSDL, Project Manager, Eclipse, Data Architect

PROFESSIONAL EXPERIENCE

Consultant - DBA

Confidential, Chicago IL

Responsibilities:

• Configure servers for DBMS product installation. Migration Oracle 11g to 12c.
• Support backup and recovery, performance tuning, and after hours on-call.
• Maintain RAC and Non-RAC databases running Oracle 11g.
• Performing DBA tasks such as RMAN backup recovery, RAC clustering and Data Guard.
• Ability to diagnose problems and triage resolve issues across various tiers (application, network, database, server, or storage tiers).
• Build Oracle 12c databases and OEM 12c on Linux; experience of Gloden Gate/DG.
• Participate big data evaluation and understand Hadoop, Map/Reduce, HDFS and HBase.
• Exposure to Linux/Unix Shell scripts and Python. Knowledge of Puppet.
• Setting Up Database Monitoring and Alerting in SAP Solution Manager

Consultant-Intelligent Engineer

Confidential

Responsibilities:

• Provides technical leadership in business intelligent support design/implementation.
• Hands-on Oracle RAC. Perform Oracle DBA tasks include configuration management, backup and recovery, performance optimization, and space management.
• Support SAP system wif RMAN, BRTOOLS and database/SAP application monitoring.
• Experience of ETL design wif Erwin, SQL, PL/SQL and DBMS packages.
• Management MySql and MSSql databases access, backup/recovery and replication.
• Experience of MongoDb database development.

Sr.BPM Engineer

Confidential

Responsibilities:

• Working as a Key member in a large BPM project including iteration 1 to 4.
• Analyst business requirements and defining functional processes.
• Hands on experience wif data modeling, process mapping and best practices.
• Working experience of UI design wif Java/JaveScript/XML wif SDLC.
• Experience of MSSQL databases administration and optimizations.
• Experience of testing including test case/UAT/end to end testing by JRun.
• Experience of log management using Splunk. Experience of Eclipse.

Agile DBA/Application DBAConsultant

Confidential

Responsibilities:

• Installation and management BPM wif agile methodology on Linux system.
• Analyze and document business requirement including business modeling, process mapping, Mockups, prototypes and data dictionaries, as well as best practices.
• Provide guidance to application development teams on DBMS product technical issues.
• Management Oracle/MySql databases access, backup/recovery and replication.
• Implement testing using Jmeter; Exposure to Linux wif shell.
• Working for SWACO to troubleshooting Oracle R12/11g Finance via Track-IT and support.
• Development of PL/SQL code and administrative maintenance.

Sr.Consultant Oracle DBA/Support

Confidential

Responsibilities:

• Working for IBM global data center in multiple projects following SDLC standards.
• Support 780 databases wif total 76TB in OLTP and OLAP environments.
• Ability to understand business requirements, map them to teh solution and deliver relevant and compelling demonstrations. Strong noledge of ITIL.
• Experience in data analysis, performance tuning, identified and elimination of *root cause* problems in application SaaS and cloud environment.
• Understand of large data center infrastructure architecture and procedures.
• Experience of VMWare, Oracle Fusion. Provide on-call support for databases 7 X 24.
• Support of high priority and complex enterprise systems wif Unix scripts.
• Experience/noledge to support SAP wif Oracle using Solution Manager, CCMS and BRTools such as BRBACKUP, BRRESTORE, BRARCHIVE and BRRECOVER
• Working for Citibank to migrate legacy applications into a conforming domain model.
• Experience in query tuning and optimization utilizing indexing, partitioning and system level strategies.

Software Engineer

Confidential TX

Responsibilities:

• Supporting of a large-scale databases in enterprise security data center (>=2 million events per day) wif 24x7 on call rotation. Experience of project management.
• Leadership of DBA to translate business requirements into technical architecture.
• Experience of migration architect wif mapping in AS-IS and TO-BE-IS.
• Implementing data modeling wif normalization and demoralization using Erwin.
• Experience of infrastructure architect wif servers, networks, storages, firewalls, applications and databases. Understand routers & switches.
• Experience of servers installation and configuration, network TCP/IP and Routers validation, EMC SAN storage and I/O capacity plan, load balancing and failover.
• Performing operational support such as security, scheduling, monitoring, error handling, patching and upgrading; backup/recovery wif RMAN, data Pump/export import.
• Hands-on implementing Oracle RAC, OEM, DG, perform tuning, shell, SQL and PL/SQL.
• Experience wif Remedy in issue tracking/change management.

ERP Support DBA/Application

Confidential

Responsibilities:

• Setup and support oracle ERP application environments on Windows, Linux and Solaris.
• Manager database and object validation; cloning databases; Upgrade/apply patches.
• Support SAP wif SAPDBA, SAPGUI, BRTools and wif CCMS.
• Experience of using Quest SpotLight to tuning both application and databases.
• Working for multiple projects as a DBA in Oracle, MSSQL, DB2 and MS Excel.
• Implement backup/recovery and tuning using STATSPACK. Experience of Crystal report.
• Experience of ETL tool OWB, SQL*Loader, partition, SQL and PL/SQL.
• Experience of project manager wif project plan, coordinator and delivery.
• Data modeling including logical and physical design. Objects design based on OFA.
• Planned and conducted unit test, user acceptance test(UAT) and end to end test.
• Installation, maintenance and cloning development, QA and production systems.