Manager Management
Resume:
Oracle DBA
Saif Khan
*************@*****.***
Over 7+ years of experience as an Oracle Database Administrator in various domains to deliver new products, upgrades with Oracle Software 11g-R2/10g/9i/8i on Sun Solaris, Red Hat Linux and Windows platforms.
Summary:
Experience in Configuring Single instance, Oracle Real Application Clusters (RAC), Automatic Storage Management (ASM) and Real Application Testing (RAT).
Experienced in day-to-day DBA activities including schema management, user management (creating users, synonyms, privileges, roles, quotas, tables, indexes, sequence), space management (table space, rollback segment), monitoring (alert log, memory, disk I/O, CPU, database connectivity), scheduling jobs, UNIX Shell Scripting.
Experience in Performance tuning of oracle databases using OracleGrid Control, STATSPACK, and tuning of SQL scripts using SQL Trace and TKProf
Good exposure of Oracle DBA tasks like Installation, Patching, Cloning and Upgrade of Oracle Databases.
Skilled in developing RMAN scripts for database back up including hot and cold backup options for both RAC and standalone instances.
Excellent experience in various migration techniques like export/import, Datapump, backup restore, cloning, and data guard.
Good experience in applying Critical Patch Update (CPU Patches) on Databases, Application Servers and Middle Tiers.
Used ADDM (Automatic Database Diagnostic Monitor) AWR (Automatic Workload Repository) for analyzing the database performance and tuning.
Creation and maintenance of database Standard Operating Procedures (SOP's).Experience with OLTP and batch processing in a large data processing environment
Migrated single instance databases to multimode 10g/11g RAC environment for high availability and load balancing.
Experience in maintaining Oracle Data Guard & Standby Database and providing critical solution with strategic disaster recovery plans with different recovery procedures and methods.
Experience with SQL, PL/SQL coding, stored procedures, triggers, functions, packages, UNIX Shell Scripting, Partitioning, Indexes, ERWIN Data modeling, Logical and Physical database design.
Worked with RDBMS, Enterprise Grid and Infrastructure support.
Management of schemas, objects, partitioning the tables, indexes, USERS and PRIVILEGES 10g OEM Grid Monitoring.
Knowledge of Data Normalization and its normal forms.
Strong experience in providing 24/7 support for corporate databases, timely resolution of tickets, and on-call rotation.
Experience in understanding business requirements for analysis, detailed design, database design & development of applications. Worked with various projects in large enterprise projects.
Technical Skills
Operating System: Red Hat Linux RHEL 2.1,3.x, 4.x,5, Sun Solaris 9.0/10.0, and Windows 98/NT/2000/2003, HP-UX, IBM-AIX 5L.
Programming Languages: Java, PL/SQL, UNIX/NT Shell Scripting
Databases: ORACLE 7.x/8.x/9i/10gR2, RAC/11g/10g
Terminal Emulation: Putty, Telnet, Cygwin
Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ADDM
Tools & Utilities: RAC, OEM Grid Control, ESM, SQL Navigator, SQL* Loader, ASM, SQL Server, Export/Import, RMAN, TOAD, Patch Management, SQLNET
ODBC, Oracle Streams, Data pump, Data Guard, VMware
Methodologies: ER-Diagrams, UML, OOAD
Version Control: CVS, SVN, Perforce
J2EE Technologies: EJB 3.0, XML, XSL, XSD, Servlets, JSP, HTML, Ajax, JDBC and Taglibs.
IDE’s: Eclipse2.1,3.2, RAD 7.0
Education:
Bachelor of Commerce
Professional Experience:
IBM Global Services/ AT&T – Naperville, IL Apr 2011 - Present
Oracle DBA
Job Responsibilities:
Manage data administrators and client enhancement requests.
Responsible for data base migration between data centers through data pump or replication and upgrade of database versions.
Working with new 11G-R2 release and all other releases 8i,9i,10g,11g
Involved in the installation of 10 g RAC on LINUX environment.
Experienced with SRVCTL, OCR and Voting Disk of 11g RAC. RAC Troubleshooting
Responsible for logical and physical database design, implementation, transforming logical data models into physical databases, and defining strategies for database implementation, high performance, streams & failover.
Maintenance and troubleshooting of oracle network files like listener, tnsnames.ora and sqlnet.ora.
Created tablespaces, tables, users for custom applications. Worked on Table Partitioning.
Created and managed database objects such as tables, indexes, partition tables and views.
Worked on Real Application Testing (RAT).
Creation of Materialized views and partitioned the oracle tables to improve reporting performance
Creating and dropping of Users, granting and revoking permissions to users/roles as and when required.
Created and managed users, roles, privileges, profiles, schemas using OEM.
Handling large database environments (Data warehouse) using Oracle Enterprise Manager (OEM) on daily basis observing the performance of the production database and constantly active regarding performance and space management issues and accordingly providing on-fly solutions to make database healthy and running.
Creating and rebuilding indexes and optimizing the code to improve the performance.
Worked on recovering of database in case of Media Failure, Block Corruption, missing data files and accidental tables dropped.
Backup and recovery procedures using RMAN.
Implemented backup/recover strategies using HOT backup, COLD backups RMAN and Export/Import utilities.
Wrote Shell Scripting for managing day-to-day activities and automation of backup.
SQL tuning and Database tuning has been done based on reports generated bySQL Trace, TKPROF Reports, STATSPACK, EXPLAIN PLAN Plans and monitor the database performance on daily basis.
Having stored outlines before and after Database tuning to stabilize and optimize the database by changing the parameters.
Experience ensuring the high availability and integrity of databases.
Worked on Automatic Storage Management (ASM) for managing data in SAN.
Wrote PL/SQL Procedures, functions, packages for various requirements in the database.
Environment:
HP -UX 11.23, Linux 4.0, Windows 2003, Streams, ASM, Business Objects Oracle 11g-R2,10g/9i,8i, SQL*Plus, OEM, TOAD
IBM Global Services/ AT&T – Naperville, IL Jan 2010 – Mar 2011
Oracle Database Administrator
Job Responsibilities:
Performed Oracle database administration duties to production and non-production databases
24x7 production support for several mission critical systems which utilize multiple Oracle databases.
Installed Oracle 10 and 11g, RAC database on Sun Solaris, Red Hat Linux.
System Study & Analysis, Design &Development.
Installed RAC on Oracle 10g and worked on ASM feature of Oracle
Upgrading databases to Oracle 10g from Oracle 9i.
Creating and maintaining the Oracle databases.
Created and managing the database objects such as tables, indexes and views.
Table Partitioning, creating Index Organized tables, Creating Locally managed Table spaces.
Setting up new environments and data refresh requests (Development, Production etc).
Database Sizing, Tablespace Management and Rollback Tablespace Management, Transaction Management and Security Administration
Created Users, Groups, Roles, Profiles and assigned users to groups and granted privileges and permissions to appropriate groups.
Manage users, privileges, profiles, schemas using Grid Control of Oracle Enterprise Manager (OEM)
Installed and Implemented Backup & Recovery procedures. Implement Hot and Logical backup plans.
Cloned schemas, objects and data on new server using exports from 10g database and imported in 11g using Oracle data pumps.
Perform Daily Monitoring of Oracle instances using Oracle Enterprise Manager / Grid Control to monitor users, tablespaces, memory structures, rollback segments, logs, and alerts.
Performed Data migrations from CSV/flat files using scripts and SQL Loader.
Worked with Enterprise Grid and Infrastructure support.
Developed automated scripts for database creation and builds.
Monitored database Performance using AWR, ADDM, SQL Tuning Advisor, SQL Analyze, TKPROF, STATSPACK and tuning parameters for optimization of system performance.
Supported Automatic Storage Management (ASM) database and performed migration of normal database to ASM database using RMAN.
Creating batch files and automating the tasks.
Granting roles and privileges to end users.
Scheduled various job using UNIXCrontab utility.
Worked on import/export and Datapump utility.
Configured and maintained Oracle Data Guard for Disaster Recovery environment using physical standby database.
Responsible for database Backups and Recovery, maintain 24 hours uptime for the database.
Environment:
Oracle 10g/11g RAC, SQL Loader, Windows 2008, Sun Solaris 10, FTP, putty, TOAD, PL/SQL
Dollar Thrifty Automotive Group - Tulsa, OK Apr 2008 - Dec 2009
Oracle Database Administrator
Job Responsibilities:
Monitoring System Resources, understanding and troubleshooting Database issues in Production Environment.
Organizing Oracle Database operations, installation, creation, configuration, laying out database tables and database schema design, startup and shutdown of Databases
Setting init.ora parameters, maintaining Data Files, Control Files, Redo Log Files, managing Tablespaces, segments, extents, indexes and managing Undo Data.
Carrying out EXPORT and IMPORT operations on Oracle Database, and monitoring the performance of the database using of OEM (Oracle Enterprise Manager).
Upgrading from Oracle 10g to Oracle 11g database
Install and configure Database as of Oracle’s Optimal Flexible Architecture (OFA).
Mentored and provided oversight and backup for the production Databases.
Supported Test Databases for testing and research work
Served as OracleDBA in a 24x7 Production environment managing several Database instances.
Used Flashback feature to recover a dropped table and also to recover a database.
Performed a proof-of-concept of Oracle10g and Oracle11g databases on single RAC Cluster 11g.
Involved in Capacity planning meetings & operations.
Automating the daily routine activities backups using the DBMS_JOBS, DBMS_SCHEDULER.
Monitoring of the queries with high response time and high disk reads per execution (Top SQL) and tuning the same using TKPROF, Auto trace.
Used Automatic Workload Repository (AWR) for analyzing the database performance.
Use TOAD to Optimize and test SQLs, PL-SQL statements developed by the Development Team.
Perform User Management, creation, monitoring and management of database users, altering passwords of users and granting and revoking system/object privileges, roles, auditing user actions in the database.
Implemented Change Control for the Production Databases as and when required.
Communicated with Oracle support via the Metalink in order to troubleshoot important issues.
Environment:
Oracle 10g and 11g, Sun Solaris 9, Windows 2008, Oracle Enterprise Manager – OEM (for monitoring the database), SQL Navigator.
Contact this candidate