Yesmeen Sultana

US Citizen Active Public Trust Able to obtain any clearance

adgxi5@r.postjobfree.com C: 703-***-**** Fairfax, VA 22032 Profile: IT professional experienced with eight-plus years of database administration for large corporations. Able to apply appropriate security, practical technology, or a mix of technologies that meet business needs while minimizing risks. Track record of delivering optimal results in high-growth environments through initiatives that exceed operational performance targets and transforms requirements into workable solutions.

• Providing DBA support to multiple Cluster and non-Cluster databases in Production, Development Servers in

"LINUX" and "WINDOWS" environment.

• Monitoring and managing day-to-day operations, maintaining Table spaces and CRD files. Monitor Server Activity, Error Log, space usage, and solving problem as needed

• Strong knowledge on Recovery of the database in case of failures (loss of Control file, loss of Data file(s), loss or crash of Tablespace(s), etc.)

• Creating Tablespaces and data files according to our requirements. Understanding of indexing, portioning, materialized views

• Migrating and deploying their enterprise applications on the AWS cloud.

• Experienced in the Creation of users, grant privileges.

• Experienced in enabling no archive log to archive log mode.

• Design and implemented an RMAN backup strategy.

• Having experience in database cloning.

• Experienced in Backup activities using Export/Import utilities.

• Having experience in administration DB with OEM

• Knowledge of Oracle Golden gate.

• Experienced in Taking incremental HOT Backups daily base and cold backup as needed.

• Experience in data loading from flat files to oracle tables using SQL Skills

• Experience in Oracle Advanced Security 12c data

Encryption and redaction.

• ASM

• Backup and Recovery

• Disaster recovery

• Linux and Unix

• Data Guard

• Upgrades and Patch

• MS SQL

• Database Administrator

• Red hat

• IIS Server

• Hewlett-Packard

• Oracle database performance Tuning

• Knowledge of RDBMS series of packages

• Oracle Enterprise User Security (EUS)

• Experience with OEM Cloud Control 12c/13c/18c

• AWS

• Migration

• Logistics/Managing

• MySQL

• Oracle database

• Scheduling

• Monitoring and tuning

• Agile methodology

• Project management

• Utilities

• Upgrades

• Windows and Linux server Admin.

• Windows Server 2012, 2008 R2, 2003 R2, 2000

• SQL server 2014, 2012, 2008 R2, 2005, 2000

• Installing and configuration oracle

• 3rd party backup tools like Tivoli Data Protection

• Familiarity with Oracle Net

Experience

US Financial Project Fairfax,

VA

Oracle DBA

07/2016 – Current

Responsibilities:

I am passionate about technology and dedicated to producing high-quality results. My duties include executing daily database administration tasks and collaborate with our partners from the IT security, infrastructure team, application developers, and project managers to achieve project milestones at the US Department of Labor.

• Administration of ASM Instances and ASM Disk groups.

• Knowledge of Oracle Enterprise User Security (EUS), Oracle SQL Loader, Oracle Database Pump (Export/Import), Oracle Trace File Analyzer (TFA),

• Experience with OEM Cloud Control 12c/13c, 18c, Alert/Event Monitoring and Configuration, Database, and Patch Provisioning.

• Patched and upgraded from lower version to higher version like 10.2.0.2 to 10.2.0.4, 11.2.0.6 to 12.1.0.2 environment.

• Created high availability services and tested for failover.

• Configured physical standby database for high availability and disaster recovery and tested for switchover and failover.

• Managing oracle RAC and non-RAC environment.

• Knowledge of 12c, 13c, and 18c environment.

• Worked on User management, security, privilege, role, and profile.

• Installed and configured 2 node RAC using raw partitions and ASM.

• Experienced in Analyzing and SQL Queries for excessive CPU usage, high disk reads/writes, and execution plans by using TKPROF EXPLAIN PLAN.

