SUMMARY:

• 8 years of Oracle and MySQL database administration on different operating systems including UNIX, Linux, and Windows for telecom and financial environments.
• Extensive experience with Oracle database (12c/11g/10g/9i) administration including backup and recovery, database monitoring, performance tuning and troubleshooting, replication and streams, high availability including RAC and Data Guard, database architecture, modeling and implementation of technology solutions.
• Deep knowledge about C/C++, Python, R and SQL server and data mining.
• Wide knowledge of software development, software integration, infrastructure management.
• Expertise in Oracle 12c/11g/10g/9i database administration on IBM AIX, Linux, Sun Solaris, HP - UX and Windows NT/2012 servers.
• Configuration, support and performance tuning of Oracle 10g, 11g and 12c Real Applications Clusters (RAC), Delphix and Exadata.
• Experience with Oracle RDBMS and Oracle 12c Cloud Control
• Experience with Teradata Viewpoint 15 & TD 14.10/15
• Good understanding of Teradata Database System Control settings
• Experience with Exadata performance tuning
• Experience with Abinitio graphs performance tuning
• Experience with Teradata utilities like BTEQ, FASTLOAD, MLOAD, TPUMP, FASTEXPORT and Query manager
• Experience with testing tools like Load Runner, Performance Center
• Expertise on managing, and maintaining MySQL replication environment running on Linux / Solaris environment.
• Proficiency with Data Guard with both physical and logical standby databases.
• Hands on experience with Backup and Recovery procedures using RMAN.
• Experience in GRID Infrastructure and CRS management and configuration
• Experience with design, installation configuration, testing, migration and implementation of Oracle WebLogic Server and operating OBIEE and EBS.
• Familiar with OLAP data warehouse designs concepts and data model creation.
• Involvement with database monitoring using shell scripts and OEM.
• Familiarity with performance tuning from machine level, database level to SQL statement level.
• Experience in using DBMS Scheduler to schedule script automatic execution.
• Excellency in PL/SQL coding and experience in cooperating with developer teams
• Excellency in UNIX Shell Scripting.
• Involvement with ASM configuration for RAC environment and storage system architecture including NFS, SAN and NAS.
• Proficiency with database upgrade and migration.
• Security management for database, network, and operating systems.
• Extensive experience in production database support and maintenance 24/7.
• Strong Experience ASM, Grid Control, Data Pump, Flashback database, Golden Gate, Data Guard AWR, and E-Business Suite.

TECHNICAL SKILLS:

RDBMS: Oracle 12c/11g/10g/9i, 11g/12c RAC

Operating Systems: Solaris10/9/8, RedHat Linux 6/5, Windows NT server /2008

Utilities/applications: Oracle Enterprise Manager, SQL*Plus, SQL*loader, RMAN, Oracle Data Guard, Replication, Stats pack, TKPROF, Veritas NetBackup

Programming Languages & APIs: C, C++, UNIX Shell Scripts, SQL, PL/SQL

WORK EXPERIENCE:

Confidential, Washington D.C

Senior Oracle DBA

Responsibilities:

