SUMMARY:

• Over 20 years of experience in Database management, operations management, project Management, client management, Resource management, vendor relationship management and budget planning.
• Experience with AWS Cloud Migration of Oracle Databases.
• Expertise in creating and launching EC2 instances using AMI’s of Linux, Ubuntu, RHEL, and Windows and wrote shell scripts to bootstrap instance.
• Expertise in working with Oracle, DB2UDB, MySQL and Sql Server databases
• Over 18 Years of experience working with Oracle Database Administration on AIX, Linux, HP - UX &Windows platforms.
• Experience and expertise in using SQL and PL/SQL to perform data aggregations, creating stored procedures, functions and triggers for data access routines and other DML activities.
• Extensive experience for designing and implementing backups using RMAN
• Wide experience in Data cleansing using various tools and stored procedures.
• Strong knowledge and experience in managing SQL Server databases.
• Demonstrated leadership abilities and effective communication and presentation skills.
• Recognized by senior management as customer-oriented professional with proven negotiation skills.
• Expertise with SCRUM, AGILE, ITIL methodologies and proficient with governance and regulatory compliance
• Extesnsive experience in implementing No SQL Databases (Mongo DB, Mark Logic)
• Solid experienced in supporting databases over 100 TB with over 5000 users.
• Experience in Migrating Oracle Data warehouse databases to AWS Redshift and experienced with Redshift, Aurora, MongoDB.
• Experienced in migration Project experience from Oracle 11gR1 to 11gR2, 9i to 10g and 8i to 9i using export & import as well as in place methods
• Experienced in Data Analysis, Requirements Gathering, Design, Development, Testing and Implementation.
• Excellent experience in architecting and implementation of Disaster recovery tools.
• Expertise in creating and launching EC2 instances using AMI’s of Linux, Ubuntu, RHEL, and Windows and wrote shell scripts to bootstrap instance.
• Experienced with installation of AWS CLI to control various AWS services through SHELL/BASH scripting.
• Experienced in writing complex SQL queries and scheduled tasks using cron jobs.

TECHNICAL SKILLS:

Operating Systems: Solaris, AIX, HP -UX, VMS, Windows

Databases: Oracle, DB2 LUW, SQL Server, MySQL

Cloud Technologies: AWS, EC2, RDS, S3, GLACIER, Gold Image

No SQL Databases: Mongo DB, Mark Logic

Advanced Database: RMAN Backup and Recovery, Exadata/Multi-Tenant Architecture, Golden gate, Performance Tuning, Real Application Clusters (RAC), Data GuardASM Storage Management, Oracle Enterprise Manager (OEM), HTML DB Grid Control, Data Modelling, Golden Image, Glacier

System Applications: Demantra, Erwin, PeopleSoft HRMS, Seibel 2000, Veritas NetbackupEMC storage manager, Informatica, Business Objects, COGNOS reportsEllucian Banner8/XE, Veritas Filesystem, Data Junction, OAS, Oracle Reports

Languages: Visual Basic, C, C++, PowerBuilder, Shell scripts, Visual Basic, Java, HTML, XML

Project management Tools: VISIO, MS-Project, MS-Office, SCRUM, AGILE, ITIL

PROFESSIONAL EXPERIENCE:

Sr. Oracle Architect/DBA

Confidential, Arlington, VA

Responsibilities:

• Migrated 11g and 12c databases to AWS Cloud Infrastructure. (EC2)
• Applied patches in AWS and hardened Security for Oracle Databases in AWS ( EC2)
• Created instances and built gold images for Rapid deployment in EC2.
• Created users and enforced controls using roles and profiles across Patching,Development,Testing,Staging,, Data Migration and production environment.
• Implemented backup strategy using RMAN and S3 backup to Glacier in AWS
• Implemented Oracle Data Guard as part of the Disaster Recovery Strategy.
• Implement Oracle Database backups and Monitoring (Scripts and 13c OEM)
• Worked on S3 data storage and retrieval, backup and restore.
• Lead the efforts to Architect the Oracle Database infrastructure (11g and 12c)
• Senior Oracle DBA supporting around 200 databases, of all kinds with over 100 Terabytes and 800 users.
• Lead for Oracle 12c JDE Database Upgrade and Compression Project
• Lead for Oracle 12c Database Character Set Conversion Project Using Database Migration Assistant.
• Tracking project dependencies outside of the project team's control and escalating issues as necessary.
• Implemented RMAN backup & Recovery Strategy.
• Documented Best practices and standard operating procedures for On-call and Backup & Recovery.
• Created methodologies for governance and compliance.
• Implemented database security by creating user roles and profiles and worked with the Security Team for Configuring Splunk.
• Involved in production DBA activities to support Mission Critical databases.
• Involved in Capacity Planning for new server additions and database growth, Production Database Support
• Tuning of Database performance and SQL queries to help the application team.

Sr. Database Consultant

Confidential, Los Angeles, CA

Responsibilities:

• Lead the efforts to evaluate and implement hardware platforms for consolidating databases on multiple SMP servers (Grid & AWS Cloud)
• Implemented and Administered Oracle Exadata in Oracle X2/X3/X4 full rack Exadata machines.
• Tracking project dependencies outside of the project team's control and escalating issues as necessary.
• Facilitating cross-group and cross-functional communications for issues resolution and updates
• Facilitated, coached, and guided the teams on the values and practices of Agile and Scrum.
• Coordinated activities of multiple Scrum Teams.
• Collecting and analyzing project metrics data and working with the Scrum Master, Product Owner and Scrum Team to identify and in corporate corrective actions when needed.
• Capacity planning for database systems (p series and x86 platforms)
• Created database benchmark criteria and published reports
• Evaluated and recommended tools for increasing productivity
• Implemented multi-node RAC database systems (10g, 11gR1/R2 and 12c)
• Implemented Golden Gate for database replication.
• Designed and implemented Oracle Application databases for Mission critical and Life Critical applications.
• Helped with performance tuning of complex OLAP/DSS & OLTP database applications.
• Implemented databases for Demantra and Hyperion Applications
• Installed and configured 10g and 11g OAS on Linux
• Documented Best practices and standard operating procedures for On-call and Backup & Recovery
• Created methodologies for governance and compliance
• Implemented Oracle Enterprise Manager Monitoring for Oracle databases
• Tuned database performance and SQL query performance.
• Generated daily, weekly and monthly reports for management.
• Implemented Virtualization solutions for Dev and Test databases using VMware.
• Upgrade of database from 8i/9i/10g to 11.1.0.7, 11.2.0.x and 12c (AIX/Linux/Windows)
• Applied periodic PSU patches for Non-RAC and RAC databases on Linux and AIX
• Implement backup strategies for OLTP and DW databases
• Provide 24/7 on-call support for databases as required

Senior Database Administrator

Confidential, West Hollywood, CA

Responsibilities:

• Heavily involved in the Databases design using ERwin
• Install and maintain large Oracle and MySQL database environments
• Lead Implementation efforts and mentor Junior DBA's
• Worked with a team of developers to create an online Java application with an Oracle database as the backend
• Capacity planning for database systems (Oracle and MySQL on Linux)
• Upgrade of Oracle (from 8.1.7 to 9i and 10g)
• Support On going Project Development efforts
• On call Support of all database systems
• Implementing High Availability solutions (Data Guard and RAC on Linux)
• Implement RMAN Backup and restore Strategy for Oracle databases
• Performance tuning of Oracle and MySQL server databases (In house and vendor supplied)
• Perl scripting for Database refresh and data movement.
• Troubleshooting JDBC connectivity in RA and Non-RAC environment
• Implemented Shareplex replication for mission critical databases
• Applying Patches for Oracle databases
• Implemented Oracle Streams for data replication
• Refresh of huge databases across different database environments.
• SQL tuning for Oracle and MySQL databases

