SUMMARY

• Over 20+ year's expertise in Oracle Database solutions implementing and managing Enterprise - level Oracle solutions such as Oracle RAC 10g/11g clusters, Grid Control, Data Guard, Streams and CDC replication solutions within Telecom, Online Advertising, and Software development industry.
• Certified Hands - on AWS Architect developing and architecting enterprise level large scale multi-tier solutions that require complex Architectural decisions.
• Hands-on experience on implementing Cloud Solutions using various AWS Services including EC2, VPC, S3, EFS, Cloud Formation, AWS Security.

TECHNICAL SKILLS

RDBMS Databases: Oracle 7.x - 12c, PostgreSQL 9-10, MS SQL Server 2012, MySQL 5.x/8.0

AWS Services: Ec2, Elastic Beanstalk, EFS, VPC, RDS, S3, Glacier, IAM, Cloud Front, Cloud Watch, Cloud Trail, Cloud Formation, Route53, SNS etc.

DB Architectures: Oracle RAC Clusters, Replication using CDC, DataGuard, ASM, PostgreSQL 10, Standby Database/replication, SLONY

Programming Languages: Bash/Korn Shell Scripting, SQL, PL/SQL

Operating Systems: All Unix/Linux flavors

Tools: Grid Control 12/13c (OEM), Toad, RMAN, DataPump, SQL Loader, SQL*Plus, Quest spotlight/Foglight

PROFESSIONAL EXPERIENCE

Confidential

Senior Database Engineer / AWS architect

Responsibilities:

• Support and maintain several databases including production databases running Oracle 10g & 11g and EnterpriseDB PostgreSQL on Linux, Microsoft SQL Server 2008 on Windows Operating Systems. Installed, configured, upgraded and migrated Oracle, PostgreSQL and MySQL Databases.
• Implemented EnterpriseDB PostgreSQL one-to-one Replication, develop and enhance scripts to automate and execute various DBA tasks. Assess the DB performance and lead the effort to patch, upgrade and/or tune the DB for optimum performance and keep the PostgreSQL DBs current.
• Review SQLs and DB transactions developed by software engineers and assist in improving the efficiency of the code for best possible DB performance and support the design of appropriate DB Schema and indexing strategy for performance and scalability.
• Design and implement backups/disaster recovery solutions for the PostgreSQL Database. Review query execution plan and query optimization techniques to optimize query performance. Provide SQL / database support to the application developers and manage the databases in development and QA environments.
• Setup and Monitor schema replication in Oracle 11gR2, migrated Oracle database to EnterpriseDB PostgreSQL, Installed PostgreSQL Databases version 9.3, 9.4, 9.5, 9.6 and 10, implemented master/slave PostgreSQL database on 3 node cluster with pgpool and Haproxy.
• Implemented EnterpriseDB PostgreSQL MDN and NMDN XDB replication, Setup Backup and recovery using BART, develop and enhance scripts to automate and execute various DBA tasks. Performed Upgrade and/or tune the DB for optimum performance and keep the PostgreSQL DBs current and setup Partitioning in PostgreSQL and automated creation of partitions on a Monthly basis.
• Design and implement backups/disaster recovery solutions for the PostgreSQL Database using custom scripts manage the databases in development and QA environments. Implemented EDB Failover Manager on a 3-cluster node in AWS, Migrated PostgreSQL 9.3 to 9.4, 9.5, 9.6,10 and applied various PostgreSQL Patches. Setup SQL Server transactional replication with updatable subscription and Peer to Peer Transaction replication, performed SQL Server database backup and recovery and maintenance such as shrinking datafiles.
• Installed and configured MySQL on Redhat Linux, migrated Oracle database to MySQL database. Installed Redis Cluster and Redis Sentinel, Setup Redis Master and slave replication.
• Responsible for managing AWS cloud computing environment and its many dimensions including VPC, EC2 S3, IAM, ELB, Cloud Formation, Route53, EFS, RDS, Cloud Front, Cloud Watch, AWS Config, Cloud Trail, SNS.
• Migrated databases On-premise PostgreSQL database to AWS cloud. Migrated databases from MySQL to Aurora MySQL, PostgreSQL to Aurora PostgreSQL and Oracle to PostgreSQL using AWS schema conversion and Database Migration Service.