• Taking AWR, ADDM report for performance tuning.

• Implement agile management ideals by facilitating exercises such as sprint planning and team-leading standups.

• Manage project timelines and communicate with management staff and clients to ensure project progress satisfactorily. Department of Labor. Washington, DC.

Oracle DBA

03/2014 - 07/2016

Responsibilities:

Multi-functional role: Create new database, administer Oracle databases, help developers with SQL programming, administer Windows and Linux servers, create technical docs, system integration and upgrade, administer a portfolio of commercial off-the-shelf products and provide support to the end users. Work with the IT security department during the annual FISMA reviews.

• Created and built Oracle 11g,12c and 18c Databases.

• Implemented and maintaining oracle11g and 12c databases.

• Patched and upgraded 11.2.0.6 environment to 12.1.0.2 environment for all PROD and Non-Prod systems.

• Created high availability services and tested for failover.

• Managing backup and recovery of databases.

• Monitoring, Scheduling, planning backup & recovery strategy using hot, cold and RMAN.

• Tablespace management, User management, Roles, and privileges management.

• Installed and configured 2 node RAC.

• Implemented ASM as a storage option for the RAC database.

• Administered ASM instance by using SQL.

• ASMCMD command line.

• Analyzing SQL Queries for excessive CPU usage, high disk reads/writes, and execution plans by using ANALYZE, TKPROF, and EXPLAIN PLAN.

• Migrated flat files from different sources into Oracle Database using SQL Loader.

• Migrating the data between production and the development database using Oracle utility traditional export/import.

• Cloning databases through Data pump Exp/Imp, RMAN.

• Generating the database health check reports using Stats pack, AWR, and ADDM.

• Provide 24/7 support for the production environment.

• User management, privilege, role, and profile.

• Managed security by defining roles and rights.

• Expertise in database Performance tuning.

• Platforms Linux RDBMS 9i,11g,12c and 18c.

Ingram Micro Inc, Irvine, CA

Oracle DBA

01/2012 - 03/2014

Responsibilities:

Ingram Micro Inc. Is a fortune 100 company, is the word’s largest wholesale technology distributor and global leader in IT supply-chain, mobile device lifecycle services and logistics solutions. I was responsible for database administration: manage users, create and restore backups, database upgrade, create new tables, analyze logs, and resolve issues as needed.

• Creating users, granting privileges /roles, user account unlock and password reset for users.

• Created Physical standby DB in the RAC environment.

• Working on issues on Data guard like resolving the Archive log gap on Primary & Standby DBA.

• Switching over to Standby to Primary when required.

• Performing Schema level/Full DB Refresh using Exp /Imp and Data pump.

• Solving Backup failure issues that use Export and RMAN methods.

• Performance tuning, Monitor Server Activity, Error Log, space usage, and solving problems as needed. Solving Performance-related issues Expertise in database.

• Migration of Oracle database from Non-ASM to ASM.

• Monitoring the ASM Disk groups and Disks.

• Generating AWR & ADDM Reports and analyzing the same.

• Generating Explain Plan and analyzing the same.

• Identifying Locks at DB level/Object Level and killing the same.

• Identifying Table Fragmentation.

• Rebuilding the Indexes whenever necessary.

• Installation of Oracle software on Linux environment.

• Changing Parameter values as required at Database Level.

• Solving Performance-related issues Expertise in database.

• Performance tuning, Monitor Server Activity, Error Log, space usage, and solving problems as needed.

Education and Training

George Mason University Fairfax, VA

• Bachelor’s Degree in Accounting and Business Administration Northern Virginia Community College Fairfax, VA

• Associate Degree in Business Administration and Social Science Microsoft Certified IT Professional

• MCITP (Microsoft Certified IT Professional) – SQL Server 2008: (70-432 and 70-450)

• SY0-501 - CompTIA Security+ Certification

• Oracle Database 12c Administration -1Z0-062

Contact this candidate