SUMMARY:

• Around ten years of IT experience as an Oracle DBA on a variety of UNIX (Solaris, Linux, HP - UX), AWS, Azure, Windows 2000 platforms with Oracle 8i/9i/10g/11g/12c. Currently working on 2500+ databases residing on Linux, SunOS, HP-UX, AWS and Windows.
• Significant experience in Oil, Financial, Insurance, Transportation and Trading applications.
• Experience in implementing and managing Oracle 10g/11g features like Real Application Clusters (RAC), Data Guard, Streams and worked extensively in OLTP and OLAP environments.
• Working experience of AWS and Oracle cloud products and services.
• Proven hands-on cloud migration solution design/delivery experience.
• Installed OEM 12c and Migrated 79 servers containing 427 databases.
• Experienced in DB activities that involved DevOps tools like JenKins, SVN, GITS and Flyway in the environment.
• Ability to effectively address data security concepts in public cloud as it relates to customer needs including an in depth understanding of Federated Security / Single Sign On, and AWS IAM.
• Exposure on AWS Relational Database Service (RDS), AWS Database Migration Service (DMS), Elastic Compute Cloud (EC2), Elastic Cache, Elastic Load Balancing, Elastic Block Store (EBS).
• Exposure in install/configure/upgrade the High-Availability Hadoop Clusters.
• Installation, Configuration and Administration of Oracle10g/11g RAC by using ASM.
• Good experience in installing, configuring and administrating Data Gaurd on both RAC and Standalone Servers.
• Also administered, monitored, migrated and upgraded versant databases.
• Applying oracle patches for Daylight Savings Time (DST), upgradation and migration of databases using the OPatch utility and fixing bugs.
• Experience with exporting and importing data to and from a database using the exp/imp utility.
• Used EXPDP/IMPDP (Data pump) to take the hot backup using DUPLICATE or full export and also to accomplish table level and full database de-fragmentation.
• Creating tablespaces and planning the location of data, index and rollback tablespaces redo log files and control files in adherence to the Optimal Flexible Architecture.
• Proficient in SQL, PL/SQL, Query/application tuning using optimizer hints, Explain plan, SQL trace, TKPROF, Analyze and Autotrace.
• Used STATSPACK for Database Monitoring and Database Performance.
• Created table partitions to improve performance and data management.
• Experience in creating Materialized Views in data warehousing environment.
• Analyzed tables and indexes for Cost Based Optimization (CBO) to work efficiently.
• Worked on various Technologies in Data warehousing - ETL Tool Informatica, Ab initio and database development tools like TOAD, ERWIN, and SQL Developer.
• Experienced in designing, developing, scheduling and monitoring UNIX shell scripts to administer all the environments.
• Extensive use of Crontab in UNIX environment for scheduling routine tasks.
• Database backup and recovery. Used hot and cold backups. Involved in development of scripts to automate backup and recovery procedures for development databases.
• Providing assistance in logical/physical data modeling using ERWin.
• Experience in database application development using SQL, TOAD.
• Extensively involved in Database Cloning manually as well as using RMAN.
• Configuration of Oracle Enterprise Manager (OEM) to monitor database and report on events as defined by the DBA group.
• Good experience working with various FTP protocols like FTP, SCP using SSH protocol.
• Extensive Database Administration - Oracle 8i/9i/10g/11g/12c experience that includes creation and management of users and their profiles. Tuning of the database for optimum performance.
• Documentation of projects, databases, installations.
• Knowledge of the System Development Lifecycle (SDLC).
• Experience with delivery management and estimation.
• Clear communication and documentation of technical specifications.
• Extensive Database Designing - Oracle 9i/10g/11g. Experience. Common tasks include analysis of the particular system, which further included interaction with the end - users and the management to develop requirements and specification for the project.
• Experience in working with high-transacted OLTP systems.
• Highly motivated, excellent team player, enthusiastic, strong initiative and quick learner of new technologies. Strong interpersonal and communication skills in dealing with customers.
• Excellent troubleshooting skills and committed follower of Oracle Technologies.

TECHNICAL SKILLS:

Databases: Oracle 8i/9i/10g/11g/12c, SQL Server, My SQL, DB2, Ms-Access

Oracle and other DB related Tools: SQL*Loader, SQL*Net, OEM,TOAD, ER-studio, Oracle migration work bench, Oracle Parallel Server, Oracle Replication, OID, Data Guard, ASM, Golden Gate, Oracle Data Integrator, RAC, OLAP, SQL backtrack and DevOps tools.

