Oracle Sql Server

Faheem Ahmed

******.****@*****.***

952-***-**** SREE INFOTECH LLC

SUMMARY:

Nine plus years of experience as Sr. Oracle Database Administrator providing 24x7production support as well as for Development databases (Oracle Exadata,12c/11g/10g/9i) primarily worked on UNIX/LINUX (Sun Solaris, HP-UX,AIX, RedHat)/Windows environments.

Experience in Oracle Database Administration activities such as Database Design, Database creation, Oracle Server Installations/Upgrades, Migrations, Patches, Cloning, Backup & Recovery, Performance Tuning, Multi-Node RAC, Goldengate, Apex (module) capacity planning, shell scripting, and documentation.

Extensive experience on database administration for Oracle 12c, 11gRAC, 10gRAC, 9i within very large scale database environment and mission critical OLTP and OLAP systems.

Installed and configured of Real Application Clusters (Oracle 11g RAC, 10g RAC), Standby Databases (DataGuard) for High Availability and Disaster Recovery.

Ugraded databases from Oracle 9i to 10g R2, 9i to 11gR2, 10R2 to 11gR2, 11gR2 to 12c.

Skilled in setting up/Installation and configuration of release 12c/11g/10g with ASM. Experienced in configuring & Managing the ASM.

Experienced with GoldenGate 12c/11g replication for Oracle databases.

Planned Goldengate setup to achieve unidirectional heterogeneous replication from SQL Server 2012R2 to Oracle 11.2.0.4 and also exposure to ELK stack

Configured GoldenGate 12c RAC for Active-Active Replication between the Datacenter for High Availability

Hands on experience on Oracle 12c/11g Active DataGuard/10g DataGuard with swithover, failover and Dataguard Broker

Experience in using Export, Import, DataPump, OEM Grid Control, SharePlex, Golden gate.

Skilled in Cross platform migrations from Windows to Linux, Solaris to Linux, Linux to AIX

Analyzing, Coding and Implementation of Oracle based applications.

Assisted in management and database administration of Oracle database applications on Exadata platforms.

Monitoring and management of various database components (logical & physical) like tablespaces.

Experience in using SQL, PL/SQL stored procedures, indexes, materialized views, shell scripting, partitioned and non-portioned tables, packages and triggers for improved performance of the database.

Delivering Oracle Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE, ADDM, ASH, AWR, ORADEBUG, 13c/12c/11g/10gOEM Grid Monitoring custom scripts troubleshooting oracle databases using SQL trace utilities.

Expertise in maintaining Database Roles, Users using Security Compliance Auditing, expertise in loading data from Flat Files using SQL*LOADER and External Table.

Skilled in MySQL, SQL Server Database Administration 2012/2008

Good experience in managing Very Large OLTP and Datawarehousing databases.

Involved in Data modeling, logical and physical database designs and worked as on-call support team member for administering OLTP 24X7 production databases.

Experience on Backup Methodologies (Making Backup Schedules depending upon Business Strategy: Daily Backup, weekly Backup etc.)

Database backup concepts and options such as user-managed backup, RMAN-managed backup with or without catalog, operating system backup, cold and hot backup, full backup, incremental and cumulative backup.

Scheduling jobs through Oracle Job Scheduler, cronjobs (Unix) and Schedule Tasks (Windows).

Experience on Recovering Databases (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption etc.).

Well conversant in translating business requirements into creation of database objects: tables, indexes, constraints, packages, stored procedures and functions using Oracle tools.

Awareness on Oracle Support processes for technical requests through Metalink

Excellent communication skills, strong analytical & logical abilities, problem solving skills and fast learning.

TECHNICAL SKILLS:

Operating Systems :Sun Solaris, Linux, HP-UX, IBM AIX, WIN 2000

Languages :C, C++, SQL, PL/SQL, UNIX Shell Scripting, PERL scripting.

Database/Applications/Tools :Oracle Exadata, ORACLE 9i/10g RAC/11g RAC,12c, SQL server 2005/2008, MySQL, Recovery Manager (RMAN), TSM,TDP, Exp/Imp, Data Pump, Data Guard, Oracle Data Integrator, STATSPACK, AWR,ADDM,ASM, SQL TRACE, EXPLAIN PLAN, TKPROF, AWS, SQL Developer, TOAD, DB Artisan, SQL*Loader, TOAD, OEM/GridControl, Erwin, Remedy, Maximo, Golden Gate.

Business Intelligence Tools :Informatica, Cognos

EDUCATION:

Bachelor of Engineering, Osmania Univeristy, India

PROFESSIONAL EXPERIENCE:

Client : Ericsson Inc, Bellevue, WA Nov ’15 – Till date

Role: Oracle Database Administrator III

Responsibilities:

24x7 Support to production databases and critical projects including participating in a weekly on call rotation.

Prerequisites, installation, configuration, migrations, upgrades, patches and administration of Oracle database 12c/11g on Linux VM machines and physical servers.