Environment: AWS - EC2, S3, SMS, DBMS, RDS, SNS, Cloud Formation, VPC, PostgreSQL 9.x /11.x, Oracle 12c/10g/11g Single Instance/ RAC, OEM (Grid Control 12c), Linux 6.8/7.4, Windows 2012, Toad, Oracle Data guard, Oracle CDC.

Confidential

Snr Oracle DBA

Responsibilities:

• Support and administer multiple Oracle 11g/10g databases in Production, QA and development environments running on RHEL 5.6/5.8, IBM-AIX 6.1 and Oracle ASM file system.
• I have upgraded Oracle databases from 10.2.0.4 to 11.2.0.2, 11.2.0.3.
• Backup plan designing and implementation using cold/hot backups for database using RMAN utility.
• Testing of Backup’s and Documenting backup strategies.
• Database performance monitoring, tuning database and application with efficient database parameters.
• Responsible for SQL query tuning optimization using index and parallel hints. Performance tuning using tools such as SQL TRACE, STATSPACK, EXPLAIN PLAN, SQL PROFILER, AWR, ADDM.
• Worked on replication using Oracle Change Data Capture.
• Wrote shell scripts for purging trace files, alert log and network log
• Performed production database maintenance and modifications to ensure databases are operational, as well as diagnosed and corrected any database environment problems; monitored database usage and reported on database performance and system availability.
• Designed logical and physical Data Models using ERWIN
• Responsible for User Security Management, Privileges, Roles, Auditing, Profiling, Authentication.
• Identify performance problems using wait event statistics. Monitor session-level wait events and collect historical data for root cause analysis. Supported the offshore development team in query tuning and monitoring, migrations of code & other support activities.
• Implemented Table Partitions and determining the suitable methodology to improve performance and manageability. Added new partitions and exchanged existing Table partitions.
• Implemented data replication through materialized views, Oracle CDC.
• Cloned/Refreshed Database environments to create patch, test, development and QA environments.
• Installed and configured Grid Control 11g to monitor all databases centrally.
• Developed RMAN scripts for daily database backups, data retention, purge and other scheduled databases. Responsible for managing and planning for data growth capacity and bench marking.
• Used SQL LOADER for loading data into database from Legacy Systems and Flat files
• Configuring Active Data Guard to ensure high availability, data protection and disaster recovery for enterprise data.
• SQL, PL/SQL coding, stored procedures, triggers, cursors, functions, packages, UNIX Shell Scripting, Indexes, Logical and Physical database design to implement the business logic.
• Responsible for all database activities such as space management, database security management, rollback segments & creation of DB links between two oracle servers.

Environment: Oracle 11g RAC/10g RAC, OEM (Grid Control) and IBM AIX 6.1 and Red Hat Linux 5.6/5.8, Windows 2008, Toad, Oracle Data guard, Oracle CDC.

Confidential, Washington DC

Oracle Database Consultant

Responsibilities:

• Responsible for 24*7 production support on a rotation basis for all Oracle databases. Extensive work experience on Oracle 9i/10g/11gon Linux/AIX environment. Work closely with the development team on all issues related to the Oracle Databases.
• Managed application support, maintenance, created logical and physical data layout, table re-organization, installing patches, upgrades, monitoring and tuning of over 70 databases for various types of databases - OLTP and Data warehouse.
• Oracle 11g/10g installation, configuration and support.
• Performed several upgrades of the oracle databases from 11gR2(10.2.0.4) to 11GR1 and 11gR2(11.2.0.1)
• Setup and configured Oracle RDBMS 10g Standby Database using (Data Guard) for real time archive application. Performed exercised switch and failover to test configuration.
• Review of Database logical and Physical design, table Partitioning, global and local indexes. Heavy data load using direct load insert technique.
• Created partitioned table using Range, hash, list partitioning, rebuilt partitioned bitmap indexes on the columns of fact tables to enhance the query performance and fast response. Analyzed slow-running SQL queries and generate statistics using the Execution Plan and recommending solutions for faster execution. Implement use of ADDM to diagnose problems and provide recommendations.
• Involved in application tuning of queries, identifying problematic code, create indexes to improve query performance, re-write queries using an optimized path, Materialized Views and gathering necessary statistics on objects etc.
• Implement Database Security, Management of role-based security.
• Refresh/Cloning of Database and applications for development and testing purpose using RMAN or Data pump utility.
• Performed databases refresh using RMAN duplicate database command from production to development and testing.
• Implemented backup and recovery procedures; established disaster recovery and high availability plans so that MTTR was reduced and business not be affected by any database down time
• Wrote complex SQL, shell and PL/SQL scripting involving reviewing and tuning SQL and PL/SQL code, triggers & stored procedure to enhance performance.
• Developed shell scripts and automated nightly jobs using cron to schedule the backups, exports, refresh test DB from production site and build development, testing staging DB’s.
• Responsible for continuous database monitoring and reorganization for ensuring performance.
• Tuning SGA, I/O Tuning, Identifying contention, waits and tuning.
• Oracle utilities i.e. export/import Data Pump, SQL, Data Guard, ASM and OEM
• Performed proactive monitoring of databases and applying RDBMS patches, security patches.