Operating Systems: Z-Linux, Sun Solaris, HP-UX, AIX4.3.3, Red Hat Linux 7.2, and Windows Server 03/08/12/16, AWS, Azure.

Languages: VB6.0, C, Pro*C, SQL, PL/SQL

Scripting Languages: Shell scripting, VB script, JavaScript, Perl

Markup Languages: HTML, XML (knowledge).

Web Servers: IIS, Apache, IBM

Server side Tools: ASP, PHP

Reporting Tools: MS Project, Ms-Office, MS-Visio, MSBI, VERITAS, Informatica, Ab Initio, oracle warehouse builder.

PROFESSIONAL EXPERIENCE:

Confidential, Houston, TX

Oracle Data Base Administrator

Responsibilities:

• Responsible for Database Administration for day to day operational support of Oracle and Versant databases as well.
• Ensuring that database backups of different environments are being taken successfully.
• Monitoring database administration, monitoring using OEM 10g/12C and migration from 10g/12C OEM of the targets.
• Effectively addressing data security concepts in public cloud as it relates to customer needs including an in depth understanding of Federated Security / Single Sign On, and AWS IAM.
• Exposure on AWS Relational Database Service (RDS), AWS Database Migration Service (DMS), Elastic Compute Cloud (EC2), Elastic Cache, Elastic Load Balancing, Elastic Block Store (EBS).
• Exposure in install/configure/upgrade the High-Availability Hadoop Clusters.
• Exposure in Importing and exporting data from different databases like MySQL, Oracle Into HDFS and Hive using Sqoop.
• Participated in DB Release activity in environments that use DevOps tools like JenKins and SVN.
• Working experience of AWS and Oracle cloud products and services.
• Scheduling jobs and troubleshooting in case of failure.
• Performing restores and data refreshes as per the requirement using impdp/expdp and sqlplus.
• Run scripts to create database objects and data manipulation as required.
• Responsible for performance upgrades to newer DBMS versions or preparing upgrades to newer DBMS versions or preparing an application to upgrade itself.
• Documented Design and change management for all process.
• Manage sharing of resources amongst applications.
• Primary DBA for 84 databases and responsible for all quarterly refreshes, upgrades, patches, monitoring and administration.
• Database and schema refreshes using impdp/expdp, imp.exp, Cold clone and RMAN duplicate very often.
• Performance tuning including database and SQL tuning to improve performance using tools like AWR, ASH, Explain Plan and thereby gathering stats, creating indexes, hints and altering parameters whenever required.
• Assisted in logical and physical database design.
• Installed, upgraded and patched Oracle software and associated applications.
• Wrote PL/SQL procedures, triggers and functions to enable plug and play of multiple data sources.
• Trained a new DBA in our environment.
• Participating in on call rotations supporting more than 2500 oracle and versant databases.

Environment: Oracle 12C/11g/10g/9i, RAC, OID, OEM 12C, ASM, SVN, Jenkins, Delphix, Hadoop, AWS, Azure, Windows Server, AIX, Linux, HP-UX, PL/SQL, RMAN, MSBI, Versant 6.4/5/6, SQL Server, SAP, Upstream, Downstream, TOAD, SQL Loader, Shell Scripting.

Confidential, San Diego, California

Oracle DBA

Responsibilities:

• Demonstrated experience in performing Oracle Database Administration activities on large multi-Terabyte and highly critical environments.
• Troubleshooting database issues and quickly resolving them.
• Advanced SQL Tuning and optimization to gain performance data warehousing.
• Creating of Shell scripts to automate monitoring SQLs.
• Introducing advanced SQL/PL*SQL methods pertaining to exadata.
• Incorporating existing monitoring, access, and access mechanisms into the Exadata environments.
• Consulting with business units to assess needs and recommends appropriate DBMS operational and warehousing methods and tools.
• Administered Oracle Access Manager (OAM) Single Sign-On authentication for user logging in Oracle 12c Cloud control.
• Provide customer onboarding and help customer to understand AWS offering and troubleshoot database issues.
• Documenting all the processes/procedures
• Maintaining quality service by establishing and enforcing organization standards
• Rolling out new application code / builds in various production and non-production environments.
• Performance tuning, problem research/resolution, code reviews and deployments, Oracle SQL support, and data movement.
• Partitioning tables with 26 billion records and 4 billion records to gain performance.
• Monitoring the database health and performance.
• Designing and implementing refreshing data using impdp/expdp, RMAN duplicate command, Backup strategies and DR.
• DBA on call every Thursday.
• Providing grants and restricting developers from consuming temp tbs and undo usage as well as running parallel slaves.
• Implemented data movement from Oracle to Hadoop and vice versa.