Senior Database Administrator

Confidential, Portland, OR

Responsibilities:

• Involved in Databases design using ERwin
• Install and maintain large Oracle and DB2 UDB database environments on Linux and AIX
• Capacity planning for database systems (DB2 UDB EEE and Oracle)
• Upgrade of Oracle (from 8.1.7 to 9i and 10g) and DB2 UDB (from 7.2 to 8)
• Support On going Project Development efforts
• Troubleshoot client connectivity issues for Oracle and DB2 UDB
• On call Support of all database systems
• Install, Upgrade and maintenance of Sql server databases
• Implementing High Availability solutions (Data Guard and RAC Linux/AIX)
• Implement RMAN Backup and restore Strategy for Oracle databases
• Create and implement maintenance plans for Sql server databases
• Implement BCV split-mirror backups (EMC) for DB2 UDB EEE databases
• Performance tuning of Oracle, DB2 UDB and Sql server databases (In house and vendor supplied)
• Scripting for Database refresh of huge databases
• Implemented Shareplex replication for mission critical databases
• Applying Patches for Oracle and Sql server and Fixpacks for DB2 UDB
• Implemented Foglight proactive monitoring for databases
• Refresh of huge databases across different database environments.
• Lead implementation efforts and mentor Junior DBA's
• Sql tuning for Oracle and UDB databases

Lead Database Administrator

Confidential, Austin, TX

Responsibilities:

• Provided Guidance and instructed the group of DBAs to install and configure Oracle 8i server on Solaris 2.8, HP-Unix and Red Hat Linux
• Created Data Marts and Date Warehouse Dimensions, facts and Cubes
• Ensured 24x7 database availability, using Oracle standby database
• Implemented Advanced and Snapshot Replication using Quest Shareplex
• Installed and configured Oracle RMAN using veritas NetBackup for database backups.
• Installed and Upgraded Oracle Applications 10.7 to 11i. The following modules were fully installed: ALR, AX, AK, GL, RG, QA, ICX, AZ, AP, AR, OE, PA, INV, BOM, WIP, PJM, EC, PO
• Maintained the APPL TOP, performed Reorgs, Concurrent managers and implemented Multi-Org
• Religiously applied Application Patches apart from monitoring and tuning the App
• Administered, Monitored and troubleshooted DB issues for the People soft HRMS 7.0
• Installed and configured Business objects.
• Created and maintained the Consteller HUB repository on Oracle and DB2.
• Planned the storage capacity for the database servers by forecasting data growth
• Partitioned the data warehouse tables for better performance, high availability and maintainability
• Designed and implemented the Disk layout using veritas file system and EMC storage manager
• Designed and built test, development, and production databases, as well as other schema objects.
• Established centralized SQL*Net connectivity in a TCP/IP network environment.
• Implemented proactive database monitoring using Quest Foglight.
• Tuned and optimized database performance and ensured database security and provided production support.
• Installed and Configured Oracle Intermedia and implemented data communication between databases by creating database links and by using Oracle utilities, including import, export, and SQL*Loader.
• Implemented database security by creating user roles and privileges.
• Installed Quest software products like Spotlight on oracle, schema manager and TOAD for efficient database monitoring and effecting the database operations
• Created the databases and other database objects according to system specifications.
• Migrated data from a mainframe to an Oracle environment.
• Created and maintained user accounts, including specifying roles and privileges.
• Engaged with Vendors like Oracle, Dell and Sun Microsystems
• Designed and implemented backup and recovery strategies for the database environment.
• Designed and implemented certain aspects of data modeling and data conversion.
• Participated in performance tuning and monitoring on both the application and server sides.
• Implemented data communication between databases by creating database links and by using Oracle utilities, including import, export and SQL*Loader.