SAADATH AFZAL

773-***-****

aczkmy@r.postjobfree.com

QUALIFICATIONS

Technical Skills: Oracle 10g/11g/12c, SQL Server 2008/2012, Sun Solaris 10, Red Hat Linux RHEL 6.x, 5.11, Windows, PL/SQL, SQL, Shell Scripting

Utilities and Tools: SSMS, OEM/Grid Control, SQL Trace, SQL Developer, Putty, Data Guard, RMAN, SQL*PLUS, IMP, Data Pump

EXPERIENCE

Frontier Communications

Database Administrator

Fort Wayne, IN

August 2015 – Present

● Supported 24/7 on-call pager support for mission critical financial databases

● Performing day-to-day database administration tasks including tablespace usage, monitoring alert log, trace files, monitoring disk usage, analyzing and modifying tables/indexes to enhance performance, database backup logs etc.

● Responsible for applying all Oracle security patches, security patches via Metalink, CPU patches, and release patches on all Oracle 11g RAC databases

● Creation of database objects like Tables, Indexes, Views, Users, and DB Links etc. on a regular basis for Application schemas

● Data Refresh from Production to Test and Development environments using RMAN Duplicate Database and Data Pump

● Oracle Database performance tuning and SQL tuning using SQL Trace, AWR, ADDM, and Explain Plan

● Management of table space growth, monitoring data file additions, as well as extent growth

● Creating and configuring new test databases for production and development Environment

• SQL Server 2008/2012, Oracle 9i/10g/11g databases, RHEL, Data Guard, 10g/11g RAC, Data Pump, Import/Export, SQL*Loader, RMAN, Grid Control, AIX, RHEL, Windows Server Alliant Credit Union

Database Administrator

Chicago, IL

2013 - 2015

● Responsible for administering and supporting production and development Oracle databases

● Responsible for installing, upgrading and configuring the Oracle server, creating databases, storage structures and objects, database backup and recovery, monitoring and optimizing database performance

● Refreshing development/test database from production using Data Pump

● Designed backup and recovery procedures for OLTP system

● Responsible for optimizing the queries and application tuning

● Assisted team with data center migration from 10g to 11g

● Enrolling users and maintaining system security

Environment

● Oracle 9i/10g/11g databases, (Active) Data Guard, 10g/11g RAC, Data Pump, Import/Export, SQL*Loader, RMAN, Grid Control

Ascendeon Group

Junior Database Administrator

Downers Grove, IL

2012 - 2013

● Writing complex SQL statements using joins, sub queries, correlated sub queries, Dynamic SQL, CTE, Table Variables, UDF's

● Created, edited, exported and imported Oracle Database using SQL statement in Oracle SQL developer

● Backing up and restoring the database

EDUCATION

Benedictine University

Masters in Information Systems – Business Intelligence Benedictine University

Bachelor of Science in Biology

Lisle, IL

June 2018

Lisle, IL

May 2012

Contact this candidate