Installation, configuration, database creation and supporting of Oracle 12c /11g databases.

Installed CPU and one-off standalone patches & patch set update (PSU).

Involved in the implementation of High availability with Real Applications Clusters(RAC), Disaster Recovery solutions with Physical/Logical Standby Databases (DataGuard).

Working experience on upgrading and migration project, Upgraded databases from 11g to 12c.

Configured Dataguard using physical standby and active dataguard for high availability and reporting purpose and setup DG Broker configuration.

Supported annual DiRT (disaster recovery) exercise on multiple databases with a data center outage. And also supported database failover and switchover situations

Oracle Database and SQL tuning using SQL TRACE, STATSPACK, EXPLAIN PLAN, TKPROF, AWR, ADDM

Identify performance problems using wait event statistics. Monitor session-level wait events and collect historical data for root cause analysis. Supported the development team at offshore in issue fixing, migrations of code & other support activities.

Working experience on upgrading and migration project, Upgraded databases from 11g to 12c (11.2.0.4 to 12cR1/R2) on RHEL.

Setup and documented Oracle GoldenGate replication on 12c/11g for support team.

Planned Goldengate setup to achieve unidirectional heterogeneous replication from SQL Server 2012R2 to Oracle 11.2.0.4 and also exposure to ELK stack.

Configured GoldenGate 12c RAC for Active-Active Replication between the Datacenter for High Availability.

Resolved replication & lag issues in GoldenGate

Troubleshoot Repcat, Extract, Abend scenarios, data issues with developers and application teams.

Installed SQL Server 2012/2016 and created new database, setup backup and created mirror databases. Supported database switchover from principal to mirror database.

Worked extensively with data pump for expdp/impdp and RMAN duplication process for refreshes and creating standby databases.

Created new schemas, constraints, indexes, synonyms, and tablespaces. Created DB links, roles and users, assigning grants/roles, index rebuilding, recompiling invalid objects, helping the users with SQL queries, truncating partitions.

Scripted proactive & scheduled DBA related health analysis & monitoring including instance, index and log health, Maintenance(Partition tables, Materialized views refresh, Reorg, index), PDA alerts.

Resolving Oracle listener and TNS names problems

Monitored the growth of the database objects for capacity planning.

Database Administration and Planning including database design, backup & recovery.

Developing a backup and recovery strategy and performed backups and recoveries using RMAN.

Re-organizing, Partitioning tables by determining the suitable methodology to improve performance and manageability.

Developed PL/SQL functions, procedures, packages and triggers.

The daily work involves maintenance and administration of Oracle Databases, Backups, Lower environment refreshes (expdp/impdp & RMAN Duplicate), Space management, Stand-by lag monitoring, Performance Tuning, Dev/QA/Prod changes, other housekeeping tasks

Environment: Exadata, Oracle 12c,11g RAC,10g RAC,9i, SQL Server, RedHat Linux, Sun Solaris, HP-UX, IBM Aix, OEM/Grid Control, DataPump, RMAN, ASM, TOAD, SQL, PL/SQL, ERWIN, Oracle GoldenGate 12c/11g

Client : Express scripts inc, Bloomington, MN May ’13 – Nov ‘15

Role: IT – Oracle DBA (Senior)

Responsibilities:

24x7 Support to production databases and critical projects including participating in a weekly on call rotation.

Prerequisites, Installation, configuration, migrations, upgrades, patches and administration of Oracle database and GoldenGate 10gRAC/11gRAC/12c on AIX, Unix, Sun Solaris servers.

Installation, configuration, database creation and supporting of Oracle 10gRAC /11gRAC, 12c databases.

Involved in the implementation of High availability with Real Applications Clusters (Oracle 11g RAC/10g RAC), Disaster Recovery solutions with Physical/Logical Standby Databases (DataGuard).

Installed CPU and One-off standalone patches & patch set Upgrade (PSU).

Involved in setting up replication solution with GoldenGate in Dev, Test and Production environments and configured GoldenGate Processes on Source, Target and Middleware environments.

Configured and build Golden Gate Extracts/replicats for multiple databases following best practices.

Resolved replication & lag issues in GoldenGate

Perform POC for testing DDL and DML replication across Databases using Goldengate 11g/12c.

Troubleshoot Repcat, Extract, Abend scenarios, data issues with developers and application teams.

Oracle Database and SQL tuning using SQL TRACE, STATSPACK, EXPLAIN PLAN, TKPROF, AWR, ADDM

Identify performance problems using wait event statistics. Monitor session-level wait events and collect historical data for root cause analysis Supported the development team at offshore in issue fixing, migrations of code & other support activities.

Experience in Ugrading and migrating Oracle databases from 10g to 11g, 11g to 12c.

Supported MySql databases, created backup and supported database recovery. Locking/unlocking tables and dropping triggers for migration, supported migration and improved the performance of the oracle databases after migration.

Involved in discussions with different application teams during the deployments and enhancing the performance. Finding long running transactions and recycling the processes causing the issue.