Environment: Oracle 11gR2/12C, RAC, OEM 12C grid control, ASM, Exadata, AIX, PL/SQL, RMAN, GreenPlum, Hadoop, AWS, Jenkins, TOAD, SQL Loader, Shell Scripting.

Confidential, Dallas, TX

Oracle DBA/Architect

Responsibilities:

• Production DBA Support for 11Gg/10g RAC Multi Node configs.
• OEM agent installation and configuration.
• High Level Evaluation and Performance Tuning.
• Created 19 Oracle SRs related to different issues including system and database performance, tuning, etc.
• DR Plan with Informatica Data Replication and different DB Performance Tuning with latest 11g/10g Grid Tools and Technologies for Production Full Life Cycle support.
• Installed and Configured RAC on Linux server with 4 nodes server side load balancing using Automatic Storage Management(ASM).
• Develop highlevel DB Performance Reports with Recommendations for future RAC Capacity Planning works.
• Responsible for applying Oracle patches.
• Worked on all document process, related to all regular DBA activities.
• Creating table/tablespaces for storing XMLTYPE datatype stored as CLOB and BINARY. Database objects were sized for effective space management and optimal performance.
• Migration, Upgradation works of all critical Production Databases from 10g/11.1g to 11g RAC/Non-Rac and 10g RAC on different OS platforms (Solaris Unix, AIX).
• Written shell scripts to automate RMAN backups and customized monitoring reports using OEM(11g/12C) monitoring templates, Incident rules and events.
• Prepares and/or review database activity, progress, and performance reports.
• Creating crontab entries for various monitoring for deleting logs created for customized monitoring reports, used intermittently to load data into reporting tables.
• Responsible for loading tables on regular bases into the migration environment as required by the application team.
• Performed weekly tasks and monthly manual reports including backup and restore by using SQL Server Management Studio.
• Implement Production Control and Change Management.
• Providing best practices on new technologies and implementations.
• Recommending application code changes (processing strategies, queries, use of RDBMS features).
• Develop and Support Strategy to provide Remote DBA Services to our customers.
• 24x7 production support DBA working on a primary/ secondary pager rotation; and supported on holidays, weekends and beyond regular hours.

Environment: Oracle 10g/11gR2, OEM Grid Control, RAC, ASM, Informatica IDR, MS SQL Server 2005 Enterprise Edition, MS SQL Server 2000 Enterprise Edition, Windows 2003 Server, Solaris, AIX, JIRA, PL/SQL, RMAN, DataGuard, Streams, SQL Loader, Shell Scripting.

Confidential, San Francisco, California

Oracle DBA/Architect

Responsibilities:

• Participated in analyzing the requirements for the logical and physical design of the database.
• Oracle 9i/10g installation and configuration.
• Performance tuning in terms of sqls, adhoc sqls etc by using parallel, indexing hints etc and database tuning by setting up the right parameters as and when required.
• Installed and Configured RAC on Linux server with 4 nodes server side load balancing using Automatic Storage Management(ASM).
• Configured Oracle Streams (Advanced Replications) and exchanged data between two databases in remote locations.
• Responsible for applying Oracle patches using the OPatch utility.
• Managing database security. Creating and assigning appropriate roles and privileges to users depending on the user activity.
• Creating tablespaces and database files based on the OFA model. Implemented physical database design after sizing tables and indexes and creating tablespaces taking into account I/O load distribution. Database objects were sized for effective space management and optimal performance.
• Identified SQL and PL/SQL bottlenecks using PL/SQL Profiler (package DBMS PROFILER), explain plan, auto trace, TKPROF and tuned them to suit SLA.
• Successfully implemented physical standby database using Oracle Data Guard feature for High availability configuration.
• Written shell scripts to automate loading files into database using crontab, error handling and notification.
• Responsible for capacity planning, administration of Oracle 11g Active Data Guard.
• Generated SQL and PL/SQL scripts to create and drop database objects including: tables, views, primary keys, indexes, constraints, packages, sequences, grants and synonyms.
• Creating crontab entries for various monitoring and maintenance job duties like backups, batch jobs, tablespace monitoring, deadlock alerts etc.
• Responsible for taking weekly backups of data using exp, imp, expdp and impdp.
• Aiding developers in writing efficient code and making efficient use of the resources leading to better performance and optimization.
• Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• Administrator tasks like managing users, roles and permissions.
• Performance testing on stored procedures, indexes, and triggers.
• Creating DTS Packages for data import/export, scrubbing and scheduled jobs for backups.
• Data migration using bulk copy program, DTS and SSIS from Oracle Databases and Flat files.
• Modeling and architecture of the SQL Server 2005 database.
• Creating Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• 24x7 production support DBA working on a primary/ secondary pager rotation; and supported on holidays, weekends and beyond regular hours.

