SUMMARY:

• Around 6 years of professional experience as Oracle Database Administrator having good experience in database administration, database installation, upgrade, migration, applying patches, performance tuning, RAC installation and maintenance, setting up and configuring Data - guard, performing all kinds of backups and recoveries, cloning databases, auditing and product support
• Experience in Performance Tuning, tuned various large critical OLAP and OLTP databases of Terabytes size using various tools like STATSPACK, AWR, SQL-Trace, Tkprof, Analyze, ADDM and Explain Plan Methods
• Hands on experience with Chef in AWS Cloud environment and have good knowledge about Physical and Logical structure of a database
• Experience as On-Call 24x7production DBA support, application/development DBA. And handled daily production problems/change requests (DBCRS) with Oracle.
• Manage Amazon RDS for backups, software patching, automatic failure detection, and recovery. Developed database monitoring/health check alert scripts for database uptime/downtime status, and sizing issues using grid control (OEM).
• Proficient in raising TAR with Oracle Support and using Meta-link to resolve the bottlenecks in the database environments.

TECHNICAL SKILLS:

Database: Oracle 12cR1, 11gR2, Oracle 11gR1, Oracle 10gR2, Oracle 9i, SQL server 2008 R2, 2012, 2014 and 2016.

Oracle Products: OEM 13c, 12C, 11g (Grid Control), Oracle cluster ware, Data guard broker, RMAN, Data pumps, ASM, AWR, ASH, ADDM, and CRSCTL.

Operating System: Red Hat Enterprise Linux (RHEL) 4.x, 5.x, 6.x, Sun Solaris 5.8, 5.9, 5.10, Windows /XP/2003/2008, IBM AIX, HP UNIX 11i.

Languages: Core JAVA, JDBC, SQL, PL/SQL, UNIX shell scripting.

Tools: OEM, TOAD, Fog light, SVN, STONE BRANCH, GITHUB, Cloud Watch, Nagios, Wireshark, Packet trace Redgate. Ticketing Tools Service Now, JIRA.

PROFESSIONAL EXPERIENCE

Confidential, BOSTON, MA

Sr Oracle/AWS Cloud Administrator

Responsibilities:

• Oracle Infrastructure and Operation database administrator support and Responsible to provide 24x7 database administrative activities over different database servers
• Installed OEM 13C, registering databases, creating OEM users, deploying agents, monitoring databases, registered Databases in OEM Administering Oracle Database 10g, 11g and 12c using Enterprise Manager
• Implemented Monitoring Templates and Incident Rule notifications using OEM cloud control 12C/13c for database alerting.
• Involved in designing and deploying a multitude application utilizing almost all of the AWS stack (Including EC2, Route53, S3, RDS, Dynamo DB, SNS, SQS, IAM) focusing on high-availability, fault tolerance, and auto-scaling.
• Migrated the current Linux environment to AWS/RHEL Linux environment and used auto scaling feature.
• Install and configure chef server / workstation and nodes via CLI tools to AWS nodes.
• Increasing EBS backed volume storage capacity when the root volume is full using AWS EBS Volume feature.
• Created AWS Route53 to route traffic between different regions and Deployed and supported Memcache-AWS ElastiCache.
• Working with GitHub private repositories and Created S3 backups using versioning enable and moved objects to Amazon Glacier for archiving purpose.
• Extensively working on designing schemas for OLTP & OLAP databases using PostgreSQL, MySQL and Oracle database solutions.
• Extensively working with cloud based database environments preferably AWS cloud.
• AWS Oracle RDS, Aurora Postgres SQL, MySQL as well as experience managing a large Oracle database on EMC Storage in a data center environment
• Configured Security group for EC2 Window and Linux instances and for puppet master and puppet agents.
• Experience with monitoring tools such as Cloud Watch.
• Used Oracle PL/SQL and SQL*Plus programming to write stored procedures, queries, objects, and views on normalized database tables for IRA module.
• Wrote larger and complex PL/SQL procedures and functions to efficiently perform complex business logic to summarize data for reporting module.
• Exadata and Involved in moving databases in Exadata x4-2, x3-2 Environments
• Handling service requests within Service line agreement and Assisting in implementation of change control process in production and Handled daily production problems/change requests (DBCRS) with Oracle
• Installed and supported the Clean Address add-on product for Banner.
• Created User accounts, Roles and granting required access permissions and privileges to the database based on the applications they are accessing.
• Configured and Installed Oracle-Wallet-Management (OWM) for Data Security.
• Used Service Now tool for all change management process
• On-Call 24x7 production DBA support and Worked with off-shore and coordinating work with prod support for managing databases