Scripted proactive & scheduled DBA related health analysis & monitoring including instance, index and log health, Maintenance ( Partition tables, Materialized views refresh, Reorg, index), PDA alerts.

Capturing the database statistics and metrics for proactive database management

Cloning of production database to the test environment using Recovery Manager (RMAN).

Monitored the growth of the database objects for capacity planning.

Database Administration and Planning including database design, backup & recovery.

Developing a backup and recovery strategy and performed backups and recoveries using RMAN.

Set up database security, auditing, creating users, roles, TDE, Database Vault, ASO, granting quotas, re-organize databases.

Re-organizing, Partitioning tables by determining the suitable methodology to improve performance and manageability.

Implemented data replication through materialized views, GoldenGate.

Capacity planning and bench marking

Created new schemas, constraints, indexes, synonyms, and tablespaces. Created DB links, roles and users, assigning grants/roles, index rebuilding, recompiling invalid objects, helping the users with SQL queries, truncating partitions.

Used puppet paltform to automate some of the DBA tasks like schema refreshes, switchovers/failovers, creating restore points, database start/stop, creating awr reports, user account unlock.

Participated in Disaster Recovery Drills, documented database and application validation steps

Developed PL/SQL functions, procedures, packages and triggers.

Environment: Oracle 12c,11g RAC,10g RAC,9i, MySql, RedHat Linux, Sun Solaris, HP-UX, IBM Aix, OEM/Grid Control, DataPump, RMAN, ASM, TOAD, DB Artisan, SQL, PL/SQL, ERWIN, Golden Gate

Client : Thomson Reuters, Hyderabad,India/Eagan,MN Jan ’07 – May ‘13

Role: Oracle Database Administrator

Responsibilities:

24 X 7 Production Oracle database support and administration

Installed, configured and maintained Oracle 9i/10gRAC/11gRAC databases.

Evaluating, Supervise, plan, Installing Database servers, Database software, upgrading to new versions, co-coordinating with hardware changes and applying oracle database patches

Involved in the implementation of High availability with Real Applications Clusters (Oracle 11g RAC, 10g RAC), Disaster Recovery solutions with Standby Databases (DataGuard).

Standby Database (Data Guard) setup and configuration.

Installed, configured and administered Oracle Clusterware, Automatic Storage Management (ASM) and created ASM Disk Groups and created Oracle 10g RAC/11g RAC DB’s

Performed various tasks like Administering RAC using SRVCTL, Adding nodes and instances, administering Storage Components, Parameter Management, and Configuring High Availability Features for RAC.

Oracle Database and SQL tuning using SQL TRACE, STATSPACK, EXPLAIN PLAN, TKPROF, AWR, ADDM

Identify performance problems using wait event statistics. Monitor session-level wait events and collect historical data for root cause analysis.

Worked extensively on RMAN, Used RMAN for Point in Time Recovery and for Full DB refreshes and schema level refreshes.

Worked extensively with DATA PUMP for expdp/impdp.

Supported the development team at offshore in issue fixing, code migrations & other support activities.

Installed and configured SQL server 2008 and SQL server 2012 on WINDOWS 2008 systems.

Migrated and upgraded SQL Server 2000 to SQL Server 2005

Provided DBA support and technical expertise for multiple applications in development, test, QA and production - SQL Server 2005, 2008, and 2012 environments.

Ugraded databases from Oracle 8i to 9i, 9i to 10g, 10g to 11g

Scripted proactive & scheduled DBA related health analysis & monitoring including instance, index and log health, Maintenance ( Partition tables, Materialized views refresh, Reorg, index), PDA alerts.

Capturing the database statistics and metrics for proactive database management

Cloning of production database to the test environment using Recovery Manager (RMAN).

Resolving Oracle listener and TNS names problems

Installed, configured, upgraded Oracle GoldenGate, troubleshooting GG issues.

Implemented data replication through materialized views, GoldenGate.

Monitored the growth of the database objects for capacity planning.

Database Administration and Planning including database design, backup & recovery.

Developing a backup and recovery strategy and performed backups and recoveries.

Re-organizing, Partitioning tables by determining the suitable methodology to improve performance and manageability.

Responsible for setting and managing user accounts, granting required privileges to users

Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption).

Used power designer, E/R Studio for data modeling and to estimate the database size, database design reviews.

Loading data from flat files into Oracle Database using SQL*Loader, External Tables and automated the process by using UNIX Shell scripting.

Writing Shell Scripts for managing day-to-day activities and automation of backup.

Developed PL/SQL functions, procedures, packages and triggers.

Environment: Oracle 11g RAC,10g RAC,9i, SQL Server 2000/05/08/12, RedHat Linux, Sun Solaris, HP-UX, IBM Aix, Grid Control, DataPump, RMAN, ASM, TOAD, SQL, PL/SQL, SQL*Loader, ERWIN, Golden Gate

Contact this candidate