SUMMARY:

• IT Professional wif 15 years of experience encompassing a wide range of skill set, roles and industry verticals.
• Extensive experience in analysis, design, application programming on Oracle. Experience in database Backup & Recovery.
• Gained very good experience in project delivery management.
• Gained very good working experience in Oracle 11g and Oracle Golden gate.
• Extensive experience in database replicating concepts, working wif remote databases, and in trouble shooting database, application oriented issues.
• Gained very good experience in Oracle Enterprise Manager to monitor database health checks for databases and for me/O tuning.
• Proficient in Upgrading databases from Oracle 8i to Oracle 10g and from 10g to 12c and proficient in migrating databases from Windows to Linux (CentOS 5).
• Proficient in Windows, UNIX, Linux, Ubuntu, Solaris.
• Analyzing and translating business requirements to technical requirements and architecture.
• Strong database skills, performance tuning of SQL queries and development noledge.
• Experience in leading and managing teams. Handled multiple roles - Project Lead, Software Architect, Developer, and System Admin.
• Executed software projects for Logistics, Telecom, Automotive, Shipping, Pharmaceutical and Process industry.
• Good communication skills, interpersonal skills, self-motivated, quick learner, team player.
• Had very good experience wif Java and ETL team in resolving their issues related to database

TECHNICAL SKILL:

GUI / Tools: JavaScript, System Analysis and Designing (SAD).

Oracle Middleware Concepts: Materialized Views and Oracle Golden Gate

RDBMS/Web Tech: Oracle 7(Personal), Oracle 8i, Oracle 10g, Postgre Sql.

Platforms: Windows 2003 Server, UNIX, Linux, Ubuntu, Solaris, IBM-AIX.

Languages Known: C, C++, Visual Basic 6.0, VB.Net, Oracle SQL and PL/SQL.

Processes: IBM’s QMS (Quality Management System).

Backup & Recovery: Oracle RMAN, Datagaurd and Data pump.

PROFESSIONAL EXPERIENCE:

Lead DBA

Confidential

Responsibilities:

• Performance tuning and day-to-day trouble shooting of multiple databases hosted onsite and offsite across all environments.
• Responsible of Oracle Dataguard alerts and set up in different machines.
• Perform off hours assignments as they relate to vulnerability mitigation, patching, upgrades, or other tasks dat cannot before during normal business hours.
• Supporting development teams in both implementation planning through debugging challenges.
• Monitoring OEM alerts and act on those if any issues.
• Monitoring Daily backups, act on those if any backup failures.
• Working on OEM to configure new Informational reports, and configuring new database alerts.
• Participation in testing Disaster recovery activities to succeed Point In Time recovery.
• Documenting new implementations to OEM
• Project management in SDLC
• Implementing new cron entries to reduce dependancies on DBA’s
• Applying new patches to databases on quarterly basis
• Responsible for resolving DB releated issues wif Java/weblogic and ETL team
• Updating day to day activities in the team and production ticket statues to upper management
• As a client value developing automation tools to reduce dependency on Database Administrators

Environment: Oracle 10g, Oracle 11i, Oracle 12c, Oracle Golden gate and OEM 12c cloud control

Lead DBA

Confidential, NJ

Responsibilities:

• Maintaining Golden Gate in between multiple systems
• Project management in SDLC
• Responsible for 24*7 Oracle databases (10g/9i) running on Sun Solaris, Linux wherein the major chunk of the databases hold data of OLTP, DSS and other enterprise applications as a Database
• Risk and issues identification and management
• Migration of GCP, SXP databases/schemas to EDF Environments.
• Assigning resources to projects, allocating FTP’s to projects
• Arranging team calls to get statues of assigned projects and update to management
• Deliver new and complex high quality solutions to clients in response to varying business
• requirements
• All project reporting and metrics
• Responsible for resolving DB releated issues wif Java and ETL team
• Responsible for managing scope, planning, tracking, change control, aspects of the project
• Responsible for effective communication between the project team and the customer. Provide day to day direction to the project team and regular project status to the customer
• Updating day to day activities in the team and production ticket statues to upper management
• Assigning production tickets and funding to team
• Establish effective communications and relationships wif cross-functional managers to achieve desired outcome and results
• Establish Quality Procedure for the team and continuously monitor and audit to ensure team meets quality goals
• As a client value developing automation tools to reduce dependency on Database Administrators
• All project planning activities, establishing team meetings, priority setting, action item tracking, communication plans, roles and responsibilities matrix

Environment: Oracle 10g, Oracle 11i, Oracle 12c and Oracle Golden gate

Sr. Oracle DBA

Confidential

Responsibilities:

• As a senior team member, responsible for Analysis, design, development, testing and implementation of project specific applications and providing solutions for new implementations to the team and this is an enterprise consolidated data warehouse project which is an interface between so many applications, responsible for assigning production tickets to team and assigning projects as per schema expertise and technology expertise wise.
• Cloning of databases between Development, System Testing (ST), User Acceptance Testing (UAT) wif production data
• Arranging team calls to get statues of assigned work and update to management
• Deliver new and complex high quality solutions to clients in response to varying business
• requirements
• Responsible for managing scope, planning, tracking, change control, aspects of the project
• Responsible for effective communication between the project team and the customer. Provide day to day direction to the project team and regular project status to the customer
• Updating day to day activities in the team and production ticket statues to upper management
• All project planning activities, establishing team meetings, priority setting, action item tracking, communication plans, roles and responsibilities matrix
• Establish Quality Procedure for the team and continuously monitor and audit to ensure team meets quality goals
• As a client value developing automation tools to reduce dependency on Database Administrators

Environment: Oracle 8i, Oracle 9i and Oracle 10g, Oracle Golden gate, Sun Solaris and Linux

Sr. Application Developer

Confidential

Responsibility:

• Upgrading Oracle Databases from lower versions like Oracle 7, Oracle 8i to higher versions Oracle 9i and to Oracle 10g
• Creation and Managing Databases
• me/O Tuning the databases using AWR & ADDM Reports
• Automation of Oracle Backups
• Maintenance of reporting database server by replicating
• Communicate activities/progress to project managers, business development, business analysts and clients
• Implementing Backup server for Archive logs, logical backups and for cold backups too

Environment: Oracle 8i, Oracle 9i, Oracle 10g on Windows and UNIX environments

IT Executive

Confidential

Responsibility:

• Handled Multiple roles and responsibilities; Lead architect, Developer, Database Administration in the capstone project of the degree program, to deliver a commercial grade Integrated Multi-Carrier Package Shipping System
• Handled Java applications and working on client requirements
• Lead architect - requirements and design phases; developed use case models
• Patching and up gradation of databases
• Resolving TNS Issues linked wif Networking

Environment: Windows2000, Oracle 8i, Oracle 9i and Oracle 10g

Systems Incharg

Confidential

Responsibility:

• Involved in Implementation of Database in various locations
• Designing the database structure and table structure
• Involved in Recovery of Database in various locations through Remote
• Interaction wif Clients and reporting status to Management
• Analyzed Business requirements and Functional Documents
• Making Documentation and explain Requirements to Programmers
• Making proposals of New Modules
• Designing the different Modules
• Implementation in Regional offices which are located in Bangalore, Chennai etc

Environment: Oracle 8i, Oracle 9i, Windows 2000/2003