Environment: Oracle 11gR2/12C, RHEL 6.X, OEM cloud control 12C/13c/11g/10g, RAC, NFS, Data guard, GoldenGate, VMWARE, AWR, ASH, ADDM, EXPLAIN PLAN, Opatch auto, VMSTAT, DSTAT, UPGRADATION 11g TO 12C, Oracle Transparent Data Encryption, EXADATA, Data pump, SQL, PLSQL, TOAD, UNIX,AWS (EC2, Auto-Scaling, S3, putty and Winscp.

Confidential, CHICAGO, IL

Sr. Oracle DBA

Responsibilities:

• Operation database administrator support and Responsible to provide 24x7 database administrative activities over different database servers.
• Installed 12c Real Application Cluster and involved in migration of standalone databases to RAC Cluster
• Involved in capacity planning, Tuning the RAC interconnect, Finding RAC wait events. And Tuning the RAC using the Enterprise Manager Grid Control.
• Maintaining ASM in RAC environment and Monitoring Health checks OCR, voting files and Interconnect for better performance and troubleshooting issues in RAC environment (11GR2 and 12c)
• Performed Cross platform migration and used Oracle Golden Gate to transfer database from Hp-unix to RHEL configured integrated extract, integrated replicate and coordinated replicate on oracle multitenant databases 12.1.0.2
• Configured an AWS Virtual Private Cloud (VPC) and Data Base subnet group for isolation of resources within AWS RDS.
• Amazon RDS automatically patches the database software and backs up database, storing the backups for a user-defined retention period.
• Worked on Cloud Migration project, worked on servers and databases running on VMware
• On-Call 24x7production DBA support and Worked with off-shore and coordinating work with prod support for managing databases

Environment: Oracle 11gR2/12C, RHEL 6.X OEM 12C, RAC, NFS, Data guard, GoldenGate, VMWARE, AWS RDS, AWR, ASH, ADDM, EXPLAIN PLAN, Opatch auto, VMSTAT, DSTAT, UPGRADATION 11g TO 12C, RDS, EXADATA, Data pump, SQL, PLSQL, TOAD, UNIX, AWS (EC2, Auto-Scaling, S3, putty and Winscp.

Confidential, IA

Sr. Oracle DBA

Responsibilities:

• Implemented Oracle Database 11gR2 2 node Real Application Cluster (RAC) using Oracle Cluster-ware on UNIX and Installed RAC on Linux.
• Installed and Configured Oracle 11g databases on AIX 6.1 and RHEL 6.X
• Worked on large databases size greater than 12TB.
• Installation, Maintenance, Administration and troubleshooting of Red hat Enterprise Linux 5.x/6.x servers on various hardware platforms. pre- requisites were correctly coded and all other pertinent aspects of the catalog were accurately code
• Configured, and maintained Apache web server from open source with Java and Tomcat.
• Maintained systems configuration and managed the installation and integration of systems patches, updates and enhancement.
• Implemented Best Practices for migration databases to Oracle EXADATA x3-2
• Migrating the databases from non-Exadata environments to Exadata environments using Dataguard switchover.
• We successfully switched and failed over databases to secondary databases during DR testing using Dataguard broker.
• Configured Dataguard broker and involved in annual Disaster recovery testing
• Involved in designing of Disaster Recovery using Data Guard and High Availability using 11g RAC.
• Achieved High Availability, Data protection and Maximum performance by maintaining both Physical and Logical Standby databases.
• Implemented Oracle database backup & recovery solutions using RMAN.
• Upgradation of SQL server versions and applying patches and hot fixes.
• Adding nodes to already existing clustered servers as a part of data load\High availability
• Configured Transactional Replication and Log Shipping with SQL Server Management
• Tuned the Database with Initialization Parameters. Viewing the Initialization Parameters with Enterprise Manager. Increasing Performance by Tuning the DB CACHE SIZE parameter.
• Managed the BANNER Catalog and all related screens and tables.
• Implementation of SQL server logins, Roles and Authentication modes as a part of security policies.

Environment: Oracle, 10g, 11g, Unix, Sun Solaris, Linux, RAC, DBCA, GOLDENGATE v11, v10, Dataguard, EXPLAIN PLAN, DATAPUMP, EXADATA x3-2, ASM, RMAN Cloning, OEM 11g,12c, STATSPACK, TKPROF and putty, SQL Server 2008,2008R2,2012, log shipping, Mirroring

Confidential

Oracle DBA

Responsibilities:

• Implemented Oracle Database 10g R2 Node Real Application Cluster (RAC).
• Maintained and troubleshooting cluster-ware components in 10G RAC environment.
• Installed 10g standalone servers on Sun Solaris and installed databases on it.
• Used oracle configuration assistants like Database Configuration Assistant (DBCA) for creating databases, Database Upgrade Assistant (DBUA) for upgrading databases.
• Configured listener and TNS names manually.
• Involved in Up-gradation of databases from 9i to 10g.
• Configured Oracle Data-guard for Oracle Disaster recovery on 10g Solaris.
• Achieved High availability, Data protection and maximum performance by maintaining both physical and logical standby databases.
• Converted physical standby databases to Snapshot standby database.
• Implemented Oracle database backup & recovery solutions using RMAN.
• Configured and Tuned RMAN for better performance and backup strategies.
• Involved in writing for shell scripts for taking RMAN backups.
• Restored and Recover database at the times of occurrence of critical failures.
• Created user accounts, roles and granting required access permissions and privileges to the database based on the application they are accessing.
• Experience in Installing, upgrading and configuring Red Hat Linux.
• Experience in administering, installation, configuration, support and maintenance of Linux.
• Performed large batch jobs and tuning of SQL queries and database systems.
• Performed automated backups and scheduling using scripting.
• Written Stored Procedure and Triggers for database maintenance and management using PL/SQL and Involved in gathering requirements from end users.
• Estimate growth of database size by detail analysis of the company's future policies and generating reports for the management to act in advance.
• Clear documentation was prepared on all the processes like program specification, bugs fixing logs & change requests for future reference

Environment: Oracle /10g/9i, Sun Solaris 5.x, Unix, OEM 10g, Shell Scripting, Oracle 10g RAC, TOAD, putty, STATSPACK, EXPLAIN PLAN.