Summary

Linux System Administrator/Oracle DBA with years of experience Strong communication skills, with history of providing on-site support to wide range of clients. Providing 24x7 production support for RHEL, UNIX, Solaris CentOS, Ubunto, AIX and Oracle 12c/11g/10g/9i/8i databases on various platforms in clustered and non-clustered environments. Excellent technical skills with hands-on expertise in mission critical applications, networking, scripting, and problem solving. Years of experience on installations and configurations.

Technical Skills

• 8 to 9 years of IT experience in the field of database administration on Red hat Linux, UNIX, Windows 2008, AIX, and Solaris.
• Work with RDB databases
• 2 years of experience with UNIX scripting ksh,perl , awk, sed, vi
• 3 4 years as system Administrator working on windows 2008, Solaris 10, Solaris 11, Red Hat Enterprise Linux 6 RHEL , CentOS, Ubuntu,
• Use Nagios to monitor databases and operating systems
• Installed and configure Data guard and RAC
• Installed red hat linux, Solaris, Windows 2008 from scratch, configured them for Oracle Installation, installed Oracle Software on them by running .runInstaller, and created oracle databases using DBCA, used netca to configure the listener and tnsnames.
• Installed AIX, CentOS, Ubuntu, UNIX and more, Installed and configured Unix and Windows 2008 on VMware machine
• UNIX shell programming in C, Bourne and Korn shells, Z shell and Python scripting languages.
• Provided 24x7 production support for Oracle 12c/11g/10g/9i/8i databases on various platforms
• Maintain the Oracle 10g/11g/12c RAC environment and troubleshoot performance problems.
• Deploying code in production databases in times of release activities or any maintenance tasks.
• Proficient in all DBA responsibilities such as Installation, Configuration, Perform Oracle Upgrades from 10.2.0.3 to 11.2.0.3 for DEV, Stage Production environment, Patches, Performance Tuning, Backup, Recovery, Cloning, Space management, Database Security, Auditing, Troubleshooting, Database Design, Unix Shell Scripting and Documentation.
• Implement Oracle Enterprise Manager Grid Control OEM 11g/10g for centralized monitoring and administration.
• Planned and implemented high availability solutions using Oracle 11g/10g RAC R2 Standby Database using Oracle Data Guard and Replication
• Operating Systems: Installation and Configuration of Unix/Linux, Windows NT 2000-08 for Oracle database, ASM and Oracle discoverer installation.
• Knowledge on converting DB2 databases to Oracle
• Involved in database upgrade from 11.1.0.6 to 11.1.0.7 for DEV and TEST environments.
• Upgrade the production and development databases from 10.2.0.1 to 10.2.0.4
• Set up Oracle Data Guard on Oracle 10g/11g for high availability, data protection and disaster recovery, also manually created physical standby database using data guard.
• Use Oracle Enterprise Manager OEM to monitor the database, cloning and many more.
• Knowledge of Golden Gate replication

Trainings

• Oracle Database 8i/9i/10g/11g/12c Administration, MYSQL databases
• Introduction to UNIX Scripting/ Red Hat Linux, Solaris, AIX, CentOS, Ubuntu
• Linux Shell scripting, Python, Golden Gate, RAC, ASM, Data guard.
• SQL and PL/SQL Fundamentals

Work Experience

Confidential

Database/System Manager