Environment: Oracle 10g RAC/11g RAC, OEM (Grid Control), Oracle Data guard, ASM, RAC, PL/SQL, Unix Shell scripting, RMAN, Datapump, SQL*Loader, Data Guard, Import Export, AIX, HP-UX, Sun Solaris and Red Hat.

Confidential, Beltsville, MD

Snr. Oracle DBA

Responsibilities:

• Served as a lead team member of Oracle database administrator and Unix Technical Operations for the Web Services Management group.
• Supported all areas of Oracle, IBM DB2 Database Administration and system administration for several thousand SUN-based web and database servers.
• Have conference calls with customers to help them troubleshoot and resolve production database issues.
• Installation of DB2 V7 and Oracle 8.x, 8i.x, 9i.x, 10g.x on Sun 6, 7, 8, 9, 10(clustered and non clustered Production environment), AIX5L, MS Window NT, 2000, 2003 and Linux.
• Creating databases, Migrating Oracle 8.x - 10g.x, Upgrading from Oracle 8.x to Oracle 8i.x, 9i.x to 10g.x.
• Applied various Oracle RDBMS patches
• Setup logical and physical Standby database
• Setup, configured and tested Oracle Data Guard on Oracle 9i and 10g
• Setup and configured Oracle 9i, 10gR1 and 10gR2 Real Application Cluster on Red Hat Release 3 and 4, Solaris 8 and 9.
• Setup and used ASM in monitoring disk groups
• Setup Oracle Enterprise Manager Management server and console to monitor hundreds of databases.
• Applying various Oracle database, IBM DB2 database, Oracle 11i application Patches
• Installing, upgrading, configuring, and maintaining Oracle Financials Application 11/11i on Solaris and Window NT environment.
• Setting up users, responsibilities and users profiles. Managing concurrent processing. Using AD Utilities to apply patches and maintain the application, application cloning and setting parallel concurrent processing
• Installs and remove Solaris operating system software using pkgadd and pkgrm, configure network, perform kernel parameter tuning in /etc/system and with the use of ndd, install patch, scripting.
• Monitor database growth and provide database capacity planning for apps expansion.
• Design and implement backup methods and disaster recovery strategies using Oracle RMAN and Netbackup
• Application Tuning: Identifying the SQL’s causing I/O bottlenecks, sql’s of high cost and giving recommendations to the development teams accordingly.
• Lock monitoring: Identifying the sessions blocking other sessions and inform the users and resolve the issues.
• Migration of code from development to production instances, database space and file system space monitoring, purging of unwanted data and files.
• Proactive monitoring of Oracle Database & Applications, which include Space management, Standard services availability check, quickly identify and resolve database and application level errors.

Confidential, Silver Spring, MD

Oracle Database Instructor

Responsibilities:

• Taught Introduction to Oracle 8i, PL/SQL, Database administration Oracle Networking, Database Tuning, Backup and Recovery.
• Setup and configured all Oracle Lab computers used for training, configured client and server, N-tier environment so students have a feel of real life scenarios.
• Developed course materials and provided the background and tools needed to install and patch Oracle software and set up, operate, and manage Oracle databases.
• Focused teaching plan on all areas including implementing a database backup and recovery strategy and addressed Oracle Software Installation issues, Network configuration, export/import/cold/hot backup and recovery techniques and tuning OLTP environments.
• Developed hands-on exercises for students to understand backup methodologies based on business requirements in a mission critical enterprise.
• Took students through backup, failure, restore, and recovery scenarios by simulating work environment in class.