SUMMARY

• IT Professional with Five Years of hands - on experience in Oracle/PostgreSQL Database Administration.
• I have equally work with other Relational database management system (RDMS) of different versions.
• Possess complete life cycle knowledge including Development, Test, QAT and Production support.
• Worked on Oracle 12c, 11g, 10g versions with specializing in database administration, production support, installation, configuration, patches, upgrading, migration, backup and recovery, performance Monitoring and tuning, Cloning, space and security management, Golden gate, RAC, Data guard, User management, Replication etc.
• Expert in implementing High Availability solutions with Oracle Data Guard.
• Excellent experience in managing large-scale OLTP databases 8+TB size in HA and DR setup
• Excellent experience in managing large-scale OLTP databases 5+TB size in HA and DR setup
• Extensive Experience with RMAN Backups, Hot Backups and Logical Backups.
• Extensively implemented Datapump, conventional Export/Import (Oracle 12C, 11g, 10g) for migration and logical backup of database.
• Strong skills in applying security patches (Patch set, Critical Patch Updates (CPU) / Patch Set Updates (PSU)) using "runInstaller" and perl based utility "opatch".
• Automated routine DBA tasks like database backup and db stats by using Grid control /Crontab.
• Upgraded Oracle Databases from 10g to 11g and 11g to 12c.
• Upgrading and Migrating Databases from lower versions to higher versions.
• Performance Monitoring and Tuning of Database, Application, System Global Area, I/O, Rollback segments using, Oracle Enterprise Manager and Toad
• Expert in RMAN backups including full, incremental and cumulative.
• Excellent knowledge in Flashback Recovery, Hot/Cold Backup and Cloning/Refresh of databases using RMAN. Experience in applying patches/ patch sets to the databases.
• Knowledge in configuring ASM (Automatic Storage Management).
• Experience in configuring Oracle network, RMAN and Recovery Catalog.
• Experienced in Performance Tuning (Memory Tuning, I/O Tuning, SQL statements) using EXPLAIN PLAN, TKPROF, and AWR . STATSPACK ADDM, ASH, SQL tuning advisor etc.
• Experienced with Database Security Administration, system monitoring including adding and removing users, configuring quotas, auditing, and analyzing security problems.
• Experience providing 24x7 Production Support, troubleshooting / resolving various types of production issues. knowledgeable in installing and configuring Oracle high availability solutions like Real Application Cluster (RAC) on Oracle 10g & 11g, 12C, both on Linux and windows platforms.
• Experienced performing manual recovery using archived logs, RMAN-managed backup with or without catalog, operating system backup, cold and hot backup, full back up, incremental and cumulative backups. Proficient at performing major Database Release Upgrade (manually as well as using DBUA) along with applying various PSU patches using OPatch for 11g|12c, databases.
• Adept at routine Database Administration tasks including automated installation, creation and replication of databases, management of tablespaces, logs, grants, roles, users.
• Working experience in database cloning, database backup, recovery procedures and security.
• Experience in application Support, Data pump, Data Guard, Fine Grain Auditing (FGA), performing Flashback, transportable tablespaces.
• Experience in designing and configuring high-availability systems using DATAGUARD with physical standby. Effectively used DATAGUARD BROKER utility.
• Implemented and maintained 12c multitenant architecture using container and pluggable databases and performed conversion of non-container databases to pluggable databases
• Experience in Performance Tuning, Tuned various large critical OLTP and OLAP databases using various tools like AWR, ASH, SQL-TRACE, TKPROF, ADDM and Explain
• Experienced in Installing, Configuring and Maintaining Real Application Cluster (RAC) using raw devices, OCFS, Automatic Storage Management (ASM) and SRVCTL utility.
• Database/Machine Administrator (oracle + EXADATA)
• Assisted the PM in preparing the efforts and cost estimation of the project and worked towards obtaining approvals from all the stakeholders.
• Refreshed/cloned databases using RMAN utility.
• Developed Shell Scripts to Automate RMAN Backups, Hot/Cold backups, Imp/Exp, Datapump and Schema Refresh, and Production to Dev/Stage Sync up
• Migration of Data from Reports generated by various vendors into PostgreSQL Databases using PostgreSQL Export/Import Procedures.
• Manage the Space and Storage of the Databases through various Shell Scripts scheduled in the corncob periodically in regular intervals. Write Complex Shell Scripts that automate the Import of Reports to PostgreSQL databases.