• Monitoring applications such as Apache, Tomcat making sure it's connected to the database and its up and running monitoring processes, listeners.
• Troubleshooting web servers making sure it's always up and running and fixing every issues that developers might be facing
• Monitoring server performance, perform application installation, creating users, adding them group, granting read, write permission to users.
• System Administrator working on windows 2008, Solaris 10, Solaris 11, Red Hat Enterprise Linux 6 RHEL , CentOS, Ubuntu
• Work with Oracle and MYSQL databases
• Troubleshoot and analyze cause of performance problems
• Use Nagios to monitor databases and operating systems, Configured RAID
• Middle-Tier Administration as well as Application Support and deployment
• Add and remove user accounts, maintain system database files e.g. groups, hosts, aliases.
• Installed red hat linux, Solaris, Windows 2008 from scratch, configured them for Oracle Installation, installed Oracle Software on them by running .runInstaller, and created oracle databases using DBCA, used netca to configure the listener and tnsnames.
• Installed AIX, CentOS, Ubuntu, UNIX and more, Installed and configured Unix and Windows 2008 on VMware machine
• Install and configure Data guard and RAC
• Deploying code in production databases in times of release activities or any maintenance tasks.
• Created scripts in order to facilitate sys admin duties troubleshot hardware, software, and network related problems as well as kernel tuning and modifications for database applications
• Writing conditional and unconditional shell and python scripts
• Work with TCP/IP networking, provided remote database upkeep and maintenance for multiple clients UNIX, Windows, Ubuntu, AIX, CentOS .
• Monitor the operating system by running by iostat, top, uptime and checking
• Maintain the Oracle 10g/11g/12c RAC environment and troubleshoot performance problems.
• Creating shell scripts to run automatically to clean up alert log files and other related files in the database.
• Provided 24/7 production support on our databases, system and servers
• Perform Database Refreshes use grid control and cloud control to monitor the databases
• Apply patching and performing Technical Health Checks on our databases
• Monitor the OS and the databases performance
• Perform performance tuning and troubleshooting
• Performing daily and weekly database backup using RMAN
• Monitoring and optimizing the performance of the database
• Perform complete and incomplete database recovery on our databases
• Deploying code in production databases in times of release activities or any maintenance tasks.
• Created Users, Index, Tablespaces, Views, Profiles, Privileges.
• Monitor the database using grid control and db console
• Generating various reports by querying from database as needed.
• Carrying out Oracle Database maintenance base lining, performance tuning, alert configuration, using snap shots taking by Automated Workload Repository AWR / Automatic Database Diagnostic Monitor ADDM to generate performance reports, monitoring database performance, securing protecting information/database with unique secure configurations, data encryption and masking

Confidential

Oracle Implementation DBA/System Admin

• Installed and configured Red Hat Linux, Oracle RAC 11gR2, configured a FSFO Observer and two standby databases.
• Troubleshooting and performance tuning on oracle databases, MYSQL databases
• Monitoring the databases and operating system
• Apply patching and performing Technical Health Checks on our databases
• Performing daily and weekly database backup using RMAN
• Perform complete and incomplete database recovery on our databases
• Perform complete and incomplete database recovery for clients databases
• Use Oracle Enterprise Manager OEM to monitor the database, cloning and many more.

Oracle DBA

Confidential

• Perform Troubleshooting and performance tuning for multiple clients for example Walmart, Home Depot, HHI, Office Depot, Best Buy, Delta, Sony, Phillip and many more.
• Write Unix shell programming in C, Bourne and Korn shells, Z shell and Python scripting languages
• Experience in bash shell scripts grep/awk/sed , crontab, and familiar with OS/admistration commands
• Maintain the Oracle 10g/11g/12c RAC environment and troubleshoot performance problems for multiple clients
• Deploying code in production databases in times of release activities or any maintenance tasks.
• Creating conditional and unconditional shell scripts and python scripts
• Perform technical health checks for our client's servers.
• Monitoring the database environment, ensuring that the database is meeting.
• Performance standards, making sure the accuracy, integrity, and security of data are maintained, and ensuring that the error log or event log is also being monitored for database errors.
• Perform complete and incomplete database recovery for clients databases
• Configure and created a recovery catalog for backups and recovery.
• Use Rman to perform backups for multiple client's databases.
• Allocating system storage, monitoring storage utilization, and planning future storage requirements for the database system.
• Develop and implement recovery procedures that will reduce downtime associated with failure.
• Monitoring and optimizing the performance of the database Maintaining archived data.
• Generating various reports by querying from database as needed. Performed database tuning for multiple clients.
• Tuning and troubleshooting Oracle Database 10g/11g and Oracle Exadata databases.
• Providing database architecture consulting for Oracle Database 10g/11g
• Performed database cloning from production to testing platforms.
• Provided OS reconfiguration recommendations to improve database performance for multiple clients.
• Installing, configuring and supporting ASM databases performing database refreshes.
• Documenting benchmarks and procedures needed to optimize database performance.
• Performing daily and weekly database backup using RMAN
• Performing data migration using Oracle data pump
• Created Users, Index, Tablespaces, Views, Profiles, Privileges.
• Upgrade oracle RAC environment with two nodes.
• Maintain and support data warehouse environments for multiple clients. I also maintain the development, test, and production in Info Sphere environment.
• Work with new development Design, build and deploy high quality, performance, integrated, and documented ETL solutions while following established standards and mentoring others.
• Design and architect ETL load strategies needed to support required staging, warehouse or data marts for multiple clients while mentoring others.

