SUMMARY

• Installation, Upgrading, Troubleshooting, Maintenance and Technical Support for Oracle Databases
• Supporting High Transactional OLTP Environments
• Microsoft SQL Server Database Administration and Microsoft T - SQL Development
• MySQL Database Administration
• Weblogic Administration
• Linux System Administration
• Oracle Exadata Database Machine Administration
• Transition and Transformation of IT deliverables
• Logical and Physical Database Design
• Implementing Disaster Recovery Solutions, Administration, Troubleshooting, and Testing using Oracle Dataguard
• Implementing High Availability Solution, Administration, Troubleshooting, and Testing using Oracle Real Application Clusters and Golden Gate
• Oracle Security tools (Oracle Transparent Data Encryption, Audit Vault, Database Vault)
• 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

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

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

PROFESSIONAL EXPERIENCE

Confidential, Herndon, VA

Oracle Database Administrator

Responsibilities:

• Setup disaster recovery solutions using dataguard in an Exadata environment
• Created backup jobs in OEM for critical DSS databases
• Cloning and deploying OEM agents for monitoring
• Created OEM 12c and added multiple hosts to OEM for monitoring
• Implemented Oracle ASM for single instance database and resolved ASM related issues
• Setup high availability solutions using Oracle RAC (12c) and Golden Gate
• Monitoring and managing multi-terabytes (~50TB) production databases, supporting critical health care application systems
• Conducting planning and sizing for Oracle databases
• Deploying applications to Weblogic and administering the Weblogic Server
• Implemented High availability using Golden Gate Replication. Implanted Bi-directional replication using golden gate

Confidential, Fairfax, VA

Database Administrator

Responsibilities:

• Performing database-level and schema level refreshes as needed by development team
• Duplicating databases for testing purposes
• Managing MySQL databases
• Checking alert logs and trace files to monitor the database on daily basis
• 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, Sacramento, CA

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
• Creating 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
• Provide help to users to resolve database performance and access issues through Remedy tickets
• Lead DBA status call meetings to discuss DBA-related issues
• Applying Oracle Critical Patch Upgrades (CPU Patches) and one-off patches
• Work with application developers to duplicate production database for testing and development
• Representing DBA team on Change Advisory Board (CAB) meetings for change management

Confidential, Columbus, OH

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
• Performed Exadata Database Administration tasks
• Resolved issues with Oracle Audit Vault and Oracle database vault components
• 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, Plano, TX

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
• Used DBCC commands to check physical and logical consistency of the database and rebuild indexes
• Utilized Microsoft JAMS job scheduler to schedule backups and run batch jobs
• Utilized BCP utility to publish table output to text files and vice versa
• Created documentation and implementation of migrating DSS databases from one server to another

Confidential, Silver Spring, MD

Database Administrator

Responsibilities:

• Performed Database Sizing, Tablespace Management, Undo Space Management, Rollback space Management, Transaction Management
• Cloned single instance and RAC production databases as needed for testing, development using RMAN or scripts
• Implemented and maintained Oracle Dataguard Physical and Logical standby databases for disaster recovery. Ensured that standby database is always in sync with production database by checking archive logs and copying missing ones over to the standby database when required
• Worked with application developers, system administrators and management to ensure that any new product usage or release upgrade takes place with minimal impact on test and production environments
• Upgraded Oracle database using DBUA or Data Pump Export/Import
• Performed database physical and logical design and procedures for Production, Development, Q&A, Test and Training servers
• Performed database maintenance by applying required patches and software updates
• Performed database troubleshooting and tuning using ADDM, ASH and AWR Report

Confidential, Juno Beach, FL

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
• 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