TECHNICAL SKILLS

Databases Versions: Oracle 10g, 11g, 12c, Postgre \SQL 9X, 10X, 11X

Solution Tools used: Oracle (Oracle Enterprise Manager, SQL*Plus, SQL Loader, DB Configuration Assistant) Toad, OEM Grid, RMAN, Exp/Imp/Data Pump, AWR, Top, DBCA, DBUA, ADDM, Remedy, Service now, Putty, WINSCP, Command prompt, Golden gate, RAC and DATA GUARD, GIT, Ansible Samba, Apache, Puppet, Excel, Microsoft office, access, PowerPoint, office suite, outlook, Pg dump, pg dumpall, pg basebackup, expdp/impdp, Rman, PG SQL and PG PL/SQL,SHELL, SprintGround, Jira +Agile, pgBadger and tailnmail.

Operating Systems: MS Windows, UNIX and LINUX

Hardware: Sun Enterprise Servers 890, Dell Servers, Compaq Server, HP/UX-9000, Red Hat Linux 6.2/7.0

PROFESSIONAL EXPERIENCE

Confidential - Atlanta, GA

Oracle/PostgreSQL Database Administrator

Responsibilities:

• Have worked as part of team for Infrastructure Migrations and Capacity planning.
• Developed RMAN Backups, Data Pump and disaster recovery management policies.
• Used RMAN for incremental and cumulative backup/restore.
• Setup, configuration and maintenance of standby databases (Oracle Data Guard) to ensure disaster recovery, high availability and data protection.
• Used Golden Gate in combination with Active Data Guard to achieve maximum availability and the Highest Fault tolerant database system.
• Implemented RMAN Image Copy Backup Strategy for very large Databases in minimizing the downtime for recovery.
• Scheduling and maintaining RMAN (Recovery Manager) backups to the FRA.
• Resolves database performance issues, database capacity issues, backup, replication, and other distributed data issues.
• Experience in editing UNIX/SHELL scripts for providing reports .
• Created a Clone Database using RMAN on remote Server .
• Implemented Data Guard with high availability and performance configurations and participated in Data Guard Fail over tests as a team member.
• Experience in scripting using PL/SQL, shell, PowerShell,
• Successfully implemented Backup & Recovery using RMAN which includes hot backups and Cold backups.
• Proficient in all DBA responsibilities such as user management (synonyms/privileges, roles, quotas, table partitioning, index, sequence), space management (Tablespaces, rollback segment), monitoring (alert log, memory, disk I/O, CPU, network activity).
• Extensive knowledge of Oracle Architecture, SGA, PGA, Binary structure, Listener,
• Performed Database Tuning - Tuning involved I/O, Memory, CPU utilization, SQL Tuning, SGA tuning, Shared Pool tuning, Buffers and Disk I/O tuning using Oracle's regular performance tuning tools like Explain Plan, AWR, SQL*Trace, TKPROF, Explain plan, Analyze, AWR and ADDM
• Implemented Goldengate unidirectional replication .
• Implemented 12c Grid control (Multi OMS architecture) on 11.2.0.3 database, Standby OMS architecture is under progress.
• Creation, Configuration and Setting up of RMAN Catalog databases and registering target Databases with the Catalog.
• Setting up and managing Hot and Cold Backups, Exports, Imports.
• Assist in SQL tuning and providing consultation such as creating Materialized views, adding ind ex es, dropping unnecessary index es, using hints wherever possible, amongst others.
• Knowledge in Oracle Data warehouse DBA skills relating to administration and management of Oracle OLTP.

Environment: Oracle 12C, 11g/11g RAC/10g, VMS, Sun Solaris, Windows Server 2003, Red Hat Linux, TOAD, RMAN, SQL server, OEM, Exadata.

Confidential - Atlanta, GA

Oracle/PostgreSQL Database Administrator

Responsibilities:

• Implemented proactive monitoring using Diagnostics Pack AND OEM 12C GRID CONTROL.
• Applying upgrade patch, maintenance and interim ( opatch ) patches on all the databases.
• Created and maintain users, roles and privileges.
• RMAN point in time recovery and Instance recovery done on 11g.
• Scheduling repetitive activities like gathering schema statistics, exports, tablespace usage report using crontab.
• Database monitoring/maintenance, replication process and performance tuning are done using OEM (Oracle Enterprise Manager).
• Implemented Flashback technology of the Oracle 12C, 11g, 10g along with Recyclebin for a faster recovery of the databases and database objects.
• Performed Data refresh activities using the export data pump utility.
• Excessively worked on performing database backup and recovery using RMAN. Key player in troubleshooting backup issues. Taking the RMAN incremental and cumulative backups.
• Refreshed/cloned databases using RMAN utility.
• Restoration of Data for users in the event of requirement or system crash.
• Achieved optimized performance for the databases by rebuilding indexes, on tables and indexes.
• Involved in the installation and configuration of Oracle 12C, 11g, 10g two Node RAC (Real Application Cluster) with ASM file system on Linux plat form
• 24 X 7 Production & Development database support and administration.

Confidential

SAFe Scrum Master Leadership Executive / IT Agile Project Manager

Responsibilities:

• Leading and coaching the organization in its Scrum adoption
• Wor king knowledge of Kanban and Lean.
• Planning Scrum implementations within the organization
• Helping employees and stakeholders understand and enact Scrum and empirical product development
• Causing change that increases the productivity of the Scrum Team
• Working with other Scrum Masters to increase the effectiveness of Scrum in the organization
• At the business level, I created a development environment that is creative, safe, productive and supportive and enables multi-directional collaboration.
• At the product owner level, I facilitates planning and helps product owners understand and adhere to Scrum techniques and practices.
• At the team level, I provides guidance, coaching, support and facilitation, and helps remove any obstacles that teams may encounter along the way.
• At the individual level, I supports individual efforts, addresses any issues that arise, and removes obstacles to help individuals be focused and productive.
• An ability to cut through unnecessary work and focus only on essential work.
• Sound judgment under pressure and the ability to remain calm under stress.
• Strong motivation and coaching skill to guide and support teams throughout a project.
• Exceptional organizational abilities to keep everything straight and prioritize.
• The ability to think and make decisions quickly as circumstances change rapidly
• A high level of adaptability in order to accept change and reduce unnecessary confusion and risk.
• Creates and manages project/program resource loading and budget; reconciles budget monthly and communicates risks to Leadership.
• Sets and runs effective recurring status meetings with the product, portfolio and delivery managers.
• Provides a single point of contact for projects.
• Works with Product Owner to define project scope and objectives.
• Works effectively with others to remove delivery team roadblocks.
• Guides team through continual improvement process.
• Bring ideas from professional facilitation, coaching, conflict management, mediation, theater and so on to help the team become a high-performance team.
• Empower the team to make system and process improvements captured in sprint .retrospective meetings. Manages the health of the team.
• Remove obstacles for developers and testers.
• Use key Scrum metrics (burn down, velocity) to help deliver committed work.
• Manage sprint backlog items and tasks.
• Manage all Scrum boards (physical or virtual).
• Leads the teams’ efforts towards continuous improvement.
• Gathering and updating project materials, completing budgeting, forecasting, project documentation, business flows, and lessons learned documents.
• Scheduling and allocating work, providing advice and guidance, and resolving problems to meet technical performance and financial objectives.
• Coordinate all Scrum Ceremonies including Sprint Planning, Daily Standups, Sprint retrospectives, Sprint Demos, Story Grooming, and Release Planning.
• Coaching and mentoring other Scrum Masters on our program team. Partnering to ensure that our ways of working are consistent across teams9
• Assist in defining and deploying new product development processes and in facilitating the continuous improvement of existing processes.
• Coaching and mentoring other Scrum Masters on our program team. Partnering to ensure that our ways of working are consistent across teams.
• Liaising between developers and project stakeholders; fostering quality communication between engineering disciplines.