SUMMARY

• An accomplished Oracle DBA over 8 years of experience on UNIX/Sun Solaris/AIX and Windows with expertise in Crisis Management, Database Activity Monitoring, Database Security, Disaster Recovery and High Availability solutions to increase reliability and introduce system efficiencies.
• Experience in Supporting database in Amazon Web Services (AWS)
• Experience in Supporting database in Microsoft Azure
• Oracle Advanced Security Option (Oracle Transparent Data Encryption, Audit Vault, Database Vault)
• Implementing High Availability Solution, Administration, Troubleshooting and Testing
• IBM Guardium Administration for Database Activity Monitoring
• Extensive knowledge in Database Backup and Recovery concepts using RMAN utilities (scheduling full/incremental/cumulative backups, hot/cold backups writing/editing UNIX Shell Scripts for RMAN)
• Experience in Logical Backup's and Database migration tools with Data Pump, Export/Import and Transportable Table spaces
• Proficient in Database Administration activities such as Upgrades, Patches, Cloning, Backup, Recovery, Performance Tuning, Trouble shooting, capacity planning, script development, and documentation
• Security administration including creating and maintaining user accounts, passwords, access rights
• Identify DB requirements, such as monitoring, analyzing, change activity deployment, and script to monitor.
• Experience in Capacity Planning, Space Management, Database Upgrades / Migration Data Extraction.
• Develop UNIX shell scripts, Perl scripts, TSQL, SQLs, PL/SQL procedures, functions, packages and triggers to support and automate repetitive tasks.
• Create and maintain documentations for all major installation, implementations and known issues
• Experience in Logical Backup's and Database migration tools with Data Pump, Export/Import and Transportable Table spaces.
• Extensive experience in supporting database on Oracle Exadata Database Machine
• Implementing Disaster Recovery Solutions, Administration, Troubleshooting, and Testing using Oracle Dataguard
• Strong leadership, technical, planning, troubleshooting, documenting, and analytical skills with excellent interpersonal and communications abilities

TECHNICAL SKILLS

Operating System: UNIX - Solaris, AIX, Linux (Red Hat, Oracle Linux), Microsoft Windows Server

Databases: Oracle 9i, 10g & 11g, MS SQL Server, MySQL

Programming Languages: SQL, PL/SQL, Unix/Linux Shell Scripting, T-SQL, Perl, Python

Software Application Areas: Oracle RAC, Oracle Data Guard, SAP BI Reporting, Microsoft SQL Server Integration Services (SSIS), Oracle Streams, VMWare EXSI, BMC Remedy Change Management, Visual Basic, ZFS Appliance, SQL*Loader, WebLogic, Golden Gate, NetApp, Multi-pathing, TCPIP, Hadoop, Cloudera, SPLUNK, AWS, CyberArk

PROFESSIONAL EXPERIENCE

Confidential, NC

Cloud Database Administrator/ Database Security

Responsibilities:

• Creating security, parameter and options groups for RDS databases
• Creating and supporting database in an Azure environment
• Setup disaster recovery solutions using dataguard in an Exadata environment
• Applying oracle patches to database running on EC2 instances
• Refreshing RDS databases leveraging bastion host
• Creating EC2 instances for Oracle and SQL Server deployments
• Installing Oracle and administering databases on EC2 instances
• Creating RDS snapshots in AWS for backup and restores when needed
• Upgrading SQL server databases from 2008 to 2012
• Creating database backups using Redgate
• Restoring sql server databases and tables using Redgate
• Documented and executed test cases for 11g and 12c database for database vault
• Installing certificates to remediate SSLv3 vulnerability for OEM 12c
• Installing Oracle 11g/12c on OEL, RHEL, AIX, and Solaris
• Primary On-call DBA daily during business hours and be available for week-end On-call support
• Analyze performance issues. Verify and tune SQL plans, queries as needed
• Co-ordinate with application team and developers in resolving issues and prepare deployments plans
• Preparing weekly status reports and presentation slides for monthly review meetings with client.
• Upgrading grid infrastructure from 11g to 12c for Exadata and for stand-alone boxes
• Set up OEM 12c to monitor databases in AWS using option groups

Confidential, Virginia

Oracle Database Administrator

Responsibilities:

• Setup disaster recovery solutions using dataguard in an Exadata environment
• Migrated databases into databases on EC2 and RDS instances
• Upgraded Grid Infrastructure from 11g to 12c for Exadata and for stand-alone boxes
• Installed and set up OEM 12c and adding multiple hosts to OEM for monitoring
• Installed and configured Golden gate for replication and resolve issues to sync Databases
• Setup high availability solutions using Oracle RAC (12c) and Golden Gate
• Conducted planning and sizing for Oracle databases
• Implemented Oracle’s Transparent Data Encryption for all database environments
• Installed standalone and clustered Weblogic environments
• Analyzed database requirements for Developers and Business Systems Analysts
• Created and maintained appropriate documentation as it relates to database creation/implementation
• Worked simultaneously with other departments and/or outside contractors to resolve system production problems
• Implemented High availability using Golden Gate Replication. Implanted Bi-directional replication using golden gate

Confidential, Virginia

Database Administrator

Responsibilities:

• Performing database-level and schema level refreshes as needed by development team
• Cloned databases for application team for testing purposes
• Patched cloud control agents
• Installed Oracle E-business suite POC environment
• Installed Oracle FMW POC environment
• Worked with Oracle support in resolving bugs, bug fix patches, multiple sev 1 SRs
• Implemented oracle standard procedures for purging, archiving
• Checking alert logs and trace files to monitor the database on daily basis
• Performed multiple clones from Production to Test environments
• Performed tracing for various user sessions and for various concurrent Programs.
• Implemented Oracle ASM for single instance database and resolving ASM related issues
• Upgraded Oracle software from 11.2.0.1 to 11.2.0.3 in Dataguard environment

Confidential, Virginia

Oracle Database Administrator/Production Support

Responsibilities:

• Daily system checks, performance monitoring, backup report checks, and space allocation management
• Maintenance of core application databases storage structures and primary objects
• Created work-plans for server-level and database-level changes
• Involved in managing and supporting 4-node cluster environment on Exadata
• Monitored and managed multi-terabytes (TB) production databases, supporting critical health care application systems
• Refreshing tables, schemas, and databases using Datapump Import/Export utility
• Monitoring standby database configuration and troubleshooting lag issues
• Led DBA status call meetings to discuss DBA-related issues
• Worked with application developers to duplicate production database for testing and development
• Represented DBA team on Change Advisory Board (CAB) meetings for change management

Confidential, Virginia

Database/Security Administrator

Responsibilities:

• Refresh multiple database schemas and databases using Datapump
• Led, designed and implemented Oracle security (Oracle TDE, Audit Vault, Database Vault) in multiple Exadata environments
• Led a team of DBAs to implement Oracle security components
• Generated audit reports to comply with SOX (Sarbanes-Oxley Act) and auditing policies
• Implemented Disaster Recovery solution using Oracle Dataguard in a RAC environment which uses ASM
• Implemented High Availability solution using Real Application Clusters
• Architected, created and modified database structures as required by developers due to business or application requirements
• Installed Oracle Enterprise Manager 12c to be used to monitor Exalogic, Exadata engineering systems, Middleware components, amongst other environments
• Developed and tested backup and recovery strategies that adhere to State policy
• Worked with network team to resolve database connectivity issues and all network-related issues
• Upgraded Grid Infrastructure and Oracle Software from 11g to 12c in Test Environment

Confidential, Virginia

Microsoft SQL Server Developer/Administrator

Responsibilities:

• Performed SQL Server database including configuring scheduled Tasks for regular Database Backup and Maintenance Activities
• Created and modified tables, stored procedures, various clustered and non-clustered indexes, triggers, check constraints and functions
• Created SSIS packages to automate reporting and other Ad-hoc requirements
• Built ETL processes utilizing SSIS and DTS, including FTP data from remote location, transform it, mart it to data warehouse and provide proper error handling and alerting
• Generated Reports for high visibility databases using SSIS and SSRS
• Configured database mirroring for mission critical databases
• Managed users including creation/alteration, grant of system/db roles and permission on various database objects
• Created documentation and implementation of migrating DSS databases from one server to another

Confidential, MD

Database Administrator

Responsibilities:

• Responsible for installing, configuring, and monitoring, administering and maintaining Oracle database that meets production, stage, development and test requirements
• Used RMAN, ASMTOOLG and ASMCMD utilities to migrate the Non-ASM Database to ASM Database
• Implemented automated backups and recovery procedures of databases using User-Managed and Server-Managed (RMAN) backups
• Applied patches to oracle databases to fix vulnerabilities
• Worked with application team to tune databases
• Cloned databases from production to stage environments, or production to development environments for test, and troubleshooting purposes
• Performed database administration tasks in a MySQL database environment
• Measured and analyzed the performance of application SQL statements using various tuning tools, and provided recommendations to the application teams for usage of Indexes and Hints
• Supported databases in Microsoft SQL Server environment
• Prepared the database troubleshooting documents