SUMMARY

• Oracle and MS SQL Server Certified professional with 11 years of experience as a Database Administrator having hands on experience in database design, administration, production support, installation, configuration, upgrades, patches, performance tuning, backup and recovery, Disk space management, database security, database cloning, database migration, data encryption, shell scripting and documenting best practices and support procedures.

TECHNICAL SKILLS

RDBMS: Oracle, SQL Server

NON - RDBMS: Hadoop & MongoDB (Oracle 19c/18c/12c/11g/10g/9i, PostgreSQL 12.0 and 11.5, MySQL 5.7, MS SQL server 2005 to 2017, Cloudera Hadoop 5.x&6.x, MongoDB 3.x, 4.0 & 4.2.)

Cloud Infrastructure: AWS, VPC(VRA)

Fusion Middleware: Golden Gate, WebLogic

Engineered Systems: EXADATA, Veritas

Operating Systems: Red Hat Linux, Oracle Linux, HP-UX 10.x, 11.x, Sun Solaris, IBM AIX, and Windows 2003/2008/2012.

Languages: SQL, PL/SQL, NOSQL, T-SQL, Shell Scripting(bash) and Python

SOFTWARES, APPLICATIONS & TOOLS: Oracle RAC, Data Guard, OEM(12c &13c), DGMGRL, RMAN, ASM, VERITAS Net Backup, Data Domain (EMC), AWR, ASH & ADDM, TKPROF, EXPLAIN PLAN, SQL*TRACE, Oracle TDE, Oracle IDM, OBIEE12, Oracle APEX 5.1.4 and 18.1, SQL Developer, Toad, SQL*Loader, Datapump, PowerBuilder, SolarWinds DPA, Mongo OPS manager, AWS CLI, Netcool, SNMP, Authentication(LDAP, Kerberos)

DevOps & Tools: GitLab, Jira, Ansible, Terraform, Jenkins, Atlassian, SVN, Flyway, Agile Scrum/Kanban, DevOps, BMC, SWIFT, ServiceNow, Confluence, SharePoint.

Domains Experience: Financial, Banking and Telecommunications

Personal Attributes: Flexible, Adaptable, Ownership, Knowledge sharing attitude, Solution oriented

PROFESSIONAL EXPERIENCE

Confidential

DBA

Environment: Oracle 19c/18c/12c/11g, OEM (GC) 13c, Data-Guard, RAC, ASM, Golden Gate, RMAN, Exadata X8,X6-2,X4-2,X-2 ODA, PCA, Oracle APEX 5.1.4 and 18.1, RHEL 7, 6, Oracle Linux 7, Solarwinds DPA, Service NOW, Jenkins, IBM DB2

Responsibilities:

• Administered Oracle Database Infrastructure by installing Oracle 19c/18c/12c and 11g databases using RAC, ASM, Data Guard instances and Golden Gate Infrastructure to increase high availability, scalability, and disaster recovery on Red Hat 7 and OEL 7.
• Created and maintained Oracle 19c/18c/12c CDB and PDB’s. Multiple databases clones/duplicates in multi-tenant architecture.
• Upgraded databases from 12c/18c to 19c. And applied Oracle Patches and patch sets in Server side and Client side.
• Performance Tuning: Worked closely with Application Team/Developers, troubleshooting with various monitoring tools and scripts, generate various Reports, Explain Plan, create SQL Profile and baselines - administer them.
• Working experience with developers and application testing teams to ensure application design as efficient and avoid any reactive performance issues, resource contention and any bottlenecks.
• Expert in Database, application, O.S and network level performance Tuning and Optimization skills, including SQL re-write for optimum performance. AWR, ASH, ADDM, OEM, SQL tracing and TKPROF.
• Resolved database performance, capacity, replication, and other distributed data issues.
• RAC/RAC One Node: Installations, adding/deleting nodes, Upgrade, create/delete databases, Administration, troubleshooting and Patching. ASM: Administration, maintenance, troubleshooting, Storage Migrations.
• Dataguard: Physical/Logical/Snapshot Standby and ADG databases creations, administration, troubleshooting, DR Tests: (Switchover/Switchback & Snapshot/Activate DR database in R-W for Bubble testing).
• OEM: Install, Configure, Administer, Security, Patch and Complete Upgrade Experience from OEM 12c to OEM 13c .
• Goldengate: Installation, Setup & Configurations, Upgrade, Administration, troubleshooting, Patching and migrations.
• Data Refresh: Performed database refreshes between environments using Datapump and RMAN.
• Migrations and GO Lives: Several migrations experience from file system/standalone/RAC to ASM/RAC/Engineered systems using RMAN/Datapump.
• RMAN: Configuring Backups strategies for both Target and catalog databases, Administration, troubleshooting, Restore and Recover in case of disaster incidents.
• Expert in designing and documenting database backup and restore, data redundancy, data auditing and disaster recovery strategies. And database cloning, database duplication and datapump.
• Flashback, Database Re-Org, Security, Day to day DBA activities like Prod, Non-Prod Support, Work on Tickets/CRQs/Incident tickets/Violations.
• Security: Experience in Database Security Policies, User Management, Auditing, Profiling, Authentication and Oracle advances security features like TDE.
• Experience in install, configure, administer, and upgrade Oracle APEX 5.1.4 and 18.1.
• Collaborated closely with application and infrastructure teams (Finance/Application/Storage/SA/Network/Offshore) on several issues and day to day support.
• Expert in design, configure and administering distributed databases along with batch loading and data reporting.
• Extensively involved in logical design, physical design, capacity planning, and user account management.
• Worked as great Collaborator, support each other, do smooth handoff on any work to shift people, do share knowledge document and presentation.
• Expert in automating database tasks like schema refreshes, log monitoring, SQL change deployments using ansible and shell scripting.
• Experience in configure and setup Oracle Identity Management (IDM) to manage user privileges in enterprise level.