Environment: Oracle 10g/11gR2, OEM, PLSQL developer, Power Center 8.6, MS SQL server 2005 Enterprise Edition, MS SQL Server 2000 Enterprise Edition, Windows 2003 Server, AIX, Reflections, HP-UX, PL/SQL, RMAN, RAC, DataGuard, ASM, ODI, Streams, SQL Backtrack, Grid Control, SQL Loader, Shell Scripting.

Confidential

Oracle DBA

Responsibilities:

• Installation, Configuration and Administration of Oracle 10g/11g RAC by using ASM.
• Planned and implemented Disaster Recovery solutions using Oracle Data Guard (Physical and Logical Standby).
• Installation, configuration of Oracle Golden Gate installation, configuration and troubleshooting GG issues.
• Supporting Terabyte databases with high transaction volume on HP-UX, SunOS.
• Refreshing databases from Production to Pre-Production environments.
• Perform database monitoring including process and query optimization, troubleshooting of locking issues, monitoring of resource contention, analysis of queries, log files, trace files, etc sometimes using statspack and AWR reports.
• Preparing shell scripts for automation and pro-active monitoring.
• Used Datapump for database migration for Maxi-Merlin, EISSC, PPD and GOCSTAR databases.
• Installation, configuration, patching and upgrading of oracle server software (10g/11g).
• Data modeling, database optimization and capacity planning for growth and changes.
• Following established standards. Develop and document new processes and procedures as necessary using change control system.
• Participating in strategic planning and project meetings.
• Monitoring and Administrating databases through OEM Grid control as well as manual scripts as and when required.
• Performing customized Backup and Restore through RMAN.
• Performing various types of database migrations using the Oracle Datapump utility.
• Configured Various Replication Types between Primary Server and Read - Only servers, with separate Distributor server and experience in troubleshooting replication problems in MS SQL Server 2000/2005 Environment to Test the Software.
• Wrote various stored procedures for the purpose of application development.
• Problem identification, troubleshooting, resolution, and index tuning databases.
• Checked databases, jobs, nightly backups on all servers and monitor system log and security log on Event Viewer.
• Successfully loaded data from an EXCEL, Access into SQL Server database Table.
• Work with the development teams to optimize ongoing performance.
• Participating in code reviews and ensure systems implementations occur in accordance with established procedures.
• Supporting RAC-ASM databases on DW and OLTP systems.
• Establishing no-data-loss Database Replication using Dataguard.

Environment: Oracle 9i/10g/11g, MS SQL server 2005 Enterprise Edition, MS SQL Server 2000 Enterprise Edition, Windows 2003 Server, DSN and Active Directory, SunOS, Red hat Linux, OEM, PL/SQL, TOAD9.1, DBArtisan 8.7.6, RMAN, Informatica, Ab Initio, RAC, ASM, Grid Control, DataGuard, Blade Logic, Golden Gate, SQL Loader, Tivoli, Shell Scripting.

Confidential

Oracle DBA

Responsibilities:

• Troubleshooting database performance issues involving problem SQL’s through SQL Advisor, AWR and Stats Pack.
• Successfully installed and configured oracle RAC, ASM and non-RAC databases on Linux, Windows and VMware.
• Disaster recovery using Standby database, Database cloning, Replication and Data Guard technology.
• Implemented Oracle streams for bi-directional schema level replication.
• Monitored and Administered database using Oracle Enterprise Manager Grid Control.
• Analyzing Database configurations and adjust to meet the performance requirements.
• Creating and altering users, managed roles and profiles.
• Backup strategies and planning using RMAN, O/S and logical backups, setting up periodic backups using cron job and shell scripts.
• Maintaining data files, tablespaces, rollback segments.
• Golden Gate set up, tuning, administration on Oracle 10g and 11g.
• Troubleshooting database and application errors and work with the application team to resolve problems.
• Planning database installation, patches and/or upgrades.
• Administering multiple database instances from Sandbox to PROD (OLTP and OLAP) while keeping configurations consistent as required;
• Communicating regularly with technical, applications and operational staff to ensure database integrity and security.
• Auditing detailed records of database changes through the use of the internal tracking systems and propagate across the environments.
• Performing basic UNIX and application administration tasks as needed for performance monitoring.
• Creating DUPLICATE database for development purposes regularly.
• Creating shell scripts to run as cronjobs based on data modification requirements.
• Working with SQL Loader to move legacy data into current environment by conversion.
• Supported through two whole release cycle from Database build to Production release.
• Utilized Materialized Views and Logs to move data from OLTP to OLAP daily.
• Following Oracle Web Conference (OWC) to update the client with the new technologies, trends, etc.
• 24x7 production support DBA working on a primary/ secondary pager rotation; and supported on holidays, weekends and beyond regular hours.

