ANJOY BARUA

Springfield, VA 703-***-**** ac9nwr@r.postjobfree.com

Clearance: Secret (active)

OBJECTIVE

Proactive and result oriented IT professional with over 8 years of Database Administration (DBA) experience providing support in Oracle 10g, 11g, and 12c databases on Linux, Unix, and Windows. Also experienced supporting Microsoft SQL Server 2008/2012 on Windows Server 2012. Knowledgeable in performing backup and recovery measures, migrations, upgrades, security measures, and performance tuning. Supported test, development, and production environments. Military Veteran with superior communication, documentation, and problem-solving skills. Currently working towards Security+CE and Oracle Certified Associate (OCA) certifications. Active Secret clearance.

SKILLS & ABILITIES

Oracle Database 10g, 11g, 12

Linux, Unix, Windows

Microsoft SQL Server 2008/2012

Backup and recovery (RMAN)

Patching, installation, upgrades

Security (TDE)

Performance Tuning (explain plan, AWR)

SQL Plus, SQL Developer, Toad, OEM

EXPERIENCE

Oracle Database Administrator, US Department of State Jan 2012 – Present

Arlington, VA

–Maintenance and monitoring of Oracle 11g and 12c databases.

–Backup and recovery of SQL Server 2008/2012 databases.

–Conduct database refreshes to provide testing team with test data.

–Perform backup and recovery measures of Oracle databases using RMAN.

–Monitor and facilitate practices for security of data in information systems.

–Load and execute automated batch jobs using Control-M (Automated job scheduler).

–Perform data migrations using Data Pump.

–Performance tuning of Oracle databases using SQL Tuning Advisor, SQL Access Advisor,

–Management of schemas, objects & partitioning the tables & indexes.

–Configure Transparent Data Encryption (TDE) for SQL and Oracle databases.

–Clone production databases as needed for testing and development.

–Assist users such as developers and QA testers with database related issues.

–Provide documentation such as SOPs and install guides.

–Conduct troubleshooting exercises to identify critical issues related to the database.

–Provide status reports to management and provide recommendations for best practices related to database management.

Database Analyst, Computer Sciences Corporation May 2011 – Jan 2012

Washington, DC

–Provided database administration and support for Oracle 10g and 11g installations.

–Performed database creation, database security, database optimization and tuning.

–Worked with developers, systems administrators and other groups to ensure operability of development, test, and production environments.

–Performed backup and recovery using RMAN.

–Supported Oracle databases on Linux and Windows Operating Systems.

–Maintained access permissions and privileges for database objects.

–Provided troubleshooting and support for all database related issues.

–Performed query analysis and interpretation.

–Used Data Pump and export/import utilities for logical backups and performed database cloning using RMAN.

–Slow running queries analysis.

–Upgraded Oracle 10g database to 11g; upgraded Oracle 11g databases from 11.2.0.1 to 11.2.0.4 using patch set.

–Performed bulk load into the database using SQL Loader.

–Administered database user accounts.

–Managed database permissions and setup database roles and enable database auditing for database security.

EDUCATION

Southern New Hampshire University – BS Information Technology 2019

CERTIFICATIONS

–Currently working towards Security+CE

–Currently working towards Oracle Certified Associate (OCA)

AWARDS

–Navy & Marine Corps Achievement Medal

–Battle Efficiency Award

–National Defense Medal

–Good Conduct Medal

Contact this candidate