Confidential, Tampa, FL

Sr. DBA/Off-shore team lead

Environment: RHEL 7, 6 OEL 6,5 AIX 5.3, 6.1,7.1 Solaris 5.10 and Windows 2003, Oracle 9i,10g,11g&12c, SQL server 2005 to 2017, OEM(12c), Data-Guard, RAC, ASM, Golden Gate, Data Domain(EMC), OBIEE 12.2.1.0.0 , Big Data(Hadoop), Kafka, Streamsets, MongoDB 4.2, PostgreSQL 12.0 and 11.5, MySQL 5.7,5.6&5.1, Gitlab, Jira, SVN, Agile, DevOPS

Responsibilities:

• SQL Server: Experience in MS SQL Database Administration, Design, Development, Installing and Support of MS SQL Server 2017/2014/2012/2008 R2 in Production, Testing and Development Environment’s.
• Experience in Installing and configuring Cluster MS SQL Servers in Active/Passive and Active/Active environments.
• Experience in implementing different types of Replication topologies involving Snapshot, Merge, Transactional and updatable.
• Implemented Backup and Restore in MS SQL Server using Native SQL Backups and using Third party tools like VERITAS Net Backup.
• Extensive Monitoring of SQL Server with DMVs, SQL Server Management Studio (SSMS) and Third-Party Tools like SolarWinds DPA.
• Experience in Performance Tuning, Query Optimization, Database Consistency Checks using MS SQL Server DBCC Utilities and Linked Servers.
• Experience in writing T-SQL (DDL, DML) scripts, Stored Procedures, Functions, Triggers and Views to facilitate data manipulation and data consistency.
• Experienced in Loading data into multiple tables using DB Management Tool like SQL*LOADER, Import/Export.
• Experienced in Migrating data from SQL Server 2005/2008 R2/2012 to Oracle 11g databases using SQL loader and flat files.
• Organize, Install, configure, maintain and tuning of Oracle 12c and 11g databases on Red Hat 7.x, Oracle Linux 6.x and AIX 7.x environments.
• Experience in upgrading databases from Oracle 9i,10g,11g to Oracle 12c on RHEL, Oracle Linux, Sun Solaris, and AIX platforms.
• Applied Oracle Patches and patch sets in Server side and Client side.
• Experience in replication like Oracle Golden Gate, clustering, and Dataguard of Oracle databases.
• Experience in creating and Maintaining both Physical and Logical standby databases for 9i,10g,11g and 12c databases.
• Experience in Design, implementation and generating documentation of Oracle 11g & 12c Data Guard on both physical/logical standby databases in high availability mode.
• Proficient with using Oracle Enterprise Manager and monitoring databases effectively with Netcool Incident Management tool.
• Experience in the data analysis, design, development, testing, project planning and implementing of major Database structures.
• Experience in Develop and Implement database maintenance plans, including performing integrity checks, updating statistics and monitoring security and hardware resource utilization.
• Experience in Creating & Managing Database Structures and Storage Allocations.
• Experience in Database Security User Management, Database Access, Roles, Privileges, Auditing, Profiling and Authentication.
• Experience in Backup/Restoration Strategy, Planning and scheduling Backups, taking Logical Backups with Data pump utilities.
• 24x7 On Call Production database support and provided support for database developers & end-users whenever needed.
• Experienced in using diagnostic tools (ADR, ADRCI and RDA) to submit diagnostic information to Oracle Support to resolve the database issues.
• Good experience in UNIX shell scripts to manage Oracle environments and for Backend Oracle Processes.
• Proven ability to effectively manage multiple priorities and meet deadlines.
• Experience in Configure database server to work with middleware, web server and Online Analytical Processing (OLAP) tools.
• Good understanding of business requirements of a large organization and reflect those needs in proposed IT solutions.
• Good experience in working with onshore/offshore teams and junior DBA's as team lead.

Confidential, Campbell, CA

Oracle DBA

Environment: Red Hat Linux 5.1, 5.2,5.3,5.8 AIX 5.3, 6.1, Solaris 5.10 and Windows 2003, Oracle 9i,10g and 11g, Oracle Enterprise Manager (GC), Data-Guard, RAC, ASM & Clusterware, VCS, RMAN, Net Backup, FRA

Responsibilities:

• Organize, Install, configure, maintain and tuning of Oracle 11g, 10g and 9i databases on Red Hat 5.x, Oracle Linux 6.x, AIX 6.x & Solaris 5.10 environments.
• Advanced knowledge of working in Unix/Linux environments.
• Experienced in upgrading databases from Oracle 9i, 10g (10.2.0.4) to Oracle 11g (11.2.0.2.0) on RHEL, Sun Solaris and AIX platforms.
• Experienced in installation of Oracle Grid Control Agents in all environments for production, test and development databases and configuring them for monitoring.
• Experienced in Creating & Managing Database Structures, Storage Allocations, Table/Index segments, Constraints and Rollback segments.
• Experienced in Database Security User Management, Database Access, Roles, Privileges, Auditing, Profiling and Authentication.
• Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics for the same.
• Implemented VERITAS Net Backup and Data Domain backups using RMAN as a media management layer.