• Expertise in Oracle 12c/11g/10g database administration configuration, support and performance tuning, Real Applications Clusters (RAC) setup including Exadata.
• Design and implement of high availability solutions with Oracle Database 12c/11g RAC, Flashback, Golden Gate and Data Guard.
• Manage with Teradata utilities like BTEQ, FASTLOAD, MLOAD, TPUMP, FASTEXPORT and Query manager
• Managing database base migration using Golden Gate zero downtime migration.
• Generated Statspack/AWR reports from Oracle 12c/11g database and analyzed the reports for Oracle wait events, time-consuming SQL queries, tablespace growth, and database growth. Used Explain Plan, Oracle hints and creation of new indexes to improve the performance of SQL statements.
• Provided tuning recommendations and future memory requirements to Primary DBA team to make the changes in Database like table reorg, add enough spaces to database
• Updating and upgrading database from 11g to 12c
• Database security management using TDE app from Oracle.
• Managing Exadata X5-2 system for business critical database. Migrating databases to Oracle Exadata Database Machine for different clients. Analyzing database performance and tuning database on Oracle Exadata using Real Application Testing (RAT)
• Creating Teradata objects like tables and views, converting data into Teradata tables.
• Work with Exadata performance tuning
• Work with data mirroring in production and development database
• Performed Oracle EBS r12.2.4 upgrade and a single sign on initiative.
• Create and modify table partition, load balancing in Oracle RAC implementation and other Oracle specified duties.
• Maintain technology features by utilizing Oracle partitioned tables, external tables, RAC, Golden Gate, and Data Guard.
• Configure GRID infrastructure and CRS management.
• Production support for Oracle database 12c/11g/10g ensuring flawless execution and continuous production.
• Implement Oracle database backup using RMAN; take 7x24 on call duties for the production support.
• Work on Oracle configuration and performance tuning with AWR and ADDM.
• Monitor database and applications, tune SQL queries, indexes, Oracle initialization parameters and clustered application servers.
• Perform database upgrade and database migration.
• Generate and analyze AWR and ADDM reports and monitor statistics for performance tuning of the database.
• Develop and create the new database objects including tables, views, index, stored procedures and functions, advanced queries and updated statistics using Oracle Enterprise Manager on the existing servers.
• Refresh database, reorganized dataset, reviewed database statistics, monitored replication, and performed space management.
• Design, developed and created the new database objects in Oracle database system according to business requirements.
• Rollout stored procedures and user-defined functions implemented by developer teams into the databases.
• Experience with design, installation configuration, testing, migration and implementation of Oracle WebLogic Server and operating OBIEE and EBS.
• Perform data mining with development team to support risk management solution.
• Experience with Delphix data visualization and reporting.

Environment: Oracle (12c/11g/10g) on Linux and UNIX

Confidential, Atlanta, GA

Oracle DBA

Responsibilities:

• Installed and configured Oracle databases and Real Applications Clusters (RAC) setup.
• Devised, developed and implemented sophisticating backup recovery strategy using RMAN and designed/implemented disaster recovery test.
• Managing database base migration using Golden Gate zero downtime migration.
• Maintain migration and monitor MySQL on Linux and other UNIX platform.
• Maintained day-to-day production support thereafter, check alerts log, error logs, RMAN log to identify any possible errors to ensure the databases health.
• Checked the configuration and performance of the existing databases including data file allocation, index, fragmentation and the impact on system performance.
• Created and developed the stored procedures, triggers to handle complex business rules, history data and audit analysis.
• Monitored strategies, processes and procedures to ensure the data integrity, optimized and reduced data redundancy, maintained the required level of security for all production and test databases.
• Collected requirement from business and customers.
• Coordinated with Developers and users connecting to different databases, setting policy and procedures as they related to database maintenance, security, backup & Recovery.
• Managed the products and development databases including performance tuning, database security configuration, and database continuity.

Environment: Oracle (11g/10g/9i) on Linux and UNIX

Confidential, Atlanta, GA

Consultant, Oracle DBA

Responsibilities:

• Installed and configured Oracle database.
• Upgraded database, applied patches and performed DB migrating.
• Performed RMAN backup on a daily basis and check file consistency.
• Performed database administration tasks such as Instance, Security, Schema and Storage Management.
• Maintain migration and monitor MySQL on Linux and other UNIX platform.
• Troubleshoot databases and custom application issues.
• Managed the granting of access to operational and developmental application system databases.
• Generated test data and tested database to meet the functionalities deliverables in the projects documentation and specifications.
• Worked with development teams in the design of physical databases and in modification.
• Ensured developers coordinated their efforts in managing and maintaining different application databases.
• Restructured production databases and improved performance according to the requirements of business, databases and applications, and resource utilization.
• Interacted with Oracle Support for resolving various critical database issues.

Environment: Oracle (11g/10g/9i) on UNIX, Linux and Windows Server 2008