Confidential

Oracle Database Administrator

• Installing and configuring Oracle Enterprise Red Hat Linux operating system versions and Windows 2008 servers for Oracle Relational RDB and Multidimensional Databases MDB installation and creation, installing Oracle grid infrastructures Oracle database software to meet the current needs and upgraded as required to meet the expansion needs of the company.
• Write Unix shell programming in C, Bourne and Korn shells, Z shell and Python scripting languages
• Experience in bash shell scripts grep/awk/sed , crontab, and familiar with OS/admistration commands
• Creating, migrating and backing up database for various clients.
• Lead a project with a team of 5 and successfully analyzed, recommended and implemented an active Oracle Data Guard for United Health groups and Wal-Mart in Georgia to improve Oracle data protection, data availability and disaster recovery to enable easier monitoring and management system.
• Lead a team of 3 to execute a project to configure multiple databases for DeKalb County GA for basic backup and disaster recovery that resolved data loss problems for the entire county database 70 with each instance of about 9 Terabytes capacity .
• Part of a team of 3 to successfully upgrade multiple databases and carried out short term performance tuning, maintenance and training for continuous operation for Wyndham Hotel Groups in Arizona.
• Carrying out Oracle Database maintenance base lining, performance tuning, alert configuration, using snap shots taking by Automated Workload Repository AWR / Automatic Database Diagnostic Monitor ADDM to generate performance reports, monitoring database performance, securing protecting information/database with unique secure configurations, data encryption and masking procedures as well as with sophisticated auditing skills.
• Lead a consulting project with Pishon Technology at RachReub IT Solutions Ltd., a UK based company during which my team performed all user requirements and troubleshooting activities, diagnosed the installed database with improved Oracle 11g packages as well as resolved connectivity issues. Implemented, administrated, and maintained daily backup and archived data on tape. Created user accounts system/user-level database objects managed user privileges.
• Installing Oracle software, planning the database security strategy, enrolling system users and planning for their Oracle Network access.
• Ensuring proper configuration and security on all database servers.
• Running complex queries to retrieve data from multiple tables, ensuring fast and secure access to business application for about 60 users in remote location round the clock.

Confidential

Oracle Database Administrator

• Installing, configuring, tuning and troubleshooting Oracle Database 10g/11g
• Write Unix shell programming in C, Bourne and Korn shells, Z shell and Python scripting languages
• Upgrading Oracle Databases from 10g to 11g
• Performed database cloning from production to testing platforms
• Made changes to development and production databases in response to developer requests and Performing database refreshes
• Providing development support to developers and testers
• Providing expect assistance in SQL statement tuning to improve performance
• Performing data migration using Oracle data pump and SQL Loader
• Deploying database and application to production and performed thorough observation of same for other hidden flaws.