SUMMARY

• Seventeen years of IT industry 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 Data Guard and OEM.
• Gained very good working experience in Oracle 11g, 12c and Oracle Golden gate.
• Extensive experience in database replicating concepts, working with 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 I/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 knowledge.
• 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 with Java and ETL team in resolving their issues related to database
• Had Good Exposure on Mongo DB, Cluster Maintenance, DB Creations, Collections Creations, DB Level performance tuning.

TECHNICAL SKILLS

GUI / Tools: JavaScript, System Analysis and Designing (SAD). Oracle Middleware Concepts Materialized Views and Oracle Golden Gate RDBMS/Web Tech Oracle, Postgre SQL, Mongo DB, Cassandra and MySQL

Platforms: Windows 2003 Server, UNIX, Linux, Ubuntu, Solaris, Confidential -AIX. Languages Known C, C++, Visual Basic 6.0, VB.Net, Oracle SQL and PL/SQL. Processes Confidential ’s QMS (Quality Management System).

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

PROFESSIONAL EXPERIENCE

Oracle DBA Lead

Confidential

Responsibilities:

• Maintaining Golden Gate in between multiple systems.
• Maintaining Golden Gate Big Data Adapter to capture JSON format events.
• Responsible for resolving DB related issues with Java/WebLogic and ETL team
• Gained knowledge on Real Applications Cluster (RAC).
• Implementing new cron entries to reduce dependencies on DBA’s
• Participation in testing Disaster recovery activities to succeed Point in Time recovery.
• 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
• Working on mongo DB Setup and creating documents, collections.
• Implementing/working on new technologies like Fast Switch Fail Over Options.
• Maintaining DBA code and Scripts in GIT/SourceTree.
• Configuring and Execution of Pipelines through Jenkins.
• Debug PL/SQL Code to meet business requirements like Stored Procedures, Functions.
• Configuring OHS/Middle tier in Source Database to access multiple target Databases.
• Mongo DB Creations, Collections Creations, Performance tuning DB Level/Query Level.
• Maintenance of Mongo DB, Setting up cron jobs for MIS Reports.
• Mongo DB Cluster maintenance, working on alerts etc.
• Oracle Data Transformation from Oracle to MongoDB using Golden Gate Big Data Adapter capturing JSON (Oracle GGBD Kafka CDC Damp DOC MongoDB/Cassandra)
• MongoDB and Cassandra DB’s Administration.
• Monitor data flow and act on Kubernetes alerts.
• Deliver new and complex high-quality solutions to clients in response to varying business Requirements.

Project Lead DBA

Confidential

Responsibilities:

• Performance tuning and day-to-day trouble shooting of multiple databases hosted onsite and offsite across all environments.
• Working on performance issues using SQL performance Analyzer.
• Responsible of Oracle Data guard alerts and set up in different machines.
• Gained experience on Oracle Data Masking to copy data from production databases to non- prod databases.
• Perform off hours assignments as they relate to vulnerability mitigation, patching, upgrades, or other tasks that cannot before during normal business hours.
• Supporting development teams in both implementations planning through debugging challenges.
• Configuring and Monitoring OEM alerts and act on those if any issues.
• Monitoring Daily RMAN and 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 dependencies on DBA’s
• Applying new patches to databases on quarterly basis
• Responsible for resolving DB related issues with 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

Onsite Project Lead DBA

Confidential

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 ASM RAC 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 related issues with 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 with 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