Environment: Oracle 9i/10g/11g, MS SQL Server 2005, Windows 2003, IDERA Diagnostic Manager, MS Reporting Services, SQL LiteSpeed Backup Software, APEX SQLlog, Quest Spotlite, AIX, ZLinux, Windows Server 2003/2008, OEM, PL/SQL, TOAD9.1, RMAN, Informatica Power Center, RAC, ASM, Grid Control, DataGuard, ODI, Streams, SQL Loader, BladeLogic, Tivoli, Shell Scripting.

Confidential

Oracle DBA

Responsibilities:

• Involved in interacting with the end-user (client) to gather business requirements.
• Participated in analyzing the requirements for the logical and physical design of the database.
• Upgraded and migrated Oracle 10g to 11g using Rolling upgrade and Golden Gate replication process.
• Oracle 9i/10g installation and configuration.
• Installed and Configured RAC on Linux server with 4 nodes server side load balancing using Automatic Storage Management(ASM).
• Configured Oracle Streams (Advanced Replications) and exchanged data between two databases in remote locations.
• Responsible for applying Oracle patches using the OPatch utility.
• Managing database security. Creating and assigning appropriate roles and privileges to users depending on the user activity.
• Knowledge of Normalization, Data Warehousing, and OLAP 24X7 support, data transfer, documentation, preventive maintenance, archive and purging, client connectivity, developers support, code review, automation, store procedures and triggers writing, load balancing, remote administration etc.
• Creating tablespaces and database files based on the OFA model. Implemented physical database design after sizing tables and indexes and creating tablespaces taking into account I/O load distribution. Database objects were sized for effective space management and optimal performance.
• Developed or modified some Oracle backup and recovery scripts. Used Oracle backup utility RMAN to implement Oracle backup and performed a number of times of disaster recovery
• Successfully implemented physical standby database using Oracle Data Guard feature for High availability configuration.
• Written shell scripts to automate loading files into database using crontab, error handling and notification.
• Generated SQL and PL/SQL scripts to create and drop database objects including: tables, views, primary keys, indexes, constraints, packages, sequences, grants and synonyms.
• Identified SQL and PL/SQL bottlenecks using PL/SQL Profiler (package DBMS PROFILER), explain plan, auto trace, TKPROF and tuned them to suit SLA.
• Improved the productivity of projects involving data transfer and and/or transformation like migration, installation of packages, construction of secured databases for the Internet, installation of datawarehouse and datamarts, and synchronization of heterogeneous applications using Oracle Data Integrator (ODI).
• Also used Oracle Enterprise Manager (OEM) to schedule jobs using the DBMS JOBS package.
• Responsible for taking weekly backups of data using exp, imp, expdp and impdp.
• Aided developers in writing efficient code and making efficient use of the resources leading to better performance and optimization.

Environment: Oracle 9i/10g, OEM, TOAD, MS SQL Server 2005, Windows 2003, IDERA Diagnostic Manager, MS Reporting Services, Sun Solaris 2.8, HP-UX, PL/SQL, RMAN, RAC, DataGuard, ASM, ODI, Streams, GoldenGate, Grid Control, SQL Loader, Shell Scripting.

Confidential

Research Assistant

Responsibilities:

• Involved in creating fundamental ideas for the systems being designed by the project.
• Created detailed ideas for implementing the systems, project team.
• Participated in frequent thinking-sessions.
• Seeking existing information for implementing the systems: in the Web, printed sources, people.
• Attended, and presented ideas at, rare meetings with people not of this university: UCoMS team meetings at LSU and others at ULL.
• Rarely: standing in for a professor in some easy duty so that the professor can attend to some conflicting duty (example: proctoring a class).
• Wrote proposals for new projects to be implemented.
• Software and Hardware Installation and Maintenance of the systems.
• Administered and maintained the research related databases.

Environment: Oracle 8.x, VB, C, PL/SQL, Windows Server, Unix, Foxpro.